Power BI Workshop Series: Mastering Data Visualisations

 

The Power BI Fundamentals workshops are designed to provide you with the core topics and skills to create data visualisations with Power BI. These include extracting, transforming and loading (ETL) data, performing calculations using Data Analysis Expressions (DAX), setting up filters and cross-filters, performing time-based analysis and forecasting, working with different data types, making a variety of visualisations.

This series of workshops is ideal for those with NO prior experience or those looking for a refresher.

Each workshop is two hours long, and you will work with fellow learners, utilising your prior experience, web searches, and in-application Help features to find the solutions to real-world problems, with a Power BI expert on hand if you get stuck.

You can choose which skill set you work on from the list below. These workshops allow you to choose your own Power BI learning journey, so you can start at the level that is right for you.

Whether you are new to Power BI or just want a refresher, you can attend as few or as many sessions you feel you need. We do recommend completing all six skill sets if time permits, as they form a good foundation for best practice and teach the fundamental Power BI skills necessary to continue expanding your expertise in Power BI and unleash the power of your data with PowerBI – your gateway to impactful data visualisations.

Workshops will take place in person throughout the year. The sessions will take place on campus in LRB.R.08 in the lower ground floor of the Library. 

Click on the links below to book your place or express an interest so you are notified as soon as a new session is scheduled. 

Power BI Fundamentals Workshop Series

You can choose which skill set you work on from the options below.

Power BI 1: ETL and Dashboards

Embark on your Power BI journey with a deep dive into the Power BI interface. Learn how to ETL (Extract Transform Load) data with ease. From navigating workspaces to importing data from various sources, you will gain hands-on experience with core data cleaning and shaping techniques. Create your first dashboard with ease using popular charts.

This task will give you a solid grasp of Power BI fundamentals and good practice in a concrete way, providing you with strong essentials to build on.

Click on the link below to check availability and book your place:

Power BI Fundamentals Workshop Series

 


Power BI 2: Interactive Dashboards

In this task, you will build on your learnings from Power BI 1 and elevate your data storytelling by customizing visuals in Power BI. Explore advanced chart types and learn when to use them effectively. Harness the power of cross-highlighting and cross-filtering for interactive data exploration. Master the art of applying filters and slicers to enhance your visualisations.

This task will cover a broad base of fundamentals, allowing you to practice what you learned in Power BI 1, while providing you with the building blocks to learn more elaborate Power BI functionalities.

Click on the link below to check availability and book your place:

Power BI Fundamentals Workshop Series

Power BI 3: Modelling and Hierarchies

Dive into the foundational principles of Star Schema design and build relationships between tables in PowerBI. Explore the intricacies of one-to-one and one-to-many relationships while creating hierarchical structures in your data model. Put your skills into practice with engaging visualisations exercises.

Click on the link below to check availability and book your place:

Power BI Fundamentals Workshop Series


Power BI 4: Advanced Dashboards

Unlock the full potential of PowerBI with advanced visualisation techniques. Delve into drilldowns, bookmarks, and page navigation. Learn to create dynamic parameters for enhanced interactivity and get introduced to PowerBI Q&A with real-world visualization exercises.

Click on the link below to check availability and book your place:

Power BI Fundamentals Workshop Series

 

Power BI 5: DAX, Time Series Analysis and Calculated Columns

Demystify DAX (Data Analysis Expressions) with an introduction to syntax and functions. Create measures and calculated columns, understanding their use cases. Explore time intelligence functions for insightful time-based analysis, implementing rolling averages, cumulative totals, and custom time periods.

Click on the link below to check availability and book your place:

Power BI Fundamentals Workshop Series

Power BI 6: Advanced Data Analysis

 Take your data analysis skills to the next level by handling outliers and anomalies in DAX. Implement dynamic grouping, scenario analysis, and sensitivity modelling using advanced DAX calculations. Learn strategies to optimize DAX in handling large datasets, ensuring top-notch performance.

Click on the link below to check availability and book your place:

Power BI Fundamentals Workshop Series