Project Details

AtliQ Hardware, an international consumer goods electronics company, experienced a significant setback in Latin America due to the limitations of their data analytics capabilities. Recognizing the need for a robust data analytics solution, the company's leadership decided to invest in a comprehensive data analytics project.
As a Data Analyst👨‍💻, I spearheaded the development of bespoke reports tailored to the unique needs of various teams, including Finance, Sales, Marketing, Supply Chain, and Executive. These reports, rich in actionable insights, have empowered each team at AtliQ to make data-driven decisions, thereby equipping them with a strategic advantage.

Project Phases:
➡ Initiation: Kick-off Meeting & Project Charter
➡ Execution: Data Collection, Transformation, & Report Generation
➡ Review: Stakeholder Feedback & Dashboard Implementation

Domains Addressed:
➡ Finance
➡ Sales
➡ Marketing
➡ Supply Chain
➡ Executive (For Stakeholders)

Live Interactive Dashboard

Project Details

Here are some of the highlights of what I learned and practiced during this fantastic journey:
✨ INNER, LEFT, RIGHT, FULL, and CROSS JOIN: I gained a solid understanding of different types of joins and how to effectively combine data from multiple tables.
✨ Subqueries and Correlated Subqueries: I explored the power of subqueries, understanding how they can be nested and correlated to handle complex queries efficiently.
✨ Common Table Expressions (CTE): Leveraging CTEs, I enhanced my query readability and learned to tackle complex problems step by step.
✨ User-Defined SQL Functions: I now have the skills to create custom functions to streamline repetitive tasks and improve overall code efficiency.
✨ Stored Procedures: Understanding the concept of stored procedures allowed me to modularize code and enhance database performance.
✨ Database Views: I grasped the significance of database views in simplifying complex queries and providing a structured interface to access data.

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

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 using DAX measure.
➡️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

Live Interactive Dashboard

Live Interactive Dashboard