As a Data Engineer in a major consultancy firm, i have been tasked to lead a new project.
The Brazilian e-commerce company “Olist” has hired our consulting firm to produce some insights using its data.
The data that you will work with is stored in multiple sources. First, some of the tables are stored in a postgres database and some will be retrieved via an API. we will move this data from the different sources to BigQuery.
We will apply the necessary modeling techniques to transform the raw data in the landing tables to multiple dimension and fact tables and store them in BigQuery.
We will build views in BigQuery from the dimension and fact tables and use them to build a dashboard on Looker Studio.
Those view are answers the following questitions :
- Who are the top customers by total order value?
- What is the average number of orders per customer?
- What are the top-selling products by quantity?
- Which product categories generate the most revenue?
- What is the total number of orders placed each month (trend over time)?
- What is the distribution of payment methods used by customers?