The starting point: dynamic data in rigid tables

Die Videospielbranche ist ein schnelllebiges Feld. Es gibt regelmäßig neue Games, Updates und Werbeaktionen. Das alles bedarf sorgfältiger Planung und einer präzisen Auswertung basierend auf einer zuverlässigen Datengrundlage. Ubisoft’s bisheriger Prozess zur Planung und Abrechnung von Verkaufskampagnen ist stark Excel-basiert. Dadurch konnte die digitale Umsetzung des Prozesses über Jahre mitwachsen. Denn Excel ist sehr flexibel. So konnten die vielfältigen Anforderungen der Anwender:innen meistens abgedeckt werden.
‍
Auf lange Sicht verzweigt sich die Umsetzung des Prozesses jedoch. Die Zusammenarbeit von verschiedenen Anwendern an vielen Files, Tabellenblättern und Makros ist unübersichtlich und führt zu einer Reihe von Nachteilen:

• Mitarbeiter:innen verbringen viel Arbeitszeit mit der manuellen Datenpflege, z.B. werden Abverkaufsdaten eingetragen und aktuell gehalten. Das führt zu einem hohen Ressourcenaufwand und ist fehleranfällig.
• Daten können schnell inkonsistent werden, wenn das Controlling auf verschiedenen Aggregationsebenen durch "Zusammenkopieren" und Modifizieren verschiedener Excel Dateien möglich ist. Dieser Effekt verstärkt sich noch, wenn verschiedene Abteilungen die Dateien nutzen.
• Excel-Tabellen erschweren zuverlässige Echtzeit-Integrationen mit externen Datenquellen (z.B. Amazon Seller Central). Verspätetes Vorliegen von Daten erschwert pünktliche Analysen des Ist-Zustandes und somit auch der Zielplanung.
  

The requirements: Concept for a user-friendly and practical application

After some preliminary discussions, it was clear that the solution to the problem fell within SIDESTREAM's specialisation. In the development of solution concepts and the development of a new tool, we relied on a "democratic" process. In short, it is not the managers alone who decide what is to be built, but all the specialist departments involved should be heard. Because only when we hear about problems and wishes first-hand can a sensible solution be designed with a high level of acceptance. The day-to-day benefits of the solution are always in focus.

To this end, we have used our proven three-stage process for concept sprints:

1. Preparation and planning

First, we exchanged ideas with those responsible for the process at Ubisoft and established initial problem areas and solution hypotheses for the process. Despite the management summary, it is important to get deep into the minds of the users and get as much detailed information as possible. The density of information can seem daunting at first. You shouldn't rush into the programming phase if you want to achieve a very good result. Therefore, in the second phase it is important to delve deeper into the process in order to then be able to design a sensible solution.

2. Information gathering

Um tiefergehende Informationen des Prozesses zu bekommen, haben wir mit den Mitarbeiter:innen von Ubisoft einen remote Workshop Tag abgehalten. Dies diente dazu, Details und Zusammenhängen des Prozesses zu verstehen. Dabei führten wir Interviews mit jeweils 1-2 Beteiligten, um tief in die bestehenden Prozesse und Tools einzusteigen und so die individuellen Wünsche und Bedürfnisse zu verstehen. In diesem Fall haben wir in Interviews mit den Fachabteilungen Vertrieb, Key-Account-Management, Controlling und interne IT durchgeführt und verschiedenste Probleme und Wünsche aufgedeckt. Zum Beispiel:

• Bessere Reportings;
• smarte Autovervollständigungen;
• Teilautomatisierungen wie Kampagnen-Duplikationen;
• granulare Zugriffsrechte und Change-Logs.

3. Elaboration and presentation

Using the information gained, we worked out the concept. In this phase, too, it was important for us to remain in close contact with the specialist departments in order to clarify questions, discuss and iteratively improve preliminary versions. The concept sprint is concluded with a handover and presentation of the deliverables.
‍
We developed the following deliverables for Ubisoft:

UX Wireframe

An essential deliverable is a wireframe that shows what the application will later look like and how various challenges will be solved through a good user experience. Even during the concept sprint, we use the wireframe to go through the various work steps with the respective employees, uncovering gaps in the solution (without having written a line of code!) and increasing acceptance of the future solution. For the Ubisoft wireframe we used the Whimsical tool. This allows for quick iterations and is well suited for table and data-heavy applications.

Target software architecture

Where wireframes reveal and solve various functional blockers, the conception of a software architecture ensures that technical blockers are also revealed and solved at an early stage. It is essential here that requirements from the various abstraction levels (interviews, UI/UX, technical implementation) are communicated smoothly. This is the only way to create a customised software architecture that is as simple as possible (and thus minimises effort) and at the same time future-proof and expandable.
‍
The software architecture for Ubisoft consists of a series of microservices: a web app, a reverse proxy, a dedicated user administration and a backend including database. The software architecture was implemented with the tool draw.io.

A development plan

Based on the wireframes and the target software architecture, a development plan can be created as the final deliverable of the concept sprint. Despite agile collaboration, it is important to have a preliminary cost and implementation plan. This increases planning security and enables an ROI calculation of the development project. For the development plan, the developed specifications are divided into several packages, each of which is provided with effort estimates.
‍
The first phase forms the basic construction and in this case was estimated to take three 2-week sprints: at the end there is a functioning application with the most important functions and a stable foundation for further functions. In addition, we have already set up plans for further phases and sprints. Our credo is: Best Value first: All features are weighed up in advance according to their value. Features with the best value are implemented with priority. This procedure maximises the business benefit of the application.
‍
For the Ubisoft development plan, we used the Productplan tool, which has a wide range of relevant features because it was developed specifically for development plans and product roadmaps.

Conclusion

A carefully and practically created concept is the cornerstone for the development of a solution-oriented application. To this end, it is crucial to enter into an exchange with all those involved in the process. This means that both users and participating departments are involved in the planning. In addition to the pure gathering of information, the focus of the planning is on the presentation and play-through of the target application. In this way, decisive features and workflows can be worked out at an early stage.

After a concept sprint, you are left with a sharpened understanding, a tailor-made implementation plan and an estimate of the effort required. Now you can calmly decide whether, how and with whom to start the development phase.