2yZV0zDJ

1-- MySQL dump 10.13  Distrib 5.7.25, for Linux (x86_64)
2--
3-- Host: 192.168.0.101    Database: audit
4-- ------------------------------------------------------
5-- Server version	5.5.5-10.3.9-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `abc_challenge`
20--
21
22DROP TABLE IF EXISTS `abc_challenge`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `abc_challenge` (
26  `id` int(11) NOT NULL,
27  `title` varchar(150) DEFAULT NULL,
28  `summary` text DEFAULT NULL,
29  `creation_date` datetime DEFAULT NULL,
30  `published` datetime DEFAULT NULL,
31  `draft` int(11) DEFAULT NULL,
32  `end_date` datetime DEFAULT NULL,
33  `categories` text DEFAULT NULL,
34  `skills` varchar(130) DEFAULT NULL,
35  `company_name` varchar(100) DEFAULT NULL,
36  `company_domain` varchar(100) DEFAULT NULL,
37  `company_country_code` varchar(4) DEFAULT NULL,
38  `md5` varchar(120) DEFAULT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `abc_challenge`
45--
46
47LOCK TABLES `abc_challenge` WRITE;
48/*!40000 ALTER TABLE `abc_challenge` DISABLE KEYS */;
49/*!40000 ALTER TABLE `abc_challenge` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `abc_course`
54--
55
56DROP TABLE IF EXISTS `abc_course`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `abc_course` (
60  `id` int(11) NOT NULL,
61  `id_degree` varchar(20) DEFAULT NULL,
62  `field_studies` varchar(100) DEFAULT NULL,
63  `start_date` datetime DEFAULT NULL,
64  `ending_date` datetime DEFAULT NULL,
65  `summary` text DEFAULT NULL,
66  `categoriess` varchar(200) DEFAULT NULL,
67  `draft` int(11) DEFAULT NULL,
68  `students_countries` varchar(100) DEFAULT NULL,
69  `academy_name` varchar(100) DEFAULT NULL,
70  `academy_domain` varchar(200) DEFAULT NULL,
71  `academy_country_code` varchar(4) DEFAULT NULL,
72  `md5` varchar(120) DEFAULT NULL,
73  PRIMARY KEY (`id`)
74) ENGINE=InnoDB DEFAULT CHARSET=latin1;
75/*!40101 SET character_set_client = @saved_cs_client */;
76
77--
78-- Dumping data for table `abc_course`
79--
80
81LOCK TABLES `abc_course` WRITE;
82/*!40000 ALTER TABLE `abc_course` DISABLE KEYS */;
83INSERT INTO `abc_course` VALUES (204,'Bachelor',NULL,'2019-10-01 00:00:00','2020-01-31 00:00:00','Managing Innovation includes methods for managing the innovation process, and refers to the relationships between innovation strategy and corporate culture. Overcoming contradicting directives in organisations, whose primary focus is efficiency, encountering structural barriers for major innovation','Innovation Management',0,'','University of Southampton','soton.ac.uk','GB','4ddcbf787570e28a5db98f1f7f6f4196'),(220,'Master',NULL,'2019-05-13 00:00:00','2019-08-09 00:00:00','This course is the culmination of the master\'s in applied economics program. Students work in groups to research, report and present their findings from a data analysis of a business problem. They apply the econometric and data analytic skills acquired and developed throughout the graduate program.','Business Data Management & Analysis,Data Modeling & Visualization,Machine Learning',0,'United States,India,China','University of Cincinnati','euc.edu','US','8912c5d4b3788e58f19c283e5be6c3bd'),(224,'Bachelor',NULL,'2019-09-18 00:00:00','2020-01-10 00:00:00','Students will learn the cornerstones of biology and chemistry and contextualize and apply them to the field of environmental engineering using various projects.','Closed-loop supply chain & Remanufacturing,Engineering,Circular Economy,Emerging Technology Evaluation & Management,Energy & Clean-tech',0,'Germany,France','University of Applied Sciences Western Switzerland (HES-SO)','hes-so.ch','CH','d4f62cd92bceea0a2b0e6831a7ab4ea9'),(225,'Master',NULL,'2019-04-26 00:00:00','2019-04-26 00:00:00','The University of Alabama is seeking an engagement with a global company to give students the experience of helping solve real business issues.  The company we seek to work with will have associates available to work with the students as the project moves to completion. Typically the students will engage with the company on a weekly basis to gauge progress and seek assistance in removing barriers to progress. This particular engagement will be completed by April 26, 2019. The headcount of students in a team is four to five.','Accounting & Corporate Finance,Artificial Intelligence,Blockchain,Business Data Management & Analysis,Business Planning & Consulting,Machine Learning,Project & Service Management',0,'United States','University of Alabama','www.ua.edu','US','dc5c5eacdbd765482d3230245ec62240');
84/*!40000 ALTER TABLE `abc_course` ENABLE KEYS */;
85UNLOCK TABLES;
86
87--
88-- Table structure for table `abc_user`
89--
90
91DROP TABLE IF EXISTS `abc_user`;
92/*!40101 SET @saved_cs_client     = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `abc_user` (
95  `id` int(11) NOT NULL,
96  `name` varchar(50) DEFAULT NULL,
97  `lastname` varchar(40) DEFAULT NULL,
98  `id_userprofile` int(11) DEFAULT NULL,
99  `id_company` int(11) DEFAULT NULL,
100  `job_title` varchar(60) DEFAULT NULL,
101  `phone` varchar(15) DEFAULT NULL,
102  `md5` varchar(120) DEFAULT NULL,
103  PRIMARY KEY (`id`)
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105/*!40101 SET character_set_client = @saved_cs_client */;
106
107--
108-- Dumping data for table `abc_user`
109--
110
111LOCK TABLES `abc_user` WRITE;
112/*!40000 ALTER TABLE `abc_user` DISABLE KEYS */;
113/*!40000 ALTER TABLE `abc_user` ENABLE KEYS */;
114UNLOCK TABLES;
115
116--
117-- Table structure for table `category`
118--
119
120DROP TABLE IF EXISTS `category`;
121/*!40101 SET @saved_cs_client     = @@character_set_client */;
122/*!40101 SET character_set_client = utf8 */;
123CREATE TABLE `category` (
124  `id` varchar(20) NOT NULL,
125  `name` varchar(100) DEFAULT NULL,
126  `parent_id` int(11) DEFAULT NULL,
127  `valoration` int(11) DEFAULT NULL,
128  `description` varchar(200) DEFAULT NULL,
129  PRIMARY KEY (`id`)
130) ENGINE=InnoDB DEFAULT CHARSET=utf8;
131/*!40101 SET character_set_client = @saved_cs_client */;
132
133--
134-- Dumping data for table `category`
135--
136
137LOCK TABLES `category` WRITE;
138/*!40000 ALTER TABLE `category` DISABLE KEYS */;
139INSERT INTO `category` VALUES ('CAT-1','Accounting & Corporate Finance',NULL,2,NULL),('CAT-10','Building Information Modeling',NULL,3,NULL),('CAT-11','Business Data Management & Analysis',NULL,5,NULL),('CAT-12','Business Model Innovation',NULL,5,NULL),('CAT-13','Business Planning & Consulting',NULL,4,NULL),('CAT-14','Chemical process optimization',NULL,4,NULL),('CAT-15','Circular Economy',NULL,4,NULL),('CAT-16','Closed-loop supply chain & Remanufacturing',NULL,4,NULL),('CAT-17','Communication & Advertising',NULL,3,NULL),('CAT-18','Consumer Behaviour 4.0',NULL,4,NULL),('CAT-19','Cryptocurrency',NULL,3,NULL),('CAT-2','Aero- / Space Technology',NULL,1,NULL),('CAT-20','Data Modeling & Visualization',NULL,5,NULL),('CAT-21','Decision Support Systems',NULL,4,NULL),('CAT-22','Electric / Hybrid engine',NULL,1,NULL),('CAT-23','Emerging Technology Evaluation & Management',NULL,3,NULL),('CAT-24','Employee Engagement',NULL,2,NULL),('CAT-25','Employer Branding - Acquisition & Retention',NULL,2,NULL),('CAT-26','Energy & Clean-tech',NULL,2,NULL),('CAT-27','Environment & Corporate Social Responsibility',NULL,2,NULL),('CAT-28','Experience & Product Design',NULL,2,NULL),('CAT-29','Forecast - Demand - Inventory',NULL,4,NULL),('CAT-3','App & Platform Development',NULL,4,NULL),('CAT-30','Future of Work',NULL,4,NULL),('CAT-31','Hard- & Software IoT',NULL,3,NULL),('CAT-32','Health & Safety',NULL,2,NULL),('CAT-33','Industry 4.0',NULL,3,NULL),('CAT-34','Innovation Management',NULL,4,NULL),('CAT-35','International Trade & Finances',NULL,2,NULL),('CAT-36','Internationalization & Growth Strategy',NULL,5,NULL),('CAT-37','Law & Tax',NULL,1,NULL),('CAT-38','Learning & Development',NULL,2,NULL),('CAT-39','Logistics & Transportation',NULL,5,NULL),('CAT-4','Artificial Intelligence',NULL,3,NULL),('CAT-40','Machine Learning',NULL,5,NULL),('CAT-41','Media - Gaming - Entertainment',NULL,3,NULL),('CAT-42','New Business Development & Entrepreneurship',NULL,5,NULL),('CAT-43','New Market Entry / New Product Launch',NULL,4,NULL),('CAT-44','New Product / Service Development',NULL,4,NULL),('CAT-45','Operations & Plant simulation',NULL,4,NULL),('CAT-46','Organizational Design',NULL,3,NULL),('CAT-47','Pharmacology Research',NULL,2,NULL),('CAT-48','Procurement',NULL,2,NULL),('CAT-49','Project & Service Management',NULL,2,NULL),('CAT-5','Autonomous vehicles',NULL,1,NULL),('CAT-50','Robotics & Drones',NULL,2,NULL),('CAT-51','Security - Cybersecurity & IT',NULL,3,NULL),('CAT-52','Smart City / Building',NULL,2,NULL),('CAT-53','Social Enterprise / Innovation',NULL,3,NULL),('CAT-54','Strategic / Digital Transformation',NULL,5,NULL),('CAT-55','Supplier Networks',NULL,4,NULL),('CAT-56','Supply Chain Management',NULL,5,NULL),('CAT-57','Sustainable Entrepreneurship',NULL,3,NULL),('CAT-58','Virtual & Augmented',NULL,2,NULL),('CAT-59','Wearables - Materials & Process Design',NULL,2,NULL),('CAT-6','Biostatistics',NULL,2,NULL),('CAT-7','Biotechnical / -medical Engineering',NULL,3,NULL),('CAT-8','Blockchain',NULL,3,NULL),('CAT-9','Brand Management',NULL,3,NULL);
140/*!40000 ALTER TABLE `category` ENABLE KEYS */;
141UNLOCK TABLES;
142
143--
144-- Table structure for table `challenge_audit`
145--
146
147DROP TABLE IF EXISTS `challenge_audit`;
148/*!40101 SET @saved_cs_client     = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `challenge_audit` (
151  `id` varchar(10) NOT NULL,
152  `title` varchar(200) DEFAULT NULL,
153  `summary` text DEFAULT NULL,
154  `description` text DEFAULT NULL,
155  `category_ids` text DEFAULT NULL,
156  `degree_ids` text DEFAULT NULL,
157  `time_constraint_id` text DEFAULT NULL,
158  `geography_ids` text DEFAULT NULL,
159  `solution_ids` text DEFAULT NULL,
160  `created_on` datetime DEFAULT NULL,
161  `updated_on` datetime DEFAULT NULL,
162  `score` varchar(255) DEFAULT NULL,
163  `user_id` varchar(255) DEFAULT NULL,
164  `draft` tinyint(4) DEFAULT 1,
165  PRIMARY KEY (`id`)
166) ENGINE=InnoDB DEFAULT CHARSET=utf8;
167/*!40101 SET character_set_client = @saved_cs_client */;
168
169--
170-- Dumping data for table `challenge_audit`
171--
172
173LOCK TABLES `challenge_audit` WRITE;
174/*!40000 ALTER TABLE `challenge_audit` DISABLE KEYS */;
175INSERT INTO `challenge_audit` VALUES ('ca-5c81242','asdfasdfasdf','asfdasdfasdfasdfasdfasdfasf','sadfasdfasdfjklhalkjsfdalsgjaks','CAT-4,CAT-28,CAT-27,CAT-26,CAT-25','DEG-3,DEG-1,DEG-2','TIME-3','GEO-3,GEO-5,GEO-9,GEO-10','SOL-1,SOL-7,SOL-5,SOL-3','2019-03-07 00:00:00','2019-03-07 00:00:00','0','u-5c812424',1),('nuevo','Gerard','Costras','Amigos de las costras','CAT-6,CAT-8,CAT-7,CAT-23,CAT-22','DEG-3,DEG-1,DEG-2','TIME-2','GEO-1,GEO-2,GEO-3,GEO-5','SOL-1,SOL-7,SOL-5,SOL-3','2019-03-07 00:00:00','2019-03-07 00:00:00','0','u-5c812424',1),('pepeJeans','Oscar','Costras','Description example','CAT-6,CAT-8,CAT-7,CAT-23,CAT-22','DEG-3,DEG-1,DEG-2','TIME-2','GEO-1,GEO-2,GEO-3,GEO-5','SOL-1,SOL-7,SOL-5,SOL-3','2019-03-07 00:00:00','2019-03-07 00:00:00','0','u-5c812424',1);
176/*!40000 ALTER TABLE `challenge_audit` ENABLE KEYS */;
177UNLOCK TABLES;
178
179--
180-- Table structure for table `challenge_audit_old`
181--
182
183DROP TABLE IF EXISTS `challenge_audit_old`;
184/*!40101 SET @saved_cs_client     = @@character_set_client */;
185/*!40101 SET character_set_client = utf8 */;
186CREATE TABLE `challenge_audit_old` (
187  `id` int(11) NOT NULL AUTO_INCREMENT,
188  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
189  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
190  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
191  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
192  `country_name` varchar(120) COLLATE utf8_unicode_ci NOT NULL,
193  `website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
194  `challenge_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
195  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
196  `categories` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
197  `geography` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
198  `degree` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
199  `expected_outcome` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
200  `time_constraints` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
201  `rate` float NOT NULL,
202  `date` date NOT NULL,
203  PRIMARY KEY (`id`)
204) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
205/*!40101 SET character_set_client = @saved_cs_client */;
206
207--
208-- Dumping data for table `challenge_audit_old`
209--
210
211LOCK TABLES `challenge_audit_old` WRITE;
212/*!40000 ALTER TABLE `challenge_audit_old` DISABLE KEYS */;
213INSERT INTO `challenge_audit_old` VALUES (82,'ABIS - The Academy of Business in Society','ABIS - The Academy of Business in Society','marco.matrisciano@abis-global.org','025392908','Belgium (België)','https://www.abis-global.org/','Value Proposition ','lorem ipsum','Environment & Corporate Social Responsibility','Europe','Master','Analysis','Within 6-12 months',81,'2018-10-23'),(83,'Gisela ','HEB','gisela_cante@hotmail.com','0442222124702','United States','www.heb.com','Retail','Se requiere optimizar los tiempos en línea','New Product / Service Development','Global,North America','Bachelor,Master','Ideation','Anytime',74.5,'2018-10-16'),(93,'Tim Denley','spark44','timd@spark44.com','85982214','United Kingdom','','Brand perception ','Change the brand perception of a Automotive brand that is perpetually viewed as a vehicle for old men.','Innovation Management','Global','Master','Ideation','Within 3 months',80,'2018-10-25'),(100,'Lukas Krondorf','Enry AS','Lukas@Enry.com','+4740596036','Norway (Norge)','www.Enry.com','Eria ChatBot','Eria (phonetic pronunciation of the word \\\"area\\\") is a so-called \\\"serious game\\\". It will increase awareness sorrounding privacy while fostering cooperation in teams.\r\nThe game is made for students, especially those new at campus to get to know people a','Media - Gaming - Entertainment,Learning & Development,Social Enterprise / Innovation,Environment & Corporate Social Responsibility','North America,Europe,China','Bachelor,Master','Prototypes,Minimal Viable Products','Within 0-6 months',56.5,'2018-10-29'),(101,'Volker Brendel','Ryde GmbH, Ryde LLC','volker.brendel@kodakone.com','+491734984705','Germany (Deutschland)','http://www.kodakone.com','KODAKOne - Digital Image Rights Management Platform on the Blockchain','KODAKOne is a revolutionary new digital rights management and protection platform secured in the blockchain that seamlessly registers, manages and monetizes digital assets for the image community. In the current unregulated media landscape, people are not','Strategic / Digital Transformation,Business Model Innovation,New Product / Service Development,Brand Management,Cryptocurrency,Blockchain,Machine Learning,Artificial Intelligence','Global,North America,Europe,China,South East Asia','Master,MBA','Concepts,Analysis,Ideation,Feasibility Studies,Prototypes,Experimental Tests,Minimal Viable Products','Within 6-12 months',77.9,'2018-10-31'),(102,'Muhammad Uzair','Venzaar Private Limited','coo@venzaar.com','+923160001266','Pakistan (‫پاکستان‬‎)','','Brain Reprogramming','I felt the need to completely change the way people think and carryout the work. Currently learning environment tends to limit or bound once true potential. Currently i am working on a project of mine to change this perception. ','New Business Development & Entrepreneurship,Internationalization & Growth Strategy,Logistics & Transportation,Social Enterprise / Innovation','Global','Bachelor','Concepts,Ideation','Anytime',78,'2018-10-31'),(103,'Martin Naedele','ABB','martin.naedele@ch.abb.com','+34932204551','Spain (España)','','SW quality','Achieve lower defect injection in a globally distributed SW development team. ','New Product / Service Development,Learning & Development,Experience & Product Design,App & Platform Development','Europe','MBA,PhD','Concepts,Ideation,Feasibility Studies,Experimental Tests','Within 0-6 months',68,'2018-11-01'),(104,'Martin Naedele','ABB','martin.naedele@ch.abb.com','+34932204551','Spain (España)','','Shorten electronics development time','How to reduce the development time of a new electronics board from 12 months to 3 months. \r\nOutcome: process, validated in prototype','New Product / Service Development,Organizational Design,Hard- & Software IoT','Europe','Master','Concepts,Analysis,Feasibility Studies,Prototypes,Experimental Tests','Within 3-9 months',73.9333,'2018-11-01'),(105,'Franziskus Büscher','stadtMUCke e.V.','franziskus.buescher@stadtmucke.de','+491756111379','Germany (Deutschland)','www.stadtmucke.de','stadtMUCke - We are looking for the song for your city!','We want everyone living in Munich to feel at home.\r\n\r\nFor us, only music has the power to let Munich become a city of diversity, engagement, full of ideas and opportunities and even more hip and cool. Music is the language that unites, that is understood ','Communication & Advertising,Brand Management','Europe','Bachelor,Master,MBA,PhD','Concepts,Ideation','Within 3 months',72,'2018-11-02'),(106,'Robin Attinkara','derSalvador LLC ','robin.attinkara@brokerme.club','+41763077833','Switzerland (Schweiz)','https://brokerme.club/en/about-us/','Automated skills assessment','Motivation: \r\nWe are IT freelancers who provide a platform for freelancers with the suitable project offers (https://brokerme.club/en/about-us/).\r\n\r\nObjective:\r\nAs an additional feature we are trying to implement an automated assessment step for the freel','Machine Learning,Artificial Intelligence','Global','Master','Prototypes,Experimental Tests,Minimal Viable Products','Within 3-9 months',69.3333,'2018-11-04'),(107,'Michael Dowden','FlexePark','michael@flexepark.com','+13174556550','United States','https://flexepark.com/','Parking Enforcement','Our company created a pay-to-park app that allows local business owners to “sell”  their unused parking spaces for a flat rate between specified hours, payable via mobile device. The available spaces are marked with branded signs that clearly explain ','Business Model Innovation,Smart City / Building,Experience & Product Design,App & Platform Development','North America','Bachelor,MBA','Concepts,Analysis,Feasibility Studies','Within 0-6 months',74.6667,'2018-11-07'),(108,'test','test','i99716@nwytg.net','+905444546756','Turkey (Turkiye)','sf','k','s','Strategic / Digital Transformation,New Business Development & Entrepreneurship,Business Model Innovation,Innovation Management','Europe','Bachelor,Master,MBA,PhD','Concepts,Analysis,Ideation,Reports,Feasibility Studies,Prototypes,Experimental Tests,Minimal Viable Products','Within 0-6 months',75.125,'2018-11-08'),(109,'timd@spark44.com','Spark44','timd@spark44.com','+6585982214','Singapore','','New way to buy vehicles','Increasingly young urbanites no longer want to own a vehicle in the traditional sense. As an automotive company how can we shift our existing business model to meet their needs?','Business Model Innovation,Innovation Management','Global,China,South East Asia','Master','Concepts,Analysis,Ideation','Within 0-6 months',82,'2018-11-12'),(110,'Maheshkumar Shah','ACL','mahesh.shah@ambujacement.com','+919879605111','India (भारत)','','MS ','Unable to develop interest.\r\nEffective PowerPoint Presentation','Strategic / Digital Transformation','South East Asia','MBA','Analysis','Within 0-6 months',80,'2018-11-21'),(111,'Guillermo Ubeda','Guillermo Ubeda (consultancy)','gubedap@gmail.com','+34664761499','Spain (España)','','Business Model for Ecommerce SaaS in Spain based on Canvas','I encourage you to draw a canvas about an Ecommerce SaaS solution for the SME Spanish market.','Business Model Innovation,International Trade & Finances,Supplier Networks,Experience & Product Design','Europe','Master,MBA','Minimal Viable Products','Within 0-6 months',56,'2018-11-22'),(112,'David Perez','myeasylog.com','David.Perez@easylog.es','+34682262296','Spain (España)','myeasylog.com','easylog & go','Create a disruptive approach to help little companies and e-commerce companies to manage its logistics challenges in a SaaS mode.\r\n It will be the IKEA of logistics management. A full business plan and software solution creation  is needed.  It will be a ','Strategic / Digital Transformation,New Business Development & Entrepreneurship,Business Model Innovation,New Product / Service Development,Procurement,Logistics & Transportation,Experience & Product Design','Global','Bachelor,Master,MBA,PhD','Minimal Viable Products','Within 3 months',58,'2018-11-22'),(113,'Nelson Valderrama','Intuilize','nelson@intuilize.com','+13104080027','United States','intuilize.com','Best-fit model for Industrial distributors (B2B)','Our goal is to have a replicable process/system to segment customers and products for Industrial Distributors (B2B) using the transactional data (sales, quotes, inventory) from their ERP.  \r\nWe want the selected “Telanto” academy team to run clusterin','Industry 4.0','Global','MBA,PhD','Analysis,Prototypes','Within 3 months',67,'2018-11-26'),(114,'anabell','telanto','timo@telanto.com','+34622720888','Spain (España)','','Anabell telanto challenge','Anabell telanto challengeAnabell telanto challengeAnabell telanto challengeAnabell telanto challengeAnabell telanto challenge','Strategic / Digital Transformation,Business Planning & Consulting,Employee Engagement,Biostatistics','Middle East,Oceania','Master','Concepts,Analysis,Feasibility Studies','Within 0-6 months',74.1667,'2018-12-10'),(115,'Tony  Maffeo','HS Spindles, LLC','engineering@hsspindles.com','+17143072332','United States','hsspindles.com','Test','new hires, training','New Business Development & Entrepreneurship,Business Planning & Consulting,Communication & Advertising,Organizational Design','North America','Master','Concepts','Anytime',72,'2018-12-24'),(116,'timd@spark44.com','Spark44','timd@spark44.com','+6585982214','Singapore','','Automotive Mobility in Smart Cities','Modern Asian cities are imposing ever more restrictive policies on private vehicle ownership due to congestion and overcrowding. In some cases vehicles from other regions are even not allowed to enter the city.\r\nIn this context develop a strategy that lev','New Business Development & Entrepreneurship','China,South East Asia','Master','Concepts,Minimal Viable Products','Within 0-6 months',71.5,'2019-01-14'),(117,'Adam Gadway','INFICON','adam.gadway@inficon.com','+13154341100','United States','','Optimal Replenishment System Settings','Use demand data to optimize reorder point replenishment system - ensuring 99% part availability accounting for demand distribution and fluctuation','Business Model Innovation,Business Planning & Consulting,Logistics & Transportation,Closed-loop supply chain & Remanufacturing,Forecast - Demand - Inventory,Supply Chain Management,Operations & Plant simulation','North America,Europe','Bachelor,Master,MBA','Analysis','Within 3-9 months',86.0476,'2019-01-16'),(118,'Fernando Recuerp Pita','Meermin 1951 S.L.','frecuero@meermin.es','+34695792048','Spain (España)','www.meermin.es','Supply Chain Optimization','We would have an optized program for our Supply Chain','Logistics & Transportation,Forecast - Demand - Inventory,Supply Chain Management','Global','Bachelor,Master,MBA,PhD,Vocational Training (Spain only)','Analysis,Feasibility Studies,Experimental Tests','Anytime',67.3333,'2019-01-17'),(119,'Timo','TELANTO','timo@telanto.com','+34622720888','Spain (España)','','Event Challenge','need to setup an event in no time with max impact on revenue','New Business Development & Entrepreneurship,Internationalization & Growth Strategy,Communication & Advertising,Brand Management','Global','Master,MBA','Concepts','Within 0-6 months',83,'2019-01-30'),(120,'MARIA CADAVAL','ABARCA COMPANHIA DE SEGUROS SA','MCADAVAL@ABARCASEGUROS.COM','+34602253519','Spain (España)','','making a company attractive to costumers','we need to make a presentation of our company, attractive to potential clients. The presentation have to put in value the benefits of our company.','New Business Development & Entrepreneurship,New Product / Service Development,Communication & Advertising,Brand Management,Organizational Design,International Trade & Finances','Global','Bachelor,Master,MBA,PhD','Concepts,Analysis,Ideation,Reports','Within 3 months',76.3333,'2019-01-31'),(121,'Vin','Vinfast','timo@telanto.com','+34622720888','Spain (España)','vinfast.com','Vinfast Market Entry Challenge','Vinfast Market Entry Challenge for Germany. Product is electric motocycle. Require a market analysis, launch plan and so forth','New Business Development & Entrepreneurship,Business Planning & Consulting,Internationalization & Growth Strategy,New Market Entry / New Product Launch','Europe','Master,MBA','Concepts,Analysis','Within 0-6 months',82,'2019-02-04'),(122,'Eduardo Delgado','Roams Tic SL','eduardo.delgado@roams.es','+34684221687','Spain (España)','roams.es','Roams will be international','Roams wants to select a country market to expand his service (search engine of phone and internet servicies).\r\nWe need to explore the world to take information about competitors, phone carriers, affiliates programs of phone and internet servicies and lega','Business Planning & Consulting','Global','MBA','Analysis','Within 3-9 months',86,'2019-02-05');
214/*!40000 ALTER TABLE `challenge_audit_old` ENABLE KEYS */;
215UNLOCK TABLES;
216
217--
218-- Table structure for table `degree`
219--
220
221DROP TABLE IF EXISTS `degree`;
222/*!40101 SET @saved_cs_client     = @@character_set_client */;
223/*!40101 SET character_set_client = utf8 */;
224CREATE TABLE `degree` (
225  `id` varchar(20) NOT NULL,
226  `name` varchar(100) DEFAULT NULL,
227  `description` varchar(200) DEFAULT NULL,
228  `valoration` int(11) DEFAULT NULL,
229  PRIMARY KEY (`id`)
230) ENGINE=InnoDB DEFAULT CHARSET=utf8;
231/*!40101 SET character_set_client = @saved_cs_client */;
232
233--
234-- Dumping data for table `degree`
235--
236
237LOCK TABLES `degree` WRITE;
238/*!40000 ALTER TABLE `degree` DISABLE KEYS */;
239INSERT INTO `degree` VALUES ('DEG-1','Bachelor','',5),('DEG-2','Master','',5),('DEG-3','MBA','',4),('DEG-4','PhD','',4),('DEG-5','Vocational Training (Spain only)','',2);
240/*!40000 ALTER TABLE `degree` ENABLE KEYS */;
241UNLOCK TABLES;
242
243--
244-- Table structure for table `geography`
245--
246
247DROP TABLE IF EXISTS `geography`;
248/*!40101 SET @saved_cs_client     = @@character_set_client */;
249/*!40101 SET character_set_client = utf8 */;
250CREATE TABLE `geography` (
251  `id` varchar(20) NOT NULL,
252  `name` varchar(100) DEFAULT NULL,
253  `description` varchar(200) DEFAULT NULL,
254  `valoration` int(11) DEFAULT NULL,
255  PRIMARY KEY (`id`)
256) ENGINE=InnoDB DEFAULT CHARSET=utf8;
257/*!40101 SET character_set_client = @saved_cs_client */;
258
259--
260-- Dumping data for table `geography`
261--
262
263LOCK TABLES `geography` WRITE;
264/*!40000 ALTER TABLE `geography` DISABLE KEYS */;
265INSERT INTO `geography` VALUES ('GEO-1','Global','',5),('GEO-10','India','',1),('GEO-2','North America','',4),('GEO-3','Europe','',4),('GEO-4','Middle East','',4),('GEO-5','China','',3),('GEO-6','South East Asia','',3),('GEO-7','Oceania','',3),('GEO-8','South America','',2),('GEO-9','Africa','',1);
266/*!40000 ALTER TABLE `geography` ENABLE KEYS */;
267UNLOCK TABLES;
268
269--
270-- Table structure for table `solution`
271--
272
273DROP TABLE IF EXISTS `solution`;
274/*!40101 SET @saved_cs_client     = @@character_set_client */;
275/*!40101 SET character_set_client = utf8 */;
276CREATE TABLE `solution` (
277  `id` varchar(20) NOT NULL,
278  `name` varchar(100) DEFAULT NULL,
279  `description` varchar(200) DEFAULT NULL,
280  `value` int(2) DEFAULT NULL,
281  PRIMARY KEY (`id`)
282) ENGINE=InnoDB DEFAULT CHARSET=utf8;
283/*!40101 SET character_set_client = @saved_cs_client */;
284
285--
286-- Dumping data for table `solution`
287--
288
289LOCK TABLES `solution` WRITE;
290/*!40000 ALTER TABLE `solution` DISABLE KEYS */;
291INSERT INTO `solution` VALUES ('SOL-1','Concepts','',5),('SOL-10','Within 3-9 months','',3),('SOL-11','Within 0-6 months','',2),('SOL-12','Within 3 months','',1),('SOL-2','Analysis','',5),('SOL-3','Ideation','',5),('SOL-4','Reports','',5),('SOL-5','Feasibility Studies','',4),('SOL-6','Prototypes','',3),('SOL-7','Experimental Tests','',2),('SOL-8','Minimal Viable Products','',2),('SOL-9','Within 6-12 months','',4);
292/*!40000 ALTER TABLE `solution` ENABLE KEYS */;
293UNLOCK TABLES;
294
295--
296-- Table structure for table `temp_challenge`
297--
298
299DROP TABLE IF EXISTS `temp_challenge`;
300/*!40101 SET @saved_cs_client     = @@character_set_client */;
301/*!40101 SET character_set_client = utf8 */;
302CREATE TABLE `temp_challenge` (
303  `id` int(11) NOT NULL,
304  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
305  `summary` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
306  `creation_date` datetime DEFAULT NULL,
307  `published` datetime DEFAULT NULL,
308  `draft` int(11) DEFAULT NULL,
309  `end_date` datetime DEFAULT NULL,
310  `categories` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
311  `skills` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
312  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
313  `company_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
314  `company_country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
315  `md5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
316) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
317/*!40101 SET character_set_client = @saved_cs_client */;
318
319--
320-- Dumping data for table `temp_challenge`
321--
322
323LOCK TABLES `temp_challenge` WRITE;
324/*!40000 ALTER TABLE `temp_challenge` DISABLE KEYS */;
325INSERT INTO `temp_challenge` VALUES (204,'How to overcome Challenges for a Freight Manager in the temp. controlled Transport Industry','As a Freight Manager (without own assets) in the Temperature Controlled Transport Industry (Food/Pharma/etc.) we are confronted with multiple challenges such as an commoditized market, customer driven market, mega trends in our industry, ecologic mindset changes, automation,  etc.. In the light of these changes of the market conditions  for our customers and for us, we wonder if there is a future for our Business Model (Freight Manager without own assets). Hence we are seeking for the answer, what we have to do to continue our growth path in terms of the right business model in order to be ready for the upcoming changes. I.e. we look for an answer what our \"Business models of the future\" should be in terms of: \na.	Vertical/horizontal integration\nb.	Org design\nc.	Processes \nd.	Systems\ne.	Products \nf.	Etc.\n\nIn order to continuously provide a value add to our customers.\nWe are looking for an advise how we will have to \"reinvent\" or \"innovate\" ourselves over the next say 10 years as the right response to the b.m. challenges.','2017-01-18 16:32:05','2017-01-18 17:14:17',0,NULL,NULL,'Customer Service','STI Freight Management GmbH','','DE','639589b57443a2503fa96f89c11757d0'),(205,'Developing a new business model for growing leafy vegetables in a complete closed environment','There is a new way of growing vegetables for city indoor farms. It offers an integrated product concept which needs an alternative business/earning model. Since our current business model is based on selling and producing vegetable seeds we would like to explore various models in order to find the best strategy for introduction of this product concept. We are willing to explain the business case in Barcelona in more detail. ','2017-01-18 16:50:19','2017-01-18 17:14:06',0,NULL,NULL,'Business Analytics','Rijk Zwaan','','NL','d52864d9ed3bd5f827eddc99919863f8'),(206,'Transforming Graphics Print Business Model from Transactional to B4B','Our Graphics Solutions Services business is a traditional HW Technology company, selling and differentiating mostly on the value of the HW (speeds and feeds).  There are two key drivers for why this model will be difficult to continue over the next 5-10 years, is 1) we are moving into applications such as Corrugated Packaging, where customers will expect a solution from HP (pre-press/post-press equipment, workflow, and integration), not just the press, and 2) Technology industry transformation, led by new models such as Cloud and Consumption based business models, will possibly dictate a different business model also for Graphics; an Outcome based model. \nThe objective of the challenge is to create a B4B business model for the Industrial graphics print business, and define the key areas requiring transformation from the current business model.  The benchmark will be against a cross section of businesses that have transformed from transactional to a B4B business model.','2017-01-18 16:52:58','2017-01-18 17:13:44',0,NULL,NULL,'Business Analytics','HP Inc / Graphics Solutions Business','','US','9eee28bf04b679e498b21707f45d72fd'),(207,'Build a long term winning business model in Pet Specialist in Northern Region ','Pet Food is worth 3.5Bio eur across the Region and has been growing low single digit overall. The market is split in 55% Grocery vs. 45% Pet Specialist/E-commerce which is where we believe the key growth is in the next 10 years.\n\nPurina is one of the TOP2 players in the market with very strong presence in the traditional Grocery sector (circa 30%) but have significant reduced ability to win and has been losing relevance in Specialist due to significant increase in small and more agility competitors entering in new market segments.\n\nOur challenge is to build a model that will game change the market in the next 10 years.','2017-01-18 17:05:58','2017-01-18 17:13:34',0,NULL,NULL,'Business Analytics','Nestle Purina ','','GB','12cc72f9e9a427db99567c0e9f1dbc65'),(208,'Circular business model Challenge - Embedding the circular economy in future business models ','Businesses aim to grow whilst having to deal with increasingly scarce resources. This triggers innovation: from traditional ‘take – make – waste’ production methods to circular methods based on ‘reduce – reuse – recycle’. This new way of doing business is called ‘the circular economy’. The circular economy is impacting the future business models of corporates. ABN AMRO aims to take an active role in facilitating the transition towards a circular economy, guided by our in-depth sector expertise. This requires new banking solutions. Therefore, Corporate Banking will also need to renew its business model. As part of the ‘Circular business model Challenge’ you will play a key role in thinking up circular business models for corporates and for ABN AMRO as its corporate banking partner. Your focus will be on the manufacturing sector where we expect most impact. You will work on the following challenging questions: • How can corporates in the manufacturing sector generate financial and social value by applying circular business models in their value chain? • What circular business models are most feasible? What models create most value? • How do circular business models in the manufacturing sector impact banks? What business model innovation will be required in corporate banking? These questions are described in more detail below (section Description). We have high expectations of your ingenuity, creativity and business model expertise. In addition, you will have access to ABN AMRO’s banking, sector and sustainability experts as well as to selected corporates. An excellent basis to jointly get to actionable results. Our senior management will be delighted to hear your ideas. Are you in? ','2017-01-22 13:17:10','2017-01-22 13:17:17',0,NULL,NULL,'Critical thinking / problem-solving','ABN AMRO','','NL','4c9e96447319c2c9dc09d6a03d25b9e3'),(209,'Designing digital-first business model for Direct Selling company','How to successfully replicate & scale “human-based” Avon business in the online world? Avon is the leader in Beauty direct selling industry, with ~6bn$ annual sales across Latin America, Europe, Middle East, Africa and Asia/Pacific. Its products include well-recognized and beloved brands, sold through nearly 8 million active independent Avon Sales Representatives who serve around 80 million Customers globally. Current business model is almost entirely based on Representatives activity who operate within their neighborhoods, workplaces or communities. Majority of Rep activities is taking place in real world: they sell Avon by giving away the paper brochure (catalogue), collecting Consumer orders to finally have products shipped from Avon which they distribute to their Consumers. Given “digitization” trends worldwide (sharing economy, social media, ecommerce growth etc), Avon recognizes the viability risk of the current “offline” model and aims to leverage those trends to design a brand new business model. Today Avon has 8 million Representatives. However, health of the business & growth broadly depends on bringing new ones to the game. The new model needs to be attractive enough to make them excited, but ultimately – loyal and willing to actively sell Avon for more than just few catalogues in a year. Currently we think that the new ideal business model should: - enable Avon Reps to operate within broadly understood digital space and help them to scale their businesses to much larger extent & much faster vs in real world. - allow Reps to run their selling businesses “from a device” i.e. with much less of their personal effort and physical activity - be incremental to the existing one & minimize any conflicts, while allowing both new & current Avon Reps to respectively join or convert to the new model - allow Avon to ongoingly innovate or iterate it, along with marketplace changes and new Consumer behaviors / trends emerging - create provide new value proposition to end Consumers - and all of above should scale across various continents and markets… But are we right…? In order to answer this question and make a major leapfrog from today, the company took it really seriously... Understanding magnitude of change, its fundamental impact on the company and the fact it is deeply touching everything what Avon does, Executive Committee ensured direct sponsorship of the initiative. As a result, company created a new “Global Social Selling” team that consist of top talents from within and externally recruited experts & high-potentials. Social Selling team is already set up and has started to work – but given early stages, we are in a good position to adjust or even disrupt our thinking with your ideas. You have absolute freedom of thinking and mandate to challenge everything you read here or what you will discover or learn from us later on. We expect fresh ideas, out-of-the-box perspective and unconstrained approach. In exchange, we offer unique opportunity to work with selected senior members of Global Social Selling and Avon Spain teams – we hope it will create a great mutual learning opportunity! Moreover, Social Selling team is set up almost as a corporate start-up. We are all passionate about experimentation, testing, Lean Start-Up, Agile methods – you name it. So if you like to see your ideas materializing not only on dozen of PowerPoint slides, you have met the right people. If possible, we are keen to deploy a test of your proposal in a real world… and we will see how it works! As said earlier, magnitude of change is probably the biggest ever in Avon history. It is not about innovating a product line or redesigning single business unit… It is about disrupting and reinventing the whole company for the 22nd century, by applying core strengths of our brand in the new, digitized world. Join us! ','2017-01-22 12:00:21','2017-01-22 13:17:20',0,NULL,NULL,'Critical thinking / problem-solving','Avon Cosmetics','','PL','18ab3b4f80f2b44128db026e65244fe8'),(210,'IN-CAR ENTERTAIMENT, CONTENT & LEISURE SERVICES ','SEAT the Spanish manufacturer car brand of the Volkswagen group, wants to become the leader of the car connected services. SEAT it’s developing an integral strategy that consist of building a services ecosystem around the car to make \"the car more than a car\". SEAT connected services are developed in 3 different layers: mobility services, convenience services and content, entertainment and leisure services. This challenge focuses in the third layer of the services ecosystem, content, entertainment and leisure services. The brand wants to provide leisure services to transform the time invested to move to one point to another in order to add more value to customer\'s displacements. ','2017-01-22 23:34:36','2017-01-22 23:39:43',0,NULL,NULL,'Critical thinking / problem-solving','SEAT, S.A.','','ES','a0595f623f6ea9fbe51856b6e3e79433'),(214,'Blackboard Integration','Connect Telanto with Blackboard in order to send or receive information such as grades, user information, deliverables, etc. They have their own API and a community of developers','2017-01-26 10:49:14','2017-01-26 11:20:37',0,NULL,NULL,'Collaboration,Communication,Creativity','TELANTO - The Global Academic Business Network','','ES','0dd028f66140b8e52f5dd08e6159db17'),(215,'Student Employability through challenge-based education','The Global Future of Work Foundation is a Non Profit Organisation and aims to help business and governments around the globe to prepare the workforce of the future for a sustainable world by detecting and predicting trends and paradigms for successful transformation. The Student Employability and Employer Branding Challenge is centred around the concept of Action learning or challenge-based education in which students solve corporate challenges and corporate companies can start to explore challenge-base recruiting practices that help retire traditional selection and recruiting processes. ','2017-01-27 12:22:45','2017-01-27 14:54:47',0,NULL,NULL,'Curiosity,Social and cultural awareness,Creativity','Global Future Of Work Foundation','','ES','b38cf320ea56cdcbf1e8620a9bb4a2d6'),(216,'Is the global start-up community a new market for sales outsourcing?','We are a German sales outsourcer with 600 employees in a number of European cities and €20M in annual revenue. We offer large telecommunication and technology organisations qualified sales-teams to support their marketing & sales activities. The range of services is divers from lead-generation, lead qualification and deal-closing activities. Today, we are experiencing flat growth and are exploring new avenues to grow. Since the global start-up community is growing exponentially and a global phenomena. We think that this market could be an extraordinary target for us to provide our experience and support.\n','2017-01-27 12:50:31','2017-01-27 14:54:58',0,NULL,NULL,'Adaptability,Collaboration,Leadership','AXIVAS GmbH','','DE','9794fe65001fe37dfb2b5ea1ae9e18a9'),(217,'EN: Précis of Customer Sweetspots under special consideration of SMART HOME','Die \"Challenge\" besteht im Wesentlichen aus der quantitativen Definition von Kundengruppen (Place) und der Generierung qualitativer Vorschläge zu deren marketingtechnischen Behandlung (Price, Product Promotion) unter besonderer Berücksichtigung von SMART HOME','2017-01-27 16:06:32','2017-01-27 16:21:26',0,NULL,NULL,'Collaboration','Conrad Electronic SE','','DE','c819315cb0a989fc7fff1c3887590a99'),(218,'DE: Précis of Customer Sweetspots under special consideration of SMART HOME','Die \"Challenge\" besteht im Wesentlichen aus der quantitativen Definition von Kundengruppen (Place) und der Generierung qualitativer Vorschläge zu deren marketingtechnischen Behandlung (Price, Product Promotion) unter besonderer Berücksichtigung von SMART HOME','2017-01-27 16:56:32','2017-01-27 16:58:05',0,NULL,'Business Development,Consulting,Marketing,Sales','Collaboration,Curiosity,Critical thinking / problem-solving','Conrad Electronic SE','','DE','e2d7d237dc82443bcc048408b46cf0b3'),(219,'autobooker.com’s mid-term European expansion opportunities','Autobooker.com is a car rental price comparison internet booking engine (IBE). In 2016, it was launched successfully in the German travel industry marketplace as a B2B2C IBE. In 2017, autobooker.com will expand into the mother company’s (Sunny Cars) core source markets Netherlands, Belgium, Luxemburg, Austria and Switzerland. From 2018 until 2020 it is intended to expand into additional European source markets. Shortlisted are: Sweden & Denmark, France & Italy, UK & Ireland.','2017-01-27 18:01:18','2017-01-27 18:05:52',0,NULL,'','Critical thinking / problem-solving','autobooker.com','','DE','fb3efb0df66f487382cc5024e66056d0'),(221,'Identify top three Asian markets for Industrial Internet of Things business, short term','Nexiona has a software framework for building platforms and applications for the Industrial Internet of Things. Our headquarters is in Barcelona and with the speed of current business we are expanding rapidly with one office already in the UK, plans for one in Paris, Munich and Tampa. We have limited knowledge of the state of Internet of Things business in Asia and would like to find out which markets, in the short term (2017/2018), offer the best prospects for doing business. Analysis and recommendations from this project would influence our choice of country in which to open an office to start to grow our business in Asia. ','2017-02-01 11:50:49','2017-02-01 11:53:07',0,NULL,NULL,'Collaboration,Initiative,Critical thinking / problem-solving','NEXIONA','','ES','24c9f3d3d805e820f6fb87549587c4a7'),(224,'New Business Models for MEDIKTOR','MEDIKTOR is a AI based medical device for online triage, pre-diagnose and support to decision making. Our key clients are Health Insurance Companies and Hospitals as a withe label technology embedded in our clients\' current technologies. ','2017-02-08 14:02:05','2017-02-08 14:02:33',0,NULL,'','Adaptability','Mediktor ','','ES','383da2e460946b7d023f7777d2614724'),(226,'Digital Marketing for Financial Services','The challenge is meant to develop a concrete Digital Marketing program for a customer segment for a Spanish Bank. The current Bank’s Marketing set-up and commercial strategy is still strongly physical and related to the current customer scenarios. \n\nThe Bank wants to grow into younger and wider customer segments. It is currently running a strategic transformation program, that will enable the bank by 2017, to be a complete digital bank without any physical transactions.','2017-02-12 18:18:02','2017-02-12 18:25:06',0,NULL,'','Critical thinking / problem-solving','Arquia Banca','','ES','63cba6f4188e3c1b1823c24f49ff8366'),(227,'Communication Strategy for Edu-Tech Start-Up','TELANTO is an Edu-Tech Start-Up in its initial growth phase in need of a state-of-the-art, yet outstanding communication strategy with focus on low/no cost measures, such as Public Relations, potentially Social Media. \nTELANTO, as the operator of the \"Academic Business Network\" serves to multiple stakeholders (University staff, academic staff, students, company representatives in HR and other LoBs), making the communication strategy a challenge to address different needs in few key messages!','2017-02-12 18:27:30','2017-02-12 18:34:30',0,NULL,'','Critical thinking / problem-solving','TELANTO - The Global Academic Business Network','','ES','a6b24c7a46b99bc1bb10b4bbebcf6594'),(228,'Support to Multiple Biomarkers Disease Activity Algorithms (MBDAA) launch strategy: HEOR','\"Bioprognos (www.bioprognos.com) is leader in the development of multiple-biomarkers algorithms for the diagnosis of cancer based on liquid biopsies using circulating proteins, RNAs and ctDNAs as biomarkers. Our flagship product is the algorithm for the diagnosis of lung cancer, which is the first worldwide blood test for lung cancer risk prediction with a 87,5% (90%) Sensitivity, 98% Specificity. This algorithm is scheduled to reach market by the end of 2016, after completion of the regulatory','2017-02-12 18:38:17','2017-02-12 18:40:28',0,NULL,'Marketing,Sales','Critical thinking / problem-solving','Bioprognos S.L.','','ES','7d5cf14b070acd79463bbb5b118aaf72'),(229,'Digital sales & marketing concept','The project goal is to create a digital sales and marketing concept, for an Axivas which can be adopted for an international IT Company. The concept needs to cover the whole digital  customer journey.','2017-02-12 18:42:19','2017-02-12 18:47:14',0,NULL,'','Critical thinking / problem-solving','AXIVAS GmbH','','DE','a94c1ffd58012d8bddf656308b0c436c'),(230,'How to use TPM bios protection with Ubuntu Core 16','Using DELL EDGE Gateway 5000 the challenge is configure TPM (Trusted Platform Module) of the BIOS to only allow the device to use Ubuntu Core 16 with our company software installed on it. ','2017-03-15 14:18:35','2017-11-17 17:45:12',0,NULL,'Information Technology','Curiosity,Persistence/grit','NEXIONA','','ES','d3130e1e506e8612d750086567aac34b'),(231,'Remote support solution using passive secure connections','Currently in Nexiona we have a remote support solution for our on-premise products that can be activated by our customers. Then an email is sent to our support mail account notifying the event and how support team can connect to the remote device. The challenge is not use anymore our technology and substitute it by another suggested technology.','2017-03-15 15:53:51','2017-11-17 17:44:49',0,NULL,'Information Technology','Creativity,Persistence/grit','NEXIONA','','ES','c54be7c461973815d29366064d7f8cc4'),(232,'VPN SSL connection using the browser as the VPN client','Currently we have a solution that need routability between two peers that connect to a server. The server can run any kind of VPN software and there is no problem on connecting one of the peers using a secure and routable channel. One of the peers only run a browser and it could not be any extra software installed there, this is the challenge.','2017-03-15 16:29:12','2017-11-23 10:20:40',0,NULL,'Information Technology','Persistence/grit,Creativity,Curiosity','NEXIONA','','ES','0cf71a23624bdf95213c46b0eb19a90b'),(233,'Getting big in Asia - a strategic move into the asian market or build out strategic partnerships or install an own operation?','The current \"Asia-Strategy\" of Lyomark is based on strategic partnerships in the region allowing a relatively easy access to asian pharmaceutical markets. Lyomark\'s strategic partnerships are managing the various local requirements for respective market specific licenses and approvals, market entries, etc. at the cost of a part of the revenue margin. The core of the challenge is to create a strategic advise based on factual data to determine a double digit revenue growth based on a \"make or buy\" decision and whether to enter the asian market with an own operation or to continue to foster strategic partnerships.','2017-03-17 18:46:34','2017-03-20 10:01:03',0,NULL,'Business Development,Consulting,Finance,Legal,Marketing,Operations,Sales','Critical thinking / problem-solving,Initiative,Social and cultural awareness','Lyomark Pharma GmbH','lyomark.com','DE','2a03d7a4e80f00ab573c3d7a3f96f5b4'),(234,'Help us build a global university inventory knowledge-data-base','TELANTO develops and commercialises the Academic Business Cloud that connects company projects to student communities all over the world. In this TELANTO Challenge we are looking for solutions that help us plan, define, identify and execute a sequence of steps, methodologies and techniques to capture either from public or private big data sources, global university information. ','2017-03-29 18:42:26','2017-04-01 14:08:57',0,NULL,'Engineering,Information Technology,Entrepreneurship,Marketing,Research and Development','Critical thinking / problem-solving,Persistence/grit,Curiosity','TELANTO - The Global Academic Business Network','','ES','d37a4c531029c528a42b0b0add8aacee'),(235,'Build a sustainable TELANTO Foundation concept','TELANTO is looking to build a foundation to extend currently commercialised services and products to non-governmental organisations in a pro-bono setup. The challenge consists of creating a concept for the TELANTO Foundation that is sustainable, can scale globally and furthermore supports TELANTO\'s long-term commercial interests. With social inequality, unemployment amongst 15-25 year-old at heart, TELANTO\'s mission is to connect university and business interests. Through challenge-based collaboration TELANTO fosters competency development with students and allows businesses to gather innovation and access to talent. ','2017-03-30 21:15:24','2017-07-20 17:46:49',0,NULL,'Business Development,Education,Entrepreneurship,Finance,Marketing,Sales','Communication,Creativity,Critical thinking / problem-solving','TELANTO - The Global Academic Business Network','','ES','97ab055c51ce212fdafdf1e83289b9ca'),(236,'Entwicklung eines Programms \'Fit for Learning\' für das Innovationscluster i4.0 @ Robert Bosch','Bosch setzt bei seinen Weiterbildungsangeboten zunehmend auf virtuelle Lernformate, wie Webinar, Live Online Training via Virtual Classroom, WBTs, Video Based Learning, etc… Informelles Lernen gewinnt zudem mehr und mehr an Bedeutung und die Effizienz von Qualifizierung und die Verbesserung Beschäftigungsfähigkeit liegen maßgeblich in der Hand der Mitarbeiter selbst. ',NULL,'2017-04-03 15:48:11',0,NULL,'','Critical thinking / problem-solving','Robert Bosch GmbH','','DE','d69cc9543382201b86ee510f96c94857'),(237,'Somfy Arbeitswelt 2025','Somfy Arbeitswelt 2025',NULL,'2017-04-03 15:53:33',0,NULL,'','Critical thinking / problem-solving','Somfy GmbH','','DE','2cb42e176eb72ce50d0f15d37485f865'),(238,'Groupon Whitepaper Challenge: Online Couponing - ist der Hype vorbei?','Online Couponing scheint in den letzten Jahren aus dem Fokus gekommen zu sein. Wie sieht der Markt aus, welche Möglichkeiten bietet es besonders für lokale Unternehmen und welchen strategischen Wert hat Online Couponing? Das Thema soll aus dem akademischen Kontext in Zusammenarbeit mit dem Studierendenteam und dem Professor analysiert werden, mit dem Ziel, in einem Whitepaper m.H. einer Markt- und Wettbewerbsanalyse den aktuellen Markt zu beschreiben und die Zukunftsaussichten zu evaluieren.','2017-04-03 17:12:02','2017-04-03 17:11:56',0,NULL,'Information Technology,Marketing,Sales','Critical thinking / problem-solving,Creativity','Groupon GmbH','','DE','8e1c38564ce3a366dc21c9e99115549b'),(239,'Job Design for the Service Industry - staying sexy at what price?','Attractive job design and work environments are key to successful talent sourcing. The sales service industry is particularly sensitive to this topic as it determines the speed and quality of resources to be sourced for upcoming projects at revenue generating customer sites. \nThe seeker asks the students teams to identify the perception of recently recruited talents to bridge the gap for these individuals between employer and customers. ','2017-04-03 18:18:00','2017-04-03 18:17:55',0,NULL,'Marketing,Information Technology,Human ResourcesHuman Resources','Critical thinking / problem-solving','AXIVAS GmbH','','DE','3c4315522845dee3fa5da991c9cae20d'),(241,'Feature extraction and engineering in sportswear images','We would like to extract consumer relevant features from our product images, for example, color, shape, logo information. Through feature engineering we target to generate consumer relevant product attributes.','2017-06-09 14:08:07','2017-12-04 10:24:43',0,NULL,'Information Technology,Marketing,Product Management,Research and Development','Collaboration,Creativity,Curiosity','ADIDAS AG','adidas-group.com','DE','7acbc41f362ff0fe7e20a0aea83b764e'),(242,'Development of a new product innovation for Lacer Oral Care along with an integrated launch strategy.','Put yourself in the shoes of the Lacer Marketing Director and break through innovation and develop a new range of products for Lacer´s Oral Care Division.  Which new product innovation would you launch and how would you execute it?\n ','2017-06-15 10:48:01','2017-06-21 09:36:08',0,NULL,'Business Development,Healthcare Services,Marketing,Product Management,Sales','Communication,Creativity,Critical thinking / problem-solving','LACER, S.A','lacer.es','ES','baa676e417c03e849209286e83844e6f'),(243,'Design the Pilexil Brand actualization and internationalization strategy','Put yourself in the shoes of Pilexil´s brand manager and redesign Pilexil while creating an integrated global internationalization strategy for the brand. How can the brand attract consumers all over the world with its unique commitment to quality, health and innovation?\n','2017-06-15 10:50:59','2017-07-03 12:12:29',0,NULL,'Business Development,Consulting,Healthcare Services,Marketing,Product Management,Research and Development','Communication,Creativity,Critical thinking / problem-solving','LACER, S.A','lacer.es','ES','497f552112648f6c2d78016641e55e52'),(244,'Development of a new product innovation for Legs Health along with an integrated launching strategy.','Put yourself in the shoes of the Lacer Marketing Director and break through innovation developing a new range of products for Lacer´s Legs Health Division.  What new product innovation would you launch and how would you do it?','2017-07-03 12:20:43','2017-07-03 12:27:28',0,NULL,'Business Development,Marketing,Product Management,Research and Development','Critical thinking / problem-solving,Creativity,Communication','LACER, S.A','lacer.es','ES','c11553418e078279f12d3866deab9780'),(245,'City-Airport: Health and wellbeing and circular economy framework. Beyond regulation compliance','This project is aimed to explore a new perspective of the sustainability impact of Airport on Airport type cities, analyzing their whole life cycle environmental, economic and social impact with special attention to impacts on public health but keeping them in the context of their impacts on climate change and city resilience. Additionally we would like to explore the potential positive impacts that the Airport might have in the city, integrating the activity they generate in the concept of circular economy and efficient resource use relationship between the city and the Airport.','2017-07-13 12:15:49','2017-07-13 12:17:48',0,NULL,'Community and Social Services,Consulting,Engineering,Real Estate','Collaboration,Critical thinking / problem-solving,Initiative','ARUP S.A.','arup.com','ES','d9d1fab2f59e49a342af8fbfbe96be28'),(246,'Develop Roadmap to enter the Italian market for roof-top Photovoltaic-Systems for self-consumption  ','The fundamental economic and environmental conditions in Italy seem to provide an attractive market-segment for the sale and  installation of so called self-consumption systems for private households as well as for small and medium enterprises. \n\nOver the last 3 years the investment cost for a solar-system have been sharply reduced while on the other hand the cost of conventionally generated electricity has been increased. This offers the opportunity to sell and provide very reliable Photovoltaik-Solar systems to customers from which they can generate a large portion of their required electricity by themselves and by this reduce significantly the electricity consumption from the public grid. Refinancing occurs via the reduced electricity bill. Payback time of investment is estimated to be between 5 to 7 years, while lifetime of system is up to 30 years.\n\nIn combination with storage-systems or smart-grids customers may achieve 100% independency from electricity provides like ENEL, TERNA, etc.  ','2017-07-17 14:29:08','2017-11-08 14:50:49',0,NULL,'Business Development,Sales,Legal,Finance','Communication,Collaboration,Critical thinking / problem-solving','CIC AG','cic-invest.de','DE','1a9e2d5acde19156849806b089891ea5'),(247,'Transportnetzwerk- und Lieferabrufoptimierung für die Beschaffung von Automotive-Bauteilen','Die Challenge beinhaltet eine Transportnetzwerkoptimierung anhand von gebündelten Daten die aus unserem MRP-System (hier SAP) bereitgestellt werden. Des Weiteren zielt diese Optimierung darauf ab, Lieferabrufe (LAB), welche an die Teilelieferanten übermittelt werden um unsere Bedarfsmenge zu decken, auf das Netzwerk zuzuschneiden. Voraussetzung ist eine LKW-Auslastung von 100% FTL (full-truck load), da die Transporte von Duvenbeck eigenverantwortlich durchgeführt werden. Transportkosten sollen somit gesenkt werden.\n\nKernbaustein der Challenge ist folglich das Zusammenspiel aus SAP-Daten und dem Transportnetzwerk. Eine (zu entwickelnde) Software/Programm stellt das Bindeglied dar. SAP ist momentan nicht in der Lage solch eine komplexe Analyse durchzuführen. \n\nDer prozessuale Ablauf ist wie folgt:\n\n1. Bedarfe des Kunden laufen in SAP ein (Daten aus zwei verschiedenen Produktionsstandorten)\n2. Diese Bedarfe werden mit Informationen wie z.B. Sicherheitsbestände bei Duvenbeck, Transport-Lead-Time, etc. zusammen gebracht\n\n---hier kommt die Challenge ins Spiel---\n\n3. Die zur Verfügung stehenden Bedarfe (inkl. der zusätzlichen Infos) werden aus SAP exportiert. Dies kann ein beliebiges System oder Programm sein (wahrscheinlich keine Standard- sondern eher eine Neuprogrammierung)\n4. Die Daten werden mit dem Transportnetzwerk im Hinblick auf die Standorte der Lieferanten und der Duvenbeck-Produktionsstandorte & HUBs in Verbindung gebracht\n5. Es erfolgt eine Bündelung der Bedarfe zu FTL-Transporten unter Berücksichtigung des Bereitstellungszeitpunktes beim Duvenbeck-Produktionsstandortes. Jeweils bezogen auf das frachtpflichtige Gewicht.\n6. Hieraus werden Lieferabrufe (LAB) für den Lieferanten für die nächsten Wochen generiert. Davon sollen die nächsten 3 Arbeitstage fix sein. Die restlichen Abrufe auf Tagesbasis darstellen mit Vorbehalt auf Änderungen in den Bedarfsmengen. \n7. Generierte LABs werden in SAP importiert und verarbeitet.\n8. LABs werden an Lieferanten versendet.\n ','2017-07-19 20:27:43','2017-07-27 18:26:27',0,NULL,'Operations,Information Technology,Procurement and Purchasing','Creativity,Critical thinking / problem-solving,Communication','Duvenbeck Logistik GmbH','duvenbeck.de','AT','d5575904e6876ed14cac54d75d74a1ba'),(248,'Material Transformation - recycling cigarette filters','We want to transform the filter of the cigarette butt into  a design product','2017-07-20 10:41:05','2017-10-02 15:25:25',0,NULL,'Engineering','Critical thinking / problem-solving,Initiative,Persistence/grit','Deriva 360','deriva360.com','ES','e88c796001e99c631440ff910586fc9e'),(249,'TELANTO ICP Challenge','This is the TELANTO ICP Test ChallengeThis is the TELANTO ICP Test ChallengeThis is the TELANTO ICP Test ChallengeThis is the TELANTO ICP Test Challenge','2017-07-20 17:48:06','2017-07-20 17:48:45',0,NULL,'Business Development','Creativity','TELANTO - The Global Academic Business Network','','ES','1adbdb9a6179577889921d69f4c6ec59'),(250,'Demo Company ICP Challenge','Briefly sum up the cornerstones and highlights of your challenge. Professors will use this summary to initially evaluate your challenge and students for placing their preferences between multiple challenges.','2017-07-20 17:57:45','2017-07-20 17:58:26',0,NULL,'Administration','Collaboration','Demo Company  (DO NOT DELETE)','','','7f10557cd0c9a398ba3172fdbadb30cc'),(251,'Strategy Management Challenge for ICP','Strategy Management Challenge for ICP','2017-07-20 18:09:49','2017-07-20 18:10:12',0,NULL,'Business Development','Creativity','Demo Company  (DO NOT DELETE)','','','f80bf4d18efe959da3cfe9aeedd40afb'),(252,'CEO Challenge for ICP','CEO Challenge for ICP','2017-07-20 18:14:16','2017-07-20 18:14:43',0,NULL,'Administration','Leadership','Demo Company  (DO NOT DELETE)','','','f75cff1e9b4b09faba3bf15ccf605fbc'),(253,'Crowdsourcing of Ideas to feed Innovation pipeline','While establishing a collaboration portal for Supply Chain Partners, our Company wants to utilize the User Community to feed the innovation pipeline with meaningful input like painpoints, ideas, issues, etc. \nThe portal shall cover the collaboration needs of Supply Chains in the food service industry from the Raw Material Supplier down to the Restaurants Customers. \nSupply Chains require agility and flexibility anticipating new trends, technical capabilities, business processes and collaboration approaches. \nHow can we assure to keep the capabilities of the collaboration portal \"evergreen\" means at least state of the art? \nHow to leverage input, concerns, trends comming from the crowds of users and communities, working on these supply chain topics and with the portal on a regular base?','2017-07-24 13:26:19','2017-08-28 18:53:43',0,NULL,'Information Technology,Media and Communication,Procurement and Purchasing,Program and Project Management,Research and Development,Quality Assurance,Product Management,Marketing,Business Development','Collaboration,Communication,Creativity','HAVI Europe Management GmbH & Co. KG','havi.com','DE','24e28035fdc227128c8a6d8c128f7116'),(255,'Carbon Footprint Awareness Campaign','Through the last five years GrowForIt has established a model making it possible to balance your carbon footprint in a fashion having several positive environmental and economic spin offs. The method is simple: planting trees. The model established, ensures full transparency allowing you to \'track your trees\' (GPS coordinates and photo documentation), and via a one-time payment, you carbon footprint is balanced for the next 50 years. \n\nWith the model in place, we are ready to take the next step; scaling, fast. But why fast? We need to scale fast in order to succeed (https://www.carbonbrief.org/analysis-four-years-left-one-point-five-carbon-budget), in other terms, we have four years to make balancing of our individual carbon foot print a global cause.\n\nTo succeed we need to reply on social media. In other words, we need to design an online marketing campaign which has the potential to attract global attention to this topic, and our solution to the global CO2 challenge. We target three segments, with three tailored strategies (see presentation attached); \n- Global organizations\n- Wealthy philanthropists\n- Global citizens\n\nThe ideal campaign considers either one - or all three segments and makes use of the most powerful methods to attract global attention, e.g. via. viral campaigns, and bridges across the most popular social media platforms; facebook, Linkedin, etc. and can go live summer 2018.','2017-08-28 09:05:20','2017-08-28 09:07:22',0,NULL,'Entrepreneurship,Marketing,Media and Communication','Communication,Creativity,Critical thinking / problem-solving','Grow For It','growforit.dk','DK','d463bea89cd8a1ec2ac68fa1b73f58eb'),(256,'TELANTO Brand Challenge - Challenge Students & Discover Talent','TELANTO is looking to build a strong global brand in the university-business collaboration space. TELANTO provisions technology and processes for academia (faculty + students) and business to find suitable engagements to get real-world industry problems solved by supervised teams of students as part of student\'s academic education cycle.\n\nThe challenge consists in defining a TELANTO brand, test the understanding of the brand definition suggestion as well as an action plan to create awareness for a solid and consistent brand and respective messages .','2017-08-29 10:29:22','2017-08-29 10:35:25',0,NULL,'Media and Communication, Marketing','Communication, Creativity, Curiosity','TELANTO - The Global Academic Business Network','','ES','c78d32c8f95ff807dfc3ffc8c23a7fbe'),(257,'How can UL apply \'lean start up?/Agile Product development to offline products?','Unilever wishes to apply the lean start up principles of build measure and learn to its offline innovations . This is a challenge as Unilever doesn\'t own the relationship with the end consumer to get feedback.  \nSeeking entrepreneurial, business or engineering students to create a solution in the format of an essay paper and a prototype (up for discussion).','2017-08-29 13:33:02','2017-10-06 08:55:09',0,NULL,'Entrepreneurship,Business Development,Engineering','Creativity,Critical thinking / problem-solving,Initiative','Unilever N.V.','unilever.com','NL','0eaf62900548ba64b53e4d2bf39fd620'),(259,'Optimisation of Transport Network and Delivery Schedule for Procurement of Automotive Components','The challenge includes an optimisation  of a transport network by means of bundled data from our MRP-System (in this case SAP). Furthermore this optimisation targets to tailor the delivery schedule, which is sent regularly to the components suppliers to cover our material demands, to the network. Prerequisite is to execute all transports as full truck loads (100% FTL, in respect to the applicable freight payment method - volume or weight), as the transports are going to be on full responsibility of Duvenbeck (use of subcontractors possible). Subsequently Transport costs should be reduced.\n\nAccordingly the key element of the challenge is the interaction of SAP data and the Transport network. A (to be developed) software/program should work as the needed link. Currently SAP is not able to conduct such a complex analysis. \n\nThe process would be as follows:\n\n1. Demands of our customer are imported to SAP (data coming from two different production plants)\n2. Those demands are brought together with e.g. safety stock at Duvenbeck, transport lead time etc.\n\n---here comes the challenge in---\n\n3. the available demands (incl. the additional info) are being exported from SAP to an external system/program. The choice is free (probably it will be no standard but rather a new programming).\n4. The data is being connected with the transport network in respect to location of suppliers and the production sites and HUBs of Duvenbeck.\n5. Bundling of the demands to FTL-Transports (chargeable weight) considering the time of supply at the Duvenbeck production site. \n6. in the following a delivery schedule for the next weeks is generated. Thereof 3 days should be fixed. The rest of the data should be illustrated on a daily basis with reservation to changes in the material demand.\n7. the generated delivery schedule is being imported back to SAP.\n8. delivery schedule is sent to suppliers.\n','2017-09-12 11:45:04','2017-09-13 09:05:32',0,NULL,'Operations,Procurement and Purchasing,Information Technology','Creativity,Critical thinking / problem-solving,Communication','Duvenbeck Logistik GmbH','duvenbeck.de','AT','34130327bbadc0057df2bcbaa142cb45'),(260,'Digital marketing campaign that enables play for all','Through Dream Networks programmes schools, businesses and communities collaborate to design and build creative and sustainable play areas in disadvantaged communities . Our play areas are designed by the children and are tailored to the communities culture and environment. Our programme introduce a new category of product and service.\n\nDream Networks has enabled over 1,800 children to play in over 6 countries. Through the help of 60 volunteers and teachers facilitating creative workshops, over 60 children have designed creative and community tailored play areas. Consequently our programmes have empowered children and inspired them to pursue careers in engineering and design.\n\nWe have gathered significant feedback and support  from local businesses and international development organisations. There is a need for our product, there are school across the world requesting to participate, there a communities who want to partner with us but we need businesses around the world to invest. Invest their time and finances. To this we need to create a following within the category we have designed. This is the challenge to create a digital marketing strategy tailored to our unique product.\n\nwww.dreamnetworks.co.uk','2017-09-19 23:41:32','2017-09-20 15:21:30',0,NULL,'Arts and Design,Business Development,Marketing,Media and Communication','Communication,Social and cultural awareness,Creativity','Dream Networks C.I.C.','dreamnetworks.co.uk','GB','7e780c4aafd382cac7db66ffc2c64f7a'),(262,'Transformation Management im globalen Business Center der KWS Saat SE - Aufgabe I','Ausgangslage:\nKWS Saat SE ist im Prozess einer strukturellen Verlagerung von Teilbereichen der unternehmensweiten Support Funktionen vom Standort in Einbeck, Barcelona, Wien, Nord-Amerika und Süd-Amerika nach Berlin. Nach eingehender Analyse verschiedener Vorteile von Zentralen-Standorten, wie z.B. Barcelona, Berlin sowie weiteren Städten in Asien, wurde sich für Berlin aufgrund unterschiedlicher Standortkriterien entschieden. Ziel ist, in Berlin ein Zentrum für die gruppenweiten Transaktions-Funktionen sowie einzelne Businesspartner der KWS Gruppe zu etablieren. Zum einen sollen im Business Service-Center für alle weltweit verteilten Geschäftseinheiten transaktionale Dienstleistungen angeboten und serviceorientiert abgewickelt werden. Dies umfasst u.a. Services in den Bereichen Personalmanagement, Controlling oder Finanzierung. Zum anderen übernehmen aber auch dezentral in den einzelnen Regionen einzelne Mitarbeiter die Rolle des ‚Business Partner‘ war. Diese unterstützen dann die Geschäftseinheiten mit ihrem Expertenwissen. ','2017-09-25 14:29:22','2017-09-25 14:58:53',0,NULL,'Human ResourcesHuman Resources,Human ResourcesHuman Resources','Collaboration,Creativity,Leadership','KWS SAAT SE','kws.com','DE','0735022320536f713dcf22232ccf45e2'),(263,'Transformation Management im globalen Business Center der KWS Saat SE - Aufgabe II','Ausgangslage:\nKWS Saat SE ist im Prozess einer strukturellen Verlagerung von Teilbereichen der unternehmensweiten Support Funktionen vom Standort in Einbeck, Barcelona, Wien, Nord-Amerika und Süd-Amerika nach Berlin. Nach eingehender Analyse verschiedener Vorteile von Zentralen-Standorten, wie z.B. Barcelona, Berlin sowie weiteren Städten in Asien, wurde sich für Berlin aufgrund unterschiedlicher Standortkriterien entschieden. Ziel ist, in Berlin ein Zentrum für die gruppenweiten Transaktions-Funktionen sowie einzelne Businesspartner der KWS Gruppe zu etablieren. Zum einen sollen im Business Service-Center für alle weltweit verteilten Geschäftseinheiten transaktionale Dienstleistungen angeboten und serviceorientiert abgewickelt werden. Dies umfasst u.a. Services in den Bereichen Personalmanagement, Controlling oder Finanzierung. Zum anderen übernehmen aber auch dezentral in den einzelnen Regionen einzelne Mitarbeiter die Rolle des ‚Business Partner‘ war. Diese unterstützen dann die Geschäftseinheiten mit ihrem Expertenwissen. ','2017-09-26 13:52:55','2017-09-27 20:03:23',0,NULL,'Human ResourcesHuman Resources','Collaboration,Creativity,Leadership','KWS SAAT SE','kws.com','DE','0d5c44990d245870bc2cbe1476ad32bc'),(264,'Transformation Management im globalen Business Center der KWS Saat SE - Aufgabe III','Ausgangslage:\nKWS Saat SE ist im Prozess einer strukturellen Verlagerung von Teilbereichen der unternehmensweiten Support Funktionen vom Standort in Einbeck, Barcelona, Wien, Nord-Amerika und Süd-Amerika nach Berlin. Nach eingehender Analyse verschiedener Vorteile von Zentralen-Standorten, wie z.B. Barcelona, Berlin sowie weiteren Städten in Asien, wurde sich für Berlin aufgrund unterschiedlicher Standortkriterien entschieden. Ziel ist, in Berlin ein Zentrum für die gruppenweiten Transaktions-Funktionen sowie einzelne Businesspartner der KWS Gruppe zu etablieren. Zum einen sollen im Business Service-Center für alle weltweit verteilten Geschäftseinheiten transaktionale Dienstleistungen angeboten und serviceorientiert abgewickelt werden. Dies umfasst u.a. Services in den Bereichen Personalmanagement, Controlling oder Finanzierung. Zum anderen übernehmen aber auch dezentral in den einzelnen Regionen einzelne Mitarbeiter die Rolle des ‚Business Partner‘ war. Diese unterstützen dann die Geschäftseinheiten mit ihrem Expertenwissen. ','2017-09-26 14:05:33','2017-09-27 20:01:31',0,NULL,'Human ResourcesHuman Resources','Collaboration,Creativity,Leadership','KWS SAAT SE','kws.com','DE','6646b36c95bc255c0c0ce979a0473f65'),(265,'Digitalization in HR & HR´s role in Digitalization of the core business.','The challenge is two fold: 1. How far goes digitalization in HR?  2. What is HR´s role in digitalization of the core business?\n1. What are the key trends in digitalization of HR. What is reality? \nWhat are aspirations? What are the challenges?\n What is best practices? Who are globally the leaders in practicing digitalization in HR?\nWhat kind of technology is best in class? What kind of budgets are invested in this area?\n\n2. What are HR leaders and their organizations doing to drive/support digitalization in the core business? Which HRCO are best practice globally. \nWhat is different in thes corporations compared to others.\nWhat does HR do in depth and detail to make the digital transformation a big success?\nWhat are their challenges and pitfalls?','2017-09-27 17:48:31','2017-09-27 19:02:38',0,NULL,'Business Development,Human ResourcesHuman Resources,Information Technology','Creativity,Collaboration,Communication','Global Future Of Work Foundation','','ES','f75de97cde91b96746175f481f5f0b3f'),(266,'HR\'s Perceived Value of Open Academic Innovation Initiatives across German Industry','Much has been analysed, published and implemented over the past 2 decades on the evolving role of HR technology. For little more than 10 years we\'ve witnessed a dramatic evolution in the ways candidates are getting recruited, engaged and developed, using digital platforms and technologies. As technology continues to accelerate, and as organisations strive to grow and keep up with the associated changes, a new dynamic presents itself with organisations’ most prevalent resource: PEOPLE. In this context, the role and perspective in which HR Professionals treat PEOPLE has changed from \"efficiently managing a workforce\" towards \"effectively scouting talent - early & fast\". \n\nThis challenge is seeking to evaluate the \"Perceived Value Proposition\" of today\'s\' digital solutions in talent matchmaking and recruiting among Senior HR Executives (VP\'s, SVP\'s, CHRO\'s) in Multinational corporations listed on the German Stock Exchange (DAX). The project is about to deliver an evaluation of the perceived value of Open Innovation initiatives in the German industry and particular to discuss the case of TELANTO\'s Global Academic Business Network.Much has been analysed, published and implemented over the past 2 decades on the evolving role of the HR profession. For little more than 10 years we\'ve witnessed a dramatic evolution in the ways we access and consume information, share it, and interact with each other. As technology continues to accelerate, and as organisations strive to grow and keep up with the associated changes, a new dynamic presents itself with organisations’ most prevalent resource: PEOPLE. In this context, the role and perspective in which HR Professionals treat PEOPLE has changed from \"efficiently managing a workforce\" towards \"effectively scouting talent - early & fast\". \n\nThis challenge is seeking to evaluate the \"Perceived Value Proposition\" of today\'s\' digital solutions in talent matchmaking and recruiting among Senior HR Executives (VP\'s, SVP\'s, CHRO\'s) in Multinational corporations listed on the German Stock Exchange (DAX). The project is about to deliver an evaluation of the perceived value of Open Innovation initiatives in the German industry and particular to discuss the case of TELANTO\'s Global Academic Business Network.','2017-09-28 19:54:59','2018-04-05 10:55:54',0,NULL,'Consulting,Human ResourcesHuman Resources,Marketing','Communication,Persistence/grit,Curiosity','TELANTO - The Global Academic Business Network','','ES','4f8204102ad2a8b5f107e02596ce46a9'),(267,'Vergütungs- und Incentivestrukturen in der Gebäude-Reiniger-Branche','Vergütungs- und Incentivestrukturen in der Gebäude-Reiniger-Branche:\nDas Team soll die sich mit den sich verändernden Gehalts- und Vergütungsstrukturen der Branche auseinandersetzen. Ziel ist es, wichtige monetäre und nicht-monetäre Motivatoren zu identifizieren und zu untersuchen, welchen Einfluss diese Motivatoren auf die Gewinnung qualifizierter Fachkräfte hat. Befragt werden sollen vor allem Gebäudereinigungs-Firmen in der Region und ggf. auch bundesweit. ','2017-09-29 12:43:56','2017-10-03 16:52:29',0,NULL,'Human ResourcesHuman Resources','Initiative','Kleine','kleine.berlin','DE','d0d23243f4954cb9eac5218b43519e6e'),(268,'Zukunft der Arbeit im Zeitalter von Digitalisierung in der Gebäudereinigungs-Branche','Regionale Digitalisierungs-Analyse der Gebäudereinigungs-Branche','2017-09-29 13:00:37','2017-10-03 16:51:52',0,NULL,'Human ResourcesHuman Resources','Initiative','Kleine','kleine.berlin','DE','b86824bf3e798aa619745c262e56fe6e'),(269,'Resource Planning','Optimization of Resource Planning: How are we going to manage better resources planning within functions, cross site, cross countries, external sourcing partnership, with the required flexibility and real-time connectivity with the demand from our projects. \n\n','2017-10-02 18:43:35','2017-10-03 13:25:09',0,NULL,'Human ResourcesHuman Resources','Collaboration,Critical thinking / problem-solving,Creativity','Bombardier Transportation','transport.bombardier.com','DE','1f4fedd65fb2b2079e625679d1295bad'),(270,'Kompetenzbasiertes Nachfolgemanagement','Für Bombardier Transportation spielt Nachfolgemanagement aus Sicht der Wissenssicherung und individuellen Kompetenzentwicklung eine entscheidende Rolle für den langfristigen Erfolg am Markt. Für die Verwaltung aller personaladministrativen Aufgaben wird bei Bombardier seit etlichen Jahren ein stark auf Rollen und Funktionen ausgerichtetes IT-System genutzt. Hier werden die Personaldaten aller Mitarbeiter verwaltet. Dieses System füttert das globale Talent-Management (TM)-System (Successfactors/SAP). Jedoch haben die TM-Prozesse und auch das TM-System insbesondere im Hinblick auf eine kompetenzbasierte Nachfolgeplanung aufgrund einer stark hierarchisch organisierten Datenstruktur seine Beschränkungen (Nachfolgeplanung erfolgt auf Positionen, die sich in der Zukuft eventuell sehr verändern werden/ersetzt werden).\n\nProjektziel:\nDas Management hat erkannt, dass für eine reibungslose und kompetenzorientierte Nachfolgeplanung ein alternatives Vorgehen entwickelt werden muss. Gängige Nachfolgeplanung pro Position kann den Gegebenheiten der sich immer verändernden Umgebung, nicht gerecht werden. Dazu gehört, dass die grundlegenden Prozesse und Datenstrukturen auf Basis von Kompetenzen der beteiligten Mitarbeiter und Führungskräfte ausgerichtet werden sollten. In diesem Projekt sollen als Grundlage zur Weiterentwicklung des Systems die konzeptionellen Bausteine analysiert und entwickelt werden. \n\n','2017-10-02 19:13:10','2017-10-03 13:15:08',0,NULL,'Human ResourcesHuman Resources','Creativity,Adaptability','Bombardier Transportation','transport.bombardier.com','DE','e221740ba661f4f8f66a6564352c653d'),(271,'Learning to walk again - GoToMarket Challenge','Honda Europe is entering a new market segment with its newly developed robotic medical device. For the initial target markets in Denmark, Netherlands, Germany and United Kingdom the challenge is to propose a solid Go-To-Market concept for each market or if possible clusters of market (in case markets work alike). A number of important decisions need to be taken regarding the sales process, business model and regulatory affairs. ','2017-10-04 16:14:09','2017-10-20 12:49:59',0,NULL,'Business Development,Entrepreneurship,Finance,Healthcare Services,Procurement and Purchasing,Sales','Creativity,Critical thinking / problem-solving,Initiative','Honda Motor Europe Limited ','honda.co.uk','GB','ed51d8478ed477ab7fb60073d50e4d8a'),(272,'Short-term rental market in Germany','Tourists planning to pop over to Berlin for a weekend break may have to give up on the hipster dream of living like a local in a spacious loft apartment, and get back into the habit of staying in an old-fashioned hotel room instead. Airbnb and other short-term letting agencies face a bleak future in the German capital after the city’s administrative court upheld a de facto ban on short-term rentals, in a landmark ruling that could inspire similar restrictions in cities around Germany.\n\nAt RooMonitor, we help landlords combat the negative side effects of short-term rentals with our IoT (Internet of Things) solutions that help to control noise and energy consumption. \n\nOur CHALLENGE for this Sustainable Entrepreneurship course is centred around understanding the German Market dynamics and appetite for a Service that supports a sustainable short-term market in Germany. ','2017-10-05 11:34:16','2017-10-09 17:28:26',0,NULL,'Entrepreneurship,Marketing,Business Development','Social and cultural awareness,Critical thinking / problem-solving','RooMonitor','roomonitor.com','ES','94d46fe6a148ae95360f3790f2381882'),(273,'Plug & Play electric powertrains for the German-speaking market (DACH)','Unlimited Engineering has created the first Plug & Play electric powertrain that fits any skateboard and we are developing the same concept for bicycles. As a team of mechanical and electronics engineers with a background rooted in racing, the Unlimited team has perfected EV technology and created the world’s first direct-drive hub motors that mount to any standard skate truck with no modifications. \n\nOur product is innovative and sexy since it combines urban-sustainable commuting. Since we launched a very successful campaign on KickStarter we see a lot of interest from a diverse range of consumers from all over the world. However, we need to better understand the different consumer behaviours and sales approaches in the different regions we are going to distribute our products. In this Challenge we are asking students forming part of the Sustainable Entrepreneurship course to help us analyse the German speaking markets - known as DACH for our product.','2017-10-05 13:24:39','2017-10-10 19:51:31',0,NULL,'Business Development,Sales','Creativity,Social and cultural awareness,Initiative','Unlimited Engineering SL','unlimited.engineering','ES','ae3cf7a71ada0774d94f4ea561d3367a'),(276,'Employer Branding Challenge','The current employer branding strategy and activities shall be put to the test. An evolved, strongly focussed strategy is required to continue to attract top talent from the south-west German region. ','2017-10-10 11:00:39','2017-10-11 21:50:11',0,NULL,'Human ResourcesHuman Resources,Marketing,Media & Communication','Creativity,Critical thinking / problem-solving,Social and Cultural Awareness','Somfy GmbH','','DE','5f89bf22b8ff7cbc32fa8766212c85c4'),(277,'How young and old companies approach competency management','Many old companies struggle to innovate and attract young talent, while young companies are often the opposite while at the same time growing fast.\nIn this project we want to find out what is the difference between young and old companies in regards to their approach towards competency management and see how it affects the business.','2017-10-10 11:31:55','2017-10-10 15:00:57',0,NULL,'Human ResourcesHuman Resources,Consulting','Communication,Initiative,Critical thinking / problem-solving','Innential','innential.com','DE','1b18e2e443480572728da4fb1e4f22e8'),(278,'Sustainable Investments@JCK','JCK is a start-up looking to impact the field of sustainable finance and change the way business is done in the arena of SRI (Social Responsible Investment). The core competence is an algorithm which allows to rate the efficiency of existing investment funds in reaching their promised goals (e.g. less child labour, more water justice etc.). This creates transparency where invested money really has an impact. The goal is less to rate the company selection but more the management of the investment funds and how it uses its influence to further the investors social and ethical interests. JCK is aiming is to make this approach an Industry wide and internationally accepted standard.\n','2017-10-10 12:28:05','2017-10-10 13:02:12',0,NULL,'Entrepreneurship,Finance,Quality Assurance','Adaptability,Creativity,Critical thinking / problem-solving','JCK ','gmail.com','DE','dccd8913cbe2deaa50aa856baa51769a'),(280,'Un lugar para los millennials asociado a imaginBank','Hace un año y medio CaixaBank lanzó imaginBank. Un banco dirigido a los milenios. imaginBank es una propuesta de banca móvil solamente. Un banco para aquellos que no quieren ir a una sucursal y que tienen necesidades financieras básicas: una cuenta, una tarjeta bancaria (Visa), pequeños préstamos, etc. Ahora, estamos construyendo un lugar físico, no una sucursal como punto de encuentro para los milenios. El objetivo es utilizar este lugar como una nueva plataforma de publicidad, proporcionando contenido que podemos compartir a través de redes sociales que lleguen a todo nuestro mercado potencial. Vamos a producir este contenido haciendo actividades dentro de un lugar físico especial para los milenios.','2017-10-10 14:44:53','2017-10-24 10:36:54',0,NULL,'Arts & Design,Community & Social Services,Entrepreneurship,Project Management','Creativity,Social and Cultural Awareness,Communication','CaixaBank S.A.','caixabank.com','ES','d825f676033c6429a12db4a9b7bd6bf0'),(281,'Communicate closeness in a relevant way for FAMILY line of products','Doing things in family has many advantages, because together and united, everything is infinitely easier. At CaixaBank, even more. We work to provide solutions that seek your savings and comfort, through solutions inspired by your day to day. And it is that there are things that only we think, we feel and we do when we are in family.\n\nWe have launched this CaixaBank challenge to have students help us identify a relevant way to communicate closeness using the Bank assets and business model as an rtb to reinforce our overall proposal. ','2017-10-10 16:58:24','2018-03-15 21:29:37',0,NULL,'Business Development,Marketing','Communication,Judgement and Decision Making,Service Orientation','CaixaBank S.A.','caixabank.com','ES','d35be444d0e7e4b281e1c69dd87840b0'),(282,'The branch of the future! Just a concept or realty? How should the bank offices of the future be?','At CaixaBank we want to boost innovation and service quality by launching new branch and customer relations model all the time. We pride ourselves with rethinking our branch concepts constantly. At CaixaBank we experiment with new business models and ways in which we can make entering our branches an experience. Today, we are already much more than a bank, we have stores that allow our customers and prospective customers to purchase a wide variety of products. \n\nThis particular CaixaBank challenge is looking to tap into the creative and resourceful thinking of a global student community in which we want to find out what the branch of the future looks like and which services and products are perceived to be beyond traditional banking.  ','2017-10-10 18:01:23','2017-10-20 12:23:39',0,NULL,'Business Development,Consulting,Marketing','Curiosity,Leadership,Service Orientation','CaixaBank S.A.','caixabank.com','ES','0ddf4500d4aad86afdf40957f8885f33'),(283,'Circular apparel challenge','We need to find a way to make mixed apparel waste into a new fiber that can then be turned into a new garment. H&M just found a way to do it but its technologies are hidden away under huge licensing fees. At Leverage Lab, we\'d like to figure out how to do this and make its technologies available and accessible to the entire industry.\nTextile waste is estimated to be one of the fastest growing waste streams in countries across the globe. Generation of apparel waste is tied to patterns of consumption, which include fashion cycles, low-quality mass-produced apparel with short lifespans (fast fashion), and consumer needs. Apparel prices started to decrease in 2000 when China entered the World Trade Organization, and prices have not yet recovered. Low prices have resulted in increased consumption. The more we consume, the more we eventually dispose and the more valuable landfill space we take up.\nThere is growing concern about what to do with apparel waste. While we know it\'s a problem, socially and environmentally, there\'s also an economic opportunity for businesses in the apparel industry to figure out how to collect, repair and generate new products with their waste. Those who have the solutions are holding them close to their chests and halting the industry from moving forward. Determining the technological process that would allow us to recycle apparel waste and unlocking it for the industry will be enough to catapult towards long-term success. ','2017-10-11 18:28:56','2017-10-17 11:11:30',0,NULL,'Engineering,Research & Development,Consulting','Critical thinking / problem-solving,Creativity,Judgement and Decision Making','The Leverage Lab','theleveragelab.com','CA','f5c5a6af92b2db9590b0c20d6f088ad4'),(284,'Comparison of voluntary Extended Producer Responsibility initiatives from selected companies for waste management.','Marine litter has been identified as a major environmental issue during the last years. A major root cause of this problem is the mismanagement of waste, especially in SE-Asia, because waste management systems are underfinanced. \n\nExtended Producer Responsibility (EPR) means to shift the responsibility for end-of-life management of products and materials to producers. In many countries with a high share of mismanaged waste, EPR schemes have not been developed yet.  In some cases, in developing countries voluntary initiatives from the corporate sector dealing with waste management and recycling have been started.\n\nDuring the research, these voluntary initiatives should be evaluated by adressing specific criteria and it should be discussed in general whether voluntary initiatives might have a positive impact on waste management issues in selected countries.','2017-10-12 09:33:18','2017-10-13 08:41:00',0,NULL,'Program Management','Critical thinking / problem-solving','WWF - Stiftung WWF Deutschland','worldwildlife.org','DE','5be14e337d45a39b51a521febc45dbe2'),(285,'Embedding Sustainability in Schindler through Employee Engagement','The Schindler Sustainability team faces a considerable challenge - how can a small corporate team communicate with nearly 60,000 employees worldwide so they understand what sustainability means to the Company and what they can do as employees to improve performance. Schindler challenges students to produce an employee engagement strategy that includes practical recommendations on how the Company can embed a culture of sustainability.','2017-10-12 15:25:00','2017-10-17 11:06:17',0,NULL,'Engineering,Media & Communication,Human ResourcesHuman Resources','Communication,Creativity,Critical thinking / problem-solving','Schindler Aufzüge AG','schindler.com','CH','34347bfc65bb455fbfccf13a46f0321b'),(286,'Big data case study: medical devices for anaphylaxis management collecting big data','Adan Medical Innovation is developing two products in the context of ehealth:\n1.	An smart case for epinephrine autoinjectors (treatment of severe allergies that patients need to carry always with them) connected to a mobile application \n2.	An intelligent emergency cabinet to keep epinephrine autoinjectors (the same concept of defibrillators but for the treatment of severe allergies)\nThese two products can collect many data: information about anaphylaxis events, information about patient’s behavior and other information thanks to the possibility to add sensors (temperature, humidity…). Collecting this information could provide endless possibilities for researchers, advocacy groups, institutions and pharma companies but we need to explore the ideas further. \nThanks to students help we want to have more information about how big data analysis could be implemented as part of our strategy. \n','2017-10-13 12:07:45','2018-01-19 14:37:31',0,NULL,'Information Technology','Collaboration,Critical thinking / problem-solving,Initiative','Adan Medical Innovation, SL','www.adanmi.com','ES','33958b73af7937e8778b8f6dbe6c8174'),(287,'Pharma-economical study on a medical device for anaphylaxis management','Adan Medical Innovation has developed anAPPhylaxis: an smart case for epinephrine autoinjectors (treatment of severe allergies that patients need to carry always with them) connected to a mobile application. The device solves a clinical need and increments adherence to treatment and reduces anxiety to patients and relatives. Therefore, exists the possibility  that public administrations in charge of healthcare services or health insurance providers can partially or totally cover the costs of AnaPPhylaxis on behalf of patients. \nOur challenge consists in creating a pharma-economical report with the economic benefits of our solution as a basis to be presented to insurance companies and public agencies.\n','2017-10-13 12:10:16','2018-02-26 11:56:04',0,NULL,'Finance,Consulting','Adaptability,Initiative,Social and Cultural Awareness','Adan Medical Innovation, SL','www.adanmi.com','ES','672648e3af833b1a4bfd04d9d86731b5'),(290,'Talent Acquisition & Retention Challenge','Axivas is a professional service outsourcing provider for global software companies, covering activities for many European countries from their strategic hub in Barcelona. Barcelona is becoming/has become an attractive city for young professionals looking for their first work experience. Generally Barcelona is attracting a lot of international talent, however due to the proliferation of global brands the demand of the talent is on a all-time-high. Axivas is looking to stay relevant in a highly competitive market. ','2017-10-20 17:18:30','2017-10-20 17:34:00',0,NULL,'Business Development,Education,Human ResourcesHuman Resources','Communication,Creativity,Critical thinking / problem-solving','AXIVAS GmbH','','DE','2b63828a394214bcfb3fdf67b5cb3f87'),(293,'CO2 emission calculator and simulator ','Help Baxter\'s Supply Chain team move towards a more sustainable decision-making process!\nHow? Deploy an innovative tool to estimate current and simulate the future carbon footprint contributed by Baxter\'s global transportation activities.','2017-11-01 14:30:26','2018-01-25 17:11:06',0,NULL,'Engineering,Information Technology,Operations,Support','Collaboration,Creativity,Critical thinking / problem-solving','Baxter AG','baxter.ch','CH','721624b184909c87eca5554b97e67775'),(294,'Benchmarking on carbon footprint, its calculation methods and reporting ','Help Baxter\'s Supply Chain team improve processes related to carbon footprint estimation and its reporting!\n\nHow? Provide an extensive benchmark analysis on the carbon footprint, calculation procedures and reporting among Baxter and peers. \n\nAfter going through the study, give recommendations to Baxter’s Supply Chain team. These must include, at least, CO2 emission target per region and transportation modes and cost-effective calculation and reporting methods applicable to our company.','2017-11-01 14:57:36','2018-01-22 09:55:32',0,NULL,'Consulting,Engineering,Operations','Curiosity,Communication,Collaboration','Baxter AG','baxter.ch','CH','d99dbfdb805673d07e25aaf0277f3d0d'),(299,'Examine machine learning and other breakthrough technologies that will impact the workplace and required skills','Machine learning, blockchain, natural language processing and conversational apps and other breakthrough technologies create new career opportunities for some while making other roles obsolete. Objective of this challenge is to investigate what skills will remain relevant and in demand, and to derive recommendations for future employees and employers.\n','2017-11-14 09:59:56','2018-02-02 16:52:09',0,NULL,'Engineering,Information Technology,Human ResourcesHuman Resources,Administration','Critical thinking / problem-solving,Collaboration,Communication','SAP SE','sap.com','DE','487131f74a1bff37283a2c6fdfa519b0'),(300,'Build model to quantify machine learning efficiency gains','Machine learning will lead to substantial efficiency gains through increased automation. The objective of the challenge is to build a KPI-based model that will allow to quantify the monetary benefits of that increased automation. ','2017-11-14 10:29:22','2018-02-09 17:00:03',0,NULL,'Information Technology,Research & Development,Operations','Critical thinking / problem-solving,Collaboration,Communication','SAP SE','sap.com','DE','cfe7327c6ca92a3eee47fb5817ccfcda'),(301,'The fully automated filter press','Currently liquid-solid separation in ethanol fractionation performed at Shire to separate immunoglobulins, -1 antitrypsin and Albumin from human plasma is done either by centrifugation or filtration. Filtration is the preferred separation option as it gives better separation profiles, requires less maintenance and is usually faster. At Shire depth filtration using commercially available depth filters from 3M or Eaton and big filter presses (filtration area between ~ 20 and 60 m²) is performed. The depth filters have to be placed manually into the filter press (vertical insertion of the depth filter plates). After hydraulic closure of the filter press, filtration is done at low temperatures (usually between 0°C and -10°C). After post-wash and blow-dry, the filter press is opened and the paste is harvested manually by scraping the paste from the depth filter. Then filter plates and frames from the filter press are cleaned manually (in some cases Eaton Begerow filter presses are used which can be cleaned by CIP). The many manual steps require substantial work force. More automation would facilitate the work-flow and would require less time at cold temperatures for employees.','2017-11-17 15:03:53','2018-09-10 17:13:31',0,NULL,'Engineering','Creativity,Critical thinking / problem-solving,Communication','Takeda Austria GmbH','takeda.com','AT','4e75bf3c84be769408d4c231fd3a5100'),(302,'ImaginCafe - Business Model Challenge','ImaginCafe is part of a greater concept within Caixabank called ImaginBank. The bank for millenials, completely virtual and digital without bank branches and without commissions for its clients. ImaginCafé is a physical space in the heart of Barcelona, where ImaginBank clients, friends and non-associated individuals can enjoy daily cafe house services (Cafe, Snacks, Bar, etc.). The space is also going to be used to host events, concerts, exhibitions, etc. to attract particularly young people (millenials). CaixaBanks investment into ImaginCafe is considerable and currently offset by the restauration services (external) and random income streams from punctual events. The team of student will be asked to propose a novel business model, in tune with millennial mindsets, that allows CaixaBank to place ImaginCafé in additional Spanish cities (no more than 3-4 though).','2017-11-22 15:38:35','2017-11-24 17:43:25',0,NULL,'Business Development,Consulting,Entrepreneurship','Creativity,Curiosity,Judgement and Decision Making','CaixaBank S.A.','caixabank.com','ES','0e0f4adca930416249c5391126ad5aec'),(304,'Application content creation with video/audio','TELANTO\'s Global Academic Business Network disrupts the university-business collaboration, allowing students to solve real-world issues as part of the university\'s curriculum. Our offering is a proprietary mobile cloud or SaaS solution which is been used by University professors, Business Executives and students. \n\nToday, university professors convert their course syllabus into a Call For Challenge using a template. A similar process applies for company sponsors, creating their challenges. Although our users are very comfortable filling-in our templates, we think that there is audio/visual way of supporting both professors and executives articulate and publish their courses or respective challenges. \n\nIn this audio/video content creation challenge, we are looking for new digital ways that allow us to support the users to share their stories.','2017-12-12 19:09:05','2018-08-28 16:47:49',0,NULL,'Engineering,Media & Communication','Creativity,Communication,Critical thinking / problem-solving','TELANTO - The Global Academic Business Network','','ES','e82ba6ebc262ef8c65681b3885df0998'),(305,'MyDigiVault MVP','MyDigiVault is a startup venture in the Fintech space. The platform (currently in dev for MVP) is a Life Management Platform; its application is an online asset registry (physical and digital assets) and planning tool. As a platform play, it creates value by connecting and facilitating interactions between stakeholders in the financial sector. On the consumer side, we are looking to solve challenges like Unclaimed Benefits and financial literacy. From an Institution perspective we are working to reduce customer acquisition costs and improve customer experience. We are based in South Africa, but believe the solution has universal appeal in the challenges it is attempting to solve. The challenge includes both business and technical considerations, from discovery and validation, GTO, commercial viability, research, business model review, HR (evaluate implementing exponential organisation methodologies), Legal considerations, financials, technology roadmap, Integrated marketing and communication, gamification as a means to deliver financial literacy and finally scaling.','2017-12-14 18:24:47','2018-04-19 23:30:36',0,NULL,'Business Development,Consulting,Data Sciences,Engineering,Entrepreneurship,Information Technology,Legal,Operations,Research & Development,Finance,Human ResourcesHuman Resources','Creativity,Communication,Social and Cultural Awareness','MyDigiVault','mydigivault.net','ZA','0c4ab947f7179f3453cf464652c54104'),(306,'Sales forecasting for pharmaceutical products','Top Tier Pharma company is looking to establish an algorithm that can forecast accurately sales of pharmaceutical products based on just historical sales and/or other financial/business indicators (internal or external).','2017-12-21 17:52:02','2017-12-22 11:58:42',0,NULL,'Data Sciences,Finance,Operations,Sales,Information Technology,Healthcare Services','Critical thinking / problem-solving,Creativity,Curiosity','Novartis Pharma AG','novartis.com','CH','9baf80e6359e1f894d3bbbb93b42dd01'),(308,'MyDigiVault Business Model/Plan','MyDigiVault is a startup venture in the Fintech space. The platform (currently in development for MVP) is a Life Management Platform; its application is an online asset registry (physical and digital assets) and planning tool. As a platform play, it creates value by connecting and facilitating interactions between stakeholders in the financial sector. On the consumer side, we are looking to solve challenges like Unclaimed Benefits and financial literacy. From an Institution perspective, we are working to reduce customer acquisition costs and improve customer experience. Our company is based in South Africa, but we believe the solution has universal appeal in the challenges we are attempting to solve. The challenge includes both business and technical considerations, from discovery and validation, GTO, commercial viability, research, business model review, HR (evaluate implementing exponential organisation methodologies), Legal considerations, financials, technology roadmap, Integrated marketing and communication, gamification as a means to deliver financial literacy and finally scaling.','2018-01-15 20:55:00','2018-04-19 23:25:13',0,NULL,'Business Development,Finance,Entrepreneurship,Research & Development','Collaboration,Critical thinking / problem-solving,Social and Cultural Awareness','MyDigiVault','mydigivault.net','ZA','2ed1fb982e980bfe254af09c300c3769'),(309,'MyDigiVault Go-To-Market Strategy','MyDigiVault is a startup venture in the Fintech space. The platform (currently in development for MVP) is a Life Management Platform; its application is an online asset registry (physical and digital assets) and planning tool. As a platform play, it creates value by connecting and facilitating interactions between stakeholders in the financial sector. On the consumer side, we are looking to solve challenges like Unclaimed Benefits and financial literacy. From an Institution perspective, we are working to reduce customer acquisition costs and improve customer experience. Our company is based in South Africa, but we believe the solution has universal appeal in the challenges we are attempting to solve. The challenge includes both business and technical considerations, from discovery and validation, GTO, commercial viability, research, business model review, HR (evaluate implementing exponential organisation methodologies), Legal considerations, financials, technology roadmap, Integrated marketing and communication, gamification as a means to deliver financial literacy and finally scaling.','2018-01-15 21:52:47','2018-04-19 23:29:07',0,NULL,'Business Development,Legal,Marketing,Research & Development,Sales,Operations','Collaboration,Creativity,Social and Cultural Awareness','MyDigiVault','mydigivault.net','ZA','717ea9714d2c2d888048d10efa500aa4'),(311,'zibuza.net GTM','Zibuza.net is a cloud-based social networking platform designed and managed by the Dr CL Smith Foundation (Project Management) and Marvel Technologies (Platform Delivery). It serves as an online professional learning community (PLC) or Community of Practice (CoP) which enables a culture of sharing and collaboration between all stakeholders in Basic Education. The community advocates and promotes Professional Development, teacher Support and Appreciation, with the goal of improving the quality of teaching and learning outcomes in South Africa. The ultimate goal is to export this innovation to other countries/regions in the world.','2018-01-26 19:33:58','2018-02-22 14:11:30',0,NULL,'','Critical thinking / problem-solving,Social and Cultural Awareness,Communication','MyDigiVault','mydigivault.net','ZA','63ba2b4c06978e29739aa41e23051b4f'),(314,'Examine machine learning and other breakthrough technologies that will impact the workplace and required skills (HR / strategic view)','Machine learning, blockchain, natural language processing and conversational apps and other breakthrough technologies create new career opportunities for some while making other roles obsolete. Objective of this challenge is to investigate what skills will remain relevant and in demand, and to derive recommendations for future employees and employers. \n\nThe scope of this particular challenge is to look at the overall HR / strategic view. ','2018-02-08 14:09:44','2018-02-14 21:34:40',0,NULL,'Human ResourcesHuman Resources,Information Technology,Business Model Innovation','Critical thinking / problem-solving','SAP SE','sap.com','DE','f5f2b296841306b248c582284468e6d8'),(315,'Micro-crystal formulation for subcutaneous immunoglobulin application','Shire is looking for opportunities to develop a high concentrated formulation for an immunoglobulin for subcutaneous application. Due to the possibility that this protein might also crystallize the formulation could also, but must not, be based on micro-crystals. In the latter case also the development of a crystallization process is necessary. The new formulation must fulfil all patients- and relevant regulatory requirements. The client is finally interested in contacts with external partners having competency on commercial formulation and process development for pharmaceutical industry.\n','2018-02-11 18:47:35','2018-04-30 11:52:31',0,NULL,'Engineering,Healthcare Services,Research & Development','Collaboration,Critical thinking / problem-solving,Judgement and Decision Making','Takeda Austria GmbH','takeda.com','AT','196482eafbeffdae1071a5b4364a855d'),(318,'Examine how machine learning and other breakthrough technologies will impact the workplace and required skills (Finance / departemental view)','Machine learning, blockchain, natural language processing and conversational apps and other breakthrough technologies create new career opportunities for some while making other roles obsolete. Objective of this challenge is to investigate what skills will remain relevant and in demand, and to derive recommendations for future employees and employers. \n\nThe scope of this particular challenge is to look at the impact specifically on Finance departments and the skills needed there. There is a corresponding challenge that looks at the overall HR / Strategic View\n','2018-02-13 10:01:05','2018-02-14 21:33:55',0,NULL,'Accounting,Finance,Human ResourcesHuman Resources,Open Innovation','Communication,Critical thinking / problem-solving,Collaboration','SAP SE','sap.com','DE','7865b12aa7ce0b8adb9cb7c7d8fd4489'),(319,'Storyspot - search out and activate target group','Storyspot is a service for almost everyone. The challenge about being a service for everyone is that most users experience that it is not particularly for them. Therefor we need to segment our audience into different target groups and prepare special campaigns for each target group. In this project we want the students to research what kind of users that are most likely to be early adopters for Storyspot and where we find them? Tribes? Interests? Where to find them?\n\nObjectives: \n1. Define a specific target group to focus on\n2. Create content that will make them understand and want them to use Storyspot App\n3. Create a campaign that will engage the target groups to create storyspots of their own and spread the word about them in order to get new users that both listen and create more storyspots.\n\n ','2018-02-14 14:53:45','2018-05-15 12:16:50',0,NULL,'Marketing,Media & Communication','Collaboration,Communication,Creativity','StorySpot ','storyspot.se','SE','b7a7e3c4b350fd00f7053a0312aeeb01'),(321,'CyberSecurity Audit ','We are a cloud SaaS provider in the EduTech space, with global operations. \nOur cloud solution is in Version 5.3 and is being deployed in more than 17 countries. Our customers are universities and industry partners ranging from start-ups, SMEs and MNCs. \n\nIn this cybersecurity challenge we are seeking for and CS audit to identify the loop-holes and vulerabilities in our infrastructure, firewall set-up and accessability .... \n\nWe are also seeking clear guidelines from this student collaboration which help us understand our current status quo as well milestones to take in order to minimise existing vulnerability. ','2018-02-14 21:27:27','2018-07-03 12:00:25',0,NULL,'Engineering','Collaboration,Communication,Critical thinking / problem-solving','TELANTO - The Global Academic Business Network','','ES','4f1880cfe00aeadd8943561525dfe5fb'),(324,'Automating Blue Collar Jobs - How to re- and up-skill current workforce?','Like other technological developments throughout human history, advancements in manufacturing will have a creative destruction effect: Many jobs will be eliminated, but many others will be created. The key will be training those caught in the middle with the new manufacturing skills required to navigate the transition.','2018-02-21 17:26:07','2018-03-16 11:36:50',0,NULL,'Human ResourcesHuman Resources,Education,Media & Communication','Collaboration,Creativity,Critical thinking / problem-solving','BASF SE','basf.com','DE','638c15a7b7613fbb0b1b08c179323b41'),(333,'Automation of spike turns cutting','During the process of manufacturing steel roll from the hot rolling process, the ends of the roll have characteristic defects of the process: absence of heat treatment and geometric defects. Both defects in roll tip and end need to be removed from the roll before being sent to the customer, so now one or two operators manually remove the loops.','2018-03-03 10:11:12','2018-05-03 20:01:37',0,NULL,'Data Sciences,Engineering,Research & Development,Entrepreneurship','Judgement and Decision Making,Critical thinking / problem-solving','Celsa Group','gcelsa.com','ES','f60213c906819c238f7e2c6646169a5c'),(334,'The best adjusted price for each customer.','- Analysis of the data and definition of a prototype model that predicts with enough confidence the likelihood of a customer to accept our quote for a given price.\n\nIn our sector both we and our competitors are defining the prices based on negotiation with our customers. We believe that the digitalization is a must and will also come to our sector. Therefore we would like to be prepared or even to be the initiators of the on-line selling. For that reason we need to be able to define the best adjusted price for our customers (based on any BI algorithm) to increase the margins for the company, but also maintain our sales. \n','2018-03-05 09:39:26','2018-08-13 13:14:25',0,NULL,'Business Development,Business Model Innovation,Data Sciences,Information Technology,Marketing,Operations,Product Management,Sales','Adaptability,Collaboration,Critical thinking / problem-solving','Celsa Group','gcelsa.com','ES','eab82593f913bd68b7fa5f15499885e9'),(335,'Rebar IoT Business Model Challenge','Main product of CELSA Group is rebars that are mainly used in construction. Nowadays there is a possibility to install sensors in these rebars and continuously get performance information and other kinds of information. But is there a business model behind this tech? How can we extract value from it?','2018-03-05 09:52:21','2018-07-30 18:55:52',0,NULL,'Business Development,Business Model Innovation,Marketing,Media & Communication,Product Management,Sales','Creativity,Communication,Adaptability','Celsa Group','gcelsa.com','ES','efad11705fcee3c16820fcb4ad5e3b88'),(339,'Integrated 360 brand campaign for zibuza.net','zibuza.net is an online professional teacher community for South African teachers, proving teachers with access to training, resources, support and appreciation. The ultimate goal is to raise the status of teachers in society. We have just began a Brand Identity exercise, but we are limited with regards to resources and capital to achieve our objectives. We see this opportunity as an ideal partnership in achieving our objectives and providing RMIT students with a worthy challenge.','2018-03-20 21:03:08','2018-04-16 21:49:38',0,NULL,'Arts & Design,Marketing,Media & Communication','Collaboration,Creativity,Social and Cultural Awareness','MyDigiVault','mydigivault.net','ZA','2c9ab35e1f7f016b7b218fb7f2d7ecd9'),(340,'MyDigiVault Platform Programming Challenge','MyDigiVault was established in 2014 and was among the Top 60 Finalist in the 2015 Global SWIFT Innotribe Challenge. Over 500 judges from across the financial, technology, and investment communities evaluated 370 applications, assessing the start-ups\' ability to provide an important innovation in the future of the financial industry. We were the only semi-finalist without a prototype and did not make it through to the finals. We did however catch the attention of Accenture, a major consulting firm, and Nedbank, one of the 4 major banks in South Africa. While conversations have progressed to an executive level, we have been told to come back with a working prototype to meet bank level standards. Several other financial institutions have echoed the same message. ','2018-03-22 20:34:16','2018-04-16 21:49:06',0,NULL,'Data Sciences,Engineering,Information Technology,Legal','Collaboration,Communication,Critical thinking / problem-solving','MyDigiVault','mydigivault.net','ZA','f8116d80a62f5c819e225c630dba1d6b'),(341,'Measurement of alcohol in protein suspensions','In the first half of the last century Edwin J. Cohn (1892 - 1953) developed cold ethanol fractionation on an industrial scale for isolating blood plasma fractions rich in pharmaceutical relevant proteins, like Albumin or immunoglobulins. Today plasma fractionation is still growing mostly driven by the production of immunoglobulins which are used in a growing number of indications. Due to the high demand fractionation companies are looking for more efficient fractionation methods. To consistently adjust alcohol concentration, one of the 5 variables in the fractionation process (the others are protein concentration, pH, temperature and conductivity), an on-line measurement to determine alcohol concentration in the protein suspension would be highly beneficial. This on-line measurement could be connecetd to alcohol addition and could stop addition at a predetermined final concentration.','2018-03-26 14:55:52','2018-04-30 11:51:53',0,NULL,'Data Sciences,Engineering,Research & Development,Quality Assurance,Open Innovation,Operations','Creativity,Critical thinking / problem-solving,Communication','Takeda Austria GmbH','takeda.com','AT','432d924f535ddd36b057d75070ef69e5'),(343,'RMIT_Digital innovation as a measure of a Supplier Relationship Management','Syngenta Sourcing function consists of 320 people located in 40 various locations. The function spends 8bn USD a year on behalf of the whole enterprise. Many of our suppliers are moving to digital format of service and goods delivery.\n\nIn this challenge we are looking for ways to \"measure\" our suppliers on their \"digital innovation\" capabilities. What would be the key performance indicators, how to make them tangible? How direct and indirect procurement could measure digital innovation of their respective supplier markets (i.e. would it be the same or different)?\n','2018-03-27 13:32:54','2018-06-09 12:29:36',0,NULL,'Business Model Innovation,Data Sciences,Procurement & Purchasing,Entrepreneurship,Information Technology,Operations','Critical thinking / problem-solving,Creativity,Communication','Syngenta Crop Protection AG','syngenta.com','CH','9c830408ebdc38e76d72fe2731c86301'),(348,'C40Reinventing Cities: Madrid','This challenge proposes a call for ideas on the development of a 3Ha site locates in an industrial area of Madrid within the C40 Reinventing cities competition framework. We look for ideas on how to develop the site with the aim of achieving a Zero emissions project also considering the reneation of the urban fabric, the social implications and the resilience of the development. ','2018-04-06 12:32:49','2018-04-20 16:43:01',0,NULL,'Consulting,Engineering,Open Innovation,Sustainablity','Communication,Creativity,Critical thinking / problem-solving','ARUP S.A.','arup.com','ES','052c60485c60dc17297fe02c9b321527'),(350,'TALKE Candidate Journey','Seit Gründung im Jahre 1947 ist die Firma TALKE als Logistikdienstleister für die chemische und die petrochemische Industrie tätig und beschäftigt aktuell mehr als 3.500 Mitarbeiterinnen und Mitarbeiter in Europa, dem Nahen Osten, Indien, China und den USA. Der Hauptsitz des mittlerweile in 3. Generation geführte Familienunternehmens befindet sich in Hürth bei Köln. Von hier aus steuert das Management das nationale und internationale Geschäft der Unternehmensgruppe in den Bereichen Transport, Logistik und Logistic Solutions.\nFür uns als Dienstleister ist unser Erfolg und die Möglichkeit eines gesunden Unternehmenswachstums maßgeblich abhängig von unseren Mitarbeiterinnen und Mitarbeitern. Gleichzeitig sind wir in einer Branche tätig, in der Lohn- und Gehaltsniveau eher niedrig und die Attraktivität der Arbeitsbedingungen und –anforderungen nicht immer auf den ersten Blick ersichtlich sind. Das Finden der richtigen Mitarbeiter für TALKE auf einem Arbeitsmarkt, der sich in einen Arbeitnehmermarkt verwandelt hat, stellt somit aktuell und zukünftig eine zentrale Aufgabe für TALKE dar. Ein Projekt zur Redefinition der Arbeitgebermarke wurde zu Beginn des Jahres gestartet. Interessenten, potenziellen Bewerber oder auch Kandidaten als Kunden zu verstehen, (HR-)Prozesse und Kontaktpunkte entsprechend zu gestalten und langfristig im gesamten Unternehmen für ein Umdenken in diese Richtung zu sorgen, sind hierbei zentrale Punkte. Besondere Herausforderung hierbei ist die Breite und Heterogenität potenzieller Bewerber, die wir ansprechen und von TALKE überzeugen müssen. Es gilt sowohl für den ungelernten Lagerhelfer und den Berufskraftfahrer als auch für kaufmännische Mitarbeiter und den spezialisierten SAP Consultant eine authentische candidate journey zu gestalten.   \n','2018-04-11 08:49:30','2018-04-11 14:05:42',0,NULL,'','Communication,Creativity,Critical thinking / problem-solving','ALFRED TALKE GmbH & Co. KG','talke.com','DE','c82f68862b3275165620aa90187f81da'),(352,'Competency Based Succession Management','Das Projektziel dieses Masterprojektes umfasst die Entwicklung von wirksamen Handlungsempfehlungen, die die Bewerberzahlen quantitativ, aber auch qualitativ anheben und gleichzeitig den eignungsdiagnostischen Ansprüchen der Personalauswahl genügen.','2018-04-11 13:29:39','2018-04-11 19:25:47',0,NULL,'Human ResourcesHuman Resources','Collaboration','dm-drogerie markt GmbH + Co. KG','dmmm.de','DE','d18e51730acc3130d502cd789fe43910'),(353,'Concept for Implementation of Accelerator Programs in SMEs','Brief Description of the Project:\n\nGroße Konzerne wie Siemens, Telekom, Bayer, Allianz, SAP, DB Ventures, SAP haben intern erfolgreiche Acceleratoren / Inkubatoren aufgebaut, um interne Startups oder neue Geschäftsmodelle zu entwickeln. In mittelständischen Betrieben wird häufig aus der Historie heraus das eigene Geschäftsmodell häufig nicht erweitert, bzw. ein internes Accelerator-Programm lässt sich nur nach Überwinden großer Hürden implementieren. \n','2018-04-11 21:44:10','2018-04-11 21:59:14',0,NULL,'','Adaptability,Critical thinking / problem-solving,Judgement and Decision Making','sdw Alumni e.V.','sdw-alumni.de','DE','fd9913c3172c59bdd527b5bdf3d5555e'),(354,'MyDigiVault Cybersecurity Management ','Data Use, Privacy and the Protection thereof is of utmost importance in a world driven by information. We are currently facing a challenge of epic proportions in how peoples personal and sensitive information is being exploited to various ends - whether to modify behaviour, influence opinions or promote sales. \nMyDigiVault was established in 2014 and was among the Top 60 Finalist in the 2015 Global SWIFT Innotribe Challenge. Over 500 judges from across the financial, technology, and investment communities evaluated 370 applications, assessing the start-ups\' ability to provide an important innovation in the future of the financial industry.\nWe have built a prototype of MyDigiVault and are working towards completing an MVP.\n','2018-04-16 17:34:56','2018-04-16 21:46:03',0,NULL,'Data Sciences,Engineering,Information Technology,Legal','Creativity,Critical thinking / problem-solving,Collaboration','MyDigiVault','mydigivault.net','ZA','5334525a3f41d13b482bba0f44e8970d'),(355,'Supplier Market Intelligence  (MI) - report automation','Syngenta Global Procurement is a function within Syngenta Crop Protection AG which counts 320 people spread over 40 countries who manage the total spend of 8bn USD per year. This covers direct (buying materials for production) and indirect (good services needed by the enterprise for its day to day life - technology, people, equipment, fleet, buildings etc) procurement.\n\nTo effectively conduct sourcing and negotiation, the department uses services of the Market Intelligence team which compiles various periodic reports Indirect Procurement and Direct Procurement teams. We are seeking ways to automate simple tasks associated with reports preparation/distribution.','2018-04-20 13:21:09','2018-06-09 12:30:24',0,NULL,'Data Sciences,Information Technology,Procurement & Purchasing','Collaboration,Critical thinking / problem-solving,Communication','Syngenta Crop Protection AG','syngenta.com','CH','738995a9f3e3417000eb46a9b6a9c907'),(356,'Cyber Security Challenge','In the second challenge, the results of an “investigation” will be presented. The technical team will present a quick analysis of what they found, and the business team will attempt to identify vulnerabilities and potential controls.','2018-04-24 13:11:15','2018-04-24 13:24:45',0,NULL,'','Critical thinking / problem-solving','Check Point Software Technologies Ltd.','checkpoint.com','IL','5ca3180d4182d70e995fd9aee923f7de'),(357,'BIM STRATEGY','SCIA develops and commercializes software products for structural engineering and structural analysis in the Architecture, Engineering and Construction (AEC) industry.  A key driver in the digitalization of this AEC industry is Building Information Modelling (BIM). As the adoption of BIM is increasing, new trends and opportunities emerge. In this challenge, we are looking for an analysis of these trends and opportunities and strategic options for SCIA.','2018-04-27 13:45:23','2018-05-14 13:24:03',0,NULL,'Business Model Innovation,Consulting,Engineering,Information Technology,Product Management','Communication,Critical thinking / problem-solving,Judgement and Decision Making','SCIA nv','scia.net','BE','ac30471350b4eafc6732cb7911caab81'),(359,'Virtual and Augmented Reality : write a plot for Mixed Reality advertising video','Create a short and interesting story for a video about Mixed Reality trading desk in real life. The duration can vary, but the minimum is 1 min. It can be a use-case, real or unreal with the HoloLens headset. The target audience – young and mid-aged traders. Please refer to https://www.dxfeed.com/virtual-reality-and-augmented-reality-analytics/ to see the real engineering video. Creating the video itself will be the bonus.\n','2018-05-08 15:56:53','2018-05-09 09:48:33',0,NULL,'Finance,Information Technology,Media & Communication,Arts & Design','Creativity','dxFeed Solutions DE GmbH','dxfeed.com','DE','b3e3e96f5f4fb6199d922c3ac5aada14'),(360,'Data analysis – anti-fraud solutions research ','The task is to create research about the companies/vendors that provide services to detect compliance issues and rogue/fraud trading. That should include services for data analysis, reporting, pattern detection. The report should cover vendor Profile, services, histories, sells to big players. Names of exchanges/regulators, that used these solutions. What are the main commercial solutions (from big banks-brokers)','2018-05-09 10:42:21','2018-05-09 11:12:17',0,NULL,'Consulting,Data Sciences,Finance,Information Technology,Marketing,Research & Development','Critical thinking / problem-solving,Adaptability,Collaboration','dxFeed Solutions DE GmbH','dxfeed.com','DE','65b7c7facde3936e6911fa4664ce22c9'),(364,'Develop the Smart Workdesk of the Future','Workplaces are slowly changing. Due to digitization and other workplace trends, an increasing number of open space offices and clean desk policies are introduced. However, initial research shows that open office spaces have a negative impact on labor productivity and direct communication. Modern workplaces with open office spaces and clean-desk policies often deprive their workers of the possibility to engage emotionally with the work space and their colleagues. In addition, they fail to create the right conditions for workers to be productive: too noisy, not the right light and temperature, disturbances by co-workers, inappropriate devices, paperless desks - the conditions are often far from ideal to concentrate, but also for collaborative and creative work. \n\nAs a possible solution to this and as an answer to changing requirements and behaviour, Konica Minolta has started to work on a product concept that will bridge the gap between standardized office spaces and highly personal, contextual needs with an easy to implement add-on device. This smart workbench will utilise IoT data to offer everything that makes employees more efficient and comfortable. It is planned to create a personalized space with reduced noise levels, individual lighting and temperature control as well as high privacy protection. \n\nFirst ideation sessions and proof of concepts showed promising results. However, recent customer research has shown that the overall concept is too complex, offers too many complex features and lacks an easy-to-unterstand, overarching benefit. This is where you come into play. The task of your group will be to revamp the existing concept based on our own ideas, experiences as well as the research results provided.\n','2018-05-25 13:28:15','2018-11-07 01:50:17',0,NULL,'App & Platform Development,Innovation Management,Experience & Product Design,Strategic / Digital Transformation,Engineering,Artificial Intelligence','Critical thinking / problem-solving,Creativity,Social and Cultural Awareness','Konica Minolta Business Solutions Europe GmbH','konicaminolta.com','DE','a37cf514bfe652acf71ed86e477c0258'),(365,'Empower Mid-managers in Organization to allow their Team Members to take part in Agile Projects','In a large Organization, there is typically a \"command-and-control\" chain of command.  Although it is fairly efficient in predictable and non-changing environment, it is not well-suited for VUCA challenges. (VUCA stands for Volatile, Uncertain, Complex, Ambiguous environment). \n\nIn the modern agile organizations, there are typically projects that take multiple members from different organizational structures to solve complex business or innovation problems.  These agile projects are something that many large organizations aspire to do, but typically cannot - due to their own rigidity. \n\nWe would like to design a organizational system that allows and supports employee movement, and agility structures.   Namely, it should be possible for employees to work part-time on agile project of their choice.   Mid-managers should be incentivized to support such behavior. ','2018-06-20 11:31:43','2018-06-20 14:40:20',0,NULL,'Operations,Human ResourcesHuman Resources','Creativity,Critical thinking / problem-solving,Collaboration','Haufe Umantis AG','haufe.com','CH','2d0ae5ccd5541e6d4374326c5e022262'),(366,'How can a short-lets apartment business based in Stockholm, Sweden improve its sales & profitability?','To maximise revenues & profitability, what Sales & Channel Strategy should be used? How should Pricing, in all aspects, be configured?','2018-06-22 12:53:05','2018-07-11 13:28:07',0,NULL,'Data Sciences,Marketing,Business Model Innovation','Critical thinking / problem-solving,Creativity,Judgement and Decision Making','Gamla Stan Apartments','gamlastanapartments.com','SE','18c62ceeac1c5565ac38122dbbbd308d'),(367,'Daily sales forecasting for pharmaceutical products','Novartis, a Top Tier global Pharma company, is looking to establish an algorithm that can forecast accurately sales of pharmaceutical products based on historical sales.','2018-07-10 10:11:37','2018-08-10 17:33:29',0,NULL,'Forecast - Demand - Inventory','Critical thinking / problem-solving','Novartis Pharma AG','novartis.com','CH','7bf9a1ac0f4888c824881be5670e577b'),(368,'Daimler Car Dealer Self-Audit App Challenge','Daimler Financial Services is the global financial services provider of Daimler AG. \nWhen most people see shiny new Mercedes cars on a garage forecourt they don’t know that the dealer doesn’t own the cars. Daimler Financial Services does.\n\nToday we would like to presenting the \"Car Dealer Self-Audit App Challenge\" where we are looking for a prototypes which help us develop a stock checking system designed to replace manual inventory control.','2018-07-13 16:58:34','2018-07-14 14:31:50',0,NULL,'Experience & Product Design,Hard- & Software IoT,New Product / Service Development','Creativity,Critical thinking / problem-solving,Service Orientation','Daimler Financial Services AG','daimler-financialservices.com','DE','1d060479bf7ac7ac1e67de7d00010c16'),(371,'Madrid Sur Project ','The city of Madrid suffers a historical urban inequality since it’s foundation in the 9th century AD: the alignment of the Manzanares River and the sloped topography to its north conditioned the layout of the urban fabric. The following periods saw continued city growth towards the North, with an economic and demographic blooming. However, the areas crossing the river to the South were mainly viewed as efficient locations for the industrial and agrarian uses that served Madrid. While the North was conceived as a recreation area for the aristocracy and royalty, the South was conformed as a consequential landscape of the development and enrichment of the North.This physical and socio-economic frontier has continued until the early 21st century, when the most important contemporary infrastructure project of Madrid, dubbed M-Rio, strived to bridge the gap between the North and the South Riversides. An environmental and engineering success, did not manage to address the main urban problems suffered by the Southern Districts.\n','2018-07-28 21:11:06','2018-07-29 19:00:14',0,NULL,'Data Modeling & Visualization,Smart City / Building','Social and Cultural Awareness,Critical thinking / problem-solving,Creativity','AECOM','aecom.com','ES','b52c5b34adb99b1f8208ea34d80100ed'),(372,'Explore how Blockchain will impact finance processes and organizations','We are hoping to jointly with the students explore how Blockchain will impact finance processes and organizations so that we can expand our understanding of and our vision for this technology','2018-07-30 11:16:58','2018-09-14 17:49:34',0,NULL,'Accounting & Corporate Finance,Artificial Intelligence,Blockchain,Business Model Innovation,Cryptocurrency,Finance,Innovation Management,Internationalization & Growth Strategy,Machine Learning,New Business Development & Entrepreneurship,Strategic / Digital Transformation','Critical thinking / problem-solving,Creativity,Collaboration','SAP SE','sap.com','DE','1ab3769e618cf7b1833f53d9f3e62bb1'),(373,'What will BASF look like in 10 years from now? Business Model Innovation Challenge','In this BASF Business Model Innovation Challenge you will play a key role in thinking up new and alternative business models for BASF and its corporate partners. \n\nWe would like you to focus on how we can improve profitability and productivity and the need to renew our existing business model where we expect the most impact. You will work on the following challenging questions: \n 1) How can corporates in the manufacturing sector generate financial and social value by applying circular business models in their value chain?\n 2) Which potential BASF business models are most feasible? What models create most value?\n 3) What business model innovation will be required in corporate banking?\n\nWe have high expectations of your ingenuity, creativity and business model expertise. In addition, you will have access to BASF’s experts as well as to selected executives. An excellent basis to jointly get to actionable results. Our senior management will be delighted to hear your ideas. Are you in?','2018-07-30 18:18:28','2018-07-30 18:55:06',0,NULL,'Business Model Innovation','Collaboration,Communication,Curiosity','BASF SE','basf.com','DE','af2ade9e92604796f2d8d218485dee64'),(374,'Benchmarking BASF\'s SCM & Logistics operations with other chemical corporations','Help BASF\'s Supply Chain & Logistics Centre of Expertise (CoE) improve processes related to SCM & Logistics operations. \n\nHow? Provide an extensive benchmark analysis among BASF and peers. \n\nAfter going through the study, give recommendations to BASF\'s Supply Chain & Logistics CoE team. These must include, at least 1 competitor per region on their Supply Chain & Logistics methods applicable to our company.','2018-07-30 18:28:42','2018-07-30 18:54:16',0,NULL,'Supply Chain Management','Judgement and Decision Making,Initiative,Communication','BASF SE','basf.com','DE','35100ecfd05171773729b083ad31e87e'),(375,'General trends in SCM & Logistics','Predicting logistics and supply chain trends will make a difference to BASF\'s businesses but has become notoriously difficult, given the speed at which technology in particular can suddenly disrupt the way things are done.\n\nWith an empowered consumer base now dictating supply and demand, accelerated time to market pressures, intense global competition and the continual rise of the Internet and mobile economies, BASF and its peers need to be able to make production decisions on the spot by leveraging the latest supply chain information at their fingertips. \n\nAt the same time, technological advances such as the Internet of Things, automated transportation and similar futuristic innovations are offering tremendous opportunities to drive efficiencies and operational excellence. ','2018-07-30 18:38:57','2018-07-30 18:53:19',0,NULL,'Business Planning & Consulting','Collaboration,Communication,Initiative','BASF SE','basf.com','DE','8713a14c85e00fac35d7a1c18d240a95'),(379,'Peer-to-Peer remittances System','Develop a peer-to-peer system to ease remittances payment between African countries','2018-08-08 22:21:16','2018-08-08 22:46:11',0,NULL,'Finance,Blockchain,App & Platform Development,Artificial Intelligence,Business Model Innovation,Circular Economy,Cryptocurrency,New Business Development & Entrepreneurship','Critical thinking / problem-solving,Creativity,Social and Cultural Awareness','HELEPMOI','helepmoi.io','FR','e9e11c7ace0f7893104b75619823748a'),(380,'Closed Loop Recycling of PET-Bottles','As it currently appears, PET will remain one of the most important materials for beverage containers in the next 5-10 years. Right now, there is no better alternative with the same characteristics available. But the material per se is actually not bad. Only the recycling of PET and using the recycled material to make new bottles does not work worldwide, even Krones offers special bottle to bottle recycling technologies. If we could close the loop after the consumption and production of new bottles, we could make a huge contribution to one of the biggest problems right now – reducing plastic waste in the environment. But how can we do this? What kind of ideas, technologies or services could lead or support a closed loop? \n\nHelp us to create a smarter and greener future together!','2018-08-14 12:15:46','2019-01-21 16:40:43',0,NULL,'Business Model Innovation,Circular Economy,New Product / Service Development','Creativity,Critical thinking / problem-solving,Judgement and Decision Making','Krones AG','krones.com','DE','fefe22e50d4437011810a33bce6c6fcc'),(381,'Robotic Vision for Future Beverage Production','Based on the requirements and tasks a robot must fulfill in a beverage production in the future, a robot might look quite differently to the robots of today. For example, these tasks might be belt lubrication, replacing of defective parts, picking up fallen bottles in mass flow or cleaning of the in- and outside of the bottling equipment. Together we want to design the robot of the future. How does the future robot look like? Which characteristics does a robot have in the future? How can the robot collaborate? \n\nLet´s develop the future of robotic in the beverage production together.','2018-08-14 12:55:34','2018-09-10 17:07:49',0,NULL,'Artificial Intelligence,Autonomous vehicles,Data Modeling & Visualization,Engineering,Future of Work,Industry 4.0,Machine Learning,Robotics & Drones,Supply Chain Management','Initiative,Creativity,Critical thinking / problem-solving','Krones AG','krones.com','DE','796d685c68b474ff7cef6be3fbf0960b'),(382,'Solar connected battery GreenBox','Develop a solar kit for off-grid power support','2018-08-20 16:18:18','2018-08-20 17:00:07',0,NULL,'Blockchain,Energy & Clean-tech','Creativity,Critical thinking / problem-solving,Social and Cultural Awareness','HELEPMOI','helepmoi.io','FR','8e83867192b4e6dd15f8af2b993447c0'),(384,'Innovation Model for HR-IT','The challenge is to design an innovation process for Bayer\'s (HR-)IT that is easy to adopt for the organization and efficient as well as sustainable in its use.','2018-08-27 23:25:31','2018-09-04 11:55:33',0,NULL,'Business Model Innovation,Innovation Management,New Business Development & Entrepreneurship','Creativity,Critical thinking / problem-solving,Social and Cultural Awareness','Bayer Business Services GmbH','bayer.com','DE','8f6188e971c9693af8bf46b14a6d1fc0'),(385,'Skills / competencies for a modern (digital) HR-IT organization','The challenge is to identify and describe the competencies and skills which are necessary for Bayer\'s (HR-)IT organization to be successful in our Digital Transformation. In this context, our special focus lies on developing our innovation, opportunity identification capabilities as well as to identify competencies raising in their importance in the future.','2018-08-27 23:39:42','2018-12-07 10:56:57',0,NULL,'Future of Work,Innovation Management','Leadership,Social and Cultural Awareness,Creativity','Bayer Business Services GmbH','bayer.com','DE','c9e7da996162075e32964cd4611ce551'),(386,'BUSINESS MODEL INNOVATION CHALLENGE','SCIA develops and commercializes software products for structural engineers in the Architecture, Engineering and Construction (AEC) industry. The company’s revenue stems from software licenses and support & maintenance fees for new product versions. Within a saturated market, product innovations (new features) and premium quality do no longer provide competitive advantages. SCIA is looking for ways to serve existing and new customers in a fundamentally different way thereby disrupting the basis of competition. In this challenge, we are looking for an analysis of the necessity of business model innovation for SCIA and alternative (new) business models that are applicable in the same market. ','2018-08-29 21:27:59','2018-08-29 21:34:18',0,NULL,'Building Information Modeling,Business Model Innovation,Emerging Technology Evaluation & Management,Engineering,Internationalization & Growth Strategy,New Business Development & Entrepreneurship,New Market Entry / New Product Launch,New Product / Service Development,Strategic / Digital Transformation','Critical thinking / problem-solving,Communication,Judgement and Decision Making','SCIA nv','scia.net','BE','6132b1aae9225e650732fe0a2f76f0c8'),(387,'Surface Automation in RPA','For security reasons, enterprise companies often prefer their employees to utilize VDIs and company’s servers, instead of working locally. WorkFusion’s RPA platform is no exception. To provide secure remote access to the users, virtual desktop tools such as Citrix are used. This type of users, also called “thin clients\", do not have direct access to the objects on the interface, as what is seen through Citrix is technically a screenshot of the interface. \n\nOne scenario in which remote access can cause problems is during the use of RPA tools. RPA, or Robotic Process Automation, is the use of software with capabilities to handle high-volume, repeatable tasks that previously required humans to perform. In order to automate these tasks using RPA while accessing the applications through Citrix, we would need to locate and understand the control objects on the interface. These control objects include buttons, textboxes, menus, tabs, flash objects, etc. \n\nThe process of understanding the control objects when only surface access is available is called “surface automation”. The goal of this challenge is to implement surface automation in its most basic form. To simplify the challenge, we are limiting it to surface access to websites. Therefore, the task is to locate and classify the basic html objects on screenshots of webpages. ','2018-08-31 18:56:53','2018-11-15 19:21:50',0,NULL,'Artificial Intelligence,Machine Learning','Collaboration,Creativity,Critical thinking / problem-solving','WorkFusion Inc.','workfusion.com','US','d2dccac53b38e741be7f9a22fd1f6dd3'),(392,'Next Generation Processes / Robotics Process Automation (RPA)					','In order to develop ourselves we want to establish \"state-of-the-art\" processes in connection with robotics. We see big advantages to avoid mistakes, caused by human factor and want to analyze existing processes for automation gaps. Cornerstones of this challenge shall be process design, service orientation (from an analysis and quality perspective) and the establishment of an ongoing-improvement/innovation mindset.','2018-09-07 14:17:14','2018-09-21 17:30:28',0,NULL,'Robotics & Drones','Critical thinking / problem-solving','Boehringer Ingelheim International GmbH','boehringer-ingelheim.com','DE','6aec4e83bed8e18d0ffbc4b76848cf4b'),(393,'Communication 2025 - next level information flows and beyond					','Ways of communication in professional and private environment have changed dramatically and next developments are likely to arise even faster and more drastic. We want to investigate which tools and channels can be used to maximize the benefit of information flows. We (cost- and profitability accounting) provide services for an increasing range of legal entities all over the world. Besides the increasing scope of activities also the number of team members and customers increases. These fast-growing structures in combination with new possibilities to share knowledge via different media like mail, skype, wikis, sharerooms, intranet, etc. hinder fast and target-oriented information sharing.','2018-09-07 16:10:22','2018-09-28 16:12:05',0,NULL,'Building Information Modeling','Service Orientation','Boehringer Ingelheim International GmbH','boehringer-ingelheim.com','DE','eabfde3461e39bdb6950b7db7b71c73d'),(399,'LUT_How to design a communication plan to make Celsa employees engage with innovation contents and increase their commitment?','Our industry is quite conservative and traditional with the bias for change and with the motto “If it ain\'t broke, don\'t fix it!”. \nWe have an innovation department running different initiatives. We have created a #changethegame internal hashtag and now we need a plan/campaign to reach out every employee of CELSA Group to tell them about innovation, explain why we need it, engage them with innovation and show what tools and methods we are using.','2018-09-12 10:50:51','2018-09-12 10:53:20',0,NULL,'Communication & Advertising,Employee Engagement,Innovation Management','Communication,Collaboration,Social and Cultural Awareness','Celsa Group','gcelsa.com','ES','ad7ba7dfe8d5e7615865ab678f44b3ab'),(400,'LUT_Digital innovation as a measure of a Supplier Relationship Management','Syngenta Sourcing function consists of 320 people located in 40 various locations. The function spends 8bn USD a year on behalf of the whole enterprise. Many of our suppliers are moving to digital format of service and goods delivery.\n\nIn this challenge we are looking for ways to \"measure\" our suppliers on their \"digital innovation\" capabilities. What would be the key performance indicators, how to make them tangible? How direct and indirect procurement could measure digital innovation of their respective supplier markets (i.e. would it be the same or different)?','2018-09-12 10:57:25','2018-09-12 11:06:15',0,NULL,'Business Data Management & Analysis,Business Model Innovation,Procurement,Supplier Networks','Creativity,Critical thinking / problem-solving,Curiosity','Syngenta Crop Protection AG','syngenta.com','CH','8da21e0aeec806c93951c5f8277ea864'),(406,'Reclassification of customers to provide the best adjusted price for them','Algorithm to dynamically reclassify customer segmentation depending on their past behavior.\n\nIn our sector both we and our competitors are defining the prices based on negotiation with our customers. We believe that the digitalization is a must and will also come to our sector. Therefore we would like to be prepared or even to be the initiators of the on-line selling. For that reason we need to be able to define the best adjusted price for our customers (based on any BI algorithm) to increase the margins for the company, but also maintain our sales.','2018-09-14 12:09:15','2018-09-24 09:43:24',0,NULL,'Business Data Management & Analysis','Curiosity,Collaboration,Adaptability','Celsa Group','gcelsa.com','ES','84d1f13a2abacb52450b14225f7f4084'),(412,'Outside-In Open Innovation: Knowledge Management in a Call-Center Environment','How is knowledge captured, structured, codified and finally stored and consequently made available especially in the a environment of a call-center for daily service requests.\n\nBy using an OI-approach we are looking for ideas and inspiration and co-development.\n\nMain aspect: How is information about internal processes (i.e. systems, processes within an organization/company) structured, and stored to make it quickly available (e.g. during a call with a customer). How has information to be stored in order to make it available for a human being and a bot (is there a difference?).\n\nMain aspect: how can this be extended from internal to external customers?\n\nSide aspect: What is a state of the art self-service approach (Videos?, Documents) to avoid that customers calling into a help-line in the first place? What\'s the role of self-help tools like \"WalkMe\". How do other (especially digital companies such as Google et al) approach the self-service challenge?\n\nSide aspect: How can information about regular service requests be gathered and optimally structured (e.g. TOP100 questions).\n\nSide aspect: How can SAP ServiceNow help in this context.','2018-09-14 18:33:12','2019-01-08 10:53:37',0,NULL,'App & Platform Development','Critical thinking / problem-solving','Boehringer Ingelheim International GmbH','boehringer-ingelheim.com','DE','f1d180b7e4f41222200a4e4563dd96d5'),(413,'Use cases for predictive analytics					','In order to develop ourselves we want to establish technical system solution at the highest level. We see big advantages to analyze big data, reduce manual workload and gain important new insights in steering related topics in our financial streams. A high degree of automatization and new learning-machine technologies will be necessary. \nWe made our first experiences with predictive analytics (customer payment prediction) and right now we are searching new use cases within Accounting to Reporting, Order to Cash, Source to Pay, etc. for predictive analytics to optimize our financial information management, etc. for controlling purposes. We are also interested to get to know similar technologies to analyse big data.				','2018-09-14 18:35:44','2018-09-28 16:06:56',0,NULL,'Business Data Management & Analysis','Critical thinking / problem-solving','Boehringer Ingelheim International GmbH','boehringer-ingelheim.com','DE','cd919ab84151fca081fecdbf3fe03cb2'),(416,'New Sustainable Approaches for Supporting the Amazon’s Indigenous Communities','Indigenous peoples in the Amazon are challenged by several threats to their rights and resources, including the expanding agricultural frontier, large-scale infrastructure projects, formal and informal extractive activities, and others. Within this context, the Amazon faces immense pressure from large-scale hydroelectric projects, river dredging, logging, land use conversion, mining, petroleum, and natural gas extraction, and climate change, which contribute to significant biodiversity loss, ecosystem fragmentation, and deforestation.\n\nPact believes that the long-term health and vitality of the Amazon is positively impacted when indigenous communities and their allies have the capacities to successfully defend their rights and resources from these threats. Much remains to be done to identify, apply, and scale sustainable solutions that balance the long-term health of the Amazon and regional economic growth without compromising the rights of the Amazon’s indigenous communities, but this is an excellent opportunity to find new approaches to these issues. \n\nStudent projects would, over a three-month period, contribute to a better understanding of existing and emerging opportunities to support thriving, resilient indigenous communities that are heard, capable, and vibrant, and contribute to the forefront of thinking on new strategies and business models with the potential to significantly change our understanding of successful, long-term approaches to meet the challenges facing the Amazon. Specific tasks and responsibilities could encompass:\n\n•	Complete a landscape analysis for funding opportunities from donors, foundations, and other potential partners who are already or actively planning for funding programs specifically focused on the Amazon\n•	Identify additional non-traditional partners, corporations, trade associations, responsible industry organizations, etc., with a potential interest in financing projects that would support indigenous rights and resources\n•	Supplemented by desk research, ~6 key informant interviews with industry and company representatives from the energy, mining, financial, and agricultural sectors, to understand how, and to what extent, issues around indigenous rights and resources are considered in decision-making around investments, sourcing/purchasing, etc.\n•	Desk research on potential payment models for ecosystem services beyond REDD+, focusing on the potential for payments to indigenous peoples from direct and indirect beneficiaries of these ecosystem services\n•	Supplemented by desk research, ~3 key informant interviews on social enterprise models and livelihoods development activities that are specifically targeted towards indigenous and other communities in the Amazon, e.g. solar-powered river transportation services, household, and mini-grid solar, telecommunications solutions, telemedicine, and the use of drones for last-mile solutions and environmental monitoring\n•	Desk research, supplemented by key informant interviews, on issues around gender and social inclusion for indigenous communities in the Amazon region\n•	Desk research, supplemented by key informant interviews, on alternative renewable energy applications and business models that are supportive of indigenous communities and their environments\n\nSpecific student project deliverables and milestones may include:\n•	Research reports\n•	Business model canvassing\n•	Donor / funder network analyses\n•	Relevant industry network analyses\n•	Strategy roadmaps\n\nSpecific responsibilities and deliverables would be determined in consultation with the selected student(s) based on their interest and skillset. The selected student will have the opportunity to engage with Pact’s innovative Mines to Markets and Energy for Prosperity platforms, gaining significant insight into the forefront of the social sector’s work in the extractives and sustainable energy sectors. Students will also be able to connect with Pact’s activity manager for a regional project to build the capacity of indigenous organizations in the Amazon, in addition to technical and project management experts for Pact’s livelihoods, natural resource management. A dedicated experienced project manager will also support and mentor students throughout their projects.\n\nWhile regional in scope, Pact is especially interested in exploring these issues in Brazil, Colombia, Guyana, Peru, and Suriname. Spanish and/or Portuguese language skills will be a significant asset but are not required.','2018-09-15 01:46:00','2019-01-17 16:02:46',0,NULL,'Sustainable Entrepreneurship,Supplier Networks,Internationalization & Growth Strategy,Industry 4.0,Health & Safety,Environment & Corporate Social Responsibility,Energy & Clean-tech,Law & Tax,Social Enterprise / Innovation','Initiative,Social and Cultural Awareness,Service Orientation','Pact','pactworld.org','US','4c213a538d1d28ad7c20b3e43e0706fc'),(417,'Create ONA (Organization Network Analysis) from available employee data','ONA (Organizational Network Analysis) is a novel way in which data from employees (how employees communicate, and share information) can be understood and processed.  It gives a deep insight into real organization network, helps understand and identify influencers, helps to understand how organization spreads, and how to improve it, etc. \nWe would like to understand how each employee could benefit from ONA analysis -> what are the information that employees can use for advancing their well-being, career, or impact in the organization?  How to display data to each employee, so that they can benefit from it? ','2018-09-17 11:38:09','2018-09-17 11:43:23',0,NULL,'Organizational Design,Machine Learning,Future of Work','Creativity,Initiative,Social and Cultural Awareness','Haufe Umantis AG','haufe.com','CH','59a37476a30d67a3f2d870ccfc9b254f'),(419,'Net sales dynamics in pharma','The business is interested in understanding net sales evolution. The students will be provided with a daily data set by customer and SKU, and both gross and net sales, and will be expected to generate visualizations that give the business a better insight into customer dynamics.','2018-09-17 19:01:59','2018-09-25 17:57:20',0,NULL,'Data Modeling & Visualization,Finance','Communication,Curiosity,Critical thinking / problem-solving','Novartis Pharma AG','novartis.com','CH','59eee2e14b68ced2c2023d2df9584747'),(420,'Algorithm for 3D Advertising Technology','Immersely is a platform for brands and game developers to create immersive advertising. We are developing an AdNetwork for immersive advertising in order to avoid the interruption of the user experience. Our end goal would be to allow brands and game developers to promote their products without compromising the user experience. \n\nOur main office is in NYC and we have a technology leader that previously worked at Facebook and sold a Tech company. Our main investor at the moment is Tetris (yes, the game!), so we have good connections within the gaming industry. Our lead mentor is Maya Rogers, CEO of Tetris, who is actively helping us with the business development side of the company.\n\n\n\n','2018-09-19 15:43:10','2018-09-21 08:34:14',0,NULL,'Artificial Intelligence,Machine Learning,Communication & Advertising','Collaboration,Communication,Creativity','Immersely','immersely.io','US','95f563f98650a4ec249859951e8442f0'),(423,'Customer dynamics in pharma','The business is interested in understanding customer dynamics and what drives them. The students will be provided with a daily data set by customer and SKU, and information about volume, and will be expected to generate visualizations that give the business a better insight into customer dynamics.','2018-09-24 18:41:12','2018-09-25 17:56:48',0,NULL,'Data Modeling & Visualization,Finance','Communication,Curiosity,Critical thinking / problem-solving','Novartis Pharma AG','novartis.com','CH','edb448da710edf40e5230b9164e5bb5e'),(426,'Help create the Workplace of the Future!','Workplaces are slowly changing. Long gone are the days when the workplace was merely a physical space employees occupied during regular office hours. Technological advancements, with digitization as its arguably most prominent phenomena, have blurred the lines between the physical office and the place where work actually happens. Today, an increasing number of employees is always connected and working in instant access environments. As the distinction between professional and personal life dissolves, and the workplace becomes truly digital, employees are communicating and collaborating in unprecedented ways. To enable knowledge sharing across the organization, they want the ability to forge productive business relationships beyond natural work groups. \n\nWhat is more, because of the changes through digitization, more and more open spaces and clean desk policies are introduced. Initial research shows that open office spaces have a negative impact on labor productivity and direct communication. Modern workplaces with open office spaces and clean-desk policies often deprive their workers of the possibility to engage emotionally with the work space and their colleagues. In addition, they fail to create the right conditions for workers to be productive: too noisy, not the right light and temperature, disturbances by co-workers, inappropriate devices, paperless desks - the conditions are often far from ideal to concentrate, but also for collaborative and creative work. As a possible solution to this and as an answer to changing requirements and behaviour, Konica Minolta works on a concept for the digital workplace of the future.\n\nThe assigned project group will support this research-based, conceptual work of the future workplace with regards to both hardware and software solutions. The objectives of this challenge range from the design work to the ideation and conceptual development of specific product features. Participants are also asked to conceive and develop a number of realistic use case scenarios.','2018-09-27 00:28:59','2018-11-07 00:09:27',0,NULL,'Experience & Product Design,Innovation Management,Strategic / Digital Transformation,App & Platform Development,Artificial Intelligence,Engineering','Creativity,Social and Cultural Awareness,Critical thinking / problem-solving','Konica Minolta Business Solutions Europe GmbH','konicaminolta.com','DE','7413a2ec458b0e13ecb5126b04e44f93'),(429,'Design a business model for a new approach to marine conservation for sustainable marine tourism','Internationally operating NGO, The Reef-World Foundation (Reef-World) is the driving force behind a global conservation initiative successfully reducing local environmental threats from the marine tourism industry to coral reefs. The current model of implementation does not have the reach or global scale to meet current and expected demand. Reef-World are looking for support in the creation of a business model for a new approach that will both scale impact and provide a new source of finances for implementation of Green Fins but must not affect the integrity of the current brand, its impact and trust with its existing stakeholders. ','2018-10-02 05:22:44','2019-01-17 16:03:36',0,NULL,'Brand Management,Business Model Innovation,Circular Economy,New Product / Service Development,Communication & Advertising,Environment & Corporate Social Responsibility','Communication,Critical thinking / problem-solving,Initiative','Reef World Foundation','reef-world.org','GB','a56274ca43cc1be8796192e756f509ee'),(435,'¿Vehículos eléctricos, revolución o destrucción del sector y la sociedad?','Actualmente los efectos de la contaminación de vehículos en la salud de las personas esta muy presente en la consciencia de la sociedad y la política. Los gobiernos cada vez se ven obligados  adoptar medidas más estrictas, hasta tal punto que algunos coches antiguos se les esta prohibiendo la circulación dentro de las grandes ciudades. Esta situación esta cambiando el paradigma de compra en los conductores, enfocando sus necesidades a comprar vehículos con bajas emisiones, derivándolos a la compra de vehículos de gasolina, híbridos o eléctricos.','2018-10-14 20:12:14','2018-11-12 17:13:14',0,NULL,'Brand Management,Business Model Innovation,Business Planning & Consulting','Judgement and Decision Making,Service Orientation,Social and Cultural Awareness','Drivim - Automoció','drivim.com','ES','7d5afdbdfeca9fb5a152e41c3dab9b0d'),(445,'Business Plan for University-Industry Network in DACH region','Create a business plan to understand the viability of a DACH markets for a university-industry network with a validated business model for Coneo, an active Partner for TELANTO, the Global Academic Business Network. The goal is the expansion of commercial activities and to increase visibility (awareness) of the network and to promote its services in the respective geographies.  Build a Go-To-Market (GTM) approach for the DACH geography based on a business plan with a zero-based budget approach in order to achieve in year 1 (350.000 Euro) , 2 (1.500.000 Euro), 3 (5.000.000 euro), in revenues and a steadily increasing margin (Net earnings over sales). A focus on (social/digital) marketing & sales activities/campaigns would be a major plus','2018-11-15 15:27:53','2018-12-05 12:57:27',0,NULL,'Brand Management,Communication & Advertising,New Market Entry / New Product Launch,Accounting & Corporate Finance,Business Planning & Consulting,Internationalization & Growth Strategy,New Business Development & Entrepreneurship,Organizational Design','Initiative,Collaboration,Judgement and Decision Making','Coneo Germany GmbH','coneo-consulting.com','DE','cbb46aed12923ad39fb7709664983a77'),(447,'FinTech-Analysis: Corporate Lending & ODDO BHF','Within the financial industry a lot of change  is driven by new innovative players who are challenging existing business models of established financial services providers such as ODDO BHF Group. In order to participate successfully in this change, the challenge is to screen the FinTech-market in the areas of the Corporate Lending Business and to identify potential collaboration partners for ODDO BHF.','2018-11-21 13:16:47','2019-01-11 12:19:45',0,NULL,'Blockchain,Business Model Innovation,Cryptocurrency,Finance,Innovation Management,Machine Learning,New Business Development & Entrepreneurship,New Market Entry / New Product Launch,New Product / Service Development,Strategic / Digital Transformation,Artificial Intelligence','Collaboration,Curiosity,Judgement and Decision Making','ODDO BHF Aktiengesellschaft ','bhf-bank.com','DE','dce9e5c44f14ae072d605ac59002ce05'),(448,'FinTech-Analysis: Trade Finance & ODDO BHF','Within the financial industry a lot of change is driven by new innovative players who are challenging existing business models of established financial services providers such as ODDO BHF Group. In order to participate successfully in this change, the challenge is to screen the FinTech-market in the areas of the Trade Finance Business and to identify potential collaboration partners for ODDO BHF.','2018-11-21 14:00:31','2019-01-11 12:19:17',0,NULL,'Artificial Intelligence,Cryptocurrency,Finance,Innovation Management,Machine Learning,New Market Entry / New Product Launch,New Product / Service Development,Strategic / Digital Transformation,Blockchain,Business Model Innovation','Collaboration,Curiosity,Judgement and Decision Making','ODDO BHF Aktiengesellschaft ','bhf-bank.com','DE','85a33f63d2f34d1af2a8ea7862d9acb6'),(455,'How to get your B2B customers and prospects to embrace your brand and services (PART 1)','Proposition of a solid marketing strategy based on a clear value proposition with an objective- and result-oriented tactical plan, which cautiously looks at spends to start small and increases with results coming in. Conduct primary research, where possible to rationalise and guide decisions on brand, business model and communication activities. Build a KPI Dashboard for marketing activities to forecast expected results and compare after-the-fact to understand impact and re-investment options to valuable mechanisms. TELANTO considers itself to think out-of-the-box and therefore also the marketing plan shall contain surprising elements. This is not only related to creativity, but to analytically/rationally proposed activity.','2018-11-27 18:04:21','2019-01-21 18:35:30',0,NULL,'Brand Management,Communication & Advertising,Consumer Behaviour 4.0,Employer Branding - Acquisition & Retention,Media - Gaming - Entertainment','Curiosity,Critical thinking / problem-solving,Initiative','TELANTO - The Global Academic Business Network','','ES','a04b08feeb7407aeec43bba979aff8c5'),(457,'Knowledge Management – Best Practices for Innovation Collection and Knowledge Retention for Companies','The Weisse Arena Gruppe (WAG) employs staff that has qualifications outside the scope of their work area. In a first step, WAG would like to develop a strategie to encourage employees to bring forward new ideas and implement them. In a second step, WAG wants to deveop a knowledge retention strategy, so that information becomes independent of information owners. ','2018-12-01 09:25:02','2019-01-21 16:02:05',0,NULL,'Building Information Modeling,Business Data Management & Analysis,Business Model Innovation,Business Planning & Consulting,Employee Engagement,Future of Work,Innovation Management,Learning & Development','Communication,Creativity,Critical thinking / problem-solving','Weisse Arena Gruppe (LAAX)','laax.com','CH','e77d1fb184b1ba28ff4010c1d521f6ef'),(458,'SIVINUM - Business Plan - A challenge with many different facettes','Sivinum is a newly created e-Commerce Business to predominantly export high-quality Spanish products into the German-speaking market. A complete business plan with focus on operational strategies (logistics + supply chain), as well as margin management (and respective pricing and offer strategies) considering organisational setup is required.','2018-12-02 17:46:09','2018-12-13 10:37:09',0,NULL,'Accounting & Corporate Finance,Brand Management,Business Data Management & Analysis,Business Planning & Consulting,Consumer Behaviour 4.0,Finance,Forecast - Demand - Inventory,Logistics & Transportation,New Business Development & Entrepreneurship,New Market Entry / New Product Launch,Operations & Plant simulation,Procurement,Supply Chain Management','Critical thinking / problem-solving,Initiative,Judgement and Decision Making','Sivinum','sivinum.com','ES','2bba7b4a6f18c5a008b25237e534d72d'),(463,'LUT_BUSINESS MODEL INNOVATION CHALLENGE','SCIA develops and commercializes software products for structural engineers in the Architecture, Engineering and Construction (AEC) industry. The company’s revenue stems from software licenses and support & maintenance fees for new product versions. Within a saturated market, product innovations (new features) and premium quality do no longer provide competitive advantages. SCIA is looking for ways to serve existing and new customers in a fundamentally different way thereby disrupting the basis of competition. In this challenge, we are looking for an analysis of the necessity of business model innovation for SCIA and alternative (new) business models that are applicable in the same market.','2019-01-08 11:09:29','2019-01-08 11:11:50',0,NULL,'Business Model Innovation,Building Information Modeling,Emerging Technology Evaluation & Management,Engineering,Internationalization & Growth Strategy,New Business Development & Entrepreneurship,New Market Entry / New Product Launch,New Product / Service Development,Strategic / Digital Transformation','Communication,Critical thinking / problem-solving,Judgement and Decision Making','SCIA nv','scia.net','BE','d6dd8661188d347a8795d41066e611c4'),(480,'How to get your prospective academic/professor partners to embrace and engage our TELANTO brand and services ','Proposition of a solid marketing strategy based on a clear value proposition with an objective- and result-oriented tactical plan, which cautiously looks at spends to start small and increases with results coming in. Conduct primary research, where possible to rationalise and guide decisions on brand, business model and communication activities. Build a KPI Dashboard for marketing activities to forecast expected results and compare after-the-fact to understand impact and re-investment options to valuable mechanisms. TELANTO considers itself to think out-of-the-box and therefore also the marketing plan shall contain surprising elements. This is not only related to creativity, but to analytically/rationally proposed activity.','2019-01-21 15:22:24','2019-01-21 18:36:04',0,NULL,'Brand Management','Collaboration','TELANTO - The Global Academic Business Network','','ES','a924a868c135fed435f40dffc099d38a'),(481,'How to get students to embrace and engage our TELANTO brand','Proposition of a solid marketing strategy based on a clear value proposition with an objective- and result-oriented tactical plan, which cautiously looks at spends to start small and increases with results coming in. Conduct primary research, where possible to rationalise and guide decisions on brand and communication activities. Build a KPI Dashboard for marketing activities to forecast expected results and compare after-the-fact to understand impact and re-investment options to valuable mechanisms. TELANTO considers itself to think out-of-the-box and therefore also the marketing plan shall contain surprising elements. This is not only related to creativity, but to analytically/rationally proposed activity.','2019-01-21 15:24:49','2019-01-21 18:36:22',0,NULL,'Brand Management,Communication & Advertising,Future of Work','Collaboration,Communication,Creativity','TELANTO - The Global Academic Business Network','','ES','544b59a03dad74adbce722a04c7204ba');
326/*!40000 ALTER TABLE `temp_challenge` ENABLE KEYS */;
327UNLOCK TABLES;
328
329--
330-- Table structure for table `temp_course`
331--
332
333DROP TABLE IF EXISTS `temp_course`;
334/*!40101 SET @saved_cs_client     = @@character_set_client */;
335/*!40101 SET character_set_client = utf8 */;
336CREATE TABLE `temp_course` (
337  `id` int(11) NOT NULL,
338  `id_degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
339  `field_studies` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
340  `start_date` datetime DEFAULT NULL,
341  `ending_date` datetime DEFAULT NULL,
342  `summary` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
343  `categories` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
344  `draft` int(11) DEFAULT NULL,
345  `students_countries` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
346  `academy_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
347  `academy_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
348  `academy_country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
349  `md5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
350) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
351/*!40101 SET character_set_client = @saved_cs_client */;
352
353--
354-- Dumping data for table `temp_course`
355--
356
357LOCK TABLES `temp_course` WRITE;
358/*!40000 ALTER TABLE `temp_course` DISABLE KEYS */;
359INSERT INTO `temp_course` VALUES (204,'Bachelor',NULL,'2019-10-01 00:00:00','2020-01-31 00:00:00','Managing Innovation includes methods for managing the innovation process, and refers to the relationships between innovation strategy and corporate culture. Overcoming contradicting directives in organisations, whose primary focus is efficiency, encountering structural barriers for major innovation','Innovation Management',0,'','University of Southampton','soton.ac.uk','GB','4ddcbf787570e28a5db98f1f7f6f4196'),(220,'Master',NULL,'2019-05-13 00:00:00','2019-08-09 00:00:00','This course is the culmination of the master\'s in applied economics program. Students work in groups to research, report and present their findings from a data analysis of a business problem. They apply the econometric and data analytic skills acquired and developed throughout the graduate program.','Business Data Management & Analysis,Data Modeling & Visualization,Machine Learning',0,'United States,India,China','University of Cincinnati','euc.edu','US','8912c5d4b3788e58f19c283e5be6c3bd'),(224,'Bachelor',NULL,'2019-09-18 00:00:00','2020-01-10 00:00:00','Students will learn the cornerstones of biology and chemistry and contextualize and apply them to the field of environmental engineering using various projects.','Closed-loop supply chain & Remanufacturing,Engineering,Circular Economy,Emerging Technology Evaluation & Management,Energy & Clean-tech',0,'Germany,France','University of Applied Sciences Western Switzerland (HES-SO)','hes-so.ch','CH','d4f62cd92bceea0a2b0e6831a7ab4ea9'),(225,'Master',NULL,'2019-04-26 00:00:00','2019-04-26 00:00:00','The University of Alabama is seeking an engagement with a global company to give students the experience of helping solve real business issues.  The company we seek to work with will have associates available to work with the students as the project moves to completion. Typically the students will engage with the company on a weekly basis to gauge progress and seek assistance in removing barriers to progress. This particular engagement will be completed by April 26, 2019. The headcount of students in a team is four to five.','Accounting & Corporate Finance,Artificial Intelligence,Blockchain,Business Data Management & Analysis,Business Planning & Consulting,Machine Learning,Project & Service Management',0,'United States','University of Alabama','www.ua.edu','US','dc5c5eacdbd765482d3230245ec62240');
360/*!40000 ALTER TABLE `temp_course` ENABLE KEYS */;
361UNLOCK TABLES;
362
363--
364-- Table structure for table `time_constraint`
365--
366
367DROP TABLE IF EXISTS `time_constraint`;
368/*!40101 SET @saved_cs_client     = @@character_set_client */;
369/*!40101 SET character_set_client = utf8 */;
370CREATE TABLE `time_constraint` (
371  `id` varchar(20) NOT NULL,
372  `name` varchar(100) DEFAULT NULL,
373  `description` varchar(200) DEFAULT NULL,
374  `valoration` int(11) DEFAULT NULL,
375  PRIMARY KEY (`id`)
376) ENGINE=InnoDB DEFAULT CHARSET=utf8;
377/*!40101 SET character_set_client = @saved_cs_client */;
378
379--
380-- Dumping data for table `time_constraint`
381--
382
383LOCK TABLES `time_constraint` WRITE;
384/*!40000 ALTER TABLE `time_constraint` DISABLE KEYS */;
385INSERT INTO `time_constraint` VALUES ('TIME-1','Within 6-12 months','',4),('TIME-2','Within 3-9 months','',3),('TIME-3','Within 0-6 months','',2),('TIME-4','Within 3 months','',1),('TIME-5','Anytime','',5);
386/*!40000 ALTER TABLE `time_constraint` ENABLE KEYS */;
387UNLOCK TABLES;
388
389--
390-- Table structure for table `user`
391--
392
393DROP TABLE IF EXISTS `user`;
394/*!40101 SET @saved_cs_client     = @@character_set_client */;
395/*!40101 SET character_set_client = utf8 */;
396CREATE TABLE `user` (
397  `id` varchar(30) NOT NULL,
398  `name` varchar(45) DEFAULT NULL,
399  `last_name` varchar(45) DEFAULT NULL,
400  `business_email` varchar(200) DEFAULT NULL,
401  `company` varchar(100) DEFAULT NULL,
402  `phone_country_prefix` varchar(5) DEFAULT NULL,
403  `phone_number` varchar(12) DEFAULT NULL,
404  PRIMARY KEY (`id`)
405) ENGINE=InnoDB DEFAULT CHARSET=latin1;
406/*!40101 SET character_set_client = @saved_cs_client */;
407
408--
409-- Dumping data for table `user`
410--
411
412LOCK TABLES `user` WRITE;
413/*!40000 ALTER TABLE `user` DISABLE KEYS */;
414INSERT INTO `user` VALUES ('u-5c73fc8f','sdf','Kerzel','gerard.llanas@telanto.com','safd','34','+34654654654'),('u-5c812294','654654','654654','64654@kjasfd.ocm','asdffsdasdf','34','+34654654654'),('u-5c812424','Gerard','Llanas','kasjdf@ksdjlf.com','kasñjdflkdjs','34','+34654654654');
415/*!40000 ALTER TABLE `user` ENABLE KEYS */;
416UNLOCK TABLES;
417/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
418
419/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
420/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
421/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
422/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
423/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
424/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
425/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
426
427-- Dump completed on 2019-03-08 13:36:56