Curriculum
Module 1IntroductionRead moreShow less
- Introduction to Power BI
- Power BI Architecture
- Components of Power BI
- Relationship between Excel & Power BI
- Why power BI
- Downloading and installing Power BI
- Power BI Desktop &Power BI Services
- Building blocks of Power BI
- Power BI workspaces
- Power BI Editor
Module 2Power BI Data Sources & Data SetsRead moreShow less
- Power BI Data Sources
- Connecting to different database like sql server etc.
- Power BI File Sources
- Connecting to different file systems like flat file, excel etc.
- Power BI Web Sources
- Fetching data from different files
- Connecting to SQL SERVER Data Sources
- Working with import and direct query
- Connecting with Views, Stored Procedures etc
- Difference between Import and DirectQuery.
- Connected to Different web sources
- Merging Data from different data sources
- Connecting to JSON , XML etc
- Connecting to OData
- Connecting to WebAPI
- Editing Data Sources
- Editing Data Queries
- Data Sets
- Editing Datasets
- Applying Changes to Datasets
- Cleaning Datasets in Power
- Reverting changes to Datasets
- Relationship in Datasets
- Editing Relationship in Datasets
- Defining relationships between tables
- Creating custom table
- Connected to Different web sources
- Merging Data from different data sources
Module 3Power BI Editor FeaturesRead moreShow less
- Merge Queries and Append Queries
- Merging Data from diff sources
- Remove columns and split columns
- Choosing required columns in the data
- Working with different transformations
- Applied steps in query editor
- Working with hierarchies
- Creating index and custom columns
- Group By functionality in Query Editor
Frequently Asked Questions
Course Brochure
Get the Course Brochure in your Inbox.


