-
₹5000
-
Duration: 2 Months
-
Delivery mode: Online
-
Group size: Individual
-
Instruction language:
English,
Hindi,
Malayalam
-
Certificate provided:
No
1. Introduction to Power BI
Overview of Business Intelligence (BI)
What is Power BI?
Components of Power BI: Power BI Desktop, Power BI Service, Power BI Mobile
Power BI Workflow: Data Import, Data Modeling, Visualization, and Sharing
2. Getting Started with Power BI Desktop
Installing Power BI Desktop
Power BI Interface Overview
Connecting to Data Sources: Excel, CSV, SQL Server, Web Data, etc.
Data Loading and Data Transformation in Power Query Editor
3. Data Modeling in Power BI
Understanding Tables, Fields, and Relationships
Creating Relationships between Tables
Data Types and Formatting
Calculated Columns and Measures
Creating and Using DAX (Data Analysis Expressions) in Power BI
4. Data Transformation with Power Query
Introduction to Power Query
Data Cleaning: Removing Duplicates, Handling Missing Values, Filtering Data
Data Transformation: Merging, Appending, Grouping, Pivoting, and Unpivoting Data
Advanced Data Transformation Techniques
Custom Functions and Conditional Columns
5. Data Visualization and Reporting
Creating Basic Visuals: Bar Charts, Line Charts, Pie Charts, etc.
Working with Slicers and Filters
Creating Interactive Dashboards
Customizing Visuals: Formatting, Conditional Formatting, Themes
Using Advanced Visuals: Maps, Gauges, KPIs, TreeMaps, etc.
Creating and Managing Report Pages
6. Advanced Data Analysis with DAX
Introduction to DAX: Syntax and Functions
Common DAX Functions: SUM, AVERAGE, COUNTROWS, etc.
Time Intelligence Functions: Year-to-Date, Month-to-Date, Running Totals
Creating Calculated Tables and Columns
Working with DAX for Complex Calculations and Measures
7. Power BI Service
Publishing Reports to Power BI Service
Creating and Managing Workspaces
Sharing and Collaborating on Reports
Setting Up Data Refresh and Schedules
Using Power BI Mobile