Project Details

In my role as a Marketing Data Analyst, I embarked on an exciting adventure, using the mighty Power BI to dive into a huge survey. Imagine, we had responses from 10,000 people across ten cities, and I wanted to turn this pile of data into golden insights for our marketing game plan.

Power BI was like my trusty sidekick. It helped me dig deep and find cool stuff in the data, like hidden patterns and trends. It was like sailing through a sea of numbers, and with Power BI's magic, I uncovered all the important treasures that would help us make smart choices.

But wait, the journey didn't stop there. Power BI wasn't just about numbers; it was also about making those numbers come to life. With its superpowers in creating awesome charts and colorful graphs, I spun the data into visual stories that anyone could understand. These story-pictures became our compass, guiding the Marketing team toward super-smart decisions that would lead us to success.

Project video

Project Details

In this project, I examined the dashboard data to grasp the impact of introducing 5G on our business.

1.Identified Underperforming KPI: Determined which key performance indicator (KPI) did not meet expectations post the 5G launch.

2.Evaluated Plan Performance: Studied revenue trends to identify successful plans and those needing enhancement.

3.Plan Performance Analysis : Analyzed how 5G affected different plans, suggesting whether they should continue or be discontinued.

4.Discontinued Plan Analysis: Explored plans discontinued after 5G's launch, providing reasons behind these decisions.

5.Offering Recommendations Based on Insights: I provided actionable recommendations informed by the insights, facilitating astute decisions for future strategies and business expansion.

Project video

Project Details

1.Top Districts by Domestic Visitors: Identified districts with the highest influx of domestic tourists, highlighting prime destinations.

2.Growth Champions (2016-2019): Recognized top 3 districts with impressive CAGR, indicating areas of rapid development.

3.Challenges and Opportunities: Revealed bottom 3 districts with sluggish growth, suggesting focus areas for improvement.

4.Seasonal Peaks and Lows: Pinpointed peak and low months for Hyderabad's domestic and foreign visitors, aiding resource allocation.

5.Domestic-Foreign Mix: Analyzed domestic to foreign tourist ratio, spotlighting districts with varying appeal.

6.Population-Tourism Dynamics: Disclosed top and bottom 5 districts based on 'population to tourist footfall ratio' in 2019.

Project video

Project Details

This is a project I have done as part of Codebasics SQL Project Challenge. Following are the key highlights of this project:

1. SQL - I have used SQL to query the database. Applied many important concepts in SQL like Subqueries, Multiple joins, CTE, Window functions, etc.

2. Power BI - Visualized the extracted data using Power BI. Used different visuals like Bar Chart, Line Chart, Donut Chart etc. to clearly communicate the insights from the data.

3. MS PowerPoint - The final output of the project was a video presentation I have created in PowerPoint. I explored various features in PowerPoint to make the presentation effective. You can find]the Presentation PDF on my profile.

Project video

Project Details

In my role as a Pricing Analyst at 'Pubs "R" Us,' my primary goal revolves around delving deeply into the data encompassing drinks prices and sales. The core objective is to extract invaluable insights that shed light on the performance of our diverse pub chain.

This intriguing SQL challenge becomes the conduit through which I navigate intricate concepts such as 'Where,' 'Group by,' 'Order by,' and 'Limit.' These fundamental building blocks empower me to dissect the data effectively and gain a more focused understanding of our operations.

Beyond these, the application of 'Aggregate Functions', 'Common Table Expressions (CTEs)', and 'Subqueries' brings an added layer of sophistication to my analysis.

Project video

Project Details

Summary View:
1.Offers a holistic snapshot of total employees, gender distribution, and gender-specific promotion trends.
2.Reveals diversity distribution across departments and age groups.

Hiring View:
1.Highlights new hire diversity distribution by department.
2.Showcases the percentage of male and female hires in 2020, alongside annual trends in female hiring.

Promotions View:
1.Compares gender-specific promotions in critical years (2019, 2020).
2.Breaks down promotions across job levels.
3.Presents the percentage of promoted individuals during these years.

Performance View:
1.Facilitates a comprehensive comparison between fiscal years 2019 and 2020.
2.Displays average performance ratings for both fiscal years.

Turnover View:
1.Provides a detailed turnover analysis, including a year-on-year comparison (2020 vs. 2021).
2.Analyzes turnover rates across distinct age groups.

Project video