As companies move data workloads to the cloud, more and more resources are available online to help you get up to speed. The following learning map provides a path to these online resources not only to give you an overview but also to provide an experience of these technologies .
I needed to quickly create a calculation that tested for the presence of a string in another column’s text values. There are two ways to solve this, but the first one is an interesting example that you can use in several situations. This solution plays on the true-false values of the DAX IF function in PowerBI.
PowerBI has the ability to mashup data from different sources; this may introduce problems when joining or matching data between systems. I was able to get around this issue by leveraging an R script from an article in the community. As a consultant there is a rule that if you use something from the community, you need to give back and particularly if you use it twice, you have to write a blog post. This is such a post.
Pie Charts are evil? Well, given the correct situation, pie charts can be used to your advantage. The following case study uses Power BI samples to provide recommendations to get the most out an often misused visualization.
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.
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.