Author Topic: Content of Tableau in Database Analysis  (Read 10185 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
Content of Tableau in Database Analysis
« on: January 03, 2015, 09:55:59 AM »
Tableau in Database Analysis  Tableau in Database Analysis 第二期 11:00 to 14:00 (USA PST) or 14:00 to 17:00 (USA EST) Sunday 4/26/2015 to 5/24/2015.
Five  3 hour sessions, total 15 hours.


Connect and visualize your data in minutes. Tableau is 10 to 100x faster than existing solutions. Anyone can analyze data with Tableau's intuitive drag & drop products. No programming, just insight. Publish a dashboard with a few clicks to share it live on the web and on mobile devices. From spreadsheets to databases to Hadoop to cloud services, explore any data with Tableau.

Course Description:
This workshop will introduce Tableau Public and Tableau Desktop from scratch. Will teach student how to install Tableau software steo by step. We’ll also cover Tableau Server using screenshot. Lastly will introduce R the open source statistical software, and how it can be integrated into Tableau for some basic statistical analysis and data mining. Once completed, students should feel comfortable building dashboards with actions, gain intermediate level of working knowledge with performance optimization and security.

Tableau Course Outline

Content 1:

•   Download and install Tableau Public
•   Connect to Data
•   Connect to Excel, CSV and Text Files
•   Edit Data Sources
•   Reshaping Data
•   Dimensions vs. Measures
•   Hierarchies
•   Toolbar: Show me, Swap, Sorting, Show mark labels
•   Grouping
•   Create Calculated Fields
•   String Functions, Logic Functions
•   Lab #1

Content 2:
•   Filtering
•   Table Calculation
•   Tooltip
•   Formatting
•   Mapping
•   Page shelf
•   Building a Dashboard
•   Dashboard Action – filter actions
•   Parameters (1) - Top N Rank
•   Lab #2

Content 3:
•   Set
•   Parameters (2)
•   Dashboard Action – URL actions, highlight actions
•   Trend lines
•   Forecasting
•   Tableau Desktop
•   Connecting to Databases
•   Connecting to single or multiple tables
•   Data Blending
•   Sharing
•   Lab #3
 
Content 4:
•   Tableau Server
•   Projects, Workbooks, Views
•   Data Sources
•   Admin Maintenance
•   Users, Groups
•   Schedules, Tasks
•   Performance optimization
•   Security
•   Lab #4

Content 5:
•   Tableau Server Cont’
•   R integration


Pre-requisition: None