T4D GmbH
SERVICES TEAM PROJECTS CLIENTS CONTACT PORTFOLIO DE EN


What we did

Selection

loading

Topic





Project type




Tools








Development of Microsoft Power BI Reports based on SQL Server


Customer project

Autumn 2023

  • Customer project
  • data
  • Microsoft Power BI
  • Data Analytics Expressions (DAX)
  • Row-level Security (RLS)
  • Power BI on-premises data gateway
  • SQL
  • SQL Server
  • HelpDocs

Dynamic community detection method tracking communities in time window graphs


Research

2021 / 2022

  • Research
  • data
  • Python
  • pyAlluv
  • matplotlib
  • Git

Orchestration framework for IP-Camera


Research

2022 / 2023

  • Research
  • dev
  • django
  • fastAPI
  • nginx
  • ffmpeg
  • systemd

Analysis of voter turnout for the federal elections (Switzerland) in October 2023


open data & community

December 2023

  • open data & community
  • data
  • Jupyter Notebook
  • Python
  • scikit-learn
  • matplotlib
  • JavaScript
  • bokeh.org
  • GitHub

Web application to send emails via Mailchimp Transactional API


Customer project

Autumn 2023

  • Customer project
  • dev
  • PHP
  • CakePHP
  • SQL Server
  • Mailchimp Transactional API (mandrill)

Introduction of a new Point of sale (POS) system incl. payment terminal


Customer project

2023 / 2024

  • Customer project
  • other
  • Luwosoft LS-POS
  • Worldline Yomani
  • JTL-WaWi
  • Microsoft Access
  • SQL Server

Conception and implementation of a reporting solution based on Power BI


Customer project

Autumn 2023

  • Customer project
  • data
  • Microsoft Power BI
  • Data Analytics Expressions (DAX)
  • Power BI on-premises data gateway
  • SQL
  • SQL Server

Implement new API functions incl. automated functional tests


Customer project

2023 / 2024

  • Customer project
  • dev
  • PHP
  • Slim Framework
  • PHPOffice/PhpSpreadsheet
  • Postman

Enhance web application with new functions


Customer project

2023 / 2024

  • Customer project
  • dev
  • JavaScript
  • qooxdoo.org
  • Visual Studio Code
  • Subversion (SVN)

Power BI sample report with surf spots in Portugal


open data & community

January 2024

  • open data & community
  • knowhow
  • Microsoft Power BI Desktop
  • Data Analytics Expressions (DAX)
  • Sphinx documentation
  • GitHub

Working With Git - A practical guide for the usage of git


open data & community

2023

  • open data & community
  • knowhow
  • Git
  • GitHub
  • Sphinx documentation

New website for a small company


Customer project

February 2024

  • Customer project
  • other
  • WordPress
  • WordPress Theme
  • WP Pusher
  • Smash Balloon Social Photo Feed
  • Elementor
  • CSS
  • JavaScript

Connect Google Distance Matrix API


Customer project

April 2024

  • Customer project
  • dev
  • PHP
  • Google API
  • SQL Server
  • Power BI

Customer project

Business case

Improving business efficiency by getting a better overview of key financial figures.

Description

  • Collaboration in conception
  • Data preprocessing
  • Creation of reports and visualizations
  • Programming of KPIs
  • Implementation of Row-level security
  • Daily data refresh
  • User manual

Tools

  • Microsoft Power BI
  • Data Analytics Expressions (DAX)
  • Row-level Security (RLS)
  • Power BI on-premises data gateway
  • SQL
  • SQL Server
  • HelpDocs

Research

Idea

Analysis and visualization of research data

Description

This Open Source Python package implements the dynamic community tracking algorithm MajorTrack.

Tools

  • Python
  • pyAlluv
  • matplotlib
  • Git

Links

Research

Product

Orchestration framework for IP-Cameras

Description

  • Development of a modular two-layered LAN structure for segmentation of IP-Cameras
  • Implementation of a robust, low-level streaming process featuring complex scheduling
  • Development & Deployment of a web application for centralized management

Tools

  • django
  • fastAPI
  • nginx
  • ffmpeg
  • systemd

open data & community

Idea

Analysis of public data for a better understanding of voting behavior.

Description

  • Get data from several public data sources, standardize it and prepare it for analysis (preprocessing)
  • Descriptive analysis
  • Data visualization
  • Create interactive plots
  • Regression analysis
  • Mediation analysis

Tools

  • Jupyter Notebook
  • Python
  • scikit-learn
  • matplotlib
  • JavaScript
  • bokeh.org
  • GitHub

Links

Customer project

Business case

Allow sending in a easy way according the corporate design

Description

  • Requirements analysis
  • Concept of the solution
  • Prepare the data
  • Develop the web application

Tools

  • PHP
  • CakePHP
  • SQL Server
  • Mailchimp Transactional API (mandrill)

Customer project

Business case

Improve customer service and sales process.

Description

  • Install and configure a new Point of Sales System (POS)
  • Install and connect payment terminal (POS-integrated)
  • Data storage in a hosted SQL database
  • Install and configure a merchandise management system

Software & Tools

  • Luwosoft LS-POS
  • Worldline Yomani
  • JTL-WaWi
  • Microsoft Access
  • SQL Server

Customer project

Business case

Getting a better understanding of business processes

Description

  • Requirements analysis
  • Solution concept
  • Prepare data
  • Implement reports
  • Regular data updates

Tools

  • Microsoft Power BI
  • Data Analytics Expressions (DAX)
  • Power BI on-premises data gateway
  • SQL
  • SQL Server

Customer project

Business case

Implement new functions in an existing API (backend software) according to business requirements and ensure long-term functionality

Description

  • Migrate software from PHP7 to PHP8
  • Optimize API functions
  • Implement new API functions
  • Automated Functional Tests

Tools

  • PHP
  • Slim Framework
  • PHPOffice/PhpSpreadsheet
  • Postman

Customer project

Business case

Further develop existing web application according to business requirements

Description

Implement new functions and improve usability for an existing JavaScript-based web application.

Tools

  • JavaScript
  • qooxdoo.org
  • Visual Studio Code
  • Subversion (SVN)

open data & community

Idea

We love to share our knowledge. In this tutorial, we explain a few concepts that have proven useful in practice.

Description

To illustrate the concepts, we created a multilingual report based on a public data set with Power BI Desktop. The report shows 129 surf spots in Portugal on a map. All files and information are publicly available on GitHub.

Tools

  • Microsoft Power BI Desktop
  • Data Analytics Expressions (DAX)
  • Sphinx documentation
  • GitHub

Links

open data & community

Idea

We love to share our knowledge. This is T4D’s practical guide for professionals and hobbyists that want to learn [more] about the usage of git and DevOps software like GitHub and GitLab to develop, track and secure their digital projects.

Description

On the linked GitHub Page, we describe important concepts of Git and how they are used in practice.

Tools

  • Git
  • GitHub
  • Sphinx documentation

Links

Customer project

Business case

New website for a small company

Description

  • Set up new web hosting
  • Install WordPress 6 incl. plugins
  • Connect the Instagram account
  • Customize theme according to customer needs
  • Adding content (images and texts)
  • Migrate email inboxes to new hosting

Tools

  • WordPress
  • WordPress Theme
  • WP Pusher
  • Smash Balloon Social Photo Feed
  • Elementor
  • CSS
  • JavaScript

Links

Customer project

Business case

Enrich address data with coordinates and travel distances (car/public transport) to optimize the planning of customer projects.

Description

  • Set up API projects on the Google Developer Console
  • Implement a Google API client
  • Enrich data in the database
  • Visualize the data on a Power BI Map

Tools

  • PHP
  • Google API
  • SQL Server
  • Power BI