Project Details

𝐏𝐫𝐨𝐛𝐥𝐞𝐦 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭: AtliQ Technologies, a thriving hardware company specializing in peripherals, faced a significant challenge in LATIN AMERICA. Their quest? To rectify the issue through data-driven decision-making.

𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐕𝐢𝐞𝐰: Analyzed crucial KPI indicators such as Net Sales, Gross Margin %, and Net Profit %. Created a comprehensive P & L Statement with YOY growth.

𝐒𝐚𝐥𝐞𝐬 𝐕𝐢𝐞𝐰: Explored Customer Performance based on Net Sales and Gross Margin.

𝐌𝐚𝐫𝐤𝐞𝐭𝐢𝐧𝐠 𝐕𝐢𝐞𝐰: Enhanced Marketing insights with segment performance and Net Profit metrics.

𝐒𝐮𝐩𝐩𝐥𝐲 𝐂𝐡𝐚𝐢𝐧 𝐕𝐢𝐞𝐰: Surveyed the variance of Actual Sales and Forecast accuracy.

𝐄𝐱𝐞𝐜𝐮𝐭𝐢𝐯𝐞 𝐕𝐢𝐞𝐰: Examined Yearly Trends by Revenue, GM %, NP % & Market Share %. Listed the TOP 5 Customers & Products by Revenue Contribution.

Live Interactive Dashboard

Project Details

I created a sales report in Excel designed to help businesses determine optimal customer discounts, improve communication, and identify new growth opportunities. The report offers actionable insights to enhance sales performance, boost customer satisfaction, and increase revenue.

Through this project, I developed skills in:

Utilizing advanced tables in Excel
Managing and analyzing data effectively
Performing basic calculations on sales data
Enhancing visuals with formatting and color
Designing clear, visually appealing reports
Understanding key sales metrics
This project equips businesses with valuable tools to monitor, analyze, and optimize their sales processes. By leveraging sales data, companies can uncover opportunities to improve, expand, and stay competitive in an evolving market.

Project Details

Working with AtliQ Grands, a renowned luxury hotel chain, we implemented "Business and Data Intelligence" strategies to revitalize their market share and revenue. Our primary task was to create a dynamic Power BI dashboard to glean insights from their historical data.

Key areas of focus included:
1. Developing an interactive Power BI dashboard for real-time data analysis.
2. Implementing crucial hospitality domain metrics like RevPAR, ADR, DBRN, DSRN, and DURN.
3. Analyzing historical data to uncover revenue-enhancing opportunities.
4. Providing actionable insights to guide pricing and occupancy decisions.

During this project, I acquired the following skills and knowledge:
1. Proficiency in Power BI for data visualization and analysis.
2. Deep understanding of key hospitality metrics and KPIs.
3. Data-driven decision-making for pricing and occupancy optimization.
4. Effective data presentation to aid in strategic decision-making.

Live Interactive Dashboard