In this workshop, learn how a dynamic dashboard in Microsoft Power BI will drive better decisions with data.
Power BI Desktop, a business intelligence tool with a freemium model, will help you to describe your data with charts and visualisations that dynamically update when your users interact with your custom dashboard. During this interactive workshop, we will introduce common Power BI features with a focus on working with data and demonstrate common data wrangling steps to transform data into a format for building a dashboard.
If you want to level-up your analytical skills and learn a new way to process, analyse and visualise data, join us in this introductory workshop and learn the fun and fundamentals of working with data using Power BI.
A basic understanding of Power BI Desktop and using the Query Editor
Importing data, changing data types and creating a date dimension
Creating new columns (introducing DAX)
Building a data model – cardinality and joining tables, cross-filter direction and filter-flow
Building a dynamic chart using the data model
Improving the data model.
Step-by-step slides will be provided for reference after class.
Required: Install Power BI Desktop. on a Windows machine (Power BI is a Microsoft product and is not supported by Mac devices)
Pre-work files will be supplied prior to class – ensure these files can be accessed and loaded into Power BI before the start of class
Datasets and files will be made available before the start of class and to be downloaded onto your laptop.
This workshop is designed for anyone who works with data or interprets data from reports and dashboards. No programming or dashboard experience is required.
In preparation, please download Zoom.
This session is not recorded however, you will receive the instructor’s slides following the session.
If you have any questions please reach out to email@example.com
Muhsin spent a rather long time in academia collecting a degree in biochemistry and genetics and a PhD in neuroscience. Being unsuccessful in gaining a position as a mad scientist, he worked as a data analyst across a variety of industries including in government, not-for-profit, retail and banking. He employed open-source tools to wrangle data into tidy meaningful formats to aid decision-making. Muhsin currently works at Mable as a senior analyst and wears hats and colourful Converse shoes most of the time.
We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.
Your registration for or attendance at any General Assembly offering indicates your agreement to abide by this Community Code of Conduct policy and its terms.