
Vinit Gahlot
Power BI, Excel, SQL, Data Cleaning and Interactive Dashboards
Skills

Bekijk mijn diensten


Portfolio
Werkervaring
Data Analyst
NTT DATA • Fulltime
Sep 2021 - Present • 4 yrs 8 mos
Working as a Data Analyst at Softogrid Solution Pvt. Ltd., where I was responsible for analyzing, cleaning, and transforming large datasets to deliver actionable business insights. I used Excel, Power BI, SQL, and Python to support data-driven decision-making across multiple projects. My role involved developing interactive Power BI dashboards with KPIs, trends, and drill-down analysis using DAX and Power Query. I designed data models, optimized reports for performance, and published dashboards to Power BI Service for stakeholders. I regularly used SQL (MySQL / SQL Server) to write complex queries involving joins, subqueries, and aggregations to extract and prepare data from relational databases. In addition, I leveraged Python (Pandas, NumPy, Matplotlib) for data cleaning, analysis, automation, and generating statistical insights. Using Excel, I performed data validation, pivot table analysis, advanced formulas, and ad-hoc reporting to support business teams. I worked closely with clients and internal teams to understand requirements, define KPIs, and convert business problems into clear analytical solutions. This role strengthened my expertise in data visualization, ETL processes, reporting automation, and business analytics, while consistently delivering high-quality insights to improve operational efficiency and decision-making.