These AI generated superhero photos from Pure Storage were a hit. Perhaps I shouldn't have smiled? On the other hand, even superhero me is ready to serve with a smile! Biggest Takeaway From Day 2 Today, I got clarity on when to use Dataflows Gen 2 versus Data Factory Pipelines…
This is my first PASS Summit. I've been to, and spoken at, SQL Saturdays, attended other regional data conferences, but nothing else on this scale. However, this event feels familiar. Like a SQL Saturday just x100! Part of my choice to attend this year is wanting to connect with other…
Thank you to Teo and Damu for the opportunity to share 30 Power BI Tips & Tricks to the Atlanta Microsoft Business Intelligence User Group this evening. You are a great group! Thank you to all who attended and for the great questions! The PBIX Presentation file is below: PBI…
A Little Background Summer is upon us and like many families, we plan to take a good, old fashioned family road trip to arrive at our vacation destination. I still enjoy road trips. The games, mixtapes (well, playlists now), looking at the scenery throughout different parts of the country. I…
In the previous post, we looked at options and features to power up your Power Query experience. I'd like to build on that in this article. Perhaps the greatest feature of Power Query is the UI. Any user can perform dozens of transformations, both basic and complex, with only mouse…
Power Query is undeniably one of my favorite features of Power BI, and for that matter, Excel. Power Query packs a powerful punch for performing ETL (extract, transform, and load) tasks and it's user interface makes completing these tasks pretty simple without having to write any code. I won't expand…
Let me start this post by stating the obvious: data is the main focus of our data models and reporting. Without the data, well, the models and reporting would be pointless. But as necessary as the data is, often times I find that it's the small details in our data…
Allow me to start this article with a question: when you build a model in Power BI, do you think about the usability of that model? Rephrased, do you think about the user who is building a report on top of your model (including yourself) and the experience of that…
In the previous 2 articles, I wrote about the importance of learning DAX and offered some of my favorite resources for working with DAX. This article will conclude the trio of tips and tricks articles on DAX. I'd like to suggest a few additional tips that will help you stay…
In the last Power BI tips and tricks article, I wrote about the importance of learning DAX to open up the full capabilities in Power BI. In this article, I'd like expand on that and offer a few resources that I have found particularly helpful as I've learned and worked…