Disclaimer: This course is independently developed and not affiliated with Microsoft. It covers concepts and skills that closely align with the objectives of Microsoft’s DP-605: Prepare and visualize data with Microsoft Power BI training, making it a strong preparatory or complementary learning experience.
This One-Day beginner-level custom course empowers data professionals with essential skills to prepare, model, and visualize data using Power BI and Microsoft Fabric. Participants will learn to connect to diverse data sources, clean and transform data with Power Query, build semantic models for scalable reporting, design interactive Power BI reports, harness Copilot for faster insights, and understand how Microsoft Fabric supports end-to-end analytics workflows.
No prior Power BI experience is required, but familiarity with basic data concepts is recommended.
Get Started Building with Power BI: Learn the core components of Power BI, its workflow, and how to create compelling, interactive reports from scratch.
Get Data in Power BI: Explore how to retrieve data from files, databases (relational and NoSQL), online services, and Azure Analysis Services. Learn to optimize performance and resolve import errors.
Clean, Transform, and Load Data in Power BI: Use Power Query & copilot to shape data: change types, rename objects, pivot/unpivot, and profile columns for deeper analytics.
Configure a Semantic Model: Organize complex data into intuitive structures that support scalable, insightful reporting and visualization.
Design Power BI Reports: Apply best practices for report layout, interactivity, and filtering to ensure clarity and usability across audiences.
Get Started with Copilot in Power BI: Boost productivity by using Copilot to build models, generate visuals, and query data using natural language.
Introduction to End-to-End Analytics Using Microsoft Fabric: Understand how Microsoft Fabric unifies data workflows—from ingestion to AI-ready insights—within a single platform.