Building Financial Dashboard in Google Data Studio

Building Financial Dashboard in Google Data Studio, available at $49.99, has an average rating of 4.5, with 22 lectures, based on 312 reviews, and has 1391 subscribers.

You will learn about Creating financial database from financial reports: Profit & Loss, Balance Sheet and Cash Flow Statement Connecting Data Studio to Google Sheets Creating powerful time series charts to help with forecasting: monthly revenue, expense, net profit & net profit margin Creating time range selection to select the time period displayed in the report Creating filter control of companies or organizations Creating Scorecards to display key metrics, comparing previous month and previous year performance Creating Pie charts, Bar charts, Combo charts & Area charts Creating table & Pivot table, showing total Creating Calculated field or KPI from existing data. Creating pages navigation like a financial software Sharing Report & Updating financial data Fixing common errors in Google Data Studio This course is ideal for individuals who are Google Sheets Users or Excel Users or Xero Users or MYOB Users or Accountants or Data Analysts or Business Owners or Managers It is particularly useful for Google Sheets Users or Excel Users or Xero Users or MYOB Users or Accountants or Data Analysts or Business Owners or Managers.

Enroll now: Building Financial Dashboard in Google Data Studio

Summary

Title: Building Financial Dashboard in Google Data Studio

Price: $49.99

Average Rating: 4.5

Number of Lectures: 22

Number of Published Lectures: 22

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Creating financial database from financial reports: Profit & Loss, Balance Sheet and Cash Flow Statement
Connecting Data Studio to Google Sheets
Creating powerful time series charts to help with forecasting: monthly revenue, expense, net profit & net profit margin
Creating time range selection to select the time period displayed in the report
Creating filter control of companies or organizations
Creating Scorecards to display key metrics, comparing previous month and previous year performance
Creating Pie charts, Bar charts, Combo charts & Area charts
Creating table & Pivot table, showing total
Creating Calculated field or KPI from existing data.
Creating pages navigation like a financial software
Sharing Report & Updating financial data
Fixing common errors in Google Data Studio

Who Should Attend

Google Sheets Users
Excel Users
Xero Users
MYOB Users
Accountants
Data Analysts
Business Owners
Managers

Target Audiences

Google Sheets Users
Excel Users
Xero Users
MYOB Users
Accountants
Data Analysts
Business Owners
Managers

Learn from a Financial business intelligence analyst for a Group of more than 10 companies.
Create Powerful Interactive Financial Dashboards from Google Sheets Data from scratch.
No VBA or SQL coding require, just drag and drop, copy and paste.
Analyze Google Sheets in minutes using powerful visualizations.
Learn powerful visualizations such as Time Series Charts, Scorecards, Pie Charts, Stacked Area Charts.
Display comparisons to Previous Period, Previous Year, in one scorecard.
Create Financial Year to Date Calculations.
Create filters to easily create interactive dashboards, graphs and reports.
Create date range selection to easily manage the display range in the charts .
Share Reports and Updating Data.
Create pages navigation to make a report look like running in a professional financial software.
Learn how to Fix error.
Free access to the report anytime, anywhere by signing in Google Account.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Example of Reports

Chapter 2: Creating Data Source from Financial Report

Lecture 1: Setting up Financial database in Google Sheets correctly

Lecture 2: Connecting Google Data Studio to Google Sheets

Chapter 3: Time series Chart

Lecture 1: Creating Time Series Chart

Lecture 2: Adding Filter Control & Time Range Selection

Lecture 3: Formatting and Designing the Dashboard

Lecture 4: Calculated Fields

Chapter 4: Scorecard

Lecture 1: Scorecard

Chapter 5: Report Navigation

Lecture 1: Pages & Nagivation

Chapter 6: Tables & Pivot Tables

Lecture 1: Table

Lecture 2: Creating Pivot Table

Chapter 7: Other Charts

Lecture 1: Pie Chart

Lecture 2: Area Chart

Chapter 8: Sharing and updating Report

Lecture 1: Sharing and updating Report

Chapter 9: Advance Topic: Time Calculation

Lecture 1: Financial Year to Date

Lecture 2: Lag data

Chapter 10: Fixing Errors

Lecture 1: Configuration error after changing/adding column in Google Sheets

Lecture 2: Date error

Chapter 11: Summary

Lecture 1: Summary

Chapter 12: BONUS MATERIAL

Lecture 1: Beautiful Color Code

Lecture 2: Google Data Studio Blog

Instructors

Loc Nguyen
Google Data Studio trainer

Rating Distribution

1 stars: 6 votes
2 stars: 7 votes
3 stars: 28 votes
4 stars: 115 votes
5 stars: 156 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu