Project Title: Student Performance & Attendance Tracker
Embedded Files
1. Project Overview
This project is a simple SQL-based student management system that helps track student information, their course grades, attendance records, and academic performance rankings. It simulates how a school or learning platform might manage its core data operations.
2. Objectives
• Store student and course information.
• Track student grades across multiple courses.
• Record and summarize attendance.
• Rank students based on average grades.
• Practice SQL operations including JOIN, GROUP BY, AGGREGATE FUNCTIONS, and WINDOW FUNCTIONS.
3. Database Schema
Tables
Students
Stores basic student information.
• student_id (INT, Primary Key)
• first_name (VARCHAR)
• last_name (VARCHAR)
• email (VARCHAR)
Courses
Stores course details.
• course_id (INT, Primary Key)
• course_name (VARCHAR)
• instructor (VARCHAR)
Grades
Stores student grades for each course.
• grade_id (INT, Primary Key)
• student_id (INT, Foreign Key)
• course_id (INT, Foreign Key)
• grade (INT)
Attendance
Tracks student attendance for each course and date.
• attendance_id (INT, Primary Key)
• student_id (INT, Foreign Key)
• course_id (INT, Foreign Key)
• attendance_date (DATE)
• status (VARCHAR: ‘Present’ or ‘Absent’)
4. Sample Data
Sample entries were inserted into each table to simulate real-world data for three students and two courses. The data supports testing and demonstration of queries.
5. Key SQL Queries
a. Student Grades Report
Lists all students and their grades across courses.
b. High Achievers
Finds students who scored above 80 in any course.
c. Course Averages
Calculates the average grade for each course.
d. Top Performers
Displays the student with the highest grade in each course.
e. Attendance Summary
Summarizes each student’s attendance record and shows the attendance percentage.
f. Student Ranking
Ranks students based on their average grades across all courses.
6. Tools Used
• SQL – PostgreSQL
• SQL Interface – pgAdmin
7. Conclusion
This project demonstrates core SQL skills such as creating relational tables, data insertion, and performing analytical queries. It can be expanded by adding features like login systems, assignment tracking, or even web integration.
Power BI Dashboard Documentation
Project Title: Sales and Marketing Performance Dashboard
Created by: Pereeware Crystalbelle Domike
Theme: Navy Blue & White Card Style
Pages: Executive Overview, Deep Dive Dashboard
1. Project Overview
This Power BI dashboard provides a comprehensive analysis of sales and marketing performance across key dimensions, enabling stakeholders to make data-driven decisions. The design emphasizes clarity, consistency, and professionalism with a custom navy blue card-style theme.
2. Dashboard Pages & Visuals
Page 1: Executive Overview
Purpose: High-level snapshot for leadership to quickly assess business performance.
Visuals:
• Total Revenue Over Time – Line Chart
• Revenue by Marketing Channel – Clustered Column Chart
• Units Sold by Product Category – Bar Chart
• Units Sold by Gender – Donut Chart
Design Features:
• Clear visual hierarchy
• Card visuals for KPIs
• No slicers; all visuals present insights at a glance
Page 2: Deep Dive Dashboard
Purpose: In-depth insights for operational teams and analysts.
Visuals:
• KPI Cards: Total Revenue, Units Sold, Avg. Order Value
• Revenue & Units Trend: Line Charts
• Revenue by Product Category: Bar Chart
• Units by Marketing Channel: Column Chart
• Revenue by Region: Table or Map
Design Features:
• Split sections for KPIs, trends, and breakdowns
• Uniform navy color palette and spacing
• Tooltips used for interactivity instead of slicers
3. Data Sources
• Sales Data: Includes Total Revenue, Units Sold, Date, Product Category, Location
• Marketing Data: Channels, Gender, Age Group
• All data cleaned and loaded directly in Power BI; no DAX calculations used
4. Design Philosophy
• Professional & Minimalist: White background, navy blue highlights, clean font usage
• Card-Based Layout: Enhances readability and modern aesthetic
• No Slicers: Ensures focus on storytelling visuals, reducing distraction
5. Tools Used
• Power BI Desktop
• Custom Theme JSON: NavyBlue_CardStyle_Theme.json
6. Challenges & Solutions
• Challenge: Avoiding DAX while still offering meaningful insights
Solution: Leveraged default aggregation and smart chart selection
• Challenge: Making dashboard interactive without slicers
Solution: Used hover tooltips and multi-page design for segmentation.
https://drive.google.com/file/d/1j7YNB8788bK_E5V473NOAmf1N62isAUC/view?usp=sharing
In Progress E-commerce Web
Built locally using HTML, CSS and JavaScript
Features- product listing, booking system, Instagram feed, events page
Responsive layout with custom branding
Live demo available upon request
Page updated
Google Sites
Report abuse