Our Solutions For Your Problems
From a high-performance web application
to a highly complex data warehouse system:
the following specialized areas provide an overview
of our extensive range of skillsets and core competencies
based on projects deployed.
Modern and high-performance applications tailored to meet the specific needs and system requirements of our clients - from user-friendly mobile APP's to complex, customized web applications.
Implementation of a Single-Point-of-Entry platform with integrated Authenticated Management for an array of applications with a refined user management administration and personalized user-friendly workflow or implementation of a customized responsive Reporting dashboard.
Implementation of a Winforms Management application that can be adjusted on asset level to incorporate a flexible user management administration, generated to exceed the clients highest expectations.
MOBILE AND APP DEVELOPMENT
Implementation of a user-friendly iOS app for surveys and evaluation reports including dedicated Web Services for data consolidation.
Application integration in the client‘s existing IT infrastructure, addition of new functionality and integration on the live server, based on the terms agreed in the Service Level Agreement.
Data Management and Analytics
For decades collecting and managing data continues to be one of the most important systemic processes in every progressive company. In order to make good use of this data, structured data warehouse systems and sophisticated analytics are necessary. This is how we transform "Big Data" into "Smart Data".
DATA WAREHOUSE DESIGN AND DEVELOPMENT
Design and development of data models for Data Warehouse systems in AWS Redshift and SQL server. Analysis and optimization of data models realized by normalization and indexing.
CONCEPT AND IMPLEMENTATION OF ETL PROCESSES
Implementation of SSIS Packages for consolidating data from different sources (Oracle, MySQL, Excel) in a SQL Server database. Data Storage (>100GB) in AWS Redshift including data cleansing and performance optimization.
IN-DEPTH DESIGN AND ANALYSIS BEST PRACTICES FOR DATA PROCESSING
Cost analysis with a SQL Server.
HR KPI data aggregation and calculations using Alteryx.
Revenue analysis using Redshift.
INDIVIDUAL DATA ANALYSIS CONCEPT AND ANALYTICAL TOOL TRAINING
Preparation of training concepts and hands-on training held for: “Introduction to Big Data”, ”Programming with Python” and all Microsoft Office products.
Tableau, QlikSense, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, SQL Server, Integration & Reporting Services, Oracle, Alteryx, Quicksight, Redshift, Elastic Map Reduce, Machine Learning (AWS), Machine Learning (Azure), Python & Tools (Anaconda and Jupyter Notebooks)
Microsoft Office Development
As a Microsoft Silver partner we have been utilizing the latest Microsoft technology and techniques to develop applications based on Microsoft Office programs, in order to simplify work processes. Most of these processes can be completely automated and have since been realized for dozens of clients worldwide.
AUTOMATED PROCESSES / TOOL DEVELOPMENT
Implementation of a complex and user-friendly VBA driven project management tool using Excel templates for data entry, MS Access for data consolidation and PowerPoint to generate reports automatically.
Implementation of an Excel application for continuous data cleansing and single use for specific tools to download and consolidate hundreds of PDF’s.
Implementation of Microsoft Outlook forms to extend the functionality of calendar entries. PowerPoint Add-in integration containing multiple convenient functions for easy use and operation.
TESTING AND QUALITY ASSURANCE
Application compatibility testing in a designated test environment with Office 2007, 2010, 2013 and 2016 (32/64 bit, DE/EN). Performance monitoring and optimization.
Microsoft Visual Studio, Microsoft Excel, Microsoft PowerPoint, Microsoft Outlook, Microsoft Word, Microsoft Access, Microsoft Project, Microsoft Visio
Reporting and Visualization
Reliable reporting and monitoring of multiple KPIs are an integral part of modern management. We help clients keep control of their data and provide a clear overview with visual compelling KPI dashboards. Deployment of web-based solutions is popular with clients, enabling them to access dashboards and data anywhere and at any given time.
CREATING DASHBOARDS IN TABLEAU
Concept development and design, implementation, test and deployment of a global web-based Project-Tracking (PMO) and Reporting Tool, providing a comprehensive visual and tabular layout and KPI reports.
MS OFFICE HYBRID SOLUTIONS
Having deployed hundreds of visual reports and KPI dashboards over the past 10 years this has developed into one of our core areas of expertise, primarily developing user-friendly Hybrid solutions in Excel, ThinkCell and PowerPoint.
WEB APPLICATION DEVELOPMENT
Implementation of easy-to-use, multi-level KPI Dashboards with first class visual effects realized with DevExpress Web-Forms.
Tableau, QlikSense, Microsoft Excel, Microsoft PowerPoint, Visual Basic for Application, Thinkcell, Power Pivot, SQL Server Reporting Service, BIRT Reporting, Winforms, Webforms, Photoshop