Single
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
You will get various benefits by joining our courses. Here is a list of some of the benefits.
1615 Poydras St #1400, New Orleans, LA 70112, United States
+1 504-370-3377
info@proarkits.com
ProArk ITs is one of the leading online training and placement organization. We deal in Training, Corporate Training, Job Assistance, and Placement.
© ProArk ITs. All Rights Reserved. Designed by ProArk ITs