technology and project consulting

Training

Unsere Trainings

Our training portfolio includes a variety of different formats, always oriented towards your needs. Whether Tableau Desktop Basic, Alteryx training or Train-the-Trainer: We serve your requirements and provide you with experienced and competent trainers. In addition to our standard trainings, we also design individual trainings for you.
 

M2 Classroom Trainings

In our training Business Intelligence with Tableau we offer you the opportunity to learn Tableau from the very beginning and in compact training modules that logically build on each other.

The Training

In our two-day training course you will go through and learn the following topics:

  • Overview Tableau Products
  • Tableau Desktop Basics
  • View types & their customization
  • Data organization
  • First calculations
  • Data management
  • Simple table calculations
  • Dashboards
  • Presentation, Export & Distribution

You can find more details about the training contents here: Business Intelligence with Tableau

Each block of topics builds on the previous one, so that you always have an overview and can easily switch between individual topics during the training to explain certain relationships in a clear and concise way.

Regardless of previous knowledge, you will gain insights into the creation of expressive visualizations, details of calculations and their application to real scenarios. Time series, geographical data, survey data as well as operational key figures are part of the training.

After completing the course, you will be able to perform innovative analyses and design interactive dashboards. We will provide you with the tools to use modern business intelligence to gain deeper insights into your company and to gain new knowledge to make intelligent and data-driven management decisions.  
 

Dates

  • Berlin – 30./31. March 2020
  • Berlin – 27./28. May 2020
     

Place

M2 - Milastr. 2 - 10437 Berlin
 

Facts

  • Small groups under the guidance of professional, trained trainers
  • Mediation of the Tableau basics in compact topic blocks
  • For beginners to advanced learners
  •  Arrival on the first day until 10 am
  • Departure on the second day from 16 hrs
  • M2-Certificate "Business Intelligence with Tableau" for each course participant
  • Training documents with cheat sheet, glossary, training workbook, etc.
  • Catering during the training
  • Enough space for questions and answers

Our offer

  • 999 € per person (plus VAT)
  • 399 € for students (plus VAT)
  • For each student: Voucher for a 30-minute remote support session with our consultants

Tableau Desktop Basic

The perfect training for advanced tableau users who want to learn a deeper understanding of the functionalities. Parameters and sets, advanced calculations, table calculations or data management are part of this 2-day training.

Content 

In our standard training Tableau Desktop Basic you will get an overview of the Tableau product range and learn to operate and use the different components of Tableau Desktop. All contents are provided with practical exercises, if desired also on your company's own Data.

  • Introduction
  • Tableau Desktop Basics
  • View types & their customization
  • Data organization
  • First calculations
  • Data management
  • Simple table calculations
  • Dashboards
  • Presentation, Export & Distribution

General conditions

  • Required prior knowledge: None
  • Duration: 2 days
  • Number of participants (recommended): up to max. 12 persons
  • Location: In-house in your company or in our training facilities

Tableau Desktop Advanced

The perfect training for advanced Tableau users who want to learn a deeper understanding of the functionalities. Parameters and sets, advanced calculations, table calculations or Data Management are part of this 2-day training.

Content

The training  Tableau Desktop Advanced is aimed at advanced tableau users who want to expand their knowledge. The goal of this training is to gain a deeper understanding of the functionality of Tableau and a comprehensive understanding of the tool. Many elements of the basic training will be continued and dealt with in greater depth.

  • Introduction & Review Basic Training
  • Spreadsheets
  • Extended view types
  • Level-of-detail calculations
  • Dashboards and Stories
  • Parameters
  • Data management

General conditions

  • Required prior knowledge: Tableau Desktop Basic Training or 6+ months Tableau experience
  • Duration: 2 days
  • Number of participants (recommended): up to max. 12 persons
  • Location: In-house in your company or in our training facilities

Data Science Training

Immerse yourself in the basics of this database language and learn to control the definition of your Data Structures independently. Edit and change your Data Stock and implement your individual requirements with SQL.

Content

With the growing amount of available data, the need for powerful analytical methods is increasing. This is where Data Science Training comes in, enabling you or your employees to apply the latest methods to gain insights from your data. The course is aimed at beginners as well as participants with first insights into the very extensive subject area "Data Science":

  • Introduction Data Science
  • Python Basics
  • Statistics Basics
  • Data Preparation
  • Machine Learning I
  • Machine Learning II
  • AWS Deployment

General conditions

  • Required prior knowledge: Basics of programming are advantageous
  • Duration: up to 6 days
  • Number of participants (recommended): up to max. 7 persons
  • Location: In-house in your company or in our training facilities

Tableau Prep

Cleanse unorganized data and get to analysis faster - directly and visually. Learn about the advantages of Tableau Prep in our 1-day training and achieve a deeper understanding of your Data.

Content

The Training Tableau Prep offers the possibility to understand the basics of data preparation and analysis and to learn the use of Tableau Prep from scratch. The training is designed as a beginner training, therefore previous knowledge is not necessary.

  • Tableau Prep Basics
  • Workspace
  • Connection to Data sources
  • Data cleansing
  • Transformation of Data
  • Calculations
  • Data link
  • Help & FAQ

General conditions

  • Required prior knowledge: none
  • Duration: 1 day
  • Number of participants (recommended): up to max. 12 persons
  • Location: In-house in your company or in our training facilities

Tableau Train-the-Trainer

As a Tableau expert, you may be faced with the question of how you yourself can best share your knowledge with other colleagues. Learn how to set up an optimal training concept and train Tableau in your company.

Content

In our training Tableau Tableau Train-the-Trainer you will learn the basics for the professional work as a systemic trainer. In a structured way we introduce you to the individual components that you should know and master in order to create a trustful and productive atmosphere and to perform confidently in front of groups. In addition, we will give you in particular the ability to convey complex, technical content to your training participants in an understandable and interesting way. 

  • Basics of the training & systemic thinking
  • Language, question techniques & learning processes
  • Collection of methods for systemic trainers
  • How do we make sure that the training arrives?
  • Relevance, Intensity, Resonance
  • Application to Tableau Trainings
  • Tableau Insights & Challenges

General conditions

  • Required prior knowledge: none
  • Duration: Variable (by agreement)
  • Number of participants (recommended): up to max. 12 persons
  • Location: In-house in your company or in our training facilities

Tableau Server Web Authoring

In just one day, learn about the extensive possibilities offered by Tableau Web Edit Authoring. Create dashboards, analytics, and visualizations, and share your Data across the enterprise without a Tableau Desktop.

Content

The analytical and visual capabilities provided by Tableau Server Web Authoring bare extensive and offer multiple data processing, visualization, and distribution options without the need for Tableau Desktop. This one-day workshop enables purely web-based Tableau users to take full advantage of the diverse technical possibilities of the server frontend.

  • Login & Tableau Server Interface
  • Tableau Dashboard functionalities
  • Customization & modification of existing Dashboards
  • Create entirely new Dashboards
  • View Types
  • Simple calculations
  • Present, Export, Share
     

General conditions

  • Required prior knowledge: none
  •  Duration: 1 day
  • Number of participants (recommended): up to max. 12 persons
  • Location: In-house in your company or in our training facilities

Alteryx Basic Training

Alteryx is a visual workflow tool that combines extraction, transformation and loading with spatial processing. Create and manage workflows and prepare your Data for later visualization.

Content

For beginners in the world of ETL-based data management, the  Alteryx Basic Training is exactly the right starting point. Alteryx allows you to quickly access and transform multiple databases, including spatial databases, to provide geographic business intelligence and address your sales, marketing, or operational challenges.

  • Alteryx Produktübersicht
  • Alteryx Basics
  • Creation of Workflows
  • Managing of Workflows
  • Data Blending
     

General conditions

  • Required prior knowledge: none
  • Duration: 1 day
  • Number of participants (recommended): up to max. 12 persons
  • Location: In-house in your company or in our training facilities

SQL Basic Training

Immerse yourself in the basics of this database language and learn to control the definition of your Data structures independently. Edit and change your Data stocks and implement your individual requirements with SQL.

Content

There are many companies that use large, relational databases, making a basic understanding of SQL a great, applicable skill. Our SQL Basic Training is primarily aimed at beginners who want to acquire the appropriate tools for communicating with relational databases and expand this knowledge.

  • Basics
  • DDL & DML statements
  • Dynamic Query Language
  • Queries over several tables (Joins)
  • Advanced use cases
  • SQL Queries in Tableau

General conditions

  • Required prior knowledge: none
  • Duration: 1 day
  • Number of participants (recommended): up to max. 12 persons
  • Location: In-house in your company or in our training facilities

Unsere Workshops

In addition to our classic training formats, our workshops offer the opportunity to work on content interactively and cooperatively in compact groups and to learn it at the same time - guided and moderated by our experts. The close focus on a topic, aligned to your very special business cases, allows an intensive and instructive introduction to the topic and a high learning curve. 
 

Tableau erleben und verstehen

You have already heard of Tableau, but haven't had the time to apply it yourself? Then you've come to the right place. In our half-day workshops we show you how Tableau works and how it stands out from other analytics products.

Content

You do not have a BI tool yet? Do you have to painstakingly collect numbers and Data from multiple files and reports? Are you struggling with formulas that cannot be updated automatically? Then you should try Tableau. Bring your own Data to our four-hour workshop Tableau erleben und verstehen or let our Demo Data set show you in detail how easy Data analysis can be with the right tool.
 

Agenda

  • 10:00 – 10:30 – Registration
  • 10:30 – 11:00 – Welcome and introduction
  • 11:00 – 11:30 – Hands-on Workshop Part 1
  • 11:30 – 12:00 – Coffee break
  • 12:00 – 13:15 – Hands-on Workshop Part 2
  • 13:15 – 13:30 – Time for questions
  • 13:30 – 14:00 – Lunch

General conditions

  • Required prior knowledge: none
  • Duration: approx. 4 hours (incl. lunch)
  • Location: In our training facilities

Dates 1st Quarter 2020:

  • Dresden: February 5 - 10:00-14:00 (Simmel Center) - REGISTER NOW
  • Hanover: February 20 - 10:00-14:00 (Bürovilla Hannover-Mitte) - REGISTER NOW
  • Berlin: March 4 - 10:00-14:00 (Milastr. 2, Prenzlauer Berg) - REGISTER NOW 
  • Stuttgart: March 5 - 10:00-14:00 (Room 40) - REGISTER NOW
  • Leipzig: 23 April - 10:00-14:00 (IKOME Seminar Centre) - REGISTER NOW

Use Case Development

During this workshop, which lasts several days, an experienced M2 consultant will support you in the implementation of your specific business requirements. This exciting format enables you to learn Tableau and to implement your requirements productively.

Content

Our latest innovation, the Use Case Workshop, is a format that is oriented towards a concrete use case within a company. Over a period of about six weeks, the requirements of the specialist area are analysed, designed and jointly implemented in several joint face-to-face meetings. The content and technical design, total duration and number of on-site visits are agreed upon in detail with you. The format shown here serves as an exemplary option that can be flexibly adapted to your ideas.

Idea & Requirements
  • Use Case Workshop, spread over a period of 6 weeks
  • Workshop is oriented towards a concrete use case of a company or department
  • Participants submit requirements, ideas, data sources and use cases in advance
  • Within the workshop, the M2-Consultant supports the implementation of the requirements of the business unit
  • The user group should be as homogeneous as possible, i.e. the same understanding of the topic and the database
Implementation
  • One joint workshop - Date per week
  • Week 1: Scribble/ Mockup - Clarification: Which business questions should be answered
  • Week 2/3: Data preparation - localisation of any missing Data, possibly integration of the IT department
  • Week 4/5: Reporting - creation of dashboards in Tableau
  • Week 6: Go Live - Productivity of the project results
     
Goals 
  • Development of a concrete result, which is directly productive and usable
  • Experience the complete development process (from mockup to production)
  • Getting to know and deepening of many tableau functions
  • Establishment of continuative, creative ideas for further use cases
  • Creation of interdisciplinary knowledge and understanding

General conditions

  • Required prior knowledge: none
  • Duration: variable (by agreement)
  • Number of participants: by agreement (depending on the use case)
  • Location: in-house in your company

Data Visualization & Dashboard Design

Design Basics, Visual Analytics & Dashboard Creation - in this workshop you will learn the basic principles of visualization, color systems, typography and layout. We show best practices and an 11-step process for Dashboard creation.

Content

Data visualization and dashboard design are naturally among the topics we place the greatest value on in our work with and for our customers. To underline this creative focus of our work, we have created the workshop format Data Visualization & Dashboard Design.

You will learn that the dashboard creation process is not only about choosing the right chart or color, but also about applying clearly defined design principles to make clear statements and ensure usability. We also apply these principles to your in-house reporting within the scope of the shop and optimize the design of your tableau dashboards live and directly. 

  • What is data visualization?
  • Basics of visualization
  • Diagrams
  • Presentation of data
  • The Visual Analytics Process
  • 11 steps: the Dashboard creation process
  • Diagrams

General conditions

  • Required prior knowledge: none
  • Duration: 1 or 2 days (by agreement)
  • Number of participants (recommended): up to max. 12 persons
  • Location: in-house in your company or in our training facilities

Tableau Performance-Optimierung

The performance of your reporting system is the result of the interaction of several components, from the browser to the structure of the Tableau workbooks to the underlying Data sources. Optimize your performance with our expertise.

Content

In the Tableau Performance Optimization you will learn about performance best practices and learn how to analyze and resolve your performance problems. Specific performance optimization techniques and performance monitoring tools will be part of this workshop as well as workbook design, sensible use of filters and calculations or the selection of the optimal hardware for your server. 

  • Introduction
  • Grundprinzipien
  • Tools
  • DatA
  • Queries
  • Data Blending
  • Filter
  • Calculations
  • Environment
  • Performance-Checklist
     

General conditions

  • Required prior knowledge: none
  • Duration: 1 or 2 days (by agreement)
  • Number of participants (recommended): up to max. 12 persons
  • Location: in-house in your company or in our training facilities