This project was one of the resume challenges conducted by Codebasics.
Atliq Hardwares, a leading computer hardware producer in India with a significant presence in other countries, identified a need for better data insights to support quick and informed decision-making. To address this, I conducted a comprehensive SQL challenge to showcase and enhance our data querying skills and provide actionable insights.
The primary objective of this repository is to demonstrate the application of SQL for data retrieval and analysis. Additionally, it highlights the use of PowerBI for data visualization to support the management in making smart, data-driven decisions.
SQL: For querying databases and retrieving insights. -Joins -Subqueries -Common Table Expressions (CTE) -Window Functions PowerBI: For creating interactive and insightful visualizations. -Creating measures -Custom columns -Various types of visuals
The insights provided from this project cover all aspects of the company's business, including:
Sales Performance: Analysis of sales data across different regions and time periods. Product Analysis: Insights into product popularity, performance, and inventory levels. Customer Behavior: Understanding customer purchasing patterns and preferences. Operational Efficiency: Evaluating operational metrics to identify areas for improvement. Market Trends: Analysis of market data to identify trends and opportunities.
Ad Hoc Requests: A collection of specific data requests to answer business questions. SQL Codes: Scripts used for the ad hoc requests, demonstrating the use of joins, subqueries, CTEs, and window functions. Presentations: PowerBI-created visualizations and presentations that depict the data insights and findings.
This repository serves as a resource for understanding how SQL and PowerBI can be utilized to transform raw data into meaningful insights, facilitating better business decisions at Atliq Hardwares.