Tableau Course Content
Data Warehouse Introduction
Difference between OLTP and OLAP
What is Fact
What is Dimension
Data Modeling Techniques
Star Schema
Snow Flake Schema
Galaxy or Hybrid Schema
Types of Facts
Types of Dimensions
Tableau Components
Tableau Desktop
Tableau Extensions
Different Connections
Diff bw Live and Extract
Extract Incremental Refresh
Excel Legacy Connection
Custom SQL Query
Pivot and Split
Marks Card
Page Shelf
Show ME
Sheets/Dashboards/Story
Sample Reports
Types of Filters
Hierarchies
Groups
Sets
Bins
Types of Actions
Parameters and diff Types
Importance and Drawbacks of Parameters
Calculated Columns
Annotations
Forecasting
Formatting
Tableau Data Blending
Add Table Calculations
Functions- String/Date/Number
Lookup and Helping Functions
Maps
Reference Lines
LOD’s – Level of Detail
Types of Charts
Tableau Notes
Why Tableau?
Transforming data into insight is critical for projects large and small. Excel has long been used for much of this analysis. But when it comes to visualizing data, creating interactive dashboards, managing unlimited data, and supporting real-time data discovery it doesn’t fit the bill. As Andy Kriebel of Coca-Cola Refreshments puts it, “Excel has its place. I mean, it’s a spreadsheet tool.” But only Tableau turns spreadsheet data into self-service BI. Meet three Tableau aficionados and learn how they’ve replaced what they used to do in Excel with Tableau to discover patterns, expose trends and uncover instant insight from their data.
What is Data Visualizations?
Data visualization is, quite simply, the process of describing information through visual rendering. Humans have used visualizations to explain the world around them for millions of years. Data visualisation allows for universal and immediate insight by tapping into our mind’s powerful visual processing system.
Why is Data Visualisation Important?
Technological advances have made data visualisation more prevalent and powerful than ever before, increasing the importance of business intelligence. Tableau leads the world in making the data visualisation process available to business users of every background and industry. Businesses around the globe realize that the ability to visualize data effectively leads directly to better understanding, insight and better business decisions.
What is Tableau?
Tableau is groundbreaking data visualisation software created by Tableau Software. Tableau connects easily to nearly any data source, be it corporate Data Warehouse, Microsoft Excel or web-based data. Tableau allows for instantaneous insight by transforming data into visually appealing, interactive visualisations called dashboards. This process takes only seconds or minutes rather than months or years, and is achieved through the use of an easy to use drag-and-drop interface.
Components of Tableau:
- Tableau Desktop
- Tableau Server
- Tableau Public
- Tableau Reader
- Tableau Online
Tableau Desktop:
• It allows the user to Create ,format & visualize the reports .
• All the work done will be saving in Dashboard.
• There are three editions for Tableau Desktop: Tableau Server
• Tableau Server is a web based business intelligence platform.
• It provides business based analytics.
• The reports that are published through Tableau Desktop can be viewed through this using the Live link.
• Dashboard can be uploaded to tableau server from tableau desktop.
• Users can access the server by login into the Tableau Server Tableau Public
• It’s a free product from Tableau
• Visualizations enthusiast can view the data in data sets.
• Data will be stored online not on the local machine.
• Data will be shared via online.
• The data storage capacity is 1GB
Tableau Cloud:
• Its similar to Tableau Server but the servers are stored on cloud • Servers are not manage by the users but by the tableau analysts.
• Its requires an annual subscriptions charges i.e. its not a free product from tableau.
Tableau Reader:
• Tableau Reader is a desktop application where users can open and view visualizations created in
• Tableau Reader is a simple way to share analytical insights.
• Its similar to Adobe Reader.
VizQL : Tableau Query
• VizQL is a visual query language that transforms drag-and-drop activities into queries and then Expresses that data visually.
• It has ability to understand complexities of query and analysis.
• It provides intuitive user experience.
• VizQL is advancement in the area of data analysis and visualization.
Tableau Benefits
• Speed
• Ease of use
• Beautiful and interactive dashboard
• Direct connection
• Easy publishing and sharing
• Growing market.