Project Details

Unified Power BI Report for AtliQ Stakeholders

Goals:

Create a report for Sales, Marketing, Finance, and Executives.

Key Focus Areas:

1. Robust Data Model: Ensure data integrity and efficient analysis.
2. User-Centric Reports: Cater to specific needs of each department.
3. Drillable Insights: Allow users to explore data in detail.

Skills Acquired:

1. Power Query: Basic & Advanced Techniques
2. DAX Formulas: Mastered Basic & Complex Formulas
3. Data Modeling: Expertise with 10+ Interconnected Tables
4. Visualizations: Selecting Effective Visuals & Formatting
5. User Experience: Utilizing Bookmarks for Navigation
6. Deployment: Power BI Service Platform
7. Stakeholder Engagement: Actively Integrating Feedback
8. Metrics Analysis: Reporting Across Sales, Marketing, Finance & Supply Chain

Live Interactive Dashboard

Project Details

Drowning in unorganized HR data? We were too! Attendance, leave, WFH stats - everything was there, but it lacked a clear picture. We needed insights to manage our workforce and employee well-being.

Enter Power BI! It unlocked hidden trends by centralizing all data sources and creating interactive visualizations. Charts and graphs revealed patterns in attendance, WFH, and sick leave. We saw peak sick leave times, tracked WFH adoption, and identified attendance drops.

Weekly breakdowns provided deeper insights. We pinpointed issues and took action, leading to a healthier, more productive work environment.

Power BI wasn't just about numbers - it revealed employee well-being, work styles, and trends. This empowered data-driven decisions for both employees and the organization.

This project showcased the power of data in HR. We mastered data prep, visual storytelling, and Power BI dashboards - skills crucial for optimizing workforces, boosting productivity.

Live Interactive Dashboard

Project Details

Unmasking the Impact of Layoffs

This project dives into the complex world of layoffs. We'll use SQL as our tool to uncover hidden truths across five key areas:

- Industry Under Siege: Which industries are getting hit the hardest?
- Layoff Rhythms: Are layoffs seasonal or cyclical patterns?
- Global Landscape: Where are layoffs geographically concentrated?
- Company Size & Funding: Do size or funding affect layoff decisions?
- Economic Footprints: Can layoffs predict economic trends?

By honing our SQL skills, we'll learn to:

- Filter & Focus: Find the data that matters most.
- Uncover Patterns: Group data to reveal hidden trends.
- Connect the Dots: Combine data sets for a bigger picture.
- Visualize Insights: Sort data for clear and impactful presentations.

Expect clear deliverables:

- Powerful Queries: We'll craft SQL queries to answer our questions.
- Actionable Insights: Data translated into actionable findings.

Project Details

Vrinda Store's data wasn't just numbers – it was a story waiting to be told!

We cleaned and organized the data, ensuring accuracy and a complete picture. This journey revealed valuable insights:

- Sales Trends: We charted Vrinda's sales journey, uncovering patterns and seeing how products performed over time.

- Customer Focus: We identified key customers and purchase behaviors, allowing for targeted strategies.

- Regional Variations: We analyzed sales across different regions, pinpointing potential opportunities.

- Product Powerhouse: We evaluated each product's performance and identified any underperformers for further analysis.

Through compelling visuals, we brought these insights to life, empowering Vrinda Store to make data-driven decisions.

Project Details

Maven Roasters: Data-Driven Coffee Success

We analyzed sales data to boost Maven Roasters, a popular NYC coffee shop with 3 locations.

Goals:

Sales rhythm: How sales fluctuate over time.

Peak hours: Busiest days and reasons behind surges.

Top sellers: Products driving revenue and customer loyalty.

Insights:

Morning rush: Sales peak 7am-10am. Ensure staff and supplies are ready for early birds.

Weekday trends: Mondays and Fridays are busiest, suggesting a start/end-of-week coffee ritual. Promotions on these days could be a hit.

Product mix: Coffee and tea are popular, but packaged chocolate lags. Consider offering new varieties or promotions to boost sales.