1
Type
Speaker
CPD Hours Level
Seminar 6 IntroductionInformation
SRA Competency D

Introduction

This course 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

Book now

Group bookings
Discounts are available for multiple places and if you have 5 or more people interested in this course and would like to discuss holding it in your area or on an in-house basis then please email us at [email protected]
Can’t Make the Date?

Please let us know if you wish to be notified when new dates are added for this programme

Related Events