Business Intelligence Development Project – BIG4TF023-3001, 5 credit points, Professional studies, Optional
Prerequisites
For this pilot implmentation it is mandatory that students haves passed the BIG4TF023 basic course before student can start this course.
Learning objectives
Upon successful completion of the course, the student
a) understands the value of business driven BI-development
b) is knowledgable of Microsoft SSAS Tabular and SSIS tools/architecture
c) understands the value of supporting business processes by BI-solutions
d) has gained experience in creating a BI-solution by using agile development and market
leading tools to extract data from an ERP system
e) has learned to document the created solution and the process
Course content
- Microsoft SSAS Tabular and SSIS
- Tableau introduction , as a possible architecture for the project
- understanding data structures (ERP) and related business processes (O2C and P2P)
- planning, developing and testing a complete BI-solution based on selected user stories
- documenting and presenting the BI development process and solution
Transition to Non-stop e-learning course
This course will be implemented as follows:
o The course starts on the first week of the second period with an optional introductory, presentation and planning session. Information in Moodle
o This pilot implementation accepts no enrolments after the start session and is open only to students who has passed the basic business intelligence course BIG4TF022.
o The course is setup as an e-learning course. Teacher might assign a time when he will be available in class – if so information will be given in Moodle.
o This is a 8 week course with the possibility to finnish the course in no more than 14 weeks (included also holidays) . This means that all deliverables need to be submitted latest by January 18th 2019 4 pm.
o NOTE! There will be a deadline for when the different modules need to be done and marked as complete. Please check out Moodle for details.
Course setup
The BI Development Project course consists of the following parts:
1. Start-up module
• Presentation and course overview
• Nav 2015 ERP understanding and use with client tool
• Nav 2015 ERP processes – O2C and P2P
• Data input to the ERP system – O2C and P2P
• Module report – pass/fail
2. Module 1A – SSAS Tabular and SSIS
• Microsoft SSAS Tabular with Data from Nav ERP
• Microsoft SSIS with Data from Nav ERP
• Module report – pass/fail
3. Module 1B – Optional Tableau Introduction
• Tableau for Teaching - Student License
• Self-guided learning
• Using Tableau Desktop in HH and with Nav ERP
• Module report – omitted/pass/fail
4. Module 2 - Initiation of Development Project
• Project definition and Frame
• User stories and goals for project
• Relevant Nav ERP data structures
• Testing and preparations for project
• Selection of Architecture and Tools
• Presentation of project – report and (video)
5. Module 3 and 4 – Creating, testing and presenting solution
• Iterations, testing and creating solutions
• Possible interim submissions - for discussions and support
• Final submission of solutions
• Presentation of results – (report) and video
6. Official course feedback and feedback directly to teacher
• In Moodle and Quality system
• Mandatory if grade and credits wanted
Assessment Criteria
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
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
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 a BI-solution
Assessment procedure and setup
To pass this course the student need to
- pass Start-up Module in accordance with the schedule setup for the implementation
- pass Module 1A or Module 1B in accordance with the schedule setup for the implementation
- define, execute and report a developing project individually or as part of a team. (max 3 students)
Requirements linked to grading is discussed in the project definition document.
Re-exams N/A
Course material
Moodlöe materials and reference articels, documents and sites.
Cooperation with the business and other organisations
World leading inetrnational tools used in companies.
Teacher
Ralf Rehn, Pasila
Contact hours: Please contact by e-mail using your myy.haaga-helia account
Recognition of prior learning (RPL)
To get a passing (P) grade and exemption from the course, student must display and demonstrate the competence by certificates from earlier studies or work experience covering the course objectives and contents. It is possible to participate in the competence demonstration only once before taking the course.
You need to contact the teacher latest on the starting date/session of the course if there is a need for an individual approach.
Material, links and videos in Moodle.
Pasila Campus
No exam
English
English tools and material
26.10.2020 - 19.03.2021
15.06.2020 - 05.11.2020
This e-learning course starts with an opttional start-up session on the week starting 22nd of October and all deliverables need to be submitted latest by 18th of January.
Not available for this course.
Ralf Rehn
15 - 30
Evaluation of created BI-solution including reporting and presentation.
BITE Degree Programme in Business Information Technology
1.00 cr
5.00 cr
H-5