Explore My Data Universe

I'm Angel Kocev Data Analyst

About Me

I am Angel Kocev (Angelche Kocev), passionate about working with data to uncover insights through data analysis and visualization. With a solid foundation in data science, I analyze patterns, trends, distributions, and insights to inform decision-making. Alongside my data journey, I have over five years of experience as a history teacher and database administrator. I am currently a PhD candidate in the field of Historical Sciences. Committed to lifelong learning and positive change, I aim to combine my teaching expertise with data-driven approaches to foster growth and understanding.

Technical Skills Soft Skills Experience Education Certification

SQL: - Proficient in SQL, specializing in MySQL, SQL Server, and PostgreSQL for database management and querying.

Tableau: - Experienced with Tableau, including Tableau Public and Tableau Desktop, for creating interactive data visualizations.

Python: - Skilled in Python, with a focus on data analysis using Pandas, Matplotlib, Seaborn, and web scraping with BeautifulSoup and Requests.

R Programming Language: - Experienced in R, particularly with the tidyverse, lubridate, ggplot2, and dplyr packages for data manipulation and visualization.

Excel: - Proficient in Excel, including advanced formulas and functions, Pivot Tables, Pivot Charts and Graphs, Conditional Formatting, and Power Query.

Power BI: - Skilled in dashboards, Power Query, data modeling, and DAX for analytics.

Microsoft Azure: - Focusing on Azure Data Factory, Azure SQL Database, Azure Blob Storage, and Azure Synapse Analytics for data integration and management.

Amazon Web Service (AWS): - Specializing in Amazon S3 for storage, RDS for database management, Athena for querying, Glue for ETL, Redshift for data warehousing, etc.

Communication - Strong communication skills, ensuring clear and effective information exchange.

Problem-Solving Skills - Adept at identifying issues and devising practical, data-driven solutions.

Explanation of Complex Concepts - Skilled in simplifying and explaining complex concepts to diverse audiences.

Collaboration & Teamwork - Proven ability to work collaboratively to achieve common goals.

Presentation Skills and Storytelling - Excellent presentation skills, using storytelling to convey data insights compellingly.

Attention to Detail - Meticulous attention to detail, ensuring accuracy and thoroughness in all tasks.

Research - Experienced in conducting thorough research and collecting reliable data for analysis.

Teaching & Academic Writing - Proficient in teaching and academic writing, with a strong background in developing and delivering educational content.

History Teacher & Database Administrator
Primary School "Strasho Pindzur" - Negotino, Republic of North Macedonia 2019 - Present

Social Sciences Teacher & Database Administrator
Primary School "Goce Delchev" - Negotino, Republic of North Macedonia 2020 - 2022

- Collecting data through surveys from employees, students, and parents, followed by analysis and visualization for the purpose of preparing the school's self-evaluation and development program. - Creating, managing, and maintaining school databases, ensuring data accuracy and integrity, processing and analyzing the data, and developing Tableau dashboards for easier access to insights. - Developing a system to collect data on the academic performance of students and teachers, followed by analysis and visualization to identify trends and patterns. - Applying advanced Excel formulas, functions, and conditional formatting for data processing and visualization, including working with pivot tables. - Creating data visualizations in Tableau and Excel to present information in a clear and understandable manner. - Collaborating and communicating with a wide range of people (principal, counseling staff, teachers, parents, and students) on a daily basis to enhance the educational process. - Encouraging students to apply critical and analytical thinking to uncover cause-and-effect relationships, patterns, and trends in history. - Leveraging strong presentation and communication skills to break down complex data concepts and make them accessible to diverse audiences.

PhD in Digital Humanities
Faculty of Philosophy - Skopje, UKiM, Republic of North Macedonia 2022 - Present

Master of Arts in Contemporary History
Faculty of Philosophy - Skopje, UKiM, Republic of North Macedonia
Exchange student at the Faculty of Philosophy in Zagreb, Republic of Croatia Completed in 2020

Bachelor of Arts in History
Faculty of Philosophy - Skopje, UKiM, Republic of North Macedonia Completed in 2016

Google Data Analytics Professional Certificate (Coursera by Google) view
- Foundations: Data, Data, Everywhere view
- Ask Questions to Make Data-Driven Decisions view
- Prepare Data for Exploration view
- Process Data from Dirty to Clean view
- Analyze Data to Answer Questions view
- Share Data Through The Art of Visualization view
- Data Analysis with R Programming view
- Google Data Analytics Capstone: Complete a Case Study view

Data Analyst Roadmap (Analyst Builder) view
- MySQL for Data Analytics view
- Advanced MySQL for Data Analytics view
- Excel for Data Analytics view
- Advanced Excel for Automation view
- Python Programming for Beginners view
- Tableau for Data Visualization view
- Cloud Computing Essentials with Azure and AWS view
- Pandas for Data Analysis view
- MySQL Interview Crash Course view
- Python Interview Crash Course view
- Landing a Data Job view - Microsoft Power BI Desktop for Business Intelligence view

Data Visualization with Tableau Specialization (Coursera by UC, Davis) view
- Fundamentals of Visualization with Tableau view
- Visual Analytics with Tableau view
- Essential Design Principles for Tableau view
- Creating Dashboards and Storytelling with Tableau view
- Data Visualization with Tableau Project view

Python for Everybody Specialization (Coursera by University of Michigan)
- Programming for Everybody (Getting Started with Python) view
- Python Data Structures view

Other Courses (Maven Analytics, Coursera & DataCamp)
- Microsoft Excel: Data Analysis with Excel Pivot Tables view
- Microsoft Excel: Advanced Excel Formulas & Functions view
- Microsoft Excel: Data Visualization with Excel Charts & Graphs view
- Data Literacy Foundations view
- Foundations of Business Intelligence view
- Get Started with Python view
- Python Data Analytics view
- Introduction to Relational Databases in SQL view
- Introduction to ChatGPT view

Data Mastery Services

With proficiency in Excel, SQL, Python, R, and Tableau, I offer end-to-end data solutions, from data preparation to analysis and visualization. My blend of technical expertise and strong soft skills ensures effective problem-solving and insightful decision-making.

Data Analysis

Conduct comprehensive analysis using Excel, SQL, Python, R, and Tableau to extract actionable insights, identify trends, patterns, and correlations, interpreting findings to support informed decision-making.

Data Cleaning

Enhance dataset reliability and quality through comprehensive data preparation, including identifying errors, standardizing formats, transforming data, and ensuring consistencies. Optimizing data for analysis.

Data Visualization

Develop visually engaging representations of key metrics and trends using charts, graphs, and interactive dashboards, facilitating easy comprehension and interpretation of complex data for stakeholders.

Database Management & Querying

Efficiently retrieve, filter, and manage data using SQL queries, optimizing database performance and ensuring data integrity, security, and compliance through effective database management practices.

Statistical Modeling

Apply advanced statistical techniques to analyze data patterns, build predictive models, and identify correlations, empowering businesses to anticipate trends and make data-driven decisions.

Data Governance

Establish and enforce policies and procedures to govern data quality, privacy, and usage, ensuring the integrity and compliance of data assets while promoting transparency and trust in data-driven decision-making process.

Projects Showcase

In my recent projects, I leveraged Excel, MySQL, Python, Tableau, Power BI, and Azure Data Factory for data preparation, cleaning, transformation, data modeling, exploratory data analysis (EDA), and visualization, transforming raw data into valuable insights.

MySQL: Data Cleaning & EDA

World Life Expectancy

This MySQL project cleans world life expectancy data and performs exploratory analysis to explore trends and correlations with GDP, BMI, and adult mortality.

Python - Pandas and Matplotlib: Data Cleaning, EDA and Visualization

IMDb Movie Genres Analysis

This research analyzes the IMDb movie dataset, focusing on movie genres. It explores which genres are most common, generate the highest profits, and have the most popular movies.

MySQL: Data Cleaning & EDA

US Household Income

This MySQL project cleans and analyzes U.S. household income data, correcting errors and exploring income trends across states, counties, and cities. It aggregates and joins data to provide insights into income disparities.

Excel: Data Cleaning, EDA & Visualizations

US Debt Tracker

The US Debt Track project in Microsoft Excel involves analyzing data related to the nation's debt. Charts and graphs created in Excel help illustrate US debt trends over time. The project includes forecasting future US debt levels based on historical trends.

Python - Pandas, Matplotlib and Seaborn: Data Cleaning, EDA and Visualization

Food Marketing Analysis

This project analyzes customer spending and campaign acceptance across different demographics, providing insights into the most effective channels and strategies for engagement.

Excel: Data Cleaning, EDA & Visualizations

Bus Breakdown and Delays in NYC

This project analyzes bus delays and breakdowns in New York City, examining the causes, timing, and regional distribution of these issues, as well as the performance of different bus companies.

Excel: Data Cleaning, EDA & Visualizations

Bike Sales

Gain insights into the demographics of bike buyers, including age, income level, geographic location, and gender.

Tableau: Data Visualization

Tableau Projects

Welcome to the Tableau Dashboard corner of my world. Feel free to take a peek!

Excel: Data Manipulation, EDA & Visualization

Coffee Orders Data

Excel's interactive dashboard reveals Coffee Orders insights.

Python Project

Unit of Measurement Converter

A Python program that allows users to convert between different units of measurement (inches, feet, yards, miles) with flexible input handling and accurate results.

MySQL: Data Cleaning

Automated Data Cleaning Project

An automated data cleaning project in SQL that creates a stored procedure to copy and clean household income data by removing duplicates, standardizing text fields, and fixing data quality issues, with a scheduled event to run the procedure periodically.

Python Project

Calculator

A Python calculator program that performs basic arithmetic operations (addition, subtraction, multiplication, and division) based on user input, with the option to continue performing calculations or exit the program.

Python Project

Automatic File Sorter

A Python script that automatically organizes files in a specified directory by sorting them into subfolders based on their file types, such as CSV, TXT, PNG, and TSV, ensuring efficient file management.

Python: Web Scraping

Automated Crypto Web Scraper

An automated Python web scraper that pulls the latest Bitcoin price from CoinMarketCap every hour, stores the data in a CSV file, and includes the cryptocurrency name, price, and timestamp.

Python: Web Scraper, Regular Expression and Pandas

Counting the Words

A Python web scraper that extracts Dr. Martin Luther King Jr.'s speech from a webpage, cleans the text using regular expressions, splits it into individual words, counts their occurrences, and exports the word count data to a CSV file.

Azure Data Factory Projects

Microsoft Azure

Step into the Azure Data Factory corner of my world, where data transformation is made seamless—take a peek!

Automating Excel Reports with VBA and Macros

Vehicle Crash Report

Optimized crash reporting workflows through VBA and Macros.

Data Cleaning in MySQL Project

Layoffs

A comprehensive SQL project focused on cleaning and standardizing a layoffs dataset by removing duplicates, correcting data inconsistencies, handling null values, and transforming data types.

Automated Dashboard Project in Excel

LAPD Crime Statistics

An automated Excel dashboard project utilizing Power Query, Power Pivot, and DAX to analyze and visualize LAPD Crime Statistics, providing dynamic insights into crime trends and categories with interactive visualizations.

Efficiently Managing Library Resources

Library Management System

This project demonstrates the implementation of a Library Management System using SQL, showcasing skills in database design, CRUD operations, advanced queries, stored procedures, triggers, and data analysis to manage books, members, employees, and branches effectively.

From Data Cleaning to Business Insights

Retail Sales Analysis

This project uses MySQL to clean, explore, and analyze retail sales data, uncovering key insights into sales performance, customer behavior, and purchasing trends.

Exploring Menu Popularity and Customer Spending

Restaurant Orders Analysis

This project uses SQL to analyze restaurant order data, uncovering insights into menu popularity, customer spending patterns, and order trends to optimize operations and improve decision-making.

HR Insights: From Data to Action

HR Analytics Dashboard

This Power BI HR Analytics Dashboard leverages DAX and data modeling to visualize employee attrition, performance, and workforce trends, enabling data-driven HR decisions.

Hire Me

I am open to part-time roles and full-time positions in data analytics. Connect with me via email: angelkocev30@gmail.com