Headline

Business Intelligence & Data Analyst | Python, SQL, BigQuery, Power BI, Looker Studio | Automated Pipelines & BI Dashboards

About

I’m a Computer Science Engineering student focused on Business Intelligence and Data Analytics, with hands-on experience building real-world, KPI-driven analytics solutions. I specialize in transforming raw data into actionable business insights using Power BI, SQL, Excel, and Python. Recently, I built a real-time sales monitoring dashboard that simulates live transactions and tracks revenue trends, customer segmentation, regional performance, and conversion metrics. The project involved data cleaning, data modelling, DAX calculations, KPI design, and interactive dashboard development to support operational decision-making. My core strengths include data analysis, business requirement understanding, performance tracking, exploratory data analysis (EDA), data visualization, dashboard design, SQL querying, ETL processes, Power Query, data transformation, statistical analysis, and report automation. I’m comfortable working with structured datasets, designing star schemas, creating calculated measures, and building insights that align with business objectives. Beyond tools, I focus on the “why” behind the numbers identifying inefficiencies, measuring business performance, and supporting data-driven strategy. I’m actively seeking opportunities in Business Analytics, BI Development, and Data Analysis where I can contribute to building scalable reporting systems, operational dashboards, and insight-driven decision frameworks.

Location

Surat

Work experience

Data Analyst at Sabudh Foundation, Jan 2025 - Jun 2025 · 6 mos, • Developed Excel-based operational reports for recurring weekly and monthly datasets used by cross-functional teams. • Monitored 8+ key performance indicators to evaluate operational trends and reporting accuracy. • Reviewed datasets to identify recurring inconsistencies, supporting data quality and reporting reliability. • Communicated analytical findings to stakeholders through structured summaries and visual reports.

Education

Bachelor of Technology - BTech, Computer Science, Vellore Institute of Technology (VIT)

RMG Maheshwari English School - India

Public links

github: https://github.com/V-Solanki03