Microsoft Power BI for Beginners & Excel Users

Overview

Dive into a course initially recorded live, making it engaging and interactive. You won't just be passively learning; you'll feel like you're right there in the room with participants from the corporate world and learning solutions to REAL problems.

Syllabus

• Introduction to Power BI
Overview of Power BI features and interface
Installation and setup of Power BI Desktop
Understanding Power BI service and Power BI mobile
• Connecting and Importing Data
Data sources supported by Power BI
Importing data from Excel
Connecting to live data sources
• Data Transformation and Cleaning
Using Power Query Editor
Applying transformations: filtering, sorting, and pivoting data
Handling data types and missing values
• Data Modeling
Understanding relationships between tables
Creating calculated columns and measures using DAX
Best practices for data modeling
• Creating Visualizations
Introduction to built-in Power BI visualizations
Customizing visuals for better insights
Using slicers and filters
• Designing Interactive Reports
Building interactive reports and dashboards
Managing report layouts and themes
Implementing bookmarks and page navigation
• Sharing and Collaboration
Publishing reports to Power BI service
Sharing reports and dashboards within organizations
Understanding Power BI licensing and access management
• Power BI and Excel Integration
Exporting Power BI reports to Excel
Using Excel data in Power BI reports
Comparing Power BI and Excel features
• Practical Case Studies
Solving real-world business problems with Power BI
Group project: Build a report from start to finish
Presentations of group findings and solutions
• Conclusion and Next Steps
Recap of key concepts and skills learned
Advanced resources and continued learning opportunities
Course feedback and Q&A session

Taught by

Ali Asghar Noorani

Subjects

Business