Duration
1 months
Mode
Online/Offline
Batch Size
10
Modules
1
LMS Access
Yes
Timing
Weekday/Weekends
Introduction
This tool allows you connecting different data sources, data warehouses, cloud files, big data, spreadsheet data, non-relational, and several other types of data. Tableau can blend every kind of data to help organizations for producing attractive visualizations.
It also allows you to create visualizations as simple as a bar chart or a pie chart, as well as more complex ones like a histogram, Gantt chart, Bullet chart, Motion chart, Treemap, Boxplot, and many other
Goal of Course
- Communicating Business Information And Explanations.
- Communicating Comprehensive Data And Commentary That Complies With Reporting Requirements And Addresses Possible Investor Concerns.
- Providing Accurate Information On The Amount, Completeness, And Compliance With Reporting Requirements And Accounting Standards.
Key Modules
- Tableau Desktop Interface
- Connecting Data Sources
- Organizing and Formatting Data
- Adoc Calculations
- Visualizations
- Create Dashboards and Stories
Introduction to Tableau Desktop
- Overview Of Business Intelligence
- Introduction To Tableau Desktop
- Use And Benefits Of Tableau Desktop
- Tableau'S Offerings
- Data Source Page
- Worksheet Interface
- Creating A Basic View
Connecting Data Sources
- Data Types
- Data Roles
- Visual Cues For Fields
- Data Preparation
- Data Source Optimization
- Joins
- Cross Database Joins
- Data Blending
- Joining Vs. Blending
- Union
- Creating Data Extracts
- Writing Custom SQL
Organizing & Formatting Data
- Filtering Data,
- Sorting Data, Creating Combined Fields
- Creating Groups And Defining Aliases
- Working With Sets And Combined Sets
- Drilling And Hierarchy
- Adding Grand Totals And Subtotals
- Changing Aggregation Functions
- Data Blending
- Effectively Use Titles, Captions, And Tooltips
- Format Results With The Edit Axes
- Formatting Your View
- Formatting Results With Labels And Annotations
- Enabling Legends per Measure
Writing Table Queries
- Retrieving data with SELECT
- Restricting rows with the WHERE filter
- Sorting the result with ORDER BY
- Handling NULL values in expressions
- Avoiding NULL value pitfalls in filter conditions
- Matching related rows with INNER JOIN
- Including nonmatched rows with OUTER JOIN
- Creating a Cartesian product with CROSS JOIN
- Stacking results with UNION
- Identifying matching rows with INTERSECT
- Utilizing EXCEPT to find nonmatching rows
- Processing data with row functions
- Conditional formatting with the CASE expression
- Utilizing the CASE expression to simulate IF tests
- Dealing with NULL values
- Performing analysis with aggregate functions
- Summarizing data using SUM, AVG and COUNT
- Finding the highest/lowest values with MAX and MIN
- Defining the summary level with GROUP BY
- Applying filter conditions with HAVING
- Constructing Nested Queries
- Applying subqueries in filter conditions
- Correlated vs. noncorrelated subqueries
Calculations & Visualization
- Use Strings, Date, Logical, And Arithmetic Calculations
- Create Table Calculations, Discover Ad-Hoc Analytics
- Perform Lod Calculations
- Creating Basic Charts Such As Heat Map, Tree Map, Bullet Chart Etc.
- Creating Advanced Chart As Waterfall, Pareto, Gantt, Market Basket
Create Dashboards and Stories
- Dashboard Interface
- Build Interactive Dashboards
- Explore Dashboard Actions
- Best Practices For Creating Effective Dashboards
- Story Interface
- Creating Stories
- Share Your Work
Note :you can speak to our team for detailed content and available batch timings.
