📊 Data Science & Analytics
Power BI
This comprehensive Power BI course teaches end-to-end skills for data professionals, analysts, and business users to ext...
17
Views
Sections
1. Introduction to Power BI662 views
Overview of the Power BI ecosystem, editions, core components, and a guided walkthrough to create your first report.
10 topics (10 versions)
1.1What is Power BI
172
1.2Power BI Desktop Overview
177
1.3Power BI Service Overview
67
1.4Power BI Mobile and Embedded
195
1.5Licensing and Editions
51
1.6Installation and Environment Setup
1.7Power BI Interface Tour
1.8Creating Your First Report
1.9Project and Learning Path Overview
1.10Key Concepts and Terminology
2. Connecting to Data Sources478 views
Learn to connect Power BI to a broad set of data sources, authenticate securely, and choose the right connectivity mode for your needs.
10 topics (10 versions)
2.1Import vs DirectQuery vs Live Connection
128
2.2Connecting to Excel and CSV Files
2.3Connecting to Relational Databases
139
2.4Connecting to Cloud Data Sources
95
2.5Connecting to Online Services and APIs
116
2.6Configuring On-premises Data Gateway
2.7Credentials and Privacy Levels
2.8Handling Incremental and Large Loads
2.9Best Practices for Source Connections
2.10Troubleshooting Connection Issues
3. Power Query and Data Transformation677 views
Master data ingestion and shaping using Power Query: cleaning, transforming, combining queries, and using M code for repeatable ETL.
10 topics (10 versions)
3.1Power Query Editor Fundamentals
166
3.2Applied Steps and Query Settings
101
3.3Data Type Detection and Conversion
161
3.4Text, Number and Date Transformations
121
3.5Splitting, Merging, and Appending Queries
128
3.6Pivoting and Unpivoting Data
3.7Using Parameters and Templates
3.8Introduction to M (Power Query Formula Language)
3.9Query Folding and Performance
3.10Reusable Dataflows and Shared Queries
4. Data Modeling Fundamentals561 views
Build robust and efficient semantic models: relationships, cardinality, star schemas, normalization considerations, and sizing strategies.
10 topics (10 versions)
4.1Tables and Relationships
67
4.2Star Schema vs Snowflake
64
4.3Cardinality and Cross-filter Direction
146
4.4Primary Keys and Lookup Tables
98
4.5Calculated Columns vs Measures
187
4.6Creating and Using Hierarchies
4.7Designing a Date Table
4.8Normalization and Flattening Strategies
4.9Managing Model Size and Storage
4.10Model Documentation and Best Practices