Data Dashboarding and Visualization using Looker Studio

Certificate of completion (supplied by PasarTrainer)

Training Material

* Overview of data analytics and data dashboard
* General usage of Looker Studio
* Tutorial for functions in Looker Studio

Explains the overview and general usage of Looker Studio.


Module 1. Introduction to Looker Studio

* Explore sample datasets (from the e-commerce industry)
* List metrics to be presented in the dashboard and determine visualizations for each metrics


Explains the data that will be converted into a dashboard and decides all metrics that will be presented in the dashboard.


Module 2. Problem Statement and Brainstorming

* Dashboard blueprint
* Metrics and charts positioning and section grouping

Designs a dashboard blueprint (template).


Module 3. Dashboard Blueprint

* Charts creation
* Dashboard data controls (filter)
* Pivot and join tables
* Style, theme, formatting
* Calculated field


Creates the dashboard based on the previously designed blueprint.


Module 4. Dashboard Creation and Data Visualization

* Data analysis/insights generation
* Recommendation from data

Generate insights and recommendations based on the available data in the dashboard.


Module 5. Data Analysis using Dashboard

* Email automaton
* Cross filtering
* Extract data
* Date range control, etc

Explains more advanced functions that can be utilized in Looker Studio.


Module 6. Additional Advance Features

*  Individual project for dashboard creation (different dataset)
* Dashboard and analysis presentation/discussion

An individual project where everyone will exercise creating a dashboard (re-do modules 2-5) using a different training dataset.


Case Study 

Many times companies have data stored in dispersed sources while the managers have to make a strategic decision using the available data. The scattered data points make it difficult for the managers to gain insights into what actually happened in their companies and what are the potential segments or areas that can be maximized to achieve the companies' goals.

A data dashboard is a tool that can help business stakeholders assess the companies' condition in a single view. At a glance, a user can gain insights from various metrics within one department or from various departments within the company. Looker Studio (previously known as Google Data Studio) is the most commonly used dashboarding tool in the industry and also the best one for anyone who wishes to learn to create a dashboard.

After completion of this program, participants will be better able to:
* Create all kinds of data visualization in Looker Studio
* Connect, pivot, and/or join data from various sources within one dashboard
* Decide the proper metrics to present in the dashboard
* Design a well-structured and user-friendly dashboard
* User filter, automation, and other useful functions in Looker to enhance the dashboard performance 
* Generate insights from the dashboard