Project Details

Empowering Business Growth through Sales Insights: I crafted a dynamic Excel sales report, unlocking valuable strategies for effective customer engagement, smarter negotiations, and international expansion opportunities. The reports offer practical advice, optimizing sales tactics, enhancing customer satisfaction, and boosting revenue.

Here's what I learned:

➡️Pivot Table
➡️Power Query
➡️DAX(Basics)
➡️Advanced Excel functions (e.g., VLOOKUP, IF statements)
➡️Mastering sales metrics
➡️Conditional Formatting
➡️Presenting captivating reports
➡️Data validation and cleansing techniques

This project equips businesses with essential tools to monitor, refine, and supercharge their sales efforts. By analyzing sales data, companies discover avenues for improvement, fuel growth, and thrive in a dynamic market landscape.

Project Details

Project Highlights
▶Finance View: Analyzed financial performance, with dynamic P&L, net sales visualization, and top/bottom products & customers breakdown.
▶Supply Chain View: Provided metrics for customers and products, net sales error analysis, and sales accuracy improvements.
▶Sales View & Marketing View: Revealed customer and product performance, region/market insights, gross margin, and net sales matrix.
▶Executive View: Delivered market share trends, revenue by division, and channel insights for strategic decisions.

Key Learnings
1️⃣ Proficiency in P&L analysis.
2️⃣ Using KPIs for Finance, Sales, Marketing, and Supply Chain.
3️⃣ Consumer goods industry understanding.
4️⃣ Stakeholder management.
5️⃣ Data extraction (MySQL, Power Query).
6️⃣ Data modeling and advanced DAX.
7️⃣ Data validation in Excel.
8️⃣ Power BI report generation and optimization.

Live Interactive Dashboard

Project Details

As a data analyst ,I aimed to provide top-level management with a comprehensive and intuitive dashboard that delivers insights into the impact of our 5G launch. The objective was to present key metrics, compare pre and post-5G performance, and formulate a data-driven strategy to boost revenue, enhance customer retention, and capture a larger market share.

Key Learnings:

●Profound understanding of key metrics in the telecom analysis domain.
●Mastery of DAX for advanced data analysis.
●Gained valuable insights and made data-driven recommendations.
●Effective comparison of pre and post-5G performance.
●Presentation of major KPIs for strategic decision-making.

With a focus on key metrics, DAX expertise, and a robust analysis of pre and post-5G data, this project equips AtliQo Telecom for a data-driven strategy in the competitive telecom landscape.

Live Interactive Dashboard

Project Details

Key Learnings:

➡️Task Scope Mastery: Effectively reviewed and addressed ten real-world ad hoc data analysis requests from 'ad-hoc-requests.pdf,' showcasing a keen understanding of business needs.

➡️SQL Proficiency: Demonstrated the ability to write SQL queries proficiently, efficiently extracting valuable insights from the database to meet specific business requirements.

➡️Insight Generation: Translated raw data into actionable insights, providing meaningful answers to complex business questions outlined in the ad hoc requests.

➡️Clear Communication: Created a persuasive presentation that effectively conveyed findings, emphasizing clarity and conciseness in data presentation.

➡️Strategic Value: Positioned myself as a potential asset to AtliQ Hardware's data analytics team, with the ability to contribute to informed decision-making, and ultimately, the company's growth and success in the competitive computer hardware industry.

Project Details

Collaborating with AtliQ Grands, a luxury hotel chain, we revitalized their market presence and revenue using "Business and Data Intelligence" strategies. Our focal point was crafting a dynamic Power BI dashboard, offering real-time insights from extensive historical data.

Key achievements:
➡️Developed an interactive Power BI dashboard for immediate data analysis.
➡️Implemented crucial hospitality metrics - RevPAR, ADR, DBRN, DSRN, and DURN.
➡️Analyzed historical data to unveil revenue enhancement opportunities.
➡️Provided actionable insights guiding pricing and occupancy decisions.

Skills acquired:
➡️Proficient in Power BI for impactful data visualization and analysis.
➡️In-depth understanding of hospitality metrics and KPIs.
➡️Expert in data-driven decision-making for pricing and occupancy optimization.
➡️Effective communication of data insights for strategic decision-making.

Live Interactive Dashboard