Superbly designed reporting clears the path for
growth and success

Practically every company uses some kind of sophisticated reporting nowadays.
However, setting up a reporting system is not so much about the tools you use as
it is about the knowledge that can be gained and the design of the reports, so
you can unleash their potential and make better decisions to drive your
company's growth
and outperform your competition

There are many Business Intelligence and reporting tools on the
market, a veritable smorgasbord of offers ranging from simple applications for
ad-hoc queries to sophisticated platforms that run the gamut of reporting tasks
and related areas.

Reporting & BI tools should serve as a means to an end. The tools
themselves must be designed correctly so that the reports and dashboards are
truly effective and the settings are a direct reflection of experience and
knowledge. Only such reporting can help you make better decisions and spur
corporate growth.

Intelligence is one of the fastest growing software markets. Gartner predicts
this market to exceed 17 billion USD by 2016.

Our verified tool

SAP BusinessObjects BI Suite

Let your people have access to the BI tools to visualize data. Meet your BI
needs and improve the business acumen of your entire organization.

The BI Suite lets organizations take the lead when quick and
effective decisions are made by the right people – managers, analysts,
suppliers and partners – receiving the right information at the
right time.

The BI Platform features an integrated and flexible
environment for data processing and information sharing. Users reach remarkable
results by processing data on a larger scale and transforming the data into a
more comprehensive form to provide outputs based on reliable data processed in
real time. Key users will have a complete overview of the performance of
individual departments and business results of the entire company. IT
departments will enjoy easier implementation and optimized usage of
infrastructure and sources with fewer demands made on both administration and
operational management. Integration onto the BI platform gives users the
opportunity to access, combine and connect various data sources from your
company's appli­cations.

Microstrategy

Microstrategy is an advanced BI solution for companies of all sizes
in various business areas. It is one of the leaders in the Gartner Magic
Quadrant for BI tools, and is constantly strengthening its
position.

The Microstrategy BI platform affords you the option of creating
well-designed charts and spreadsheets for reporting, score cards and using
interactive panels (dashboards). It enables the usage of advanced, predictive
and OLAP analyses. Thanks to ROLAP (relational OLAP) technology, you can monitor
all corporate data, thereby letting you analyze a variety of data sources
including Hadoop. Moreover, you may connect to the platform from other client
applications, such as MS Excel amongst others, thanks to an adapter.

The Microstrategy desktop application gives developers access to the full
range of resources across the platform for the development of analytical objects
(metrics, attributes, filters). Consequently, these can be used anywhere in
different contexts and without the risk of inaccurate results.

The Microstrategy web interface allows users both interactive work with
reports (drilling, pivoting, formatting, sorting), along with the option of
creating filters, including definitions and metrics.

The Microstrategy administrator is an interface for the administration of
enterprise-wide BI solutions on this platform which manages users and their
access in addition to security rules in all environments (developing, testing,
production).

Microsoft SQL Server Reporting Services is a complete server
platform for reporting. The benefits of this application are that it:

is server orientated

includes services, tools and API for the creation, central
administration and delivery of reports

supports traditional as well as interactive reports

is integrated for various types of structured data (relational,
hierarchical, multidimensional)

is scalable, expendable, and can be inserted into other applications,
intranets and portals.

Microsoft SQL Server Analysis Services is a set of tools for
real-time data analysis (on-line analytical processing – OLAP) and Data
Mining. It incorporates a powerful server for the construction and maintenance
of multidimensional data cubes ( a method for arranging and saving data) for
on-line analysis and providing clients with fast access to the data thanks to
reports or the well-known MS Excel application.

This technology:

is very efficient

is a flexible, user-friendly data model

is now equipped with two models (tabular and multidimensional)

is scalable

is fully integrated with other components of the Microsoft SQL Server
platform

allows you to use well-known tools (MS Excel) for acquiring decision making
data.

Adastra helped to implement and fully use these technologies for numerous
customers. Among the most noteworthy were the implementation­s for:

Ahold Czech Republic (retail, a large amount of data
including individual receipts, wide implementation among users)

Customs Office of the Czech Republic (a very complex data
model featuring the integration of a large number of data sources)

Melita (a Maltese telecommunication operator having a large
amount of data with a complex data model)

CME (a media company, a complex and flexible data model
including integration of accounting data of a number of companies, fast data
processing including uploading, processing, storage in a relational database as
well as projecting into OLAP cubes – near on-line)

Our verified tool

Microsoft Power BI & MS Excel

Microsoft Power BI is a self-service BI technology implemented into
the well-known MS Excel environment

Microsoft Power BI belongs to the self-service BI technologies
family. It provides a very effective tool for analysts and other users as it
enables them to assemble and model data in such a way that they can mine
required information from it in real time and without direct support of the IT
department.

Integration of the entire technology into the familiar MS Excel environment
markedly decreases the demands for training and understanding of the entire work
process. The result is an incredibly fast and simple implementation of these
technologies that can often be done without needing any IT support.

The cornerstone of this technology consists of the following
components:

PowerPivot

PowerQuery

PowerView

PowerMap

PowerPivot is a tool for assembling, modeling and
consolidating data from various data sources. This is advantageous when compared
to Excel, as the number of uploaded entries is unlimited. The technology used
allows data analysis in the operational memory and the option to use all
computer processor cores enabling high-speed data processing and rapid data
access, easy data transferability inside the pages as well as the option to use
common Excel tools.

PowerQuery is an ETL (Extract, Transform, Load) tool for
modifying, combining and cleaning data from various types of sources
(relational, structured, partially structured and non-structured data). It can
download data from various sources and, apart from standard databases, offer the
option to import from files (of various formats) from the web, Sharepoint,
Odata, Cloud (Azure), Hadoop (HDFS, Hive), Active Directory, Exchange and
Facebook.

PowerView is an interactive data explorer tool for creating
interactive reports. Compared to Excel it offers new ways of displaying data, in
metrics or chart, in particular when displaying development through
visualization over time. Moreover, it displays geographical data simply on a
map. PowerView reports can then be uploaded into Sharepoint where they remain
interactive and can thus be shared among users.

PowerMap is, up to this point, the latest tool that allows
enhanced data display into a map according to geographical classification. It
enables data to be displayed in several layers at the same time and for
development to be shown in real time on a map. It allows video sequences to be
created and shared.

Adastra has implemented Power BI technologies for its customers to use to
beat their competition thanks to timely and easy tracing of information needed
for managerial decisions.

Our verified tool

Cognos Reporting

Quality reporting guarantees effective management. We afford you a fast,
clear, consolidated view of all data and information.

Cognos BI is one of the most advanced tools for reporting that
comprises:

Real-time monitoring – monitoring of events in real
time, such as fraud detection amongst others.

Report developing in Congos is intuitive. Reports are
created by using an internet browser mostly by the ‚Drag&Drop‘
method.

Report Studio:

Creates professional reports

Includes tools for advanced users

Combines various objects

Has multiple data sources

Used advanced visualizations and formatting

Has its own SQL/MDX

Features filters, calculations

Has the option of setting parameters

Includes various output formats

Is database operational

Advanced Workspace:

Fast, easy reporting

Intuitive Ad-hoc analysis

Shares resulting reports

A tool for business analysts

Various types of objects

Visualization and formatting

External data sources

Filters, calculations

Various output formats

Reports can be further developed in Report Studio

Workspace:

Tools for creating dashboards

Fast, easy, flexible

Simple designed reports

Re-uses existing objects

‚Drag & Drop‘ access

Comments, sharing, ‚collaboration‘

Filters, calculations

Data updating

Option to change dashboard display features

Our verified tool

Oracle Business Intelligence Enterprise Edition (Oracle BI EE)

Create dashboards, send out reports. Use KPIs and scorecards to monitor and
optimize the performance of your organization.

Oracle Business Intelligence Enterprise Edition (OBIEE) is a set of
Business Intelligence tools that lets you integrate data from various sources
and provide centralized access to corporate information. It runs on an Oracle BI
server to administer metadata and offer high scalability. OBIEE tools allow
integrated data to be analyzed over this server.

The key components from the end users' point of view, including managers,
data analysts etc. such as manager, data analyst etc. are:

Oracle BI Answers

Basic OBIEE analytical tool where ad-hoc analyses are created courtesy of the
metadata provided from the BI server. The user (analyst, reporter) creates
reports and is fully screened from the business logic which is separately
maintained and managed by the metadata administrator. Analyses are created
intuitively by the ‚Drag & Drop‘ method and results can be saved, shared
with other users or placed on a dashboard as shown in the Oracle BI Interactive
Dashboards below.

Oracle BI Interactive Dashboards

Dashboards are graphical interfaces that display information. Users work with
live data in the form of tables, contingency tables, charts, KPI indicators,
etc. You can move among the dashboards, drill for detail, filter or export their
content. It is a standard managerial tool.

A fully autonomous tool with its own data sources (SQL query, XML, CSV, XLS
etc.) providing a complete solution for generating and distributing reports
within an organization. Reports can be published via various channels (email,
fax, WebDav, FTP), generated at regularly schedule times and saved in various
formats (MS Excel, PDF, interactive HTML) while using predefined templates.

Adastra played a key role in the implementation of Oracle Business
Intelligence in Equa bank which now relies on Oracle BI Publisher to distribute
reports.

Our verified tool

QlikView

QlikView represents the new generation of BI tools that places the user at
the forefront of the entire BI solution by enabling the user to create
split-second ad-hoc analyses and detect hidden errors in the data.

BI tool QlikView, an innovative product from the American company
QlikTech, boasts a number of essential features that support fast and
effective decision making within all types of organizations.

Associative analysis

Storing and linking data enables you to browse data and search much like an
internet browser. It is an extremely intuitive environment and provides you
with the option of working with data in new ways so that semantic
interconnections let the user quickly move from aggregated data to specific
transaction details. You no longer have to merely react to reported results.
Instead you are now able to identify the underlying causes and react to possible
problems long before they actually occur.

Self-service Business Intelligence

No longer is the user a mere passive recipient of reports. The roles of
developer and analyst now intersect in what is known as business user 2.0,
someone who adjusts reports, creates new insights and shares them immediately
with colleagues. This new user is thus involved in the entire process of
creating a BI solution and can precisely specify its requirements based on data
sources, provide feedback and inform colleagues while significantly saving
costly IT resources.

In-memory data saving

The data used by the QlikView tool is saved directly in the memory by a
patent protected method. QlikView does not save the data into a database,
therefore the developer can fully focus on the semantic interconnections of the
data to decrease the time it takes to deliver results to end users
dramatically.

Integration

QlikView is a software that integrates the ELT tool, OLAP module as well as
the presentation layer. Therefore, everything is out-of-the-box and ready for
development and work.

User collaboration

The QlikView Server is the place where users can choose to cooperate, share
their experience and work results while working with reports. The QlikView
Server platform distributes information to all users in a centralized way,
while, at the same time, providing ample opportunities to determine levels of
rights of all users flexibly to ensure the ultimate efficacy of all work
associated with the information.

Our verified tool

Oracle Endeca Information Discovery

Oracle Endeca Information Discovery lets users actively discover new
unexpected knowledge and dependencies in their data through a device designed
‚data discovery‘.

Oracle Endeca Information Discovery is an enterprise platform for
self-service data discovery. Simply put, it employs agile analytics on
relational and non-relational data sets and follows this up intuitively
discovering hidden information to give users tremendous advantages as they can
interpret market trends and anomalies earlier than ever before.

Endeca expands upon conventional BI solutions by making them more dynamic and
offering greater development potential allowing users to derive competitive
advantages previously unseen. Endeca lets users easily import, integrate and
interconnect data from various data sources, such as databases, files (JSON,
Excel etc.), web pages or, for instance, Oracle BI reports, and visualize
established results in a snap while revealing all hidden associations that need
to be identified and influenced in a timely fashion.

Endeca, true to its name (from the German word „to discover“) used
‚faceted search‘ where data analysis is managed from a user point of view
by groups of classification filters. Internal data warehouses are built on a
highly flexible data model which can save structured, semi-structured and
non-structured data into one data model at the same time.

As you would expect, Endeca provides complete support for text analysis. The
most suitable hardware platform for running Endeca is the Oracle Exalytics
In-Memory Machine that can also be used for other analytical and reporting
applications, such as Oracle Business Intelligence further guaranteeing top
performance and scalability.

Reporting.cz

This comprehensive cloud-based application processes the complete reporting
cycle for companies – from data collection, including its transformation and
storage in the data warehouse (DWH), to presenting end users with clearly
defined roles and access rights.

Multiple sources of data are easily integrated, regardless of type and
physical location and all of this without any infrastructure. The entire
solution enables the customer to manage, maintain and guarantee its performance
or we can train users or the IT department so that the customer can run the
application independently. The application can be immediately implemented for
projects and customers who are not starting from scratch.

Reporting.cz has ready-made data models available that can be customized and
adapted to the specific needs and instructions of principal users. Data models
are highly flexible in terms of content, framework dimensions, indicators and
demands for visualizing data. The reporting models can be used throughout the
company in the financial division, in sales and marketing, in logistics or HR
(for monitoring employee satisfaction).

How Reporting.cz works

The customer uses Uploader, a client agent which ensures data is uploaded to
the cloud over a secure channel and puts full control of data access and data
sources in the hands of the customer. Before being uploaded, and subsequently
leaving the customer network, data is automatically adjusted, anonymized, and
aggregated according to required details.

The processing, integration and validation of the data is done by
Reporting.cz's own ETL (Extract, Transform and Load) module that records and
stores data in the DWH in the cloud.

Users access data and reports in the cloud through a web browser interface in
your computer or mobile device. Data and reports can also be presented online in
an ordinary setting, such as MS Office, a website, or if necessary, an ERP
solution of the customer.

Rapid implementation

Thanks to its simplicity, flexibility and comparatively minor input
requirements, more complex templates can be tailored to suit the
customer's needs in terms of content and access rights. Creating a reporting
connection can be done within a few days.

Minimal technical requirements

Reporting.cz minimizes the technical requirements of the customer with the
cloud solution ensuring operations run smoothly, freeing you from the added
responsibility of building a new system or your own DWH. Similarly, you needn`t
worry about maintenance or management costs, or any transition to a new ERP
system. Everything is done for you and arranged by the database in the cloud
which provides the data and all relevant information for authorized users. The
solution is independent of the technical infrastructure, location and your
current ERP system. In the event that a company either does not use an ERP
system or has just started to use one, you can temporarily enter data manually.
Simply connect to the Internet, login and the reporting revolution
can begin.

High security

Protecting your data is of paramount importance for Reporting.cz which is why
we rely on multi-level data security:

Data is subjected to anonymization techniques before being sent from the
customer's network

An SSL certificate is required to transfer data to the cloud and create a
secure channel

The data can only be accessed by authorized users

All communication is encrypted and authenticated

Access to technology on the hosting provider is strictly limited to select
individuals

Accessing a server that monitors your history requires the user to log in,
with the level of rights limited to tasks specified by the responsibilities of
the person in question

The data in the data repository is backed up on a regular basis

Case studies

Stories of successful projects

Read the stories of successful projects. In these stories you can find an
interesting wisdom of gained experiences and certainly answers to many of your
questions.

How do you create a data warehouse and bank reporting for a newly established
bank? Would you like to know? Keep reading! Equa bank is exactly such a case.
Not only that, the bank requested some data from an online data warehouse. No
small feat considering the data had to keep its consistency and be integrated in
the data warehouse to provide an…

The client is an international company that sells its products worldwide
which must report results in an exact and precise way on a monthly basis.
Adastra provides the company with a system that guarantees complete overview and
accountability of all key indicators, generates annual closing numbers, in
addition to forecasts for the end of the…

Team

YOUR Reporting & BI EXPERTS

Our reputation is built on capable people who steer your project
to a successful end. Meet your new team!