Skip to content
View ron-kothari's full-sized avatar
πŸ’­
πŸ“Š Finishing up a PowerBI Dashboard!
πŸ’­
πŸ“Š Finishing up a PowerBI Dashboard!

Block or report ron-kothari

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ron-kothari/README.md

Hey, I am Ron

Business & Data Analyst | Power BI, SQL, Python | Turning raw data into decisions

Tableau LinkedIn Gmail

Data Analytics Animation

🧭 About Me

I am studying Computer Science and looking for full time roles in Business Analysis, IT Analysis, and Data Analytics. Through my internships I built incident management frameworks, worked closely with stakeholders, and learned how to solve problems that cross different teams.

I like taking messy data and turning it into something a business can actually use. Most of that work sits in this GitHub, spread across SQL projects, Power BI dashboards, and Business Analyst documentation. Take a look around and see what I have been building.

  • πŸ”­ Currently building out my data analytics portfolio and applying to full time roles
  • 🌱 Sharpening my Python and DAX skills project by project
  • πŸ’¬ Ask me about Power BI data modeling, SQL querying, or business requirements documentation
  • I love soccer ⚽️, chess β™ŸοΈ, aviation ✈️ and history πŸ“–

If you want to talk about a project, an opportunity, or just want to collaborate, email me anytime or connect with me on LinkedIn. I am always happy to chat.


πŸ› οΈ Tech Stack

SQL Power BI Python Tableau Excel Jira Google Apps Script


πŸ“Œ Featured Projects

πŸ“Š Business Intelligence Dashboards

Project What it does
AdventureWorks Power BI Dashboard Star schema, custom DAX, and drill through for executive, regional, product, and customer level insight
Maven Markets Power BI Dashboard Two page dashboard covering sales performance, regional trends, and product detail across the USA, Mexico, and Canada
Customer Retention & Churn Analytics Full workflow from SQL to DAX, measuring retention, churn, and customer lifetime value
Sales Analytics Dashboard (DAX Heavy) Dynamic bookmarks and complex DAX for both executive and operational level tracking
Superstore DAX & Star Schema Analysis 3 years of sales data modeled and visualized for executive decision making

🐍 Python & SQL Analysis

Project What it does
Spotify Analytics Dashboard Power BI plus Python, with a custom heatmap and Spotify API album art
IMDb / Netflix Data Analysis Genres, languages, and durations analyzed to uncover Netflix content trends
Pizza Sales Analysis A full year of pizza sales broken down by revenue, order patterns, and top products
Spotify Top 50 Tracks (SQL) SQL deep dive into the audio patterns behind what makes a song a hit
Cycling Club Relational Database Relational database covering members, bikes, and track times, queried for activity trends

πŸ“‹ Business Analyst Work

Project What it does
Customer Query Management System Full BA lifecycle from business problem to Agile delivery, using Jira and wireframes
Requirement Documentation Examples Core BA documents built to BABOK standards for requirements tracing and stakeholder alignment

🎨 Also on Tableau

I build interactive Tableau visualizations alongside my Power BI work.
πŸ“ View my Tableau Public profile


πŸ’Ό Open to Business Analyst, IT Analyst, and Data Analyst roles
πŸ“© Let us connect if you are hiring or just want to talk data

Tableau LinkedIn Gmail

Pinned Loading

  1. AdventureWorks-Power-BI-Dashboard-Project AdventureWorks-Power-BI-Dashboard-Project Public

    A Power BI dashboard for AdventureWorks Cycles, a fictional bike manufacturer, built on a star schema with custom DAX measures and finished with drill through and bookmarks for executive, regional,…

  2. Customer-Query-Management-System Customer-Query-Management-System Public

    A simulated Business Analyst project covering the full lifecycle, from business problem and requirements through design and Agile delivery, for a customer query management system.

  3. Customer-Retention-and-Churn-Analytics Customer-Retention-and-Churn-Analytics Public

    An end to end customer analytics project using SQL, Power BI, and DAX to measure retention, churn, and lifetime value, covering the full workflow from data cleaning to churn insights.

  4. Cycling-Club-Data-Analysis-SQL Cycling-Club-Data-Analysis-SQL Public

    Built a relational database for a cycling club covering members, bikes, track times, and locations, then wrote SQL queries to surface member activity and track performance trends.

  5. Requirements-Documentation-Examples Requirements-Documentation-Examples Public

    A set of core business analysis documents built to BABOK standards, used to track requirements and keep stakeholders aligned.

  6. Spotify-Analysis-Dashboard-PowerBI-Project Spotify-Analysis-Dashboard-PowerBI-Project Public

    A Spotify analytics dashboard built in Power BI with Python integration, covering streaming data, artist and track performance, and listener behavior across 2024 through a custom heatmap, album art…

    Python