QlikView in GC "Aeroclub": Atom - interactive platform for analyzing forecasts and reports
ATK
Power BI
QlikView in GC "Aeroclub"
.png)
Company:
"Aeroclub"
Industry:
Other
Functional areas:
Product:
Power BI
About the client company:
Aeroclub Group of Companies has been providing a full range of services in the field of business tourism for more than 20 years. The business is based on reducing corporate costs and providing the best service.
Aeroclub Group of Companies is rightfully recognized as an expert and market leader due to many years of experience, highly qualified specialists, unsurpassed level of service and investments in its own IT-development. Aeroclub, forms market standards based on the experience of long-term relationships with thousands of large corporate clients from various business spheres. Since 1995 Aeroclub has been a member of IATA and since 2004 an exclusive partner of the global network of BCD Travel in Russia.
Project Objective:
Development of a clear interactive visual business intelligence platform for the Business Travel market with the following characteristics:
-
Availability of an accessible web-interface
-
Shared access rights
-
Possibility of online analysis and forecasting of travel expenses for corporate clients, Benchmark with other market participants.
-
Possibility of independent modeling of travel policy with the help of advanced tools
-
Travel management data management for analysis of any depth
Solution:
Consulting Group developed the ATOM platform for Aeoclub Group based on Microsoft technologies - Power BI, Microsoft SQL Server, SSIS, SSAS. The integrated BI-system Power BI collects data from Front and Middle Office databases, from numerous corporate directories, external Internet sources, analyzing more than 14.3 MLN records of transactions aggregated by AeroClub for 10 years.
Users of the ATOM platform based on Power BI:
-
Corporate clients of Aeroclub Group
-
Business Travel market analysts
-
Communication agencies
-
Client department of Aeroclub
The most popular reports:
-
Travel Expense Optimization Reports
-
Internal management and accounting of travel expenses for the period with the possibility of detailing each individual trip
-
What-if analysis for modeling travel policy and expenses, calculation of potential savingsBenchmark: industry and market slices regarding key business indicators of the client's company.
ATOM platform:
-
Allows you to analyze and forecast travel spending in real time
-
Gives access to information at any convenient time
-
Has no limits on the amount of data to be analyzed
-
Has a client interface with separate access rights
-
Enables what-if analysis and benchmarking with other market participants
-
Allows you to create impressive visualizations on your own
Data Sources:
-
Front and Middle Office transaction databases of Aeroclub Group of Companies,
-
corporate directories,
-
external Internet sources
Results in numbers:
man-hours
2500
automated workstations
100
Results in numbers:
-
2500 man-hours
-
100 automated workstations
-
More than 14.3 million lines of transaction records
-
From the traditional static reports in excel, pdf, pptx format to dynamic online reports based on Power BI.
Screenshots of the solution:
Testimonial:
"Instead of fixed, static reports, the client is provided with a unique online platform, with the help of which it is possible to independently and in real time model the travel policy of a campaign, moving among different levels of data - from totals for the period to details on each individual service. The project is unique in that it is intended for external users who, taking advantage of ATOM capabilities, can make business decisions more efficiently, get statistical slices, test hypotheses and compare their data with other market and industry participants. At the same time, the solution created on the basis of Microsoft technologies, in particular Power BI, fully complies with data security regulations"
Director of IT, Aeroclub.
ЯКОВ ЛЬВОВИЧ ГОЛЬДФАРБ
Presentation
+7 (495) 134-32-92
consult@atkcg.ru
Russia, 121467, Moscow,
Istrinskaya str. 4, Office 1
Company News
subscribe to our newsletter
