Advanced programming & development techniques for experienced professionals looking to level up.
In this course you'll master the advance features in Google Data Studio, so that you understand all the options available for transforming your data sets and data visualisations into the format you need. Target Audience This course is for people who have an intermediate knowledge of Google Data Studio and want to gain advance knowledge. You already have experience with Data StudioYou have experience with Functions in Excel and/or Basic knowledge of SQLWant to understand the full range of capabilities that Google Data Studio offers Curriculum In this course you will cover in detail: Visualisations - Pivot Tables, Combination & Dual Axis Charts, Stacked Bar & Area Charts Layout - How to set global colour palettes Transforming Data Sets - Transforming Metrics & Dimensions with Calculated Fields and a range of functions that Data Studio supports e.
g Median(), Variance(), Percentile(), Concat(), Substr() as well as Case Statements for grouping dimension values together. Hyperlinks and Clickable images - Adding images and links to data tables to show and link through to your products in your reports Filters - Group and Page Level filters to add more control to your reports Embedding - How to embed your reports into an external application or website. Databases - Connecting to SQL database tables, views and custom queries.
We will connect to BigQuery. Roles Your role might fall into one of the following Online MarketerProduct AnalystData AnalystFinance AnaystProduct Owners/ManagerSmall business Owner Data Sources you may already use Google Analytics, Adwords or other Google Product Google Sheets Excel SQL Database e. g MySQL, BigQuery, PostGresQL The Power of Data Studio Intuitive Design - create dashboard designs that are more intuitive than dashboards in GA & Google SheetsScale your insights - build shareable dashboards saved in Google DriveSpeed up time to insight - build reports and visualisations to answer questions within minutesUser friendly Templates and Layouts - will make it easier for users to interpret the data.
Data Studio is a Data Visualisation Tool created by Google. It is part of the Google Suite including Google Docs, Google Sheets and Google Slides. Data Studio is FREE and allows you to connect to a range of data sources.
View pricing and check out the reviews. See what other learners had to say about the course.
Not sure if this is right for you?
Browse More Programming & Development CoursesExplore more Programming & Development courses to deepen your skills and advance your expertise.