Portfolio - Aditya Goel

PowerBI Project

Business Insights 360

Problem: AtliQ Hardware hit limits with Excel data management. Mission: Excel to Power BI for insights. Objective: Insights into finance, sales, marketing, supply chain. Volume: 1.8M records. Tools: SQL, Power BI, Excel, DAX Studio, ChatGPT, Google.

View Project
Engagement

Landing page of dashboard showcasing key areas of report.

Detailed snowflake schema representing the data model for structured analysis.

Project Details

Project Description*Project Walkthrough:
📝Planning: Defined the scope, targeting Finance,Sales,Marketing,Supply Chain
📊 Data Collection: SQL for extraction. Ensured accuracy and data completeness.
🔄 Data Loading: Integrated data into Power BI via MYSQL.
✅ Data Validation: Checked Power BI data against benchmarks.
🛠 Data Transformation:Power Query for data shaping; added columns, merged tables.
🧪 UAT: Collaborated with stakeholders for dashboard accuracy
🔄 Feedback: Implemented end-user suggestions.
⚙️ Optimization: DAX Studio for enhanced performance.
🚀 Deployment: Used Power Bi Desktop Service and Gateways for live connection.

Learnings:
- Power Query & DAX
- Data modeling with snowflake schema
- Creating & formatting visuals.
- Dashboard design principles.
- Using bookmarks.
- Deployment in Power BI service.
- Stakeholder feedback implementation.
- Metrics creation for different departments.

Project video

Live Interactive Dashboard

PowerBI Project

CodeX Survey Insights

CodeX, a German beverage firm, has ventured into the Indian market with its energy drink. To gauge its impact, they surveyed 10 cities, gathering feedback from 10k respondents. As their marketing analyst, Peter Pandey, our task is to derive actionable insights from this data, guiding CodeX's future.

View Project
Engagement

Landing Page with access to various insights & recommendations.

Dedicated video for potential "Brand Ambassador" for Codex Energy drink on Youtube ! Check out Project Engagement For Link

Project Details

🎯Task:
Provide Insights & Recommendations to CodeX based on survey data.
⚙️Tools:
PowerBi || Data Analysis(DAX),Data Visualisation & Smart Narratives(AI summary)

Resources Provided:
dim_respondents: Data on respondents, covering age, gender, and city.
dim_cities: Details on city names and tier categories.
fact_survey_responses: Deep dive into consumption frequency.

Project Focus:
Demographic Insights: Analyze age, gender distribution, and city preferences.
Consumer Preferences: Gauge the appeal of CodeX's energy drink.
Competition Analysis: CodeX's standing against competitors.
Brand Penetration: Measure brand reach and acceptance in varied cities.
Marketing Channels & Awareness: Examine advertising channel impacts.
Purchase Behaviour: Insights into buying habits, frequencies, and patterns.
Product Development: Recommendations for product enhancements.
Recommendations: Data-driven advice for optimizing CodeX's approach.

Project video

Live Interactive Dashboard

Excel Project

Personal Expense Tracker

Ever had that 'Where did my money go?' moment? I've been there too. That's why I created this Excel tool. Just jot down your buys and bills, and see the whole picture in the Dashboard. It's like a friend helping you keep tabs. Know your spends, plan better, and breathe easy.

View Project
Engagement

A summarized view showcasing monthly and yearly finances at a glance, highlighting trends and offering insights from your entered expenses.

Easily log expenses by entering the date, selecting a category from a dropdown, specifying the amount, and adding an optional description.

Project Details

📝 Objective Setting: Aimed to provide a straightforward tool for individuals to track and understand their personal expenses.
📚 Data Input: Created an "Input Journal" for users to manually record daily expenses and incomes.
🔧 Dashboard Creation: Built a "Dashboard" for a summarized view of monthly and yearly expenses, providing a clear financial picture.

✨ Features:
Data Validation: Ensured correct data entry with Excel's data validation features.

Conditional Formatting: Highlighted specific cells based on certain conditions to enhance user clarity.

Aggregation: Used SUMIF to summarize expenses by category and month.

Insights: Displayed month-on-month (MoM) percentage growth to track spending trends.

Result Achieved: An organized "Personal Expense Tracker" that offers both granular and summarized views of personal finances, aiding in better financial management and planning.

Hello, I am

Aditya Goel

1

2

About

Key

My

Business Insights 360

CodeX Survey Insights

Personal Expense Tracker

Awards

Contact Me

Email

Linkedin

Call

Aditya Goel

Download Resume