FINANCE AND SUPPLY CHAIN ANALYTICS OF ATLIQ HARDWARES
📊 Problem Tackled: Addressing the challenges of Excel's file size constraints, enhancing decision-making processes, and streamlining operations through MySQL analytics.
📈 Project Synopsis: Delved into AtliQ Hardware's sales, products, customers, and regional data to derive critical insights.
🎯 Challenges Conquered: Focused on pivotal aspects like sales reporting, market trend analysis, customer behavior patterns, and predictive supply chain forecasting.
🔑 Acquired Skills: ➡ Development of Custom User-Defined Functions ➡ Mastery of Database Views ➡ Proficiency in Stored Procedures ➡ Utilization of Advanced Window Functions (OVER, ROW_NUMBER, RANK, DENSE_RANK) ➡ Effective Management of Temporary Tables ➡ Deep Dive into Database Indexes and System Updates ➡ Upholding Data Integrity and Mastering Entity-Relationship Diagrams
🔄 Notable Discoveries: ➡ Amazon topped net sales with 109.03M in fiscal 2021, closely followed by AtliQ Exclusive at 79.92M. ➡ India emerged as the leading market with the highest net sales of 210.67M in fiscal 2021, with the USA trailing at 132.05M. ➡ Amazon's contribution to total net sales was a significant 13.23% in fiscal 2021. ➡ In the APAC region, Amazon outperformed others with a net sales percentage of 12.99% in 2021. ➡ India claimed the leading position in total gross sales within the APAC region.
Presentation Doc Link : https://drive.google.com/file/d/1c9zzQ3auw0xj5LiG8df4BAOvek82Okjx/view?usp=drive_link
Full Video Presentation Link:https://youtu.be/koWuuLWeWoM