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.
Posts from the ‘Learning’ Category
Visualizations can make even the most mundane information more accessible and easier to digest. I put together these two facts to make a visualization out of my lesson plan that the students could take away as a memory jogger when they get back to their offices.
There are times when, as a consultant, you have to produce a demo or training database that has no relation to the client that you are doing the work for. This can be due to security or confidentiality of the data. I try to produce training and samples that at least have realistic values so that the people involved have a frame of reference.
There are many formats that you can write documentation in for the Web. For GitHub projects, Markdown is an accessible format that is cross-platform and compatible with many web editors and CMS systems. This article shows how to add a Wiki to your GitHub project, write in markdown, and convert HTML documentation to the Markdown format.
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 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.
I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations. R provides many packages and functions that let you perform data discovery over a data set.
This article will impart what I have learned over my 20-year consulting career and provide some strategies to help you find your balance. I am writing this article from a consultant's point of view, but we all struggle with these priorities and expectations as an employee or entrepreneur. Also included is a simple methodology to help measure your work life balance and assist in determining where your time is going.
I must say that this is the most amazing visual I have seen in a while. The animation over time shows exactly what the author intended in a very simple and visual way. The colors are not jarring and change with the intensity of the data. The bar chart at the bottom is a little hidden, but perfectly placed not to take away from the main story the author is trying to portray.
I found that this was a perfect visualization example for the trend over time of the temperature data.