Course description
Import data from different external sources (CSV files, Excel, Access, etc.) to explore and visualise them in pivot tables, pivot charts and Power BI.
Why enrol on this course?
Who can take this course?
Employed, self-employed or unemployed people who want to improve their skills.
Free course
Subsidised training, at no cost to the student.
Online course
Study from home with a flexible format.
Certified course
When you finish you will be able to certify the training you have completed.
Course content
CHAPTER 1. POWER BI PRACTICAL COURSE
1.1 DESCRIPTION AND FEATURES OF THE TOOL. MAIN USES
CHAPTER 2. PREPARING THE DATA
2.1 IMPORTING DATA WITH POWER BI
2.2 METHOD FOR RUNNING QUERIES
2.3 DATA RELATIONSHIPS
2.4 DATA MODELLING
CHAPTER 3. POWER QUERY
3.1 INTRODUCTION
3.2 DATA CLEANING
3.3 MERGING QUERIES
3.4 CHANGING THE DATA SOURCE
3.5 CREATING AND MODIFYING COLUMNS
3.6 VIEW OPTIONS
3.7 OTHER OPTIONS
CHAPTER 4. DESIGNING REPORTS IN POWER BI
4.1 INTRODUCTION
4.2 TABLES
4.3 EDITING A TABLE
4.4 MATRICES
4.5 CREATING HIERARCHIES
4.6 CARDS
4.7 FILTERS
4.8 COLUMN CHARTS
4.9 OTHER TYPES OF CHARTS
4.10 ANALYSING DATA
4.11 MAPS
4.12 CHOROPLETH MAPS
4.13 OTHER MAPS
4.14 CONDITIONAL FORMATTING
4.15 GROUPS
4.16 THEMES
4.17 VISUAL INTERACTIONS
4.18 TEXT SLICERS
4.19 DATE AND NUMBER SLICERS
4.20 SLICER SCOPE
4.21 AI VISUALS
4.22 OTHER POWER BI VISUALS
4.23 ADDING OTHER CONTROLS
4.24 WORD CLOUD VISUAL
4.25 INFOGRAPHIC DESIGNER VISUAL PAGE
4.27 HELP
4.28 POWER BI OPTIONS
CHAPTER 5. DESIGN TOOLS
5.1 INTRODUCTION
5.2 DRILLTHROUGH PAGE
5.3 TOOLTIP
5.4 SELECTION PANE
5.5 BOOKMARKS
5.6 MEASURES VS COLUMNS
5.7 IMAGES, SHAPES AND TEXT BOXES
5.8 BUTTONS
5.9 MANAGING AND CREATING ROLES
5.10 PERFORMANCE ANALYSER
5.11 MOBILE LAYOUT
5.12 PREVIEW FEATURES
5.13 FIELD PARAMETERS
CHAPTER 6. DAX
6.1 INTRODUCTION
6.2 CREATING A MEASURES TABLE
6.3 BASIC FUNCTIONS
6.4 X FUNCTIONS
6.5 CALCULATE AND FILTERS
6.6 CONDITIONALS
6.7 TEXT
6.8 DATES
6.9 PARAMETERS
6.10 CREATING THE DATE TABLE
6.11 RELATED FUNCTION
6.12 USERELATIONSHIP FUNCTION
6.13 TIME INTELLIGENCE FUNCTIONS
6.14 INFORMATION FUNCTIONS
6.15 OTHER WAYS TO USE MEASURES
6.16 DAX TO CREATE TABLES
6.17 CALCULATION GROUP
6.18 DAX QUERY VIEW
6.19 NEW VISUAL CALCULATION
CHAPTER 7. PUBLISHING
7.1 INTRODUCTION
7.2 PUBLISHING A REPORT
7.3 POWER BI VERSIONS
7.4 PUBLISHED REPORT OPTIONS
7.5 MY WORKSPACE
7.6 SEMANTIC MODEL
7.7 SCORECARDS
7.8 DASHBOARDS
7.9 WORKSPACES
7.10 POWER BI ON MOBILE
CHAPTER 8. POWER BI TIPS AND TRICKS
8.1 MEASURES TABLE
8.2 HIDING PAGES
8.3 LESS IS MORE
8.4 SWITCHING VISUALS WITH BOOKMARKS
8.5 PLAY AXIS IN A TOOLTIP
8.6 DOUBLE CONTROL TO CHANGE AN IMAGE
8.7 MEASURES TO DISPLAY BY LEVEL
8.8 MORE INFORMATION WHEN EXPORTING A VISUAL
8.9 GOING TO A TAB
8.10 POWER QUERY TRICKS
8.11 TAB ORDER
8.12 REUSING REPORTS
8.13 STORE IN THE SAME PLACE
8.14 CONDITIONAL FORMATTING ON A CARD
8.15 SLICING SOME VISUALS BUT NOT OTHERS
8.16 USING POWER AUTOMATE IN POWER BI
8.17 HIDDEN SLICERS
8.18 NON-DATE HIERARCHY IN CHARTS
8.19 CURRENCY CONVERTER
ADDITIONAL MATERIAL
1.1 DESCRIPTION AND FEATURES OF THE TOOL. MAIN USES
CHAPTER 2. PREPARING THE DATA
2.1 IMPORTING DATA WITH POWER BI
2.2 METHOD FOR RUNNING QUERIES
2.3 DATA RELATIONSHIPS
2.4 DATA MODELLING
CHAPTER 3. POWER QUERY
3.1 INTRODUCTION
3.2 DATA CLEANING
3.3 MERGING QUERIES
3.4 CHANGING THE DATA SOURCE
3.5 CREATING AND MODIFYING COLUMNS
3.6 VIEW OPTIONS
3.7 OTHER OPTIONS
CHAPTER 4. DESIGNING REPORTS IN POWER BI
4.1 INTRODUCTION
4.2 TABLES
4.3 EDITING A TABLE
4.4 MATRICES
4.5 CREATING HIERARCHIES
4.6 CARDS
4.7 FILTERS
4.8 COLUMN CHARTS
4.9 OTHER TYPES OF CHARTS
4.10 ANALYSING DATA
4.11 MAPS
4.12 CHOROPLETH MAPS
4.13 OTHER MAPS
4.14 CONDITIONAL FORMATTING
4.15 GROUPS
4.16 THEMES
4.17 VISUAL INTERACTIONS
4.18 TEXT SLICERS
4.19 DATE AND NUMBER SLICERS
4.20 SLICER SCOPE
4.21 AI VISUALS
4.22 OTHER POWER BI VISUALS
4.23 ADDING OTHER CONTROLS
4.24 WORD CLOUD VISUAL
4.25 INFOGRAPHIC DESIGNER VISUAL PAGE
4.27 HELP
4.28 POWER BI OPTIONS
CHAPTER 5. DESIGN TOOLS
5.1 INTRODUCTION
5.2 DRILLTHROUGH PAGE
5.3 TOOLTIP
5.4 SELECTION PANE
5.5 BOOKMARKS
5.6 MEASURES VS COLUMNS
5.7 IMAGES, SHAPES AND TEXT BOXES
5.8 BUTTONS
5.9 MANAGING AND CREATING ROLES
5.10 PERFORMANCE ANALYSER
5.11 MOBILE LAYOUT
5.12 PREVIEW FEATURES
5.13 FIELD PARAMETERS
CHAPTER 6. DAX
6.1 INTRODUCTION
6.2 CREATING A MEASURES TABLE
6.3 BASIC FUNCTIONS
6.4 X FUNCTIONS
6.5 CALCULATE AND FILTERS
6.6 CONDITIONALS
6.7 TEXT
6.8 DATES
6.9 PARAMETERS
6.10 CREATING THE DATE TABLE
6.11 RELATED FUNCTION
6.12 USERELATIONSHIP FUNCTION
6.13 TIME INTELLIGENCE FUNCTIONS
6.14 INFORMATION FUNCTIONS
6.15 OTHER WAYS TO USE MEASURES
6.16 DAX TO CREATE TABLES
6.17 CALCULATION GROUP
6.18 DAX QUERY VIEW
6.19 NEW VISUAL CALCULATION
CHAPTER 7. PUBLISHING
7.1 INTRODUCTION
7.2 PUBLISHING A REPORT
7.3 POWER BI VERSIONS
7.4 PUBLISHED REPORT OPTIONS
7.5 MY WORKSPACE
7.6 SEMANTIC MODEL
7.7 SCORECARDS
7.8 DASHBOARDS
7.9 WORKSPACES
7.10 POWER BI ON MOBILE
CHAPTER 8. POWER BI TIPS AND TRICKS
8.1 MEASURES TABLE
8.2 HIDING PAGES
8.3 LESS IS MORE
8.4 SWITCHING VISUALS WITH BOOKMARKS
8.5 PLAY AXIS IN A TOOLTIP
8.6 DOUBLE CONTROL TO CHANGE AN IMAGE
8.7 MEASURES TO DISPLAY BY LEVEL
8.8 MORE INFORMATION WHEN EXPORTING A VISUAL
8.9 GOING TO A TAB
8.10 POWER QUERY TRICKS
8.11 TAB ORDER
8.12 REUSING REPORTS
8.13 STORE IN THE SAME PLACE
8.14 CONDITIONAL FORMATTING ON A CARD
8.15 SLICING SOME VISUALS BUT NOT OTHERS
8.16 USING POWER AUTOMATE IN POWER BI
8.17 HIDDEN SLICERS
8.18 NON-DATE HIERARCHY IN CHARTS
8.19 CURRENCY CONVERTER
ADDITIONAL MATERIAL