Welcome to Database School

SQL Query Writing and Power BI Report for Academic Database Project

Industry: Education / Academic Support

Platform: Microsoft SQL Server, Power BI

  1. Project Title:
SQL Query Development and Power BI Reporting for University Assignment

  1. Objective:
The objective was to complete a structured database assignment involving SQL query writing and analytical report creation using Microsoft SQL Server and Power BI, aligned with the client’s academic requirements and strict deadline.
 
  1. Project Description:
The client required a comprehensive SQL report based on a provided brief and data structure. The tasks involved:
  1. a) Reviewing a Word document containing database questions.
  2. b) Writing optimized SQL queries for Microsoft SQL Server.
  3. c) Generating the required outputs for each task.
  4. d) Completing a Power BI dashboard segment as a supplementary task.
  5. e) Compiling all responses into a well-structured final report for academic submission.
  Despite initial pricing and deadline negotiation, the project was completed within the agreed scope and time, including a follow-up fix for one of the questions to meet academic expectations.

  1. Tools & Technologies Used:
  2. a) Database: Microsoft SQL Server
  3. b) Visualization: Microsoft Power BI
  4. c) Documentation: Microsoft Word, PDF Compilation
  5. d) Communication: Fiverr Messaging
 
  1. Key Features Implemented:
  2. a) SQL queries for data retrieval, grouping, filtering, and joins
  3. b) Use of aggregate functions for business logic representation
  4. c) Power BI visualizations to enhance analytical insight
  5. d) Final academic-style report compilation in PDF format
 
  1. Challenges Faced & Solutions:
Challenge Solution
Tight delivery deadline (within 4 days) Prioritized task queue and maintained client updates
Misinterpretation of one question Re-reviewed instructions and corrected within the requested 12-hour window
Power BI compatibility Streamlined with basic visualizations to match client’s assignment level


  1. Outcome & Benefits:
  1. a) Final deliverable submitted before May 11 deadline
  2. b) Client satisfied with revision support and communication
  3. c) Project contributed to student’s academic submission
  4. d) Follow-up conversations initiated for future projects (data mining, web app, etc.)