If you are a Google Analytics user you will know how much data can be provided to you. However it is not always easy to access this data and make sense of it within Google Analytics. In this course Ian Littlejohn will show you how to easily create your own custom Google Data Studio reports and dashboards that will make it easy to understand your Google Analytics data.
Google Data Studio is Google's latest report and dashboard creation tool. Using a drag and drop interface reports can be created and running in minutes. Google Data Studio also makes it incredibly easy to share your reports with other users.
In this course we will show you how to easily create the following:
This course is for anybody who wants to effectively analyze and understand their Google Analytics data.
The Introduction section provides an overview of the course
Explanation of the course content
Introduction lesson for the Google Analytics Reports and Dashboards with Data Studio.
Download the learner guide to use during the course
In this section we review how to connect your web site data to Google Data Studio and how to start your report and dashboard creation
We provide an overview of Google Data Studio and explain how to connect your web site data to Google Data Studio
Practical Activity for the setting up Google Data Studio lessons
Learn how to create your first report using Google Data Studio
In this lesson we will start to create our first report in Google Data Studio.
The Scorecard is an important visualization for displaying key metrics and KPIs. In this lesson you will learn how to display key metrics such as the number of sessions and users
Practical Activity for the Scorecard section
The Time Series section
In this lesson we learn how to use the Time Series graph. The Time Series graph makes it easy to understand your data by week, month, quarter or many other options.
The Cumulative Time Series creates a running total visualization. This visualization is very powerful to display how the number of users or sessions accumulates.
Time filters are one of Google Data Studios most powerful features. At the click of the mouse you can change the time frame for the data being displayed in report or on the dashboard.
In this lesson we will learn how to create comparisons to previous periods. Google Data Studio supports two forms of previous periods. The data can be compared to the previous period i.e. the previous week or previous month or the data can be compared to the previous year.
The practical activity for the Time Series visualization section
The Filters section. In this section you will learn how to easily filter the data from your web site and ask questions.
Filters are powerful tools for asking questions of your data. In this lesson you will learn how to add filters to your reports and dashboards.
This section will teach how to use the Area Graph to visualize how data changes over time
In this lesson we will learn how to use the Area graph to display time series data. The area graph provides an effective visualization to understand trends.
The practical activity for the area graph
Column and Bar graphs section
In the column and bar graphs lesson we will see how to use this form of visualization to display which items are highest and which are lowest
The Pie Graph section.
In this lesson we learn how to use the Pie graph to effectively visualize the percentage contribution to the total.
Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio.
Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.
Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.
Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.