Microsoft Power BI: Advanced Data Analysis and Visualisation

Overview

Power BI is a cloud-based business analytics service, helping you stay up-to-date with the information that matters to you. It helps create live operational dashboards from on-premises and cloud data in one central location that you can access across a range of devices.

Syllabus

• Introduction to Power BI
Overview of Power BI and its components
Installation and setup
Connecting to data sources
• Advanced Data Transformation
Using Power Query for data cleansing
M language essentials
Advanced data shaping techniques
• Data Modeling in Power BI
Building robust data models
Creating relationships between tables
Using calculated columns and measures
• DAX for Data Analysis
Basics of DAX (Data Analysis Expressions)
Advanced DAX functions
Using DAX for time intelligence
• Creating Advanced Visualizations
Customizing visuals
Using slicers and filters
Advanced charts and visual elements
• Power BI Service
Publishing reports to Power BI Service
Creating dashboards
Sharing and collaborating on reports and dashboards
• Power BI Mobile
Accessing Power BI on mobile devices
Designing mobile-optimized reports
• Power BI and Cloud Integrations
Integrating with Azure services
Using Power BI with cloud-based data sources
• Security and Data Governance
Managing permissions and roles
Row-level security techniques
• Best Practices and Optimization
Report performance optimization
Best practices for Power BI setup and maintenance
• Case Studies and Real-World Applications
Analyzing business case studies using Power BI
Practical exercises and hands-on projects
• Course Wrap-up
Review and Q&A
Final project presentations and feedback

---

Taught by

Marc Espos

---

Subjects

Business