SQL Saturday Atlanta 2024 – BI & Data Analytics
Thank you to all who attended the session today! Slide deck is posted below: Communicate-Clearly-SQL-Saturday-Atlanta-2024-BI-02-10-2024Download
0 Comments
February 10, 2024
PASS Data Community Summit 2023, Day 3
This week has been a whirlwind in the best possible way. As full as the week has been, it has come to a bittersweet conclusion. I am ready to return home to my family. My brain has definitely reached capacity. But this #SQLFamily connection is real. I was really just…
November 17, 2023
PASS Data Community Summit 2023, Day 2
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…
November 17, 2023
PASS Data Community Summit 2023, Day 1
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…
November 15, 2023
Atlanta Microsoft Business Intelligence User Group
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…
October 2, 2023
Use Excel’s IMAGE() Function to Build a Custom Road Trip Bingo Game
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…
June 2, 2023
Power BI Tips & Tricks: Build a Date Table with Power Query
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…
January 13, 2023
Power BI Tips & Tricks: Power Up in Power Query
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…
December 30, 2022
Power BI Tips & Tricks: Simple Additions with Big Impacts
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…
December 16, 2022
Power BI Tips & Tricks: Naming Conventions, Formatting, and Metadata
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…
December 2, 2022