MS Power BI
Text

Power BI - Gladiator Academy - One of Five Modules

11 Lessons Easy

About this course

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

Course Structure

ONLY FOR LOGGED-IN USERS

Start Here!

Introduction

ONLY FOR LOGGED-IN USERS

Software you need

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

ONLY FOR LOGGED-IN USERS

Synopsis of Power BI

High level overview of Power BI process.

ONLY FOR LOGGED-IN USERS

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.

ONLY FOR LOGGED-IN USERS

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.  

ONLY FOR LOGGED-IN USERS

How to Connect to a Access Database

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

ONLY FOR LOGGED-IN USERS

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.

ONLY FOR LOGGED-IN USERS

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.  

ONLY FOR LOGGED-IN USERS

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.

ONLY FOR LOGGED-IN USERS

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. 

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
>