Face to face / Online public schedule & onsite training. Restaurant lunch included at STL venues.
From £495 List price £650
This one day course is ideal for those looking to create an outstanding Power BI reports design based on best practice, high performance, efficiency, and high level of transparency and readability for their report audience. And for those looking to incorporate brand/company design to Power BI reports.
Prerequisites:
Attendance of the Power Bi Reporting Course or a good knowledge of how to create report visuals in Power BI Desktop

Power Bi Desktop report design considerations
Consistency across all report pages
Brand/company design rules
Clarity and readability
How design options affect the reports performance
Planning report design for efficiency
Use design tricks to emphasise important information
Find the right balance for your design
Report design workflow
Due diligence
Avoid repeating steps
Create the design for future reports and for sharing with colleagues
Choose the right colour palette for the reports
Follow your company’s design rules
Create a colour palette to match your company’s colours
Use the colour palette for consistency
Understand how colours affect the audience
The traffic light colours (RAG) signals and symbolic
Contrast and accessibility colours
Create design elements in another application
Use PowerPoint to build Power BI design elements to:
-Improve report performance
-Get a much higher variety of design options
-Obtain consistency across report pages and reports
-Layout design elements to emphases information
-Incorporate Images, logo, and icons in the background for more flexibility and faster load speed
Create templates for efficiency and consistency
Build templates for visuals designs for efficiency and consistency
Save, distribute, and reuse templates
Themes
Build a theme for your organisation
Use company fonts and set font size
Setup the colour palette as a theme
Save, distribute, and reuse Themes
Design performance
Use the Performance Analyser to avoid slow performance from design elements
Arguably, the most experienced and highest motivated trainers.
Training is held in our modern, comfortable, air-conditioned suites.
Modern-spec IT, fully networked with internet access
A hot lunch is provided at local restaurants near our venues:
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Browse the sample menus and view joining information (how to get to our venues).
Available throughout the day:
Regular breaks throughout the day.
Contains unit objectives, exercises and space to write notes
Available online. 100+ pages with step-by-step instructions
Your questions answered on our support forum.
|
|
| Next date | Location | Price |
|---|---|---|
| Wed 30 Sep | Bloomsbury | £495 |
| Mon 26 Oct | Online | £495 |
| Wed 28 Oct | Bloomsbury | £495 |
| Wed 25 Nov | Online | £495 |
| Fri 27 Nov | Bloomsbury | £495 |
| Wed 23 Dec | Bloomsbury | £495 |
And 25 more dates...
Loading content...

Excellent
Mott MacDonald
Data Engineer
The 2-day Power BI course I attended was the best software training event I have attended.
"The trainer, Jens, was obviously hugely passionate and knowledgeable about the software. ... Lunch at the local Italian restaurant in Bloomsbury was very nice too, lots of comments the portions were BIG....
The course also provided a huge reference manual for my future use and a support forum for 2 years which I anticipate will come in very useful as I already have a list of new questions to ask since completing the course."
Tutorials and discussions on MS Office
MS Office tips to save you time
MS Office shortcut keys for all versions
Handy info on industry trends
Latest news & offers
Loading content...
Below are some extracts from our Power BI Report Designer manual.
What is Power BI? a data analytics and visualisation tool which has 4 main component parts: **Pull data in from different sources Manipulate and refine the data in Power Query Create charts and other visuals from the data in Power BI Desktop Publish report out to Power BI server**
Power Query avoids having to manually cleanse and reshape your data source by saving all previous steps
• Many data sources
• Transforming
• Shaping & modeling
• Measures
• Calculated columns
• Python
• Themes
• RLS creation
Every week/month Process data more productively -can spend more time on visualisations those steps are carried out automatically
• Welcome page as a 'Home Page'
• Too much content could overwhelm audience
• Use new 'Navigator' tools to be more customer-focused
• More economical use of visual elements
• meet targets and forecast growth
• What will your audience see at the end?
Conditional Formatting
Aim: To apply rule to gauge so Fill Colour turns green when target is exceeded and red if not
• Go to Format icon > Colours > Fill Colour > fx button
• Set ‘Format Style’ to ‘Rules’
• For ‘What field should we base this on’, select the value field being used in the gauge
• Set 1st rule: >=80,000 and <200,000 Green
• Set 2 nd rule >0 and <80.000 Red. Click OK
Custom Tooltip
1. Create a new page named ‘Tooltip page’
2. In the Format icon under Page Information turn on ‘Allow use as Tooltip’
3. In Canvas settings under Type check it says ‘Tooltip’. For a larger ‘canvas’ select ‘Custom’ and set width and height e.g. 400px by 400px
4. Click back on the Field Well icon. Now create a ‘Donut’ visual
5. Select the chart to which you want to attach the tooltip visual
6. In the Format icon go to General > Tooltip and set Page to ‘Tooltip page’
7. Now test that it works by hovering over the chart for each column
Top N Filter
Aim: To apply a Top band of categories according to a performance measure e.g. Top 5 Products by Extended Price (EP)
1. Create Table visual based on Product by EP
2. In the Filter Pane, select Top N
3. Show Items: Top 5
4. By Value: Extended Price
5. Click ‘Apply’
Old way to create summary reports:
1. Use a LOOKUP function to match ID no. from Fact table to Lookup table
2. Populate Salespersons’ names in Fact Table
3. Create Pivot Table to summarise Salespersons’ Total Sales
Create DATA MODEL as an alternative
1. ‘Get Data’ from different data sources
2. Select ‘Model View’
3. Check relationship is showing a ‘One to Many’ Cardinality
Call for assistance
We will call you back