Microsoft Power BI: Advanced Data Analysis and Visualisation

Overview

Master the fundamentals of Power BI and learn how to gather, transform, and visualise data with ease.

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

Tags