Project Details

This Excel-based analytics project for AtliQ Hardware, a fictional electronics company, demonstrates a dual-focus approach to data analysis — Sales and Finance.

On the sales side, I created interactive dashboards to track customer performance, market-wise comparisons, product-level performance (top/bottom 5), and divisional breakdowns. The goal was to uncover insights into customer behavior, sales trends, and business expansion opportunities.

On the finance side, I developed Profit & Loss (P&L) reports by fiscal year, market, and month, along with Gross Margin % reports by quarter. These helped evaluate financial health and supported strategic planning.

Technically, the project highlights ETL processes, Power Query transformations, relationship modeling in Power Pivot, and advanced DAX calculations. I focused on building user-friendly, insight-driven reports that support stakeholder decisions and long-term business goals.

Project Details

This project delivers a unified BI solution for AtliQ Hardware, a fast-growing electronics company struggling with Excel-based reporting. Using SQL and Power BI, I designed and developed end-to-end interactive dashboards across Finance, Sales, Marketing, Supply Chain, and Executive domains. The data model follows a snowflake schema with sources from SQL and Excel. I used DAX for complex calculations and DAX Studio for optimization. The solution replaces manual processes with dynamic, real-time dashboards and empowers the leadership to make faster, data-driven decisions. Key outcomes include improved forecast accuracy, cost control, and deeper insights across departments. The project also strengthened my skills in stakeholder communication, KPI alignment, and storytelling with data.

Live Interactive Dashboard

Project Details

This project is my submission for the Codebasics SQL Challenge, simulating a real-world data task for AtliQ Hardwares, a fictional global electronics company. As part of the analytics hiring process, I tackled 10 ad-hoc business questions using clean and efficient SQL queries on the company’s database. The analysis covered product growth, market performance, sales trends, discounts, and more. I also designed a Power BI dashboard and presentation to communicate key insights effectively to stakeholders. Through this project, I demonstrated my ability to translate raw data into strategic recommendations, apply advanced SQL techniques, and present findings in an executive-friendly format.

Project Details

This full-stack Expense Management System empowers users to manage their spending through a clean and interactive web interface. Built using Streamlit for the frontend and FastAPI for the backend, the system connects to a SQL database for secure data storage. Users can add, update, and visualize expenses across categories like rent, food, and entertainment, and analyze monthly trends. Key features include intuitive CRUD operations, category-based analytics, and time-based filtering. The project is modular and test-driven, with separate folders for backend, frontend, and automated tests. It also showcases REST API design, integration testing with Postman, and version control with Git. This system not only simplifies budget tracking but also encourages financial discipline by enabling data-driven spending habits.