Building Financial Dashboard in Google Data Studio
4.3 (201 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
845 students enrolled

Building Financial Dashboard in Google Data Studio

How to Build Dynamic Financial Dashboard in Google Data Studio From Scratch
4.3 (201 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
845 students enrolled
Created by Loc Nguyen
Last updated 5/2019
English
English [Auto-generated]
Current price: $64.99 Original price: $99.99 Discount: 35% off
3 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • Google Account
  • Google Chrome
  • Basic Excel/ Google Spreadsheet
Description
  • 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.



    Who this course is for:
    • Google Sheets Users
    • Excel Users
    • Xero Users
    • MYOB Users
    • Accountants
    • Data Analysts
    • Business Owners
    • Managers
    Course content
    Expand all 22 lectures 01:07:37
    + Creating Data Source from Financial Report
    2 lectures 07:32
    Setting up Financial database in Google Sheets correctly
    05:49
    Connecting Google Data Studio to Google Sheets
    01:43
    + Time series Chart
    4 lectures 14:35
    Creating Time Series Chart
    03:37
    Adding Filter Control & Time Range Selection
    03:11
    Calculated Fields
    02:03
    + Tables & Pivot Tables
    2 lectures 07:16
    Table
    04:23
    Creating Pivot Table
    02:53
    + Other Charts
    2 lectures 06:31
    Pie Chart
    02:54
    Area Chart
    03:37
    + Sharing and updating Report
    1 lecture 01:55
    Sharing and updating Report
    01:55
    + Advance Topic: Time Calculation
    2 lectures 08:53
    Financial Year to Date
    05:53
    Lag data
    03:00
    + Fixing Errors
    2 lectures 04:29
    Configuration error after changing/adding column in Google Sheets
    01:30
    Date error
    02:59