ICA Specification
Annalisa Occhipinti Page | 1
Module Title:
Big Data and Business Intelligence
Module Leader:
Dr Annalisa Occhipinti
Module Code:
CIS4008-N
Assignment Title:
Business Intelligence Solution and Report
Deadline Date:
15th January 2021
Deadline Time: 4:00pm
Submission Method:
Online (Blackboard)
Middlesbrough Tower
Library Support for Academic Skills
Did you know you can book an individual 30 minute tutorial in the Learning Hub with an adviser to help you with
your academic skills, writing or numeracy? Or that there are loEDT of really useful workshops available to help you
with your studies and assessments? Have a look at the [email protected] workshops for more details.
FULL DETAILS OF THE ASSIGNMENT ARE ATTACHED
INCLUDING MARKING & GRADING CRITERIA
ICA SPECIFICATION
Central Assignments Office (Middlesbrough Tower M2.08) Notes:
• All work (including CDs etc) needs to be secured in a plastic envelope or a folder and clearly marked with the
student name, number and module title.
• An Assignment Front Sheet should be fully completed before the work is submitted.
• When an extension has been granted, a fully completed and signed Extension form must be submitted to the
SCMA Reception.
Online Submission Notes:
• Please follow carefully the instructions given on the Assignment Specification
• When an extension has been granted, a fully completed and signed Extension form must be submitted to the
SCMA Reception.
http://libguides.tees.ac.uk/learning_hub
http://tees.libguides.com/workshops
https://powerbi.microsoft.com/en-us/
ICA Specification
Annalisa Occhipinti Page | 2
Big Data and Business Intelligence
CIS4008-N
In-course Assessment
“Business Intelligence (BI) is the use of computing technologies, applications, and practices for the
collection, integration, analysis, and presentation of business information. Business Intelligence
solutions provide current, historical, and predictive views of internally structured data for products
and departments by establishing more effective decision-making and strategic operational insights.”
For this In-Course Assessment (ICA) you are required to design and implement a Business
Intelligence (BI) Solution from an Industry based dataset using Microsoft Power BI.
You will submit a final written Report* to present your BI design and solution.
*Report: The term report is used to denote a Word document but you may utilise Powerpoint to
present part of the design and implementation of your BI Solution with supporting artefacts.
You are required to submit your ICA to the submission link on Blackboard by the due date.
ICA Requirements & Logistics
The assessment is individual based and you are required to produce a Business
Intelligence Report covering a BI Design and Solution to an industry-based dataset.
The report should mainly consists of images or screenshots with wording kept bullet
point or summative. The report is to be about 1200 words and including the
following two sections:
Section 1: Business Intelligence Design
Students will be required to identify the Business Intelligence Scope and outline the BI
Questions and BI Data Source Description. In addition, the student is able to demonstrate
the ability for data pre-processing in terms of both data cleansing and data modelling.
Demonstrate the ability to prepare a dataset for data analytics and data visualisation.
1a: BI Questions and BI Data Source Description
1b: BI Data Pre-Processing and Data Cleansing
1c: BI Data Modelling via Star Schema
https://powerbi.microsoft.com/en-us/
ICA Specification
Annalisa Occhipinti Page | 3
This will assess the student’s ability to demonstrate data integration and analysis skills
required to support business intelligence solutions using Power BI (assess Learning Outcome
1, 2 & 3).
Section 1 should include annotated screenshots of the BI design, data cleansing and the
data modelling of the dataset in PowerBI.
The annotation should be in bullet point format or a basic instruction set in order to
replicate your BI design, data cleansing and the modelling of the dataset in PowerBI.
You should aim to have a cleansed dataset loaded within MS Power BI so you can
undertake the development of a BI analytical and visualisation solution as outlined in the
next section.
Section 2: Business Intelligence Solution Report. The section of the report will be used to
present the completed data analytics and data visualisation phases of the Power BI
solution. Students will have to report the implementation of a Business Intelligence
solution for the chosen dataset that address the business question raised in section 1.
This will assess the student’s ability to demonstrate data analytics, visualisation and
reporting skills required to support any Business Intelligence solution (assess Learning
Outcome 1, 3, 4, 5, 6 & 7)
Ongoing review meetings with individual students will provide the opportunity for
formative feedback as they develop their solutions to support Business Intelligence.
ICA Specification
Annalisa Occhipinti Page | 4
ICA Section 1 – Business Intelligence Design
Section 1 of the written report must include a description of the dataset selected. This includes the
data source, provided as link, database name, tables name and column name, a screenshot of the
data in cvs or excel format must also be included.
Your report must also cover the rationale behind the choice of your dataset. For example, the
reasons why you selected that specific dataset: What is the main focus of your BI project?
Which specific features are you going to focus on? Will this dataset help you in developing
specific business skills? These questions will define the main direction of your BI project.
Provide the Business Intelligent Scope for your dataset. Identify the Data Source, Data Descriptions
and the BI requirements. In addition, demonstrate the ability to load the dataset into PowerBI and
undertake data pre-processing in terms of data cleansing and data modelling.
Essentially, you are demonstrating the ability to prepare a dataset for BI data analytics and data
visualisation as required in section 2.
You may choose a Case Study/Dataset from the list at the end of this document or choose your
own dataset from Industry, Research or Government community. More information about
this will be given in lesson.
Section 1: Business Intelligence Design – Section details
This section of the report should address the following:
1a: BI Data Source Description and BI Requirements
Data Source: What are the sources of the data or where does the data originate from? A
description of the dataset selected. This includes the data source, provided as link,
database name, tables name and column name, a screenshot of the data in cvs or excel
format must also be included.
BI Requirements: The BI Questions will help determine the Key Performance Indicator (KPI) for
analytics and visuals. This is intended as a high-level scope of the initial discovery in order to
present an understand of the following:
• What are the sources for the data or where does the data originate from?
• General descriptors of the data.
• What business processes are most critical to measure – KPI?
• What kinds of business questions/problems are you trying to answer/solve?
• Who are the key user groups of this data/report?
ICA Specification
Annalisa Occhipinti Page | 5
• Why is this information needed? (Think about the broader process)
1b: BI Data Pre-Processing or Data Cleansing
• A description of the data pre-processing steps. This will include any steps performed
to cleanse your data, such as removing NAs, renaming columns, changing data types,
removing errors, removing columns, merging tables etc.
• You should include screenshots of your Power BI project in your presentation to
illustrate the effect of each pre-processing step.
1c: BI Data Modelling via Star Schema – Facts and Dimensions.
• Using your BI requirements list or BI questions identify suitable data from your dataset and
present as Star Schema Facts and Dimensions. Commonly used dimensions are people,
products, location, date and time or demographics.
• A description of the Business Intelligence data modelling process. This will include the
description of all the steps performed to develop a well-structured Star Schema Facts
and dimensions data model, such as working with multiple tables, creating
relationships, modifying relationships or data normalisation.
• You should include screenshots of the Star Schema data model with facts and
dimensions from your Power BI project to illustrate the effect of the data modelling
process.
• Measures and Calculated Columns – The core of the dimensional model and data
elements that can be summed, averaged, or mathematically manipulated.
ICA Section 2 – Business Intelligence Solution
Using your design from Section 1, demonstrate your ability to build a Business
Intelligence Solution and present your dashboard analytics, visualisation, and findings in
a Technical Report. Since this part is the actual business report, it would be better
submitting this section as a Word document.
The BI Solution report must include the following:
• Title page This will include the title of your report, project and your details
• Executive Summary This is a condensed version of your report. To help busy people
understand what the problem is, the executive summary includes the key findings and
your recommendations. It is common practice to include one or two charts from the
full report.
• Body
o Introduction This will illustrate the questions you are addressing in your report and
will give some information about the data collected. Include a screenshot of
ICA Specification
Annalisa Occhipinti Page | 6
the data model with relationships and provide a short description of the
dataset used. This section can be shorter than usual considering that you might
be working with sample data, which are not properly related to any business.
o Finding based on analysis and evaluation This section will cover the key findings
based on analysis and evaluation: this is the most import section of your ICA.
This section must include:
(1) data analysis steps (either using M language or DAX formulae) to add
calculated columns and measures
(2) your Power BI visuals with the description of the type of data you are
displaying and why you are using such metrics. Screenshots and
description of each Power BI visuals must be included.
(3) a description of the Power BI dashboard (full collection of visuals) and
how the content of the Power BI pages is organised.
(4) the key findings from parts (1), (2) and (3).
• Conclusions and Recommendations Summarise your report and provide some
recommendations based on your findings.
Submission details
You will need to submit a single zip folder containing the following:
• The complete report (either in PDF or word format).
• The Power BI project file.
• Any Excel or csv file used to import the data.
A submission link will be available via Blackboard under the Assessments link.
You must submit your files by the due date reported on the front page of this document.
Use the following naming convention studentnumber_lastname.firstname.zip (e.g.
x1234567_smith.a.zip)
Please also make sure that submitted documentation has been tested and verified and is
not corrupted in any way which would prevent access for marking.
ICA Specification
Annalisa Occhipinti Page | 7
Learning Outcomes
This assessment has been designed to assess the following learning outcomes:
Personal and Transferable Skills
1. Reflect on and critically appraise own performance and skills development
during the module.
Research, Knowledge and Cognitive Skills
2. Examine and evaluate system level software architectures, tools and techniques
for big data systems.
3. Demonstrate a critical understanding of the issues associated with business
intelligence and big data.
4. Integrate and synthesise diverse concepts and theory on system level software
architectures for big data systems to design the data processing requirements of
big data system.
5. Research an emerging database technology and communicate the findings in
writing in an academic context.
Professional Skills
6. Select and implement appropriate BI tools and evaluate the results of their
application to a given scenario.
7. Autonomously plan, design and implement a big data system to meet an
enterprise’s information requirements and business rules for big data.
ICA Specification
Annalisa Occhipinti Page | 8
Assessment Criteria
Element 1: Business Intelligent Design Assessment Guideline Criteria (30 marks)
GRADE Characteristics of Response
%: 70-100
Marks: (21-30)
[professional | outstanding]
The BI Design report meets Microsoft Developer Network (MSDN) and Industry
standards. The design is outstanding and meets ALL learning outcomes at an
outstanding level. Clear demonstration and outstanding awareness of DW and BI
needs for industry. All design steps clearly identified and of outstanding quality.
%: 50 – 69
Marks: (15-20)
[exemplary]
The BRS report meets most of MSDN and Industry standards. The design is
exemplary and meets MOST learning outcomes at an exemplary level. Clear
demonstration and exemplary awareness of DW and BI needs for industry. Most
design steps clearly identified and of exemplary quality.
Generally, you needed to consider more depth or details to one or more sections.
You may also have considered provide more complex dimensions to your fact
table.
<50 Marks: (0-11) [inadequate] The submitted work was insufficiently well-developed for this level of study and could be improved substantially by using more thoughtful inspection use design requirements or solutions to supportBI. Element 1: Detailed assessment criteria (30 marks) following detailed have been provided help you checking that included the required elements in your ICA. Parts Checklist Section Business Intelligent Design (3 passes 30 points) A) Data Source Description Questions (10 • A descriptiondataset is included. What about? data reported each table (columns) described screenshot questions answered: Why did select specific dataset? Will developing business skills? do seek answer with BI project? ICA Specification Annalisa Occhipinti Page | 9 Which features are going focus on? Does address Big problem? B) Pre-Processing Cleansing Evidence pre- processing steps. Include screenshots Power project presentation illustrate effect pre-processing step. Is there any evidence steps performed cleanse data? For example: Removing NAs, Renaming columns Changing types errors Merging tables etc. C) Modelling – Star Schema Facts Dimensions modelling process. You should include model from If database already well-structured it does not need modification, show section deleting at least one relationship can perform adding relationships This will meet first target (creating new relationships). However, receive full 10 points case. Hence, we would suggest all three if possible. There some develop a well- structured model, such as: Creating Modifying Splitting normalise data. 2: Intelligence Solution Assessment Guideline Criteria (70 GRADE Characteristics Response %: 70-100 (49-70) 70%+ [professional outstanding] DW-BI interpretation undertaken dashboard approach employing suitable software environment graphical highlight critical dynamic manipulation employed variety supporting statistical calculations modelling. Supporting reports were very well designed developed accompanied action agenda Solution. 50 69 (35-48) [exemplary] simple calculation, but significantly enhanced in- depth tool. Results proposals responsive also considered. acceptable benefit considered content <50 (0-34) DW & tools. (7 70 D) Title page Executive Summary Introduction has title report, details executive summary provides clear report key findings presented At chart recommendations addressed brief used model. 11 E) Finding based on analysis evaluation 1 (20 M language DAX Expressions different formulae (either language, don’t replicate same formula twice Language, both languages must used. example write 2 vice-versa). understanding how shown providing written explanation applied formulas work. calculated column added into measure - Report Visuals, KPI, Infographics Animated charts including buttons. Formatting options structure Dashboard. Ask Question Tool visuals proper justification two previously measures visual created follows tips covered lessons. KPIs clearly visualised report. They analyse depending Infographics, Charts, Buttons correctly ask question tool appropriately Analytics (Forecast, Analysing trends). Artificial Machine Learning tools final further investigate results Analytics, detail showing good F) Conclusions Recommendations Personal conclusionschallenges rubric marking accessed here: link https:>