Create and share data insights across your company in minutes using Tableau

Tableau Developer

 

Course Code: TBPG01

Duration: 16 Hours

Tableau Developer course by Computing Academics, is comprehensively designed to explain from basics of data visualization and business intelligence using Tableau. The course is based on extensive hands-on practice, so that the candidate gets expertise in all the concepts taught and would become knowledgeable to work on real time projects. Apart from lab exercises for each of the modules listed, you will be assigned with project(s), that would be based on real world requirements and problems. You will be well equipped to perform Tableau developer job functions, through this course.

Audience

• Data Analysts and Business Analysts
• Application, Information and Data Architects
• Project Managers
• Data warehouse and business intelligence professionals
• Recent graduates who want to learn and pursue a career in Data Science, business analytics and Big Data
• Those who would like to obtain a professional certification from Tableau.

Prerequisites

Required Prerequisites:

Basic working knowledge of computers. Basic knowledge in data processing

Suggested Prerequisites:

None

Objective

Upon successful completion of the course, participants are expected to be proficient in:
• Usage of Tableau in industries and how they are used
• Install and configure Tableau Desktop
• Connect Tableau to various data sources
• Learn to Organize and Simplify data such as filtering, sorting, grouping
• Learn to apply formatting annotations
• Learn special field types
• Learn Tableau-generated fields
• Become a master in creating various charts
• Understand various calculations that can be applied
• Learn to create and use parameters
• Learn to apply mapping
• Gain knowledge in applying statistical functions
• Become an expert in creating and modifying dashboards
• Become an expert in real time deployment by working on case study

Module: Introduction to Tableau - 1 Hour

- Benefits of Tableau
- Use of Tableau in the industry

Module: Field Types and Visual Cues - 1 Hour

- Application terminology and definitions
- View terminology and definitions
- Fields on shelves
- Visual cues for fields
- Fields in the data window
- Data terminology and definitions
- Exercises

Module: Data connections - 1 Hour

- Connecting to Tableau Data Server
- From the same database, understand connection options
- Working with extracts
- Custom SQL Data connection
- Database joins
- Database blending
- Understanding Kerberos authentication
- Understanding performance optimization
- Parallel query
- Data engine vectorization
- Parallel aggregation
- External query caching
- Query fusion
- Tableau Data Interpretor
- Metadata grid
- Pivot
- Exercises

Module: Organizing and Simplifying Data - 1 Hour

- Filtering
- Sorting
- Creating a combined field
- Grouping
- Sets
- Drilling, Hierarchies
- Grand Totals, Sub-totals and Changing Aggregation
- Bins
- Exercises

Module: Formatting and Annotations - 1 Hour

- Use spatial analysis
- Effectively use titles, captions and tooltips (tutorial)
- Hortonworks Sandbox Installation and Configuration
- Format results with edit axes
- Formatting Your View
- Format results with mark labels and annotations
- Exercises

Module: Special Field Types - 1 Hour

- Date hierarchies (tutorial)
- Different date parts on different shelves
- Discrete and continuous date parts
- Continuous dates
- Custom dates
- Define a fiscal year
- Relative date filtering
- Date hierarchies and OLAP considerations
- Exercises

Module: Tableau-generated fields - 1 Hour

- Measure values and names (tutorial)
- When to use measure values and names
- Number of records
- Generated latitude and longitude
- Exercises

Module: Chart Types - 1 Hour

- Combined or Shared Axis Charts
- Combo charts – bar and line or mixed mark
- Geographic mappings and geocoding (tutorial)
- Scatter plots – scattergraph
- Cross tabs – text tables or pivot tables
- Highlight table
- Motion Charts
- Heat maps
- Bins, histograms, calculated bins
- Motion charts – working with Page Shelf and History
- Pie charts
- Bullet graphs
- Bar in bar
- Box plots – box and whisker diagram or plot (tutorial)
- Market Basket Analysis
- Waterfall Charts
- Gantt bar chart
- Exercises

Module: Calculations - 1 Hour

- Manipulate strings calculations
- Date Calculations
- Build arithmetic calculations
- Work with aggregation options (tutorial)
- Build logic statements (tutorial)
- Build grand totals, sub-totals and changing aggregation
- Create quick table calculations
- Use automatic & custom split
- Use Ad-hoc Analytics
- Exercises

Module: Creating and Using Parameters - 1 Hour

- Creating Parameters
- Using Parameters and Reference Lines
- Using Parameters with Filters
- Exercises

Module: Mapping

- Modify locations within Tableau
- Import and manage custom geocoding (tutorial)
- Use a background image map (tutorial)
- Modifying Geocode Locations within Tableau
- Use Geographic search
- Use Map Data & Pan/Zoom
- Use Lasso & Radial Selection
- Exercises

Module: Statistics - 1 Hour

- Reference lines
- Reference bands
- Reference distributions
- Trend lines
- Trend model
- Statistical summary card
- Drag & Drop Analytics
- Instant Analytics
- Exercises

Module: Dashboards - 2 Hours

- Build dashboards (tutorial)
- Utilize visual best practices for dashboard design
- Use options for running actions
- URL actions
- Highlight actions
- Filter actions
- Create a drill-down report
- Sharing Your Work
- Exercises

Module: Case study - 2 Hours

- Understanding what to do with the data
- Support and help in completing a case study