Portfolio - Cynthia Chinenye Udoye

Cynthia Chinenye Udoye

Data Scientist

Resume

2

Excel Projects

2

PowerBI Projects

1

SQL Project

About Me

Hello and welcome to my portfolio! I'm a dedicated Data Professional with a knack for turning numbers into actionable insights. Currently advancing my skills with an MSc in Data Science from the University of Hertfordshire, my academic foundation in mathematics fuels my passion for data analysis. Proficient in Excel, PowerBI, SQL, Python, and M language, I thrive on solving complex challenges and driving business growth. My hands-on experience in various projects, showcased below, reflects my commitment to delivering impactful solutions. I invite you to explore my portfolio and discover how my expertise can add value to your organization. Let's connect and explore the possibilities together!

Key Skills

SQL

Effective Communication

Problem solving

Technical skills

Project Management

Stakeholders Management

My Projects

Stock Market Analysis

Sales Analytics(FMCG)

Comprehensive Business Insights 360 Dashboard: Finance, Sales, Marketing, and Supply Chain

Comprehensive Shield Insurance Analysis Dashboard: Customer Demographics, Sales Modes, and Age Groups

AtliQ Sales Analysis SQL Project

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

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Python: Beginner to Advanced For Data Professionals

Microsoft Excel - Excel from Beginner to Advanced

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/chinenye-cynthia-udoye-data-scientist

Call Me

+44 07393161319

GitHub

https://github.com/Cynthiaudoye

Excel Project

Stock Market Analysis

In the analysis, Microsoft stands out for its stability in the market, making it a safer choice. Tesla, while riskier due to market volatility, presents potential for higher returns for those comfortable with risk. Apple strikes a balance, appealing to investors

View Project
Engagement

Risk Assessment: Higher Risk: Tesla > Apple > MSFT Higher Return Potential: Tesla > Apple > MSFT

Beta Values: Microsoft (MSFT): β = 1.22 Tesla: β = 1.45 Apple: β = 1.23

Project Details

In this project, I utilized Excel to conduct a comprehensive analysis of stock prices from 2018-2023. By generating comparative descriptive statistics and visually representing trends through charts like scatter plots and histograms, I provided insights into each stock's performance. Additionally, I employed regression modeling to assess the relationship between the percentage change in Closing Stock Prices and the S&P 500 market return for each company. By comparing Beta values, I offered a clear perspective on the stock's progress and associated risk levels, equipping stakeholders with valuable information for informed decision-making.

What I've Learned:

Importance of historical data in stock analysis.
Effective utilization of visual tools like scatter plots and histograms.
Significance of descriptive statistics such as mean, median, and standard deviation.
Interpretation of Beta values as indicators of risk.
Application of regression models in financial analysis.

Project video

Excel Project

Sales Analytics(FMCG)

Created detailed reports for the sales team, enabling them to assess customer performance metrics, understand progress towards sales objectives, and strategize effectively for future growth opportunities.

View Project
on GitHUB

Customer Sales Report: Shows how much each customer bought over the years.

Yearly Report on Market vs. Target: Helps see how well a country did and if it met its targets.

Project Details

I made a sales report in Excel to help businesses offer better discounts, negotiate with customers, and find new markets to grow in. The report gives clear advice on how to boost sales and make customers happier.

I learned:

Using pivot tables
Power Query
Basic DAX
Formatting data
Making reports look good
Important sales metrics
This project helps businesses track sales better and find ways to grow. Analyzing sales data can help companies find new chances to succeed and keep up in the changing market.

PowerBI Project

Comprehensive Business Insights 360 Dashboard: Finance, Sales, Marketing, and Supply Chain

AtliQ Hardwares, a burgeoning consumer electronics firm, faces challenges in data-driven competition as their reporting is predominantly Excel-based. This project aims to deploy an advanced Power BI analytics solution, providing vital insights for informed decision-making across the organization.

View Project
Engagement

View Project
on GitHUB

Landing Page Designed with User Empathy as an Integral Element of the Dashboard

Comprehensive Data Modeling Across Over 10 Tables

Project Details

The project's objective is to develop a unified report accessible to stakeholders from sales, marketing, finance, and the executive team. Key focus areas include:

Robust Data Modeling.
User-centric Report Design.
In-depth, Drillable Insights.
Key Learnings and Achievements:

Mastery of Power Query, covering both basic and advanced operations.
Development of fundamental and complex DAX formulas.
Comprehensive data modeling with over 10 tables.
Strategic selection and formatting of visuals.
Adherence to dashboard design best practices.
Utilization of bookmarks for dynamic reporting.
Deployment on Power BI service.
Incorporation of Stakeholder Feedback.
Integration of core metrics for Sales, Marketing, Finance, and Supply Chain.

Project video

Live Interactive Dashboard

PowerBI Project

Comprehensive Shield Insurance Analysis Dashboard: Customer Demographics, Sales Modes, and Age Groups

Shield Insurance, navigating the transition to data-driven operations, seeks to overcome limitations of traditional analytics methods. This project introduces an advanced SQL and Power BI analytics solution to enhance strategic decision-making across key departments.

View Project
Engagement

View Project
on GitHUB

User-Centric Report Design: Crafting a dashboard that caters to the specific needs of different user groups within Shield Insurance.

Robust Data Modeling: Building a solid data foundation for complex analytical tasks.

Project Details

The project focuses on developing a unified report for Shield Insurance's key departments, emphasizing efficient data modeling, tailored dashboard design, and deep analytics for exploring insurance sales data and customer demographics.

Key achievements include:

SQL and Power Query proficiency for data handling.
Building a strategic data model for insurance analytics.
Designing interactive Power BI dashboards for user engagement.
Dynamic reporting features for an interactive experience.
Seamless deployment and integration on Power BI.
Regular updates and refinements based on feedback.
Comprehensive coverage of essential metrics in customer demographics and sales.

Project video

Live Interactive Dashboard

SQL Project

AtliQ Sales Analysis SQL Project

AtliQ Hardwares, a growing electronics company, is struggling to keep up in a data-driven market due to reliance on Excel for reporting. This project introduces a sophisticated Power BI solution to help AtliQ make better, data-informed decisions.

View Project
Engagement

View Project
on GitHUB

The project offers AtliQ key insights into sales, market segmentation, and regional performance, guiding strategic decisions and positioning.

For additional data analysis and visualization.

Project Details

The AtliQ Sales Analysis SQL Project, focused on strategic decision-making in a consumer electronics context, combines SQL and Excel for various key tasks. These include generating detailed monthly sales reports, classifying markets based on sales into 'Gold' or 'Silver' categories, creating SQL views for efficient net sales analysis, and performing regional sales analyses to identify market trends and financial insights.

Key Learnings:

SQL Proficiency: Mastered extracting and aggregating sales data, particularly for monthly reporting.
Stored Procedure Creation: Developed dynamic market classification stored procedures.
View Development: Gained skills in creating efficient SQL views for enhanced query performance.
Regional Sales Analysis: Learned to analyze sales data by region, understanding market trends and financial performance.
Excel Analytics: Improved Excel abilities for data analysis and visualization.