Data Analysis with Google Looker

A Powerful Tool for Digital Marketing Success

Data Analysis4.9(100)3h 47m24 lectures6 sections

What you'll learn

  • Get to know Looker Studio and start using it
  • Connect to data sources
  • Import data from Excel
  • Create line, bar and pie charts
  • Use scorecards for key indicators
  • Show data on geographic maps
  • Apply dynamic filters
  • Build a complete dashboard
  • Share and publish reports
  • Customize Google Analytics data in reports

About this course

This course teaches data analysis and report building with Google Looker Studio, a free tool for showing data in interactive dashboards that help digital marketing. It starts with an introduction to the tool and how to get started, then connecting to data sources and importing data from Excel. After that you learn the charts one by one: line, bar, pie, area, scatter, waterfall, Sankey and geographic maps, then tables and scorecards for key indicators. You also learn to add images and shapes, apply filters, build a dashboard, manage multiple pages, share and publish reports, blend data from several sources, and customize Google Analytics data. The course suits marketers, analysts and business owners, and needs no previous experience. By the end you will be able to build a professional report that shows the results of your campaigns and your data clearly. Each lesson builds on the one before, and you can return to any lesson whenever you like.

Expected outcomes

  • Ability to create customized professional reports.
  • Master designing interactive dashboards using advanced tools.
  • Analyze data effectively to understand patterns and trends.
  • Create engaging visualizations that aid data-driven decision making.

Learner reviews

These reviews are from learners who bought the content and completed at least 50% of it — there are no reviews from anyone who hasn't gone through the material.
4.9
★★★★★
100 reviews
5★
88
4★
10
3★
2
2★
0
1★
0
  • ★★★★★اسامه ا.·منذ 1 شهرشاهد 52٪

    جيد في التحلات جميل

تم عرض كل التقييمات (1)

Course content

1

Introduction and Beginning

2 lectures
  1. Introduction to Google Data Studio (Looker Studio)Introduces Looker Studio, formerly Google Data Studio, as a free tool for data analysis and building interactive reports and dashboards, connecting to many sources and sharing reports, and previews what the course covers.6:21
  2. Getting Started with Google Data StudioExplains opening Looker Studio from Google's site, getting to know the home page with its reports and templates, creating a new blank report, and starting to connect a data source.4:57
2

Data Sources and Importing

2 lectures
  1. Connecting to Data SourcesExplains how to connect to data sources in Looker Studio, such as Google Sheets, Google Analytics, Google Ads and databases, adding a Google Sheets worksheet to a report and adding a second data source.3:18
  2. Importing Data from ExcelExplains importing data from an Excel file into Looker Studio by saving it as CSV, then uploading it through File Upload and adding it to the report.2:48
3

Creating Charts and Visualizations

9 lectures
  1. Creating Line Charts and Controlling Data RangeExplains building a line chart in Looker Studio and using the Date Range Control to set the time period, compare two periods, add a reference line such as the average, and format the chart.14:03
  2. Building Stacked Bar ChartsExplains the four types of bar charts in Looker Studio, including stacked and percentage stacked, the difference between drill down and breakdown dimensions, and adjusting range, colors and horizontal orientation.17:04
  3. Creating Pie Charts and Donut ChartsExplains how to build pie and donut charts to show each category's share of the total, set the number of slices and group the rest, and adjust colors, labels, and font size.6:36
  4. Designing Spatial DiagramsExplains designing an Area Chart where the lines overlap, with a breakdown by category, the stacked option, a 100 percent view of proportions, and color changes.4:03
  5. Data Visualization Using Scatter PlotsExplains the Scatter Chart for studying the relationship between two numeric variables such as sales and profit, spotting categories with high sales but negative profit, adjusting point size, and how it differs slightly from a bubble chart.7:38
  6. Using Scorecards for Key IndicatorsExplains Scorecards and compact-number scorecards for showing key metrics, adding metrics such as profit, setting the date range, and comparing with the previous period, showing change as a percentage or an absolute value.12:19
  7. Creating Waterfall ChartsExplains the Waterfall Chart and how it shows the positive and negative contributions to a total, such as the effect of negative-profit categories on sales, with separate colors for positive and negative values.4:37
  8. Sankey DiagramsExplains the Sankey Chart, which shows the flow of values from a source to a target through connected lines, with color and font customization and adjusting node thickness and node padding.4:49
  9. Plotting Data Using Geographic MapsExplains the geographic map types in Looker Studio such as Filled Map, Bubble, Line, and Combo, setting a field as a geographic location, color shading by value, and changing the map type and its settings.9:59
4

Report Elements and Customization

4 lectures
  1. Creating and Using TablesExplains building tables and Pivot Tables in Looker Studio, expanding levels, subtotals and grand totals, conditional formatting, and styling the table with bars and icons and applying a date filter.13:05
  2. Merging Images and IconsExplains adding smart objects to a Looker Studio dashboard: an image as a background, an icon as a logo, and text as a title with formatting, plus arranging the layers.5:31
  3. Applying Dynamic FiltersExplains adding dynamic filter controls to a dashboard, such as a drop-down list for choosing a category and a date range control, and using them to filter the data and return to the original view.18:27
  4. Using Shapes in ReportsExplains adding shapes to reports such as rectangles, circles, and icons, changing background color, transparency, and borders, and arranging shapes in front of or behind elements to improve the dashboard's look.6:15
5

Managing Dashboards and Reports

6 lectures
  1. Building a DashboardApplies earlier lessons to building a dashboard in Looker Studio by recreating a ready-made design: adjusting charts, colors and fonts, adding a table and a bar chart, and navigating between pages with buttons.17:34
  2. Using the 'File' Tab in Google Data StudioCovers the File tab functions in Looker Studio: sharing a report with viewer or editor permissions, report settings, Version History to review earlier versions, downloading, and embedding the report.11:40
  3. Managing Multiple Pages in ReportsExplains managing multiple report pages: adding a new page or duplicating one with its styling, renaming pages, hiding them in view mode, and giving each page an icon for navigation.5:28
  4. Sharing and Publishing ReportsExplains ways to share and publish a report: emailing with permissions, sharing a link, embedding the report, scheduling delivery by email, and downloading the report as a PDF.7:20
  5. Merging Data from Multiple SourcesExplains blending data from multiple sources by joining tables on a shared field such as Order ID, the join types Left, Right, Inner, Full, and Cross, and using the blend to work out returned-order values.12:38
  6. Customizing Google Analytics Data in ReportsExplains connecting Looker Studio to a Google Analytics account and customizing its data in the report, such as metric cards, comparing the last 28 days, sparklines, and seeing which channels visitors come from.30:44
6

Accessories

1 attachments
  1. Downloading Add-ons

Instructor

Mohamed Khalaf

Mohamed Khalaf

Data analysis and business intelligence specialist, lecturer, and trainer in statistical analysis programs.
25.3K views6 courses

This course is part of the diploma

Related courses