Business Intelligence Development Project - Study guide

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

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

- 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

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

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

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

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

NOTE: From Autumn 2023 this course starts from the semester start (not period 2) and defined as a 16-week course (can still be done in shorter time)

This is the second course of the renewed business intelligence course setup.

It is setup as 16 week non-stop e-learning approach with the strong recommendation to utilize Zoom sessions with teacher/customer as part of submitted iterations.

The two BI-courses build on a Business Intelligence Framework, stressing the importance of creating business value, valuing the strategy alignment, imposing the importance of BI-maturity understanding and suggests the need for an agile approach to BI-development life cycles.

In this second course the student runs a project in which a BI-solution based on user stories and agile development principles are created.

The architecture utilized is Power BI Desktop - Power BI Pro (cloud) - SharePoint.
Power BI pro license will be provided by Haaga-Helia.

As the course is now 16 weeks - students that have NOT passed the BI-basic can be accepted BUT then need to first gain the proper basic knowledge during first weeks.

The amount of students accepted to one implementaton is restricted by the amount of HH Power BI pro licenses available (25)

Business Intelligence Development Project – ICB012AS3AE, 5 credit points, Professional studies, Optional

Moodle materials and reference articles, documents and sites.
SharePoint support Site and content
Business Intelligence Platform 2021 - support

Pasila Campus

No exam

English

World leading tools and material in English

19.08.2024 - 13.12.2024

Course setup – Autumn 2023 forward The BI Development Project course consists of the following parts: 1. Introduction Presentations and course overview 2. Project Initiation Project plan and Schedule Proof of concept --> Schedule published in SharePoint Grading document created 3. Iteration 1 Some Nav learnings and adding new data to Nav – Journal Some Visual Design learnings – Journal Some AI elements introduction - Journal 4. Iteration 2 Solution published based on defined User stories Reporting Self-check of solution 5. Iteration 3 Solution published based on defined User stories New version of Iteration 2 solution (if applicable) Reporting Possible Zoom with teacher 5. Iteration 4 Solution published based on defined User stories New version of Iteration 2 and 3 solutions (if applicable) Reporting Possible Zoom with teacher 6. Project closing Total solution published and submitted Project report Possible Zoom with teacher As part of grading an extra Iteration can be initiated by teacher, if initiated it is either to pass the course or to get a higher garde 7. Official course feedback and feedback directly to teacher In Moodle and Peppi system Mandatory if grade and credits wanted

03.06.2024 - 16.08.2024

From Autumn 2023 the course starts from semester start and can be done for -16 weeks also including possible learning activities.
To support student individual study situation - extra time can be granted to finish the project as long as the
first iterations are done properly.

IT4PAICB1
ITE4PAICB1
VIRTUAL
INSTRUCTED
EXCH
ITB4PAICB1

RPL can be applied - contact teacher by email.

Ralf Rehn

30 - 60

Grade 5 (90%)
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

Grade 3 (70%)
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

Grade 1 (50%)
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 procedure and setup
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 timespan between start and end of project
- Teams CAN be accepted but requires always a start-up meeting with teacher

TRATI Business Information Technology, ITBBA Business Information Technology

0.00 cr

5.00 cr

H-5