Fiza Loladiya

Data Analyst

[email protected]

Hello, I am

Fiza Loladiya.

2

Excel
Projects

2

PowerBI
Projects

About Me

I’m Fiza — the kind of data analyst who doesn’t start with charts. I start with a question: what decision needs to be made, and what information would actually change it? That mindset drives everything I build.

I use Excel, SQL, and Power BI to turn raw, messy data into clear insights teams can act on. In Excel, I clean and structure data, build reliable reporting workflows, and analyze trends using smart formulas and PivotTables. In SQL, I extract and shape data with joins, CTEs, and window functions to answer real business questions. In Power BI, I create interactive dashboards with strong modeling, DAX measures, and visuals that communicate the story fast—without noise.

What sets me apart is the mix of analysis, communication, and design thinking. I care about the details because details change decisions: KPI definitions, layout, drill paths, and the way a dashboard guides attention. My goal is simple: make insights obvious, reliable, and decision-ready.

Key Skills

Excel

Power BI

SQL

Data Cleaning

Data Visualization

Dashboard Building

Power Query

DAX (Power BI)

Data Modeling

Data Analysis

Statistics

My Projects

Call Center Performance Dashboard (Excel)

Domain/Function: Call Center Analytics / Customer Support Operations

Sales & Finance Reporting Dashboard (Excel) – AtliQ Hardware

Domain/Function: Business Reporting / Sales & Finance Analytics

Employee Attrition Insights: HR Analytics Dashboard

Domain/Function: Human Resources Analytics

Electric Vehicle Market Analysis Dashboard

Domain/Function: Automotive Industry Analytics

My Experience

Excel Course Content & Project Intern (Remote) | Coding Liquids | Nov 2025 – Dec 2025

Researched and shortlisted topics for an Excel course to create a clear, structured learning path.
Edited and refined the course curriculum to improve flow, clarity, and progression for learners.
Planned lectures and aligned them with practical learning outcomes and project-based practice.
Built project resources including Start/Complete Excel workbooks, datasets, and README documentation.
Organized course materials systematically to ensure learners could follow along and apply concepts easily.

Tools/Skills: Excel, Curriculum Design, Content Research, Documentation (README), Dataset Preparation, Attention to Detail

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/fiza-loladiya

GitHub

https://github.com/fiza-loladiya

Excel Project

Call Center Performance Dashboard (Excel)

Domain/Function: Call Center Analytics / Customer Support Operations

Designed an interactive Excel dashboard to track call center KPIs, agent performance, abandoned calls, and customer behavior. Includes monthly trends, reason-wise failure analysis, and agent-level drilldowns using slicers.

View Project
Engagement

Main dashboard overview showing overall call center KPIs (total, successful, failed, abandoned), agent-wise call volume, call outcome rate, abandoned call reasons, product discussion (success vs failure), monthly trend, and state-wise call distribution.

Interactive drilldown view with Morning time filter and a different agent selected (MichaelPage). Shows how KPIs, call outcomes, abandoned call reasons, trends, and state-wise distribution update dynamically.

Project Details

Built a detailed, decision-ready Call Center Dashboard in Excel to summarize overall call performance, agent activities, and customer behavior. The dashboard highlights key KPIs (total calls, answered vs abandoned, success rate, avg handling time), compares agent-wise performance, and enables quick drilldowns with slicers/filters to view an individual agent’s outcomes, abandoned calls, products discussed, and customer locations. I also added monthly trend views to spot seasonality and a reason-wise breakdown to identify why calls were unsuccessful. Designed with a clean layout, consistent formatting, and interactive visuals so managers can review performance in seconds and take action fast.

Excel Project

Sales & Finance Reporting Dashboard (Excel) – AtliQ Hardware

Domain/Function: Business Reporting / Sales & Finance Analytics

Created Excel-based business reports to track Market Performance vs Target, P&L by Market, quarterly GM% trends, and customer net sales performance. Designed for quick comparison across years, markets, and regions using clean tables and KPI-focused views.

View Project
Engagement

Market Performance vs Target report comparing 2019–2021 performance with target variance and % gap by country to quickly identify underperforming markets.

Customer-wise Net Sales Performance report for the India market showing 2019–2021 sales and 2021 vs 2020 growth %. Helps identify top customers, fast-growing accounts, and overall YoY performance trends.

Project Details

Built a set of Excel business reports for AtliQ Hardware to support sales and finance decision-making. The reports include Market Performance vs Target (year-wise comparison and target variance), a FY2021 P&L summary by market (Net Sales, COGS, Gross Margin and GM%), GM% trends by quarter across sub-zones for FY2019–FY2021, and customer-wise net sales performance for the India market. The reporting layout is designed to be management-friendly: easy to scan, consistent formatting, and focused on KPIs and variance analysis so performance gaps are visible quickly.

PowerBI Project

Employee Attrition Insights: HR Analytics Dashboard

Domain/Function: Human Resources Analytics

Built an interactive HR Analytics Dashboard in Power BI to analyze employee attrition trends, department-wise performance, age and gender distribution, and job satisfaction insights for better workforce decision-making.

View Project
Engagement

View Project
on GitHUB

Power BI HR Dashboard highlighting employee attrition trends, department analysis, age groups, gender distribution, education insights, and job satisfaction metrics.

Detailed analysis of department-wise attrition, age group distribution, education field trends, and gender-based attrition rates, providing deeper insights into workforce demographics and employee turnover patterns.

Project Details

This HR Analytics Dashboard was built using Power BI to analyze employee attrition patterns and workforce insights. The dashboard highlights key KPIs such as Total Employees, Attrition Count, Attrition Rate, Active Employees, and Average Age.

It provides department-wise attrition analysis, age group and gender distribution, education field insights, and job satisfaction ratings across different roles. Interactive visuals and slicers allow dynamic filtering for deeper analysis.

During this project, I worked on data cleaning, creating calculated columns and measures, designing meaningful KPIs, and selecting appropriate visuals for clear storytelling. The focus was to convert raw HR data into structured, decision-focused insights that can help HR teams reduce attrition and improve employee satisfaction.

Live Interactive Dashboard

PowerBI Project

Electric Vehicle Market Analysis Dashboard

Domain/Function: Automotive Industry Analytics

Interactive Power BI dashboard analyzing electric vehicle adoption trends, manufacturer dominance, state-wise distribution, CAFV eligibility, and growth patterns from 2010 onwards to support market and policy decision-making.

View Project
Engagement

View Project
on GitHUB

Overview of EV market KPIs including total vehicles, BEV vs PHEV distribution, growth trends from 2010, and state-wise adoption analysis.

In-depth analysis of EV adoption growth, regional penetration, brand leadership, and CAFV eligibility impact, highlighting market dominance and consumer preference trends.

Project Details

The Electric Vehicle (EV) industry is rapidly evolving due to environmental awareness, government incentives, and technological advancements. This project analyzes electric vehicle data to understand market growth, regional adoption patterns, and manufacturer dominance.

The dashboard provides key insights such as total vehicles, average electric range, BEV vs PHEV market share, state-wise distribution, and top manufacturers and models. A time-series analysis from 2010 onwards highlights the acceleration in EV adoption, especially after policy support and technological improvements.

CAFV eligibility analysis helps evaluate the role of clean fuel incentives in influencing adoption trends. Interactive filters allow users to explore EV performance by state, vehicle type, and manufacturer.

This project demonstrates my ability to transform raw automotive data into structured KPIs and visually engaging dashboards that support strategic decision-making.