Data Analyst Well Versed in Excel, Power BI and SQL @OmangAnalytics
This project demonstrates my ability to use SQL to extract, organize, and analyze data to answer relevant business and analytical questions. I developed SQL queries to retrieve specific information from the dataset, filter and sort records, perform calculations and aggregations, and identify meaningful patterns and trends.
This project analyzes e-commerce sales data to identify key trends in revenue, customer purchasing behavior, product performance, and sales activity. Using Microsoft Excel, I transformed the dataset into an interactive dashboard that provides a clear overview of business performance. The analysis uses Excel formulas, PivotTables, and PivotCharts to calculate key metrics and uncover meaningful insights that can support data-driven decision-making. Key Areas Analyzed: Sales performance, product categories, customer demographics, payment methods, shopping locations, and revenue trends. Tools Used: Microsoft Excel | PivotTables | PivotCharts | Excel Formulas | Data Visualization
This project analyzes medical equipment procurement data to evaluate purchasing activities, supplier performance, procurement costs, and equipment categories. The dashboard provides a clear overview of procurement operations and highlights important patterns that can support better purchasing and resource allocation decisions. Using Microsoft Excel, I created an interactive dashboard with KPIs, PivotTables, and visualizations to summarize procurement performance and make the data easier to understand. Key Areas Analyzed: Procurement costs, equipment categories, supplier performance, purchasing trends, and procurement activity. Tools Used: Microsoft Excel | PivotTables | PivotCharts | Excel Formulas | Data Visualization
This project analyzes medical insurance data to understand the factors influencing insurance costs and identify patterns across different customer groups. The dashboard presents key metrics and trends to help explore how demographic and policy-related factors affect insurance charges. Using Microsoft Excel, I applied formulas, PivotTables, and visualizations to analyze the data and communicate the findings through an interactive dashboard. Key Areas Analyzed: Insurance costs, customer demographics, policy factors, customer segments, and cost trends. Tools Used: Microsoft Excel | PivotTables | PivotCharts | Excel Formulas | Data Visualization
This project analyzes restaurant order data to evaluate sales performance, customer ordering patterns, and product performance. The Power BI report provides an interactive view of key business metrics and helps identify trends that can support operational and strategic decision-making. I used Power BI to create calculated measures, KPI cards, interactive visualizations, and filters that allow users to explore the data and gain meaningful insights. Key Areas Analyzed: Revenue performance, order trends, product performance, customer ordering behavior, and sales patterns. Tools Used: Power BI | DAX | Data Modeling | Data Visualization
This project analyzes student survey data to explore patterns related to academic pressure, mental health concerns, lifestyle factors, and access to professional support. The Power BI report presents key findings through interactive visualizations and KPIs. The analysis helps identify trends and relationships within the data, making it easier to understand the factors associated with students' reported experiences. Key Areas Analyzed: Academic pressure, mental health concerns, treatment-seeking behavior, lifestyle factors, and student demographics. Tools Used: Power BI | DAX | Data Modeling | Data Visualization
This project analyzes online retail data to evaluate sales performance and customer purchasing behavior across different markets. The Power BI report provides an interactive overview of key metrics and trends to support business decision-making. I used Power BI to analyze revenue performance, product demand, customer activity, and geographical trends, presenting the findings through KPI cards, charts, filters, and interactive visuals. Key Areas Analyzed: Revenue performance, product demand, customer behavior, market performance, and sales trends. Tools Used: Power BI | DAX | Data Modeling | Data Visualization
Abuja, Nigeria