An Introduction to Microsoft Power BI - Turn Your Data into Opportunity

Introduction

This in-person seminar 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 course 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

NB: A laptop with 'Power BI Desktop' installed is required for the course session.