enEnglish
CROS

Introduction to business intelligence in public statistics (Power BI)

 

Introduction to business intelligence in public statistics (Power BI)

Course Leader

Øyvind BRUER-SKARSBØ and Nadiya FEDORYSHYN

Target Group

Staff of national statistical institutes (including newcomers) who are involved in the production process and interested in learning new tools for visualizing and consuming data.

Entry Qualifications

  • Sound command of English. Participants should be able to make short interventions and to actively participate in discussions
  • Participants must have Power BI installed on their computer to be able to participate in the course. The free desktop version is enough to complete the course.  It can be downloaded here. 

Objectives

  • An understanding of how a business intelligence tool like Power BI can be used in public statistics.
  • Being able to import data to Power BI from different sources and visualizing them in Dashboards, making it easy to consume for yourself or other end-users.
  • Knowledge of how BI-tools might supplement more typical statistical programming software.

Contents

The course will have the following structure:

Day 1 webinar:

Introduction to business intelligence in general and Power BI (PBI) in particular. Participants will learn how to import data and visualize them in PBI- dashboards. Since these visualizations often will be interactive, some emphasis will be put on how to design reports that enable end-users to make changes themselves. We will also show several examples on direct connection between PBI and other data sources (SQL-databases, CSV/, R, Python, etc.).

Day 2: working on assignment:

After day 1 the participants are given a dataset to explore using PBI. They will be given one day to design a dashboard and play around with PBI. Videos will be made available before the course that show different functionality in Power BI. These will be a series of short tutorials aimed at public statisticians, that will make it easier for participants to get a good result from their assignment.

Day 3 Webinar:

Discussion around the participants experiences with PBI, including "walk through" of the assignment where participants can ask questions. Participants will also hear about more advanced topics surrounding BI-tools: how to visualize big data, how to publish dashboards and make them embeddable, and how PBI can be integrated into different parts of production in public statistics.

Expected Outcome

Participants should get a good basic understanding of the role that BI-tools can play in public statistics, and the importance of understanding data through visualizations. Participants should be able to make their own PBI-dashboard using the most common data sources.

Training Methods

  • Lectures (day 1 and 3)
  • Exercises (homework between day 1 and 3)
  • Questions and presenting work (day 3)
 

Required Reading

None

Suggested Reading

None

Required Preparation

Watching a series of tutorials before the webinar and having the software installed.

Trainers/
Lecturers

Øyvind BRUER-SKARSBØ and Nadiya FEDORYSHYN.

Practical Information

When

Duration

Where

Organiser

Application  via National Contact Point

20-22.04.2021

3 days

ONILNE

EFTA

22.03.2021