Portfolio Hub: Comprehensive data analytics portfolio showcasing business intelligence dashboards, statistical analysis, and data visualization projects. This repository serves as the central hub for analytics projects demonstrating end-to-end capabilities from data extraction and transformation to business insights and visualization.
With a background in business consulting and operations management, I bring a unique perspective that bridges technical analysis with strategic business impact. From Power BI dashboards with row-level security to large-scale statistical analysis in Python and R, this portfolio demonstrates systematic progression from foundational analytics to enterprise-ready business intelligence solutions.
Live Portfolio: mohitpammu.github.io/Projects
Edureka Business Analyst using Power BI Certification (2024)
- Analyzed 546K+ employee records to uncover critical retention patterns across 6 regions
- Implemented row-level security for 6 regional roles enabling distributed data access
- Key Insight: Revealed 73% of new hires are under 30 yet this age group drives highest separations—identifying targeted intervention opportunities
- Business Impact: Data-driven workforce planning and retention strategy development
Tech Stack: Power BI, DAX, Row-Level Security, Data Modeling
View Project Details
Edureka Business Analyst using Power BI Certification (2024)
- Analyzed $62.3M in sales across 51K+ transactions spanning global markets
- Implemented row-level security for regional roles (Africa, Europe)
- Key Insight: Identified critical profitability challenge—2.4% profit ratio with Central Asia operating at -9.4% loss despite 23.8% average annual growth
- Business Impact: Strategic profitability interventions and regional performance optimization
Tech Stack: Power BI, DAX, Multi-Market Analysis, Profit Analytics
View Project Details
Google Data Analytics Professional Certificate (2024)
- Analyzed 4.3M+ ride-sharing records using R to identify conversion opportunities
- Delivered 5 actionable marketing recommendations for casual-to-member conversion
- Key Insight: Member and casual rider behavior patterns reveal distinct usage profiles enabling targeted marketing
- Business Impact: Data-driven customer acquisition and retention strategy
Tech Stack: R, tidyverse, ggplot2, Statistical Analysis
View Project Details
MIT Professional Education Applied Data Science Program (2024)
- Analyzed 1,898 orders to identify trends in restaurant popularity, cuisine preferences, and delivery performance
- Generated strategic recommendations for menu optimization and operational efficiency
- Key Insight: Customer rating patterns and delivery time analysis reveal service optimization opportunities
- Business Impact: Revenue growth through data-driven operational improvements
Tech Stack: Python, Pandas, Matplotlib, Seaborn, EDA
View Project Details
Edureka Business Analyst using Power BI Certification (2024)
- Analyzed Northwind database (2,155 order details, 830 orders) with advanced time intelligence DAX
- Revealed 80% YoY growth alongside customer concentration risk (top 3 = 25.6% of revenue)
- Features cascading filters, drill-through pages, and Q&A natural language interface
Tech Stack: Power BI, DAX, Time Intelligence, Customer Segmentation
View Project Details
Edureka Business Analyst using Power BI Certification (2024)
- Analyzed 5,806 Netflix titles with Power Query transformations and DAX measures
- Platform composition: 65% movies vs. 35% shows, with shows averaging 13% higher IMDB ratings
- Demonstrates dashboard design and data visualization fundamentals
Tech Stack: Power BI, Power Query, Data Visualization
View Project Details
MIT Professional Education Applied Data Science Program (2025)
- Achieved ~90% accuracy with 38.6% parameter reduction through systematic experimental analysis
- Developed edge-compatible solution for resource-constrained deployment scenarios
Tech Stack: Python, TensorFlow, CNN Architecture, AutoML
View Repository
MIT Professional Education Applied Data Science Program (2025)
- Achieved ~82% accuracy using custom CNN architecture optimized for grayscale images
- Outperformed transfer learning models (VGG16, ResNet101, EfficientNetV2)
Tech Stack: Python, TensorFlow, CNN, Computer Vision
View Repository
Core Analytics Stack
Python Ecosystem
Expanding Into
Specializations
- Business Intelligence & Dashboards • Statistical Analysis & EDA • Data Visualization & Storytelling • DAX & Advanced Calculations • Row-Level Security & Data Governance
Tools & Platforms
- Power BI Desktop • Power Query • Jupyter Notebooks • RStudio • Git/GitHub • VS Code
Business Foundation: 5+ years in consulting and operations management, including business analysis for $50M+ healthcare projects and managing restaurant operations
Analytics Focus: End-to-end analytics workflow from data extraction and transformation (SQL, Power Query) to analysis (Python, R) and visualization (Power BI, dashboards)
Unique Value: Combines technical analytical skills with real-world business experience to deliver insights that drive measurable organizational outcomes. Focus on asking the right questions before writing the first query.
This portfolio demonstrates:
- Business Impact Orientation: Every project connects technical analysis to concrete business recommendations
- End-to-End Capabilities: From data cleaning and transformation to advanced analytics and interactive dashboards
- Technical Depth: Row-level security, advanced DAX, time intelligence, statistical analysis
- Clear Communication: Documentation and visualization designed for both technical and business stakeholders
- Progressive Complexity: From foundational analytics to enterprise-ready BI solutions
Interactive Elements
- Responsive design with dark/light mode toggle
- D3.js skills network visualization
- Project filtering by tool/category (Power BI, Python & R, Machine Learning)
- Integrated contact form
Performance Optimized
- Mobile-friendly responsive layout
- Semantic HTML for improved SEO
- Modular code structure for maintainability
# Clone the repository
git clone https://github.com/MohitPammu/Projects.git
cd Projects
# Start local server
python -m http.server 8000
# View at http://localhost:8000Projects/
├── index.html # Main portfolio landing page
├── css/ # Styling files
├── js/ # Interactive elements (D3.js, filtering)
├── assets/ # Images, resources, data files
├── projects/
│ ├── EDA/ # Exploratory Data Analysis
│ │ ├── Cyclistic/ # Bikeshare analytics (R, Google certification)
│ │ │ └── cyclistic-google-data-analytics-capstone.html
│ │ └── FoodHub/ # Restaurant delivery analysis (Python)
│ │ └── MohitPammu-FDS_Project.html
│ └── BI & Visualization/ # Business Intelligence Projects
│ ├── HR Data/ # HR workforce analytics (Power BI, RLS)
│ ├── Global-Sales-Performance-Dashboard/ # Sales profit analysis
│ ├── Sales-&-Customer-Analytics-Dashboard/ # Time intelligence
│ └── Netflix Content Analysis/ # Content strategy dashboard
└── README.md # This documentation
Learning: Advanced SQL (window functions, CTEs, optimization)
Building: SQL-based analytics projects demonstrating database querying and data transformation
Goal: Expand into predictive analytics and machine learning applications
Open to: Data Analyst, BI Analyst, Analytics Engineer roles
Open to discussing data analytics opportunities, collaborative projects, or technical conversations.
Email: mopammu@gmail.com
LinkedIn: linkedin.com/in/mohitpammu
Portfolio: mohitpammu.github.io/Projects
Location: Laurel, MD (Washington DC Metro Area)
Transforming data into actionable business insights
© 2025 Mohit Pammu