Microsoft Power Bi: Dashboard in a Day

Location EY Malta, Regional Business Centre, Achille Ferris Street, Msida, Malta, MSD1751, MT

Time 09:00 - 17:00

Register

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: Eur145 (a light lunch is included in the price).

CPE Accreditation

This event is eligible for 7 hours Professional Development CPE Accreditation.

Speakers

Francesca Mizzi

Francesca Mizzi is an Associate in Technology Consulting at EY Malta. Francesca holds a Bachelor's degree in Information Technology, with a specialization in Artificial Intelligence, and is passionate about helping clients harness the power of data to drive business success.
As a Microsoft Certified professional with qualifications in Power Platform, including Power BI Data Analyst Associate and Power Platform Fundamentals, Francesca has a deep understanding of the tools and technologies that are essential for unlocking valuable insights and driving growth.
Francesca's primary areas of focus include Artificial Intelligence, Data Analysis, Business Insights, and Automation. With her expertise and dedication to staying up-to-date with the latest industry trends and best practices, she is committed to delivering innovative solutions that help clients achieve their goals.