Project Details

Problem Statement:
AtliQ is a fast-growing hardware company that sells various products to customers in many countries through various channels, including retail, direct sales, and distributor networks, both online and in brick-and-mortar stores. To support its growth and make data-driven decisions, AtliQ needs a data analytics team.
Workflow steps:
 ETL (Extract, Transform, Load) in excel.
 Solution design thought process.
 Creating connections among tables using data modelling.
 Adding the Date table using Power Query(M language).
 Functional knowledge in Sales, Finance and Profit & Loss.
 Creating Customer performance report.
 Creating Market performance vs Target report.
 Creating P&L reports by year, quarters and months.
 Further analysis of the given data by solving the assignment problems.

Project video

Project Details

Problem Statement:
AtliQ Grands owns multiple five-star hotels across India. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands is losing its market share and revenue. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue.
Workflow steps:
1. Data collection and exploration, create a Date table in Power Query (M language).
2. Data load to Power BI and initial validation.
3. Data Transformation in Power Query.
4. Data Modelling and creating calculated columns.
5. Creating measures using the DAX language.
6. Build Executive View, Finance View, Revenue View, Occupancy and Booking View and Key Metrics View.
7. Designing an effective Dashboard that includes page navigation with buttons, tooltips, using KPIs, and conditional formatting of the values in visuals.
8. Deploying the solution using Power BI.

Project video

Project Details

Problem statement:
AtliQ is a fast-growing hardware company that sells various products to customers in many countries through various channels, including retail, direct sales, and distributor networks, both online and in brick-and-mortar stores. To support its growth and make data-driven decisions, AtliQ needs a data analytics team.
Tech stacks:
• SQL
• Power BI
• Excel
• DAX Studio
• PowerPoint
• Languages- M , DAX
🔵 Workflow steps: 🔵
1. Project planning and scoping.
2. Project Charter
3. Data collection and exploration, create a Date table in Power Query
4. Soft skills associated with project management
5. Data load to Power BI and initial validation.
6. Data Transformation in Power Query.
7. Data Modelling and creating calculated columns.
8. Creating measures using the DAX language.
9. Build Finance View, Sales View, Market & Supply Chain View.
10. Data validation set up like creating user acceptance test report.
11. Implementing stakeholder feedback.

Project video

Project Details

In this project, I delved into 10 Ad-hoc queries, unraveling key details about top products, customers, markets, and crucial metrics like gross price, pre-invoice deductions, manufacturing costs, and sales quantity. “It's all about turning data into actionable insights!".

Tools Used:
- MySQL Workbench (For getting insights using SQL)
- Microsoft Excel (For data visualization)
- Microsoft PowerPoint (For presentation)

Knowledge gained in:
1. Database Exploration with MySQL Workbench.
2. Data Management Concepts.
3. Database Design Principles.
4. Data Integrity and Relationships.
5. SQL Querying Expertise.
6. Advanced Query Techniques.
7. Understanding Datatypes.
8. Window Functions.
9. Database Optimization Techniques.

Project video

Project Details

"Sports Basics" is a sports blog company that entered space recently. They wanted to get more traffic to their website by releasing a special edition magazine on IPL 2024. This magazine aims to provide interesting insights and facts for fans, analysts, and teams based on the last 3 years' data.

🏏 Tech Stacks: 🏏
⭐ Power BI for ETL, data modeling, visualizations, and insights
⭐ PowerPoint for presentation
⭐ SQL for data validation
⭐ Languages- M, DAX, SQL

🏏 Workflow steps: 🏏
⚡ Data load to Power BI and initial validation.
⚡ Data Transformation in Power Query.
⚡ Data Modeling and creating calculated columns.
⚡ Creating measures using the DAX language.
⚡ Analyzing the data using primary and secondary queries, further predicting the top 11 players for IPL 2024.
⚡ Designing an effective Dashboard that includes page navigation with buttons, tooltips, using KPIs, and conditional formatting of the values in visuals.
⚡ Deploying the solution using Power BI Service.

Project video

Project Details

AtliQ Mart is a retail giant with over 50 supermarkets in India. All the stores had promotional sales during Diwali 2023 and Sankranti 2024. Sales Director Bruce Hariyali wants tangible insights regarding these promotional sales to make informed decisions for their next sales.

⚒ Teck Stacks: ⚒ - ♠ Microsoft Power BI ♠ MySQL workbench, MySQL database, SQL♠ Microsoft PowerPoint
🔦Insights: 💡
♦ The top 3 cities performing well are Bengaluru, Chennai, and Hyderabad.
♦ The bottom 3 cities that need improvement are Trivandrum, Vijayawada, and Mangalore.
♦ Revenue after promotions is the highest for the 500 Cashback promo type which is 158M INR followed by 95M INR for the BOGOF promo type.
♦ The 25% OFF, 33% OFF and 50% OFF promo types showed a decrease in revenue after the promotion.
♦ The top 3 categories w.r.t IR% are Home Appliances, Home Care, Combo1.

Project video