Updated 7.10.2021/ Ralf Rehn
Link to pdf document - https://haagahelia-my.sharepoint.com/:b:/g/personal/h00503_haaga-helia_fi/BI002/ER1R-AP-_tJMiQHcnqSR2csBdpLoR-MzWkkSiQCLuo_p8Q
Business Intelligence Development Project – BIG4TF023-3008, 5 credit points, Professional studies, Optional
Prerequisites
1) Student has passed the BIG4TF022 BI-basic course (or BIG4TA022-3011) before student can start this course (Pass).
2) 3008: However also students without BI-Basic can be accepted by showing
necessary skills/knowledge at the immediate start of the course. (NonPass) The test/skills measure cannot be redone and if failed acceptance for this and future courses can only be gained by passing BI-Basic - to be noted places on the course are restricted to number of licenses and is at time of writing - 25
3) students with BI-Basic passed has precedence if timely enrolled
Learning objectives
Upon successful completion of the course, the student
a) understands the value of business driven BI-development
b) is knowledgeable of Microsoft BI Capabilities - SSAS Tabular and SSIS tools/architecture ( Azure AS)
c) understands the value of supporting business processes by BI-solutions
d) has gained experience in creating a qualitative BI-solution by using agile development and market leading tools to extract data from an (ERP) system
e) has learned to document/present the created solution and the process
f) has gained experience in publishing solution in Enterprise/Cloud type of environment
Course content
- Design and good practices in BI development
- Microsoft BI - SSAS Tabular and Microsoft Integration Services, Microsoft Azure
- 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
- 3008: Architecture setup – either of
a) Power BI Desktop - BI Services - SharePoint Power BI web part
(b) Tableau Desktop – Tableau Online (only if and when accepted by teacher))
Course setup - implementation 3008
This course will be implemented as follows:
o The course starts on the first week of the second period. If a start session its informed in Moodle and Whats Going on Section. If and when course is available – it can be started. The course and the project need to be started in accordance with deadlines defined in Moodle.
o 3008: This is setup as a one period course with the possibility to finish the course before semester start 2022. Basically, doing the project for a longer period is well accepted BUT the project period cannot be less than 6 weeks.
o Not applying to course deadlines will affect the grade except for start module and acceptance to course ? removal from course.
o When access to Moodle has been given ? Be sure to check out possible deadlines and instructions in Moodle!
o If the basic course not passed (NonPass) – check carefully instructions and deadlines – no exceptions to deadlines will be granted
o The course is setup as an e-learning course. Teacher might assign a time when he will be available in class/Zoom – if so information will be given in Moodle.
Drop-outs and retake
Due to the number of students enrolling and later dropping out in e-learning courses the following rule will be applied for this and future implementations
* Restart of course is only allowed if you have not finished the Start-up Module
* If Start-up module has been done and you after that are denied access or do not finish ? the course can only be retaken by specific decision of teacher
Course setup – version 3 (October 2021)
The BI Development Project course consists now of the following parts:
1. Course and architecture introduction (all)
• Presentation and course overview
• Infrastructure/Architecture discussion and setup
• About the ERP system
• The new iteration setup
• Grading structure and assessment criteria’s
• Acceptance procedure for NonPass students
• Confirmation of course enrolment for Pass students
2. Pre-Iteration 1 - Start-up (accepted and confirmed)
• Nav 2015 ERP understanding and use with client tool
• Nav 2015 ERP processes – O2C and P2P
• Relevant Nav ERP data structures
• Data input to the ERP system – O2C and P2P
• Project architecture selection, setup and check
3. Pre-Iteration 2 - Initiation of Development Project
• Project definition and Frame
• User stories, goals and requirements for project
• Learnings, testing and preparations for project
• Architecture, definition, tools and timelines
• Presentation of project – report and (video/Zoom)
4. Iterations on Learning modules (partly optional)
• Microsoft SSAS Tabular with Data from Nav ERP/Azure
• Microsoft SSIS with Data from Nav ERP/Azure
• (Azure Analysis Services to be added)
5. Iterations – Creating, testing and presenting solution
• Iterations, testing and creating solutions
• Iterations - for delivery, comments and support
• Final submission of solutions
• Presentation of results – (report) and video
• Please Note: Students can be asked to a contact meeting in
regards to any part or phase of the project
6. Official course feedback and feedback directly to teacher
• In Moodle and Quality system
• Mandatory if grade and credits wanted
Implementation 3008 specifics
This implementation will as main architecture apply Power BI Desktop- BI-Services - SharePoint. This architecture was tested as pilot on 3006 and was successful. 25 Power BI Pro license is reserved for this course. The project can also be done with Tableau Desktop – Tableau Online – secondary architecture – teacher acceptance required.
A more guided approach setup is now applied – as more students expected to do ? streamline and support passing course. You can change the standard setup in your project plan.
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
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.
Re-exams N/A
Course material
Moodle materials and reference articles, documents and sites.
SharePoint support Site and content
Business Intelligence Platform 2021 - NonPass students
Cooperation with the business and other organizations
World leading international tools used in companies.
Teacher
Ralf Rehn, Pasila
Contact hours: Please contact by e-mail using your myy.haaga-helia account only
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.