Project Details

Extract:
Begin with the extraction of 6 CSV files, each brimming with valuable information about AtliQ Hardware's customers, market dynamics, product catalog, and sales transactions.

Transform:
Harness the power of Power Query and Power Pivot to Mold this raw data into actionable insights. With Power Query, embarked on a journey of data cleaning and column transformations. In Power Pivot, delved into data modelling, crafting calculated columns, and unleashing the strength of DAX measures to extract deeper meaning.

Load:
With the transformation complete, witness the data seamlessly loaded into Excel. Pivot table is created to summarize and analyze the data.
• Sales Analytics, offering a panoramic view of customer behaviour, market trends, product performance, and divisional insights.
• Finance Analytics stand ready to provide comprehensive financial summaries, empowering strategic decision-making based on critical financial indicators.

Project video

Project Details

Delved into the world of data-driven insights with our analysis of Mitron Bank's dataset. Discovered key findings and unlocked valuable insights as we visualize the data in Power BI. Explored detailed spending analysis, identified key customers and their demographics, and delved into credit card usage patterns. Plus, gained actionable recommendations to help Mitron Bank attract more customers and increase card usage.

Key Findings:
1. Among all the payments, customers primarily use Credit card for spendings.
2. Customers spend primarily on bills, groceries, electronics, and health & wellness.
3. Most of the spendings are made by male customers and married customers.
4. 25-35 and 35-45 age groups spend most among all the age groups.
5. Mumbai customers spends the most among all the cities.
6. Majority of the transactions are made by Salaried IT Employees and Salaried Other Employees.

Project video

Project Details

Collect:
Transformed raw data from MySQL database and Excel/CSV files into Power BI, creating a comprehensive dataset spanning 15 interconnected tables.

Process:
Rigorous data quality assurance in Power Query ensured dataset cleanliness, eradicating duplicates and rectifying inconsistencies. Leveraging advanced DAX functions, crafted calculated columns and measures to enhance data accuracy and enable deeper analytical insights.

Visualize:
Tailored distinct perspectives for varied departments including Finance, Sales, Marketing, and Supply Chain within the Power BI environment. Strategically curated visuals to maximize insights, leveraging formatting techniques for enhanced clarity. Integrated Key Performance Indicator (KPI) indicators to facilitate intuitive comprehension of crucial metrics. Implemented seamless page navigation through button-driven interfaces and streamlined visualization transitions using bookmark functionality.

Project video

Project Details

AtliQ Mart, a retail giant with over 50 supermarkets in southern India, recently conducted massive promotions during Diwali 2023 and Sankranti 2024 on their AtliQ branded products. We identified two key metrics: Incremental Sold Units (ISU%) and Incremental Revenue (IR%). Let's explore the key areas:
1. Store Performance: We'll examine the sales impact across different stores and cities, identifying locations with significant sales boosts during the promotional periods.
2. Promotion Type Analysis: We'll analyze the effectiveness of various promotions like discounts, buy-one-get-one-free offers, and ₹500 cashback deals to understand which strategies resonated most during both festive seasons.
3. Product & Category Analysis: We'll delve into the sales performance of different products and categories, highlighting items with the highest increase in sales.

Project video

Project Details

AtliQ Media, a private media company, is gearing up to telecast a comprehensive show on the Lok Sabha elections 2024 in India. Our goal is to present insights from the 2014 and 2019 elections without any bias, focusing on less explored themes like voter turnout percentage in India.
Our dashboard is categorized into three reports:
1. Overview: Let’s explore the total constituencies, total electors, total postal votes, total votes, and voter turnout ratio. We'll examine the voter turnout ratios for the top/bottom 5 constituencies and states, comparing the 2014 and 2019 elections.
2. State Level Analysis: We will analyze the candidates' votes in each state, the percentage of votes for parties, and the winning candidate and their vote share.
3. National Level Analysis: We will look at the percentage of votes at the national level and the constituencies that have gained or lost vote share compared to the 2014 elections in the 2019 elections for BJP and INC parties.

Project video