- More Info
RED – Rapid Exploratory
Data AnalysisDWH & Smart Analytics
in just a few weeks
RED Benefits at a Glance
Rapid IT Solution
External implementation in just 3 weeks
Transparency
Extremely short lead time – ‘metadata-driven’
Time Efficiency
No programming required, no special modeling
Access Rights
You determine the personalized access to your data – even possible at row & column level!
Architecture
Direct connection to all common IDMs (e.g. Active Directory, LDAP)
Verifiability
Complete audit thanks to historised database
Traceability
100% reproducible reporting “out-of-the-box”
RED Modules
No additional ELT tool and no additional scheduler required: thanks to the ingenious simplicity and automation of the analytics platform, it only takes a fraction of the project lead time compared to before. We're talking days instead of weeks and months instead of years.
All data is historised two-dimensionally, bitemporally. This means that there is a functional and a technical validity period for each data record. This means that the valid version of a data record can be queried at any time and any changes to the data record can be tracked. Seamless historisation is an integral part of RED.
Rule-based, personalized access permissions are part of RED and are activated via simple statements. Each query only returns the rows and columns in the objects that are intended for the respective person. Queries in RED are executed via a view layer, which guarantees this additional, strict level of security.
RED Technology
The basis is a database with massive parallel processing technology. Specifically, an Exasol database. Technically the best MPP technology currently available on the market and absolutely affordable thanks to a fair, volume-oriented license model.
The database is regularly loaded or updated from any data source via RED's highly intelligent loading framework. Source and periodicity are configurable, the only limiting factor is the bandwidth of the network. Existing data structures are adopted largely unchanged. The specialist department works with familiar data structures and there is no need for complex data modeling. If the evaluation tool requires a star schema, this is generated virtually via views.
Find out more in our RED documentation.
Ad-hoc Analyses Down to the Individual Record
Pre-aggregated data is a thing of the past. Thanks to the extreme performance in RED, the business layer is view-based and drilling down to data record level is a matter of course. Data can be queried where the requirements originate: in the specialist departments. This relieves the burden on IT and provides the specialist department with immediate answers to their questions.
See for Yourself!
A PoC (proof of concept) for your new analytics platform only takes a few days with the help of RED. Everything happens on your premises, your valuable data never leaves your premises. Exasol and RED are installed – in a virtual environment or optionally on a (rented) test server. Any data source is connected as an example, the preferred analytics tool is connected to RED and data analysis by the specialist department can begin.
More about RED in the video
Customer Voices
„Thanks to the competent team at Sphinx & the excellent tech stack, it only took us 3 weeks to get the first dashboard in the Management Information System!“
Some of Our Customers
Customer Voices
“Our partnership with Exasol and Sphinx has been game-changing. We‘ve gained the ability to understand and serve our unique audiences in each country while continually elevating the Cineplexx experience. With data at the heart of our operation, we‘re confident in our ability to innovate and grow in the years ahead, no matter what challenges the industry brings.”
Sphinx – your reliable partner
SMEs Can Rejoice –
to More Growth with Sphinx!
Growth means change. Even in the digital sector, development must never stand still. Many small and medium-sized companies face the challenge of keeping up. In-house IT teams are often not an option – too expensive and too complex to train. It is also particularly difficult for SMEs to find qualified IT specialists on the highly competitive job market and to retain them in their own company in the medium to long term.
You can breathe a sigh of relief: Sphinx picks you up exactly where you are – with cost-effective and comprehensive IT support that is specially tailored to SMEs.
Leave the ‘Data Islands’ Behind:
Let's Design Your Visionary IT Infrastructure of Tomorrow!
It's time for holistically thought-out and powerful IT solutions that integrate your existing data and systems and take your company to the next level. With an advanced IT architecture and a comprehensive, functional database, nothing stands in the way of your growth. Think about smooth interfaces, standardized data access and potential for AI-supported automation.
With Sphinx, you gain an overview of all relevant company data & data sources using a central reporting system that provides you with real-time data and fully complies with data protection requirements.
Start-ups, Step Up!
Full IT Service at the Touch of a Button
Data, data, data – but where to put it? At a certain point, data protection and a centralized IT structure are essential. IT should be a support for your start-up growth! Especially in the growth and development phase, an all-round view is essential. Don't lose any relevant data – back it up, store it correctly and use it in the future!
Sphinx accompanies you and your company competently and reliably through the further growth process – as agile and flexible as your start-up!
Our Technology Partners for this Solution
Contact us
MAG. DR. THOMAS PETRIK
Head of Technology Consulting
Sphinx IT Consulting GmbH
+43 1 599 31 - 0
thomas.petrik@sphinx.at