Building a pharmaceutical sales forecasting model using Amazon Forecast

In this section, we will use Amazon Forecast to build a forecasting model to predict sales quantities for a drug. We will generate two different forecasts. The first one will be at the hourly granularity, and the second one will be at the daily granularity. We will then visualize the forecasts using a chart. Let’s begin by downloading the dataset.

Acquiring the dataset

The dataset for this exercise is available at the following link: https://www.kaggle.com/code/milanzdravkovic/pharma-sales-data-analysis-and-forecasting/data.

You can see the contents of the saleshourly.csv file here:

Download the files saleshourly.csv and salesdaily.csv from the above portal. Let us look at the contents of the two files in a bit more detail.datum

M01AB

M01AE...