Level: Foundation (F)
 

Power BI is rapidly becoming a standard tool for producing interactive reports and dashboards and this course will provide a systematic introduction to Power BI, focusing on the workflow, from data preparation through to building and sharing visuals. There will be a focus on design issues, helping to achieve the right level of functionality and usability based on the intended audience. Particular attention will also be paid to the use of basic statistics.​
 

Learning Outcomes

By the end of the course, participants will be able to produce reports and dashboards in Power BI, drawing on and transforming data from a variety of sources. They will be able to create multi-page reports and dashboards based on their own data and their organisation’s themes with a variety of graphical and tabular outputs.

 

Topics Covered

Day 1 will cover:

• Overview of the workflow with a quick start to produce our first Power BI report followed by focus on the visuals (the chart types, tables and slicers)
• Working with the data including an introduction to the Power Query editor; introduction to the DAX formula language; filters; visual headers; drill

Day 2 will cover:

• Using basic statistics (correlation, linear regression and t tests); more on DAX
• Power BI service; report and dashboard deployment; bookmarks for story telling; security

 

Target Audience

The course is designed for those with no knowledge of Power BI but are responsible for producing reports and disseminating analysis. The course will be particularly helpful for those wanted to communicate their data analysis to a wider audience.

 

Knowledge Assumed

Knowledge of Excel is assumed. Knowledge of pivot tables (especially Power Pivot) is especially helpful as is an understanding of basic statistics.
 
Each attendee will need to have their own laptop with the free version of Power BI desktop already installed

Simon Musgrave

Simon is RSS certified as an advanced data science professional. He runs his own analytics business after working in academia and private consulting for many years. He has been involved in the production of reports and dashboards in Power BI across several sectors and has delivered numerous training courses in data analytics.
 

Robert Lukacs

Robert will be assisting with the practical sessions and has been designing dashboards for many years in Xcelcius, Tableau and Power BI. He has a very strong eye for design and is expert in the use of DAX to create more advanced reports.

Fees		Registration before  18 May 2024	Registration on/after 18 May 2024
Non Member  RSS Fellow  RSS CStat/Gradstat/Data Analyst  also MIS & FIS		£694.00+vat  £590.00vat  £557.00+vat	£772.00+vat  £655.00+vat  £616.00+vat
Group discounts are also available*: 3-5 people 6-8 people 9+ people *Discount only applies to non-member price		10% discount 15% discount 20% discount