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
Craft insights with complex data transformation
- Review basic data transformations and dive into complex transformations
- Delve into Power Query formula language
- Practical exercises in data cleaning, shaping, and creating calculated columns
Fine-tune Power BI data models
- Understand data modelling concepts
- Optimise data models for performance
- Explore query folding and query optimisation techniques
Optimise data insights with DA
- Dive into Data Analysis Expressions (DAX) language
- Intermediate DAX functions and concepts
- Write complex DAX measures to answer specific questions
Design and customise your reports
- Explore and create custom layouts with json files
- Create visualisations with custom layouts
- Hands-on exercises creating visuals
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
Security and integration
- Protect data 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 and create content that connects with your audience
- Select and implement appropriate visualisations
- Apply design principles to enhance your dashboards
Dashboard design with storytelling techniques
- Design captivating and impactful data stories
- Bring 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