Business Intelligence Development ProjectLaajuus (5 cr)

Learning objectives

Upon successful completion of the course or possessing equivalent know-how the student
- understands the value of business driven BI-development
- understands the value of supporting business processes by BI-solutions
- has gained experience in creating a qualitative BI-solution by using agile
development and market leading tools to extract data from an (ERP) system)
- has learned to document/present the created solution and the process
- has gained experience in publishing solution in Enterprise/Cloud type of
environment

Contents

- design and good practices in BI development
- understanding data structures (ERP) and related business processes (O2C
and P2P)
- planning, developing and testing a complete BI-solution based on selected
user stories
- iterative and incremental development
- documenting and presenting the BI development process and solution
- basics of Microsoft BI - SSAS Tabular and Microsoft IS, Microsoft Azure
- main architecture setup – Power BI Desktop - BI Services - SharePoint

Starting level and linkage with other courses

This course is part of Business and ICT specialization area in Degree Programme in Business Information Technology.
Prerequisites:
It is strongly recommended that students has passed ONE of ICB005AS2A and ICB005AS2AE.

Students without the specific Business Intelligence course can be accepted by showing
necessary skills/knowledge at the immediate start of the course.
The test/skills measure cannot be redone and if failed acceptance for this and future courses can only be gained by passing BI-Basic.
Amount of students on the course are restricted to number of licenses available.
Students with BI-Basic passed has precedence if timely enrolled

Implementation methods, demonstration and Work&Study

Implementation methods:

- virtual with possible online and individual sessions
- studification

Assessment criteria - grade 1

When the implementation type of the course is CONTACT, ONLINE or BLENDED it is required that the student is present during those teaching hours that are marked in the study schedule. If you are absent more than 25 %, your grade will be lowered by one. If you are absent more than 50 %, the course is failed.

The student:
a) has a basic understanding of the agile BI development process
b) is familiar with data structures and related business processes
c) has gained some understanding in planning and developing a BI-solution
d) is able to utilize market leading tools to create at least a part BI-solution
More precise Assessment criteria:
To achieve the grade 1, it would be expected that
The student:
- has mainly worked independently
- has mainly followed instructions
- has planned the project and presented the project planning
- has planned and fulfilled at least some part solution
- has created a solution
- has utilized tools/architecture
- has reported and presented the solution
- has run a project with a sufficient time span

Assessment criteria - grade 3

The student:
a) has a good understanding of the agile BI development process
b) is knowledgeable of data structures and related business processes
c) has good insights in regards to planning and developing a BI-solution
d) is confident in utilizing market leading tools to create a BI-solution
More precise Assessment criteria:
To achieve the grade 3, it would be expected that the student:
- has worked independently
- has followed instructions and deadlines
- has planned the project and presented the project planning reasonably well
- has planned and fulfilled a basic solution, the created and presented
solution is pretty ordinary but of good quality
- has created a final solution that corresponds to the plan or there are
explanations and reasons why not
- has utilized good capabilities of the selected tools/architecture
- has used at least to some extent a systematic agile approach
- has reported and presented the solution
- is able in all communications to discuss using BI and ICT terminology

Assessment criteria - grade 5

The student:
a) has a very good understanding of the agile BI development process
b) is very knowledgeable of data structures and related business processes
c) has excellent skills in regards to planning and developing a BI-solution
d) is mastering market leading tools to create a BI-solution
More precise Assessment criteria:
To achieve the highest grade, it would be expected that
the student:
- has worked independently
- has followed instructions and main deadlines without exceptions
- has well planned the project and presented the project planning well
- has planned and fulfilled more than just a basic solution, the created and
presented solution has some specialty, some finding or includes an
interesting/innovative approach or the quality is excellent overall
- has created a final solution that corresponds well to the plan or there are
clear explanations and reasons why not
- has utilized good design and other capabilities of the selected tools/architecture
- has clearly applied a systematic agile approach
- has well reported and presented the solution
- is able in all communications to discuss using good BI and ICT terminology
- has fulfilled all defined requirements

Assessment criteria, approved/failed

To pass this course the student need to
- independently plan, execute and report a BI development project in accordance
with schedules and created project plan
- the work MUST be done as in a project with sufficient time span between start and end of project

Learning materials

In Moodle learning environment:
Lectures/ presentations , videos, hands on exercises , links to leading actors learning materials aso
Demonstrations
Teacher/Customer feedback on solutions developed

Further information

Amount of students on the course are restricted to number of licenses available.
This course is a direct continuation to the basic Business Intelligence courses ICB005AS2A and ICB005AS2AE