Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analytics & Advanced Reporting Using Power BI
Welcome
What to expect in this course (0:12)
About the instructor
Course Structure & Resources (6:52)
Data Analytics I | Import & Combine Data
Introduction to Data Modeling (27:25)
Power BI Overview | Desktop, Online, Mobile (14:00)
Overview of Power BI interface (17:22)
Getting Familiar with Power Query (16:35)
Import Data from Excel (3:18)
Basic Data Transformations & Importance of Data Types (52:55)
Import single CSV files (7:59)
Combining multiple CSV files (32:07)
Combine multiple Excel files (19:42)
Get Data from Web (23:01)
Import and Combine multiple tabs / worksheets (30:05)
Data Analytics | Mastering Data Transformations -
Power Query best practices
Apply Basic Data Transformations
Apply Advanced Data Transformations
Data Source optimization technique
How to fix query errors
Test your learning
Data Modeling
Case Study overview
Data Relationships - Link data from alternative sources
Optimize Your Data Model for Reporting - Best Practices
Prepare for Time Intelligent reports
Test your learning
The Power of DAX language
Why it is important to get an understanding of DAX
Calculated Columns vs DAX Measures
Implicit Measures vs Explicit Measures
DAX Functions you need to know
Understanding Filter context
Time Intelligence | Track Business Trends Through Time
Using Quick Measures
Best Practices
Test your Learning
Create interactive reports using Power BI
Upgrade your reporting using Power BI: Analyze & Visualize your Data
Power BI Reports - apply best practices
Apply Report Filters
Manage Interactions between Visuals
Create hierarchies based on business needs
Key Influencers Visual
Q & A : Ask a question about your data
Using Custom Visuals
Creating Mobile friendly dashboards
Latest Power BI visuals & features - March 2020
Test Your Learning
Power BI Online
Publish your reports online
Workspaces
Building Dashboards
Sharing Dashboards and Reports
Connect Power BI model with Excel
Test Your Learning
Wrap up
Course recap
Your feedback
What's next
Why it is important to get an understanding of DAX
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock