PBI-RB: Using Power BI Desktop – Data Analysis and Report Builder

Become an EPIC Affiliate

To view the class schedule you need to become an Affiliate

  • Largest “Guaranteed To Run” public technical training schedules available
  • Easy to become an Affiliate – no charge or fee
Become an EPIC Affiliate

already an Affiliate?  Login

About this Course

In this 2-day course we will dive deep into the realms of data analysis and visualization within the dynamic landscape of today’s data-driven businesses. In this course, we empower you with comprehensive knowledge and practical skills essential for thriving as a Microsoft Power BI Data Analyst. Throughout this program, participants will navigate through a diverse array of methods and industry best practices tailored for modeling, visualizing, and analyzing data using Microsoft Power BI. From accessing and processing data from various sources to crafting compelling visuals and reports, this course provides a robust foundation for mastering the intricacies of Microsoft Power BI.

Our curriculum is designed to equip you with the proficiency to create impactful reports and dashboards while efficiently managing and deploying them. By the conclusion of this training, you’ll emerge poised to unlock the full potential of Microsoft Power BI, ready to tackle data analysis, visualization, and reporting challenges head-on in your professional journey.

Join us and embark on a transformative learning experience that propels your expertise in the realm of data analytics.

Audience Profile

At Course Completion

By the end of this course, participants will:

  • Develop Comprehensive Reports: Acquire the skills to design detailed reports and dashboards that are both functional and visually appealing.
  • Master Data Visualization: Gain expertise in creating informative and engaging visualizations that succinctly convey the story behind the data.
  • Efficient Data Management: Understand how to manage, share, and deploy reports and dashboards effectively within Power BI.
  • Practical Application: Apply learned concepts through hands-on projects to real-world scenarios, enhancing your capability to make data-driven decisions.

Outline

Discover Data Analysis with Microsoft Power BI

  • Explore the roles in data analysis
  • Understand the tasks of a data analyst

Get Started Building with Power BI

  • Learn about Power BI services and applications
  • Create compelling visuals and reports

Get Data in Power BI

  • Connect to various data sources
  • Utilize Power Query for data cleaning and preparation

Data Models in Power BI 

  • Explore Power BI Models
  • Review and configure model relationships

Add Calculated Tables and Columns to Power BI Models

  • Writing DAX formulas
  • Generate calculated tables and columns
  • Explore row context and best practices for calculated columns

Introduction to DAX Time Intelligence Functions in Power BI

  • Explore date tables
  • Apply time intelligence functions
  • Conduct time-based analysis

Add Measures to Power BI Desktop Models

  • Create measures
  • Understand the difference between calculated columns and measures

Design Power BI Reports

  • Understand the structure of Power BI reports
  • Choose the most suitable visualizations for your reports
  • Create multiple page report

Configure Power BI Report Filters

  • Design reports with a focus on filtering
  • Use slicers and advanced filtering techniques

Enhance Power BI Designs for the User Experience

  • Create interactive reports featuring details, highlights, and navigation
  • Work with bookmarks and visual headers

Create and Manage Workspaces in the Power BI Service

  • Navigate the Power BI service effectively
  • Distribute reports and monitor usage

Create and Share Dashboards in the Power BI Service

  • Construct personalized dashboards featuring pinned visuals
  • Configure mobile views and real-time data

Prerequisites