How to Architect Your Power BI Solution

The best place to start when learning to develop Power BI solutions is to review the logical architecture your Data Visualization projects will have. There are many moving parts and pieces to a Power BI solution, especially when looking at the varied data sources you can use. From on-premises to web-based, from public to confidential, you must make sure you expose your data securely. Having a good clear architecture will help you achieve a not only a good solution but also a secure one. The following article will show you how you can architect your own solution.

How to Use and Refresh Power BI Using OneDrive Data Sources

One of the challenges for users with Power BI is being able to use a data source that you can update and flow those changes to your Power BI dashboards and reports. Using an Excel file in OneDrive for Business allows you to have multiple users update data, connect to a data source and schedule an automated refresh without having a lot of infrastructure. The following walkthrough will show you how you can leverage this feature for your own solution.

A Quiz to Measure Your Work-Life Balance

A few years ago a manager at work circulated the “Work-Life Balance Quiz”,  from the Canadian Mental Health Association which tries to quantify your balance.  A great quote from the quiz; “Achieving work/life balance means having equilibrium among all the priorities in your life – this state of balance is different for every person.”

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.