Microsoft Power Bi: Dashboard in a Day

Introduction

In this workshop, we will be exploring the powerful capabilities of Power BI, a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities with an interface that is simple enough for end users to create their own reports and dashboards. Whether you are new to Power BI or an experienced user looking to take your skills to the next level, this workshop will provide you with practical knowledge and hands-on experience to help you create compelling visualizations and reports that can help you make informed business decisions.

Power BI Desktop is a report designer with endless possibilities, used to bring in data from multiple sources, transform that data and merge them into a data model to get insights into your information. Making use of over 135 cloud and on-premise data sources as well as over 250 custom visualizations, PowerBI will help connecting, loading/transforming the data and creating reports, dashboards, applications and data visualization.

The deliverables can be viewed on a variety of platforms. Power BI can be integrated with Excel, Power Point, SharePoint and Teams. Generated reports can be embedded in the platforms and data connectors can be used to connect to data stored in those platforms.

Who Should Attend?

These workshops are open to everyone with an interest in data analysis and business insights using visualizations and reports. No prior knowledge of Power BI is needed as even the basics will be covered but some basic knowledge of Excel and data tables are recommended.

Requirements

Please follow these very important requirements:

1. Participants are required to bring their own laptops for the workshop. 
2. Participants are required to install Power BI Desktop on their personal laptop prior attending the workshop. To install it please follow the instructions at this link. 

Workshop Outline 

Data Quality and Visualisation Theory session

Prior to delving into PowerBi transformations, we will go through a quick theoretical session which will cover the below principles:

• The meaning of data quality and data quality best practices.
• Establishing Context, Audience, and Goal for your visualisation.
• Choosing the best visualisations to represent your data.
• Choosing the right layout.
• Application of Tufte Guidelines, Gestalt Principles, and Pre-Attentive attributes to maximise on audience attention.

PowerBi Workshop

The second part of the session will include a hands-on workshop using PowerBi, where you will be provided with a large dataset, which you will be guided in transforming into an engaging dashboard. The following core technical PowerBi principles will be covered:

• Importing data, the different data sources available, and the Power Query Editor.
• Transforming data, including conditional columns and coded columns.
• Creating links and relationships between tables.
• Creating visuals using in-built and add-in visualisations.
• Creating calculated measures.
• Using bookmarks and custom buttons.
• Visualisation interaction.
• Formatting Visualisations.

Registration fee

Click on Register to confirm your place. 

• Price for this session: Eur180 (a light lunch is included in the price). 

Speakers

Emma Forace

Emma is an Associate within the People Consultancy team at EY. In her role, she assists clients with various people-related issues to enhance their workforce strategy and ensure alignment with broader organisational goals. Emma hs a Microsoft Certified Power BI Data Analyst Associate certification. Additionally, she plays a key role in HR transformation projects, which involve implementing effective HR solutions, advancing digitalisation initiatives, and facilitating change management processes. Emma is also tasked with creating and analysing data-driven dashboards that deliver valuable insights to aid strategic decision-making and enhance organisational performance.

Celine Suban 

Celine is a seasoned educator with several years of experience teaching both adults and children. Celine's teaching experience includes instructing students in mathematics and computer programming. She holds a bachelor's degree in Artificial Intelligence and has been working as a Technology Consultant at EY Malta for over two years. Celine is also Microsoft certified in PowerBI, making her well-equipped to deliver comprehensive and insightful training sessions.