DP-605: Develop Dynamic Reports with Microsoft Power BI (Live Online)

Overview

Unlock the full potential of dynamic reporting and data visualization with our comprehensive Microsoft Power BI course. Gain essential skills to retrieve, clean, and transform data from various sources, creating reports that are both insightful and impactful.

Master the art of creating semantic models, adding measures and calculated columns, and designing visually compelling reports tailored to your business needs. Whether you're a beginner or have prior experience with Power BI, this course provides in-depth knowledge on filtering techniques, workspace management, and performance optimization.

By the course's conclusion, you'll be proficient in crafting and managing dynamic reports that enhance decision-making and organizational efficiency.

Audience Profile: This course is ideal for data analysts, business intelligence professionals, and IT specialists aiming to advance their dynamic reporting skills with Microsoft Power BI. Managers and team leaders responsible for generating insights and making data-driven decisions will also find this course beneficial.

Prerequisites: Familiarity with basic data concepts and terminology is recommended. Some exposure to Power BI is beneficial but not mandatory.

Course Outline:

• Module 1: Get data in Power BI
  • Get data from files and relational data sources
  • Create dynamic reports with parameters
  • Get data from a NoSQL database and online services
  • Select a storage mode and resolve performance issues
• Module 2: Clean, transform, and load data in Power BI
  • Shape and simplify data structure
  • Evaluate and change column data types
  • Combine tables and profile data
• Module 3: Design a semantic model in Power BI
  • Work with tables, create a date table, and define data granularity
  • Work with relationships and resolve modeling challenges
• Module 4: Add measures to Power BI Desktop models
  • Create simple, compound, and quick measures
  • Compare calculated columns with measures
• Module 5: Add calculated tables and columns to Power BI Desktop models
  • Create calculated columns and learn about row context
• Module 6: Design Power BI reports
  • Design analytical report layouts and visually appealing reports
  • Select report visuals and work with KPIs
• Module 7: Configure Power BI report filters
  • Apply and configure filters using slicers
  • Learn advanced filtering techniques
• Module 8: Create and manage workspaces in Power BI
  • Distribute reports or dashboards and monitor performance
  • Develop a life cycle strategy and configure data protection
• Module 9: Manage semantic models in Power BI
  • Use a Power BI gateway, configure refresh settings, and promote models

Syllabus

Taught by

Tags