
Learn to consolidate data from Google Analytics, spreadsheets, and databases with Google Data Studio, drag-and-drop visuals, and third-party connectors to create centralized dashboards.
Log in to Google Data Studio and begin creating visualizations in its interface, exploring reports, data sources, and explorer insights with useful search, help, and settings.
Open the new report interface, start a blank report with the plus sign, and review the terms and preferences. Connect data sources from the right panel, beginning with Google Analytics.
Connect to the Google Analytics demo account, explore the ecommerce data and three views, and access the master view for use in Google Data Studio.
Connect the Google Analytics e-commerce demo account to Google Data Studio, create a new data source from Google Analytics, select the merchandise store view, and prepare your report.
Learn how to build a report in Google Data studio. This lecture also shows you time series chart, bar chart, table chart and pie chart as well how to use image object.
Add pages to a Google Data Studio report and rename them. Navigate pages with the page menu, and add scorecards and a line–combo chart showing sessions, page views, and users.
Explore how include and exclude filters focus data in your visualizations. Apply filters at report, page, or chart levels and enable viewer controls, with cascading effects across the hierarchy.
Apply a filter to a chart in Google Data Studio to focus on a subset of data, such as Google traffic, by using include filters on the source medium.
Apply a page level filter to all charts on a page in Google Data Studio, attach a default data source, and create a non Google traffic rule.
Apply a report level filter in Google Data Studio to ensure all components share the same data source. Create and save filters, and view their sequential effects across charts.
Learn to use a filter control in Google Data Studio to let users slice data by dimensions, apply filters on pages or whole reports, and set default values.
Learn to add and customize reference lines in Google Data Studio to compare data against targets, averages, and benchmarks across time series and other charts.
Change the default date ranges for charts, pages, and reports in Google Data Studio by selecting custom or fixed ranges. Apply last seven, fourteen, or 28 days or today.
Place a date range control in Google Data Studio to let users choose the period, ensure charts have a date dimension and auto data, and apply at report level.
Explore weighty formatting options in Google Data Studio, including applying themes, customizing colors, borders, fonts, and data styles to create visually effective reports.
Explore Google Data Studio report layout options, including header visibility, navigation placement, display mode, margins, canvas size, and grid-based alignment with snap-to features.
Connect Google Analytics with external sources like Excel files and Google Sheets in Google Data Studio. Create multi-source reports with time series charts showing page views and ad impressions.
Learn to blend data from multiple sources in a single Google Data Studio chart by joining on a common key, creating a blended data source with shared dimensions and metrics.
Learn to speed up report development in Google Data Studio by duplicating charts with all attributes and quickly changing chart types, using right-click copy or duplicate and adjusting metrics.
Learn to create calculated fields in Google Data Studio to derive new metrics and dimensions using aggregation, date/time, geo, text, and other functions, with chart-level and data-source level examples.
Learn how pivot tables in Google Data Studio reorganize dimensions and metrics to reveal patterns by date, medium, and source, with totals, sorting, and expand and collapse features.
Enable interactive filters in Google Data Studio by turning charts into filter controls, letting you filter other charts by selecting dimensions, dates, or multiple conditions.
Build Google Data Studio report themes by extracting colors from images.
Explore an evolving Google Data Studio course that adds new lectures and answers your questions, building a continuously updated, engaging learning experience.
Learn Google Data Studio in this easy to understand step-by-step course. In this course you will learn everything you need to go from not knowing to feeling confident abut using Google Data Studio. In this course I will teach you various ways you can use Google Analytics data in Google Data Studio.
This tool is generally is used by various teams across organization. Your role might fall into one of the following
Web Analyst
Digital Analyst
Marketers
Adwords Analyst
A/B testing specialist
Product Analyst
Data Analyst
Product Owners/Manager
Small business Owners
Students who are looking to learn new skills that employers are looking for.
Real Estate agents
Anybody who does data visualization
Anybody who uses Google Analytics
Data Sources you may already use that you can connect with Google Data Studio
Google Analytics, Adwords or other Google Product
Google Sheets
Excel
Data Studio has 3 Key benefits;
1. Connecting to various data sources
2. Visualizing data
3. Sharing dashboards for collaboration and communicating insights.
Why should you learn from me?
I have been in Digital Marketing and Analytics for over 15 years. I have trained people from diverse backgrounds and have converted them into high performing Digital Marketers and Analysts. I understand both the technology and marketing side of business. I have dealt with many analytics technologies way before Google Analytics, Google Tag manager, Google Data Studio etc. existed and know the inner working of Digital Analytics.
I have extensively worked with companies like Microsoft, Starbucks, Wall Street Journal, ESPN, T-Mobile to name few and helped them Data Driven Marketing Decisions.
In addition, I have developed various course and taught students from all over the world. I am online instructor for University of British Columbia (Canada), University of Washington (USA), Bellevue College (USA) and Digital Analytics Association.
I have an engineering degrees and an MBA.