Course description
Microsoft Power BI: Visualisations
SquareOne Training's Power BI Visulations course is designed for professionals who need to analyse, process, and connect to data in order to create reports, interactive dashboards, and visualisations using Microsoft Power BI.
This course is aimed at those already familiar with data analysis and concepts like charts and PivotTables, the course will focus on Power BI Desktop. Participants will learn how to connect to various data sources using Query Editor, create dynamic visualisations (including charts, tables, gauges, and maps), and apply interactivity and advanced formatting techniques such as conditional formatting, matrices, cards, and KPIs. The course can be tailored to meet specific business needs, so feel free to contact us for any additional topics you would like to cover.
Upcoming start dates
Suitability - Who should attend?
At the end of the course delegates will be able to:
- Connect to a variety of data sources using Query Editor
- Create Visualisations (Charts, Tables, Gauges, Maps)
- Create Charts with Interactivity
- Filter data with various tools
- Apply advanced formatting and visualisations with conditional formatting, matrices, cards, gauges and KPIs
Training Course Content
Overview of Power BI Desktop
Overview of a pbix file and introduction to:
- Views: Reports (visualisations); Tables and Relationships
- Visualisations: Treemap; Funnel; Map; Clustered Column Charts
- Page Tab
- Focus Mode
- Tool tips
Creating a Basic report
- Getting data
- Basic visualisations
- Shapes, text boxes and images
Data sources and Query Editor
Connecting to:
- Access databases
- Excel / text files
- Websites and web services
- Pasting data
- Filtering rows
- Manipulating columns
- Working with data types
Filtering data
- Slicers
- Visualisation level filters
- Hierarchies and re-usable Hierarchies
- Drill with Dates
Formatting visualisations
- The formatting panes
- Conditional formatting
Charts
- Working with charts
- Specific chart type issues
- Grouping and binning
Other types of visualisations
- Working with matrices
- Working with cards
Maps
- Geo Data
- Data Categorisation and Maps
Dashboard visualisations
- Gauges
- KPIs
Advanced Filters and Views
- Grouping and pivoting
- Grouping with Bins
- Filter combinations
- Creating new columns
Drill-down
- Interactions
- "See records" feature
Parameters
- Creating parameters
- Filtering by parameter
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
Expenses
Training Locations
Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead, Aberdeen and Ireland.
Closed courses can also be delivered in European countries such as Austria, Belgium, Denmark, Greece, France, Finland, Hungary, Italy, Ireland, Netherlands, Norway, Portugal, Spain, Poland, Sweden, Switzerland and off shore.... Either in English or local languages
Request info
Welcome to SquareOne Training – Where Your Learning Journey Takes Centre Stage! For over 30 transformative years, SquareOne Training has been the beacon of excellence in IT and personal skills training. We started our journey when computers were just making...
Case Studies
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Excel Templates For Mexichem
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.