Looker and Looker Studio: Google’s Data Visualization Tools

سرفصل های دوره

Learn Google's Data Visualization tools - Looker and Looker Studio (previously Google Data Studio) + LookML for Devs

1. Introduction

1. Introduction

2. Why use Looker

3. This is a Milestone!

4. Google Data Viz & Bi products

2. Google Data Studio

1. Why Data Studio

3. Terminologies & Theoretical concepts for Data Studio

1. Data Studio Home Screen & Dataset vs Data Source

2. Structure of Input data

3. Dimensions vs Measures (new definition)

4. Practical part begins here

1. Opening Data Studio

2. Adding a data source

3. Managing added data source

5. Charts to highlight numbers

1. Data Table

2. Styling tab for data table

3. Scorecards

6. Charts for comparing categories Bar charts and stacked charts

1. Simple Bar and Column chart

2. Stacked Column chart

7. Charting maps of a country, continent, or a region - Geomaps

1. GeoMap

8. Charts to highlight trends Time Series, Line and Area charts

1. Time Series

2. Update to Time Series chart

3. Line Chart and Combo Chart

9. Highlight contribution to total Pie chart & Donut Chart

1. Pie Chart and Donut Chart

2. Stacked Area Charts

10. Relationship between two or more variables Scatter plots

1. Scatter Plots and Bubble charts

11. Aggregating on two dimension Pivot tables

1. Pivot tables for cross tabulation

12. All about a single Metric Bullet Chart

1. Bullet Chart

13. Chart for highlighting heirarchy TreeMap

1. TreeMaps

14. Branding a Report

1. Branding a Report Brand Logo and Company Details

2. Brand colors for report branding

15. Giving the power to filter Data to viewers

1. Filter controls for viewers

16. Add Videos, Feedback form etc. to your Report

1. URL Embed to include external content

17. Sometimes data is in multiple tables

1. Blending data from multiple tables

2. Different types of Joins while blending data

18. Sharing and Collaborating on Data Studio report

1. Downloading report as PDF and Page Management

2. Sharing report and Data Credentials

3. Sharing report using a link

4. Scheduling emails

5. Embeding report on Website

19. Google BigQuery Connection

1. Connecting and Visualizing Data in Google BigQuery

20. Charting Best Practices

1. Highlighting chart message

2. Eliminating Distractions from the Graph

3. Avoiding clutter

4. Avoiding the Spaghetti plot

21. Looker Features

1. Looker features

2. Setting up the Sandbox

3. Home Interface

22. Terminologies & Theoretical concepts for Google Looker

1. Important terms used in Looker

2. Dimensions and Measures

23. Practical part begins here

1. Creating your first Look

2. Saving a Look

24. Filters

1. Filtering using Dimensions

2. Filtering using Measures

25. Popular Chart Types

1. Single-Value Visualization

2. Bar and Column Chart

3. Line Chart

4. Pie Chart

5. Scatterplot

6. GeoMaps

26. Custom fields

1. Table Calculations

2. Creating a custom dimension using a Looker expression

3. Binning - Custom Dimension

4. Groups - Custom Dimension

5. Custom Measures

27. Look view-mode

1. Look view-mode

2. Other options in View mode

28. Looker Dashboards

1. Creating a Dashboard in Looker

2. Adding filters to a dashboard

3. Setting the tiles and other options

29. Folders in Looker

1. Creating folders and Managing Access

30. Downloading and sharing content

1. Downloading Looks and dashboards

2. Sharing and Sending mails

31. Boards

1. Boards

32. LookML

1. Why to use LookML

2. Advantages of LookML

3. LookML important terms

4. Interface of LookML

5. How to create Views in LookML

6. SQL runner in Looker

33. Dimensions in Looker

1. Dimensions - Syntax ed

2. Dimensions - Number

3. Dimensions - String

4. Dimensions - YesNo

5. Dimensions - Tier

6. Dimensions - Location - Tier

7. Dimensions - Date Time and Others

34. Creating Dimensions in Looker

1. Dimensions in looker - Data sample and import

2. Dimensions in looker - For Airport view

3. Dimensions in looker - Creating single view explore

4. Dimensions in looker - Creating Airport dashboard

5. Dimensions in looker - Explore and look for Flight view

35. Measures

1. Measures - Syntax

2. Measures - Average

3. Measures - Average Distinct

4. Measures - Count and Count Distinct

5. Measures - Other common measures

6. Measures - Running total

7. Measures - Percent of previous

8. Measures - Percent of total

9. Measures - List

10. Measures - YesNo

36. Creating Measures in Looker

1. Measures in Looker - Data Sample and Measures calculation

2. Measures in Looker - Creating Measures

3. Measures in Looker - Measures in a look

37. Substitution operator

1. Substitution operator

38. Joins Prerequisites

1. Types of joins - Introduction and Left Join

2. Types of joins - Full Outer join

3. Types of joins - Inner Join

4. Types of joins - Cross Join

5. Relationships for joins - Introduction

6. Relationships for joins - Why should we use relationships for joins

7. Primary Keys

39. Creating Joins in Looker

1. Joins in Looker - Syntax

2. Joins in Looker - Syntax Example

3. Joins in Looker - Creating joins

4. Joins in Looker - Exploring joins in a look

40. Customization in Looker

1. Customising explore menu - Concepts and Syntax

2. Customizing explore menu - Application in looker

3. Customizing Field Picker - Concepts and Syntax

4. Customizing Field Picker - Application in Looker

41. Git and Github Basics

1. Git and Github Basics

42. Congratulations & About your certificate

1. The final milestone!

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training