# Hardik Solanki

Hardik Solanki is a remote worker on Himalayas, Freelance at Brands In Ltd, based in India.

Source: https://himalayas.app/@hardiksolanki

```text
Business Data Analyst at BRANDS IN LTD who built Power BI finance dashboards and cut report-refresh times by 25%.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 378k+ INR |
| Job categories | Business Data Analyst, Data Analyst |
| Skills | Business Data Analysis, Financial Analysis, Executive Dashboards, Management Reporting, Financial Forecasting, Variance Analysis, Budget Vs. Actual Analysis, Scenario Modeling, Data Modeling, Data Quality Control, Requirements Gathering, KPI Tracking, Power BI, SQL, DAX |

## About

```text
At BRANDS IN LTD, I built executive Power BI dashboards tracking revenue, operating expenses, profit margins, and key performance indicators. I also streamlined reporting, cutting refresh times by 25% and saving more than 10 hours of manual effort per week.

In a freelance project for BRANDS IN LTD, I delivered executive Power BI dashboards and financial summaries. I automated data reconciliation and backend query modeling with SQL and DAX to expedite reporting.

At ANALYSTICS LEAP, I produced monthly executive reporting packs and Power BI dashboards for financial and commercial performance. I partnered with data engineering teams to troubleshoot data-quality issues and optimize SQL queries, boosting speed by 30%.

I also built a management reporting model for revenue, expenses, budget-versus-actual analysis, and rolling forecasts. For a UK banking analytics dashboard, I evaluated more than 5,000 transactions to identify operational trends, customer segments, and risk indicators.
```

## Experience

### Freelance

Brands In Ltd. Nov 2025 - May 2026

```text
Delivered executive Power BI reporting dashboards and financial summaries on an independent project basis. Automated data reconciliation and backend query modeling using SQL and DAX to expedite reporting turnaround.
```

Skills: Power-BI, SQL, DAX, Data-Modeling, Reporting, Financial-Analysis

### Business Data Analyst – Finance and Operations

Brands In Ltd. Mar 2025 - Oct 2025

```text
Built executive Power BI dashboards tracking revenue, operating expenses, profit margins, and key performance indicators. Streamlined reporting processes, cutting report-refresh times by 25% and saving more than 10 hours of manual effort per week.
```

Skills: Power-BI, SQL, Power-Query, DAX, Data-Reconciliation, Reporting, KPI-Tracking

### Data Analyst

Analytics Leap. Apr 2024 - Feb 2025

```text
Produced monthly executive reporting packs and Power BI dashboards covering financial and commercial performance metrics. Partnered with data engineering teams to troubleshoot data-quality issues and optimize SQL queries, boosting speed by 30%.
```

Skills: Power-BI, SQL, Data-Quality, Reporting, Management-Presentations

## Education

### University of Wales Trinity Saint David

MBA, Banking & Finance Management. 2023 - 2024

```text
MBA in Banking & Finance Management from the University of Wales Trinity Saint David, London, from February 2023 to February 2024.
```

### Team Lease Skill University

BSc, Hospitality and Tourism Management. 2018 - 2021

```text
BSc in Hospitality and Tourism Management from Team Lease Skill University, Gujarat, from June 2018 to June 2021.
```

### Analytics Leap

Power BI Course, Power BI

```text
Completed a Power BI course from Analytics Leap.
```

### Analytics Leap

SQL Course, SQL

```text
Completed a SQL course from Analytics Leap.
```

## Tech stack

- Python
- SQL
- Power BI
- Power Query

To contact Hardik, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Sudhirkumar Gulbile](https://himalayas.app/@sudhirkumargulbile): Data Visualization & Analytics Consultant, Accenture
- [Darshan Acharya](https://himalayas.app/@darshanacharya1): Business Analyst (Power BI), MNK GCS
- [M K Abhishek Basavesh](https://himalayas.app/@mkabhishekb): Freelance BI Consultant, Independent Consulting
- [Mithil Gundeti](https://himalayas.app/@mithilgundeti): Customer Data Quality Validation, Personal Project
- [Sumit Garg](https://himalayas.app/@sumitgarg): Data Analyst, Ummeed Housing Finance
- [Namburu Venkata Subrahmanya Deepk](https://himalayas.app/@namburuvenkatasubrah): Business Intelligence and Data Analyst, Self Employed
- [Abhi M](https://himalayas.app/@abhim1): Data Analyst Intern, Rows and Columns
- [Saami Anware](https://himalayas.app/@saamianware): Data Analyst Intern, Intrepedians
- [Yashika Pihal](https://himalayas.app/@yashikapihal): Senior Business Intelligence Analyst, EXL
- [MINHAJ KP](https://himalayas.app/@minhajkp): Manager IT & Analytics, Leapx Coating
