Questions Data Science tries to answer one of the following questions: Classification -> “Is it A or B?” Clustering -> “Are there groups which belong together?” Regression -> “How will it develop in the future?” Association -> “What is happening very often together?” There are two ways to tackle these problem domains with machine learning:…
The Essence of Machine Learning A pattern exists The pattern cannot be described mathematically We have data on this problem
This episode is about the basic statements needed to create, read, update and delete data in a database system. It is part of my SQL-Tutorial Motivation Let’s assume we work as a data scientist for Knight Industries. We want to help the Foundation of Law and Government to keep track of our operatives. We decide…
Sometimes your RDBMS does not allow you to do certain changes like updating a table without using a WHERE clause that uses a key column. When you are really sure what you want to do: SET SQL_SAFE_UPDATES = 0; Now the dirty brown magic can begin! Back to the SQL-Tutorial
Sometimes You screw up your database design and you have redundancies i.e. your database is not normalized. If You want to correct that: Subqueries for the rescue! In our example we have two tables which contain almost the same information: CREATE TABLE installed_device (`id` int, `device` text, `info` text); INSERT INTO installed_device (`id`, `device`, `info`)…
You can comment your queries with — This is a comment in SQL SELECT * FROM my_table — WHERE id = 1
I got confused by all the buzzwords: data science, machine learning, deep learning, neural nets, artificial intelligence, big data, and so on and so on. As an engineer I like to put some structure to the chaos. Inspired by Roadmap: How to Learn Machine Learning in 6 Months and Tetiana Ivanova – How to become…
As this year is coming slowly to an end, I like to use this Sunday to experiment with a little personal Retrospective. We already did two good retros at work so I decided to do one for myself. Set the stage As a method for setting the stage I use Check In-Questions What do I…
Last event for this year: ASQF’s #agilebrunch in Nuemberg. Jürgen Mohr invited me to this event because I was curious about Management 3.0 Workshops and Jürgen told me that he was going to hold a short session about M3.0 at this particular event.
Imagine that you come home from a party and you are stopped by the police. They ask you to take a drug test and you accept. The test result is positive. You are guilty. But wait a minute! Is it really that simple? In Germany about 2.8 million people consume weed on a regular basis,…