I tried to Visualize and Forecast Data using Amazon QuickSight

2023.04.17

Data Visualization

The process of putting information into a visual context, such as a map or graph, in order to make it easier for the human brain to absorb and extract insights. The primary purpose of data visualization is to make identifying patterns, trends, and abnormalities in vast amounts of data easier.

These information visualizations explain complicated data correlations and data-driven insights in an easy-to-understand manner.

In this blog, I will be showing how to visualize data using Amazon QuickSight as a tool to see trends and patterns in the data.

QuickSight setup

  1. In a new browser tab, open AWS Console, and search for QuickSight.
  2. Click the Sign up for QuickSight button on the QuickSight page.
  3. Continue with the default Enterprise edition, scrolling down and clicking the Continue button.
  4. Enter your QuickSight account name and email address for notifications.
  5. Scroll down and press the Finish button.
  6. Go to Amazon QuickSight by clicking the Go to Amazon QuickSight button. You will now be sent to the QuickSight console.

Build Your Dashboard

  1. Select Datasets from the menu on the left.
  2. Click the New Dataset button in the upper right corner of your screen.
  3. Select the first option, Upload a file.
  4. Select Next.
  5. Select Visualize.

Visualization

We will try to visualize the Sales by Month.

  1. To verify that the empty visual is chosen (shown by a blue border), click it.
  2. Select Sales and Order Date from the list of Fields.
  3. If the axis labels are not visible, enlarge the visual.
  4. On your X-axis, click the arrow next to the Order Date label and select Aggregate->Month.
  5. Alternatively, you may open the Field Wells section at the top of the page, click the arrow in the Order Date field, and then change the aggregate to Month.

Let's add Forecast to the visualization

  1. From the visual menu in the upper right of the visual, click the ellipsis icon, and choose Add Forecast.
  2. Optional - when adding/editing the forecast, you can apply a backward or forward forecast as well to see how close the forecast is to the actuals for the previous months.
  3. Change Periods backward to 4 and Period forward to 6, and click Apply.

From this visualization dashboard, you can decide to use any preferred visual type like a pie chart and so on.

Amazon QuickSight is a good tool to visualize business and also make a forecast for the business.