Day 1
Module 1: Understanding Analytics & Business Intelligence (BI) Concept
This module will guide the candidate through the basics of Analytics. Learn about the Data & Analytics
- Data & Analytics
- Introduction to Business Intelligence
- Importance of Business Intelligence
- Overview of Self-Service BI
Module 2: Microsoft Power BI Introduction
- Power BI introduction and Overview
- Power BI Desktop – Installation
- Explain Power BI Desktop
- Power BI Screen Elements and Toolbars
Module 3: Connecting Power BI with Different Data Source
- Connect to CSV files in Power BI
- Connect to Excel in Power BI
- Connect to PDF in Power BI
- Connect to Web Page in Power BI
Module 4: Data Cleaning with Power Query
- Power Query Introduction
- Query Editor interface
- Column Transformations
- Combining Data: Append Query
- Combining Data: Merge Query
- Number, Date and Time Calculations
- Text Transformation
- Sorting & Filters Data
- Splitting & Merging Data
- Transforms Data
- Pivot and Unpivot Data
- Adding Columns
- M Built-in Function