Power BI (2 day course)

Summary

Microsoft Power BI is a powerful data and analytics reporting tool that enables anyone to visualise and analyse data with greater speed. This 2-day course covers the essential skills in Power BI, Extracting, Transforming and Loading data into the Data Model, then Visualising it with a rich set of Graphics, Charts & Dashboards. We also cover the use of DAX in Excel and how that can feed data to Power BI and be combined in Dashboards & Visualisations

Venue details:  
Start date & time:  
16 October 2019 09:30
End date & time:  
17 October 2019 16:30
Price: €546.58  (€519.25 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
20.00
CPD hours:  
13.00
Speaker details
First nameLast name
Mullan Training

Description

Product type:  
Category:  

Who should attend?

You should have a good working knowledge of Excel, and familiarity with Excel Functions like SUMIF and VLOOKUP. People with Database, Programming or other BI experience will be qualified for the course even if they don’t have Excel experience

Course overview

What is Microsoft Power BI?

  • Understanding the Power BI environment.

 Exploring Power BI Desktop

  • Working with the Fields and Visualisations Panes
  • Using Report View to create visualisation
  • Using Data View to sort and format data

Understanding Data Sources in Power BI Desktop

  • Importing a variety of data sources into Power BI Desktop
  • Connecting to Excel Workbooks, Access Databases, CSV files
  • Other data locations

Creating a Data Model in Power BI Desktop

  • Understanding the Data Model
  • Using Relationships View
  • Creating Many-to-One relationships
  • Understanding Filter Propagation

Visualisations Workshop using Power BI Desktop

  • Adding visualisations to the Report Canvas Understanding and controlling interactions between visualisations
  • Using Drill Down and Drill Through on visualisations creating and using Hierarchies

Introduction to DAX in Power BI Desktop

  • Exploring the importance of custom calculations within the Data Model.
  • Creating Calculated Columns & Measures.
  • Understanding Evaluation Context.
  • Using CountRows and DistinctCount Functions.

Sharing Your Dashboards & Content Packs

  • How to Share your Interactive Power BI Dashboards with people both inside and outside your organisation.
  • Sharing using Power BI, Web, PowerPoint and others.

Data Refresh

  • Manually refreshing data.
  • Creating a Scheduled Refresh.

Key learning outcomes 

  • Produce visually compelling, intuitive Dashboards & presentations of your corporate data with Power BI.
  • Blend data from multiple sources into a single data stream for analysis.
  • Create basic ‘measures’ and ‘calculated columns’ and use them to manipulate data in the data model.
  • Build various reports / dashboards using the extensive range of charting tools.
  • Share reports / dashboards with colleagues and people outside of the organisation.