At some of my most recent customers I've developed an efficient way to analyse & deliver more meaningful, actionable and business-impactful insight to the users. I'd like to share this with you! This is based on Power BI, so I'll talk about DAX and Power BI report design, but it could be adapted to any tool. Using the Adventure Works sample database I created a couple of examples. It reads like a DevOps User Story, which is good as it switches to being busines-driven over data-driven. Some of ou

In this post, we look at how to create our own SQL Database and fill it with data from the Contoso Data Generator, so we can get some hands-on Power BI experience.

How does the Optimize ribbon, with Pause visuals, Refresh visuals, Optimization presets, and Performance analyzer, as well as Edit relationships in the properties pane work to streamline your authoring experience? Here are some scenarios they can help you with! 1. Make changes to an existing DirectQuery report without running queries until you are ready 2. Create new visuals without running a query until you are ready 3. Create measures in a DirectQuery model without the visuals refreshing until you are ready 4. Quickly edit relationships between DirectQuery tables 5. Quickly learn about and apply query reduction settings to your DirectQuery report 6. Adjust the query reduction settings to the level you need in your DirectQuery report 7. Quickly revert to the full interactivity after a data source change in your report

The External Tools ribbon is a feature that has been available in Power BI Desktop since the July 2020 release.  This feature should be considered essential to anyone who is regularly working in the Power BI space.    In this article I recommend my top five External Tools, that I [...]Read More »

The ultimate snapshot report shows the latest snapshot while showing the evolution at the same time. It's easy to select a previous snapshot and more.

Recently, I’ve published a new version of the Model Documenter. With that, version 2.1.0 went live. I always try to keep the FAQ up to date and add sections describing typical questions and u…

Here's the rough draft of a few key paragraphs from The Art of Insight : I respect but also disagree with the Tuftean and Bertinian function...

Is your data issue a business intelligence problem... or a change management issue? Can you distinguish these perspectives, or is it differing views on the same thing

Have you ever wished Power BI knew the optimal number of periods to show? It is possible with my Smart Axis Magic :) ! Here is how to improve UX by creating a smart date axis that automatically picks the optimal calendar period based on the timeframe. In this step-by-step explanation we dive deeper into field parameters, data modeling, and DAX. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :) Download link: https://my.datatraining.io/course?courseid=howtopowerbifiles *See improved solution in the download files, where you don't need the bridge table and can use a between date slicer -------------------------------- 📊 TRAININGS 📊 --------------------------------- New! Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Learning Path https://my.datatraining.io/subscriptions?id=power-bi-zero-to-hero For Custom Trainings and Consulting email directly support@datatraining.io --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 00:00 Intro 01:43 Step 1 - Creating a field parameter with periods 03:23 Step 2 - Creating a helper table 07:17 Step 3 - Creating the relationships 09:14 Step 4 - Applying a TopN filter 10:14 Demo - smart date axis 10:55 Finishing touch - Dynamic title 13:40 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Subscribe: https://bit.ly/31MnQGO​ Website: https://www.datatraining.io Facebook: https://www.facebook.com/groups/howtopowerbi LinkedIn: https://www.linkedin.com/company/datatraining-io Insta: https://www.instagram.com/howtopowerbi/ Twitter: https://twitter.com/HowToPowerBI --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://a.co/69HEjRu 📚 Power BI books MUST READ! https://a.co/5q5k6Dv 💡 General books I recommend https://a.co/05I4W2L 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://a.co/4V5CUJN * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Can you spot the difference between the following two report pages? Yeah, neither do I! But, there is a huuuuuge difference between those two reports! What if I tell you that the report on the right is 5x faster than the one on the left? Would you believe me? No? Then keep reading and I will show yo