- Dual-domain dashboard covering 1,470+ employee records (HR) and 3 years of sales (2017 to 2019) across 7 products, 3 channels and several geographies.
- Power Query transformations (merged queries, conditional columns, split columns) and DAX measures using CALCULATE, COUNTROWS, SWITCH and LOOKUPVALUE.
- Navigation tabs, dynamic slicers, custom tooltips and drill-through for easy exploration.
Open to BI and Data Analyst roles
Yashwant Gupta
Data Analyst & BI professional in Delhi
I build Power BI and Excel dashboards that give senior management a clear view of performance. My core tools are Power BI, SQL Server, Power Query, Excel and Google Sheets.
Sample data for illustration. Real dashboards are in Projects below.
Turning raw data into decisions
5+KPI dashboards used daily
40%Less time on report generation
3Departments that used my dashboards
I'm a confident data analyst with a problem-solving mindset and hands-on skill across the Microsoft and Google data stack. I enjoy finding trends and inefficiencies in business data and presenting them so leaders can act.
Experience
-
Executive, Business Intelligence Unit
- Built 5+ KPI dashboards used by 3 departments daily, enabling real-time performance tracking across business units.
- Reduced report generation time by 40% through Excel automation, removing manual effort across daily, monthly and yearly reporting cycles.
- Tracked and analysed department-wise performance metrics to find trends, inefficiencies and growth opportunities, and shared insights with business heads regularly.
- Prepared and delivered daily, monthly and yearly MIS reports with actionable insights to the CEO and Business Heads for strategic planning and performance reviews.
- Designed and maintained complex incentive calculation files in Excel, managing multi-tier commission structures and automated payout summaries for the sales team.
- Supported senior management in policy generation with data-backed analysis and structured documentation for internal process development.
-
Data Analyst Intern
- Supported data collection, cleaning and analysis for business reporting.
- Built interactive Power BI dashboards and automated reporting workflows in Excel, SQL and Google Sheets.
- Improved data quality and reporting efficiency through structured analysis and documentation.
- Gave the IT team insights for operational tracking.
Skills
Excel
- SUMPRODUCT
- Pivot tables
- Pivot charts
- Lookup functions
- Conditional formatting
- Dashboards
- Data validation
Power BI
- Data modeling
- DAX
- Power Query
- Slicers
- Bookmarks
- Drill-through
- Reports
- Dashboards
SQL Server
- SELECT
- JOIN
- GROUP BY
- HAVING
- Subqueries
- Constraints
- Stored procedures
- Window functions
Google Sheets
- Apps Script
- QUERY
- ARRAYFORMULA
- IMPORTRANGE
- Automation
- Data cleaning
- Reporting
- Dashboard support
Projects
- Two-page report on revenue by model, region, month and customer segment, built to support forecasting and profitability decisions.
- Advanced DAX (CALCULATE, VAR, FORMAT, WEEKDAY, ISBLANK) and custom sparklines for model-level trends.
- Surfaced top-performing models, underperforming regions and month-over-month seasonal patterns.
- Two-page HR payroll dashboard tracking basic salary, allowances, deductions and net pay by department, employment type and payment mode.
- DAX (VAR, MAXX, SWITCH, time intelligence) with conditional formatting, data bars and dynamic parameters for filtering by employee and month.
- Identified monthly payroll trends, top earners and the departments with the highest payroll cost.
Excel formulas I've written
Day TAT
Used in the CET daily report. Counts the days from pickup (S) to handover (T), skips any dates in the Holiday list sheet, and never returns less than 0.
=IF(IFERROR(TEXT(T3,"DD-MMM-YY")-TEXT(S3,"DD-MMM-YY")-COUNTIFS('Holiday list'!A:A,">="&S3,'Holiday list'!A:A,"<="&T3),0)<=0,0,IFERROR(TEXT(T3,"DD-MMM-YY")-TEXT(S3,"DD-MMM-YY")-COUNTIFS('Holiday list'!A:A,">="&S3,'Holiday list'!A:A,"<="&T3),0))Time TAT
Used in the same report. Calculates the working hours from pickup to handover. A work day runs 10:00 AM to 7:00 PM, or to 4:30 PM on Saturdays. It returns 0:00 when a time is missing or the result is negative.
=IF(OR(S3="",T3=""),TIME(0,0,0),IF(IF(TEXT(S3,"DDDD")="Saturday",IF(U3<=0,TEXT(T3,"HH:MM:SS")-TEXT(S3,"HH:MM:SS"),(TIME(16,30,0)-TEXT(S3,"HH:MM:SS"))+(TEXT(T3,"HH:MM:SS")-TIME(10,0,0))),IF(U3<=0,TEXT(T3,"HH:MM:SS")-TEXT(S3,"HH:MM:SS"),(TIME(19,0,0)-TEXT(S3,"HH:MM:SS"))+(TEXT(T3,"HH:MM:SS")-TIME(10,0,0))))<=0,TIME(0,0,0),IF(TEXT(S3,"DDDD")="Saturday",IF(U3<=0,TEXT(T3,"HH:MM:SS")-TEXT(S3,"HH:MM:SS"),(TIME(16,30,0)-TEXT(S3,"HH:MM:SS"))+(TEXT(T3,"HH:MM:SS")-TIME(10,0,0))),IF(U3<=0,TEXT(T3,"HH:MM:SS")-TEXT(S3,"HH:MM:SS"),(TIME(19,0,0)-TEXT(S3,"HH:MM:SS"))+(TEXT(T3,"HH:MM:SS")-TIME(10,0,0))))))Conveyance report lookup
Used in the conveyance report that goes to the CEO every month. For PayMT rows, it looks up the earlier row with the same reference (P) and the opposite amount (C), then returns that row's value from column H. Other rows stay blank.
=IF(G2="PayMT",
IFERROR(
INDEX(H$1:H1,
MATCH(1,
(P$1:P1=P2)*(C$1:C1=-C2),
0)
),
""),
"")Education and courses
Data Analytics Course
Bachelor of Arts
Class 12 (CBSE)
Class 10 (CBSE)
Let's talk
I'm based in South Delhi and actively looking for BI and data analyst roles. If you need dashboards, automated reporting or a data analyst on your team, send me a message.