MS Power BI
Text

Power BI - Gladiator Academy - Two of Five Modules

7 Lessons Easy

About this course

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

Course Structure

ONLY FOR LOGGED-IN USERS

Managing Data Relationships

When you import multiple tables, chances are you’re going to do some analysis using data from all those tables. Relationships between those tables are necessary in order to accurately calculate results and display the correct information in your reports.

ONLY FOR LOGGED-IN USERS

Creating Calculated Columns

Sometimes the data you’re analysing just doesn’t contain a particular field you need to get the results you’re after. This is where calculated columns come in. Calculated columns use Data Analysis Expressions (DAX) formulas to define a column’s values.

ONLY FOR LOGGED-IN USERS

Optimising Models for Reporting

Changing data types, for example, a number to a currency value will help report readers to quickly focus on the key points of interest. So, it’s worth spending a little time on data types.

ONLY FOR LOGGED-IN USERS

Forming Calculated Measures

DAX empowers us to ask incisive and powerful questions of data. You define your question once and you can then slice your data by as many different fields as you want. An example would be time-based calculations.

ONLY FOR LOGGED-IN USERS

Produce Calculated Tables

Calculated tables allow you exact data of interest from several tables to create a new table from which you can answer questions and in turn, generate reports you couldn’t do any other way.   

ONLY FOR LOGGED-IN USERS

Time Intelligence

There will be occasions when you will want to analyse data over time, for example by year, quarters, months and days. Thankfully using Power BI this is relatively easy as fields can be automatically generated.

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
>