Hello,I’m Ogechi Faith, a Data Analyst passionate about transforming data into actionable insights that drive business growth and efficiency. With a strong foundation in SQL, Excel and PowerBi, I specialize in analyzing complex datasets to uncover strategic insights that empower data-driven decision-making. I thrive both independently and in collaborative environments, applying my analytical skills to solve real-world problems.
- Data Analysis: SQL, Excel, Data Visualization, Data Cleaning
- Tools: Power BI,Microsoft Office Suite, MySQL
- Techniques: Descriptive and Predictive Analytics, Statistical Analysis, Trend Analysis
Sales Analysis of Transportation Modes Across 21 Countries
This repository showcases a project where I utilized SQL and Excel to analyze sales data and build interactive dashboard for various modes of transportation across 21 countries. I demonstrate my ability to handle large datasets, identify key trends, and present findings that inform business strategies.
https://github.com/Ogechifaith-analytics/project/blob/main/Sales%20analysis%20project.sql
- Feature engineering
- Generic question
- product analysis: identifying product trends, top selling products, differences in products demand
- sales analysis: analyzing sales per month, sales per city and cost-revenue per product
- customer analysis: evaluating customer pattern and behaviour
- visualization: comprehensive visualization using chart and dashboards
- SQL: joins,CTE'S,window functions,Aggregate.
- Excel:Pivot tables,chart,slicers.