Create analytics dashboard of your Google sheets

Photo for Editor | Chatgt

Obvious Introduction

Google Shestinity dashboard is a powerful way to see the project progress, comparing tasks, and quickly identifying anything bad that needs your attention. You can prioritize your work by priority, follow the bottles, and take action in real time. The best, when connecting Google Sheets Dashboard with services such as Google Analytics, Salesforce, or Github, your dumps can relieve successively as the data is changed or changed.

In this article, I will take you in a way to create a basic dashboard using Google sheets.

Obvious Why Consider Dashboard for Your Google Sheets?

Google Shestinist dashboard is a very useful tool that will help you visualize and track data to all different platforms. With just a bottle clicking, you can bring data from a variety of spreadsheets together to display data in charts, tables, and graphs to analyze our business or project.

You can also create automatically sent alerts, so you can look at the changes made of dashboards and see that the tendency to improve may need to be needed by corrective action.

Creating a valid and visual dashboard on Google sheets contain a few simple steps. Let's look at them now.

Obvious 1. Import and plan your data

Start by editing your data in clear, table table. To start, we will use flower sales dummy dataset. Finding it, You can copy this template template and the remaining data installed (and the solution!).

In case you want to use any data source, you can easily download the CSV file or connect Google sheet to a particular data source using its connectors. When the data is in our area, some tap should remain in mind:

• Make sure your data is clean and compatible (eg, no empty cells or combined formats)
• Use Data Confirmation to Create a Case Design or Conditions
• Enter a Timestamp Time column when planning to track the tendency time

Obvious 2. Produce a chart

When your data is ready, highlight the part you want to analyze and navigate to install and charge. Google sheets will include a chart on your paper, early as an empty canvas.

You will work with two big tabs to stop your chart:

• To Set Up: When selecting a type of chart (eg, line, bar, pie) and define the range of data. Make sure you enter all required columns represent your ax or variables.
• Customize: In preparing appearance, labels, colors, and structure to match your style or reporting requirements. Use this section to accompany your defense, reading and impact.

Keep in mind: The number of columns you enter into your data will determine how many dimensions (eg, x and the AXS) your chart can display.

Screenshot of Google Sheets

// 2.1 ScoreCards or Guji Charts

ScoreCards are ready to highlight key work indicators (KPIS) or one number metrics, such as income or standard discount.

To create one, you can start installing a new chart and select a scorecard type.

Then go to the setup tab, describe the data distance, order column to display complete sales.

After this, the basic credit card will appear immediately. Next, don't customize tab:

• Fix the scale. We will choose millions in this example.
• Enter the prefix or suffix.
• Set the title, such as “Revenue Revenue”, and sync both title and metric value in the middle.

Here's how the final Scorecard can look like:

You can also repeat this process to show other KPIS:

1. Complete units sold, summarizing the amount of value
2. A common discount, by calculating the discount column rate

These scorecards provide a quick, fastest maximum maximum metrics.

// 2.2 Line charts

Line charts are ready to track and changes later. Creating one:

• Insert a new chart and select the type of line chart
• On the setting tab, select two counters of data, one X-axis (such as a time column or time column) and one of the Y-Axters or income)

This setup lets you see how your metric comes from later. Enter a descriptive title such as temporary income to make a chart easy to translate. Once prepared, your chart should clearly show the practice of income throughout your selected time. Here is my last effect:

// 2.3 Bar and column charts

Bar and column charts is the best way to compare prices in different categories. In this example, we want to identify which product guidelines that provide the highest discounts:

• Insert a new chart and select a type of bar chart.
• The setup tab, select two counters of data. One of the paragraph axis (product class). Another Axis of Number (Discount Column, Mixed Mixed Mix)
• Customize the chart by giving different colors to each bar to improve the visual clarity.

// 2.4 Bar and column charts

PIE charts help show the equality and understanding how different components contribute altogether. In this case, we will consider the distribution of money through the product class:

1. Insert a new chart and select a chart type.
2. Setup tab, select the relevant data settings. One of the sections (such as the product section) one of the prices (such as cash available)
3. Customize the chart by giving different colors to each piece to read better.

This will produce clear deterioration, equal amounts of income in all categories, helps you quickly see which parts are driving more money.

Now we have all our charts! We are about to receive the last version of our dashboard. So the next natural step is to allow users to choose which data to see, leading to this.

Obvious 3. Adding Sliders to Sort Data

Providing a powerful variety and achievement of your dashboard as the data value grows, you can take advantage of the sliders. Active strenuous Silons, allow users to make certain filters based on specific columns.

First, go to the data and select Add Slicer option.

Then choose all your personal information such as slic width and select the column you want slicer the fountain with (as a region, product class, or date).

Slicer will automatically sort all Dashboards, charts and contacts connected, based on the selected price.

In our example, we will add two pieces to pieces they allow to make the default Deskboard, one ordertypi and other product phase, having a set of easy-tested data.

Obvious 4. produce dashboard with many charts

Now that you have hit your charts and create active sliders, we will put everything together one last dashboard. To do so, you will have to:

• Create another Dashboard sheet
• Put a clear title at the top of a new sheet to summarize Dashboard content
• Edit and distinguish your observations in similar or related categories
• Match your charts and brake together, to save clean dashboard and professional

With just a few tweaks, you will convert a set of charts into valid dashboard, easy learning is ready to make decisions and introduction.

Obvious Store

Google sheets offer a variable and accessible way of building Dashboards that help you track work, testing styles, and make data-operated decisions, all without leaving your browser.

By following this guide, you have learned to edit and submit your data effectively; Create a variety of different types of different understanding sheets; Enter cooperation by using slicers; And designed the structure of a tied dashboard.

Whether you control projects, tracking tracking, or monitoring the KPIS, dashing Google Gobboard sheets can be your Real-Time device, no codes are installed.

JOSEP FERRER by analytics engineer from Barcelona. Graduated from physics engineer and is currently working in a data science association used for human movement. He is a temporary content operator that focuses on science and technology. Josep writes in all things Ai, covering the use of ongoing explosion on the stadium.