Day #5 – Amazon.com Order History Dashboard
As part of my Power BI 12 Days of Dashboards series, the 5th day of dashboards brings you an easy way to view your Amazon.com Order History. I built this with a single year of data, but you could extend this to view history from multiple years for additional insight into your order history.
Here is a fictitious example of the dashboard. You can easily create your own order dashboard by following the steps below.
The first step to creating this dashboard is to export your order history from Amazon.com.
- Navigate to www.amazon.com and click on “Your Account”
- Under the heading “Order History”, click on “Download Order Report”
- The next screen will allow you to select which data to export and the date range desired. Keep the report type set to Items to get the breakdown of categories in the dashboard above. Make your selection and click on “Request Report”. The report will be processed and will appear in your report list below. Download this .csv file to your local machine to use as the data source in the Power BI template in the next step.
Next, download the Power BI Template from here and continue with the following steps:
- Download and open the attached AmazonOrdersTemplate.pbit file and open it in Power BI Desktop
- A popup box appears asking for the full path of the .csv file exported in the above steps. Provide the full path to the file on your computer and click the “Load” button in the bottom right. (TIP: Make sure the file is closed or you’ll hit an error here. If so, close the file and relaunch the Power BI template)
Sam Lester (MSFT)