Sales forecasting and planning.
The main learning objective of this project is to apply knowledge of SQL and foundations of relational databases to create a tool for sales planning and analysis.
Access has been given to a database of a company that sells bikes and related products. The database contains information about orders, products, and customers. Company works with customers of two types. The first group includes individuals and the second contains shops that resell goods bought from the company.
To evaluate the performance of sales department:
- create tools to automate the planning process;
- prepare data to calculate difference between planned and actual values of amount sold to companies (resellers).
This assignment includes the following activities:
- Writing queries to process and copy data
- Creating functions in the database
- Creating materialized views
- Setting permissions with SQL