Business Intelligence Masters Program

Birchwood University’s Data Warehousing and Business Intelligence Course will introduce the participants to create and work with the Industries leading ETL & Business Intelligence tools like Talend 5.x & Tableau 9.x and a Data Modelling tool ER Win r9. Developers can use the ER Win r9 tool to create a Data Ware House or Data Mart. Developers can use Talend to create, execute, monitor and schedule ETL processes. The course will cover different components of Talend 5.x Open Data Integration Studio and show how they are used in Data Replication, Migration and Integration operations. Developers can use Tableau 9.x for data visualization to see how easy and reliable data visualization can become for representation with dashboards.

Module Outline

Module 1: Introduction to Data Warehouse & Business Intelligence

Learning Objectives
In this module, you will get an introduction of Data Warehousing and Business Intelligence with various ETL Tools and BI Tools with ERWin r9 Data Modeling.

Topics:

• What is Data Warehousing?
• Definitions by W.H. Inmon [Top-Down Design]
• Ralph Kimball [Bottom-Up Design]
• Inmon vs. Ralph Kimball
• Data Warehousing Tools
• Schema Modeling Tools
• CA
• ERWin
• Dell Toad Data Modeler
• Oracle Data Modeler
• ETL Tools: Informatica Power Center
• Talend DI Open Studio
• BM Data Stage
• SAS
• Data Warehousing categories
• What is BI - BUSINESS INTELLIGENCE?
• BI Definition, BI Tools, Classification of BI Tools

Module 2: Data Warehouse Architecture

Learning Objectives
In this module, you will learn about the Data Warehouse Architecture which talks about the Various Source Systems i.e. Production Data into Relational, Flat File and various legacy system to the Staging Area and finally into the Data Warehousing/Data Mart for the presentation layer.

Topics:

• Relational Vs Analytical
• Data Warehouse Vs Data Mart
• What are - OLTP, OLAP, OLAP categories, MOLAP, ROLAP, HOLAP
• Dependent and Independent Data Mart
• Data Warehouse Architecture
• Source System
• ETL Extraction, Transformation
• What is a cube?
• Benefits of cube?
• How to create the cube?
• How to deploy a cube?
• How to create a report using a cube?

Module 3: Warehouse: D & F Dimension & Fact Tables

Learning Objectives
In this module, you will learn about different categories of Dimensional and Fact Type tables. Dimension - Slowly Changing Dimension concepts with Hierarchies and Level Attributes. Fact - Granularity for the fact data and talks about the Measure Type.

Topics:

• What is a Dimension Table?
• Dimension table categories
• What is a Fact Table?
• Fact Table Granularity
• Fact Table categories

Module 4: Data Modeling

Learning Objectives
In this module, you will learn about Data Normalization and their 3 types of normal forms. Here you learn about the type of dimensional modeling benefits, principal and their characteristics and Dimensional Modeling Type and Technique.

Topics:

• What is Data Normalization?
• Data Normalization Rules -1NF, 2NF, 3NF
• Data De-Normalization
• What is Dimensional Modeling?
• Principles, Benefits, Type and Technique

Module 5: Building Data Warehouse with ER Win

Learning Objectives
In this module you will see how we create a staging and target data warehouse and data marts from scratch to final. Decide the surrogate key, Dimension and Fact Tables. You also learn to generate the SQL scripts via ERWin r9.

Topics:

• Source System Understanding
• Future Data Requirement
• Designing and Developing Dimension Table
• Designing and Developing Fact Table
• Designing and Developing ER Model with ERWin
• Designing and Developing Entity Relationship Modeling

Module 6: Introduction to Open Source ETL Tool Talend DI Open Studio 5.x

Learning Objectives
In this module, you will learn about the open source and commercial ETL Tools available into the market and its various comparisons. You will learn to create the flat file and relational target via Talend DI Open Studio 5.x using various Transformations.

Topics:

• Open source ETL Talend DI Open Studio - Difference between Licensed and Open Source ETL Tools
• What are Licensed and Open Source ETL Tools
• Working with ETL Transformation in Talend Open DI Studio

Module 7: Building ETL Project With Talend DI Open Studio 5.x

Learning Objectives
In this module, you will learn to create the actual business model and data integration jobs with management of various ETL items. You will learn how the actual ETL Projects work with BRD [Business Requirement Document] and TDD [Technical Design Document] and its uses.

Topics:

• Building ETL Project Talend DI Open Studio
• Understanding the Data Source System which will be a future Data Requirement
• Identify Business Requirement Gathering
• Building the ETL Talend Technical Design Document
• Building an ETL Project

Module 8: Introduction to Data Visualization BI Tool Tableau 9.x

Learning Objectives
In this module, you will learn about the Data Visualization Tools available in the market. You will learn to create reports and dashboards via Tableau 9.x using various functions.

Topics:

• Data Visualization BI Tool: Tableau 9.x-Introduction to Data Visualization with Tableau
• Exploring Data Visualization with Tableau
• What is Data Visualization?
• Exporting Data and Working with Tableau

Module 9: Building Data Visualization BI Project with Tableau 9.x

Learning Objectives
In this module, you will learn to create reports and dashboards via Tableau 9.x using various advance features and functions. You also need to understand the various current and new report requirements.

Topics:

• Building Data Visualization BI Project with Tableau 9.x
• BI Reporting Understanding
• Report and Dashboard Template Document
• Tableau Design and Development Database Source Connection

Module 10: An Integrated Data Ware Housing & BI Project

Learning Objectives
This is an integrated Data Ware Housing and Business Intelligence Project which starts from User Source System and Business Requirement Gathering till end of Project Development with production support strategies developments.

Topics:

• An Integrated Data Ware Housing & BI Project
• Developing a Data Warehouse & BI Project
• Source System Understanding
• Understanding today's Data that will be the future Data Requirement
• Identify the Business Requirement Gathering
• Report and Dashboard Template Document
• Designing and Developing Models
• Designing and Developing the Staging Area
• Finalizing the Dimension Modeling Type
• Designing and Developing Dimension Modeling

Project Work

Learning Objectives
Towards the end of the Course, you will be working on a live project where you will be using Adventure Work Dataset, Sales Dataset to perform various data and reporting analytics.

• Project #1: Creation of Sales Data Warehouse & Data Marts.
  Industry: Retail
  Data: North-wind/Adventure Works dataset.
  Problem Statement: Creation Sales Data Mart using ER Win r9.
• Project #2: Transaction Analysis for Retail
  Industry: Retail
  Data: Sales data from Real time retail project. (Data will be masked)
  Problem Statement: Analyzing & Loading Retail Transaction Data using Talend.
• Project #3: Transaction Analysis for Retail Analytics
  Industry: Retail
  Data: Real Time Retail Analytics Dashboard Project.
  Problem Statement: Building Real Time Retail Analytics Dashboard using Tableau.

Birchwood University’s Microsoft Power BI Training introduces you to Power BI Desktop and how it is used with Power Pivot for Data Modelling. This course enables you to learn about Data Analysis Expressions (DAX) and Data Visualization with Power BI Desktop, Power View and Power Map.

This course will also introduce you to Power BI Q&A, which enables you to discover, explore and visualize enterprise data using Natural Language.

Module 1: Introduction to Power BI

Learning Objectives
This module will introduce you to Power BI, its building blocks and the various fundamental concepts of Power BI.

Topics:

• Business Intelligence
• Self Service Business Intelligence
• SSBI Tools
• Power BI vs Tableau vs QlikView
• What is Power BI
• Why Power BI?
• Key Benefits of Power BI
• Flow of Power BI
• Components of Power BI
• Architecture of Power BI
• Building Blocks of Power BI
• Question Bank

Module 2: Power BI Desktop and Data Transformation

Learning Objectives
This module will introduce you to Power BI Desktop. You will know how to extract data from various sources and establish connections with Power BI Desktop, perform transformation operations on data and the Role of Query Editor in Power BI.

Topics:

• Overview of Power BI Desktop
• Data Sources in Power BI Desktop
• Connecting to a data Sources
• Query Editor in Power BI
• Query Ribbon
• Clean and Transform your data with Query Editor
• Combining Data – Merging and Appending
• Cleaning irregularly formatted data
• Views in Power BI Desktop
• Modelling Data
• Manage Data Relationship
• Automatic Relationship Updates
• Template Apps
• Cross Filter Direction
• Create calculated tables and measures
• Optimizing Data Models
• PBIDS Files
• Question Bank

Module 3: Data Analysis Expressions (DAX)

Learning Objectives
This module will help you learn the basics of DAX in Power BI Desktop

Topics:

• Essential concepts in DAX
• Why is DAX important?
• DAX Syntax
• Data Types in DAX
• Ranking and rank over groups
• Filter and evaluation context
• Context interactions
• Calculation Types
• DAX Functions
• Measures in DAX
• DAX Operators
• DAX tables and filtering
• DAX queries
• Create simple and compound measures
• Schema relations
• Star schema design
• DAX Parameter Naming
• Question Bank

Module 4: Data Visualization

Learning Objectives
This module will help you understand the benefits and best practices of Data Visualization. It will also help you in creating charts using Custom Visuals.

Topics:

• Introduction to visuals in Power BI
• Charts in Power BI
• Matrixes and tables
• Slicers
• Map Visualizations
• Gauges and Single Number Cards
• Create scatter, waterfall, and funnel charts
• Modifying colors in charts and visuals
• Shapes, text boxes, and images
• What Are Custom Visuals?
• Page layout and formatting
• KPI Visuals
• Z-Order
• Explore time-based data
• AppSource
• Question Bank

Module 5: Introduction to Power BI Service, Q&A and Quick Insights

Learning Objectives
This module will help you in creating Dashboards and publishing it on Power BI services. You will also be taught to monitor Real-time Data with REST API.

Topics:

• Introduction to Power BI Service
• Introduction to using workspaces
• Dashboard vs. Reports
• Quick Insights in Power BI
• CrConfiguring a Dashboard
• Power BI Q&A
• Ask questions of your data with natural language
• Power BI embedded
• Create custom Q&A suggestions
• Edit tile details and add widgets
• Build apps
• Integrate OneDrive for Business with Power BI
• Question Bank
• Case Studyeating Dashboards

Module 6: Connectivity Modes

Learning Objectives
This module will help you learn, how to connect data sources directly to Azure, HD Spark, My SQL, and create interactive dashboards.

Topics:

• Introduction to using Excel data in Power BI
• Exploring live connections to data with Power BI
• Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
• Introduction to Power BI Development API
• Import Power View and Power Pivot to Power BI
• Data caching and refresh
• Introducing Power BI Mobile
• Question Bank

Module 7: Power BI Report Servers

Learning Objectives
This module will help you understand Power BI Report Servers and data gateways. Also you will learn about the web portal in which you display and manage reports and KPI’s .

Topics:

• Report Server Basics
• Web Portal
• Paginated Reports
• Row level Security
• Data Gateways
• Scheduled Refresh
• Configure scheduled refresh
• Create a publish-to-web embed code
• Customize the sample Power BI file
• Question Bank
• Case Study

Module 8: Using R & Python in Power BI

Learning Objectives
This module will help you create R and Python visuals in Power BI Desktop as well as in Power BI Service.

Topics

• R Integration in Power BI Desktop
• R visuals in Power BI
• R Powered Custom Visuals
• Creating R visuals in Power BI
• R Visuals in Power BI Service
• R Scripts Security
• Creating visual using Python
• Question Bank
• Case Study

Module 9: PowerCenter Repository Management

Learning Objectives
This module will help you perform advanced analysis using Anomaly Detection and Smart Narrative visualisation in Power BI.

Topics:

• Using Parameters
• Create a data flow
• Introduction to Anomaly Detection
• Introduction to Smart Narrative
• Introduction to Sensitivity labels in Power BI
• Deployment Pipeline

Module 10: In-class Project

Learning Objectives
Here in you will develop an exhaustive project where you will incorporate all your learnings of Power BI. At the end of this module you should be able to learn to incorporate various features as per the requirements of your Enterprise

Topics Covered:

• The comprehensive project covers all essentials of the course.

The course provides you the overview of Informatica PowerCenter Product and its installation, the concepts of data integration and data warehousing. You will learn how different development units of PowerCenter can be used to create a simple mapping. It introduces you to advanced transformation techniques, and ETL scenarios using Informatica 10. You will understand the features provided by Informatica to debug, troubleshoot and handle errors. You will learn the best practices for optimum performance of your ETL process; to manage the repository effectively.

Module 1: Informatica PowerCenter 10 – An Overview

Learning Objectives
Upon completing this module, you should be able to explain Informatica & Informatica Product Suite, explain the purpose of PowerCenter as ETL Tool, describe PowerCenter Architecture, explain component-based development techniques in PowerCenter, explain the new features of Informatica 10.X over 9.X.

Topics

• Informatica & Informatica Product Suite
• PowerCenter as ETL Tool
• PowerCenter Architecture
• Component-based development techniques

Module 2: Data Integration and Data Warehousing Fundamentals

Learning Objectives
At the end of this module, you should be able to explain Data Integration concepts, understand Data Profile and Data Quality, describe ETL Architecture & Process flow, describe different ETL methods & Tools, explain Data Warehouse Concepts & Architecture.

Topics:

• Data Integration Concepts
• Data Profile and Data Quality Management
• ETL and ETL architecture
• Brief on Data Warehousing

Module 3: PowerCenter Transformations

Learning Objectives
At the end of this module, you should be able to describe & Visualize PowerCenter Client Tools, understand basics of Data Flow, explain how to create & Execute mapping, explain different Transformations & their usage.

Topics:

• Visualize PowerCenter client tools
• Data Flow
• Create & execute mapping
• Transformations & their usage

Module 4: PowerCenter Tasks & Workflows

Learning Objectives
At the end of this module you should be able to explain PowerCenter Workflow Manager, describe Flow within a Workflow, describe Reusability & Scheduling in Workflow Manager, understand components of Workflow Monitor, explain Workflow Task and job handling.

Topics:

• PowerCenter Workflow Manager
• Flow within a Workflow
• Reusability & Scheduling in Workflow Manager
• Components of Workflow Monitor
• Workflow Task and job handling

Module 5: Advanced Transformations, Techniques & Reusability Features

Learning Objectives
Advanced Transformation techniques will equip you to deal with advanced concepts of PowerCenter transformations like Java, XML etc. of PowerCenter. We will also discuss about transaction processing & reusability features available in Informatica.

Topics:

• Advanced transformations (Java, SQL, Normalizer)
• XML File Processing & Transaction Processing
• Error handling features
• Cleaning the data (Advanced Functions, Regular Expressions)
• Reusability features

Module 6: ETL Scenarios using Informatica

Learning Objectives
We will discuss advanced ETL scenarios using Informatica. You will be introduced to the concepts - Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint Based Loading, Target Load Order Group, CDC (Change data Capture) etc. We will also discuss about creating Data Warehouse related processes like SCD, Fact and Dimension Loading.

Topics:

• Changed Data Capture, Incremental Aggregation, Constraint Based Loading, etc.
• Advanced techniques - Flat File, XML File
• Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)

Module 7: Service & Support of PowerCenter Environment

Learning Objectives
In this module, you will understand: Describe basic PowerCenter Error. Follow a basic troubleshooting methodology. Use the debugger. Use Workflow and Session logs to diagnose errors. Recognize & repair Connection Errors & Network errors. Understand the recovery scenarios & mechanisms. Configure Workflow & sessions for recovery. Understand the purpose of High Availability. Monitor the PowerCenter Environment.

Topics:

• PowerCenter Error
• Basic troubleshooting methodology
• Debugger
• Workflow and Session logs to diagnose errors
• Connection Errors & Network errors
• Recovery scenarios & mechanisms
• Configure workflow & sessions for recovery
• High Availability
• PowerCenter Environment

Module 8: Performance Tuning, Design Principles & Caches

Learning Objectives
In this module, you will understand: Understand the Performance Tuning Methodology. Learn Mapping design tips & tricks. Explain Caching & Memory Optimization. Learn Partition & Pushdown Optimization. Explain Design Principles & Best Practices.

Topics:

• Performance Tuning Methodology
• Mapping design tips & tricks
• Caching & Memory Optimization
• Partition & Pushdown Optimization
• Design Principles & Best Practices

Module 9: PowerCenter Repository Management

Learning Objectives
In this module, you will understand: Recognize and explain the functionalities of the Repository Manager tool. Describe how to create and delete folders using the Repository Manager tool. Illustrate how to migrate components using the Repository Manager tool. Learn PowerCenter Repository Maintenance.

Topics:

• Repository Manager tool (functionalities, create and delete, migrate components)
• PowerCenter Repository Maintenance

Module 10: Informatica Administration & Security

Learning Objectives
In this module, you will understand: Explain the new features of PowerCenter 10. Explain an overview of the PowerCenter. Administration Console. Recognize and explain the integration and repository service properties. Identify how to handle services in the Administration Console. Explain how to handle locks through the Administration Console Illustrate how to create users and groups.

Topics:

• Features of PowerCenter 10
• Overview of the PowerCenter
• Administration Console
• Integration and repository service properties
• Services in the Administration Console (services, handle locks)
• Users and groups

Module 11: Command Line Utilities

Learning Objectives
In this module, you will understand: Apply infacmd to domain objects and security. Apply infasetup to domain objects. Apply pmcmd to execute and control workflows. Apply pmrep to manage the PowerCenter Repository. Explain Automate tasks via command-line programs: why you need these skills/why you need to know.

Topics:

• Infacmd, infasetup, pmcmd, pmrep
• Automate tasks via command-line programs

Module 12: Informatica 10 Technical Architecture

Learning Objectives
In this module, you will understand: Describe Informatica 10 Architecture. Explain the application services related to PowerCenter and their related processes. Understand buffer memory. Describe Connectivity among the tolls. Describe Connection pooling used in PowerCenter.

Topics:

• Informatica 10 Architecture
• Application services
• Buffer memory
• Connectivity among the tolls
• Connection pooling

Project Work

With more than 100 locations spread across the country, Gander Mountain operates the largest retail network of electronic products and accessory stores across the world. Headquartered in Texas, our client operates 1,00+ stores throughout the world. The retail chain acquired many brands as part of expansion in the US and Canada.

Multiple brand acquisitions in the long term led to information challenges (functional silos, data redundancy, multiple data marts, multiple reporting tools, no common "enterprise" data model, integration and delivery issues, data quality issues, and coordination issues with multiple teams).

Costs of maintaining multiple data marts and costs of training multiple teams were growing out of control. The systems and analysis tools were limited in volume, sophistication, and rate of change of data they could handle.

A significant amount of data was replicated across multiple data marts. Getting a single source of truth for data was becoming more and more challenging as the technical landscape was becoming more and more complex with the introduction of multivendor Database, ETL and Reporting platforms. Integrating ongoing acquired business' data into heterogeneous platforms was a challenging and uphill task.

A study was carried out with input from various stakeholders and the key outcome from this study was to consolidate all the data marts into one single Integrated Data Warehouse (IDW).

Results:

• Single version of truth
• Information Accuracy
• Analytics-Ready Data Warehouse Platform
• Reduced batch time
• Earlier availability of information
• Improvement in business continuity (ability to access critical reports in the event of production data warehouse failure)
• Significant cost savings (licensing cost elimination, Database Administration cost reduction, Reduced network resource usage, reduction in Data Warehouse and ETL operational costs
• Enable faster integration of new brands and realize related benefits sooner
• One small and efficient team supporting all brands and business units

Informatica PowerCenter 10.X has been chosen as the ETL tool for the implementation of the ETL processes in the project.

Birchwood University’s Tableau Training & Certification Course is curated by Business Intelligence Industry Experts, and it covers in-depth knowledge on Tableau Prep Builder, Tableau Desktop, and Tableau Online. Throughout this online instructor-led Tableau Training, you will be working on real-life industry use cases in Retail, Entertainment, Transportation and Life Sciences domains.

Module 1: Data Preparation using Tableau Prep

Learning Objective: Get a brief idea on Data Visualization and Tableau Prep Builder tool.

Topics:

• Data Visualization
• Business Intelligence tools
• Introduction to Tableau
• Tableau Architecture
• Tableau Server Architecture
• VizQL
• Introduction to Tableau Prep
• Tableau Prep Builder User Interface
• Data Preparation techniques using Tableau Prep Builder tool

Hands-On:

• Build a simple data flow using Tableau Prep Builder tool
• Group and Replace feature using Tableau Prep Builder tool
• Pivoting data using Tableau Prep Builder tool
• Aggregate data using Tableau Prep Builder tool
• Perform Unions and Joins using Tableau Prep Builder tool

Module 2: Data Connection with Tableau Desktop

Learning Objective: Get a brief idea on Tableau UI components and various ways to establish data connection.

Topics:

• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Joins and Unions
• Data Blending
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online

Hands-On:

• Joins using Tableau Desktop
• Data Blending feature within Tableau
• Create a Workbook and publish it over Tableau Online
• Save a workbook in different formats

Module 3: Basic Visual Analytics

Learning Objective: Understand the importance of Visual Analytics and explore the various charts, features and techniques used for Visualization.

• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets

Hands-On:

• Basic Charts in Tableau
• Demonstrate Hierarchies, Data Granularity and Highlighting features in Tableau
• Perform Sorting, Filtering and Grouping techniques in Tableau
• Sets in Tableau

Module 4: Calculations in Tableau

Learning Objective: Understand basic calculations such as Numeric, String Manipulation, Date Function, Logical and Aggregate. You will also get introduced to Table Calculations and Level of Detail (LOD) expressions.

Topics:

• Types of Calculations
• Built-in Functions (Number, String, Date, Logical and Aggregate)
• Operators and Syntax Conventions
• Table Calculations
• Level Of Detail (LOD) Calculations
• Using R within Tableau for Calculations

Hands-On:

• Demonstrate calculations using Built-in Functions in Tableau
• Perform Quick Table and Level Of Detail (LOD) calculations in Tableau
• Installing R and establishing connection with R within Tableau

Module 5: Advanced Visual Analytics

Learning Objective: Deep dive into Visual Analytics in a more granular manner. It covers various advanced techniques for analysing data that includes Forecasting, Trend Lines, Reference Lines, Clustering, and Parameterized concepts.

• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering

Hands-On:

• Demonstrate Parameters in Calculations
• Perform Data Visualization using Trend lines, Forecasting and Clustering feature in Tableau
• In-class Project 1- Domain: Media & Entertainment Industry

Module 6: Level of Detail (LOD) Expressions in Tableau

Learning Objective: Deep dive into advanced analytical scenarios, using Level of Detail expressions.

• Use Case I - Count Customer by Order
• Use Case II - Profit per Business Day
• Use Case III - Comparative Sales
• Use Case IV - Profit Vs Target
• Use Case V - Finding the second order date
• Use Case VI - Cohort Analysis

Hands-On:

• All the use cases are Hands-on intensive

Module 7: Geographic Visualizations in Tableau

Learning Objective: Gain an understanding of Geographic Visualizations in Tableau.

• Introduction to Geographic Visualizations
• Manually assigning Geographical Locations
• Types of Maps
• Spatial Files
• Custom Geocoding
• Polygon Maps
• Web Map Services
• Background Images

Hands-On:

• Create a Map and assign Geographic locations to the fields
• Demonstrate how to create a Map from a Spatial file
• Learn how to create a Filled Map, Symbol Map, and a Density Map
• Perform Custom Geocoding in Maps
• Build a Polygon Map
• Establish connection with the WMS Server

Module 8: Advanced Charts in Tableau

Learning Objective: Learn to plot various advanced charts in Tableau Desktop.

• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart
• Step and Jump Lines
• Word Cloud
• Donut Chart

Hands-On:

• All the above charts have Hands-on

Module 9: Dashboards and Stories

Learning Objective: Build Dashboards and Stories within Tableau.

• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points

Hands-On:

• Demonstrate how to add objects to a Dashboard
• Build a simple Dashboard (using Layouts and Formatting features)
• Create Interactive Dashboards using actions
• Learn to create Dashboard for devices using Device Designer
• Build Stories with Dashboards
• In-class Project 2- Domain: Retail Industry

Module 10: Get Industry Ready

Learning Objective: Learn effective ways of designing Dashboards with minimum time investment.

• Tableau Tips and Tricks
• Choosing the right type of Chart
• Format Style
• Data Visualization best practices
• Prepare for Tableau Interview

Hands-On:

• Hands-on experience on various tips and tricks with Tableau
• In-class Industry Grade Major Project-Domain: Transportation Industry

Module 11: Exploring Tableau Online

Learning Objective: Learn to publish data, interact, modify, and secure the published data on Tableau Online.

• Publishing Workbooks to Tableau Online
• Interacting with Content on Tableau Online
• Data Management through Tableau Catalog
• AI-Powered features in Tableau Online (Ask Data and Explain Data)
• Understand Scheduling
• Managing Permissions on Tableau Online
• Data Security with Filters in Tableau Online

Hands-On:

• Publishing Workbooks to Tableau Online
• Interacting with Content on Tableau Online
• Managing permissions on Tableau Online
• Data security using User-based and Row-level filters

In-class Project

Learning Objective: Learn to create Tableau reports for various industrial scenarios and publish them on Tableau Online. Learn to manage permissions and secure data using filters.

Project Statement:

You have been recruited as a freelancer for a Retail store that supplies Furniture, Office Supplies and Technology products to customers across Europe. You have been asked to create interactive dashboards which can be used to gain insights into the profits for orders over the years.