What you'll learn:
- Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P
- Learn from an Instructor with over 10 years teaching Data Analysis and Dashboard Design
- Create POWERFUL Interactive Dashboards from Google Sheets Data in Minutes
- Analyze Google Sheets in MINUTES using powerful visualizations and reports
- Create Year to Date, Month to Date, Week to Date Calculations with the click of the mouse
- Learn to SHARE and COLLABORATE using Reports and Dashboards of data
- Create powerful SCORECARDS displaying Key Metrics and KPIs
- Create TIME SERIES graphs that easily display Month to Date, Previous Month and many more
- Display COMPARISONS to Previous Periods
- Create FILTERS to easily create interactive dashboards, graphs and reports
- Learn powerful VISUALIZATIONS such as Column, Bar, Pie, Scatterplot
In this course we are going to show you how to supercharge your Google Sheets into Interactive Dashboards and incredible reports. Data Studio works seamlessly with your Google Sheets data to create amazing data analysis in minutes.
Data Studio is an incredibly easy to use drag and drop tool that allows a multitude of different visualizations to be created in minutes. The addition of filtering tools produces stunning reports that will take your data analysis to the next level.
Data Studio is available free to people with a Google or Gmail account.
COURSE CONTENT AND OUTCOMES
How to connect Data Studio toGoogle Sheets
Learn how to calculate Averages, Highest values, Lowest Values and number of Unique Values
Create Scorecards to display key metrics and KPIs
Create powerful trend analysis graphs to help with forecasting
Create Year to Date, Month to Date and Previous Month calculations with the click of a mouse button
Learn to gain powerful analysis from Stacked Bar and 100% graphs
Create powerful Time and Category filters to easily create interactive reports
Learn to share your Reports and Dashboards with other users
Google Data Studio is truly an amazing product for creating insight and intelligence from your Google Sheets data.
ABOUT THE TRAINER
I am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.
WHAT STUDENTS ARE SAYING
I was very pleasantly surprised by this course, I just wanted to whip through it to get the gist of data studio, but it's very interesting and there's lots of cool tips and tricks, and perhaps most welcome of all, the lessons are concise - a lot of 'tech' courses on udemy are very long, and I'm not against the creators taking their time and including lots of content, but it is difficult to maintain your concentration across 40 hours, especially with a new subject. This was an excellent course.
Excellent course with a general overview of all the features that Looker Studio has to offer. Concise, simple to understand, great presentation and to the point. Excellent!
Very thorough and concise course. I feel like I've gained all of the knowledge I need to get started with building effective reports in Looker Studio. I especially appreciated the "Sales Manager" hands-on exercises.
Really enjoyed this course - having never worked with Looker it was great and gave me all the information i needed for a new role - highly recommend
DATA ANALYSIS COURSES ROADMAP
The tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.
Microsoft Excel
Introduction to Analyzing Data with Excel Pivot Tables
Complete Introduction to Excel Power Pivot
Complete Introduction to Excel Power Query
Excel Interactive Dashboards and Data Analysis
Complete Introduction to Business Data Analysis
Tables and Formulas with Excel
Microsoft Power BI
Complete Introduction to Microsoft Power BI
Complete Introduction to Power BI Query Editor
Power BI Master Class-Data Models and DAX Formulas
Power BI Master Class - Dashboards and Power BI Service
Complete Introduction to Google Sheets Pivot Tables
Complete Introduction to Looker Studio (formerly Google Data Studio)
Amazon QuickSight
Complete Introduction to Amazon QuickSight
ChatGPT
Introduction to Analyzing Data with ChatGPT