This project is part of the Codebasics Resume Project Challenge. In this project I have provided insights to the management of Atliq Hardwares.
Atliq Hardwares (imaginary company) 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. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.
-
Dataset: the dataset contained 6 tables: a.dim_customers which conatined details of all customers of Atliq Hardwares such as customer name,customer code,region etc. b.dim_product which contained details of all the products sold by Atliq Hardwares c.fact_gross_price which had details such as product code, fiscal year and gross price of products d.fact_manufacturing_cost which had details such as cost year and manufacturing cost of products e.fact_pre_invoice_deductions which had the percentage of pre-invoice deductions for each product f.fact_sales_monthly which had details such as quantity sold and date.
-
Ad-hoc requests: there were 10 ad hoc requests for which the business needs insights which helped in understanding the requirements of management.
- sql query were performed to answer the ad-hoc requests.
- data was exported to excel to covert output into visual.
- created presentation to show the insights.