Critical thinking and decision making at its best
Hey, I’m Kingsley Ayozie
Mechanical Engineer (Industrial Production Engineer) /Data Analyst
I help institutions Describe, Prescribe and Predict their possible positions and make adequate decisions based on their previous data/informations through Defining the Problem statement, data modeling, Data quality check, Exploratory data analysis and Data communication. Intrepreting them in pictures and dashboards. So in other words I turn data/information into pictures.
World Population EDA
EDA with PYTHON
I Utilized Python to analyze the world population in different years 1970, 1980, 1990, 2000, 2010, 2015, 2020, 2022With the use of pandas I formatted and identified the key requirements needed to show a descriptive analysis on the previous worldpopulation and growth rate.Aggregated and visualized the data by using pandas, matplotlib.
COVID-19 Portfolio Project
Applied SQL to format data and Power Bi for visualization
I really enjoyed working on this project,
Utilized SQL to interpret and extract the required data from different related tables from COVID-19 databases using JOIN and VIEW
Transformed and filtered data by using aggregating and filtering function to improve reporting process
Loaded and visualized data with Power BI to identify areas with highest death rates and survival rates
Super-Market-Sales
Microsoft Excel dashboards
I Created a dashboard with Excel to help compare the sales and orders using single chart, which month got the highest sales, Gender that purchased more in 2022, Different order status, Top 10 states contributing to the sales, etc. I Transformed and processed the data using some Excel Formulas, Condition Formatting and Pivot tables to ensure data completeness and validity and also Provided technical insights on best sales channel and products with Profit margins
DATA PROFESSIONAL SURVEY BREAKDOWN
Power BI project
I Utilized Power BI to perform sentiment analysis on different data professionals in Canada, United Kingdom, United States, India and other parts of the world. Performed data cleaning and text analysis to successfully identify the necessary columns and rows needed (filtered, deleted, changed type, spilt column and added column). Finally I Created a dashboard on country of survey takers, Average Salary by Job title, happiness with work life, favorite programming language, difficulty to break into data, etc.
About Me
Critical thinking and Decision Making
"Hello there! I'm a dedicated Data Analyst and Industrial Production Engineer with a passion for extracting valuable insights from complex datasets. My journey began in the world of industrial engineering, where I honed my skills in optimizing processes and enhancing productivity. As my curiosity expanded, I ventured into the realm of data analysis, where I thrive on uncovering patterns, trends, and actionable recommendations from data-driven narratives. With a solid foundation in both fields, I bring a unique perspective to problem-solving, merging analytical thinking with real-world application. Join me as we explore the dynamic interplay between data and industry, transforming information into innovation."
Let’s Talk
Every institution needs a data analyst which plays a crucial role in extracting insights and patterns from data, helping organizations make informed decisions. Interpret data to identify trends, opportunities, and challenges, which can guide strategic planning and business growth. Schedule an initial consultation by leaving your details below.
Engr. Ubanwa Avenue Orogwe
07064326644