Microsoft Power BI Introduction Training Course
Table of Contents
Course Overview
Our Microsoft Power BI Introduction training course helps you extract, analyse and comprehend large quantities of data – ensuring that you can present data in a logical manner and make informed business decisions. Microsoft Power BI (Business Intelligence) is a user-friendly report-based analytical tool that is transforming the way that businesses read their performance data.
This two-day, hands-on course assumes no previous knowledge of Power BI and will show you how to link and model data in Power BI and then create and share visual reports that reveal data insights.
Power BI Introduction Five Key Topics
- Creating Power BI data models
- Understanding table relationships
- Creating engaging visuals
- Understanding the role of DAX formulas
- Publishing and sharing dashboards
Training Course Details
Course Duration : 2 days
Course Availability : Monday – Saturday
Course Types : Group booking, 1-2-1 sessions, Bespoke and Public Courses
Training Times : Our courses run from 09:30 to 16:30, course registration 09:00 to 09:30, refreshments available throughout the day. A buffet lunch is available – please discuss with the team.
Facilities : A relaxed environment, air conditioned training rooms, note pads, pens and unlimited access to our online course materials.
Power BI Training Course Details
Course Location : Face to face group/public and onsite training available. Virtual training courses available.
Class Size : As a guide we recommend class sizes to be no more than eight.
Virtual / Online training Format : Teams or Zoom.
Tailored Course Content : Our Power BI course can be tailored to your requirements – Get In Touch
Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.
Centre and Services
Comfortable and modern facilities
Unlimited access to our online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft and CPD courses available
On completion of Microsoft Power BI Introduction
- Understand the Power BI workflow
- Connect to various data sources
- Shape and combine data using the Query Editor
- Create relationships in the Data model
- DAX formulas in Power BI
- Creating visuals on report pages
- Designing well presented reports
- Publishing and sharing your dashboards
Course Outline
- What is Power BI and when do we use it?
- Power BI Desktop
- The Power BI service
- Importing data
- Visualisations
- Filters and queries
- Reports and dashboards
- Data sources to which Power BI can connect
- Different data sources: Files, Databases and the Web
- Data types and properties in Power BI
- Connecting to files
- Importing Excel files
- Publishing to Power BI from Excel
- Data Refresh
- Introducing the Query Editor
- Data transformations
- Applied Steps
- Removing Columns and Rows
- Data Type Changes
- Filters
- Combining data sources in the Query Editor
- Appending and Merging
- Group, Split and Duplicate data
- Unpivoting Excel data
- Adding Columns
- Creating Conditional Columns
- Understanding the data model
- Working with relationships in Power BI
- Viewing Relationships
- Creating Relationships
- Working with Related Tables
- Join Types
- Creating and using Hierarchies
- Cardinality
- Cross Filter Direction
- Why do we need DAX?
- Functions
- Calculated Columns
- Using the DIVIDE function
- Using the FORMAT function
- Cross table calculations using the RELATED function
- Measures
- Introduction to the CALCULATE function
- Introduction to iterator functions, SUMX
- Managing your Measures
- Quick Measures
- Calculated Tables
- Fact tables and Dimension tables
- Date Table Rules
- Setting the Date Table
- Automatic Date Table
- Time Intelligence Formulas and Measures
- Power BI Reports: Page Layout and Formatting
- Multiple pages
- Table and matrix visualisations
- Working with charts
- Applying conditional formatting
- Cards, Gauges and KPI’s
- Geo-data and maps
- Filters
- Slicers and timelines
- Power BI Themes
- Create and deploy a custom theme
- Changing the font size for all visuals and pages
- Changing the number format for visuals
- Inserting Pictures, Text Boxes and Shapes
- Using DAX formulas on Cards to display the current filter value
- Publishing Reports
- Publish to Web
- Publish to the Power BI service
Is this Power BI Introduction Course for You?
Give us a call, our admin team will be delighted to assist in making sure you are on the correct course.
