Building Financial Dashboard in Google Data Studio

Name: Building Financial Dashboard in Google Data Studio
Rating: 4.4 (317 reviews)

How to Build Dynamic Financial Dashboard in Google Data Studio From Scratch

Last updated 4/2021

English

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

12 sections • 22 lectures • 1h 7m total length

Creating Time Series Chart3:45
Create time series charts in Google Data Studio by converting daily data to monthly metrics, including revenue, expense, net profit, and net profit margin, using month field and year-month formatting.
Adding Filter Control & Time Range Selection3:13
Add a filter control and a time range selector to the report to view profit and loss by branch (for example Sydney) and set dates for the current financial year.
Formatting and Designing the Dashboard5:44
Format and design a Google Data Studio dashboard, set size and theme, style revenue, expense, and net profit charts with last-year comparison and forecast, and create a profit margin field.
Calculated Fields2:03

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.