Finance and Supply Chain
Analytics
1
Project overview
AtliQ Hardware is a computer hardware company that manufactures various computer parts and peripherals. AtliQ operates
in APAC (Asia Pacific), EU (Europe), NA (North America), and LATAM (Latin America). They sell their products at Croma
and Best Buy stores as well as online on Amazon and Flipkart.
2
Problem statement
● Excel files getting bigger is causing performance issues, making things slow and inefficient.
● AtliQ Hardware is addressing the problem with a project that involves growing their data analytics team by hiring
junior data analysts.
● They are using MySQL as their database management system to analyze data, understand the company's finanical
position over the years, and extract valuable insights.
● The goal is to improve decision-making, optimize operations, and enhance overall performance.
3
Task
● Generate monthly gross sales report
● identify the financial position of the company over the various fiscal years
● identify the top products, markets and customers
4
Dataset overview
● loaded a million rows of data into a MySQL database and executed multiple queries.
● analyzed the following tables to derive the SQL concepts presented
5
● 2 user-defined SQL functions
● 5 stored procedures
● 4 views
6
Finance Analytics
# Gross Sales Report 1: Monthly Product Transactions for Croma Customer in FY 21
by Ng Hoi Yee 8
Finance Analytics
# Gross Sales Report 2: Monthly Product Transactions for all FY
by Ng Hoi Yee 9
Finance Analytics
# Generate Monthly Gross Sales Report for any customer using stored procedure
by Ng Hoi Yee 10
Supply Chain Analytics
# Forecast Accuracy Report
forecast qty
by Ng Hoi Yee 12
Supply Chain Analytics
# Forecast Accuracy Report
forecast qty
by Ng Hoi Yee 13
Supply Chain Analytics
# Forecast Accuracy 2020 vs 2021
forecast qty
by Ng Hoi Yee 14
Supply Chain Analytics
# Forecast Accuracy 2020 vs 2021
forecast qty
by Ng Hoi Yee 15
Supply Chain Analytics
# Forecast Accuracy 2020 vs 2021
forecast qty
by Ng Hoi Yee 16
Thank you
17
