• BI Academy: http://www.bi-academy.eu
  • Login to the teaching material and hands-ons
  • Login with a name like W18sxxxx / xxxxx
• Game User: http://iis.hdm-server.eu/biagame_u01/login.php
  • set location, employ people, order stock, plan marketing events
  • Login with a name like uxx_fr_1 / uxx_fr_1
• Game Admin: http://iis.hdm-server.eu/biagame_lecturer/login.php
  • open and close game, run stored procedures, get list of student users, view game factors
  • login with uXX_admin / uXX_YYY

• Manage Infrastructure Settings: http://iis.hdm-server.eu/BIA_WP01b/menu.php – be careful
  • create student user names, set database server names
  • Login with username and password you got from us via email
  • Documentation

Introduce the game to the students.

Slides

Create max. 10 teams with 4 students per team.

Assign one of the cities to each team:

• Freiburg
• Heidelberg
• Karlsruhe
• Wiesbaden
• Friedrichshafen
• Darmstadt
• Kaiserslautern
• Ludwigshafen
• Ulm
• Ludwigsburg (for lecturer)

Login to the admin application, get the user names and let the students pick one username and password.

We pass a scissor and the list with the user names around the class. The students cut a line off the paper Old fashion, but it works!

We have created a database for each of your students on our servers.

Let the students login to http://www.bi-academy.eu with username and password from above.

After the login, the students have to set the field BI Game > Enter your City to the city you assigned to a team.

Then, let the students check, if all Hands-Ons are visible.

Slides

The students should work through the guideline BI Serious Game → Create a Business Plan and prepare a 15 min. presentation with 8 slides.

The student can now enter their data in our ERP system. Therefor, the game has to be open so that students can insert data.

Logon to the admin componente and open the BI game for the bookings.

• Game Admin: http://iis.hdm-server.eu/biagame_lecturer/login.php
  • login with uXX_admin / uXX_YYY

• RUN GAME → Run stored procedure: Unlocks the game. Changes allowed

• VIEW GAME → System Messages

The game is now open and the students can enter their data.

The students should work through the guideline BI Serious Game → Hire Staff, Rent Location, Do Marketing, Procure Bicycles .

Next, each student has to create the Data Mart. The data mart contains 4 models:

• Sales Data Mart
• Costs Data Mart
• Stock Data Mart
• Marketing Data Mart

Slides

The students should work through the guideline BI Serious Game → Multidimensional modelling.

Next, you can generate the data for the coming year.

• login to the admin component with the user name uxx_admin / uxx_yyy
• Select RUN GAME > Run Stored Procedures
• Click on the icon left to Generate data for each store. Game will be locked!
• Click on SAVE.
• Select VIEW GAME > View System Message and check, if the stored procedure was successful.

Walk through the Hands-Ons.

• BI Game – Extraction – Transformation – Load

• BI Game – OLAP with Excel (PowerPivot) or BI-Game-Fallback – OLAP (FastTrack)

• login to the admin component. We have send an user name and password per email to you. The user name sounds like u20_admin, the password like u20_123.
• Select RUN GAME > Run Stored Procedures
• Click on the icon left to Unlock Game!
• Click on SAVE.
• Select VIEW GAME > View System Message and check, if the stored procedure was successful.

• Work through the Hands-Ons BI Game – Change your ERP parameter.

Next, you can generate the data for the coming year again.

• login to the admin component. We have send an user name and password per email to you. The user name sounds like u20_admin, the password like u20_123.
• Select RUN GAME > Run Stored Procedures
• Click on the icon left to Generate data for each store. Game will be locked!
• Click on SAVE.
• Select VIEW GAME > View System Message and check, if the stored procedure was successful.

Next, you create a Data Cube that contains the data from all stores.

• BI Game – Create a Data Cube with User Perspectives

• BI-Game: Board Presentation / (Dashboards, Mobile, PowerBI)

• BI Game: Marketing Campaign with Data Mining