SQL-Finance-Market-Supply-Chain-Analytics

Problem Statement

Atliq Hardware, a tech company, is transitioning from Excel to MySQL to handle increased amounts of data and enhance efficiency.

The project involves Finance analytics, Market analytics, and Supply chain analytics to derive decision-making insights.

Business Model

Atliq's business model involves selling hardware to customers like Croma and BestBuy, who in turn sell to the end consumer.

Types of Analytics

Finance Analytics

We need to generate individual product sales, aggregated on a monthly basis, for the Croma India customer in FY 2021. This will help track individual product sales performance. The report would contain:

Month
Product Name
Variant
Sold Quantity
Gross Price

Market Analytics

Create a report for the top market and top customer by net sales for a given financial year. This will help us have a holistic view of the trends and take required actions.

Supply Chain Analytics

Create an aggregate forecast accuracy report for all customers in a given fiscal year. Doing this will allow us to track the accuracy of the forecasts we make for a given customer.

Final Outcome

These SQL-driven analytics will help AtliQ make sense of huge volumes of data and make growth-propelling business decisions.