Powered by
Codebasics DA Bootcamp

Syed Faisal Hussain

Data Aspirant

+91 9631701517 [email protected]

Resume

Hello, I am

Syed Faisal Hussain.

1

Excel Project

2

PowerBI Projects

About Me

Hi,
Welcome to my portfolio website. I am a data enthusiast, although I have graduated from mechanical engineering, I developed interest in data analytics during my previous job and decided to finally move data analytics.
I am good with tools like Power BI, excel and SQL which helps me derive insights from raw data. From data cleaning and converting complex data into understanding dashboards and derive narratives that drive business success and I love to do it.
As I don't have any official work experience in data analytics yet , but I have completed projects that revolve around real life data sets that truly showcase my data analysis prowess. You will find these projects highlighted in my portfolio below.

My Projects

My Experience

Analyzer CAE solutions

Perform CFD analysis for different client projects.
Prepare geometry for meshing and then apply real life physics on it in Ansys simulation software.
Perform meshing for engines and piping network.

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

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.

[email protected]

https://www.linkedin.com/in/syed-faisal-hussain-5a691b1a4/

+ 91 9631701517

Excel Project

Customer Analysis of AtliQ

Domain/Function: Financial and Sales

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 Analysis of AtliQ

It compares top countries by sales increase in year 2020 and 2021.

Customer Analysis of AtliQ

This reports lets you know know sales performance of different customers in different region around globe.

Project Details

In this project, I created a sales report using excel pivot tables which will help to determine effective customer discounts, facilitate negotiations with consumers, and identify business expansion opportunities in different countries.

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

PowerBI Project

Business Insight 360

Domain/Function: Finance and Sales

This project contains complete business analysis of Atliq. It includes sales , marketing and financial analysis. This project has covered vast theoretical business concepts like Gross values, COGS etc

Business Insight 360

Financial report of different markets

Business Insight 360

Marketing expenses for different customers and market.

Project Details

In this project, I created dashboard for financial, sales growth and marketing expenses which helps in determining which market and region is performing better and which ones are lagging behind.
I have learned the following:

1. Power Query
2. Data Cleaning and star schema
3. DAX (Basics)
4. Creating Measures
5. Creating Dashboards
6. Generic business terms

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

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

Domain/Function: Hotels

I was working on data collected from different locations about hotel bookings and need to Analyze that data over 3 months for different hotels spread across cities to understand consumer behavior.

View Project
on GitHUB

Hospitality Analysis

Dashboard created to understand consumer behavior

Hospitality Analysis

Star schema to connect dim and fact tables

Project Details

- 3 month data of bookings from different sources (online, offline) and revenue realized at different locations
- Analyzed gap in revenue generated and revenue realized for different hotels and for different cities and find which city or hotel has highest gap.
- Analyze which month of year generated highest revenue.

Live Interactive Dashboard