Duration: 2 Days
Course Overview
With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. This allows you to then produce detailed reports through a comprehensive range of visualizations.
The reward is to then be able to share those reports with your team inside or outside of your organisation, simply by publishing them to Power BI online service.
This course allows you to gain a thorough understanding of the complete Power BI cycle by working with real-world examples and will equip you with the necessary skills to start applying your knowledge straight away.
Course Content
Getting Started
• The Power BI process
• Launch Power BI Desktop
• Power BI Desktop views
Getting Data
• Connect to data sources
• Connect to an Excel file
• Connect to a CSV file
• Connect to a Web source
Transform Data in the Query Editor
• Clean data in the query editor
• Data types and replace values
• Fill data up and down
• Split column by delimiter
• Add conditional and custom columns
• Pivot data in the query editor
• Pivot and append data
• Insert a custom column
• Append data to a query
• Add an index column
Build a Data Model
• Relate tables in a data model
• Manage table relationships
Merge Queries
• Table join kinds
• Table merge process
Create Report Visualisations
• Create and format visuals
• Create map visuals
• Format map visuals
• Create chart visuals
• Format chart visuals
• Table, matrix and card visuals
• Control number formats
• Format chart visuals continued
• Use slicers to filter data
• Visuals from the marketplace
• Map latitude and longitude
• Export report data to Excel
Introduction to Calculated Column
• Two kinds of power BI formulas
• Add your first calculated column
• The SWITCH function
Introduction to DAX Measures
• COUNTROWS and DISINCTCOUNT
• DAX rules
• Introduction to the CALCULATE function
Introduction to Date Tables and Time Intelligence
• Standard vs. custom calendar
• Calendar: a special lookup table
• Time intelligence functions
• The TOTALYTD function
Introduction to Date Tables and Time Intelligence
• Create a hierarchy to “drill” data
• Add conditional formatting
Publish and Share Your Report Online
• Publish to the online Power BI Service
COURSE PREREQUISITES
There are no specific technical pre-requisites for this course, but a familiarity with Excel and/or Relational Database Technologies may be beneficial. The main pre-requisite is to have a basic understanding of your business’s need to collect, cleanse, analyse and deliver insights and visualisations of your business data.
To book this course please call
+44 (0) 1444 410296 or email: Info@kplknowledge.co.uk
Short Description