Atliq Hardware : A financial and sales analysis Challenge Provide Insights to Management in Consumer Goods Domain

Domain Consumer Goods | Function : Excecutive Management

Problem statement

Atliq Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. Hence, company decided to conduct a SQL challenge which will help them to understand the data.

Task : Check ad-hoc-requests.pdf - there are 10 ad hoc requests for which the business needs insights. Need to run a SQL query to answer these requests.

Tools & Applications MySQL, PowerBI, Canva, PowerPoint

· MySQL - Leveraged advanced database techniques including Joins, Common Table Expressions (CTEs), Subqueries, Window functions, and Entity relationship Diageram ERD's various functions to extract valuable insights.

· PowerBI - Utilized the power of Data Analysis Expressions (DAX) to dissect data and craft an array of informative visual representations such as charts and maps.

Key Insights & Solutions

· Key Insights - Uncovered pivotal metrics including Gross Profit, Contribution Percentage, and Order Rankings based on Overall Amount Sold, Average Gross Sales, and Average Manufacturing Cost, among others.

· Innovative Strategies - Devised inventive tactics to enhance production, including introducing membership programs, gift certificates, bundled offerings, student discounts, and various special promotions to entice a broader customer base.