AKTU Financial Analytics Using Power BI (BMBAFM02) Syllabus PDF – MBA (Business Analytics) 3rd Semester

Course Objectives

1. Understand the financial analysis concepts and visual analytics using Power BI.
2. Equip learners with the skills to extract, clean, and transform financial data for analysis.
3. Enable students to design interactive dashboards for financial reporting and KPIs.
4. Apply Power BI tools to analyze profitability, liquidity, valuation, risk, and cost management.
5. Develop the ability to interpret financial performance for strategic decision-making.

Unit 1: Introduction to Financial Analytics and Power BI Basics (8 Hours)

Introduction to financial analytics, Scope and applications in business decision-making, Types of financial data (structured/unstructured), Overview of Microsoft Power BI ecosystem, Power BI Desktop interface and features, Data import methods (Excel, CSV, databases), Data modeling basics and relationships, Creating your first financial dashboard

Unit 2: Financial Data Preparation and Transformation (8 Hours)

Data cleaning using Power Query, Handling missing, duplicate, and inconsistent financial records, Date and time intelligence in financial data, Introduction to DAX (Data Analysis Expressions), Calculated columns and measures for financial KPIs, Financial data modeling best practices, Building hierarchies (fiscal year, quarter, month), Creating time-based financial metrics (YoY, MoM)

Unit 3: Financial KPIs and Visualization Techniques (8 Hours)

Key financial ratios: profitability, liquidity, solvency, efficiency, ROI/ROE, Dynamic visuals for income statements, balance sheets, and cash flow reports, Trend analysis and variance reports using line/bar charts, Financial KPI cards and conditional formatting, Drill-down and drill-through for financial insights, Forecasting and scenario analysis in Power BI, Building waterfall charts for profit/loss analysis, Creating dashboards for CFO/finance executives

Unit 4: Budgeting, Forecasting, and Risk Analysis (8 Hours)

Budget vs Actual analysis using slicers and filters, Cash flow forecasting and projection models, Working capital analysis and dashboards, Risk identification using financial indicators, Sensitivity analysis using parameters, Data alerts and Power BI service for report sharing, Financial benchmarking and competitor comparison, Compliance and audit dashboards

Unit 5: Advanced Analytics and Business Use Cases (8 Hours)

Using What-If parameters for financial simulations, Embedding Power BI reports in Excel and PowerPoint, Integration with Excel, SQL Server, and cloud sources, Introduction to Power BI Service and publishing reports, Role-based dashboards for accountants, analysts, and managers, Case study:

Financial performance analysis of a listed company, Capstone project: Build a complete financial dashboard, Ethical considerations and best practices in financial analytics

Course Outcomes

Suggested Readings

Text Books

1. Financial Analytics with Power BI by Lukas Ruebbelke (eBook / blog-based resources)
2. Analyzing Data with Power BI and Power Pivot for Excel by Alberto Ferrari and Marco Russo, Publisher: Microsoft Press
3. Financial Statement Analysis by K.R. Subramanyam, Publisher: McGraw-Hill Education Tools & Platforms:

• Microsoft Power BI Desktop (Free version)
• Power BI Service (cloud)
• DAX Guide (https://dax.guide)
• Microsoft Learn – Power BI modules
• Kaggle/Excel datasets for finance case studies