• logo
  • 9861600203
  • info@mentorit.com.np
header-logo.png

Overview

Unlock the Power of Data with Looker Studio!

Your Fast-Track Guide to Data Visualization Mastery
Feeling overwhelmed by data? Struggling with complex tools? Look no further. Our beginner-friendly course is designed to make you a Looker Studio pro in just one hour. Navigate, create, and style reports with ease and confidence.

Quick Start Guide

The Looker Studio course is focused on empowering beginners and experts in data visualization and analysis. It offers a comprehensive guide to the platform's key features, including accessing and navigating the homepage, utilizing data connectors, and creating customized reports using pre-built templates.

Data Connection

This Looker Studio tutorial provides an in-depth walkthrough of the platform's interface, focusing on connecting to various data sources, managing and customizing reports, and utilizing a range of chart options. It also introduces the concept of connectors, explaining the different types available for integrating data from platforms like Google Analytics and Google Sheets.

Choosing & Building Charts

This tutorial dives into the intricacies of building charts in Looker Studio, emphasizing the importance of dimensions, and metrics in data visualization. It covers essential chart types like table charts, line charts, bar charts, scorecards, and geo charts, while also offering pro tips for effective visualizations, such as adding comparisons and cross-filtering options.

Create Eye-Catching Dashboards

The tutorial provides a step-by-step guide on creating and customizing dashboards in Looker Studio, covering everything from setting up new reports to adding intricate elements like scorecards and date range selectors. It also delves into advanced features such as adding custom dimensions, metrics, and even creating a navigation menu, making it a comprehensive resource for anyone looking to master Looker Studio's dashboard capabilities.

Course Content

  • 1.1. Looker Studio Introduction
  • 1.2. User Interface Explained
  • 2.1. Bringing in Your Data
  • 2.2. Data Connectors
  • 2.3. Live vs Warehoused Connectors
  • 2.4. Google Connectors
  • 2.5. Partner Connectors
  • 2.6. Data Sources
  • 2.7. Data Source Scope: Embedded vs Reusable
  • 2.8. Caching & Data Freshness
  • 2.9. Managing your Data Sources
  • 3.1. Overview of Chart Types in Looker Studio
  • 3.1. Chart Types Overview
  • 3.2. Scorecards
  • 3.3. Tables
  • 3.4. Pivot Tables
  • 3.5. Time Series
  • 3.6. Area Charts
  • 3.7. Line Charts
  • 3.8. Combo Charts
  • 3.9. Bar Charts
  • 3.10. Geo Charts & Google Maps
  • 3.11. Pie Charts & Donuts
  • 3.12. Scatter Plots & Bubble Charts
  • 3.13. Tree Maps
  • 3.14. Gauge Charts
  • 4.1. Text Functions: CONCAT()
  • 4.2. Text Functions: LOWER() & UPPER()
  • 4.3. Text Functions: LENGTH()
  • 4.4. Text Functions: CONTAINS_TEXT(), STARTS_WITH(), and ENDS_WITH()
  • 4.5. Text Functions: LEFT_TEXT() and RIGHT_TEXT()
  • 4.6. Text Functions: REPLACE() and REGEXP_REPLACE()
  • 5.1. Grouping Data with IF() in Looker Studio
  • 5.2. The CASE Function
  • 6.1. Data Visualization Best Practices
  • 6.2. Visualizing KPIs & Metrics
  • 6.3. Visualizing Distribution
  • 6.4. Visualizing Trend over Time
  • 6.5. Comparison Across Categories
  • 7.1. Mastering Your Style in Looker Studio
  • 7.2. Report Layout Customization
  • 7.3. Theme Customization
  • 7.4. Dimension Color Management
  • 7.5. Page Level Theme & Layout Settings
  • 7.6. Time Saving Techniques
  • 7.7. Effective Communication
  • 7.8. Community Visualizations
  • 8.1. Right Outer Join
  • 8.2. Inner Join
  • 8.3. Full Outer Join
  • 8.4. UNION (with Full Outer Join)
  • 8.5. Cross Join
  • 9.1. Intro & Dimension Filters
  • 9.2. Metric Filters
  • 9.3. Filters Live in Data Sources
  • 9.4. Managing Filters
  • 9.5. Controls: Data Control
  • 9.6. Date Range Control
  • 9.7. Filter Controls
  • 9.8. Filtered Filter Controls
  • 9.9. Advanced Filter Controls
  • 9.10. Chart Cross Filter
  • 9.11. Controls Filter Controls
  • 9.12. Scope of Controls
  • 10.1. Introduction to Parameters
  • 10.2. Use Cases for Parameters
  • 10.3. Properties of Parameters
  • 10.4. Parameters: From Creation to Visualization
  • 10.5. Parameters: Range of Values
  • 10.6. Parameters on Charts
  • 10.7. Scope of Parameters
  • 11.1. The Limitation of Controls Across Data Sources
  • 11.2. Bridge Fields
  • 11.3. Bridge Filters
  • 11.4. Filtering Blended Data Sources
  • 11.5. Page vs Report Level Parameters
  • 12.1. The Date Functions
  • 12.2. Calculating Membership Duration with CURRENT_DATE()
  • 12.3. Advanced Date Range Selector
  • 12.4. WEEKDAY() Function
  • 12.5. DATETIME_ADD() in Looker Studio
  • 12.6. DATETIME_DIFF() in Looker Studio
  • 12.7. EXTRACT() and DATE()
  • 13.1. Diving into Sharing and Management in Looker Studio
  • 13.1. Sharing Looker Studio Dashboards
  • 13.2. Embedding Reports on Webpage
  • 13.3. Downloading Looker Studio Reports in PDF format
  • 13.4. Notes About Sharing Edit Access
  • 13.5. Creating Dashboard Templates
  • 13.6. Limiting Access for Editors and Viewers
  • 13.7. Presentation Mode
  • 13.8. Row-Level Security
  • 13.9. Tracking Usage of the Report
  • 13.10. Auditing Dashboard Usage
  • 13.11. Working on and Editing Published Reports
  • 13.12. Version History in Looker Studio
  • 13.13. Restoring vs Report Publishing
  • 13.14. Managing Ownership of Assets in Looker Studio

About the instructor

DIPU MAHARJAN

BI Solution Architect

Hi I am Dipu Maharjan. I am working as BI Solution Architect. I have experience more than 13 years as Data Analyst, Database Programmer, BI Developer and Trainer.

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features

  • Total Credit Hours30 hrs
  • Course CostUSD 224.70