Data Modelling using Power BI
Overview
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualisations, the Power BI Service, and the Power BI Mobile App. It starts by introducing you to Business Intelligence concepts, building a report, and dashboard, moving on to importing and modelling data. You will also learn how to create and manage interactive data visualisations.
Course Objectives
To become proficient in Power BI, to be able to create and manage complex Power BI reports, and dashboards. This Power BI course aims to equip participants with the skills to efficiently import, transform, and visualize data, utilizing components like DAX for effective analysis. It also covers advanced features, security measures, and integration with Microsoft 365 applications, fostering the ability to design and deploy impactful BI solutions.
Content
Introduction to Power BI
- Overview of Power BI
- Components and workflow
Power BI Desktop Data Transformation
- Power Query Editor
- Importing, cleaning, and transforming data
Power BI Desktop Modelling
- Creating relationships between tables
- DAX (Data Analysis Expressions) basics
- Calculated columns and measures
Power BI Desktop Visualization
- Building basic and advanced visualizations
- Customizing visualizations
- Using slicers and filters
Implementing the Power BI Service
- Publishing reports to Power BI Service
- Creating & managing dashboards
Connecting to Excel Data
- Importing data from Excel
- Maintaining live connections to Excel files
Collaborating with Power BI Data
- Sharing reports and dashboards
- Working with Power BI workspaces
- Using Power BI apps
Connecting Directly to Data Stores
- Connecting to databases and online services
Power BI Developer API
- Overview of Power BI API
- Embedding Power BI content
- Customizing Power BI with APIs
Power BI Mobile App
- Accessing and interacting with reports on mobile devices
- Offline capabilities and notifications
Course summary video
You will learn how to
- Master data transformation using Power BI Desktop.
- Understand and implement data modelling in Power BI Desktop.
- Create effective visualizations in Power BI Desktop.
- Utilize the Power BI Service for sharing and collaboration.
- Connect and import data from Excel into Power BI.
- Connect directly to various data stores for real-time analysis.
- Understand and use the Power BI Developer API.
- Use the Power BI mobile app for on-the-go data access and analysis.
- … and much more.
Audience
This course is aimed at SQL Server report creators who are interested in alternative methods of presenting data. Essential to have a good understanding of Excel before attending this course.
Classroom and Virtual training options
Online Course Materials
Duration
2 Days or 4 x 3 Hour Sessions
Contact Us
We’ll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.