Project Details

The Sales Report project aimed to provide valuable insights into sales performance and market dynamics for Atliq Hardware. It consisted of some main objectives:
1)Customer Performance Report: This report focused on analyzing the performance of customers based on their purchasing behavior and contribution to overall sales.
2)Market Performance vs. Sales Targets Comparison: This aspect of the project involved conducting a thorough comparison between market performance and predefined sales targets.
3)P&L Report for Fiscal Year:
The P&L report for the fiscal year provides a comprehensive overview of the company's financial performance over the entire fiscal year period. It includes revenues, costs, and expenses incurred during the year, resulting in net profit or loss
4)P&L Report for Top Markets:
The P&L report for top markets focuses on analyzing the financial performance of the company's top-performing markets or regions.

Project Details

The objective of the Power BI project "Unleashing the Power of Data for AtliQ Hardware" is to enable AtliQ Hardware, a global consumer electronics company, to elevate its data analytics capabilities by transitioning from Excel to more robust analytics tools. This initiative aims to harness the full potential of data through Power BI, empowering stakeholders to extract actionable insights and drive informed decision-making.
Key Goals:
Transition from Excel: Replace traditional Excel-based data analytics methods with more advanced and efficient tools offered by Power BI.
Enhanced Analytics Capabilities: Equip AtliQ Hardware with the ability to perform sophisticated data analysis, visualization, and reporting using Power BI's powerful features.
Improved Decision-Making: Enable stakeholders to derive actionable insights from data, facilitating better decision-making processes across the organization.

Live Interactive Dashboard

Project Details

● Diagnosed loss in market share and revenue at Atliq Grands by developing and implementing a Power BI dashboard analyzing 4 months of data; identified key areas for improvement and devised actionable strategies to regain market dominance..
● With this dashboard, the Revenue team of Atliq Grands was able to gain insights into their revenue trend. This could help in regaining their revenue and market share by 20% in the next month.

Live Interactive Dashboard

Project Details

The major aim of this project is to gain insight into the sales data of Walmart to understand the different factors that affect sales of the different branches.
Analysis List :
Product Analysis
Conduct analysis on the data to understand the different product lines, the products lines performing best and the product lines that need to be improved.
Sales Analysis
This analysis aims to answer the question of the sales trends of product. The result of this can help use measure the effectiveness of each sales strategy the business applies and what modificatoins are needed to gain more sales.
Customer Analysis
This analysis aims to uncover the different customers segments, purchase trends and the profitability of each customer segment.