Portfolio/Projects

Welcome to my portfolio! Here, you’ll find a selection of my projects that showcase my skills in data analysis, visualization, and management information systems. Each project highlights my ability to deliver actionable insights and improve operational efficiency. 

Project 1: Secondary School Data Management/Analysis Flow 

Description:
I developed a flow using Power Automate in conjunction with Microsoft Forms to streamline administrative tasks in secondary schools. The system simplifies various processes, making it easier for both educators and students to manage their information.

Tools Used:

• Microsoft Power Automate

• Microsoft Forms

• Microsoft Excel Online with Office Scripts

• Google Drive

Skills Involved:

• Digital Process Automation

• Data Analysis

Features:

• Student Registration: Allows for easy registration and unregistration of students.

• Results Management: Teachers can upload and download students' results seamlessly.

• Parent Communication: Results are published and emailed to parents for easy access.

• Student Access: Students can download their results at any time.

• Score Sheets: Provides downloadable class/subject scoresheets.

• Parent Memos: Sends memos to all registered students' parents.

• Staff Registration: Facilitates registration with varying levels of access rights.

• Automated Subscriptions: Offers an automated subscription channel via bank transfer.

Outcome:
The flow enhances operational efficiency within secondary schools, allowing for better management of student data and improving communication with parents. Attached are samples of the flow in action.

If you're interested in seeing how it works, please contact me at +2348064678011 or email stanleyitemuwa@gmail.com. 

Check out the form here: View the Form.

Attachments:

Project 2: Customer Insights Dashboard

Description: I developed a comprehensive Customer Insights Dashboard using Power BI to provide stakeholders with valuable insights into customer satisfaction and treatment metrics. This interactive dashboard consolidates data on customer experiences, payment methods, and service performance, enabling data-driven decision-making.

Tools Used:

• Microsoft Power BI

• Microsoft Excel

• SQL Database

Skills Involved:

• Data Visualization

• Data Analysis

• Business Intelligence

Features:

• Transaction Insights: Displays transaction counts segmented by payment method (Cash, Debit Card, Credit Card), facilitating understanding of customer payment preferences.

• Customer Satisfaction Metrics: Visualizes customer satisfaction distribution, allowing quick assessment of overall customer experiences through ratings.

• Service Type Performance: Shows extreme satisfaction rates and treatment counts by service type, helping identify areas for improvement in service delivery.

• Revenue Analysis: Provides total revenue metrics categorized by service type, offering insights into financial performance and profitability.

• Time Series Analysis: Tracks customer satisfaction trends over specific time periods, aiding in the evaluation of service improvements or declines.

Outcome: The Customer Insights Dashboard enhances the ability to monitor customer satisfaction and financial performance in real-time, allowing for strategic adjustments and improved service offerings. The dashboard has been instrumental in guiding business strategies based on data-driven insights.

Power BI Report:

Project 3: Base Station Maintenance Report

Description: I developed a two-page Base Station Maintenance Report dashboard using Power BI to monitor the operational status and signal performance of base stations across various regions. The dashboard includes interactive visualizations, including map-based performance tracking, to help maintenance teams and stakeholders identify key areas for intervention based on real-time data.

Tools Used:

• Microsoft Power BI

• Microsoft Excel

• SQL Database

Skills Involved:

• Data Visualization

• Geospatial Analysis

• Data Analysis

• Reporting Automation

Features:

• Real-time Monitoring: Tracks the number of sites that are online, offline, and disconnected, enabling quick identification of base stations needing attention.

• Signal Performance by Cluster: Displays signal performance by clusters across different regions, helping teams prioritize maintenance efforts in specific locations based on operational data.

• Map View: Provides a geospatial representation of base station clusters across various states, allowing stakeholders to visualize geographic areas where issues are concentrated and make region-specific decisions for dispatching maintenance teams.

• Reasons for Disconnections: Visualizes the percentage breakdown of disconnection causes, such as ignition relay issues, meter faults, and unit disconnection, enabling root cause analysis for service interruptions.

• Connection Status and Signal Quality: Displays a detailed view of the connection status (on, off, disconnected) and signal quality of base stations, providing insight into overall network health and operational efficiency.

• Regional Performance: Analyzes signal performance by region, enabling management to compare the operational status of base stations across different areas and direct resources accordingly.

Outcome: The Base Station Maintenance Report dashboard enhances operational visibility for maintenance teams, facilitating data-driven decisions to improve base station uptime and signal performance. The map view offers a geographical overview, making it easier to visualize regional performance and prioritize resources effectively. This dashboard has proven valuable in identifying maintenance priorities and optimizing operational tasks.

Power BI Report: