Course description
This 6 hour live session will provide you with an introduction to what Power BI is and how you can easily obtain, transform and model the data.
Using Power BI, you will be able to connect your data sources and visualise them in a coherent report. There will also be some basic DAX formulas to create measures to be used in visualisations to create and publish useful reports. Some basic knowledge of DAX is recommended.
Join leading Excel trainer Alan Murray in our virtual classroom as he explores everything from how to download Power BI getting data from a variety of sources, modelling the data, creating reports and publishing to the service.
Upcoming start dates
Outcome / Qualification etc.
Training Course Content
Introduction
This 6 hour live broadcast session will provide you with an introduction to what Power BI is and how you can easily obtain, transform and model the data. Using Power BI, you will be able to connect your data sources and visualise them in a coherent report.
There will also be some basic DAX formulas to create measures to be used in visualisations to create and publish useful reports. Some basic knowledge of DAX is recommended.
What You Will Learn
This live and interactive session will cover the following:
- What is Power BI?
What exactly is Power BI, how to download it and an orientation to the screen and views. - Getting and Transforming Data
Getting data from a variety of sources including excel, csv, a folder, the web and PDF.
How to use power query to clean and transform this data and then load to the Power BI model. - Modelling the Data
Creating relationships between the tables of our model, set up a date table and instruct specific tables and fields to not load to the model or be hidden.
An introduction to some basic DAX formulas to create measures to be used in your visualisations. - Creating your Reports
How to use a variety of visualisations such as cards, column charts, matrix, slicers and maps. Edit the interactions between them and set filters. - Publishing to the Service
How to publish the report to the Power BI service and interact with it and show some sharing options.
Expenses
MBL Seminars Limited
With over 1,000 expert speakers covering more than 3,360 different topics, our course portfolio is vast and can be delivered either online or in-person. With over 450 years of collective professional development experience, we are proud to be trusted to...