The Source for this data was used from this link: https://codebasics.io/challenge/codebasics-resume-project-challenge
PowerBI Dashboard link: https://www.novypro.com/project/atliq-hardware--power-bi
Atliq Hardware (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.
Nevertheless, the management noticed that they do not have sufficient insights to make prompt, wise and data informed decisions. Plan to expand their data analytics team by adding junior data analysts. To assess candidates, Data analytics director, Tony Sharma plans to conduct a SQL challenge to evaluate both tech and soft skills. The company seeks insights for 10 ad hoc requests.
Tools : Used MySQL for ad hoc requests and Power BI for Level 1 Analysis to gain the better overall insights of all segments.