MS Power BI

Power BI - Gladiator Academy - One of Five Modules

11 Lessons Easy

About this course


Welcome to Cloud Hounds' MS Power College course, Analysing and Visualising Data with Power BI.

Note: To learn the most from this course a desktop PC is recommended. 

Why Microsoft Power BI?

The truth is all industry sectors can benefit from Power BI. The data analysis principals taught in this course can be applied to all organisations regardless of size. However, the focus for this course, is hospitality.

Why is business intelligence (BI) so important?

In these highly competitive times, would an analysis report that can show you:

  • The fastest growing players in the market
  • The most profitable competitors
  • The "over trading" companies that are chasing sales despite mounting losses
  • What the strongest competitors are doing right

give you and instant competitive advantage?

Power BI offers powerful analytical tools for all businesses regardless of business size.

BI for market forces analysis

Economic uncertainty, rising inflation leading to likely interest rate increases combined with rising job insecurity, stagnate wages and rising inflation will inevitably reduce your consumers, disposable income.

The possible outcomes of the above makes it imperative your product service offering matches consumers expectations.

BI to measure business implications

Add changing consumer demographics to the mix, demand preferences will change. An aging population may lead to a more discerning customer base. Increasing labour costs, recruitment retention problems and higher training costs are likely to impact the ability to maintain product service delivery standards. Particularly as employers become ever more reliant upon zero hour contracts and casual work force.

BI to assess business operational challenges

The profitability of individual companies depends on efficient supply chain management and effective merchandising and marketing.

Negative PR event, data security breach, a decline in year on year (YOY) sales, missed earnings call, market share loss, inventory write-off, forced layoff, business unit closure, technology failure, a lost contract, a change of management, bad data leads to wrong busienss decisions be taken, all possible factors for business demise.

BI can help to address key business decision concerns.  

CEO : primarily interested in creating differentiation as well as developing a merchandising strategy.

CFO : primarily interested in optimising inventory, reducing costs and developing a competitive pricing strategy.

Chief Information officer/IT : primarily focused on data security leveraging the Internet to drive increased sales.

So, what is Power BI?

Power BI is a cloud-based service. Use your own data, freely available and paid online data all can be utilised and held securely, in one central location, for analysis and accessed, using a range of devices. The principal benefit being decision makers are working with up to date, evidence based information rather than gut instinct and most importantly reports can be distributed and interrogated by the right people at the right time.

Course Prerequisites

Some experience in working with data from Excel, databases, or text files.

Course Schedule

This course is available in self-paced format.

Quizzes are an aid to your learning and to help you to fully understand the material. Ideally you should complete the quizzes before you begin the next module.

Module 1

Learn the key ideas in business intelligence, data analysis, and data visualisation

How to import your data and create automated dashboards from services such as Marketo, Salesforce, and Google Analytics

Learn how to extract, load and transform (ETL) your data.

How to ask and answer business questions using calculations

Module 2

Presenting your data and publish reports

Module 3

Automated scheduled report refresh

Producing dashboards and using natural language queries to answer business questions

Sharing dashboards to the right people at the right time

Viewing dashboards using mobile apps

Use your Excel reports within Power BI

Creating bespoke visualisations using your dashboards and reports

Collaborating within groups to develop reports and dashboards

Sharing dashboards according to your needs

Module 4

Using real time connections to update your data with Power BI

How to connect directly to SQL Azure, and SQL Server Analysis Services

Power BI Development API basics.

Using bespoke graphics in Power BI

Expected Effort

Each week, you should spend as much time as you require to understand the principals. Most people generally spend 2-4 hours on the course, completing the following:

  • Viewing the videos
  • Completing the quizzes
  • Completing the lab exercises
  • Further reading


This course includes coursework and is not, graded. Each module in the course includes several videos, and short quizzes, and lab exercises.


If you are fortunate to be studying within a group you should encourage each other to ask questions. Doing so helps to consolidate learning and understanding. If you have issues you may find asking your fellow students for help might prove mutually beneficial. You never know they may have already found a solution!

If you have questions visit Cloud Hound PRIVATE Flaurum forum. The forum is open to all students and staff, and while we love to see passionate engagement, abusive or inflammatory behaviour will not be tolerated. If you wish to join the group email to and your application to join will be considered. Alternatively you can click the Facebook Power BI Group image button below and register your interest to join.

Due to the volume of students studying this course, it will not be possible to answer every question individually. You should still post questions however, because in many cases, your fellow students may be able to help.

Completing the survey will help with development of further courses.

Thank you.

Course Structure


Start Here!



Software you need

Obviously you do other wise you wouldn't be viewing this course.


Synopsis of Power BI

High level overview of Power BI process.


How to connect to Software Services

Helicopter overview of connecting to data services for example Adobe, Google Analytics, Acumatica, MailChimp, SQL to Power BI interrogating the data and publish reports & dashboards.


Power BI Desktop Modelling & Data Modelling in Power BI Desktop

Power BI Desktop can connect to all sorts of data sources and then help you, to extract, load and transform the data into a format you can start to build relationships in turn enable you to analysis and visualise the data.  


How to Connect to a Access Database

This video demonstrates how to use Power BI Desktop to connect to a database


Data transformation

In today’s world sustained competitive advantage at its core necessitates data transformation. Master this essential skill and you will remain one step ahead of your competitors.


Connecting to files in a folder

Assume for a moment. You have a number of businesses operating in different geographic locations. Each month or week they submit sales reports to your offices. The data needs to be added to your database. This video illustrates how to append such files to your data set.  


Less Structured Data

In this presentation, the focus is upon a more complex real-world example, for example, exporting a matrix-like data format and transforming the data layout into a column format a style that works well for Power BI.


Create tables within Power BI

Create tables within Power BI. Manually type entries or copy and paste data then transform and query data to generate spectacular eye-catching reports. 



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