Financial Reporting with Power BI (Batch-01)

Categories: Finance, Financial Reporting

Course Content

Class 01 -Introduction of Power BI Desktop for Financial Reporting | Explaining Financial Reporting Core Concepts | Exploring different Data Sources and Connections

FR with Power (Batch-01) – Session 01

02:22:24

Class 02 – Introduction of Power Query | ETL (Extract, Transform and Load) | Data Cleaning | Exploring the Databases | Text, Numeric and Date Tools in Power Query | Time Series vs Categorical Analysis | Conditional Columns

Class 03 – Power Query | Parameter | Append Queries | Select from Folder | Data Normalization Concept | Data Modeling

Class 04 – Data Modeling: Star & Snowflake Schema | Data Formatting | DAX Calculated Columns | Text Functions (LEFT, RIGHT, UPPER, LOWER, CONCAT)

Class 05 – Data Modeling: Star & Snowflake Schema | Data Formatting | DAX Calculated Columns | Text Functions (LEFT, RIGHT, UPPER, LOWER, CONCAT)

Class 06 – DAX Calculated Columns- Date Functions: DAY, MONTH, YEAR, DATEDIFF, TODAY, WEEKDAY, WEEKNUM | Text Functions: SUBSTITUTE, FIND, SEARCH, Dynamic RIGHT & LEFT | Logical Operators and Functions

Class 07 – DAX Measures: Implicit vs Explicit | Filter Context | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)

Class 08 – DAX Measures: Filter Flow Concepts | CALCULATE Measure | and Multi-Dimensional Analysis | Real World Scenarios

Class 09 – Advanced CALCULATE: ALL Conditions, Variables (VAR) and Practical Applications

Class 10 – FILTER Functions with Explicit Measures | Merging Measures into a Single Calculated Measure | Introduction to Iterator Functions (SUMX, COUNTX, AVERAGEX)

Class 11 –

Class 12 –

Class 13 –

Class 14 –

Class 15 –

Class 16 –