Financial Reporting with Power BI (Batch-01)

Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Class 01 – Power BI for Financial Reporting | Core Concepts | Data Sources & Connections

  • FR with Power (Batch-01) – Session 01
    02:22:24

Class 02 – Power Query Introduction | ETL & Data Cleaning | Text, Numeric & Date Tools | Time Series vs Categorical Analysis | Conditional Columns

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

Class 04 – Data Modeling | Data Formatting | DAX (Calculated Columns & Text Functions)

Class 05 – Data Modeling | Data Formatting | DAX (Calculated Columns & Text Functions)

Class 06 – DAX Calculated Columns | Date Functions | Text Functions | Logical Operators & Functions

Class 07 – DAX Measures (Implicit vs Explicit) | Filter Context | Aggregation Functions

Class 08 – DAX Measures | Filter Flow Concepts | CALCULATE | Multi-Dimensional Analysis

Class 09 – Advanced CALCULATE | ALL Conditions | Variables (VAR) | Practical Applications

Class 10 – FILTER Functions | Combined Measures | Iterator Functions

Class 11 – Time Intelligence Functions | Handling Errors | Introduction Data Visualizations

Class 12 – Data Visualizations: Navigation Bar | Images, Cards and Visual Formatting | Line Chart, Bar Chart, KPI Chart, Table and Metrix Visual & Formatting | Report Level & TOPN Filters

Class 13 – Data Visualizations: Donut & Pie Charts, Visual Pages, Card Visuals | Slicers | Area Chart and Others | Gauge Chart | Area Chart

Class 14 – Data Visualizations: Custom Tooltips Option | Advanced Line Chart | Drill Up & Drill Down Through | Bookmarks | Page Navigation | Conditional Formatting

Class 15 – Data Visualizations: Advanced features of Visualizations | Power-BI Services Introduction | Data Refreshers | Row Level Securities | Credentials Assigned | Workspaces Assesses

Class 16 – SQL Queries Concepts | Data Fetching from SQL Database thoughout in PowerBI | Power Query and ETL for Financial Dashboard Data and Data Modelling | Dashboard Designing Techniques

Class 17 – Income Statement | Income Statement Composition | Revenue by Trend | Operating Expense | Calculated Measures and Designing | Charts Designing and Finalization

Class 18 – Advanced Calculated Measures & Functions | Balance Sheet | Statement of Financial Position Page Design | Data Visualization | Advanced Dashboard Design Concepts

Class 19 – Financial Dashboard Finalization & Publishing | Dashboard Deployment Best Practices | Power BI Services Overview (Data Refreshers) | RLS | Credential Management | Workspace Setup

Class 20 – Core Financial Reporting with Power BI & IA | Building Accounts Receivable Dashboards from Scratch with Advanced Techniques

Class 21 – Advanced Dashboard Design Strategies | Advanced Power Query Concepts with M-Code Techniques | Building Performance Analysis Dashboards from Scratch

Class 22 – Finalizing Performance Dashboards with Advanced Methods | Solving Real Financial Reporting Problems for Global Clients

Class 23 – Resume Building (ATS Compliant) | LinkedIn Optimization Strategies | Freelancing & Upskilling (Fiverr & Upwork) | Portfolio Website Development

Class 24 – Final Project Presentation Day