Course description
Microsoft Power BI: Visualisations
This one-day course is an introduction to the Microsoft power tools within Power BI for those who need to analyse, process and connect to with data in order to produce reports, interactive dashboards and visualisations at all levels within an organisation. It is assumed that attendees on the course are already working with data, are familiar with charts and PivotTable concepts. Delegates will be using Power BI Desktop.
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
SquareOne Training
With 30 years of experience in IT training, personal skills, and consultancy, SquareOne specialise in crafting and delivering exceptional industry leading training courses. Our extensive range of courses are tailored to cater to a diverse range of learning preferences and...
Case Studies
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.
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.