Tag: Power BI
-
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 person while working with your…
-
Power BI Tips & Tricks: DAX Organization
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 organized and make your life,…
-
Power BI Tips & Tricks: DAX Resources
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 with DAX over the last…
-
Power BI Tips & Tricks: Learn DAX!
This year I have gotten back to basics with Power BI. After working a day job that was largely focused on SSRS, on a basic on-premises Power BI setup, and on gathering proper requirements for Power BI solutions, I have returned to work in a more “traditional” Power BI environment utilizing the Power BI web…
-
Nashville Modern Excel and Power BI User Group: 30 Power BI Tips & Tricks
It’s great to be back! Grateful for the opportunity to share at the Nashville Modern Excel and Power BI User Group’s October 2022 meeting. 30 Power BI tips in just over an hour! Thanks to everyone who attended in person and online, I hope you learned something new! PBIX presentation file is below: PBI 30…
-
Choosing Charts
Happy new year! Quick post today to let you know about some new content on the site. In my work to visualize data and provide reporting solutions, I have both encountered the sometimes daunting task of choosing a chart and been asked about how to choose a the correct chart. The choice is not always…
-
M / Power Query: Table.HasColumns()
The Challenge Recently, I have been using Power Query to scrape data from web pages to load into Power BI for some side projects (more to come as these are completed, hint hint). The data from the web pages is good but inconsistencies do exist. Sounds like a pretty normal day for a data nerd,…
-
SQL Saturday Nashville 2020
Earlier, I had the privilege and honor of speaking to a full room at SQL Saturday Nashville on Applying Visual Design Best Practices in Power BI. Thank you to everyone who attended, you were fantastic! The slide deck is below: Applying Visual Design Best Practices in Power BI 01-18-20