Amazon QuickSight basic steps
Amazon QuickSight Introduction — Part 2
20 May 2019

In our second Amazon QuickSight introduction blog post we will go through the basic steps in building a dashboard. These steps include importing a CSV data set, creating calculated fields and data analysis. The data being analyzed is in regards to non–local employee travel which is a public access data set and the source of the data is data.gov. We utilized the data set of employee travel data (non-local) of Montgomery County of Maryland. This data set gives insights into […]

Power BI — Align Your Visuals
Power BI — Align Your Visuals — Episode 7
17 May 2019

Welcome to Episode 7 of my Power BI Best Practices Series. In today’s episode, I will show you how to align your visuals to make users happy with the content they see.

create a waterfall chart
Create a waterfall chart when the data differs by several orders of magnitude
16 May 2019

With a starting value of $288,222,000.21 USD and a final total of $285,769,892.75 USD, the middle values used to calculate the total in the initial dataset contained extremely large variances in values. The scale and degree of variance created a challenge for creating a waterfall chart in Power BI.

Power BI Relate tables
Power BI — Relate Tables Using Your Data Model — Episode 6
10 May 2019

Welcome to Episode 6 of my Power BI Best Practices Series. In today’s episode, I will show you how to relate tables and your data model to allow for cross filtering and relationships. Here we go! Power BI — Relate tables and your data model By default, Power BI relationships are not active. So, you need to set the relationships in your dashboard. You can also set the type of cardinality of the selected relationship from one of the following […]

Power BI - Prepare Report
Power BI — Prepare Report Requirements — Episode 5
03 May 2019

Welcome to Episode 5 of my Power BI Best Practices Series. In today’s episode, I will show you how to prepare report requirements documentation. Here we go! Power BI — Prepare Report Requirements When building out your Power BI Dashboards, how do you make sure your visualizations address all the points your client wants? This is where a Reports Requirement Document comes into play. By creating a Reports Requirement Document, you will have a record of what’s expected, and can […]

Power BI — Table for Key Measures — Episode 4
26 Apr 2019

Welcome to Episode 4 of my Power BI Best Practices Series. In today’s episode, I will show you how to set up a key measures Power BI table, and why it’s beneficial to do so. Last episode, we covered sub-dividing and segmenting visuals. As a reminder, here is the overall curriculum for this video blog series: Power BI – Table for Key Measures The larger the dataset, the more difficult it can be to be organized, especially when sharing dashboards […]

New revenue streams for Retail and Services industries in 2020
16 Apr 2019

It seems that the world is slipping further and further into our pockets. We are doing more on our phones than ever before, and the power of the small, black tablets is growing stronger every year. The latest iPhone, only 6 inches tall and 3 inches wide, rivals the flagship desktop computers of only a few short years ago while adding GPS capabilities and Augmented Reality (AR), Virtual Reality (VR), and Machine Learning (ML). With billions of smartphones in use […]

Power BI - Eliminate Unnecessary Columns
Power BI — Eliminate Unnecessary Columns — Episode 2
12 Apr 2019

Welcome to Episode 2 of my Power BI Best Practices Series. In this episode, I will show you the importance of eliminating unwanted columns from cluttering your Power BI Desktop Report. Be sure to check out prior episodes and see where I’m going with BEST PRACTICES below. Power BI — Eliminate Unnecessary Columns One of the major selling points of Power BI is the ability to transform massive quantities of data into easily-digestible visual information. However, showing data that isn’t essential for the story […]

Power BI - Be Creative
Power BI — Be Creative and Tell a Story — Episode 1
05 Apr 2019

[cc] Welcome to my Power BI Best Practices video series Over the past year, I’ve been blessed to share my B.E.S.T. P.R.A.C.T.I.C.E.S. at the Memphis PASS Power BI meetup, the Microsoft Tech Expo in Portland, and the  Power BI World Tour in Seattle. At the Seattle event, I was lucky enough to meet with members of the Power BI product team like Will Thompson @Will_MI77 and Maggie Sparkman @maggiesMSFT. Since not everyone can get out and attend events like these, […]