How to Use Date vs Date Hierarchy in Power BI: A Comprehensive Guide (2023)
PowerBI has built-in date hierarchy features that seem to cause confusion in not only new users but experienced users. This article shows you how to avoid errors.
Why use Visualizations and Infographics With Data Story Telling
Data visualizations can become the vehicle that leads a reader through your narrative. Having an infographic or series of visuals allows one to tell a story and provide greater understanding than simply having text alone.
5 Steps to Improve Your Excel Data Tables
You can improve your data visualizations productivity by using the built-in table functionality available in Excel. This tutorial and sample Excel workbook, available on GitHub, will move you from raw table to interactive analysis in less than 5 minutes.
6 Resources to Generate Test Data That’s Realistic (2023)
Needing to Generate test data can be very stressful. I like to produce sample data that contains realistic values, such as professional names so that the people involved in the training have a frame of reference and do not get tripped up on the data. Realistic datasets can be created by following these steps and utilizing the resources listed below.
How to Convert Excel Tables Fact Tables Using Query Editor
If you have an excel table that is built for data entry, it may not be in the best format for data analysis or your data model. By using Query Editor, you can keep the original table and create a version that you can use for analysis as a dimensional fact table.
How To Use Query Parameters In PowerBI Flat File Data Sources
How do I make it easy for the end user to move the source Excel File around while making it easy to update the source location in PowerBI? Query Parameters solved that issue making the solution a lot easier to maintain.