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 the total approved actual expense incurred by Montgomery County Government employees traveling non-locally. The data set comprises of 7 columns and 1412 rows. This data se...
Managing Data and Applications Anywhere
Anil Kishore
Solutions Consultant
2
Blog posts
Create a waterfall chart when the data differs by several orders of magnitude
13 May 2019 Anil Kishore
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. Item Price, $ Start value 288,222,000.21 A (60,311.00) B (333,111.00) C 64,444.00 D (187,856.00) E 108,886.00 F (268,806.00) G 41,961.00 H 1,803,265.00 I (12,606.00) J (380,246.00) K 1,650,164.00 L (1,863,598.00) Final value 285,769,892.75 With the highest value being $288,222,000.21 million and the lowest value being negative $1,863,598.00, the ...