Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Project video

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Project Details

🎯 Task: Crafting Compelling Insights - Unveiling film Production Performance.
🛠️ Approach: I skillfully harnessed MySQL Workbench, transforming data into valuable assets. My mission: Generate insightful reports and seamlessly export them to CSV files. When necessary, I breathed life into data through meticulous formatting and visualization.
📚 Key Learnings:
✅ Data Retrieval: I mastered SELECT, WHERE, DISTINCT, LIKE, and BETWEEN to summon the right data.
✅ Sorting & Filtering: With ORDER BY, LIMIT, and OFFSET, I orchestrated data for clarity.
✅ Aggregate Functions: SUM, MIN, MAX, AVG, GROUP BY, and HAVING unveiled hidden trends.
✅ Advanced Functionality: From JOINS to Subqueries and Correlated Subqueries, I navigated complex data relationships.
✅ Analytical Prowess: CASE, YEAR, CURYEAR, IF, CTEs, User Defined Functions, and Window Functions empowered me.
🚀 Insights & R : top movies , finance ( top revenue) My reports not only delivered actionable insights

Project video