In today’s world, making informed decisions is the key to business success. Power BI It gives you the opportunity to delve into the world of data visualisation and analysis. From the initial set-up to the creation of dashboards interactive, this comprehensive course will equip you with essential skills in strategic information management. You will explore each module of Power BI in depth, building a solid foundation in installation, modelling of data, visualisation y creation on creating impactful reports. You’ll learn key concepts such as data filtering, query formulas, making columns dynamic, creating charts and pivot tables, building dashboards, and how to create reports.
Power BI
Introduction
Objectives
-
You will learn how to install and configure Power BI effectively.
-
You will master data modelling, including the creation of measures y relationships between the boards.
-
You’ll be able to design striking visualisations, such as charts and tables dynamic y maps.
-
You’ll learn how to create Interactive dashboards and share them with others.
-
You will explore the use of visual elements, data segmentation and the creation of widgets.
Table of Contents
TEACHING UNIT 1. INSTALLING POWER BI
1. Installation and commissioning
2. Connecting data to Power BI
3. Data filtering
4. Data view
TEACHING UNIT 2. DATA MODELLING
1. Introduction to data modelling
2. Creation of measures
3. Creating tables and the relationships between them
4. Creating columns and calculated measures
5. Optimise columns
6. Query formulas
TEACHING UNIT 3. DATA VISUALISATION
1. Creating charts
2. Pivot tables
3. Data segmentation
4. Use of visual aids
5. Shapes and text boxes
6. Images
7. Matrices and tables
8. How to create 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