Get To Know More
Explore My
RESUME WRITING
GHOSTWRITING
EXCEL
POWER BI
SQL
PYTHON
PROBLEM-SOLVING
COMMUNICATION
ATTENTION TO DETAIL
ANALYTICAL THINKING
POWER POINT
STORY TELLING
Browse My Recent
I created a Power BI dashboard called Business Insights 360 for AtliQ Hardwares, a company that sells computer hardwares. The dashboard helps them to understand their financial, sales, marketing, supply chain, and executive performance. It also shows them how accurate their predictions are and where
AtliQ Hardware, a computer hardware company in India, needed a dashboard to assess their business performance and make data-driven decisions.
My role was to develop an interactive dashboard that provided insights into their financial, sales, marketing, and supply chain operations.
I integrated data from Excel/CSV files and a MySQL database into Power BI using Power Query and DAX. I built a data model and developed interactive visuals, including filters, slicers, and drill-downs. I also optimized the dashboard using DAX Studio for faster performance.
The dashboard provided key business insights, enabling AtliQ Hardware to identify strengths, weaknesses, and areas for improvement, ultimately leading to better strategic decisions.
Revive Insights 360 for Marriott Bonvoy: a PowerBI project revealing weekly hotel performance metrics, occupancy trends, room distribution, and KPI cards tailored for executive-level decision-makers.
Marriott Bonvoy needed insights to improve booking trends, guest preferences, and overall hotel performance.
I was tasked with developing an interactive dashboard that could analyze key metrics like booking platforms, cancellations, and guest preferences.
Using Power BI, I created the "Revive Insights 360" tool, integrating booking, cancellation, and guest data. The dashboard featured top booking platforms, cancellation patterns, and room allocation optimization, with drill-down options for hotel-specific performance.
The tool empowered Marriott to make data-driven decisions, leading to increased bookings, improved revenue, and enhanced guest satisfaction.
AtliQ Sales and Finance Analytics Reports showcases my exploration into customer and market performance, financial health, and strategic decision-making. Leveraged ETL methodologies, Power Query, Power Pivot, and DAX to craft impactful reports.
Sales Report Insights: Analyzed customer sales figures and tracked year-over-year growth in the Customer Performance Report. Conducted an in-depth comparison of market performance versus sales targets in the Market Performance and Sales Targets Comparison Report, providing clear insights for strategic decision-making.
Finance Report Insights: Assessed financial performance across various time frames in Profit & Loss (P&L) Reports, broken down by fiscal year and months. Provided market-specific financial benchmarks through P&L Reports by Markets, helping to identify key areas for improvement.
Analyzed data from Diwali and Sankranti promotions using SQL and PowerBI. I uncovered which promotions worked best, increased sales significantly, and identified top-performing products.
Atliq Mart, with over 50 supermarkets, needed insights to analyze the impact of their festive promotions during Diwali and Sankranti.
Atliq Mart, with over 50 supermarkets, needed insights to analyze the impact of their festive promotions during Diwali and Sankranti.
I created a "sales summary" view and built interactive Power BI dashboards to visualize trends, assess product performance, and measure promotion impact. This allowed for real-time analysis of sales and customer engagement.
Sales increased by 107.64% during Diwali and 113.58% during Sankranti. The analysis provided strategic insights into top-performing products, driving future data-driven marketing decisions.
My
Get in Touch
I’m a data analyst passionate about solving problems and helping others grow. Whether you need help with data insights, resume reviews, or optimizing your LinkedIn and Naukri profiles, feel free to reach out. I'm also open to exploring new opportunities.