Details
About the workshop
Power BI is an interactive data visualisation software developed by Microsoft, focusing on business intelligence and part of the Microsoft Power Platform. Organisations of all sizes and industries use it to consolidate data from various sources into a single dashboard, enabling the creation of interactive reports and visuals to identify trends and make informed decisions.
Building on the recent sucess of the Power BI foundations workshop we now advance to the next level.
This workshop is specifically crafted for professionals tasked with data extraction, analysis, visualisation, and the creation of recurring reports and dashboards. If their role involves ensuring accurate, up-to-date, and easily digestible information to initiate and support business decisions, this program is essential.
Agenda
Crafting insights through complex data transformation
- Review basic data transformations and dive deeper into complex transformations
- Delve into Power Query formula language (M) for custom transformations
- Practical exercises in data cleaning, shaping and creating calculated columns
Fine-tuning Power BI data models
- Data modelling concepts
- Strategies for optimising data models for performance
- Explore query folding and query optimisation techniques
Optimising data insights with DA
- Deep dive into Data Analysis Expressions (DAX) language
- Intermediate DAX functions and concepts
- Practical exercises in writing complex DAX measures to answer specific business questions
Designing and customising your reports
- Exploring and creating custom layouts with json files
- Creating visualisations with custom layouts
- Hands-on exercises creating visuals
Going beyond basic charts with custom visuals
- Explore best practices for combining multiple visuals
- Understand the power of maps and geolocation data
- Utilise forecasting and advanced analytics features to create comprehensive insights
The importance of security and integration
- Learn how to protect data in Power BI with row-level and data-level security
- Understand a user of roles and permissions in Power BI
- Integrate PowerBI with other applications
Master data visualisations
- Plan for and create strong visual content that will connect with your audiences
- Select and implement the most appropriate visualisations
- Apply design principles to ensure dashboards are user-friendly enhance your dashboards
Enhanced dashboard design with storytelling techniques
- Develop strategies to design captivating and impactful data stories
- Bringing it all together with interactive storytelling practice
Tailor Your Training Experience
To make sure you get the learning solution that’s right for you, we offer different levels of tailoring to suit your needs. Choose from three levels of customisation:
1.Off the Shelf
Love what you see? Great! Choose this option to take one of our most popular courses and bring it in-house for your team. Includes a pre-course consult session with our facilitator to make sure we hit the mark, and deliver the right learning experience for you.
2.Customised
Make sure you get the most from the course you choose, by tailoring the content to get the right fit for you. Speak to our team, who will work with you to pick and mix from a curated bank of training modules to help customise your learning experience.
3.Premium
Not on the list? Let us know what you’re looking for and we will find the right solution. Our team of learning specialists will work with you to develop a unique training course for your business. Through an in-depth consultation process, we will work with you to profile your learning needs and build a bespoke program from the ground up.
Speak with one of our team today to find which option is right for you.
Who Will Attend
Anyone who wants to boost their skills in Power BI
- Business analysts
- Finance and accounting professionals
- Data analysts
- Data scientists