From Raw Data to Board-Ready Insights — that's the standard I hold every project to.

I'm a Data Analyst specializing in Power BI, SQL, and Python — building end-to-end analytics solutions that go beyond visualization into actual business decision-making.

• 🌱 Learning: Microsoft Power BI Certification, TypeScript
• 🤝 Open to collaborate on: Data-driven projects, React.js applications, Dashboard development
• 💬 Ask me about: Data Analysis, Data Visualization, Frontend Development
• 🎯 Expertise: Data Analysis, Data Visualization, Frontend Development, API Integration, UI/UX Design
• 📫 Reach me at: jgohel9902@gmail.com

End-to-end churn risk dashboard modeled after real banking analytics workflows. Built with star schema data modeling, DAX measures, Power Query transformations, and a rule-based churn risk engine segmenting customers into Low, Medium, and High risk categories.

Power BI DAX Star Schema Churn Analysis Banking Analytics

🔗 View Repository

Analyzed 63,000+ transit incidents and 1M+ delay minutes across Toronto's transit network. Built a 3-layer executive dashboard covering KPI monitoring, route performance intelligence, and 3D Azure Maps geospatial hotspot analysis.

Power BI DAX Geospatial Analytics Azure Maps Executive Dashboard

🔗 View Repository

Full VS Code extension that brings real-time AI-powered code analysis directly into the developer workflow. Built a multi-model architecture supporting Codestral, Mistral, DeepSeek, Ollama, and OpenAI-compatible APIs — with full offline capability using LM Studio. Features include full-file review, selection-based analysis, AI refactoring, code explanation, and a built-in issues dashboard panel.

TypeScript VS Code API LLM Integration Node.js Prompt Engineering

🔗 View Repository

analytics_workflow = {
    "data_architecture" : ["SQL Server", "Star Schema", "ETL Pipelines"],
    "analysis"          : ["Python", "Pandas", "NumPy", "Scikit-learn"],
    "visualization"     : ["Power BI", "DAX", "Executive Dashboards"],
    "domains"           : ["Churn Analysis", "Healthcare", "Transportation",
                           "Banking", "Geospatial Analytics"]
}

Advanced Diploma in Computer Programming and Analysis - Conestoga College (2026)