Tableau and its Relevance in the Context of Data Warehousing

This report delves into Tableau, a leading data visualization tool in business intelligence, and its crucial role in data warehousing environments. It explores the software's ability to simplify raw data into understandable formats and accelerate data analysis. The report highlights Tableau's features, incl...Read More

Running head: TABLEAU AND ITS RELEVANCE
Tableau and its Relevance
Name of the Student
Name of the University
Author Note

TABLEAU AND ITS RELEVANCE
Table of Contents
Introduction................................................................................................................................3
Discussion and findings.............................................................................................................3
Tools, technologies and techniques relative to tableau in data warehousing.........................4
Critical Evaluation of the tools relative with Tableau...............................................................6
Conclusion..................................................................................................................................8
References................................................................................................................................10

TABLEAU AND ITS RELEVANCE
Introduction
Tableau is one of the powerful as well as one of the fastest growing tool of data
visualization which is utilized in the industry of business intelligence. One of the advantages
of the utilization of this particular tool is that it helps in the simplification of raw data into an
understandable format in a very easy manner [4] . The analysis of data takes place in a faster
manner with the utilization of the tool of data visualization. All the visualizations gets created
like that of the form of dashboards and worksheets
The data which gets created by the utilization of this tool of data visualization could
only be understood by the professionals who are present at any levels within any particular
organization. Even a non-technical user is allowed by this tool of data visualization for the
aim of the creation of the dashboards. Several types of features of Tableau comprises of
blending of data, real time analysis along with data collaboration to name a few. This
software does not demand any sort of skills of programming for operating it. All sectors of
the industry like researchers, business take interest in the utilization of this software.
This report focuses on the discussion of Tableau along with its relevance in the
context of the environments of data warehousing. This report also purposes to focus on the
tools, techniques along with the technologies relative with this software along with its
relevance with the environments of data warehousing. The report also aims to critically
discuss the as well as evaluate the tool, techniques and technologies related with this
software.
Discussion and findings
Several kinds of flexible and powerful applications are provided by Tableau which
could easily be utilized by anyone for understanding the data from any of the sources. This in
turn involves higher performance along with enterprise data warehouses with higher

TABLEAU AND ITS RELEVANCE
capacities [5] . The resultant visualizations, reports and dashboards could easily be shared
across various kinds of organizations in the analytics which are based on web. In addition to
this, Tableau utilizes the functionality of direct access in the data warehouses [6] .This in
turn helps in enabling the abilities of the novice users for the creation of several kinds of
compelling stories in Tableau.
Six connections of data warehouses which are mostly utilized comprises of Oracle,
Teradata, Hadoop, Cloudera, Microsoft MS SQL along with Amazon Web Services-Redshift.
In addition to this, Tableau is an American software company which focuses on the
interaction of data visualization [10] . It was founded in the year 2003 and is headquartered in
the United States.
Tools, technologies and techniques relative to tableau in data warehousing
Tableau Prep is an ETL or Extract Transform Tool which permits the users in the
procedure of the extraction of data from various kinds of sources [11] . It also permits all the
users in transforming of data along with outputting of data to Tableau Data Extract with the
utilization of a new Hyper database in the form of the extract engine for the aim of the
analysis. On the other hand, data warehousing could help in solving several bigger challenges
which are related with data ranging from disparate as well as disorganized sources. In
addition to this, various sources of enterprise data are consolidated by the warehouses.
This in turn forms one of the critical elements related with the industry of business
intelligence. Several products of Tableau query cloud databases, online analytical processing
cubes along with several types of relational databases for the generation of those data
visualization which are of graph-type [12] . These particular products could help in the
process of extraction, storing along with the retrieval of data from a single in-memory engine
of data.

TABLEAU AND ITS RELEVANCE
Several kinds of software products of Tableau comprise of Tableau Desktop, Tableau
Online, Tableau Server, Tableau Prep Builder, Tableau Reader and Tableau Public. The
Tableau Desktop is available for both personal as well as professional editions. The Tableau
Prep Builder was released in the year 2018 which in turn is a recent software product.
Tableau Vizable on the other hand is a mobile application of which was built up for the aim
of data visualization of consumer and it was released in the year 2015. Both Tableau Reader
and Public are free for utilization and could be utilized by anyone [13] . Several types of
functionalities of Tableau comprises of a functionality of mapping and this software contains
the abilities of plotting of both the longitudinal and latitudinal coordinates and is responsible
for the connection to all the spatial files.
Some of the examples of this constitutes of GeoJSON, Esri Shapefiles and KML
which are accountable for displaying of custom geography. The built-in feature of the geo-
coding permits for several types of administrative places like that of airports, area codes
which could be mapped in an automatic manner. All these geographies could be group for the
aim of creation of several custom territories. On the other hand, utilization of custom
geocoding could help in extending of the ongoing geographic roles within the products. In the
context of the environments of data warehousing, enterprises of data warehouses becomes
idea for the business intelligence.
This help in keeping the data in an organized as well as centralized manner for
supporting of modern analytics along with several kinds of needs of the data governance as it
gets deployed with the ongoing architecture of data. The maintenance of data warehouses
extremely becomes important as data sources are needed by data warehouses and structured
data are featured like that of the databases [16] . In addition to this, unstructured data are also
featured in the form of text files and emails as well.

TABLEAU AND ITS RELEVANCE
Tableau is responsible for the revolutionizing of speeding up of the methods of
analytics. The process of visualization help people in understand the warehouse data of the
enterprise in an effective manner. Tableau associates a variety of advantages along with it
which constitutes of interaction and visualization of data. It focuses on exploring the data as
well. Tableau also acts in the form of a data exploration tool for several actionable insights. It
provides several visuals for enhancing the natural capabilities of the users for spotting
numerous visual patterns [14] . It helps in delivering of certain dashboards which are
interactive in nature and also help in supporting the insights. It permits for asking questions,
identification of the opportunities along with spotting of trends.
It also gets linked with the databases of SQL, cloud applications, flat files and
spreadsheets. This software possesses native connectors who are accountable for enabling it
to query cloud databases, spreadsheets, relational databases and flat files. In simple words,
Tableau is an interactive solution in the field of business intelligence. It is designed with the
aim of helping people who possess no knowledge regarding the coding skills [15] . It
becomes possible for anybody to understand and visualize data without any such requirement
of several advanced skills in the field of data science.
Several insights are delivered by Tableau by the process of equipping anybody for
doing a visual analysis of the data of the SQL Server. SQL Server or Tableau could directly
be connected for several kinds of queries which are platform-specific or bringing data inside
the analytical engine of Tableau for taking off the burden of the database in a direct manner
[7] .
Critical Evaluation of the tools relative with Tableau
Tableau Online is an analytics platform which is totally hosted within the cloud. It
also publishes dashboards along with sharing of several discoveries with every single user.

TABLEAU AND ITS RELEVANCE
The utilization of Tableau Online is easy [8] . No programming or coding skills are required.
In addition to this, users are permitted to invite their customers or colleagues for exploring
several hidden opportunities with accurate data and interactive visualizations.
This particular product of Tableau is very advantageous as it could be accessed by the
users on their go. Next comes the Tableau Server which is an online platform for hosting
which holds various sources of data and workbooks of Tableau. Within this, the functionality
of Tableau could be utilized without the need of the downloading as well as opening of the
workbooks to open up with the Tableau Desktop every time it is needed. Comparatively,
Tableau online is more convenient than that of the Tableau server.
Tableau Desktop is in turn a tool of data visualization which helps in the achievement
of several actionable insights regarding data at a faster manner. It is comparatively different
from the Tableau server because it provides the users with the capabilities for developing
interactive and comprehensive dashboards and workbooks for fulfilling both their business as
well as academic requirements [9] . So, Tableau Server is mostly preferred as compared to
that of the Tableau Desktop. Now comes Tableau Vizable wherein data could be visualized
as well as explored on the store of application itself.
This particular software is very feasible for the users as they are able to interact,
visualize along with explore data on their go. This software product is mostly being utilized
by people and are more preferred as compared to the other software products which have
been mentioned above. It associates no certain factors like that of opening of the workbooks
along with the dashboards whenever needed [1] . Now, it is the turn of the Tableau Prep
Builder which is solely designed for helping every single user in combining, shaping along
with cleaning of their data for the aim of the analysis of data in a confident and quick manner.

TABLEAU AND ITS RELEVANCE
Tableau Prep builder is highly preferred by the users who have zero programming
skills. If the qualities of this particular product of Tableau would get incorporated in Tableau
Server, it would also become equally preferable by all the users. Tableau Public is referred to
a free service which does not demand any amount and permits each and every one in
publishing their respective and interactive visualizations of data towards the web [2] . This
particular advantage of Tableau Public is not available with any of the above mentioned
software products where users are permitted to freely publish their own visualization of data
on the web. If this particular factor could be added to the other products, it would be a good
thing in itself. The visualizations which have been published to Tableau Public could in turn
be embedded in several blogs and web pages.
They could also be shared through email or social media which could be available to
be downloaded by the other users. Last is Tableau Reader is a free application of desktop
which is required to be read and interacted with all the packaged workbooks of Tableau. The
abilities of interaction with the visualization is retained by this Tableau Reader which gets
created within the Tableau Desktop [3] . The involvement of the interaction of with the
packaged workbooks of Tableau is not associated with the other software products which
makes it much more advantageous for the users.
Conclusion
From the above report, it could be understood that tableau is one of few tool of data
visualization and business intelligence which is evolving at a very faster rate. Several
advantages which are associated with the utilization of this particular tool is that it is easier to
get deployed and learned as well. It is additionally intuitive to utilization for the customers
with zero knowledge regarding the several skills of coding and data science as well. This
particular tool is equally feasible for interaction, visualization as well as exploration of data.

TABLEAU AND ITS RELEVANCE
Any sort of programming knowledge is not really demanded for the utilization of this
particular tool. It involves the creation of several calculated fields where the logics or formula
needs to be written with respect to the required data. The details of Tableau along with its
relevance with the environment of data warehousing has been discussed in this report.
Several kinds of software products of Tableau has been discussed in this report and they have
be critically analyzed as well.

TABLEAU AND ITS RELEVANCE
References
[1] S.Smith and M. Rege, The Data Warehousing (R) Evolution: Where's it headed next?,
In Proceedings of the International Conference on Compute and Data Analysis (pp, 104-
108), ACM, 2017
[2] T. Pellegrini, H. Sack, and S. Auer, eds, Linked Enterprise Data: Management und
Bewirtschaftung vernetzter Unternehmensdaten mit Semantic Web Technologien, Springer-
Verlag, 2014.
[3] W.M. Yafooz, S.Z. Abidin, N. Omarand S. Hilles, Interactive Big Data Visualization
Model Based on Hot Issues (Online News Articles), In International Conference on Soft
Computing in Data Science (pp, 89-99), Springer, Singapore, 2016.
[4] B. Gupta, M.Goul, and B. Dinter, Business Intelligence and Big Data in Higher
Education: Status of a Multi-Year Model Curriculum Development Effort for Business
School Undergraduates, MS Graduates, and MBAs, CAIS, 36, p,23, 2015.
[5] B. Martinho, and M.Y. Santos, An architecture for data warehousing in big data
environments, In International conference on research and practical issues of enterprise
information systems (pp, 237-250), Springer, Cham, 2016, December.
[6] F.Z. Fezarudin, M.I.I Tan, and F.A.Q. Saeed, August, Data visualization for human
capital and Halal training in Halal industry using Tableau Desktop, In Asian Simulation
Conference (pp, 593-604), Springer, Singapore, 2017
[7] M.Y. Santos and C. Costa, Data warehousing in big data: from multidimensional to
tabular data models, In Proceedings of the Ninth International C* Conference on Computer
Science & Software Engineering (pp, 51-60), ACM, 2016, July.

TABLEAU AND ITS RELEVANCE
[8] S. Szewrański, J. Kazak , M. Sylla and M. Świąder, Spatial data analysis with the use of
ArcGIS and Tableau systems, In The Rise of Big Spatial Data (pp, 337-349), Springer, Cham,
2017
[9] S.M. Ali, N. Gupta, G.K, Nayak and R.K. Lenka, Big data visualization: Tools and
challenges, In 2016 2nd International Conference on Contemporary Computing and
Informatics (IC3I) (pp, 656-660), IEEE, 2016.
[10] H.J. Watson, Tutorial: Big data analytics: Concepts, technologies, and
applications, Communications of the Association for Information Systems, 34(1), p,65, 2014
[11] I. Ko and H. Chang, Interactive visualization of healthcare data using
tableau, Healthcare informatics research, 23(4), pp,349-354, 2017.
[12] K.C. Davis, D. Aggarwal, and S. Baskin, Scaling Data Warehousing Course Projects,
In 2016 International Conference on Computational Science and Computational Intelligence
(CSCI) (pp, 241-245), IEEE, 2016.
[13] L. Leonardi, S. Orlando, A. Raffaetà, A. Roncato, C. Silvestri, G. Andrienko, and N.
Andrienko, A general framework for trajectory data warehousing and visual
OLAP, GeoInformatica, 18(2), pp,273-312, 2014.
[14] L. Wang, G.Wang, and C.A. Alexander, Big data and visualization: methods, challenges
and technology progress, Digital Technologies, 1(1), pp,33-38, 2015.
[15] M. Sadiku, A.E. Shadare, S.M. Musa and C.M. Akujuobi, Data
Visualization, International Journal of Engineering Research And Advanced Technology
(IJERAT), 2(12), pp,11-16, 2016.

TABLEAU AND ITS RELEVANCE
[16] L. Nair, S. Shetty and S. Shetty, Interactive visual analytics on Big Data: Tableau vs
D3, js, Journal of e-Learning and Knowledge Society, 12(4), 2016