Course outline
- Connect Power BI with company Database / Flat file
- ETL using power Query
- Data Modeling in Power BI
- Create Data Table and relationships
- Data preparation for trial balance
- Segregate chart of accounts of detailed financial modeling
- Advanced DAX functions for financial highlights
- Advance time intelligence function for running total, YTD, QTD, MTD etc
- Create Automatic Balance Sheet from the trail balance as per business KPI
- Prepare Income Statement ( P/L) through trial balance as per business KPI
- Do ratio analysis for the business highlights