Analyzing Data with Microsoft Power BI

Analyzing Data with Microsoft Power BI (DA-100)

Course Objectives

By the end of the programme, participants will be able to:

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets
  • Create paginated reports in Power BI

Course Outline

  • Data Analytics and Microsoft
  • Getting Started with Power BI
    Lab : Getting Started
    ▪ Getting Started

  • Get data from various data sources
  • Optimize performance
  • Resolve data errors
    Lab : Preparing Data in Power BI Desktop
    ▪ Prepare Data

  • Data shaping
  • Enhance the data structure
  • Data Profiling
    Lab : Transforming and Loading Data ▪ Loading Data

  • Introduction to data modeling
  • Working with tables
  • Dimensions and Hierarchies
    Lab : Data Modeling in Power BI Desktop
    ▪ Create Model Relationships
    ▪ Configure Tables
    ▪ Review the model interface
    ▪ Create Quick Measures
    Lab : Advanced Data Modeling in Power BI Desktop
    • Configure many-to-many relationships
    • Enforce row-level security

  • Introduction to DAX
  • DAX context
  • Advanced DAX
    Lab : Introduction to DAX in Power BI Desktop
    ▪ Create calculated tables
    ▪ Create calculated columns
    ▪ Create measures
    Lab : Advanced DAX in Power BI Desktop
    ▪ Use the CALCULATE() function to manipulate filter context
    ▪ use Time Intelligence functions

  • Optimze the model for performance
  • Optimize DirectQuery Models
  • Create and manage Aggregations

  • Design a report
  • Enhance the report
    Lab : Designing a report in Power BI
    ▪ Create a live connection in Power BI Desktop
    ▪ Design a report
    ▪ Configure visual fields adn format properties
    Lab : Enhancing Power BI reports with interaction and formatting
    ▪ Create and configure Sync Slicers
    ▪ Create a drillthrough page
    ▪ Apply conditional formatting
    ▪ Create and use Bookmarks

  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard
    Lab : Designing a report in Power BI Desktop - Part 1
    ▪ Create a Dashboard
    ▪ Pin visuals to a Dashboard
    ▪ Configure a Dashboard tile alert
    ▪ Use Q&A to create a dashboard tile

  • Paginated report overview
  • Create Paginated reports
    Lab : Creating a Paginated report
    ▪ Use Power BI Report Builder
    ▪ Design a multi-page report layout
    ▪ Define a data source
    ▪ Define a dataset
    ▪ Create a report parameter
    ▪ Export a report to PDF

  • Advanced Analytics
  • Data Insights through AI visuals
    Lab : Data Analysis in Power BI Desktop
    ▪ Create animated scatter charts
    ▪ Use teh visual to forecast values
    ▪ Work with Decomposition Tree visual
    ▪ Work with the Key Influencers visual

  • Creating Workspaces
  • Sharing and Managing Assets
    Lab : Publishing and Sharing Power BI Content
    ▪ Map security principals to dataset roles
    ▪ Share a dashboard
    ▪ Publish an App

• Parameters
• Datasets

  • Security in Power BI

Who Should Attend

Course Pre-requisites

Course Details

  • Course Title: Analyzing Data with Microsoft Power BI (DA-100)
  • Class Schedule: 20 -23 September 2021
  • Time: 9am to 5pm
  • Duration (Days): 4 days
  • Certification Exam: DA-100
  • Certification Body: Microsoft

Course Fee = RM2,800