B.i.TEAM Society for Software Consulting mbH

Through our Qlik Sense training concept, we impart our knowledge to power users, key users and consumers. In this way, we ensure that our customers are methodically and technologically able to work independently of service providers in the short and medium term.

We want to bring innovation into the companies through projects and ensure through knowledge transfer that this innovation is transferred into the operational and applied.

• Conception and design of a data target image with the aim of professionalising the reporting landscape
• Requirements Elicitation
• Definition of design principles
• Market analysis of possible tools & tools for data processing (Azure, AWS, Snowflake, Talend)
• Visualisation of the target architecture
• Creation of a roadmap for implementation

Through our Power BI training concept, we impart our knowledge to power users, key users and consumers. In this way, we ensure that our customers are methodically and technologically able to work independently of service providers in the short and medium term.

We want to bring innovation into the companies through projects and ensure through knowledge transfer that this innovation is transferred into the operational and applied.

Challenge:
Within the framework of financial planning, data had to be prepared and analysed manually on an annual basis in order to create a basis for the planning of the following year.

Solution:
Replacement of an outdated planning software and associated design of a new planning process with the aim of uniting several components:
Analysis of past financial planning
Simulation & planning of future financial plans

Data and tools:
- SAP (ERP)
- Qlik Sense

Added values:
- Automation
- Simple and fast execution of a wide range of financial simulations
- Time and cost saving

The Tuttlingen District Office is a municipal authority
of the Baden-Württemberg district and
at the same time a lower state administrative authority with a wide range of different functions. A
of the Authority's total of 23 administrative units
is the district forestry office, another is the communal
Timber sales point.

The initial situation:
Its tasks include, among others, the management of the non-state forest from an economic point of view. This includes the production, harvesting and marketing of timber.
and by-products. The forestry office is responsible for 150,000 solid cubic metres of timber, which are recorded by 19 forest rangers using mobile terminals according to tree species, length, diameter, intended use and geo-coordinates. The sales office then takes care of marketing to around 35 customers in the timber and damaged timber industry. These include companies from the sawmill, packaging and paper industries, the construction sector as well as private individuals.
Thomas Storz, Head of Timber Sales, Tuttlingen District Office, comments: "The entire flow of timber from the forest to the customers according to their contractually agreed delivery quantities and dates is coordinated by us the solution is easy to operate and maintain. We have to ensure that customers are supplied with the desired quality and quantity of timber on time." Accordingly, it is important for the sales office to have a complete overview of the timber flow. "Until now, we only had limited possibilities to compare the contract data with the data from the forest recorded by the forest rangers on mobile devices. In addition, the manual effort involved was too high," Storz continues.

The solution:
ithin the framework of the tendering procedure customary in the municipal sector, the Qlik solution provider B.i.TEAM Gesellschaft für Softwareberatung mbh from Karlsruhe was awarded the contract for the realisation of the
project and a training of the staff. Through
Storz's preparatory work during the test phase led to the Qlik applications going live.
within a few days. Areas of application and benefits
Customer data is analysed, as well as the data collected by the
information on the timber lots ready for marketing. Since the technical procedure does not
allows this data to be transferred directly from the database into Qlik, the timber sales office is
daily the relevant data in .xls format by e-mail
sent to a specific mailbox from which the
file is then automatically retrieved and stored in Qlik
is read in. Three dashboards are now in use: The areas of contract/supply, timber flow and strategy and planning are displayed. "With QlikView, I can see immediately what the delivery status of the individual contracts is," says Storz. "In the past, to get the same information, I had to read three or four reports that were not in context with each other and then interpret them.
Now I can click on each individual supply contract
and immediately see the status. We can now also inform our customers directly if we have any queries, without
to have to painstakingly search out figures first. "The
He estimates the time saved for the analyses at around 70
percent. Also with regard to the variety of analyses
the timber sales office, as Storz reports.
"We have more flexibility than before. Go to
For example, we can retrieve information on which
Customer supplied when, which precinct supplied
and which has not yet, as the overall delivery rate
or the quota is by purpose."

More info:
https://www.biteam.de/share/downloads/referenz_qlikview/b.i.team-referenzbericht_forstamt_tuttlingen

Development of a BI infrastructure. Recording the requirements of the production and sales departments for a modern analytics solution based on their operational activities. Technical implementation on
Basis of Microsoft Power BI. Conducting training courses for Power users to impart knowledge about the creation, administration, further development and provision of data models, analyses and visualisations.

Challenge:
There is currently no analysis of the data collected in either area. There is a need to develop and provide precise analyses.

Solution:
- Consultation and requirements assessment of the departments
- Presentation of Power BI
- Provision of central data models and self-service BI structures
- Knowledge transfer and empowerment of the departments

Tools:
- NAV/BC (ERP) SQL database
- Power BI

Added values:
- Automation & time saving
- More efficient and faster data analysis
- Higher data quality
- More consistent data
- Better transparency about the processes

• Creation and optimisation of a machine learning model to predict order development, taking into account various influencing factors (previous order behaviour, public holidays, weather, marketing campaigns, etc.)
• Automatic calculation and integration of the results into the existing business intelligence infrastructure (Qlik Sense)

• Mainly responsible for setting up an analytics infrastructure with the help of Microsoft Power BI
• Connection of data from Microsoft NAV / Business Central and Google BigQuery with the Power BI Dataflows
• Preparation with Power Query and M
• Calculation of KPIs in DAX and R
• Provision of appealing reports/dashboards for the marketing and sales departments
• Communication and control of management contacts
• Other data sources: SharePoint, SQL DB, Excel

Through our Power BI training concept, we impart our knowledge to power users, key users and consumers. In this way, we ensure that our customers are methodically and technologically able to work independently of service providers in the short and medium term.

We want to bring innovation into the companies through projects and ensure through knowledge transfer that this innovation is transferred into the operational and applied.

As an infrastructure and energy service provider, the
Stadtwerke Schwäbisch Gmünd GmbH ensures the basic supply in the Schwäbisch Gmünd region.

Around 32,000 industrial, commercial and private customers
use products and services in the areas of electricity, gas, water, heat and telecommunications. The municipal company employs
approx. 160 employees.

The Basic Planning Department of Stadtwerke Gmünd,
responsible for technical controlling, regularly prepares a comprehensive cost accounting report for senior staff in the networks division. However, the preparation of this report was associated with some hurdles, as Tiffany Barlow from the Policy Planning Department at Stadtwerke Schwäbisch Gmünd GmbH reports. "We
use SAP as their ERP system. Since I did not have any evaluation options directly in SAP, I had to extract the necessary data from the SAP modules for cost accounting in Microsoft Excel and link them to corresponding background files in order to be able to create the desired evaluations. This procedure was cumbersome and time-consuming. Especially at the beginning of the year, when a lot of large invoices are posted, I sometimes had to start new evaluations every day to keep the figures up to date.
hold - but took two working days to complete the report."

Solution quickly in sight:
Driven by the specialist department, IT has focused on the
search for a suitable solution in order to be able to
data provision and analysis faster and more efficiently. "We first investigated whether we could extend the standard SAP functions," reports Thomas Lange, IT coordinator at Stadtwerke Schwäbisch Gmünd GmbH. "However, it quickly became clear that this was not the right way to go." Instead, a business intelligence solution that can automatically read in and analyse SAP data was to provide a remedy. Which one was clear to Lange very quickly: "I had already worked with Qlik solutions in the past and got to know them as a very flexible, powerful tool that is also very manageable. That's why I introduced Qlik Sense to the specialist department. And after Ms Barlow's eyes lit up as well, the matter was decided."
The self-service data visualisation software Qlik Sense was particularly convincing due to its high flexibility in terms of connectable data sources and the uncomplicated ability to analyse data down to the detailed level.

The right choice of partner with B.i.TEAM:
As an IT partner for the project realisation, the
Stadtwerke Gmünd the Qlik solution provider B.i.TEAM
from Karlsruhe on board. "In a joint 3-day workshop, both the product and the partner were convincing," says Lange. "After this short period of time, the first version was already ready. It paid off to have a partner with solid SAP and Qlik know-how.

The data connection is made via the certified SAP SQL Connector from Qlik. The modules required for cost accounting are connected. Data from the last ten years is imported - this corresponds to around four million accounting documents. The data is updated daily.

Field of application and benefit:
The network report created with Qlik Sense can be accessed by division, department and team leaders. Cost centres and orders are displayed. Employees have information at their disposal that shows them where they stand with their investments (what amount is left on the cost centre, what amount was actually spent) and how much they have invested compared to the planned expenditure. In case of deviations from the plan, they can
users can call up more in-depth information on the cost drivers. "To see at a glance what the current status is, the entry figures are visualised via speedometers," Barlow explains.

More info:
https://www.biteam.de/share/downloads/referenzsap/b.i.team-referenzbericht-stadtwerke-schwaeb.gmuend-FINAL

An analysis was provided for ticketing and stadium security, which enables the specialist departments to improve matchday planning, spectator satisfaction and the security situation in the stadium.

By providing an interactive analysis report in Microsoft Power BI, which combines historical ticket sales and live access data on match day (IoT data: scans at the stadium entrance) and visualises them in an easy-to-understand way in the form of a stadium map, stadium security can precisely allocate stewards and security staff in advance of the match. On the day of the match itself, it is then possible to react flexibly to the access situation at entrances, blocks and seats by moving security staff around. Ticketing can use the analyses to understand which people have stayed away from the matches in order to select suitable marketing approaches.