Tableau 10 and Tableau 9.3 Desktop, Server & Data Science

Learn the science & art behind creating powerful reports, dashboards to solve amazing & difficult business problems
4.3 (77 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
959 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 122
  • Length 26 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

  • This course is about learning Business Intelligence & Analytical tool called Tableau, which has been in leaders position since 4 years
  • Business Intelligence, Analytics, Data Visualisation, Tableau desktop, Tableau server, Tableau & Hadoop, Tableau & R, are the common terminologies used to find this course
  • We have included course content in form of powerpoint presentation, datasets used for visualisation, 2 live case study projects for download, interview questions, sample resumes/profiles for job seekers
  • This course is extremely exhaustive & hence will last for more than 25 hours
  • Course is structured to start with introduction to the tool & the principles behind data visualisation. From there Tableau desktop is explained thoroughly including analytical concepts behind applicable visualisation. Finally course ends with explanation on Tableau server & the final 2 use cases as projects along with interview questions for job seekers
  • Jobs are abundant for Tableau & salaries are very promising & highest in this domain. Also this course is very exhaustive which includes Statistics, Forecasting, Regression models, K-means Clustering, Text Mining, Hadoop & R required for Tableau. Also included are Tableau Desktop & Server concepts in one course. 

What are the requirements?

  • Download all the datasets provided as part of this program to be able to practice & replicate the visualisations
  • Download Tableau Desktop Professional software from Tableau website

What am I going to get from this course?

  • Learn about data visualisation principles & importance of Tableau in present world
  • Learn about Tableau Architecture & the top charts used in Tableau
  • Learn about the statistical concepts pivotal for success in Tableau profession
  • Learn about building prediction models & forecasting models in Tableau
  • Learn about Tableau calculated fields & advanced reporting concepts
  • Learn in-depth concepts of K-Means clustering & Text Mining & how to accomplish the same in Tableau
  • Learn about various Tableau Server concepts including security settings, automatic reporting, etc.

What is the target audience?

  • With plethora of job opportunities & luring salaries which are best in industry, Tableau promises to be one of the best professions which is most sort after by students & working professionals. This course is meant for students, working professionals, data warehouse & business intelligence professionals, data analysts, data scientists, etc., who want to learn the science & art behind generating powerful data visualisations, to address even difficult business problems. Prior knowledge of working with data is a plus but not mandatory.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Tableau Introduction
07:04

Brief introduction about the trainer and overall Agenda of this program. Happy learning!

05:39

Learn about the concepts that would be discussed as part of this section. Learn on why Tableau is extremely valid to be in the current world alongside learning Tableau's dominance in the space of Business Intelligence & Analytics. You will notice that Tableau exists in the leaders quadrant of Gartner's magic quadrant since 4 years in a stretch.

07:47

Learn about Tableau and its importance in the space of Analytics. Learn on why data visualization is extremely imperative in the world of big data. Get a glimpse into the amount of data getting generated via various sources. Finally you will learn the importance of data visualization in identifying interesting insights from the data.

10:17

Learn about the various products which Tableau provides us to cater to our business needs. This includes Tableau Desktop, Server, Online, Mobile, Public, Reader. Learn about the Tableau architecture and various components including various data source formats, data connectors and APIs.

11:12

Learn about the various components of Tableau server including Data Server, VizQL Server, Application Server. Learn about the load balancing and failover support with Tableau. Also learn on what are the various browsers, mobile devices on which end users can view the visualization using Tableau

07:04

Learn on how to extract the data from various datasources using Tableau Desktop or Tableau Server. Also discussed about is the way to establish live connection with data sources using Tableau Desktop & Server. Learn on how we can extract inly relevant fields of the data source by writing queries. One can also automate the reports & establish security settings in Tableau.

06:05

Learn about the operating systems on which Tableau Desktop can be installed. Pros and Cons of using it on the two operating systems. Also learn about VSA of Tableau, the word coined by ExcelR Solutions. 

05:34

Learn about Tableau start page & how to connect to wide variety of various datasources. Also learn about thumbnails & discover pane, which will help you gain access to amazing real-world projects which are solved in current world. 

10:19

Learn about an interesting case study solved using data visualisation using Tableau, which is called as Location Based Analytics. 

13:24

Learn about the worksheet interface of Tableau including dimensions & measures. Learn on how to covert dimensions to measures & vice-versa. Learn about the terminologies of various components of a worksheet & about show me panel. 

08:12

Learn on how to accomplish a simple visualisation on Bar plot, function of Filters & Marks shelf. Also learn about the usage of double clicking on measures & dimensions. 

Section 2: Statistics for Tableau including Linear Regression, K-Means Clustering & R
16:18

Learn about the basic statistics required to get started with Tableau. As part of this learn about the very first question which any management person would ask pertaining to business. Learn about the measures of central tendency. 

17:29

Learn about the basic statistics required to get started with Tableau. As part of this learn about the very second question which any management person would ask pertaining to business. Learn about the second moment business decision. 

16:25

Learn about the science behind using Bar plot & Histogram. One should know about the applications & uses of each visualisation before accomplishing a specific chart.

06:14

Learn about the various components of Box Plot & how to identify the outliers using this plot. Also learn about the quartiles, IQR, median, etc., of Box Plot. 

18:08

Learn about how to accomplish a simple visualisation using Bar plot & learn on how to make the visualisation tell different stories using a Bar plot by simply dragging the various dimensions & measures around on a worksheet.

16:35

Learn about the steps involved in generating histograms. Also learn about what kind of inferences can be drawn using histogram and explore the opportunities of skewness & thereby long tail effect.

07:11

Learn about steps involved in generating histogram by changing the number of bins. Experimenting by changing the bins in histogram, to derive meaningful insights, is pivotal to the success of drawing business inferences. 

14:23

Learn about the famous 80/20 rule, which says that 80% of problems are because of 20% of causes. Learn about how to generate a Pareto chart & how to draw reference lines. 

09:18

Learn about the famous 80/20 rule, which says that 80% of problems are because of 20% of causes. Learn about how to generate a Pareto chart & how to plot a curved line graph on top of the bar plot.

11:22

Learn about the steps involved in generating Bar Plots by having two axis instead of one. This is accomplished using a concept called as dual axis. 

05:11

Learn about the steps involved in creating a calculated field & using this to generate a Bar Plot for comparison. 

10:43

Learn about the steps involved in accomplishing a Box Plot. Interesting part is to learn about the various components of Box Plot and draw meaningful business insights. 

25:56

Learn about the concepts behind scatter diagrams, which are used to explain about the direction of relationship, strength of relationship & linearity of relationship between 2 variables. Also learn about how to objective way of evaluating strength of relationship using correlation coefficient value. 

12:03

Learn about the various ways of generating scatter plot & how to draw inferences from the scatter plot in Tableau.

27:19

Learn about the concepts of Population & Sample, how to determine sample size. Also learn about calculating the confidence interval using a real world case-study.

13:54

Learn using R on how to generate the Z value & how to manually calculate the confidence intervals using Z-distribution & t-distribution. 

18:33

Learn about simple linear regression concepts and various components which one needs to understand before building prediction models. Also learn about a real world case-study from Life Sciences Health Care industry to understand about building prediction model.

18:31

Learn about the use of R in building prediction model to understand on how to build an equation for prediction. Also learn on how to gage the strength of the model along with the possible transformations to improve the accuracy of the model. 

08:41

Learn on how to build simple linear regression using Tableau Analytics pane. Also learn about the log transformation option of Tableau to see whether the accuracy of the model increases. 

07:25

Learn about exponential & polynomial regression using Tableau. Learn about how to bring back the log of output variable to the original variable by taking exponential. Also learn about how will changing the degrees impact the polynomial regression. 

14:30

Learn about the data visualisation principles which are pivotal for successful reports generation. In order to gain the attention of the stakeholders one has to ensure that visualisation is done based on Tufte's principles, Lie Factor, etc.

18:42

Learn about the data visualization principles including consistent scales, standardized monetary values, presenting data in context, data-ink ratio, chart junks, Moire effect & Necker illusion. 

20:49

Learn about how to connect to a Microsoft Access data source using Tableau. Also learn about establishing connection between R and Tableau in a Windows machine. 

14:22

Learn on how to establish a connection between R and Tableau on a Macintosh Machine. Also learn about how to accomplish K-means clustering using Tableau by having a connection established with R.

34:28

Learn about what is clustering and why K-means clustering is such an important technique within Data Mining Unsupervised learning. 

09:37

Learn about K-Means clustering using R code and understand the output in finer details. 

Section 3: Working with Data using Tableau including Data Extraction & Blending
06:57

Learn about the new feature of Tableau 9.3, which will make the life of most of the analysts simpler by identifying the discrepancies in a dataset and highlighting the auto corrections which have been made by Tableau automatically. 

17:33

Learn about how to change the data types within Tableau from dimensions to measures. Also learn about customising the different views along with Split function of Tableau. 

15:09

Learn about how to use clipboard features in Tableau, how hierarchies are created & changed. Also learn about how to save the metadata and how to share it. 

14:46

Learn about how to extract data from various data sources and how to refresh the changes, either incrementally or fully. 

12:28

Learn about how to work with multiple data sources at one go. Also learn about how to use different fields from the various data sources to accomplish a visualisation to solve business problems. 

15:30

Learn about the integration between Cloudera Hadoop and Tableau. Also learn about how to extract the data from Twitter using Tableau.

Section 4: Various Charts in Tableau including Text Mining
21:55

Learn about when to use trend line chart as part of time series analysis. Also learn about the visualisations pertaining to line chart which will help the business answer a wide variety of questions. 

08:12

Learn about the various mark types in maps using case studies. Learn about creating pie charts on maps and ranking states by sales using maps. 

10:21

Learn about generating a basic line chart and from there on learn about the advanced line chart using multiple panes in Tableau. Also learn about using calculated field while using a line chart.

08:44

Learn about two basic yet powerful default charts used in Tableau. Text table is to visualise the data in textual format. Also learn about the 2 variants of Area chart including discrete & continuous. 

14:14

Learn about the Highlight table, Heat Maps, how to change the colors, filtering and Circle plots, Tree maps & how to draw interesting insights. 

06:33

Learn about the Pie Chart and the use of this in various scenarios. Dos and Don'ts of the Pie chart are extremely imperative because this chart should be sparingly used in real world scenarios. 

07:09

Learn about the use of Bubble chart. Learn on how to generate this chart using the default options of Tableau and also learn on how to manually generate the same. 

09:55

Learn about the Bullet chart and how to set the various target values within the chart. Learn about the various shades of colors within this chart and its implications in drawing inferences. 

Waterfall Chart
03:52
24:22

Learn about the various options within Analytics pane of Tableau, including reference lines, references bands & reference distributions to visualise the various business parameters.

03:02

Learn about how to generate word cloud, also called as tag cloud, manually using Tableau. There is no default chart for word cloud within Tableau. 

20:31

Learn about the science behind generating word clouds & sentiment analysis, including positive & negative word clouds. Also learn about Term Frequency & Term Frequency Inverse Document Frequency, the two key concepts used to generate the word clouds. 

Section 5: Forecasting/Time series/Trend lines in Tableau
Forecasting using Tableau
Preview
14:18
12:23

Learn on why forecasting is so important and a few case studies of forecasting failures. Also learn about the various types of forecasts such as point, interval and density forecasts. 

16:11

Learn on why forecasting is so important and a few case studies of forecasting failures. Also learn about the various types of forecasts such as point, interval and density forecasts. 

12:55

Learn about who does the forecasting and about the dataset to be used for forecasting. Also learn about the various notations which are pivotal for strong foundation.

13:13

Learn about the 8 steps in brief for successful forecasting. Also deep dive on the first step which is Defining Goal, which is the single most important step of the 8-step forecasting strategy.

11:28

Learn about step-2, Data collection in the 8-step forecasting strategy. Also you would gain in-depth knowledge on exploring the data series, which happens to be the 3rd step of the 8-step process. 

Forecasting-Data Exploration & Visualization
26:14
Forecasting-Data Visualization Principles
06:46
Forecasting-Error measures
05:53
Section 6: Tableau Filtering
14:35

Learn about the 'include' & 'exclude' functionalities of filtering. Learn about relative date, range of dates, starting date, ending date, special & various filtering options on a date dimension. 

11:07

Learn about the filter options when we filter on dimensions & measures. Also learn about general, wildcard, condition, top. Also learn on how to apply a filter to all worksheets or only a few. 

10:32

Learn about setting a quick filter and also learn about the various options available to represent the quick filter, including single, multiple value list, dropdown & sliders.

08:43

Learn about creating a parameter and how to show parameter control to perform what-if analysis.

13:07

Learn about creating a parameter and how to use it in the calculated field, which can be used to show case the use of Tableau to perform what-if analysis in solving business problems pertaining to setting goals. 

09:44

Learn about filter action, highlight action & URL action through demonstration of the options using Tableau. Also learn about all the various options available in Filter actions.

09:00

Learn about the Highlight action & the various options are explored thoroughly in this tutorial. Also learn about URL action to navigate to a url in web browser upon clicking a specific entry on the map. 

Section 7: Tableau Groups, Sets, Calculations
12:45

Learn on how to create groups within dimensions by directly exploring the 'Create Group' option. Also learn about creating groups using visual grouping by selecting a specific dimensions or all dimensions. 

20:53

Learn on how to create sets to narrow the dimensions entries and also learn about how to combine multiple sets to generate a visualisation to solve complex business questions. 

11:14

Learn about Ad hoc calculations, which are also called as on-the-fly calculations. Also learn about simple numeric calculation & various components of calculation editor. 

31:34

Learn about the various Numeric calculations, String calculation including converting the customer name into a proper case, date calculations including creating a default date dimension. 

14:05

Learn about creating logic constructs including IF/ELSEIF/ELSE/END, CASE/WHEN/THEN/ELSE/END, IF/ELSE/END, IF/THEN/ELSE/END, etc.

11:53

Learn about aggregation within aggregation using LOD expressions. Also learn about the basic syntax of LOD expressions using FIXED scope keyword and Table scoped LOD expression.

27:16

Learn about the LOD expression scope keywords for aggregation granularity including FIXED LOD expression, INCLUDE & EXCLUDE LOD expressions using business scenarios. 

21:40

Learn about the table calculations such as Grand Totals for rows, columns, Percentage of totals. Also learn about Table (Across), Table (Down), Table (Across then Down), Table (Down then Across).

21:31

Learn on how to calculate 'Year over Year Growth', 'YTD Total', 'YTD Growth' & 'Compound Growth Rate' using Tableau and also learn on how to calculate the same using spreadsheet.

Section 8: Tableau Maps
29:03

Learn about the importance of maps in Tableau. Also learn about the various Geocoded fields, Background maps options and the various geographical roles. 

11:50

Learn about custom geocoding by manually creating latitude & longitude in a spreadsheet. Also learn about how to import custom geocoding so that the latitude & longitude values are included within Tableau for future use. 

09:54

Learn about the various navigating options including 'Zoom In', 'Zoom Out', 'Reset using pushpin', various options of arrow control including Rectangular, Radial, Lasso selection. Also learn about enabling & disabling toolbar menu & map search options. 

12:31

Learn about the various Map Options including 'Map Layers' & 'Data Layers'. Also learn about Web Map Services & Mapbox maps. 

07:17

Learn about setting background images and setting the X & Y coordinates. Also learn about the various options such as 'Lock Aspect Ratio' & 'Always Show Entire Image'.

Tableau_Maps_Mark Types
08:12
Section 9: Tableau Dashboard & Story
21:48

Learn about how to create dashboard, various components of dashboard including worksheets, additional dashboard elements, layout section & sizing section. 

17:31

Learn about tiled and floating containers. Also learn about the various options in the context menu and other dashboard elements usage in the dashboard. 

09:07

Learn about the various filtering options in Dashboard including Filter actions, Highlight actions & URL actions, which are illustrated using business case studies. 

09:40

Learn about the guided analytic using story option of Tableau. Learn about adding story points, which can be worksheets or dashboards. Learn about adding description, setting the size to fit the various needs to display devices. 

Section 10: Tableau 10 New Features

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ExcelR Solutions, Pioneer in professional management trainings & consulting

Certifications:

Certified Six Sigma Master Black Belt

Project Management Professional (PMP)

Agile Certified Practitioner (PMI - ACP)

Risk Management Professional (PMI-RMP)

Certified Scrum Master

Agile Project Management – Foundation & Practitioner from APMG

Bharani Kumar is an Alumnus of premier institutions like IIT & ISB with 15+ years professional experience and worked in various MNCs such as HSBC, ITC, Infosys, Deloitte in various capacities such as Data Scientist, Project Manager, Service Delivery Manager, Process Consultant, Delivery Head etc.

He has trained over 1500 professionals across the globe on Business Analytics, Agile, PMP, Lean Six Sigma, Business analytics and the likes.

He has 8 years of extensive experience in corporate, open house and online training.

He is a thorough implementer with abilities in Business Analytics and Agile projects.

He worked in Delivery management focusing on maximizing business value articulation.

He has a comprehensive experience in leading teams and multiple projects.

Quality Management: A thorough implementer with abilities in Quality management focusing on maximizing customer satisfaction, process compliance and business value articulation; comprehensive experience in leading teams & multiple projects. A result-oriented leader with expertise in devising strategies aimed at enhancing overall organizational growth, sustained profitability of operations and improved business performance.

Project Management: Project Management Professional involved in Initiation, Planning, Execution, Monitoring & Controlling and Closing phases of project activities. Devising and implementing project plans within preset budgets and deadlines and managing the projects towards successful delivery of project deliverables and meeting project objectives.

Training: Close to 8 years training experience and conducted multiple trainings in PMP, Agile, Six Sigma, Business Analytics and Process Excellence across the globe. Understands the individual differences of the attendees and possesses excellent training skills and considered as one of the best trainers in his areas of expertise.

Ready to start learning?
Take This Course