I’m a Data Analyst with a passion for discovering the stories hidden in data.My journey started with alove for tackling complex Math problems, and a curiosity about how data influences the world.Over time, this has evolved into an exciting career whereI turn raw data into actionable insights that power smart decisions.

On my GitHub, you’ll find diverse projects that showcase my skill set.

• Languages: Structured Query Language(SQL), Python, R
• Tools: Excel, Power BI, MySQL, Microsoft SQL Server, Jupyter Notebook, R Studio, Google Cloud Platform(GCP), Microsoft Office
• Data Visualization: Tableau, Power BI, Looker, Matplotlib, Seaborn, Excel Charts, Dashboards
• Data Manipulation: Advanced Spreadsheet Functions, Google BigQuery, Pandas, NumPy, Tidyverse, SQL.
• Data Cleaning: Handling missing data, Outlier detection, Data normalization, Data transformation.
• Statistical Analysis: Hypothesis testing, Regression analysis, Statistical inference,etc

• Bachelor's degree in Applied Mathematics, Kenyatta University.
• IBM Data Analyst Professional Certificate, Coursera.
• Google Data Analysis with R Programming Certificate, Coursera.
• Microsoft Data Analysis and Visualization with Power BI Certificate, Coursera.
• UC Davis Fundamentals of Visualization with Tableau, Coursera.
• Google Cloud Data Analytics Professional Certificate, Coursera.

1. Phone Sales Data Analysis - UtilizedPython andJupyter Notebooks with libraries such asPandas,Numpy,Matplotlib, andSeaborn to clean, analyze, and visualize a Phone Sales Dataset, thereby identifying consumer preferences, pricing trends, and market dynamics while uncovering key insights into brand performance and customer satisfaction.

2. Bolt Ride Analytics - UtilizedMySQL for data cleaning, formatting, and analysis of Bolt Ride operations, alongsideTableau for visualization and dashboard creation, enabling the identification of peak ride times, popular pickup locations, and revenue trends to enhance decision-making and operational efficiency.

3. Healthcare Performance Analysis - UtilizedMicrosoft SQL Server andPower BI for data cleaning, analysis, and visualization of a Healthcare Dataset, enabling the identification of key trends and providing deeper insights into healthcare performance and operational effectiveness.

4. Supermarket Sales Analysis - UtilizedMicrosoft Excel to clean, conduct exploratory data analysis, create pivot tables and charts, and develop an interactive dashboard for a Supermarket Sales Dataset, thereby delivering insights into the sales performance of the supermarket's three major branches.

...and several others as shown in myrepositories!

I encourage you to explore the projects further on myPortfolio Website.Should you have any questions or opportunities for collaboration, don’t hesitate to email me atpatriciavalentinedanga@gmail.com or connect with me onLinkedIn.

Popular repositoriesLoading

1. GYM-MEMBERSHIP-EXPLORATORY-DATA-ANALYSISGYM-MEMBERSHIP-EXPLORATORY-DATA-ANALYSISPublic

   This project analyzes a Gym Membership Dataset using Excel to uncover insights into member behavior and gym usage patterns. The analysis is visualized through charts and a dashboard.

   1

2. patriciavalentinepatriciavalentinePublic

   This is the configuration for my GitHub profile.

3. SUPERMARKET-SALES-ANALYSISSUPERMARKET-SALES-ANALYSISPublic

   This is an Excel project that aimed to provide insights into the sales performance of a supermarket's major three branches.

4. HEALTHCARE-PERFORMANCE-ANALYSISHEALTHCARE-PERFORMANCE-ANALYSISPublic

   In this project, I utilized Microsoft SQL Server & PowerBI to analyze & visualize a healthcare dataset, hence providing insights into the Healthcare performance of several health facilities in the …

5. BOLT-RIDE-ANALYTICSBOLT-RIDE-ANALYTICSPublic

   This is a project focused on analyzing the operations of a Bolt Ride. I used MySQL for data cleaning, formatting, and basic analysis, followed by Tableau for visualization and to create a dashboard.

6. KCSE-RESULTS-WEB-SCRAPINGKCSE-RESULTS-WEB-SCRAPINGPublic

   In this project, I developed a Python-based web scraping solution to extract and structure tabular Kenya Certificate of Secondary Education (KCSE) data from the webpage of Moi Kapsowar Girls.

   Jupyter Notebook