How to Use Data to Tell Compelling Stories and Win New Deals - Build What's Next
Blog

How to Use Data to Tell Compelling Stories and Win New Deals

4509

Of your peers have already read this article.

2:30 Minutes

The most insightful time you'll spend today!

Understanding how to visualize a story can be difficult if you’re left staring at numbers sitting stagnant in rows or columns within a spreadsheet. Here's how to make numbers work for you.

A picture is worth a thousand words–especially at work. The data we present every day is what helps us drive decision-making in the workplace. But understanding how to visualize a story can be difficult if you’re left staring at numbers sitting stagnant in rows or columns within a spreadsheet. 

This is where visualization with charts and reports becomes critical. Let’s say your team needs to understand global sales trends. If you have a waterfall chart that shows regional contribution to total revenue or a scatter plot that shows individual salesperson performance, it’s much easier to spot patterns, draw insights, and make informed recommendations. The same goes for analyzing travel expenses.

In Google Sheets, we have several built-in tools that make it easy to create and share useful charts and reports so that you can quickly visualize data (without having to leave the spreadsheet). Follow these tips to showcase your data in Sheets and influence decisions.

1. Pick the most compelling way to visualize your data.
Perhaps just as important as the data you reference is the way in which you present it. Charts are the basic building blocks for data visualization and can take many forms–from bar charts to line graphs to scatter plots. There are more than 30 chart types to choose from in Sheets, and we’re constantly adding more ways to express your data. Here are a few we recommend:

  • To draw attention to a key metric or KPI, try the brand new scorecard chart. For example, you can show the total sales number for your organization’s top-selling product, and even call out percentage increase or decrease over time. 
  • To illustrate how values add to or subtract from a starting value, try a waterfall chart. For example, show how your product sales and restocking efforts led to a net decrease in inventory from last quarter to this quarter.
  • To represent different data series using lines and bars, try a combo chart. For example, you can show revenue in bars and profit margins in a line across the same chart, giving you a more complete picture of your organization’s financial health.

If you’re unsure how to best present your data, Google’s built-in machine learning can help you choose the right visualization—Sheets intelligently suggests charts for you. Simply highlight data you would like to visualize, click the chart button, and then select one of the suggested charts. According to our internal data, more than 1.5 million charts are inserted into Sheets each week based on intelligent recommendations.

Note: Once you have a chart inserted into Sheets, you may want to control the look and feel. We recently made it possible to click directly on data labels, chart titles, or legends and drag to reposition them. You can also easily delete these elements using the delete or backspace keys, if you want to make other data points stand out. We’re exploring even more ways to customize charts—stay tuned.

2. Be sure to tell a complete story. 
Data really comes to life when you put several charts and tables together into a report or dashboard. Going back to our sales data example, an individual line graph showing revenue over time gives you quick insight into the general sales trend for your organization (hopefully, up and to the right!). But when you surround that line graph with other charts and tables–like a pie chart showing total revenue breakdown by-product, or a stacked bar chart comparing revenue driven by each sales team–you can tell a more complete story. 

If you do build reports featuring multiple charts, there are ways that Sheets can help you organize and format them more quickly. Earlier this year, we made it easier to align, size, and position objects within your spreadsheets so you can quickly put several charts together. We also recently added themes, which let you alter the look and feel of an entire spreadsheet—including charts, pivot tables, and cells—to ensure a consistent look and feel across the elements in your report. To apply a preset theme, select Format > Theme and choose the right option. Faster formatting can mean faster reporting.

Blog

Accelerate Developer Productivity with Google Workspace

5775

Of your peers have already read this article.

3:30 Minutes

The most insightful time you'll spend today!

Google Workspace integrates DevOps tools, enabling developers to centralize work, build codes faster & deliver quality products. We are constantly expanding the Google Workspace giving you the power to push towards better software development.

The software development process requires complex, cross-functional collaboration while continuously improving products and services. Our customers who build software say that they value Google Workspace for its ability to drive innovation and collaboration throughout the entire software development life cycle. Developers can hold standups and scrums in Google Chat, Meet, and Spaces, create and collaborate on requirements documentation in Google Docs and Sheets, build team presentations in Google Slides, and manage their focus time and availability with Google Calendar.

Development teams also use many other tools to get work done, like tracking issues and tasks in Atlassian’s Jira, managing workloads with Asana, and incident management in PagerDuty. One of the benefits of Google Workspace is that it’s an open platform tailored to improve the performance of your tools by seamlessly integrating them together. We’re constantly expanding our ecosystem and improving Google Workspace, giving you the power to push your software development even further.

Make software development more agile


Google Workspace gives you real-time visibility into project progress and decisions to help you ship quality code fast and stay connected with your stakeholders, all without switching tools and tabs. By leveraging applications from our partners, you can pull valuable information out of silos, making collaborating on requirements, code reviews, bug triage, deployment updates, and monitoring operations easy for the whole team. This allows your teams to stay focused on their priorities while keeping everyone aligned, ensuring collaborators are always in the loop.

Plan and execute together


When combined with integrations, Google Workspace makes the software development planning process more collaborative and efficient. For example, many organizations use Asana—a leading work management platform—to coordinate and manage everything from daily tasks to cross-functional strategic initiatives. To make the experience more seamless, Asana built integrations so users can always have access to their tasks and projects with Google Drive, Gmail, and Chat. With these integrations for Google Workspace, you can turn your conversations into action and create new tasks in Asana—all without leaving Google Workspace.

“We’ve seen exceptional, heavy adoption of tasks being created from within the Gmail add-on. Our customers and community have also shown very strong interest in future development work, which is something we’ll continue to prioritize.” Strand Sylvester, Product Manager, Asana

To date, users have installed the Asana for Gmail add-on over 2.5 million times, as well as over 3.8 million installs of the Asana for Google Workspace add-on for Google Drive.

Turn your conversations into action with the Asana for Google Chat app.

Start coding quickly


Google Workspace makes it easy for product managers, UX designers, and engineers to agree on what they’re building and why. By bringing all stakeholders, decisions, and requirements into one place—whether it’s a Gmail or Google Chat conversation, or a document in Google Docs, Sheets, or Slides—Google Workspace removes friction, helping your teams finalize product specifications and get started right away.

Integrations like GitHub for Google Chat make the entire development process fit easily into a developer’s workflow. With this integration, teams can quickly push new commits, make pull requests, do code reviews, and provide real-time feedback that improves the quality of their code—all from Google Chat.

Get updates on GitHub without leaving the conversation


Speed up testing


Integrations like Jira for Google Chat accelerate the entire QA process in the development workflow. The app acts as a team member in the conversation, sending new issues and contextual updates as they are reported to improve the quality of your code and keep everyone informed on your Jira projects.

Quickly create a new Jira issue without ever leaving Google Chat


Ship code faster


Developers use Jenkins—a popular open-source continuous integration and continuous delivery tool—to build and test products continuously. Along with other cloud-native tools, Jenkins supports strong DevOps practices by letting you continuously integrate changes into the software build.

With Jenkins for Google Chat, development and operations teams can connect into their Jenkins pipeline and stay up to date by receiving software build notifications directly in Google Chat.

Jenkins for Google Chat helps DevOps teams stay up to date with build notifications.


Proactively monitor your services


Improving the customer experience requires capturing and monitoring data sources to improve application and infrastructure observability. Google Workspace supports DevOps teams and organizations by helping stakeholders collaborate and troubleshoot more effectively. When you integrate Datadog with Google Chat, monitoring data becomes part of your team’s discussion, and you can efficiently collaborate to resolve issues as soon as they arise.

The integration makes it easy to start a discussion with all the relevant teams by sharing a snapshot of a graph in any of your Chat spaces. When an alert notification is triggered, it allows you to notify each Chat space independently, precisely targeting your communication to the right teams.

Collaborate, share, and track performance with Datadog for Google Chat.


Improve service reliability


Orchestrating business-wide responses to interruptions is a cross-functional effort. When revenue and brand reputation depends on customer satisfaction, it’s important to proactively manage service-impacting events. Google Workspace supports response teams by ensuring that urgent alerts reach the right people by providing teams with a central space to discover incidents, find the root cause, and resolve them quickly.

PagerDuty for Google Chat empowers developers, DevOps, IT operations, and business leaders to prevent and resolve business-impacting incidents for an exceptional customer experience—all from Google Chat. See and share details with link previews, and perform actions by creating or updating incidents. By keeping all conversations in a central space, new responders can get up to speed and solve issues faster without interrupting others.

PagerDuty for Google Chat keeps the business up to date on service-impacting incidents.


Accelerate developer productivity


Integrating your DevOps tools with Google Workspace allows your development teams to centralize their work, stay focused on what’s important—like managing their work—build code quickly, ship quality products, and communicate better during service impacting incidents. For more apps and solutions that help centralize your work so you and your teams can connect, create, and get things done, check out Google Workspace Marketplace, where you’ll find more than 5,300 public applications that integrate directly into Google Workspace.

Blog

Celebrating Google Cloud and State of Wyoming’s Decade of Partnership!

4049

Of your peers have already read this article.

2:00 Minutes

The most insightful time you'll spend today!

About a decade ago, State of Wyoming incurred savings worth a million by transitioning to Google Workspace. In this blog, we have marked 10 important milestones achieved with this partnership and new opportunities created for the state government.

When Wyoming became the first state to transition all its employees to Google Workspace ten years ago, everyone expected a million dollars in cost savings. What started as a move to save money and ease communication has turned into much more. While the cost savings continues to be significant, state efficiency skyrocketed, allowing employees to spend more time working directly with the community.

This year, we’re celebrating 10 of the most important lessons learned over ten years in our Wyoming-Google partnership.

1. Collaborative tools breed a collaborative culture. Wyoming was prepared when the COVID-19 pandemic hit, forcing our workers to transition to at-home environments. Employees across the state were already using Google Workspace collaboration and productivity tools, which made the switch easy. We also had already set a precedent by hosting a key budget meeting over Google Meet from outside the country. Using Google Meet in such a high visibility meeting showed state employees that every level of government could benefit from digital collaboration. This culture was made possible by Google Workspace tools.

2. Digital tools can connect the community with essential services. That same collaborative spirit helped our government employees better connect with our community throughout the pandemic, delivering key information for food assistance, as an example. One in five children in Wyoming suffer from food insecurity. Google Workspace allows programs like the Wyoming Hunger Initiative to run smoothly, as everything from scheduling and planning events, to tracking and research, is handled with Google Workspace. The data gathered and stored in Google Cloud is protected and helps to bring meals to the kids who need them most.

3. Easy-to-use apps make transitions simpler. Google Workspace apps have been a breeze to learn from day one. They are designed to be intuitive and state employees are able to get the hang of the software simply by trying it themselves. We also developed a training series for new users to further ease the transition. Training is offered every six weeks so users can take the training when they are onboarded or at any time they need a refresher.As I started my career with the State of Wyoming, Wyoming began its journey as the first state to go Google – forever changing how and where we work. This was especially evident as we worked through our emergency telework at the height of the pandemic. Whether meeting with stakeholders around the capitol complex, across the state or teleworking from home, Google ensures our teams are always connected and collaborating.-Tim Sheehan
Interim CIO & Information Services Administrator, Dept. of Enterprise Technology Services

4. Invest in students, invest in the future. How do you enable students to retain access to their work and emails as they transition from elementary to middle and high school? Wyoming developed “Wyo for Life ,” which established a state email domain across all our school districts. Students get an email address with unlimited data that they can keep forever. This makes the transition for students seamless, and their digital portfolio is theirs for life.

5. Switching to Google Cloud saved millions on technology costs. The cost savings from moving to Google have taken many forms over the years. Google Cloud’s migration tools made it easy to move various systems to a single centralized platform, consolidating IT resources—and saving money—across the state. In the past 10 years, the cost of Google Workspace within the Department of Transportation has increased by only 7%, a third of the inflation rate over the same period. Our state also switched from a $1.5 million legacy video conferencing system to Google Chromeboxes in 2015—at a fraction of the cost. When combined with the savings over each year, the switch has saved taxpayers a compelling amount of money. This allows our state to keep innovating and adapting without putting pressure on taxpayers.

6. Security is both simpler and stronger. In the last decade, Wyoming has become the state with one of the best security records in the country. We have consistently ranked in the top five most secure states, year after year, with the help of Google Cloud. Other states have found it difficult to keep constituent data secure, and major breaches have left communities across the country floundering. By partnering with Google, we have ensured constituent data is constantly secure.

7. Flexibility is crucial for governments that want to grow. Focusing on flexibility, the State of Wyoming has been able to look at the needs of our employees and community and change the way we apply technology to our constituent services with Google Workspace. As those needs have changed, we have been able to shift our focus and better serve constituents without having to spend time rebuilding internal systems.

8. Working together has led to stronger, more cost-effective solutions over time. Our state has access to Google Cloud experts, and that relationship has allowed real flexibility. For example, Google Meet and its predecessor Google Hangouts, weren’t available at the beginning of our partnership. When it became clear that those tools could serve the Department of Corrections, we worked with Google Cloud to ensure the tool was added to our Google Workspace portfolio.

9. Workspace apps are always improving. Google Cloud is constantly evolving, upgrading, and improving their products to serve their users better. The hundreds of product updates they’ve put out over the years have benefited us as a long-term customer, and Google Workspace for Government ensures the complex problem of running an efficient public office has real solutions.

10. Community is key, even outside of Wyoming. The State of Wyoming is part of a larger community of public sector workers using Google called Public Sector Connect. All public sector employees can connect with others, join discussions, and get inspired by how Google tools are changing government and education. All community members hold positions in government or education, and new ideas are being shared every day. This community is at the forefront of public sector innovation. We meet with Google engineers and suggest solutions, feature set requests, and learn from others about problem-solving, innovation and implementation. This is the space that has been lacking in the public sector for years and if you are in the public sector, please join!

Using Google has allowed the State of Wyoming government to focus on our future roadmap. Over the last 10 years, instead of retrofitting our ideas into legacy technology or developing applications as we go, Google Workspace and Google Cloud contained all of the tools to achieve our milestones seamlessly. Google Workspace contains all of the applications our end users need for working remotely, in-person, or hybrid. The harmony between Google Workspace and Google Cloud opens new opportunities for our government, to include data analytics, big queries, and the use of artificial intelligence. Our enterprise processes have modernized thanks to the innovative solutions and support by Google. 

Now 10 years later, we are proud of the partnership we have built with Google Cloud and are looking forward to the next 10 years using Google to support our community.

E-book

Five Reasons Your Business Should Move to AI-Enabled, Smarter, Spreadsheets

DOWNLOAD E-BOOK

6311

Of your peers have already downloaded this article

4:04 Minutes

The most insightful time you'll spend today!

When it comes to data analysis, it’s easy to fall into routine. But no matter how much of a whiz you are at formulas or pivot tables, superb spreadsheet skills only take you so far if you’re working with multiple versions or outdated datasets.

On average, your employees spend up to eight hours each week—an entire work day—searching for and consolidating information.

What if businesses spent their time applying data insights instead of tracking them down?

Working in the cloud means your data can easily stay up to date because information is automatically saved as it’s typed. Multiple team members can collaborate in real-time from their phone, tablet or computer (online and offline) and create a single source of truth for projects, like quarterly budgets.

Powered by Google’s machine intelligence, Sheets does a lot of the heavy lifting for you when it comes to data analysis. You can ask a question about your data and Sheets will return an answer using natural language processing. Sheets also builds chartssuggests formulas and creates pivot tables for you.

4088

Of your peers have already watched this video.

1:00 Minutes

The most insightful time you'll spend today!

Blog

Say Hello to Google Workspace

Make way for Google Workspace to connect, create, and collaborate with your team and organization. Watch the video to explore how you can achieve more with Google Workspace and how it can transform the future of workplace!

4212

Of your peers have already watched this video.

18:40 Minutes

The most insightful time you'll spend today!

How-to

Enabling a Remote Workforce with Chrome Enterprise

The recent COVID-19 pandemic has mandated that organizations take unprecedented efforts to enable their employees to work remotely. This recent Gartner survey indicated that 88% of organizations have encouraged or required employees to work from home.

Even before this year’s events, remote working has been a growing consideration for employees and employers alike. In fact, since 2005, working from home has grown by 173% amongst the non-self-employed population. And the desire to work remotely continues to increase.

As more businesses consider how to enable their teams to work remotely, business and IT leaders are increasingly thinking about how to best support a distributed workforce.

In this video, learn how Chrome Enterprise can help keep your employees productive and data secure while allowing IT to remotely manage devices and find out how other companies are doing it too.

More Relevant Stories for Your Company

Trend Analysis

2022’s First Cloud CISO Perspectives: Recap of the Megatrends, Releases and News

I’m excited to share our first Cloud CISO Perspectives post of 2022. It's already shaping up to be an eventful year for our industry and we’re only in month one. There’s a lot to recap in this post, including the U.S. government’s recent efforts to address critical security issues, like

How-to

Rethinking time management: Helping employees manage their time efficiently

As business leaders evaluate their hybrid work models, employee productivity is top of mind. They’re trying to understand how to balance organizational needs for productivity with employee needs for autonomy, flexibility, and work/life balance. In my role as Google’s Productivity Advisor, I help organizations and employees realize that being productive

Case Study

Google Cloud’s Suite of DevOps Speeds Up ForgeRock’s Development

Editor’s note: Today we hear from ForgeRock, a multinational identity and access management software company with more than 1,100 enterprise customers, including a major public broadcaster. In total, customers use the ForgeRock Identity Platform to authenticate and log in over 45 million users daily, helping them manage identity, governance, and access management across

Blog

Partner Delivery Excellence: Empowering Partners Deliver Customer value with Google Cloud

With growing demand for Google Cloud, customers are increasingly expecting more reliable advisory and implementation skills from Google Cloud Systems Integrator (SI) Partners. Our model for professional services remains differentiated, with a heavy co-dependence on our SI Partner ecosystem to drive success for our customers. Therefore, enabling and nurturing strong

SHOW MORE STORIES