
About this Course
Syllabus
About this Course
Power BI is a business intelligence and data visualization platform. It enables the creation of analytical reports and interactive dashboards using many different data sources.
The lesson covers the fundamentals of working with this platform, including creating a connection to various data sources, modeling and defining relationships between tables, and creating different visualizations.
Audience
The course is mainly intended for analysts, data scientists and BI people who want to intergrate Power BI in their daily work.
Prerequisites
Experience and course background in SQL and Excel
- Introduction to Power BI – main features and key benefits
- Downloading, Installing, and configuring Power BI
- Available Data Connectors
- Data Source Settings
- Connection Best Practices
- Refresh Settings
- Using the Query Editor
- Working with Text, Numeric and Date values
- Aggregating Results
- Pivot & Unpivot Data
- Merging & Appending Data Sets
- Hierarchies
- Understanding Database Normalization
- Data Tables vs. Lookup Tables
- Creating & Managing Table Relationships
- Active vs. Inactive Relationships
- Using Filter Flow
- Best Practices
- Basic Charts & Visuals in Power BI
- Conditional Formatting
- Formatting Options
- Filtering Options
- Using Matrix Visuals
- Filtering using Date Slicers
- Text Cards
- Geospatial Data and Maps
- Treemaps
- Line & Area Charts
- Drillthrough Filters
- “What-If” Parameters
- managing and viewing roles
- Best Practices