Building Financial Dashboard in Google Data Studio
933 students enrolled
Building Financial Dashboard in Google Data Studio
How to Build Dynamic Financial Dashboard in Google Data Studio From Scratch
933 students enrolled
Current price: $69.99
Original price: $99.99
Discount:
30% off
5 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
Featured review
Ticiano Carvalho
(
20 courses,
4 reviews
)
a year ago
I am accountant and I was trying to find a model that I can trust that my codes wont be copied more than numbers that I show. With this tool I can do it and with ideas here explained I surely will apply for a real world soon! Thank you!!
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
+
–
Scorecard
1 lecture
06:09
Scorecard
06:09
+
–
Report Navigation
1 lecture
04:07
Pages & Nagivation
04:07
+
–
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