Welcome to Data Analytics Ireland
Livestream #1 Here is our first live stream, we discuss the channel, the areas of data analytics we cover, and the future direction and what the plans are for 2021.
Archives
How To Join Tables In SQL
When running an sql select query, most likely we may have a need to bring in data from other tables. The reason for this is that tables have a specific purpose for the data they store. One of the most important features of a data architecture is to avoid duplication. This has the impact of…
TypeError: ‘str’ object is not callable
This is a common TypeError that you will come across in Python, it is actually easy to diagnose how it occurred. To start off we need to understand “str” is a function in python, and it converts any value into a string. As a result, because it is a function your ability to call it…
TypeError: cannot unpack non-iterable int object
Often when working on a data analytics project it requires you to split data out into its constituent parts. There are a number of reasons for this, it can be confusing when you get errors as with the title of this post. Before we explain this error and what it means, lets us first explain…
Read More “TypeError: cannot unpack non-iterable int object” »
What is a Primary Key and Foreign Key
When working with databases in your data analytics projects, most likely you will deal with more than one table. As a result in certain scenarios there will be a link between the tables This will ensure that you can use data from the two or more tables that can be joined together. But how would…
Tableau Desktop versus Tableau Server
Are you working on a data analytics project, and seeking a way to present your data visually? Data Visualisation achieves this, and there are many products on the market place that you could use. In this blog post, we are going to discuss Tableau , one of the leading data visualisation tools in the market…
TypeError object of type ‘int’ has no len()
I have seen this data type error come up numerous times while working on my data analytics projects, and recently decided to investigate further. On initial inspection, it can seem a bit of a funny one, but in actual fact, it is quite straight forward. Lets break it down and see what is going on…
how to create and drop a table in SQL
If you are working on data analytics , and have access to databases that you can load data into and manipulate, then read on. There maybe a reason for you have your own partitioned table with data in it, but you need to know how to create a database. The creation of a table can…
how to use case statements in SQL
In recent posts on SQL here on this website, we have covered off a number of ways to extract your data from wildcards to filters. Here we are going to build on that learning, but bring in a new dimension in the use of case statements. These are very handy to use when you may…
How to use wildcards in SQL
Following on from from our previous posts on SQL, this post will help to explain how to use wildcards in your query. What would you use a wild card in the first place? When a data analyst dealing with a large dataset, it is most likely that they will not know every piece of data….