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 AudienceThis 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 offersCurriculumIn this course you will cover in detail: Visualisations - Pivot Tables, Combination & Dual Axis Charts, Stacked Bar & Area ChartsLayout -How to set global colour palettesTransforming 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 toyour products in your reportsFilters - Group and Page Level filters to add more control to your reportsEmbedding - How to embed your reports into an external application or website. Databases -Connecting to SQLdatabase tables, views and custom queries. We will connect to BigQuery. RolesYour role might fall into one of the followingOnline MarketerProduct AnalystData AnalystFinance AnaystProduct Owners/ManagerSmall business OwnerData Sources you may already useGoogle Analytics, Adwords or other Google ProductGoogle SheetsExcelSQL Database e.g MySQL, BigQuery, PostGresQLThe Power of Data StudioIntuitive 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 andvisualisations to answer questions within minutesUser friendly Templates and Layouts-will make it easier for users to interpret the data. Data Studio is aData Visualisation Tool created by Google. It is partof the Google Suite including Google Docs, Google Sheets and Google Slides. Data Studio is FREEand allows you to connect to a range of data sources. It’s an incredible tool to create powerful and interactive dashboards for you to explore your underlying data.I look forward to showing youhow to master the advance concepts in Google Data Studio so that you understand the full range of capabilities at your fingertips.
