Microsoft BI Training Courses

Use Microsoft’s range of BI (Business Intelligence) tools to analyse data sets quickly, provide visual insights via reports and dashboards and to share that data with colleagues.

Choose from Power BI or Get and Transform to learn how to get the most from your data using Microsoft BI.

Microsoft BI Training Courses
Home > Training > Microsoft BI Training Courses > Introduction to Power BI Desktop Data Modelling
Find Your Course

Introduction to Power BI Desktop Data Modelling

1 Day

This Introduction to Power BI Desktop Data Modelling course covers the basics needed to enable users to analyse data and create interesting visual reports.  It is purely aimed at users new to Power BI.

Microsoft's Power BI is a cloud-based business analytics service that allows you to gather, shape, analyse and visually explore data.  The Power BI Desktop is where you CREATE data models and build visual reports.  Once reports are created most use the Power BI Service i.e. App.PowerBI.com to create Dashboards they can share with others to view and interact with, via browsers or on mobile devices.

Download PDF

What will you learn?

At the end of this Introduction to Power BI Desktop Data Modelling course, delegates will be able to:
  • Use Power BI to analyze your data
  • Access, prepare and create basic transformations of your data
  • Use data modeling and exploration
  • Create rich, interactive reports and visualizations

Audience?

Anyone wanting to create data models and reports in Power BI and who would like to expand their skills in data analysis language (DAX – data analysis expressions).

Course Contents


What is Microsoft Power BI?

  • The Power BI environment
  • Working with the Fields and Visualisation Panes
  • Using Report View and Data View

Data Sources

  • Using Excel, CSV/Text files, Folders and SQL server as data sources

Power Query

  • The role of Queries in data import
  • Extract, Transform & Load (ETL)
  • Working with Applied Steps
  • Exploring some transformations
    • Unpivot
    • Split columns
    • Extract
    • Group

Replacing Values

  • Calculated columns
  • Append and Merge Queries
  • Understanding Applied steps limitations

DAX Introduction

  • Calculated Columns & Measures
  • Evaluation Context
  • COUNTROWS and DISTINCTCOUNT
  • SUMX and CALCULATE

Visualisations

  • Adding visualisation to a Report Canvas
  • Controlling visualisation interactions
  • Drill Down and Drill Through
  • Custom Tooltips

Calendars

  • Importance of calendars
  • Creating a calendar via DAX

Time Intelligence

  • Time Intelligence Functions
  • Comparison with Previous periods
  • Aggregations over time

Creating a Data Model

  • Model view
  • Creating and managing relationships
  • Cross filter directions
  • Inactive relationships

Preparing for Publishing

  • Adding bookmarks
  • Creating action buttons

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable.  These may be either paper based or in Adobe pdf format or a combination thereof. Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.
“Excel 365 Intermediate course review "Fantastic course! Thanks you Marko" - Laura "Really enjoyable and informative course, would recommend to everyone!" - Matt "Very entertaining and relevant to the job, Easy to follow!" - Cath Abcam - January 2020  ”Excel 365 Intermediate course review

Prerequisites

Delegates should have a good knowledge of using Excel analytical skills.


Additional Information

NOTE:   We only offer this Introduction to Power BI Desktop Data Modelling course on a private in-house basis. The suggested course duration is a guideline.  Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.