Business Reporting With Tableau


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.