Course Contents

    Financial Business Analysis: Python | Excel | BI |Cloud

    Module 1: Get Started with Microsoft Data Analytic

    • Data analytics and Microsoft
    • Getting Started with Power BI

    Module 2: Prepare Data in Power BI

    • Get Data from Various Data Sources
    • Optimize Performance
    • Resolve Data Errors

    Module 3: Clean, Transform, and Load Data in Power BI

    • Data Shaping
    • Enhance the Data Structure
    • Data Profiling

    Module 4: Designing a Data Model in Power BI

    • Introduction to Data Modeling
    • Working with Tables
    • Dimensions and Hierarchies

    Module 5: Create Measures using DAX in Power BI

    • Introduction to DAX
    • DAX Content
    • Advanced DAX

    Module 6: Optimize Model Performance

    • Optimize the data model for Performance
    • Optimize DirectQuery Models
    • Create and manage Aggregations

    Module 7: Create Reports

    • Design a Report
    • Enhance the Report

    Module 8: Create Dashboards

    • Create a Dashboard
    • Real-time Dashboards
    • Enhance a Dashboard

    Module 9: Create Paginated Reports in Power BI

    • Paginated Report Overview
    • Creating Paginated reports

    Module 10: Perform Advanced Analytics

    • Advanced Analytics
    • Data Insights Through AI Visuals

    Module 11: Create and Manage Workspaces

    • Creating Workspaces
    • Sharing and Managing Assets

    Module 12: Manage Datasets in Power BI

    • Parameters
    • Datasets

    Module 13: Row-level Security

    • Security in Power BI

    * Course topics and duration may be modified by the instructor based upon the knowledge and skill level of
    the course participants.