Hello,

I'm Zohaib Hassan

Welcome to my PortfolioWebsite

zohaib.atd92@gmail.com

About Me

Dedicated Business Intelligence Consultant and Accounts Specialist.

Hello,

I am Zohaib Hassan, a dynamic finance professional and seasoned Data Analyst and Business Intelligence Consultant with over 6 years of comprehensive experience in Accounts, Finance, and Data Analytics. My journey has spanned diverse industries both in the public and private sectors, working both on-site and remotely as a freelancer.

Throughout my career, I have been passionate about transforming raw data into actionable insights that help businesses sell, earn, save, and grow. I believe that data is the most valuable commodity for any enterprise, and I continuously upskill to deliver findings faster and more effectively.

A Dedicated Business Intelligence Consultant and Accounts Specialist, I am equally adept at working with accounts to ensure financial accuracy and efficiency. I look forward to connecting with like-minded professionals who share a passion for data and its power to drive business success. If you’re interested in leveraging my skills to meet your data needs, feel free to
HIRE ME.

Services

Data Cleaning

Unlock the full potential of your data with my professional data cleaning and transformation services. As a skilled data analyst, I specialize in removing duplicates, correcting errors, and ensuring consistency for accurate analysis. Additionally, I excel in converting raw data into structured formats, enabling seamless integration and insightful reporting. My expertise ensures that your data is reliable, actionable, and ready to drive business success.

Data Modeling

Being a proficient data analyst, I am specialized in creating robust data models that facilitate accurate and insightful analysis. My expertise encompasses conceptual, logical, and physical data modeling, ensuring that your data architecture is optimized for performance and scalability. By structuring your data effectively, I enable seamless integration, enhance data quality, and drive informed decision-making. Partner with me to transform your raw data into a strategic asset that powers business growth and innovation.

Data Visualization

As a skilled data analyst, I am specialized in transforming complex data sets into intuitive, visually compelling dashboards that provide actionable insights at a glance. Whether you need real-time monitoring, trend analysis, or performance tracking, my customized visualizations ensure that your data tells a clear and impactful story. By leveraging the latest tools and techniques, I create dashboards that are not only aesthetically pleasing but also highly functional, enabling you to make informed decisions with confidence. My expertise ensures that your data is not just seen but understood, driving business success and innovation.

My skills

Explore my diverse skill set to unlock the full potential of your data and drive your business forward

QuickBooks and Tally

Excel

Data Visualization- Power Bi

Data Analytics

Word, PowerPoint & Access

WordPress Web Development and Woo-Commerce

Aronium (POS)

SQL

AI-Prompt Engineering

My Projects

Please choose any of the following to see the relevant projects that I have completed.

My Excel Projects

Explore my extensive portfolio of Excel projects that demonstrate my expertise in data analysis, financial modeling, and business intelligence.

Discover how I transform complex data sets into actionable insights using advanced Excel techniques to drive business success. Click on the above picture to see all projects.

My Power Bi Projects

Explore my Power BI projects to see how I create interactive dashboards and dynamic visualizations that provide real-time business insights. Click on the above picture to see all projects.

Discover how I leverage Power BI to transform data into compelling stories, driving informed decision-making and business success. Click on the above picture to see all projects.

SQL Projects

Explore my SQL projects to see how I design and manage databases to efficiently store, retrieve, and analyze data. Click on the above picture to see all projects.

Discover how I leverage SQL to perform complex queries and data manipulation, providing robust solutions for data-driven decision-making. Click on the above picture to see all projects.

My Excel Projects

Welcome to my portfolio of Excel data analysis projects! Here, you’ll find examples of how I use data-driven solutions to solve real-world problems. Each project showcases my skills in data manipulation, visualization, and interpretation, demonstrating the power of Excel in uncovering valuable insights. Take a look below to see how I transform raw data into actionable intelligence

MICROSOFT EXCEL

BANK LOAN DASHBOARD

The bank is experiencing a significant discrepancy between the issuance of good loans and bad loans, as evidenced by the loan application statistics, funded amounts, and received amounts. Despite a high number of total loan applications and a substantial amount of funded loans, a notable portion of the loans are classified as bad loans. This discrepancy poses a risk to the bank's financial health and indicates a potential issue in the loan approval and risk assessment processes. Additionally, there is a need to analyze the distribution of loans by purpose and grade to identify any patterns that may be contributing to the high percentage of bad loans.

MICROSOFT EXCEL

COFFEE SHOP SALES DASHBOARD

The coffee shop chain needs to enhance its decision-making process by obtaining detailed insights into sales performance, customer footfall, product popularity, and sales distribution across various timeframes and locations. The current data is extensive but not effectively leveraged, leading to missed opportunities in optimizing sales strategies, inventory management, and customer satisfaction. The goal of this project is to create a comprehensive and interactive dashboard that visualizes key metrics, trends, and patterns to support data-driven decisions and improve overall business performance.

MICROSOFT EXCEL

BOOKING CANCELLATION PROJECT

Hotel booking cancellations pose significant challenges for the hospitality industry, leading to potential revenue loss and inventory management issues. Understanding the underlying reasons and patterns behind these cancellations can help hotel management implement strategies to reduce cancellation rates and optimize operations. The objective of this project is to analyze hotel booking data to identify patterns and trends in reservations and cancellations over a different periods. By utilizing various pivot tables and measures, the project aims to provide insights into customer behavior, seasonal trends, and the impact of different factors on booking cancellations.

MICROSOFT EXCEL

PIZZA SALES REPORT

The pizza sales dashboard is created to address the need for a comprehensive and visual representation of the pizza sales data. The aim is to provide a detailed and easily understandable overview of sales performance, helping to identify key trends, best and worst-selling items, and peak sales periods.

My Power Bi Projects

Welcome to a curated selection of my Power Bi projects, each one reflecting my journey of growth, learning, and achievement. These projects represent my ability to blend creativity with technical skills, resulting in solutions that are not only effective but also forward-thinking. Explore and get inspired by the stories behind each endeavor.

MICROSOFT POWER BI

Logistics Security Dashboard

Dubai South Headquarters faced challenges in efficiently monitoring and managing security incidents across its extensive logistics operations. The key issues included: Inconsistent reporting of incidents. Difficulty in identifying high-risk areas and recurring problems. Lack of actionable insights to enhance security measures. Inefficient incident resolution tracking. To address these issues, we developed a comprehensive Logistics Security Dashboard using Power BI. This dashboard aims to centralize incident data, provide clear visual insights, and facilitate data-driven decision-making to improve security operations.

MICROSOFT POWER BI

Car Sales Data Analysis Dashboard

The primary problem addressed by this Power BI dashboard is the need for a comprehensive and interactive tool to analyze and visualize car sales data across the United States. Stakeholders, such as car manufacturers, dealerships, and business analysts, require detailed insights into sales performance by various dimensions such as car manufacturers, models, and released years. This dashboard aims to provide a user-friendly interface to facilitate data-driven decision-making and strategic planning in the automotive industry.

MICROSOFT POWER BI

Global Sales Performance Dashboard

The primary objective of this project is to create a comprehensive sales analysis dashboard for a global retail company. The dashboard aims to provide insights into sales performance, identify key trends, and facilitate data-driven decision-making by visualizing sales data across different dimensions such as products, regions, and demographics. The dashboard is intended for use by management, sales teams, and other stakeholders who need to monitor and analyze sales metrics to optimize business strategies and improve profitability.

MICROSOFT POWER BI

Revenue And Customer Behavior Analysis Through Credit Card Transactions Dashboard

The primary objective of this Power BI project is to analyze and visualize credit card transaction data to gain insights into customer behavior, revenue trends, and overall financial performance. The dashboard aims to provide a comprehensive view of credit card transactions, helping stakeholders make informed decisions to optimize marketing strategies, enhance customer engagement, and improve revenue generation.

MICROSOFT POWER BI

Vendors Payment Analysis Dashboard

Ismmart Group of Industries faced significant challenges in managing and analyzing vendor payments across multiple regions and departments. The primary issues included: Difficulty in tracking total payments and pending amounts. Lack of visibility into payment distribution across different regions and departments. Inefficiencies in identifying high-value payments and pending invoices. Need for real-time insights to make informed financial decisions.

MICROSOFT POWER BI

Narcotics Data Analysis Dashboard

The Narcotics Department faces challenges in effectively monitoring and analyzing drug-related offences across various districts. There is a need for a comprehensive data analysis tool to help identify trends, patterns, and hotspots in narcotics activity. The current manual reporting and analysis processes are time-consuming and prone to errors, hindering the department's ability to respond swiftly and efficiently.

SQL Projects

Welcome to my SQL Projects Portfolio! Here, you will find a collection of projects that demonstrate my proficiency in SQL and data analysis. Each project is designed to address real-world challenges by leveraging SQL’s powerful data manipulation and querying capabilities. Explore the projects below to see how SQL can transform raw data into actionable insights

SQL PROJECT

Rental Trends in Dubai: A Data Analysis Approach

With the rapid growth of Dubai's real estate market, there is a significant need for a comprehensive analysis of property listings to understand rental trends, property distribution, and key factors influencing the market. This project aims to provide detailed insights into various aspects of the Dubai property market, helping stakeholders make informed decisions.

SQL PROJECT

Analysis of Employee Attrition and Satisfaction

Here is the text extracted from the image: Employee attrition is a significant challenge for many organizations, impacting productivity, morale, and financial performance. Understanding the factors contributing to attrition and identifying patterns within HR data can help organizations take proactive measures to improve employee retention. However, many companies struggle with analyzing large volumes of HR data efficiently and deriving actionable insights. This project aims to address this issue by leveraging SQL to perform comprehensive analyses of HR data, focusing on employee attrition, demographics, and job satisfaction.

Hello,

I'm Zohaib Hassan

Welcome to my PortfolioWebsite

zohaib.atd92@gmail.com

About Me

Services

Data Cleaning

Data Modeling

Data Visualization

My skills

My Projects

My Excel Projects

My Power Bi Projects

SQL Projects

My Excel Projects

My Power Bi Projects

SQL Projects

Contact

Quick Links

Social