Assessment

Module Title:	Business Intelligence
Module Code:
Lecturer Name:	John Rowley
Assessment Title:	Power BI Airline Delay Analysis
Assessment Type (Exam or CA):	CA
Weighting % Within The Module:	40%
Group and / or Individual:	Group or Individual (on Repeat)
Min & Max Group Size	2-4
Formats (e.g. written, poster, video, audio, etc.):	Power BI File with written report
Length (e.g. word count, video timing, etc.):	200 words + or 10%
Submission:	Through Moodle
Issue Date:	July 30th
Submission Deadline (Time and Date):	To be announced probably mid August, 1 week after exam.

Learning Outcomes Addressed:

MIML02	Apply appropriate key performance indicators to monitor business performance
MIML03	Interpret and use data models to access analytical data using modern business intelligence tools
MIML03	Apply state of the art self-service business intelligence tools and techniques to build dashboards monitoring performance and providing business intelligence

Assessment Details: Download the compressed file on Moodle / Google Classroom called AirlineDelays.zip. This file contains more than two million records of U.S. airline flight delays.

1. Use Power BI to analyse this data set and create a dashboard showing key metrics that you believe are significant.
2. Your Dashboard should make use of slicers, charts, interactive drilldowns, cards (mode, medians and means).
3. Interactive Drilldowns should allow break down by month, airline etc.
4. Your Power BI file should demonstrate the use of data transformations, adding new columns and at least two DAX measures.
5. Produce a written report highlighting the objectives you set out to achieve with your dashboard, the key findings from the dashboard figures and a brief description of the challenges you faced as you worked on the dashboard.
6. Present your finding as group in the final class of the semester.
7. Submit your pbix file and report up onto Moodle

Marking Criteria & Feedback:

Student Identifiers:		Provisional Grades Achieved:
Module:		Issue Date:
Submission Date:
Assessment:		Lecturer:

Criteria	Evidence of Achievement	Mark
Part A (if assessments lends to multiple components):	/100
Criteria A	Interactivity Slicers Etc	/20
Criteria B	Interactivity Drill Down	/20
Criteria C	Analysis Use of Visuals, Dashboard Design	/20
Criteria D	Use of Measures and Dax	/20
Criteria E	Report	/20
Part B (if assessments lends to multiple components):	/??
Criteria A		/??
Criteria B		/??
Criteria C		/??
Criteria D		/??
Criteria E		/??

Important Notes: Groupwork: For group projects, the lecturer reserves the right to amend individual group members marks upwards or downwards from the group marks, to reflect individual level of input and effort. This can result in group members achieving different final marks for the assignment. MBA students only: Moodle & Turnitin: a guide is available at http://intranet.ibat.ie/moodleturnitin-guide.html All other students: Please ensure that you are familiar with the Vericite software. Citing & Referencing: a guide and generator is available at http://www.citethisforme.com/harvard-referencing (or lecturer preference) IBAT Assessment Regulations: The IBAT College Quality Assurance Manual (QAH) is available at https://www.ibat.ie/downloads/Institutional_documents/IBAT%20College%20Dublin%20Quality%20Assurance%20Handbook%202019%20V4.4.pdf Chapter 8 addresses Assessment. Responsibility of Students: see section 8.3.8. Registration for Assessment: see section 8.6 Deferrals & Reasonable Accommodation Policy: see section 8.7 and 8.8 Extensions & Late Submissions: see section 8.9 Re-sit Assessment: see section 8.13.5 Academic Misconduct: see section 8.16

Attachments:

ibat-bi-asses....docx