Building Financial Dashboard in Google Data Studio
- 4.4
-
![]()
![]()
![]()
![]()
1 hour on-demand video
$
11.99
Brief Introduction
How to Build Dynamic Financial Dashboard in Google Data Studio From ScratchDescription
- 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.
Requirements
- Requirements
- Google Account
- Google Chrome
- Basic Excel/ Google Spreadsheet
Knowledge
- 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
Loc Nguyen
4.4 Raiting
Building Financial Dashboard in Google Data Studio
- 4.4
-
![]()
![]()
![]()
![]()
![]()
How to Build Dynamic Financial Dashboard in Google Data Studio From Scratch Learn from a Financial business intelligence analyst for a Group of more than 10 companies....
Logistic Regression in R Studio
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Logistic regression in R Studio tutorial for beginners. You can do Predictive modeling using R Studio after this course. After completing this course, you will be able to:...
Learn TradingView Pine Script Programming From Scratch
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Build your own indicators, signal generators and automate trading logic. TradingView is one of the most well known online charting platforms across the globe....
Creating New BigQuery Datasets and Visualizing Insights
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This is the second course in the Data to Insights specialization. Here we will cover how to ingest new external datasets into BigQuery and visualize them with Google Data Studio....
