Power BI Desktop Essentials - 1 Day course
Course Description
Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources. This course provides a solid introduction to using Power BI Desktop to connect to data, create visualisations, query the data and publish reports. It is designed to introduce users to report generation and updating and sharing of existing Power BI reports.
1 day
€375.00
Prerequisites
Participants should have at least Intermediate Excel and database user skills. They need:An understanding of basic data concepts
Ability to create and format chart outputs
Ability to create formulas using standard aggregate functions
Learning Objectives
Participants will learn:Power BI Desktop concepts and main features
Data sources compatible with Power BI Desktop
Connecting to data with Power BI Desktop
Exploring data visualisations
Creating new columns using DAX formula
Creating and publishing reports
Getting Started with Power BI
An Introduction to Power BIWorking with Power BI Desktop Files
Connecting to Data Sources with Power BI Desktop
Creating a Report with Visualisations
Doing More with Visualisations
Working with Data examples
Exercise 1 - Importing data from CSV files.Exercise 2 – Using multiple datasets imported from Excel
Exercise 3 – Automatically updating data from files in a Folder
Exercise 4 – Un-pivoting Data using Power Query
Relational Databases and Power BI
Creating Data Tables in Power BI from ExcelCreating Lookup Tables
Creating and Managing Relationships between Tables
Creating Visuals based on Linked Data
Introduction to Data Analysis Expressions - DAX
The concept of DAXCreating new columns
Creating quick and New Measures
A Closer Look at Visualizations
Matrixes, Tables, and ChartsMaps
Cards, Gauges, and KPIs
Slicers
Introduction to the Power BI Online Services
Getting Started in Power BI OnlinePublishing reports to Power BI Online
Web View and Phone View
Creating a Dashboard and Sharing the Dashboard
Power BIPower BI Data VisualisationsPower BI DesktopPower BI OnlineMicrosoft Power BIMS Power BIDAX