Exasol On-Premise & Cloud In-Memory Analytics Database

Minerra Icon

Exasol: The Analytics Database

The Exasol in-memory analytics database can help you become data-driven and transform the way you do business - on-premises, in the cloud or both.

Exasol - Go Beyond Data-Driven​

The unrivalled power of Exasol’s high-performance in-memory analytics database transforms how organizations work with data, on-premises, in the cloud or both – and turns it into value faster, easier and more cost effectively than ever before.

Unrivalled Performance

Unlock analytics as fast as you think – and get unrivalled performance, anywhere you have data.

Significantly Reduced TCO

An intelligent, self-tuning and resource-efficient database – giving you complete cost predictability for your cloud, on-premises or hybrid strategy.

Unifying AI and BI

Consolidate AI, ML and BI for both standard and advanced analytics, directly in the database – using any data science language.

Complete Freedom to Adapt and Change

There’s no platform, vendor or architecture lock-in. Exasol can be deployed on-premises, in a private cloud or on AWS, Microsoft Azure or Google Cloud public cloud environments. Its database-as-a-service offering is also available for ExaCloud and on-premises customers.

What Exasol Can Do For You

Access your data at the speed of thought​

Exasol is a high performance, in-memory analytics database that provides unrivalled performance anywhere you have your data. It’s the only analytics database that has in-memory processing ingrained in its core architecture, allowing for significantly faster access times. Massively Parallel Processing (MPP) means that queries can be answered significantly faster, allowing you to turn your data into value quicker than ever before.

Use your existing analytics platforms and languages​

Exasol works with all major analytics and business intelligence platforms and data integration platforms. It also provides support for R, Python, Java & Lua and an ability to integrate the analytics programming language of your choice – to use it for in-database, advanced analytics. Exasol’s standard SQL interfaces also mean avoiding the trap of NoSQL skill shortages and allows for easy compatibility with pre-existing applications and data structures.

Lower and predictable cost of ownership

Exasol provides upfront pricing and fair licensing so that you can have complete control over your budget. Its pay-per-data volume licensing is based on raw data, rather than queries, users or loads, which can rack up costs at volume.  You’ll need significantly less infrastructure to make big performance improvements and if you want to scale out your system you won’t be penalized with additional license fees. If you’re not sure how much data you will be using, you can choose the flexible pay-per-usage option for all (public) cloud deployments, with the option to switch back to the pay-per-data-volume based pricing as soon as it makes sense for you.

Easily deploy data science models

Exasol’s architecture enables you to perform advanced analytical tasks on large volumes of data – right in the database. And limitations aren’t imposed on you – it works with whatever data science programming language you’re using (including R, Python, Java, Lua). It’s also easy to bring Artificial Intelligence (AI) and Machine Learning (ML) algorithms and (BI) Business Intelligence, directly to where you keep your data. This means that you can solve complex analytical challenges like predictive analytics with the minimum of fuss.

Exasol + Yellowfin

Exasol is a fully supported data source for the Yellowfin Analytics Suite. This allows you to combine the unrivalled performance of its analytics database with market-leading augmented analytics, data analysis and storytelling capabilities, so that you can extract maximum value from your data performance monitoring and decision making.

Minerra is an Exasol Authorised Partner

Talk to us about how we can help you utilise the power of the Exasol in-memory analytics database.

Exasol Consulting

Minerra’s experience with analytics architecture designdata warehouse and data integration design and development, and data science design will help you get the most value out of your Exasol in-memory analytics database.

Exasol Training

Our experienced consultants provide training and custom workshops to help you get the most out of the Exasol in-memory analytics database.

Get more information about the Exasol in-memory analytics database

Want to learn more? I can provide you the best consulting and training to successfully implement Exasol.

Steve Remington Headshot

Analytics Fundamentals​

Minerra Icon

Analytics Fundamentals Training

This analytics fundamentals training course provides core knowledge about analytics, and how to successfully work with analytics in an organisation.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

The purpose of the Analytics Fundamentals course is to provide attendees with a common foundational knowledge about data and analytics generally, and how to implement analytics within their organisation.

After completing the course all attendees will have a common understanding of key analytics terms, what analytics is, how analytics used in organisations, and what leads to a successful analytics implementation.

Key Topics

  • Analytics and the Business Landscape
  • Data-driven Decision Making
  • Analytics Case Studies
  • Analytics Success Factors
  • The Analytics Environment: People, Culture and Structure
  • The Analytics Environment: IT Systems, Technologies and Tools
  • Evolutionary Development
  • Analytics Adoption Factors
  • Introduction to Data Visualisation
  • Conclusion

This course will provide attendees with a general understanding of:

  • The use of analytics within the business landscape
  • Data-driven decision making
  • How analytics is used to support data-driven decision-making (DDDM)
  • Factors influencing analytics success
  • The people, cultural and structural aspects of the analytics environment
  • Why people use BI tools
  • IT systems, technologies and tools within the analytics environment
  • Evolutionary analytics development and its benefits
  • Factors influencing analytics adoption

Request More Information

Leading Analytics in Organisations: An Executive Introduction

Minerra Icon

Leading Analytics in Organisations: An Executive Introduction

This analytics introduction for executives course provides leaders with the knowledge to plan and lead a successful analytics programme in an organisation.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

There are many factors driving organisations to implement an analytics and data science programme. The push factors of increasing demands for greater returns from stakeholders in the form of expanded markets or greater efficiency are combined with the pull factors of a significant increase in low-cost computing power and the ever-growing amounts of meaningful data generated by digitisation initiatives.

While many organisations claim that analytics is a top strategic priority, many of these same organisations have either failed to start an analytics programme or have started and reached what McKinsey & Company calls the “started but stuck” phase, that is they have invested heavily in analytics infrastructure and technical people but are yet to achieve meaningful business results.

This one-day course provides practical knowledge, grounded in high-quality academic research and industry best practice, will empower the executive and management team of any organisations to jump-start an analytics programme capable of providing positive financial returns and sustainable growth.

Key Topics

  • Analytics and the Business Landscape
  • Types of Analytics
  • The Analytics and Data Science Process
  • Analytics Technology – The What and Why
  • Analytics in Business Functions
  • Analytics Success Factors
  • How to Staff and Structure an Analytics Team
  • How to Build an Analytics Culture
  • Governance, Compliance and Ethics of Analytics
  • Analytics Strategy Development and Execution

When the participant completes this course they will:

  • Know how analytics can help their business unlock the value in their data to achieve sustainable competitive advantage and drive innovation
  • Understand the key principles and concepts of analytics
  • Understand the proven success factors for analytics
  • Understand how to build an analytics culture within their organisation
  • Know what is required to plan and execute a successful organisation-wide, business-driven analytics program
  • Know how to assemble an effective analytics team that can drive analytics throughout the organisation

Request More Information

Introduction to Data Visualisation and Storytelling​

Minerra Icon

Introduction to Data Visualisation and Storytelling

This course provides attendees the knowledge and experience to create compelling data visualisations and data stories your business users love to use.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

This course provides attendees the knowledge and experience to create data visualisations and data stories your business users will not only love but also rely on to make better business decisions.

The success of an analytics system is judged by the value it provides to the business users it was designed to support. Those business users, to a large degree, judge the value and trustworthiness of the analytics system on the quality of the user interface they interact with. While the analytics platform an organisation chooses plays some part in the business users’ assessment, most of their assessment is based on the usefulness and usability of the data visualisations and dashboards displayed by the platform.


An organisation could have created the most complete and accurate analytics system possible and chosen the most suitable data visualisation platform available, but if the data visualisations and data stories created by analysts are poor and do not help the business users make better decisions the entire project will be considered a failure by the business.


This workshop provides attendees with knowledge of and practical experience with the best practices for the design and development of data visualisations and data stories that business users will trust, use and value.

Key Topics

  • Data Visualisation and Analytics
  • Data visualisation principles
  • Dat Visualisation Design Process
  • Data Storytelling Principles
  • Exercise: Create a Data Visualisation and Data Story
  • Data Visualisation and Data Story Presentations and Feedback

Participants completing this workshop will be able to:

  • Use knowledge of human visual and thinking processes to guide the design of attractive and effective data visualisations and data stories
  • Explain how data visualisations and data stories support analytics and data-driven decision making
  • Choose the correct form to communicate data and information simply, clearly and accurately to business users
  • Apply best practice design principles to the design of data visualisations and data stories
  • Use decision-driven design and evolutionary development to create data visualisations and data stories that are useful for business users
  • Interact with business users to gather the correct requirements for data visualisation and data stories

Request More Information

SQL Training: Advanced Querying

Minerra Icon

SQL Training: Advanced Querying

This advanced SQL training course provides attendees with skills to perform advanced querying to retrieve and analyse data from relational databases.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

This practical course provides attendees with advanced querying techniques, including subqueries and window functions.

You will also learn how to create and manipulate tables, create views, index data and manage transactions.

Key Topics

  • Using Subqueries to Perform Advanced Querying
  • Manipulating Table Data
  • Manipulating the Table Structure
  • Working with Views
  • Indexing Data
  • Managing Transactions

When the participant completes this course they will be able to:

  • Use subqueries to generate query output.
  • Manipulate table data by inserting and updating records in a table and deleting records from a table.
  • Manipulate the table structure.
  • Create views, manipulate data through views, modify the view structure, and drop views.
  • Create indices on table columns and drop inefficient indices.
  • Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.

Request More Information

SQL Training: Fundamentals of Querying

Minerra Icon

SQL Training: Fundamentals of Querying

This SQL training course provides attendees with fundamental skills to use a range of queries to retrieve and analyse data from databases using SQL.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

This course introduces attendees to querying with SQL. You will learn how to connect to a SQL database and execute a range of queries to retrieve and analyse data.

The course will cover a variety of functions including date calculations, aggregate functions, string manipulations and more.

Key Topics

  • Executing a Simple Query
  • Performing a Conditional Search
  • Working with Functions
  • Organising Data
  • Retrieving Data from Tables
  • Presenting Query Results

When the participant completes this course they will be able to:

  • Connect to the SQL Server database and execute a simple query.
  • Include a search condition in a simple query.
  • Use various functions to perform calculations on data.
  • Organize data obtained from a query before it is displayed on-screen.
  • Retrieve data from tables.
  • Format an output, save a result, and generate a report.

Request More Information

Programming in VBA with Microsoft Excel

Minerra Icon

Microsoft Excel Training: VBA Programming

This advanced Microsoft Excel training course provides attendees with the skills to automate repetitive tasks or create real-life applications using VBA.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel.

The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.

Key Topics

  • Recorded Macros
  • Recorder Workshop
  • Understanding Excel VBA
  • The VBA Editor
  • Procedures
  • Using Variables
  • Functions In VBA
  • Using Excel Objects
  • Programming Techniques
  • Creating Custom Forms
  • Programming UserForms
  • Automatic Startup
  • Error Handling

When the participant completes this course they will be able to:

  • understand the Excel object model and VBA concepts
  • work effectively with the main features of the VBA Editor window
  • create procedures in VBA
  • create and use variables
  • create and work with user-defined functions in VBA
  • write code to manipulate Excel objects
  • use a range of common programming techniques
  • create a custom form complete with an assortment of controls
  • create code to drive a user form
  • create procedures that start automatically
  • write a variety of error handling routines

Request More Information

Microsoft Excel Training: Level 3

Minerra Icon

Microsoft Excel Training: Level 3

This advanced Microsoft Excel training course provides attendees with the skills to create spreadsheets using the advanced features of Microsoft Excel.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

This course aims to provide skills and knowledge which will allow the attendee to workbooks using advanced features of Microsoft Excel.

Create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and Solver, and create and use macros. 

Key Topics

  • Lookup Functions
  • Setting Excel Options
  • Chart Object Formatting
  • Labels And Names
  • Protecting Data
  • Summarising And Subtotalling
  • Data Linking
  • Data Consolidation
  • Pivot Tables
  • PivotTable Techniques
  • PivotCharts
  • Goal Seeking
  • Grouping And Outlining
  • Solver
  • Recorded Macros
  • Recorder Workshop

At the completion of this course you should be able to:

  • modify Excel options
  • protect data in worksheets and workbooks
  • import data into Excel and export data from Excel
  • use data linking to create more efficient workbooks
  • group cells and use outlines to manipulate the worksheet
  • create summaries in your spreadsheets using subtotal
  • use the Data Consolidation feature to combine data from several workbooks onto one
  • create, use and modify data tables
  • create and work with scenarios and the Scenario Manager
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create and edit a PivotChart
  • use advanced filters to analyse data in a list
  • use a variety of data validation techniques
  • create and use a range of controls in a worksheet
  • share workbooks with other users
  • create recorded macros in Excel

Request More Information

Microsoft Excel Training: Level 2

Minerra Icon

Microsoft Excel Training: Level 2

This intermediate Microsoft Excel training course provides attendees with the skills to create more effective and productive spreadsheets and workbooks.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

The skills and knowledge acquired in Microsoft Excel Level 2 enable users to expand their knowledge and learn how to create more effective and productive spreadsheets workbooks.

 It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks. 

Key Topics

  • Filling Data
  • Moving Data
  • Logical Functions
  • Formula Techniques
  • Number Formatting Techniques
  • Conditional Formatting
  • Applying Borders
  • Page Setup
  • Working With A Worksheet
  • Worksheet Techniques
  • Finding And Replacing
  • Sorting Data
  • Filtering Data
  • Charting Techniques
  • Chart Text Formatting

When the participant completes this course they will be able to:

  • use the fill operations available to fill a data series
  • use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use common worksheet functions
  • create more complex formulas and functions
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel’s Quick Analysis tools
  • create and work with tables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

Request More Information

Microsoft Excel Training: Level 1

Minerra Icon

Microsoft Excel Training: Level 1

This beginner's Microsoft Excel training course aims to give the new spreadsheet user fundamental skills in creating and working with Excel.

Classroom: 1 day | Remote: 4 x 2 hour sessions

Overview

This is a beginner’s Microsoft Excel training course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Excel.

Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Key Topics

  • Getting to know Microsoft Excel
  • Creating A New Workbook
  • Working With Workbooks
  • Selecting Ranges
  • Formulas And Functions
  • Copying Data
  • Formula Referencing
  • Font Formatting
  • Cell Alignment
  • Row And Column Formatting
  • Number Formatting
  • Printing
  • Creating Charts

When the participant completes this course they will be able to:

  • navigate your way around Microsoft Excel 2016
  • create and work with a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • format rows and columns in a worksheet
  • work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  • filter data in a table
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it
  • understand points to consider to avoid problems in your worksheets

Request More Information