Project Details

This project focuses on using Power BI to transform data processes at AtliQ Hardware, an electronic manufacturing company with a significant market share in hardware products. We overcame data collection challenges from various sources and implemented:

Project Charter for clear project guidance.
Data validation with benchmarks.
Data modeling with robust structures.
Data transformation using Power Query.
Optimized, user-friendly reports.
Stakeholder mapping for effective communication.
Dynamic financial overviews for Finance.
Redefined sales performance visuals.
Enhanced marketing analytics.
Supply chain visibility.
Executive dashboard with KPI visuals.
User Acceptance Testing (UAT) to ensure rigorous testing.
Utilized Power BI Services for real-time insights.
The project's aim is to provide data-driven insights to support AtliQ Hardware's growth trajectory.

Project video

Project Details

AtliQ Grands, a hotel chain seeking to expand its reach and market share, faced challenges in identifying growth opportunities and tracking performance due to the absence of an in-house data analytics team. To address these challenges, a comprehensive interactive dashboard was developed using Power BI, providing real-time insights into key metrics such as RevPAR, ADR, and occupancy rates. This data-driven approach empowered AtliQ Grands to optimize resource allocation, implement targeted marketing strategies, and enhance operational efficiency, ultimately driving growth and profitability.

Project video

Project Details

Codex conducted a survey, garnering responses from around 10,000 individuals. The goal is to extract meaningful insights from these responses to guide actionable strategies and decision-making for the marketing team, ultimately presented to the chief marketing officer.

Project video

Project Details

This project aims to help AtliQo, a leading Indian telecom provider, improve its 5G strategy and reverse the decline in active users and revenue growth. The project involves analyzing pre- and post-5G launch data using Microsoft Excel, MySQL, and Power BI to understand the impact of 5G on AtliQo’s key performance indicators (KPIs), such as monthly active users, average revenue per user (ARPU), customer satisfaction, and loyalty. The project also identifies the factors influencing these KPIs and provides actionable recommendations based on the analysis. The project focuses on the city-specific and plan-specific trends to help AtliQo optimize its 5G offerings and enhance its competitive edge.

Project video