Search
START TYPING AND PRESS ENTER TO SEARCH




    Image

    Introduction to Power BI Training

    Introduction to Power BI Training
    This Introduction to Power BI Training will equip you with all the skills necessary to kick-start your Power BI journey. The course thoroughly covers the industry-recognized steps from raw data to detailed analysis across five main stages:

    - Loading data into Power BI from various data sources, including CSV and XLS files
    - Transforming data using Data Analysis Expressions (DAX), M, and Power Query languages
    - Creating and enhancing a comprehensive data model with DAX
    - Visualizing data in Power BI Desktop using built-in tools
    - Sharing and collaborating through the Power BI service or Power BI server

    Introduction to Power BI Training Objectives

    • Create interactive visualisations to deliver business insights.
    • Extract business intelligence by using DAX M and Power Query.
    • Share Datasets Reports and Dashboards in the Power BI Service.
    • Pre-format and import data from an Excel Report using Power Query and M.
    • Add value with measures calculated columns and calculated tables using DAX.
    • Import data from relational databases and integrate it with other data sources.
    • Profile
    • shape and filter tables to prepare for analyses by fixing data issues.
    • Integrate data from CSV files and Excel Workbooks.
    • Explore and extend a Power BI data model.

    Need Assistance Finding the Right Training Solution

    Our Consultants are here to assist you
    Arrange a consultation

    Key Point of This Training Program

    • Introduction to Power BI Training Prerequisites

      None.

    • Introduction to Power BI Training Delivery Format

      In-Person

      Online

    • Introduction to Power BI Training Outline

      Chapter 1: Power BI Overview
      Visual analysis and visual analytics
      Power BI Infrastructure
      Loading Data
      Introduction to Power BI Desktop
      Hands-On Exercise 1.1 Loading and Visualising data

      Chapter 2: Transforming Data
      Using Power Query to clean, transform and load data
      Profiling your data
      Resolve data quality issues
      Apply user-friendly names to Queries, tables, and columns
      Import data from an Excel formatted report
      Hands-On Exercise 2.1 Transforming Data with Power Query

      Hands-On Exercise 2.2 Appending, Merging, and Combining Queries

      Chapter 3: Creating a Data Model
      Understand the role of the Data Model in Power BI
      Create table relationships
      Understand Cardinality and Cross Filtering
      Discuss Star and Snowflake schema
      Create a Date Dimension
      Build a Data Model from multiple Data sources
      Hands-On Exercise 3.1 Creating a Data Model

      Chapter 4: Visualising your Data
      Discuss Report settings
      Choosing the right visualisations
      Creating, formatting, and styling your reports
      Using Hierarchies and Drilldown
      Utilising Slicers and Filters
      Adding Custom Visualisations
      Hands-On Exercise 4.1 Creating Reports Part 1

      Hands-On Exercise 4.2 Creating Reports Part 2

      Hands-On Exercise 4.3 Creating Reports Part 3

      Chapter 5: Introduction to DAX, Calculated Columns and Measures
      Gain an Introduction to DAX
      Differentiate between Calculated Columns and Measures
      Create Calculated Columns
      Create Measures
      Understand Filter and Row context
      Understand the power of the Calculate function
      Hands-on Exercise 5.1 Introduction to DAX

      Optional Hands-on Exercise 5.2 Intermediate Level DAX

      Chapter 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)
      Discuss the Power BI Service and Power BI Server
      Understand the main components of the Power BI Service
      Publish a Power BI Project to the Power BI Service
      Share Reports
      Build and Share Dashboards
      Hands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service