Zain ul Abidien | Data Analyst

Zain ul Abidien Logo
Zain ul Abidien Logo

name = "Zain"
occupation = "Data Analyst"
likes = ["football", "biryani"]

print("Name:", name)
print("Occupation:", occupation) print("Likes:", likes)

My Work

Relationship Between Parents and Students' Scores in Python
HR Report in Power BI for a Tech Company
  • Cleaned and preprocessed raw student data using Python.

  • Handled missing values and inconsistencies.

  • Utilized libraries like pandas for data manipulation and analysis.

  • Leveraged Matplotlib and Seaborn for data visualization.

  • Investigated the potential association between: Parent's marital status and student academic performance & Parent's educational background and student scores.

  • Created informative visualizations (e.g., charts, graphs) to represent: Distribution of student scores.

  • Relationships between variables identified.

  • Cleaned and transformed raw HR data in Excel, ensuring accuracy and consistency.

  • Utilized Power Query Editor within Power BI for advanced data cleansing and shaping.

  • Created custom DAX measures in Power BI to simplify calculations and enhance data analysis.

  • These measures may have included: Headcount by employee location (Work from Home, Office), Leave type breakdowns (Sick leave, Vacation, etc.)

  • Developed an interactive dashboard showcasing key HR metrics for the tech company.

  • The dashboard likely includes: Charts and graphs to depict distribution of employees across work locations (Work from Home vs. Office), Trends in leave usage by type.

  • Slicers and filters allowing users to explore the data by department, team, or other relevant criteria.

Sales Report for Bikes Sold in Excel
HR Dashboard showing employees' presence
HR Dashboard showing employees' presence
Second HR Dashboard showing employees' presence
Second HR Dashboard showing employees' presence
Another HR Dashboard showing employees' presence
Another HR Dashboard showing employees' presence
Bikes Sales Dashboard
Bikes Sales Dashboard
  • Meticulously cleaned and organized raw data in Excel to ensure data quality for reliable analysis, removing duplicates and inconsistencies, standardizing data formats (dates, text entries), and addressing missing values.

  • Leveraged pivot tables for efficient data summarization and analysis. Pivot tables explored various aspects of the data, such as, trends over time (e.g., monthly sales figures), comparisons across categories (e.g., product sales by region), performance of specific items or groups (e.g., top-selling products).

  • Developed an interactive dashboard within Excel to showcase key findings from the pivot table analysis.

About Me

I have been working as a freelance data analyst for the past two years. During this time, I have acquired a diverse set of skills that enable me to effectively analyze and interpret data. My expertise lies in SQL, Power BI, Python, Tableau, Pandas, and Excel. My journey in the data world has been marked by innovation, collaboration, and a commitment to excellence.

I helped a growing e-commerce company identify customer buying patterns and optimize their product recommendations, leading to a 15% increase in average order value. This experience reflects my dedication to delivering solutions that not only push technological boundaries but also prioritize user trust and data privacy.

Beyond my core projects, I actively contribute to open-source initiatives, firmly believing in the power of knowledge sharing and collaborative development. It's my way of giving back to the community and staying engaged with the latest industry trends.

Services

Here, I excel in turning raw data into actionable insights. With services spanning data cleaning, statistical analysis, data visualization, dashboard development, and report generation, I'm your go-to for all things data. Ready to harness the power of your data?

Click below to learn more about my services and let's dive into the world of data together!

Python
R
Pandas
R logo
R logo
Pandas Logo
Pandas Logo
Python Logo
Python Logo
SQL Logo
SQL Logo
SQL
MongoDB Logo
MongoDB Logo
MongoDB
PostgreSQL Logo
PostgreSQL Logo
PostgreSQL
Tableau Logo
Tableau Logo
Tableau
AWS/Azure Logo
AWS/Azure Logo
AWS/Azure
Power BI Logo
Power BI Logo
Power BI
Excel Logo
Excel Logo
Excel

Skills

Here's what people say about me

”Every day, they strive to improve their service to the clients by developing the right blend of technology and creativity to make sure every job done is done as efficiently as possible.”

- Clarice Turner

”Every day, they strive to improve their service to the clients by developing the right blend of technology and creativity to make sure every job done is done as efficiently as possible.”

- Brian Moten

”Every day, they strive to improve their service to the clients by developing the right blend of technology and creativity to make sure every job done is done as efficiently as possible.”

- Joyce Gould

”Every day, they strive to improve their service to the clients by developing the right blend of technology and creativity to make sure every job done is done as efficiently as possible.”

- Sharon Roddy

Wanna talk?

Contact me with any questions or just to say a few nice words or if you wanna make your data journey the best one.

Drop me a message here, or you can contact me through my email. You can expect a reply within 1 - 2 business days. Cheers : )

mohammadfaizi27@gmail.com

© 2024 Zain ul Abidien Karachi, Pakistan