MS Power BI
Text

Power BI - Gladiator Academy - Three of Five Modules

18 Lessons Easy

About this course

Welcome to Module Three - How to Analysis and Visualise Your Data with Power BI.

Course Structure

ONLY FOR LOGGED-IN USERS

Create Pie Chart & Treemap

You won’t be surprised to learn there are a variety of ways to develop visualisations.

ONLY FOR LOGGED-IN USERS

Slicer

To be able to give report users the filter data capability add a filter and in Power BI this is called a Slicer.

ONLY FOR LOGGED-IN USERS

Bar Chart with Line

On occasions you will want to present a visualisation with two different measures for example revenue and units in the same chart. The best option for this scenario is a combination chart. These charts display a line with different axes.

ONLY FOR LOGGED-IN USERS

Scatter Chart

Scatter charts are a powerful way to illustrate sales or unit sales versus revenue performance over time.

ONLY FOR LOGGED-IN USERS

Waterfall Visual

This type of chart is useful to show changes for a value over time.

ONLY FOR LOGGED-IN USERS

Guage, Card & KPI Visuals

Gauges, Cards, KPI visuals provide a historical numerical value. The number value indicates a trend over a period of how that, number has changed

ONLY FOR LOGGED-IN USERS

Colour Controls, Reference Lines and Borders

Power BI provides numerous formatting options to empower you to brand your reports to your organisation preferred style.

ONLY FOR LOGGED-IN USERS

Shapes, Textboxes and Images

Using shapes, text, images can help branding and help readers to focus on key points.

ONLY FOR LOGGED-IN USERS

Page Layout and Formatting

Page layout & formatting are important considerations prior to publishing your reports. 

ONLY FOR LOGGED-IN USERS

Visual Relationships

Amending default relationships between visuals to display the required results will empower report readers. 

ONLY FOR LOGGED-IN USERS

Duplicate Page

Duplicate a page and amend titles and fields is a considerable time saver.

ONLY FOR LOGGED-IN USERS

Categories with No Data

Identifying categories with no data is an important skill.

ONLY FOR LOGGED-IN USERS

Default Summarisation and Categorisation

There are occasions when you will need to change the properties of fields to help report visualises. An example would be a sales margin is totalled when you require an average of the sales margin. A further example would be geographical locations. Cities may be states or countries.

ONLY FOR LOGGED-IN USERS

Z Order

Z-order refers to the order in which visuals are displayed for example a title needs to be on top of the background image. 

ONLY FOR LOGGED-IN USERS

Focus Mode & See Data

A report with multiple visuals can mask individual visuals message. Focus mode allows you to fill the screen with just one visual allowing report readers to explore the detail. 

ONLY FOR LOGGED-IN USERS

Hierarchy

A logical hierarchical data structure can empower report readers to intuitively navigate through the data.

ONLY FOR LOGGED-IN USERS

R-Visual Integration

Use R visuals within Power BI.

ONLY FOR LOGGED-IN USERS

Workshop

The workshop is an important opportunity for you to confirm what you do or don’t understand. Mistakes are often a better learning experience than getting everything right the first time so if you do make mistakes no one needs to know. On the positive side, you are unlikely to repeat your error. Good luck.

Powered by Thrive Apprentice
Pen
>