Parcourir les catégories
Explorer
Fiverr Pro
Français
$
USD
Rohit Gaikwad
@rohitg005
Data Analyst, SQL, Tableau, Power BI, Looker aka Data Studio, Python
Inde
Anglais, Hindi, Marathi
À propos de moi
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!
Compétences
Rohit Gaikwad
hors ligne •
Temps de réponse moyen de 10 heures
Voir mes services
Formules & Macros
I will fix google sheets and excel formulas
Tableaux de bord des données
I will create professional looker studio dashboards and data reports
Portfolio
Expérience professionnelle
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.
