Reference no: EM132762337

CIS4008-N Big Data and Business Intelligence - Teesside University

Assignment - Business Intelligence Solution and Report

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

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 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?

• 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

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.

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.

Attachment:- Business Intelligence Solution and Report.rar