Database Corner: Beginner’s Guide to MySQL Storage Engines
Analytics
3654 views
Analytics
3654 views

Database Corner: Beginner’s Guide to MySQL Storage Engines

Eran Levy - September 10, 2016

When a database is created, one often overlooked but critical factor in performance is the storage engine (particularly as the database grows). In many instances, the temptation…

SQL
1427 views

8 Ways to Fine-tune your SQL Queries (for production databases)

Eran Levy - September 7, 2016

In organizations that operate without a data warehouse or separate analytical database for reporting, the only source of the latest and up-to-date data may be in the…

Business Intelligence
1124 views

Getting Started with BI on ERP: an MS Dynamics Example

Eran Levy - August 30, 2016

For any business intelligence solution to be effective, it needs to have demonstrable value for business users and to actually gain some traction within the organization. However,…

Analytics
1637 views

Tips for Exploring Financial Data with Business Intelligence

Eran Levy - August 27, 2016

One of the main advantages modern business intelligence brings to the table is the ability to perform exploratory data analysis – i.e., testing new hypothesis leading to…

Big Data
1727 views

7 Data Modeling Mistakes that Will Sink your Analysis

Eran Levy - August 24, 2016

You have a goal. You want to gain actionable insights from all of this data that you have been collecting. So, how do you make sure to…

Analytics
1458 views

Why Embedded Analytics is a Game Changer for UX

Eran Levy - August 20, 2016

As a quick recap, embedded analytics generally means including consumer-facing BI and analytics tools within a separate application, as part of the native application itself rather than…

Analytics
1442 views

4 Building Blocks of Great CFO Dashboards

Eran Levy - August 17, 2016

So, you’ve been tasked with creating a dashboard for the Chief Financial Officer (CFO) of your company. How do you create one that will not only present…

Business Intelligence
2629 views

Postgres vs. MongoDB for Storing JSON Data – Which Should You Choose?

Eran Levy - August 15, 2016

In the fast-moving world of unstructured data, does it make more sense to use a database management system (DBMS) built from the start to handle the widely…

Analytics
1236 views

Infographic: The Relationship between Business Professionals and KPIs

Eran Levy - July 29, 2016

In preparation for launching our BI Virtually Everywhere program, we ran a quick survey (comprised mostly of participants from within our user base) aiming to understand how…

Business Intelligence
1823 views

BI Case Study: Building an Open Data Portal

Eran Levy - July 19, 2016

This article was written by Paul Murphy, IT Program Leader at Co-operatives UK, about his experience using business intelligence technology to centralize years of messy historical data…