ArchiTech IT

Course information

Tableau: is a leading data visualization tool used for data analysis and business intelligence. Gartner’s Magic Quadrant classified Tableau as a leader for analytics and business intelligence. This Tableau tutorial will cover a wide range of how-to topics, including how to create different charts and graphs, in addition to visualizing data through reports and dashboards in Tableau to derive meaningful insights.

Tableau has a lot of unique, exciting features that make it one of the most popular tools in business intelligence (BI). Let’s learn more about some of the essential Tableau Desktop features.  Tableau is a widely used BI and analytics software trusted by companies like Amazon and Unilever to explore, create, and securely share contextualized data. In this course, you will learn how to build data visualizations, conduct data analyses and adopt best practices of data formatting with Tableau.

 It helps in simplifying raw data in a very easily understandable format. Tableau helps create the data that can be understood by professionals at any level in an organization. It also allows non-technical users to create customized dashboards.

The great thing about Tableau software is that it doesn’t require any technical or any kind of programming skills to operate. The tool has garnered interest among the people from all sectors such as business, researchers, different industries, etc.

TERA DATA TUTORIAL: Teradata is the most popular Relational Database Management System (RDBMS). The Teradata is suitable for large data warehousing applications. Teradata can handle large volumes of data and highly scalable.

It can run on Linux, UNIX, or Windows server platforms. This tool supports multiple data warehouse operations at the same time to different clients. It is designed or developed by a company named Teradata.

Teradata Corporat

Complete Set of Tableau 

Prerequisites: Excel

Add on: SQLite or SQL Server Basics
MDX with Tableau
Integration to Python and R
Live Project

Before Starting Tableau, I will go with SQLite or SQL Server Basics which is Mandatory

Tableau Contents

Main Module: Architecture of Tableau

Module 1: Tableau Course Material  
Start Page
Show Me
Connecting to Excel Files
Connecting to Text Files
Connect to Microsoft SQL Server
Connecting to Microsoft Analysis Services
Creating and Removing Hierarchies
Bins
Joining Tables
Data Blending

Module 2: Learn Tableau Basic Reports  

Parameters
Grouping Example 1
Grouping Example 2
Edit Groups
Set
Combined Sets
Creating a First Report
Data Labels
Create Folders
Sorting Data
Add Totals, Sub Totals, and Grand Totals to Report

Module 3: Learn Tableau Charts 
Area Chart
Bar Chart
Box Plot
Bubble Chart
Bump Chart
Bullet Graph
Circle Views
Dual Combination Chart
Dual Lines Chart
Funnel Chart
Traditional Funnel Charts
Gantt chart
Grouped Bar or Side by Side Bars Chart
Heat map
Highlight Table
Histogram
Cumulative Histogram
Line Chart
Lollipop Chart
Pareto Chart
Pie Chart
Scatter Plot
Stacked Bar Chart
Text Label
Tree Map
Word Cloud
Waterfall Chart

Module 4: Learn Tableau Advanced Reports  

Dual Axis Reports
Blended Axis
Individual Axis
Add Reference Lines
Reference Bands
Reference Distributions
Basic Maps
Symbol Map
Use Google Maps
Map box Maps as a Background Map
WMS Server Map as a Background Map

Module 5: Learn Tableau Calculations & Filters -- we will discuss about MDX Commands here

Calculated Fields
Basic Approach to Calculate Rank
Advanced Approach to Calculate Ra
Calculating Running Total
Filters Introduction
Quick Filters
Filters on Dimensions
Conditional Filters
Top and Bottom Filters
Filters on Measures
Context Filters
Slicing Filters
Data Source Filters
Extract Filters

Module 6: Learn Tableau Dashboards 

Create a Dashboard
Format Dashboard Layout
Create a Device Preview of a Dashboard
Create Filters on Dashboard
Dashboard Objects
Create a Story

Module 7: Server 
Tableau online.
Overview of Tableau Server.
Publishing Tableau objects and scheduling/subscription.

Module 8: Integration with Python and R
Python Basics and then linked with Tableau
R Basics and then linked with Tableau -- Optional

MDX Course Outline 
Module 10
The Business Intelligence Landscape the Dimensional Model Implementing the Dimensional Model the MDX Language
Module 11:
 Using the MDX Query EditorSQL Server Management Studio the MDX Query Editor Building a Simple MDX Query Exploring the Step-by-Step Cube Building a More Complex Query
Module 12: 
Understanding TuplesN-dimensional Space Cube Space Accessing Data with Tuples Understanding Cells Working with Partial Tuples Building Tuples with User-Hierarchies
Module 13: 
Working with Sets Set Basics Understanding the SELECT Statement Building Sets with Functions Limiting Sets
Module 14: 
Working with ExpressionsExpression BasicsCalculated MembersBuilding Dynamic ExpressionsResolving Contextual ConflictsBuilding Complex Expressions
Module 15: 
Building Complex SetsAssembling Ordered SetsRetrieving the First or Last Tuples of a SetFiltering SetsCombining SetsPerforming Advanced Set Construction
Module 16: 
Performing AggregationPerforming SummationCalculating AveragesIdentifying Minimum and Maximum ValuesCounting Tuples in Sets
Module 17:
 Navigating HierarchiesAccessing Immediate RelativesAccessing Extended RelativesNavigating within a Level
Module 18: 
Working with TimeUnderstanding the Time DimensionCalculating an Accumulating TotalPerforming Period-over-Period AnalysisCombining Time-Based Metrics
Module 19:
 Enhancing the Cube (Optional)
Understanding the MDX ScriptConstructing Calculated MembersAssembling Named Sets
Module 20: 
Building Reports (Optional)
Getting StartedConnecting to Analysis ServicesDesigning the DatasetAdding Parameters to the DatasetPresenting the Data in the Report

Module 21: Assignments will be provided after the class for the required topics.

Module 22: Live Project