Öppna kurser

Introduction to Power BI

This Introduction level Microsoft Power BI Training course will give you all the skills you need to jump-start your Power BI journey.

Utbildningsmål

It discusses in depth the industry-recognised steps from raw data to detailed analysis via five main stages:

  • Loading data into Power BI from a wide range of data sources, such as CSV and XLS files
  • Transforming data using Data Analysis Expressions (DAX), M, and Power Query languages
  • Creating and extending a comprehensive data model with DAX
  • Visualising data in Power BI desktop using built-in tools
  • Sharing and collaborating with the Power BI service or Power BI server

In this course, you will:

  • 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 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

Förkunskaper

There are no prerequisites for attending this course. However, it is recommended that participants have basic knowledge of Excel and data analysis.

Innehåll

Module 1: Power BI Overview

  • Visual analysis and visual analytics
  • Power BI Infrastructure
  • Loading Data
  • Introduction to Power BI Desktop

Module 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

Module 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

Module 4: Visualizing 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

Module 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

Module 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

Kursen levereras genom utbildningspartner: Learning Tree

Learning-Tree-Logo_horizontal.png


Delivering Value Beyond OMB's IT Spending Mandate, Learning Tree Launches New Technology Business Management (TBM) Training - Odisha Expo