About Course
Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform.
Build a strong knowledge-based career platform in the Power Bi platform by getting enrolling for our institutes Power BI Course. Our Power BI training program will help you to master knowledge of the concepts such us modeling, visualizations, exploring data with dashboards, DAX functionality and many more.
What Makes Power BI Unique?
- Enables reports to be published securely
- Has the presence of rich personalized dashboards
- Integrates seamlessly with existing applications
- No specialized technical support required
- Supports Advanced Data services
- Can extract business intelligence rapidly and accurately
Course Curriculum
Introduction to Power BI Desktop
- Import data from diverse sources
- Creating dashboards and reports
- Installing Power BI desktop
- Adding matrix, column chart and cards
- Adding slicer
- Creating reports
- Adding pages
- Renaming pages
- Moving pages
- Importing excel and power view items
Discovering and loading data with Power BI Desktop
- Data sources
- File sources
- Databases
- Azure and other sources
- Loading data
- Web pages
- CSV files
- XML files
- Excel
- Relational databases
- Loading related tables
- Database options
- Microsoft SQL Server Analysis Services data sources, tabular data sources
- Refreshing query/all the queries in a Power BI desktop file
Transforming datasets
- Power BI desktop queries
- Editing data after data load
- Transforming data
- Query editor and ribbons
- Dataset shaping
- Filtering data
Data cleansing
- Changing datatype
- Replacing values
- Transforming column contents
- Grouping records
- Extending data
- Duplicating columns
- Splitting columns
- Merging columns
- Custom columns
- Merging data
- Appending data
- Adding contents of one query to another
- Pivoting and un pivoting tables
- Transposing rows and columns
- Managing queries
- Grouping queries
- Duplicating queries
Creating a data model
- Data modeling in Power BI desktop environment
- Data modeling ribbon
- Manipulating tables and columns
- CRM Overview
- Sorting data
- Designing a data model
- Creating relationships
- Creating relationships manually/automatically
- Deleting relationships
Adding measures to data model
- Basic aggregations in measures
- Multiple measures
- Cross table measures
- Advanced aggregations
- Filtering data in measures
- Simple filters and complex filters
Text based visualizations
- Switching to report view
- Tables
- Table granularity
- Matrix, cards, multirow cards
Charts in Power BI Desktop
- Creating a chart
- Chart modifications
- Column charts, line charts and pie charts
- Donut charts
- Funnel charts
- Water fall charts
Other types of visuals
- Maps
- Filled maps
- Tree maps
- Gauges
Filtering data
- Visual level filters
- Filtering different data types
- Advanced text filters
- Page level filters
- Report level filters
Using slicers
- Slicers
- Formatting slicers
- Using charts as slicers
Enhancing dashboards
- Text boxes
- Modifying Page background
- Images
- Adding shapes
- Organizing visuals on the page
- Exporting data from a visualization
POWER BI WEB
- POWER BI Dashboards
- Reports
- Datasets
- Content packs
- Work groups
- Gateways
- Q&A
- Insights
