Enterprise Analytics

Enterprise analytic designs, guidance and visibility (20 years of direct experience)

Most companies are integrating Modern Business Intelligence (BI) Tools like Tableau, Qlik, Lumira, Spotfire, Microsoft Power BI with Traditional BI and date science software like R, RStudio, Python, Scala and Amazon SageMaker. We help with these areas by integrating structures for traditional and modern BI tools and advancing enterprise information integration so all tools access the same proven enterprise data model and sub models.

We use business, management, lean, six sigma, data science and big data methods, techniques and computations in "Enterprise Data Warehouses (EDWs)." Skilled with ERP data and integration with IoT and external data.

Typical large enterprise analytic systems have thousands of company shared (public) and personal reports. Our first step is to catalog these systems which provides visibility on the As-is Environment. After this, change is possible toward achieving the designed To-be Environment. We put analytics on the analytics servers and supporting data management servers (databases) to catalog the "Analytics Landscape." This provides a foundation and visibility to plan change.

Large Enterprise Databases

Superfast databases have become the new norm for analytic systems sourcing from the EDW. These superfast databases are comprised of software and hardware platform components. They are Massively Parallel Processing (MPP) databases used for very large datasets with advanced speeds for large query workload processing and large computations across large data sets.

As datasets have grown, Big Data systems and smaller databases need business logic, summarizations and calculations to be handled in the database layer. Many systems handle these important operations in the middle layer or Analytics Server (2) and/or in the frontend or Visualization (1) layer. Moving to bigger data and faster systems requires different and newer data model builds rather than just trying to compensate with additional software and hardware purchases that provide less than acceptable performance gains because of existing slow or "hard-to-analyze" data models. Alexicon can provide help and advice to avoid performance problems while opening up analysis capabilities as data scales by pushing Visualization or Analytic Server level work to the database layer.

Below are major parts of a BI or Analytics system

1. Visualizations, Dashboards and Reports

Traditionally, BI and analytics has been focused on users being able to run standard reports with prompt interactivity and even “ad hoc” abilities or a “self-service facility” to build reports. Dashboards evolved from these systems and gained popularity in the last 10 years with Mobile BI, BI Search and Interactive Visualization tools following in recent years. In addition, statistical client tools have been used throughout all these periods and continue to be a powerful tool that complements current “Big Data” efforts to assist with in-database computations.

2. Analytics Server

Frontend visualizations, dashboards and reports typically depend on the Analytics Server (2) which sits in the middle of the overall BI Landscape.

The Analytics Server is used to aggregate reasonable data sets and present those data sets to Frontend Visualizations for OLAP or static use. The server acts as a broker between the Users and the Database. It provides a place to administer users and to organize content or visualization objects (typically thousands of users and thousands of visualization objects).

The key is to use the Analytics Server as a pass-through for the hard work performed at the Database layer (quick data throughput to users). The database should perform filtering, aggregations and computations where possible. In addition, Analytic Server Meta Data should follow the same rule and should complement or be a pass-through for Meta Data at the Data Warehouse layer.

3. Database Servers (MPPs, Large Compute R, Python and SQL)

The Database is where all the sorting, filtering, aggregations and computations should be performed. This utilizes the databases computing power and passes summarized results to the Analytics Server layer which passes the summarized data to the Visualization layer. One example is a simple need to aggregate records for five regions on 20 billion base records. If the summarization is done in the database it will produce five rows with the region names and accompanying numeric values as columns. It passes those to the Analytics Server which renders those five rows in the web visualization layer or passes data to a client analytics tool (desktop application).

While this is an extreme case to produce five rows of data, these types of aggregations are critical for databases to handle (big or small). Typically, the Analytics Server is overworked because this basic rule is not followed. While 20 billion rows of data would definitely break most Analytics Servers, there are still many systems that run large aggregations in the Analytics Server and sometimes even in the visualization layer. Users experience slowness with response times as a result of the Analytics Server being overworked. With Big Data, this becomes painfully clear quickly. Analytics Servers start failing as data size and velocity increases. This why data manipulations and computations need to be done in the database.

The "Data Model"

Data Warehouses depend on the right overall or enterprise data model to produce data structures for reports, dashboards and visualizations. As data Volume, Variety and Velocity (3V's) continues to increase, more advanced ways on ingesting, storing and providing data structures for analytic tools are available. Cloud solutions have added to the ease of scaling analytics systems. With their added “Big Compute” abilities, clouds are even more attractive. Alexicon focuses or the overall enterprise data model, indicators, sub data models, summaries and detail records. The goal is to drill from top levels as quickly as possible to any level in the system with accuracy.

Experiance Curve

Alexicon has 20 years of progressive and successful experiences implementing enterprise analytics systems across a variety of industries and functional company areas. Our data models (heart of a system) provide thorough analysis capability and quick response times. It is surprising the quick performance gains that can be achieved when a company develops the right analytic systems to match their strategy. We can assist with your Company’s strategic alignment of their analytic and data management solutions (fixes, enhancements and new analytic landscapes).

Contact us

Analytics and Data Management


Indicator Analytics

Big Data

Data Science

Lean Six Sigma

Contact Us

© 2019 Alexicon Corporation. All rights reserved.