Portfolio - Taiyaba Khatoon

Taiyaba Khatoon

Data Aspirant

Resume

2

Excel Projects

2

PowerBI Projects

1

SQL Project

About Me

I’m a detail-oriented and curious problem solver with a strong background in Finance and a growing passion for data and business analysis. I hold a Bachelor’s degree in Business Administration (Finance) and a Postgraduate Certificate in Global Business Management – Financial Planning from Humber College, Canada.
During my internships at AtliQ Technologies and Pragra Inc., I worked with real business data, built dashboards, and helped teams make better decisions through clear and meaningful insights.
I’m skilled in SQL, Excel, and Power BI, and have used these tools to clean data, build reports, and analyze trends in areas like sales, HR, finance, and more. I’m also certified in ECBA (IIBA) and Microsoft Power BI.
I’m now looking for a full-time opportunity as a Business or Data Analyst where I can keep learning, grow my skills, and make a real difference. I’d be happy to connect if you’re looking for someone reliable and insight-driven!

Key Skills

Excel

SQL

Power BI

ETL & Data Modelling

Data Cleaning & Transformation

Data Visualization

Analytical Thinking & Problem Solving

Communication & Stakeholder Reporting

My Projects

Sales Analytics(FMCG)

Domain/Function: Sales Data Analysis & Reporting

P & L Reports of AtliQ Hardware Data

Domain/Function: Profit & Loss (P&L) Reporting

360 Business Intelligence Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: BusinessInsights360.com

SQL EDA: Layoffs Analysis

Domain/Function: Workforce Planning

HR Presence & Work Mode Insights

Domain/Function: Human Resources / Workforce Analytics

My Experience

Data Analyst Intern

AtliQ Technologies | Remote | May 2025 – Present
Worked with data to create dashboards, clean datasets, and generate useful reports using Power BI and SQL. Supported the team by providing insights for different departments like sales and finance.

Business Analyst Intern

Pragra Inc. | Mississauga | May 2024 – Aug 2024
Assisted in gathering data, creating reports, and identifying simple trends to support business decisions. Helped the team with documentation and analysis of project requirements.

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/taiyaba-khatoon-/

Call Me

+1 4379735361

GitHub

https://github.com/taiyk53

Excel Project

Sales Analytics(FMCG)

Domain/Function: Sales Data Analysis & Reporting

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Excel Project

P & L Reports of AtliQ Hardware Data

Domain/Function: Profit & Loss (P&L) Reporting

Created a detailed Profit & Loss report for AtliQ Hardware (FY 2019–2021) using Excel’s advanced tools like Pivot Tables, Slicers, and Conditional Formatting. The report delivers clear, data-driven insights into revenue trends, cost behavior, and profit margins, enabling informed financial analysis

View Project
on GitHUB

Shows total sales, costs, and profits for each year (2019–2021) and the percent change from 2020 to 2021.

Shows sales, costs, and profits for each month and quarter, helping to see trends and changes across the year.

Project Details

This Excel project is a Profit & Loss (P&L) report created for AtliQ Hardwares. It shows the company’s financial performance over three years: 2019, 2020, and 2021. The report was made using Pivot Tables, Slicers, and Conditional Formatting to make the data clear and interactive.
The main financial numbers shown are:
Net Sales (Total sales made)
COGS (Cost of Goods Sold)
Gross Margin (Profit before other expenses)
GM% (Gross Margin as a percentage)
You can also filter the data by region, market, division, or customer to see specific results. The report shows both yearly totals and monthly breakdowns, so users can track performance over time.
In the yearly comparison, Net Sales increased by 204.5% from 2020 to 2021, and COGS increased by 208.6%. The Gross Margin% dropped slightly, which could mean higher costs affected profits.
This report is useful for managers and analysts to quickly understand how the business is doing and to make better decisions.

PowerBI Project

360 Business Intelligence Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: BusinessInsights360.com

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following
1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project
1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

SQL Project

SQL EDA: Layoffs Analysis

Domain/Function: Workforce Planning

This project performs Exploratory Data Analysis (EDA) using SQL on a global layoffs dataset to uncover key trends across industries, companies, countries, and funding stages. Using advanced SQL techniques like window functions and time-based aggregation, it reveals when and where layoffs were most.

View Project
on GitHUB

Monthly Layoffs with Rolling Total This line chart shows monthly layoffs with a cumulative (rolling) total over time. It reveals peak layoff periods.

Top 5 Companies by Layoffs Per Year A ranked table displaying the top 5 companies with the highest layoffs for each year.

Project Details

This project focuses on performing an Exploratory Data Analysis (EDA) using SQL on a global layoffs dataset. The goal was to uncover key patterns and insights related to workforce reductions across various industries, companies, and time periods. By using advanced SQL techniques such as Common Table Expressions (CTEs), window functions, and time series queries, I analyzed which companies and sectors experienced the most layoffs, identified peak periods of job losses, and ranked the top impacted companies per year.
The insights derived from this analysis can help businesses, policymakers, and job seekers better understand economic shifts and prepare for workforce planning. This project demonstrates my ability to work with real-world datasets, clean and manipulate data efficiently, and extract meaningful business insights using SQL.

PowerBI Project

HR Presence & Work Mode Insights

Domain/Function: Human Resources / Workforce Analytics

Designed a Power BI dashboard to uncover trends in employee presence, work-from-home (WFH), and sick leave patterns at ATLAS Hardware Company. Used DAX and Power Query to analyze attendance data, delivering actionable insights to optimize workforce scheduling and improve engagement.

View Project
on GitHUB

This dashboard shows key metrics like Presence %, WFH %, and Sick Leave trends over time. Helped visualize overall employee attendance patterns month

Cleaned and transformed raw attendance data using Power Query. Steps included removing extra rows, renaming columns, unpivoting data, and fixing error

Project Details

Developed a dynamic Power BI dashboard for ATLAS Hardware to analyze employee attendance, work-from-home (WFH) trends, and sick leave patterns. Utilized Power Query for data cleaning and transformation, and applied DAX to calculate key performance indicators (KPIs) such as Presence %, WFH %, and SL %. The dashboard provides monthly trends, departmental breakdowns, and employee-level insights, helping the HR team make informed decisions to improve workforce planning and engagement.