Enterprise DNA Learning Summit – Session 1 Preview

11 comments

With the first session of the Enterprise DNA Learning Summit starting tomorrow, here’s a quick run down of what you can expect from this training.

If you haven’t registered you still can here – Enterprise DNA Learning Summit

We firstly need to set the scene around the data we’ll be working through during the summit. I’ll review that and then show you how I think about building my data model off that back of that.

It’s important to really get the setup right here around your data model. It’s maybe not the most exciting part about Power BI development but it’s essential, trust me on this one.

Once we’re done there, I show you how to get started with DAX formulas. The key with creating formulas is to start simple and let the data model do all the hard work around filtering your data to get the results that you need.

From there you can branch out into more complex calculations. This is what I term ‘measure branching’. This is a powerful concept and range of techniques that you need to learn and understand and start using as soon as you can in your own models.

Once we’ve set up our ‘core calculations’ We can actually quite quickly begin building up our report page. I’m going to be looking to identify trends in sales, profits, margins and more.

By using the different dimensions that we have in our model we can effectively drill into why we are seeing the trends we’re seeing, and also why we’re getting the results we are.

So, very quickly you can extract great insight AND we really haven’t even started yet in where you can take your analysis with DAX.

I’ll touch on time intelligence calculations and how we can move to these quite quickly from the base we build. Also I’m going to cover how you can create dynamic visuals based on the ranking of the dimensions you place into your charts. This is a really effective data viz. technique and is really an entry into how you can use DAX to create amazing visuals in your reports.

Setting up our visualization will be next on the list to cover. It is so key in my opinion to really make your visualizations stand out.

I will be covering ALL my best practice tips. They are actually quite simple but REALLY effective, so I’m hoping you’ll be able to get these ideas into your models soon after this session.

This is going to be an interactive session as well. I’m going to answer as many questions as I can. Obviously a lot to get through but if you have any questions that are on topic, I’m happy to run through them.

See you during the session.

Sam

11 comments on “Enterprise DNA Learning Summit – Session 1 Preview”

  1. Hey Sam. Thanks for doing this! Your awesome. At work I have a few projects going that demands my boss to make sure it gets done. So I wasnt able to catch, im sure another capitvating video. Is it possible for you to send me the download like so I ca rewatch the video on my down time?

    Like

  2. Hi Sam,

    I had signed up for the training but couldn’t make it due to work; hoping to watch them over the weekend. I am not able to find the reource material for the summit. Could you please tell me where I can find it?

    Thanks
    PK

    Like

      1. Hi Sam,

        Yes, I did get the email thanks for that

        This is the finished Pbix file, isn’t it? I was wondering if there was a resource you provided for one to start from scratch? Connecting to the data model, manipulating it in the the query editor, and writing the first measure etc. Something I could use to practise as I follow the videos…

        Thanks

        Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s