How to use Data Driven Settings to Control Power BI Reports

It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.

Effective Data Visualization – My 3 Key Lessons

I must say that I enjoy articles that teach me something new from people who have a great depth of knowledge about a topic.  I read an article by Avinash Kaushik,  Create High-Impact Data Visualizations: Nine Effective Strategies, which covers nine strategies while reviewing sixteen visualizations. It reminded me of three key learnings I have had over my career.

Fuzzy Matching for PowerBI with RScripts

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.

4 Step PowerBI L​earning Plan Visualization

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.

Getting Started with Date Dimensions​ with PowerBI

The date dimension is the table that controls your time analysis and the most important to get right, especially with PowerBI 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.

A Consultant’s Guide to Work Life Balance​

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.

Powered by

Up ↑