Are pie charts evil? Given the correct situation, pie charts can be used to your advantage in telling your data story. The following case study uses Power BI samples to review examples and provide recommendations to get the most out of an often misused visualization in Excel or Power BI.
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.
Data development projects, especially those involving multiple developers, languages, and platforms, can quickly become overwhelming without proper organization and consistency. One solution is to implement a style guide.
The Power of a Productive No is the ability to generate positive outcomes when saying No to a request. Having the ability to say no, but provide options to find an answer is called a “Productive No.” In this article, we’ll explore the benefits of saying no and share practical tips for unlocking your productivity.
Visual learners are individuals who process information best when presented visually rather than through other means like listening or reading. In this article, we’ll explore how you can use visual learners’ unique learning styles to your advantage in academic, professional, and personal settings.
The date dimension is the table that controls your time analysis and is the most important to get right, especially with PowerBI, Excel, and other visualization tools. Having various tags and descriptors that aid in your analysis gives your end users several options in creating their visualizations in addition to a base for DAX time intelligence calculations.
There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results that you can paste into Word to kickstart the documentation process.
