Anyone who is familiar with Microsoft Office applications and need to work with data to connect, process and analyse data to produce suitable output at all levels within an organisation.
It is assumed that attendees are familiar with Excel with charts and pivot table concepts and have an understanding of basic data concepts.
• Power BI Concepts and Overview
• Introduction to Main Features
• Imports
• Visualisations
• Filters and Queries
• Reports
• Data Sources
• Data Types and Properties
• Import and Enter Data
• Get Data and Query Editor
• Introducing the Query Editor
• Combining Data Sources
• Append Queries
• Merge Data Tables
• Working with Relationships in Data
• Filters
• Clean, Trim, Format and Replace
• Split Column or Extract Using Delimiters
• Column from Example
• UnPivot
• Custom Calculated Columns
• Histograms
• Overview of Data Visualisations
• Table and Matrix Views
• Conditional Formats
• Charts
• Slicers
• Visualisation Drilling for Data
• Analytics Lines
• Forecast
• Measures
• KPI Visualisation
• Date Hierarchies
• Quick Measures
• Clustering
• Report Elements and Options
• Working with Pages
• Visual and Filter Settings
• Edit Interactions
• Bookmarks
• Report Themes
• Buttons and Q&A
• Export Power BI Data to CSV
• Create a Power BI Template