Feb 11
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."
Minimize the impact on SQL Automation workflows when migrating to SQL Azure by automating stored procedures using Runbooks and E-mail. This step by step tutorial and walkthrough will review a solution to provide scheduling via Azure Runbooks with integrated O365 email alerts.
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.
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.
We are all busy and jumping between tasks and projects. This makes it easy for your accomplishments to get left behind as you move on to the next thing. Keeping an accomplishment log will help you track what you have completed, your successes and will also serve as a resource for items you can reuse later.
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.
There is a very active community around PowerBI with many sites specializing in different aspects of the product. The following 4 resources are ones I always fall back on recommending that provide both beginner and advanced users learning resources.
Data visualizations can become the vehicle that leads a reader through your narrative. Having an infographic or series of visuals allows one to tell a story and provide greater understanding than simply having text alone.
