This section aims to demonstrate the data acquisition process, outlining the steps taken to extract and load data.
I personally know the client and they shared encrypted and password protected zip file containing csv data. File name is “sitelog-Dec-2023.”
The csv consists of 6 fields and 2319 entries / records.
| Fields | Description |
|---|---|
| session_id | A unique identifier for the session |
| created_at | The timestamp when the session was created |
| device | The device used during the session |
| load_time | The load time of the session |
| view_time | The view time of the session |
| lead_status | Lead registration (0/1) |
Before proceed with the data import, I've taken the initiative to set up the initial database named "web" and an empty table "session" with the exact number of columns required. I've ensured that each column is set to the default data type "varchar" to accommodate a wide range of data.