Fachhochschule Dortmund University of Applied Sciences Data Mining OLAP

Fachhochschule Dortmund University of Applied Sciences Data Mining & OLAP Reporting Phase: Project Acquisition Week 3/2008 – Report 9 Christoph Szczecina Udi Ibarretxe Andoni Albizu Dario Casas Borja Uriarte Fachhochschule Dortmund University of Applied Sciences Budget: Man-Hours 140 120 100 Man Hours 80 60 40 20 0 44 45 46 47 48 49 50 51 52 1 2 3 Planned -10,00% 10,00% Actual Calendar Weeks Fachhochschule Dortmund University of Applied Sciences Since Last Report: Planned vs. Actual • [17] Create Views from the resulting destination table • [18] Use Dimension and Cube Wizard to build a cube from these views • [19] Evaluate and browse this Cube in the Cube Designer • [20] Document processing steps • [24] Build an OLAP Pivot Report using Excel • [25] Document processing steps Fachhochschule Dortmund University of Applied Sciences Progress Overview Fachhochschule Dortmund University of Applied Sciences Gantt Chart Fachhochschule Dortmund University of Applied Sciences Data Warehouse: Cube Design 6 dimensional cube: season, year, agency, destination, income, age Fachhochschule Dortmund University of Applied Sciences Data Warehouse: Importing Tables Fachhochschule Dortmund University of Applied Sciences Data Warehouse: Cube Measures ID for each dimension (key) Fachhochschule Dortmund University of Applied Sciences Data Warehouse: Dimension Usage Fachhochschule Dortmund University of Applied Sciences Data Warehouse: Creating Hierarchies e.g. destination zone has two dimensions itself, country and region Fachhochschule Dortmund University of Applied Sciences OLAP: Testing the Cube Fachhochschule Dortmund University of Applied Sciences OLAP: Results Fachhochschule Dortmund University of Applied Sciences OLAP: Excel connection via pivot Fachhochschule Dortmund University of Applied Sciences OLAP: Testing the connection Fachhochschule Dortmund University of Applied Sciences OLAP: Excel Results Fachhochschule Dortmund University of Applied Sciences OLAP: Excel Table Fachhochschule Dortmund University of Applied Sciences Data Mining: Marketing Considerations • Age class of 35  Observation: Preference for destinations in Asia  Possible offers assuming a superior income: • Dedicated tours with personalized guide • Added value trips • South Agency  Observation: Strong decrease of bookings for Italy, Bulgaria and Malta  Action plan: Review the marketing actions Fachhochschule Dortmund University of Applied Sciences Data Mining: Marketing Considerations • West Agency  Observation: Strong increase of bookings for Italy  Action plan: Check need to increase capacities? Possible advance in price? Fachhochschule Dortmund University of Applied Sciences Deployment • • • • Informative and interesting project Time-related hurdles Team members often on business trips Communication not optimal but finally successful Fachhochschule Dortmund University of Applied Sciences Lessons Learned • Proper reporting     PM must keep members informed about status Different communication skills within the team Regular reports necessary Awareness of cultural differences • Task descriptions  Detailed and certain task descriptions to avoid confusion and time loss  Double-check for proper understanding? Fachhochschule Dortmund University of Applied Sciences Lessons Learned • Time estimation  Needs a lot of experience  Reuse time estimations from former projects  Expert consultation? • Keeping track of motivation  Ask team members about their progress  Ask for troubles concerning tasks  Ask on time Fachhochschule Dortmund University of Applied Sciences ... for your attention! support@kyynel.biz