know.bi blog

Basic Machine Learning - Linear Regression

Apr 26, 2018 10:00:00 AM / by Yannick Mols posted in data science, machine learning, algorithm, linear regression

0 Comments

What size is this?

Suppose you want to predict what the length or width of a flower petal.
For this we can look for a relation between the two.

Read More

Basic Machine Learning - Anomaly Detection

Apr 11, 2018 10:00:00 AM / by Yannick Mols posted in data science, outliers, anomaly detection

0 Comments

What's weird about this?

At certain times you might be faced with unexpected patterns or events appearing in your data. Let's take a look on how we can tackle anomalies, by detecting them.

Read More

Basic Machine Learning - Clustering

Mar 27, 2018 10:00:00 AM / by Yannick Mols posted in data science, artificial intelligence, machine learning, python, algorithm

0 Comments

How is this related?

In this post, we'll take a look at how we can find out in what way data is structured or related.

Read More

Basic Machine Learning - Classification

Mar 13, 2018 10:00:00 AM / by Yannick Mols posted in data science, python, classification

0 Comments

Is this A, or B?

As a follow-up to last week's machine learning tidbit let's look at an example of how we can solve a classification problem using machine learning (on recreational data).

Read More

Graph Databases - Analytical Use Cases

Mar 9, 2018 10:00:00 AM / by Shila Casteels posted in neo4j, fraud detection, graph databases, graph analytics, social network analysis, recommendation engine

1 Comment

What is a graph database?

 Although graph theory has been around for centuries, graph databases started to appear relatively recently.

‘Traditional’ relational databases store data in tables. These tables have a fixed format (fixed number of columns, each with a fixed data type). Tables are linked through the primary key in one table and the corresponding foreign keys in other tables. When a query is executed, the database engine fetches the primary keys from one table and links them to the corresponding foreign keys in other tables through SQL joins.

Although this works well to insert, select, update and delete individual records over one or a limited number of tables (CRUD operations), performing joins during query execution over large schemas and data volumes is expensive and slow.

Property graph databases (like the one offered by market leader Neo4J) use nodes with labels and properties to store data instead of the relational database tables and columns. Instead of fitting all data into a fixed, predefined table structure, each node is a new instance with a structure that can be different from other nodes.

This schema-less structure offers more flexibility than the relational database table. On top of the additional flexibility, graph databases treat relationships as first class citizens. Instead of being built during query execution, relationship are persisted in a graph database. Having all relationships stored with the data not only allows to extremely outperform relational databases on relationship-heavy queryies, it allows use cases that simply aren’t possible in relational databases.

In this post, we’ll have a look at a couple of analytical use cases with graph databases.

Read More

Build a dashboard with AWS Athena and Quicksight in less than an hour

Feb 28, 2018 10:00:00 AM / by Hans Van Akelyen posted in cloud, analytics, amazon, aws

0 Comments

Quickly move from data to insight

Read More

Basic Machine Learning - Choose a learning type and algorithm

Feb 20, 2018 10:30:00 AM / by Yannick Mols posted in data science, artificial intelligence, r, machine learning, python, matlab

0 Comments

So you want to get started with Machine Learning?

Read More

5 Key Components For Your Cloud Analytics Project

Feb 9, 2018 10:00:00 AM / by Bart Maertens posted in data engineering, cloud, cloud etl, business intelligence, analytics, amazon, aws, analytical database, column store

0 Comments

Why move your BI to the cloud? 

As discussed in a previous post, there are many reasons to move your BI to the cloud.
Security, being able to work from anywhere and delivering faster, with more resource flexibility and at a lower cost are just a few.  

Read More

Predictive Analytics with Vertica

Jan 30, 2018 10:00:00 AM / by Yannick Mols posted in vertica, analytical database, column store, data warehouse, olap

0 Comments

In-SQL machine learning

Vertica is a clustered analytical database that handles large, fast-growing volumes of data with ease and provides lightning fast query performance. Apart from that it also has in-database machine learning which we’ll be taking a look at in this blogpost!

Read More

Easily load data to Neo4J with Pentaho Data Integration

Jan 25, 2018 10:00:00 AM / by Bart Maertens posted in pentaho, pdi, data integration, neo4j

0 Comments

Load data to Neo4J

Read More

Subscribe to Email Updates

Recent Posts