AudienceTableau Fundamentals serves the beginner to intermediate Tableau user, targeted towards anyone who works with data – regardless of technical or analytical background. This course helps you implement important concepts and techniques in Tableau. Duration :five day virtual classroom instruction.Course Content:This course includes a workbook containing key concepts on each topic covered and hands-on activities to reinforce the skills and knowledge attained. Detailed Course Content:1. Introduction Tableau Desktop and the Tableau Product Line Application Terminology Visual Cues for Fields2. Connecting to Data Creating a Live Data Connection Saving a Data Source Sharing a Data Source Understanding Changes to Data Other Data Connection Options in Tableau3. Creating Basic Visualizations Getting Started in Tableau Desktop Elements of a Visualization Formatting Your View4. Simplifying and Sorting Your Data Data Filtering Sorting5. Organizing your Data Using Groups Creating and Using Hierarchies Creating a Combined Field Using Sets6. Slicing your Data by Date Working with Dates Using Discrete Date Parts Creating Date Filters Defining a Fiscal Year Creating Custom Dates7. Using Multiple Measures on the Same Axis8. Showing the Relationship between Numerical Values Options for Showing Numerical Relationships Creating Scatter Plots Creating Heat Maps9. Mapping Data Geographically10. Viewing Distributions11. Viewing Specific Values12. Customizing your Data13. Using Parameters for Dynamic Values14. Showing Breakdowns of the Whole15. Highlighting Data with Reference Lines Using Reference Lines and Reference Bands16. Showing Data History Creating Motion Charts17. Making Your Views Available Building Dashboards Dashboard Actions Using Drill Downs18. Sharing Your Work Export to an Image File Exporting the Data Only Other Sharing Options

AudienceTableau Advanced is for the professional who has solid working experience with Tableau and wants to take it to the next level. You should have a deep understanding of all the fundamental concepts of building worksheets and dashboards, but may scratch your head when working with more complex issues.Duration: five days of virtual classroom instruction.PrerequisitesTableau Fundamentals and/or equivalent.Course Includes:This course includes a workbook containing key concepts on each topic covered and hands-on activities to reinforce the skills and knowledge attained. Detailed Course Content:1. Introduction Review Fundamentals Concepts2. Working with Single Data Sources Desktop Data Architecture Using Data Extracts Custom SQL Data Connection3. Using Multiple Data Sources All About Joins Using Data Blending4. Using Calculations in Tableau Creating and Editing Calculated Fields Calculations Performed on the Database Calculations and Aggregations Aggregating Dimensions in Calculations Record Level Calculations for Date Conversion5. Advanced Table Calculations Table Calculation Scope and Direction Null Values in Table Calculations Table Calculations for Statistical Analysis6. Creating and Using Parameters Using Parameters and Reference Lines Using Parameters with Filters7. Comparing Measures Against a Goal Showing Total Progress Toward a Goal (Bar in Bar Graph) Showing Staged Progress Toward a Goal (Bullet Graph)8. Showing the Biggest and the Smallest Values9. Tableau Geocoding10. Advanced Mapping11. Showing Distributions of Data12. Statistics and Forecasting13. Overview of Additional Visualizations14. Dashboards: Quick Filters, Actions, and Parameters Comparing Quick Filters, Actions, and Parameters Highlight Actions15. Dashboard Best Practices16. Sharing Your Work Sharing Packaged Workbooks Export to an Image File Exporting the Data Only Other Sharing Options

Module 1: Introduction to Business Analysis What is a Business Analyst? Required areas of knowledge Business Analyst competencies General Analysis competencies Key conceptsModule 2: Planning the Analysis Approach General Business Analysis Scenarios Document Analysis Enterprise Architecture Sponsor and Stakeholder Analysis Roles and Responsibilities Pre-Elicitation Planning Developing the Business Needs Developing a Solution Scope Developing a Business Case Stakeholder Roles and ResponsibilitiesModule 3: Elicitation Elicitation Techniques Requirements Planning Risk Analysis and Management Enterprise Analysis/Business Case Elicitation Communications Enterprise Analysis Tasks Preliminary Solution Scope Transition Requirements Elicitation ResultsModule 4: Requirements Management and Communication Managing the Solution Scope Requirements Traceability Inputs to the Solution Scope Managing Requirements Changes Outside Vendor requirements Preparing the Requirements Package Communicating Requirements Approved Requirements Traceability Structured Walk-through TestingModule 5: Enterprise Analysis Business Needs Company Capabilities Analysis Solution Scope Risk Analysis SWOT Analysis Determining Solutions Approach Economic Feasibility Analysis Defining the Business CaseModule 6: Requirement Analysis What is Requirement Analysis? Prioritize Requirements Organize Requirements Define Assumptions and Constraints Verify Requirements Validate RequirementsModule 7: Solution Assessment and Validation Assess Proposed Solution Allocate Requirements Assess Organizational Readiness Define Transition Requirements Validate the Solution Evaluate Solution PerformanceModule 8: Overview of Business Analysis Techniques PESTLE MOST  SWOT  CATWOE Module 9: Sample Interview Questions

Web Intelligence 4.0 (3 days) Introducing Interactive Analysiso Describing Interactive Analysis Conceptso Explaining Interactive Analysis Core Functionalityo Describing Interactive Analysis and the SAP BO BI Platform Creating Interactive Analysis Documents with Querieso Querying with Interactive Analysiso Creating a New Documento Modifying a Document’s Queryo Working in the Query Panel Restricting Data Returned by a Queryo Restricting Data with Query Filterso Modifying a Query with a Predefined Query Filtero Applying a Single-value Query Filtero Using Wildcards in Query Filterso Using Prompts to Restrict Datao Using Complex Filters Designing Interactive Analysis Documentso Working with Interactive Analysis Documentso Displaying Data in Tableso Working with Tableso Presenting Data in Free-standing Cellso Presenting Data in Charts Enhancing the Presentation of Data in Documentso Using Breaks and Calculationso Using Sorts and Hiding Datao Formatting Breaks and Cross Tableso Filtering Report Datao Ranking Datao Tracking Data Changeso Highlighting Information with Formatting Ruleso Organizing a Report into Sectionso Copying and Pasting Data Blocks Formatting Interactive Analysis Documentso Formatting Documentso Formatting Charts Calculating Data with Formulas and Variableso Formulas and Variableso Using Formulas and Variables Using Multiple Data Sourceso Synchronizing Data from Multiple Data Sourceso Creating Multiple queries in a Documento Synchronized Data with Merged Dimensionso Using a Personal Data Provider Analyzing Datao Analyzing the Data Cubeo Drilling in an Interactive Analysis DocumentManaging and Sharing Interactive Analysis DocumentsWorking with advanced query techniques Creating formulas with character and date string functions Working with additional reporting techniques

 Creating a Dashboardo Producing Interactive Dashboardso Getting Around in Dashboardso Working with your Excel Work booko Visualizing Data with Chartso Using Dashboards Componentso Applying Best Practices for Designing Dashboardso Distributing Your Dashboard Formatting a Dashboardo Applying Formatting Optionso Using Themes and Templates to Apply Formatting Adding Interactivity to a Dashboardo Using Selectorso Adding Dynamic Visibilityo Troubleshooting Unintended Behaviour in Your Dashboard Creating a Connected Dashboardo Using Live Data Sourceso Connecting to XML datao Connecting to Data using an Existing Web Serviceo Connecting to Crystal Reports Datao Connecting to SAP BO Universes using Web Services Query (Query as a Web Service)o Connecting to SAP BO Universes using the semantic layer using the Query Browsero Using Live Office Data

 Understanding BusinessObjects Universeso Define BusinessObjects universe conceptso Use the universe development cycle Creating the Course Universeo Describe the course database and universeo Create the course universes Building the Universe Structureo Populate the universe structureo Define joins in a universe Creating Dimension Objectso Describe classes and objectso Create classes and objects Creating Measure Objectso Define measure object conceptso Create measure objectso Create delegated measure objects Resolving Loops in a Universeo Understand loopso Resolve loops using aliaseso Resolve loops using contexts Resolving SQL Trapso Understand SQL traps and universeso Resolve fan trapso Resolve chasm traps Applying Restrictions on Objectso Restrict the data returned by objects Using @functions with Objectso Use @functions Using Hierarchieso Understand hierarchies and universeso Work with hierarchies Using Lists of Valueso Create a list of valueso Work with LOVs in Universe Designero Create a cascading LOV Creating Derived Tables and Indexeso Use derived tableso Apply index awareness Linking Universeso Understand linked universes Create links between universeso Applying Universe Access Restrictionso Set access restrictions on a universe Managing Universeso Document universeso Deploy universeso Maintain universeso Deploy universes in multiple languages Reviewing Universe Design Conceptso Use your universe design and BusinessObjects Universe Designer knowledge to solve business problemso Describe the course universe, database data, and structure Working with Aggregate Awarenesso Define aggregate awarenesso Apply aggregate awareness to objects Designing Advanced Objectso Construct relative date-time objects Creating Complex Predefined Conditions, LOVs, and Joinso Create complex predefined conditions Securing Universes Implementing Universe Life Cycle Management

 Introduction to the Information Design Toolo What is the Information Design Tool?o Introduction to Resources and Workflows Creating the Data Foundationo What is a Connectiono Creating a Data Foundationo Defining Joins Creating a Business Layero Describing Folders and Objectso Creating Measure Objects Resolving Loops in a Universeo Understanding Loopso Resolving Loops using Contexts Applying Restrictionso Defining Data Restrictions Using List of Values and Parameterso Creating a List of Valueso Understanding Parameters Using @functions with Objectso Understanding @functions Using Navigation Pathso Navigation Path Aggregate Awarenesso Defining Aggregate Awareness Creating Derived Tables and Indexeso Using Derived Tableso Applying Index Awareness Managing Universeso Deploying and Managing and Maintaining Universes SQL Trapso Understanding SQL Traps and Universeso Detecting and Resolving Chasm Trapso Detecting and Resolving Fan Traps Advanced Use of the @ Aggregate_Aware Functiono Advanced Use of @Aggregate_Awareo Using @AggregateAware to resolve a 2-Table Fan Trapo Using @AggregateAware to resolve an Ambiguous Outer Join Creating Universes from different Data Sources o Creating Universes from Different Data Sourceso Creating an OLAP Universeo Creating a Multisource Universe Deploying a Universe in different languageso Using the Translation Management Tool Managing and Optimizing Universeso Managing a Universe with Data Foundation and Business Layer Viewso Working with a Shared Projecto Optimizing the Universe

 Planning a Reporto Defining Database Conceptso Planning and Developing a Report Prototype Creating as Reporto Creating a Reporto Adding Tableso Design Environmento Inserting Objects on a Reporto Previewing a Reporto Saving a Reporto Positioning and Sizing Objectso Formatting Objects Selecting Recordso Select Experto Determining the Criteria for Record Selectiono Saved versus Refreshed Datao Applying Record Selectiono Setting Additional Criteriao Modifying Record Selectiono Applying Time-Based Record Selection Organizing Data on a Reporto Sorting Recordso Grouping Recordso Creating Nested and Multiple Groupso Adding a Specified Order Groupo Grouping on Time-Based Datao Creating a Grand Totalo Summarizing Data Formatting a Reporto Adding Graphical Elementso Applying Specialized Formattingo Combining Text Objects with Database Fieldso Inserting Fields with Pre-Built Functions Applying Section Formattingo Formatting Sectionso Creating Summary Reports Creating Basic Formulaso Defining a Formulao Creating Formulaso Applying an If-Then-Else Formulao Applying Boolean Formulaso Applying Date Calculationso Applying Numeric Calculationso Applying String Manipulation Applying Conditional Formattingo Formatting Data Conditionallyo Adding Key Performance Indicators Representing Data Visuallyo Creating a Charto Charting on Details or Formula Informationo Customizing a Chart Distributing a Reporto Exporting a Reporto Saving to SAP BO BI Platform Building Reports from Repository Objectso Organizing Repository Objectso Building a Report Based on Repository Objects Creating Formulaso Adding Functions & Operators to a Formula Managing Reports Creating Variables and Arrays Building Report Templates Building Parameterized Reports Summarizing Data with Crosstabs Dividing a Report into Sections Building Specialized Reports Understanding Report Processing

1. What is SAP BusinessObjects Business Intelligence platform? Describing SAP BO BI Platform Working in BI Launch pad Working in the Central Management Control2. Managing content and objects in SAP BusinessObjects Business Intelligence platform  Adding Objects in the Repository Managing objects in SAP BO BI Platform 3. Securing users and groups in SAP BusinessObjects Business Intelligence platform  Managing Users and Groups Administering Rights in SAP BO BI Platform 4. Managing applications security  Securing your applications in SAP BO BI platform 5. Distributing content using scheduling and alerting  Scheduling objects Managing instances Managing Calendars Managing Events Working with Alerting6. Publishing and Publications  Publishing personalized reports

1. SAP BusinessObjects Business Intelligence Platform  BI and SAP BO BI Platform SAP BO BI platform Architecture2. Installation and Configuration  Installing SAP BO BI Platform – Server side Installation Installing SAP BO Bi platform – Client-side Installation3. Server Administration and Management  Using the Central Management Console (CMC) Using the Central Configuration Manager (CCM)4. Managing the Web Application Servers  Managing the Web Application Servers5. Managing the Central Management Server Databases  Managing the Central Management Server and system database Managing Auditing6. Managing the file Repository Servers Managing the file Repository Servers Using the Repository Diagnostic Tool7. Managing the Adaptive Servers  Understanding Adaptive Job Servers Understanding Adaptive Processing Servers8. Managing the Crystal Reports Servers  Managing the Crystal Reports Servers 9. Managing the Web Intelligence Servers  Managing the Web Intelligence Servers10. Managing the Dashboard Servers  Managing the Dashboard Servers11. Managing the Connection Server Configuring the Connection Server and Connection Server 3212. Managing the Explorer Servers The role of Explorer Servers13. Managing the Event Servers  Understanding the Event Servers14. Troubleshooting SAP BusinessObjects Business Intelligence Platform Troubleshooting SAP BusinessObjects Business Intelligence Platform

AudienceTableau Server Essentials is an overview course for IT professionals who need to quickly learn the basics of administering a standard, out-of-the-box installation of Tableau Server. The course is also appropriate for anyone considering a deployment of Tableau Server and would like to learn more about the product prior to making a final decision.Duration: four days of virtual classroom instruction.PrerequisitesNoneCourse IncludesThis course will include a workbook containing key concepts on each topic covered and hands-on activities to reinforce the skills and knowledge attained. After completing this course you will be able to: Perform a single server installation of Tableau Server Configure a single server installation Administer content, users, groups, and the Data Server Administer security and permissions Administer sites in Tableau Server Schedule tasks and create extracts Embed views Perform basic administration and configuration tasks using command line toolsDetailed Course Content:1. Installing and Configuring Tableau Server Single Server installation Single Server configuration2. Tableau Server Administration Content administration User and group administration Data Server administration Site administration3. Security and Permissions in Tableau Server License level User rights Roles Permissions precedence4. Working with Data Task scheduling and extracts Embedding URLs5. Command Line Tools(Basic Administration & Configuration) tabcmd tabadmin6. Additional Materials Tableau file type and extensions Component functions Sharing work Publishing to Tableau Server Publishing to Tableau Public Tableau Public Premium Tableau Packaged Workbooks Tableau Reader Save to Office and share image file Save to PDF Export data only

 Defining Data Services  Defining Data Services  Defining Source and Target Metadata Defining Datastores in Data Services Defining Data Services System Configurations Defining a Data Services Flat File Format Defining Datastore Excel File formats  Creating batch jobs for data integration o Creating Batch Jobs Troubleshooting batch jobs o Setting Traces and Adding Annotationso Using the Interactive Debuggero Setting up and Using the Auditing Feature Using functions, scripts and variables o Using Built-in Functionso Using Variables, Parameters and Scripts Using Platform Transforms o Using Platform Transformso Using the Map Operation Transformo Using the Validation Transformo Using the Merge Transformo Using the Case Transformo Using the SQL Transform Setting up error handling o Setting up error handling Capturing change in data o Capturing change in datao Using Source-Based Change Data Capture (CDC)o Using Target-Based Change Data Capture (CDC) Using Text Data Processingo Using the Entity Extraction Transform Using the data integrator platform transforms o Using Data Integrator Platform transformso Using the Data Transfer Transform and Performance Optimizationo Using the Pivot Transform

 Overview of Analysis, Office edition & OLAP editiono The Design Panelo Navigation Options Chartso Overview of Analysis chartso Adding a charto Adding data to a charto Defining an analysis using an empty chart componento Chart typeso Bar and column chartso Multi line chartso Multi pie chartso Other chartso To change the chart typeo Scrolling through chartso Customizing chartso Sub-analysis name and descriptiono Chart styleso Chart color paletteso Display fonto Displaying totals in chartso Displaying hierarchical chart labelso Hiding the chart legendo Chart axis labelso Y axis scale and symbolo Scatter chart and bubble chart measureso Configuring pie chart labels Filtering & Sortingo Filtering by measureo Filtering SAP BW data by measureo Filter typeso To filter by measureo To modify an existing filtero Removing a filtero Removing a sorto Filtering by membero To remove or add individual memberso Finding memberso To select a range of memberso Showing only selected memberso To change the display of member keys and texto Displaying parent nameso Hierarchy view and leaf members viewo Favorite filterso Removing displayed memberso Background filterso Removing null and zero values Sortingo Sorting valueso Sorting member nameso Removing a sorto Automatically removed sorts and filterso Removing a sort Filtering By Measure Working with Hierarchies Insert Components Using Formulas to add additional information Conditional Formatting & Promptingo Applying conditional formattingo Editing conditional formattingo Removing conditional formatting Change Variables in Prompts and Add Calculations Combination of multiple functions into one action Advanced scenarios for formula usage