Data Analysis and Data Visualization using Tableau — Getting started with Tableau
SGP-V
Abstract
In 2021 the world has generating 52 times the amount of data as in 2010, and 76 times the number of information sources. Being able to use this data provides huge opportunities and to turn these opportunities into reality, people need to use data to solve problems. In this scenario tableau play the vital role, because Tableau is an extremely powerful tool for visualizing massive sets of data very easily. It has an easy to use drag and drop interface. You can build beautiful visualizations easily and in a short amount of time. Tableau supports a wide array of data sources. Airline, Space mission and Retail sales analytics with Tableau, you will create dashboards that help you identify the story within our data, and we will better understand the data in detail. In this paper comprehensive review about Tableau. The Tableau are the tools which deals with the big data analytics also it generates the output in visualization technique i.e., more understandable and presentable. Its features include data blending, real-time reporting and collaboration of data. In the end, this paper gives the clear picture of the analysis of Retail sales, Airlines and Space missions data and the tools which can help more effectively, accurately and efficiently.
Introduction
Big data Analytics is an emerging trend in today’s world and big data analysis is receiving increasing attention in many industries, including social media, healthcare, retailers etc. Visualization plays an important role not only in intuitively showing the results of data analysis but also in the whole process of collecting, cleaning, analyzing, and sharing data. This paper presents a procedure for the interactive visualization and analysis of retail data, using Tableau as a business intelligence tool. We have considered a case study of the data where we are considering three cases —
i. Space Mission Data set
ii. Airline Data set
iii. Retail Sales Analysis
Data Visualization
Data visualization is the use of human natural skills to enhance data processing and organization efficiency. Data Visualization is the representation of data or information in a graph, chart, or other visual format. Visualization can help Us deal with more complex information and enhance memory. It communicates relationships of the data with Images.
This is important because it allows trends and patterns to be more easily seen. With the rise of big data upon Us, we need to be able to interpret increasingly larger batches of data. Machine learning makes it easier to conduct Analyses such as predictive analysis, which can then serve as helpful visualizations to present. But data visualization Is not only important for data scientists and data analysts, it is necessary to understand data visualization in any career. Whether you work in finance, marketing, tech, design, or anything else, we need to visualize data. That fact showcases the importance of data visualization. Its main goal is to distill large datasets into visual graphics to allow for easy Understanding of complex relationships within the data.
It is often used interchangeably with terms such as Information graphics, statistical graphics, and information visualization. Data visualization is a huge field with many Disciplines. It is precisely because of this interdisciplinary nature that the visualization field is full of vitality and Opportunities.
Necessity of Data Visualization
According to the World Economic Forum, the world produces 2.6 quintillion bytes of data every day, and 90% of all data has been created in the last two years . With so much data, it’s become increasingly difficult to manage and make sense of it all. It would be impossible for any single person to wade through data line-by-line and see distinct patterns and make observations. Data proliferation can be managed as part of the data science process, which includes data visualization. We need data visualization because a visual summary of information makes it easier to identify patterns and trends than looking through thousands of rows on a spreadsheet. It’s the way the human brain works.
Since the purpose of data analysis is to gain insights, data is much more valuable when it is visualized. Even if a data analyst can pull insights from data without visualization, it will be more difficult to communicate the meaning without visualization. The charts and graphs make communicating data findings easier even if we are identify the patterns without them. The numerous types of data visualizations for example Line charts, Box plots, Area charts, Sankey diagram, Scatter plots, Bar charts. Population pyramids, Pie charts, Heat maps, Bar chart (actual vs. expected), Tree maps, Histograms, Bubble charts, Choropleth, Network diagram etc.
Tableau
In this scenario, Tableau is very advantageously tool. Because Tableau is a data analysis and visualization tool which can connect with many data sources comfortably. The big advantage with Tableau is its ability to create interactive dashboards. These dashboards can be created without much coding knowledge, through visual intuitive drag and drop interface.
Tableau has been very popular among organizations due to its ability to translate data into insightful visual dashboard. The Tableau utilizes application integration innovations like JavaScript APIs and single sign-on application to include Tableau analytics into basic business applications consistently.
Tableau can create an ample range of visualization to interactively present the data and showcase insights. It comes with tools that allow to drilldown data and see the impact in a visual format that can be easily understood by any individual.
Tableau also comes with real-time data analytics capacity and cloud support. Here we discuss the various versions of tableau, it benefits and implementation. We will see how tableau is various from ms excel and other spreadsheet tools. Tableau is the most strong, safe and flexible end-to-end analytical platform for our information from connection via cooperation. It also enhances data power for people.
Tableau is the only business intelligence platform designed for the individual but scaled for business that turns information into an insight which drives action.
Tableau can manage millions of rows of data with ease. Different types of visualization can be created by the large amount of data without having another performance of the dashboards. Also, there is an option in Tableau where user can make live two connections to different data sources like SQL etc. There are, any different types of visualization options available in tableau which egregious the user experience. Lastly, Tableau is very easy to learn, anyone without having any knowledge of coding can easily learn Tableau.
Versions of Tableau
Tableau makes it easy to share data, no matter what your requirements are. Tableau Online is an easy-to-use, cloud based BI tool that can enable any organization to share visualizations created in Tableau Desktop with other people. Tableau Server enables the same sharing capabilities through a similar interface, but it is installed on our own network servers and managed by yourself. As we would expect, all visualizations on Tableau Server and Tableau online are fully interactive and can be embedded in any webpage. Additionally, the Tableau engine can connect to live data for up-to-date visualizations or warehoused data for many smoother-moving visualizations. In this section, we are discussing the different type of Tableau versions and the version we are using.
Tableau Public
This is a free version of Tableau software which can be used to make visualizations. It is an economical version which is very good for people wanting to learn and share their data with people. The files are published on Tableau Public and cannot be stored in the system. Tableau Public is not secured one and anyone can access the data and download.
Sample Dashboard in Tableau
a) Space Mission
In this data set the following queries are answered:
1. What are the average temperature details of the launch site?
2. What are the average Wind Speeds details of the launch site?
3. What are the average humidity details of the launch site?
4. What are the different varieties of launch vehicles used by different companies?
5. Track records of the launch sites.
Dashboard —
b) Airline Dataset
In this data set the following queries are visualized and analysed-
1. What are the total number of flights in a day?
2. Find the busiest day at SFO airport
3. Total no. of flights per day in a month
4. What are the top 5 busiest flight routes?
5. Which are the top 5 longest flight routes?
6. Represent the flight flying outside SFO towards different parts of world
Dashboard —
c) Retail Sales Analysis
In this data set the retail analysis is done with the help of different features created by us and following things are implemented in creating the dashboard.
1. Show the trend of state wise profit
2. Show the requirement of average profit by states. Analyze which state is generating more average
3. Profit and which is going in loss
4. Show the avg sales
5. Show the avg profit
6. Show the avg discount
7. Show information where you can write about the dataset
8. Show the branding
9. Regional quarterly avg profit
Dashboard —
Conclusion
Currently data is at the heart of most breakthrough technologies in the 21st century.
We are use Tableau to create high-impact visualizations of common data analyses to help us see and understand our data. We are applying predictive analytics to improve preferable decision making for making retail sale analysis, space mission analysis and airline traffic analysis. Using Tableau people, scientist, and researcher can quickly access reliable information, and even analyze the data for themselves. With Tableau define discrete and continuous dates, and examine when to use each one to explain our data and also introduce mapping and explore how Tableau can use different types of geographic data, how to connect to multiple data sources and how to create custom maps. Tableau is a used for data visualizations which we can use to connect with almost any database, plot our data and get insights to understand the data properly. Using Tableau we are create dashboards, models, interactive visualizations as well as analyze our data thoroughly as well as to create story out of the data and view results. In this paper, we are review the background and state-of-the-art of Tableau. Eventually, Tableau’s main task is connecting and extracting the stored information in different locations. It can collect information from any platform. Tableau can obtain information from any Excel, PDF, Oracle or Amazon Web Services database.
