Future-Proof Your Career, Master Data Skills + AI


Future-Proof Your Career, Master Data Skills + AI


What You Will Learn During The Next Enterprise DNA Learning Summit – August 2018

by | 8:57 am EDT | August 20, 2018 | DAX, Learning Summits, Power BI

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

Enterprise DNA Learning Summit, August 2018

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.

Learning Summit August 2018 - Laptop Main

  • 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.

Laptop 2

  • 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.

Laptop 3

  • 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.

Laptop 4

  • 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.

Laptop 5

  • 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.

Laptop 6

  • 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

Enterprise DNA Learning Summit, August 2018

If you have any questions around the summit certainly get in touch.


Related Posts