The next learning summit is not far away and we already have close to 1000 Power BI users registered for the event.
There is going to be a significant amount to learn about high quality Power BI development so if you haven’t had a chance to register so far then you still can below
What I thought I would do here is create a detailed summary of what you will learn during each session as it’s going to be a comprehensive event and I want all those who are able to attend live to know exactly what they will learn.
Just as an aside all the resources and replays from the event will be made available to everyone who registers. These will only be made available before, during and for a few days after the event before they get moved to a members only section at Enterprise DNA Online.
Ok, so here’s the summary of what I’ll be covering during the live training workshops.
Session 1 – Advanced Model Development
During the very first session of the event, I’ll be completing an intro for the entire event, running through the data and resources we’ll be using and then covering many of the best practice techniques I feel you should follow as you build out your Power BI reports.
- Query Editor tips
- Developing robust data models
- Intro to time intelligence calculations
- Trend analysis
- Ranking Insights
Session 2 – Segmentation Patterns
In the second live session we’ll be covering a variety of segmentation ideas and techniques for Power BI.
During this workshop I plan to show you how you can do just that by isolating some customer data and really drilling into what’s creating our overall results and the performance of the business.
Sometimes it’s difficult to know where to start with this type of work but I plan to go through my thought process here and hopefully many of these tips can move into your own development processes over time.
- Segmentation & grouping patterns
- Advanced modeling techniques
- Focus on key customer groups
- Dynamic calculations
- Table visualization features
- and others
Session 3 – Budgeting Techniques
Budgeting analysis in Power BI can be quite difficult to implement in a lot of cases. The idea with this session is to take things up a level and show you how you can solve some advanced work around these types of analytical scenarios.
We’ll be dealing with some monthly budgets built from the ground up and comparing these to transactional results at a different granularity. There’s a lot you need to get right in Power BI to do this, so I’ll be letting you know all my best practice tips around how to do this.
- Manage data at different granularities
- Budgeting visualization techniques
- Combining multiple DAX formulas
- Master advanced DAX functions & patterns
- Highlighting key indicators
Session 4 – Attrition Analytics & Virtual Tables
We’re going to end the second day of the summit with a really advanced session.
I’ll be talking through how to setup attrition analysis in your models/reports and also discuss an increasingly important topic especially around DAX called ‘virtual tables’. If you are working in Power BI in any capacity you’ll want to master virtual tables fast.
- Understand customer breakdown
- Identify marketing opportunities
- Virtual Tables – advanced DAX concepts
- Advanced DAX function combinations
Session 5 – Financial Reporting Templates
In the 5th live session we’ll be covering a variety of tips for financial reporting in Power BI.
I will be covering a topic I’ve never reviewed before around financial templates! There is no other content out there around this type of techniques in Power BI so looking forward to getting your feedback…
I can’t wait to show you my integrated reporting techniques which will have a lot of real world application for anyone who’s looking to complete this type of analysis with Power BI.
- Data model design & setup
- Advanced financial insight visuals
- Financial calculations tips
- Integrated reporting techniques
- Financial reporting templates
Session 6 – Natural Language Queries (Q&A)
We’re going to end the summit with a deep dive into the Q&A feature.
The Natural Language functionality within Power BI is world class and I want to showcase to you the potential of this feature.
It only works well if you build your models well so I look forward to sharing my best practice tips.
- Best practices for Q&A feature
- Understanding how it all work
- Develop reports with just Q&A
- Synonyms and Linguistic Schema
- How far can you take the Q&A feature?
This will be it. 6 detailed workshops on a range of Power BI topics.
Anyone using Power BI will benefit immensely from these training sessions so I hope you can come along live and learn how I work in Power BI on a daily basis.
If you haven’t had a chance to register you still can here
If you have any questions around the summit certainly get in touch.