4.9 (520 reviews)
Power BI Essentials
Power BI provides tools to perform data analysis and output results in visual reports. This course provides an in-depth, hands-on introduction to the Microsoft Power BI tool using data from Excel spreadsheets, databases and websites to create interactive reports. You will learn to
connect and use data from multiple sources
transform data into workable data sets
build powerful interactive visuals
This instructor-led course will teach you how to get data from almost any source and present it in a meaningful, visually appealing, and easy-to-understand format using Power BI's abundant features including how to create comprehensive interactive dashboard-style reports.
Course Overview
Audience:
The course has been designed for new users of Power Bi who wish to develop interactive and visually appealing reports.
Prerequisites:
Participants must be familiar with Microsoft Excel including creating charts.
Learning Outcomes
- Connecting a data source to Power BI
- Creating Visualisations
- Querying and shaping data
- Using the Query Editor
- Working with visual interactions
- Creating Reports
Course Content
Overview of Power BI
- Overview of Business Intelligence and Power BI
- Power BI Desktop, Power BI Service, Power BI Mobile
- Getting started with Power BI Desktop
- Data Sources
Power BI Desktop
- Interface
- Visualizations and Fields panes
- Power Query Editor
- Getting data from data sources
- Excel
- SQL database
- Online data services - Uploading Excel data to Power BI
- Working the the views - Report View, Data View and Model View
Transforming, Cleansing and Shaping Data
- Opening Power Query
- Removing rows from the top
- Using First Row as header
- Removing columns
- Choosing relevant column data types
- Renaming columns
- Cleansing data
- Adding Year column for filters
- Filtering data
- Unpivoting data
- Removing duplicates
- Copying queries
- Merge and Append queries
- Organising queries
- Checking column quality and data profiles
Power BI Data Model
• Using the Data model
• Relationships
• Adding calculations (Measures)
• Creating calculated columns (DAX)
Visualizations
• Creating and working Visualizations
• Chart types
- Bar chart
- Column chart
- Line chart
- Pie charts
- Map
- Matrix
- Bubble map
• Basic formatting of Visualizations
• Creating a Table Visualization
Power BI Reports
• Designing a report
• Adding pages to a report
• Adding text boxes and shapes to a report
Visual Interactions
• Turn interactions on/off
• Interacting by Filtering
Delivery Options
 |
Classroom sessions are delivered at a nominated location (Private courses only). Inclusions: |
Full Day Sessions: Half Day Sessions: |
 |
Live online sessions are instructor-led in a virtual environment, providing hands-on instruction and practical activities for participants. Participants can see the instructor screen and interact with the instructor and other participants. Instructor can assist participants on their screen if necessary. Participants can join a session from any location using the Course Invitation. There is no need for software just a computer with an internet connection and a browser. Public sessions are conducted through Live Online. Inclusions: |
Full Day Sessions: Half Day Sessions Times:
|
Power BI Essentials
Quickly find meaningful insights within your data that help you make better business decisions. Create rich, interactive reports with visual analytics at your fingertips
Brochure