What does a data analyst do daily? Data Analytics Ireland

Tableau Desktop versus Tableau Server

February 11, 2021February 11, 2021 admin 226 Views 0 Comments data analyst, enterprise solution, Tableau, Tableau data management, Tableau Desktop, Tableau Server

Estimated reading time: 5 minutes

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 place.

So before we dive into this tool and start looking at it, we need to ask the question, why pursue data visualisation?

In the pursuit of a better understanding of data a company holds, a data analyst will need access to multiple tables and records.

They first of all will need to get the right data, usually through SQL select statements.

The challenge then is how do they take all this data and present it in a meaningful way? Data visualisation looks to fix this problem by:

Aggregating data into meaningful groups.
Removing the need to trawl through rows and rows of data.
Allow the ability to drill down deeper, to see what makes up a set of data.
Create visually appealing pages, that quickly give the viewer an understanding of what is going on with the data, and spot visual patterns.

So what is Tableau Desktop?

Tableau Desktop is used by end users with the following functionality in mind:

Interactive dashboards
The ability to connect to data on-premises or in the cloud.
Exceptional analytics demand more than a pretty dashboard.
Quickly build powerful functionality:
- That allows calculations from existing data.
- Enables drag and drop of data.
- Provides statistical output.
Make your point with trend analyses, regressions and correlations for tried-and-true statistical understanding.
It also allows you to:
- Ask new questions, look at the data from a way you had not thought of before.
- Spot trends – See visually how data is moving in a direction, can you benefit from this insight?
- Identify opportunities and make data-driven decisions with confidence.

As a result you can share/visualise the underlying data securely using Tableau Server.

So what is Tableau Server?

Tableau Server on the other hand is used as follows:

It is an enterprise solution, you can let the whole organisation leverage the power of its functionality.

In light of this, it empowers your business with the freedom to explore data in a trusted environment, and it doesn’t limit them to pre-defined questions, wizards or chart types.

For the purpose of understanding your data better, it has the functionally for you to ask questions, and these use sophisticated algorithms.

Also, it has artificial intelligence capabilities that allow the software to find insights you may not have been aware of.

You can also harvest the following capabilities:

Connect to Cloudera Hadoop, Oracle, AWS Redshift, cubes, Teradata, Microsoft SQL Server, for your enterprise needs.
Similarly, it has Governance capabilities so that you can centrally manage all of your metadata and security rules.
The Tableau platform is easy to deploy, scale and monitor.

If security is something that is important:

Whether you use Active Directory, Kerberos, OAuth or another standard, Tableau seamlessly integrates with your existing security protocols.
Easily track and manage content, users, licences and performance.
Quickly manage permissions for data sources and content and monitor usage visually.
- Tableau Data Management helps you better manage the data within your analytics environment, ensuring that trusted and up-to-date data is always used to drive decisions.

So you have seen both, what areas should you look at before deciding on which to use?

Criteria	Tableau Server	Tableau Desktop
Licensing	Centrally managed, licenses can be easily redistributed if a person leaves the organisation.	Managed on a case by case basis, if a person leaves the license needs to be transferred, can cause additional administration.
Security	Permissions are managed centrally, on access and ability to update the dashboard. It can leverage the power of Active Directory, Kerberos, OAuth.	Permissions managed locally, based on the corporate network setup, which is usually a username and password.
Connectivity	Works well with popular enterprise data sources like Cloudera Hadoop, Oracle, AWS Redshift, cubes, Teradata, Microsoft SQL Server.	You can connect to data on-premises or in the cloud – whether it’s big data, a SQL database, a spreadsheet or cloud apps like Google Analytics and Salesforce.
Artificial Intelligence	As this is usually installed on the corporate network the ability to perform complex calculations has more power on dedicated servers.	No capability on the desktop version
Scalability	Highly scalable allows for more users and data to be added, becomes easier to manage.	As stored locally, you are subject to the capabilities and size of the computer you are on. The larger the volumes, the longer the processing takes, and you could run out of space locally.
Development	It would depend on the user’s rights, not might be possible/ideal if the server is just used for hosting and managing the dashboards.	It can be achieved with the desktop but then sharing it has its limitations per Sharing below. On the other hand, when development is complete it could be loaded to the server for sharing with other users.
Data Management	You can manage all your data centrally, thus if you have multiple dashboards, they will work off the one set of data ensuring consistency.	If you have a number of people developing dashboards that are similar, they need to ensure where they pull their data from is consistent, so that the outputs do not give conflicting messages.
Enterprise Capability	Has the ability to manage a large corporate network of users.	None available used more for local development.
Sharing	As long as the user can log in to the server they can see dashboards they have access to.	Can be shared locally, the recipient must have Tableau installed to see the visualisation.
Editing	The dashboard can only be edited on the server, with appropriate permissions.	Local versions could be edited by users, thus you could end up with multiple versions of the same dashboard.

So in summary:

In order to make a decision on which route to take, the following questions should be asked:

What is the size of your organisation?
Does your workforce need development capabilities?
How important is it to be able to manage your data? Does it need to be controlled centrally?
Can you benefit from scaling for:
- Licensing costs.
- Data management.
- User management.
- Dashboard distribution.
- Scalability – Will your existing data be extensive and grow over time?

As a result a lot of the decision will come down to cost, the size of your data , distribution of dashboards and the no of users.

Python type error

TypeError object of type ‘int’ has no len()

February 8, 2021February 22, 2021 admin 132 Views 0 Comments data analyst, data type, dictionary, int has no len(), len(), list, object of type int, string, tuple, type int, TypeError

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

So in the below code, there are a number of things:

On line 1 we have a variable that is an integer. If we think about this logically, something that is a single numeric number cannot have a length.

An integer by design is purely to count up a number of apples or no of people, it cannot be viewed as having a length as it is descriptive of the number of occurrences of an object.

data = 100
print(type(data))
print(len(data))

Output Error:
<class 'int'>
Traceback (most recent call last):
  File "object of type int.py", line 3, in <module>
    print(len(data))
TypeError: object of type 'int' has no len()

So for it to in anyway allow a length to be calculated, the object needs to be one of the following data types:

List
String
Tuple
Dictionary

Opposite to an integer, these are datatypes that have values that would be more appropriate to having values that a length can be calculated on.

data = "100"
print(type(data))
print("Length of string is: ", len(data))

data = [100,200,300]
print(type(data))
print("Length of list is: ", len(data))

data = (100,200,300)
print(type(data))
print("Length of tuple is: ", len(data))

data = {"Age": 1, "Name": 2}
print(type(data))
print("Length of dictionary is: ", len(data))

And the output is:
<class 'str'>
Length of string is:  3
<class 'list'>
Length of list is:  3
<class 'tuple'>
Length of tuple is:  3
<class 'dict'>
Length of dictionary is:  2

In summary, to understand this error and fix it:

An integer describes the number of things that exist for an object, they are actually not the actual object in existence.

Anything that can have a length method applied to it actually exists and can be counted. In the above four examples, they are actually values that you could describe as existing as you can count each one of them.

The explanation here hopefully clears up the matter, if you have any questions leave a comment and I will answer for you!