Course Description

Power BI Data Essentials is an in-depth eight (8) hour course to allow individuals to understand the Power BI platform along with creating and publishing reports and generating useful visualizations from transformed data from various sources.

Who should consider taking this course?

• Data Professionals.
• Business Intelligence Professionals.
• Individuals that want to learn how to perform data analysis utilizing Power BI.
• Report developers who work with data from both cloud and on-premises sources.

Course Outline

• Introducing Power BI
  • Power Bi as Part of Power Platform
  • What is Power BI
  • Power BI Overview
• Get Starting Building with Power BI
  • Learn about Power BI services and applications.
  • Create compelling visuals and reports.
• Understand the different versions and services associated with Power BI
  • Power BI Desktop
  • Power BI Service
  • Power BI Mobile
• Understand the high-level flow of Power BI
  • Connect to data
  • Transform and model data
  • Create visualizations and reports
  • Publish reports
  • Distribute and Manage Reports
• Identify the building blocks of Power BI
  • Semantic Models
  • Visuals
• Accessing and Preparing Data
  • Power BI Desktop – Accessing Data
  • Power BI Desktop – Data Preparation
• Get Data in Power BI
  • Connect to various data sources.
  • Enhance data retrieval performance.
• Clean, Transform, and Load Data in Power BI
  • Utilize Power Query for data cleaning and preparation.
  • Profile columns and transform data types.
• • Understanding Power BI Data Models
  • Terminology
  • Introduction to Tables & Relationships
  • Introduction to Data Model Schemas
• Defining a Report
  • Power BI Reports
  • Overview of Report Objectives
  • Data-Driven Narratives
• Building power BI Desktop Reports
  • Working in Power BI Desktop
  • Creating Visuals
  • Formatting and Organizing Visuals
  • Sharing
• Data Modeling and Exploration
  • Power BI Desktop – Layout
  • Power BI Desktop – Data Exploration
• Data Visualization
  • Power BI Desktop – Data Visualization
• Collaboration
  • Power BI Service – Collaboration and Distribution
  • Power BI Mobile – Accessing Report on Mobile Device
  • Further Exploration – Power Platform
• Publish and Accessing Reports
  • Power BI Desktop – Creating a mobile view
  • Power BI Service – Publishing Report
  • Power BI Service – Building a Dashboard
  • Power BI Service – Storytelling with power BI within PowerPoint
• Create Dashboards in Power BI
  • Construct personalized dashboards featuring pinned visuals
  • Configure mobile views and real-time data
• Use DAX time Intelligence Functions in Power BI
  • Apply time intelligence functions
  • Conduct time-based analysis

Learner Outcomes

• Identify the different versions of Power BI and their purposes.
• Identify the Building Blocks of Power BI and Model Concepts.
• Distinguish the differences between Reports and Dashboards
• Understand Data Modeling
• Get Started with Data Visualization
• Develop Comprehensive Reports
• Efficient Data Management
• Practical Application