In today’s world, making informed decisions is the key to business success. Power BI gives you the opportunity to enter the world of data visualisation and analysis. From the initial installation through to creating interactive dashboards, this comprehensive training course will equip you with the essential skills for strategic information management. You will explore each Power BI module in depth, building a solid foundation in installation, data modelling, visualisation, and creating powerful reports. You will also learn key concepts such as filtering data, using query formulas, making columns dynamic, creating charts and pivot tables, and building dashboards and reports.
Cross-cutting
Big Data
30 hours
Power BI
Big Data
30 hours
Introduction
Objectives
-
To learn how to effectively Install and configure Power BI.
-
To master data modelling, including the creation of measures and relationships between tables.
-
To design powerful visualisations, such as charts, pivot tables, and maps.
-
To understand how to create and share interactive dashboards.
-
To explore the use of visual objects, data segmentation and widget creation.
Table of Contents
TEACHING UNIT 1. POWER BI INSTALLATION
1. Installation and Launch
2. Connecting data to Power BI
3. Data Filter
4. Data View
TEACHING UNIT 2. DATA MODELLING
1. Introduction to data modelling
2. Development of measures
3. Creation and relationships between tables
4. Creating columns and calculated measures
5. Pivoting Columns
6. Query formulas
TEACHING UNIT 3. DATA VISUALISATION
1. Creating Charts
2. Pivot tables
3. Data segmentation
4. Use of visual objects
5. Shapes and text boxes
6. Images
7. Matrices and tables
8. How to make a speedometer
9. Maps
10. Slicers
11. How to change colours
TEACHING UNIT 4. DASHBOARDS
1. Using the dashboard
2. Share Dashboards
3. Add Widgets
4. How to create reports
5. Panel Settings
6. Dashboard Questions and Answers (Q&A)
More related courses
Cross-cutting
Cross-cutting
Cross-cutting