(English) How to Build Company Financial Reporting Dashboard with Google Data Studio - Grow Your Business with Data & Business Intelligence Webinar Series
Training Duration : 3 hours 52 minutes
Watch Promo
For Credit Card Payment, click Orange Enroll Button Above this Sales Page. πππ
For Online Bank In, click this link π https://www.learnabee.com/p/bank
For FAQ, click this link π https://www.learnabee.com/p/faq
Everything you need to know about How to Build Company Financial Reporting Dashboard with Google Data Studio
πClick here to sign up (RM49)
- Unlimited Download of Sample Raw Data (for practice)
- Unlimited Copying Template / Sample Dashboard (for practice & reference)
- Unlimited Replay
- Unlimited Download of Presentation Slides & Notes
- Certificate of Completion to manually claim your CPD/CPE points.
- Introduction of workshop flow
- What is Google Data Studio?
- Benefits of Google Data Studio
- How to start using Google Data Studio?
- Get your data set ready
- Connect your data
- Themes & layout
- Creating P&L report
- Header, text, linking pages, report level
- Time series chart
- Date control filter
- Net profit margin: Creating fields from existing ones
- Control filter by branch
- Score cards
- Revenue analysis
- Duplicate page
- Table with bars
- Area chart
- Pivot table
- Pie chart & end of revenue analysis
- Expense analysis
- Adding data to Google Sheets
- Refreshing fields in Google Data Studio
- Time series chart with 2 metrics (represent CGS and operating expenses)
- Linking pages
- Balance sheet
- Overview of charts that can be used and review of previous concepts (data adding, refreshing fields)
- Pie chart with optional metrics
- Asset analysis
- Overview of asset analysis report
- Cash Flow Statement
- Overview of cash flow statement
- Time series chart with breakdown by branch
- Part 7: Accounts Receivables Aging Dashboard
- Purpose: record that shows the unpaid invoice balances along with the duration for which theyβve been outstanding. This report helps businesses identify invoices that are open and allows them to keep on top of slow paying clients.
- Data, header, score card
- Aging analysis using combo chart
- Receivables maturity & delayed receivables
- Complete report using table, pagination
- Overview of completed report
- Conclusion
Your Instructor
Course Curriculum
-
StartPreparing the data (3:34)
-
StartConnecting data (2:03)
-
StartThemes & Layout (2:33)
-
StartHeader, text, linking pages, report-level (5:59)
-
StartTime Series chart (6:57)
-
StartDate control filter (3:20)
-
StartCreating new fields in Google Data Studio (3:14)
-
StartControl filter (by branch) (1:56)
-
StartScore cards (6:36)
-
StartDuplicate page (1:06)
-
StartCreate table with bars (3:28)
-
StartArea chart (1:50)
-
StartPivot table (2:12)
-
StartPie chart and end of revenue analysis (2:38)
-
StartAdding data to Google Sheets and refreshing in Google Data Studio (3:53)
-
StartTime series chart with 2 metrics (1:33)
-
StartLinking pages (0:50)
-
StartOverview of Balance Sheet (6:39)
-
StartPie chart (optional metrics) (1:38)
-
StartAsset analysis report (8:48)
-
StartCashflow statement (5:11)
-
StartAging Dasboard (data, header, score cards) (9:12)
-
StartAging Analysis. (4:41)
-
StartReceivables Maturity and Delayed Receivables (4:20)
-
StartAging Complete Report, pagination (4:44)
Frequently Asked Questions
Sign Up Now ... See you "inside" the paid area soon !
We highly encourage you to pay via credit card for instant access to the content.
However, you have the option to pay via online bank in method, Click Here for Instruction to Pay Through Bank
Hi, My name is EvannaMiss8. I am a One Leg Kick , Happy go Lucky Organiser & Producer of Webinars & Online Training for Professionals, Directors & Management
If you are still blur blur about this webinar, no worries ya ... you may contact me directly using any of the below methods
Email: [email protected]
Whatsapp: +6012 203 8046
Facebook: https://www.facebook.com/learnabeeOfficial/
Bee Happy, Learn Online ...
Important Note: If you want to download the Certificate of Completion at the end of this course, please make sure the FULL NAME you key in is 100% Accurate ya ...