Pakiza Nisar

Data Analyst | Business Intelligence Enthusiast

Data Analyst specializing in end-to-end analytics solutions using Excel, Python, SQL, and Power BI. Passionate about transforming raw data into actionable business insights through structured analysis and interactive dashboards.

Laptop displaying Power BI dashboards

Featured Projects

End-to-end analytics projects demonstrating data cleaning, business analysis, SQL querying, and interactive Power BI dashboard development.

AI Job Market Analysis Dashboard - Salary Drivers AI Job Market Analysis Dashboard - Market Trends

AI Job Market Analysis

End-to-end analytics project exploring global AI job trends, salary drivers, technical skills, hiring demand, and compensation patterns using Python, MySQL, and Power BI.

✓ 10,000+ AI job records analyzed

✓ End-to-end analytics workflow

✓ 2-page interactive Power BI dashboard

✓ 10 business questions answered

Python MySQL Power BI
CRM Sales Analytics Dashboard - Executive Overview CRM Sales Analytics Dashboard - Sales Performance CRM Sales Analytics Dashboard - Customer and Product Analysis

CRM Sales Analytics

Business intelligence solution analyzing sales performance, customer value, product contribution, revenue trends, and business performance using Excel, Python, SQL Server, and Power BI.

✓ Excel → Python → SQL Server → Power BI workflow

✓ 30 SQL business queries

✓ 3-page executive dashboard

✓ 7 business recommendations

Excel Python SQL Server Power BI

About Me

Transforming raw data into meaningful business insights through structured analysis and interactive dashboards.

I am a self-taught Data Analyst specializing in Excel, Python, SQL, and Power BI. I enjoy transforming complex datasets into actionable insights through data cleaning, preprocessing, exploratory analysis, and interactive dashboard development.

My workflow begins with understanding the business problem, followed by data quality assessment, exploratory analysis, SQL-based business analysis, and visualization to support informed decision-making.

My portfolio demonstrates complete analytics workflows—from data profiling, feature engineering, SQL querying, data modeling, DAX calculations, and Power BI dashboard development—with every project focused on solving real business problems.

I am continuously improving my analytical and technical skills by building practical projects and am currently seeking opportunities where I can contribute analytical thinking, technical expertise, and a passion for data-driven decision-making.

Technical Skills

Technologies and tools I use to build end-to-end analytics solutions.

Excel

Data Profiling • Power Query • Pivot Tables • Data Cleaning

Python

Pandas • NumPy • Data Cleaning • Feature Engineering • EDA

SQL

MySQL • SQL Server • CTEs • Window Functions • Joins

Power BI

DAX • Power Query • Data Modeling • Dashboard Design

Version Control

Git • GitHub

Core Skills

Data Analysis • Business Intelligence • Data Visualization • Problem Solving

Get In Touch

I'm currently seeking Data Analyst opportunities. Feel free to connect regarding full-time roles, internships, collaborations, or analytics projects.