Available for freelance BI projects

Rohit Gharat

Senior BI Consultant | Qlik Expert | Data Analytics Specialist

Transforming Data into Actionable Business Insights

Rohit Gharat — Senior BI Consultant
Dashboards delivered 120+
Qlik · Power BI · SQL
0Years Experience
0Dashboards Built
0Happy Clients
0Industries Served
Qlik Sense SQL Server Power BI ETL
About Me

Turning messy data into decisions leaders trust

I'm Rohit Gharat, a Senior Business Intelligence & Data Analytics Consultant with 10+ years of hands-on experience designing analytics platforms that move the needle. I partner with enterprises and growing businesses to replace spreadsheet chaos with governed, self-service dashboards people actually use.

My core craft is the Qlik ecosystem — QlikView and Qlik Sense — paired with Power BI for modern self-service reporting. Behind every clean visualization sits robust engineering: tuned SQL Server models, scalable data warehousing, and reliable ETL pipelines. As an independent freelance consultant, I own the full journey from raw source systems to executive-ready insight.

Business Intelligence

QlikView, Qlik Sense & Power BI dashboards built for scale.

Data Warehousing & ETL

Dimensional models and resilient data pipelines.

Data Visualization

Story-driven, decision-first dashboard design.

Analytics Consulting

Strategy, governance & freelance delivery, end to end.

Technical Skills

A full-stack analytics toolkit

From source data to the boardroom — these are the tools I use daily.

Business Intelligence
QlikView95%
Qlik Sense96%
Power BI90%
Databases
SQL Server93%
MySQL85%
PostgreSQL82%
Analytics & Engineering
Data Modeling92%
ETL90%
Data Warehousing88%
Reporting94%
Other
Python80%
Digital Marketing75%
WordPress78%
Career Journey

A decade building analytics that scales

Roles are samples — edit the timeline blocks in index.html to match your CV.

2021 — Present
Senior Qlik Consultant · Independent / Freelance

Lead Qlik Sense and QlikView delivery for clients across healthcare, retail and finance. Architect data models, mentor in-house teams, and own end-to-end dashboard delivery from requirements to production.

  • Qlik Sense
  • QlikView
  • Data Modeling
  • Consulting
2018 — 2021
BI Developer · Enterprise Analytics Team

Designed enterprise dashboards on Power BI and Qlik, built SQL Server data marts, and standardized KPI definitions across business units, cutting report turnaround time by 60%.

  • Power BI
  • SQL Server
  • Data Warehousing
2015 — 2018
Data Analytics Specialist · Consulting Practice

Delivered ETL pipelines and analytical models for clients, translating ambiguous business questions into governed datasets and self-service reporting layers.

  • ETL
  • Analytics
  • Reporting
2014 — 2015
Reporting Lead · Operations & MIS

Owned operational reporting and MIS, automating manual spreadsheets into scheduled dashboards and laying the foundation for a centralized BI function.

  • Reporting
  • SQL
  • Automation
Certifications

Credentials & continuous learning

Swap the placeholder images in assets/certificates/ with your real badges.

Microsoft Power BI certificate
Microsoft Power BI

Data Analyst Associate

Verified
Qlik Sense certificate
Qlik Sense

Business Analyst Certification

Verified
Data Analytics certificate
Data Analytics

Professional Certificate

Verified
SQL Server certificate
SQL Server

Database Development

Verified
Selected Work

Dashboards & analytics solutions

A sample of BI projects across industries. Click any tile to open a live, interactive demo dashboard.

Healthcare Analytics Dashboard Open dashboard
Healthcare Analytics Dashboard

Patient flow, bed occupancy and clinical KPIs unified into a single Qlik Sense command center for hospital leadership.

  • Qlik Sense
  • SQL Server
  • ETL
Sales Performance Dashboard Open dashboard
Sales Performance Dashboard

Region, rep and product drill-downs with target-vs-actuals and forecast trends, built in Power BI for a national sales org.

  • Power BI
  • DAX
  • SQL
HR Analytics Solution Open dashboard
HR Analytics Solution

Attrition prediction, headcount planning and DEI metrics surfaced through an interactive Qlik Sense workforce app.

  • Qlik Sense
  • Data Modeling
  • Python
Customer Retention Analytics Open dashboard
Customer Retention Analytics

Cohort analysis, churn drivers and lifetime-value segmentation to help a subscription business retain its best customers.

  • Power BI
  • SQL Server
  • Data Warehousing
Financial Reporting Dashboard Open dashboard
Financial Reporting Dashboard

Automated P&L, cash-flow and variance reporting consolidating multiple ledgers into one governed Qlik finance hub.

  • QlikView
  • ETL
  • SQL Server
What I Offer

Services & engagement models

Flexible freelance engagements — from one-off dashboards to long-term BI partnerships.

Qlik Dashboard Development

End-to-end QlikView & Qlik Sense apps — data modeling, scripting, UX and deployment.

Power BI Development

Modern self-service reporting with robust DAX, dataflows and row-level security.

Data Analytics Consulting

BI strategy, KPI design, governance and roadmap to make your data trustworthy.

SQL Development

Optimized SQL Server queries, stored procedures and performance tuning.

ETL Development

Reliable data pipelines and warehouse loads that keep dashboards fresh.

BI Training

Hands-on Qlik & Power BI training to upskill your in-house teams.

Freelance Consulting

Need a flexible, senior BI partner? Engage me on a project, retainer or fractional basis — fully remote and outcome-focused.

Testimonials

What clients say

Insights & Articles

From the blog

Tutorials and field notes on Qlik, Power BI, SQL and analytics. Add posts as you publish.

Qlik Sense Tutorials Power BI Tutorials SQL Tips Data Analytics Business Intelligence
Qlik Sense Tutorials
Set Analysis in Qlik Sense, explained simply

A practical guide to writing set expressions that make your charts respond exactly the way the business expects.

Read article
Power BI Tutorials
5 DAX patterns every Power BI developer should know

Time intelligence, running totals and dynamic measures — reusable patterns to speed up your next report.

Read article
SQL Tips
Window functions that will level up your SQL

From ROW_NUMBER to running aggregates — how to replace messy subqueries with clean, fast window functions.

Read article
Get In Touch

Let's build something with your data

Have a dashboard, analytics or BI consulting need? Send a message and I'll get back within one business day.

Please enter your name.
Please enter a valid email.
Please add a subject.
Please write a short message.