r
rohitg005

Rohit Gaikwad

@rohitg005

Data Analyst, SQL, Tableau, Power BI, Looker aka Data Studio, Python

India
Engels, Hindi, Marathi
Sommige informatie wordt in het Engels weergegeven.
Over mij
Hi, I'm Rohit Gaikwad, a Data Analyst with a background in Mechanical Engineering. I specialize in turning complex datasets into clear, actionable business insights. Whether it's cleaning messy Excel files, writing SQL queries, or building interactive dashboards in Power BI and Tableau, I am dedicated to helping businesses make data-driven decisions. My goal is to provide high-quality, accurate work that saves you time and scales your operations. Let's discuss how I can help you with your next project!... Lees meer

Skills

r
rohitg005
Rohit Gaikwad
offline • 
Gemiddelde reactietijd: 10 uur

Bekijk mijn diensten

Formules en macro's
I will fix google sheets and excel formulas
VanafUS$ 10 / projectMeer informatie
Data dashboards
I will create professional looker studio dashboards and data reports
VanafUS$ 25 / projectMeer informatie

Portfolio

Werkervaring

Upwork

LIVE interactive Looker Studio (aka Google Data Studio) Dashboard creation using Bigquery and data source is from Google sheet that regulary updates

Upwork • Freelance

May 2026 - Jun 2026 • 1 mo

Short description : 1. Clean data using SQL on Bigquery 2. Create links from Google Sheet that regulary updates in "Views" of Bigquery 3. Create *LIVE interactive Dashboard in Looker Studio (aka Google Data Studio). Full Details 1. Database Architecture & Modular Views Multi-Layer Design: Engineered a modular database architecture inside Google BigQuery consisting of a clean foundational base view fed into multiple specialized summary views. Consolidated Aggregations: Structured the logic to dynamically track and compute vital sales and operational metrics. 2. SQL Cleaning & Data Pipeline Optimization Structural Imputation: Standardized the raw database by filtering out blank entries, eliminating corrupted header rows, and dropping redundant, duplicating columns to preserve data integrity. Data Typology & Formatting: Standardized irregular text timestamps into clean, uniform date formats suitable for time-series reporting. Categorical Domain Mapping: Applied conditional mapping to text fields (specifically identifying variations in course columns) to clearly segment product offerings into distinct categories (such as Front End vs. Back End data tracks). 3. Metric Reconciliation & Quality Assurance Discrepancy Auditing: Audited and successfully resolved mathematical mismatches between the client's legacy ECom dashboard numbers and the backend data feeds. Validation Logic: Applied consistent date filtering and row-count verification scripts to ensure that the database records matched live transactional values 1:1. 4. Cloud Access Controls & IAM Troubleshooting 5. Looker Studio Dashboard Customization Filter Consolidation: Created high-level interactive filters within Looker Studio to replace fragmented selectors, giving the client a unified view of operational performance. Executive Formatting: Tailored the final report views to isolate KPIs regarding cash tracking and call-conversion velocity for quick decision-making.