3518 Dash courses

This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

This course is very much a discussion, so be prepared to present and critically analyse your own and class mates work. You will also need to bring a few examples of work you have done in the past. Learning and applying best practice visualisation principles will improve effective discussions amongst decision makers throughout your organisation. As a result more end-users of your dashboards will be able to make better decisions, more quickly. This 2 Day training course is aimed at analysts with good working knowledge of BI tools (we use Tableau to present, but attendees can use their own software such as Power BI or Qlik Sense). It is a great preparation for taking advanced certifications, such as Tableau Certified Professional. Contact us to discuss the Visual Analytics Best Practice course Email us if you are interested in an on-site course, or would be interested in different dates and locations This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course includes the following topics: WHAT IS VISUAL ANALYSIS? Visual Analytics Visual Analytics Process Advantages of Visual Analysis Exercise: Interpreting Visualisations HOW DO WE PROCESS VISUAL INFORMATION? Memory and Processing Types Exercise: Identifying Types of Processing Cognitive Load Exercise: Analysing Cognitive Load Focus and Guide the Viewer Remove Visual Distractions Organise Information into Chunks Design for Proximity Exercise: Reducing Cognitive Load SENSORY MEMORY Pre-attentive Attributes Quantitatively-Perceived Attributes Categorically-Perceived Attributes Exercise: Analysing Pre-attentive Attributes Form & Attributes Exercise: Using Form Effectively Colour & Attributes Exercise: Using Colour Effectively Position & Attributes Exercise: Using Position Effectively ENSURING VISUAL INTEGRITY Informing without Misleading Gestalt Principles Visual Area Axis & Scale Colour Detail Exercise: Informing without Misleading CHOOSING THE RIGHT VISUALISATION Comparing and Ranking Categories Comparing Measures Comparing Parts to Whole Viewing Data Over Time Charts Types for Mapping Viewing Correlation Viewing Distributions Viewing Specific Values DASHBOARDS AND STORIES Exercise: Picking the Chart Type Exercise: Brainstorming Visual Best Practice Development Process for Dashboards and Stories Plan the Visualisation Create the Visualisation Test the Visualisation Exercise: Designing Dashboards and Stories This training course includes over 20 hands-on exercises to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives an extensive training manual which covers the theory, practical applications and use cases, exercises and solutions together with a USB with all the materials required for the training. The course starts at 09:30 on the first day and ends at 17:00. On the second day the course starts at 09:00 and ends at 17:00. Students must bring their own laptop with an active version of Tableau Desktop 10.5 (or later) pre-installed. What People Are Saying About This Course "Steve was willing to address questions arising from his content in a full and understandable way"Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs"James G. "The course tutor Steve was incredibly helpful and taught the information very well while making the two days very enjoyable."Bradd P. "The host and his courses will give you the tools and confidence that you need to be comfortable with Tableau."Jack S. "Steve was fantastic with his knowledge and knowhow about the product. Where possible he made sure you could put demonstrations in to working practice, to give the audience a clear understanding."Tim H. "This was a very interesting and helpful course, which will definitely help me produce smarter, cleaner visualisations that will deliver more data-driven insights within our business."Richard A. "Steve is very open to questions and will go out of his way to answer any query. Thank you"Wasif N. "Steve was willing to address questions arising from his content in a full and understandable way"Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs"James G.

Duration 2 Days 12 CPD hours This course is intended for Application Consultants, Business Analysts, and Process Owners Overview Learn to navigate the catalog, create and approve requisitions, and receive against POs. This course covers all of the functions of SAP Ariba Buying related to the creation of requisitions, the issuing of purchase orders, and receiving against purchase orders. Course Outline Introduction The Dashboard Catalogs Requisitions Accounting Approval Managing POs Receiving SAP Ariba Mobile Searching and Reporting Collaboration Demand Aggregation

Duration 1 Days 6 CPD hours In this hands on workshop for Agile Scrum Masters, Release Train Engineers and anyone serving as Jira Administrators, Jira experts will lead you through advanced configuration and customization settings in Jira, from installation through to customized screens, workflows, filters and reports. Jira Administration Adding and managing Users Administering and managing Groups Global Jira Settings Jira layout and interface customization User authentication and security Jira Customization Customization of screens and fields Customization of workflows Project and Board Administration Configuring and managing Projects Configuring and managing Boards Creating and managing Filters JQL Jira Integration Integrating Jira with Atlassian Tools Retrospectives and Documentation in Confluence Code management with Bitbucket Integration management with Bamboo Building a Dashboard with gadgets Jira Plug-ins and Marketplace

Duration 3.5 Days 21 CPD hours This course is intended for Intermediate Users of Office 365 and Excel Overview Creating Advanced Formulas Analyzing Data with Logical and Lookup Functions Organizing Worksheet Data with Tables Visualizing Data with Charts Analyzing Data with PivotTables, Slicers, and PivotCharts Inserting Graphics Enhancing Workbooks This course builds upon the foundational Microsoft Office Excel 2016, you create advanced workbooks and worksheets using advanced formulas and organizing your data into tables. Excel Intermediate Learn how to navigate Pivot Tables, (for example, Create a Pivot Table/ add data/ Add calculations); Formulas, Data organization (for example, multiple worksheets) Excel Advanced Data Analysis (for example, sparklines) , Macros (making changes to macros) and Building A Fast Dashboard (PivotCharts, slicers, etc.) Office 365 Training Getting More with OneDrive Office 365 Training When is a Team a Team? Includes Using Video with Audio, Exploring Teams/Navigating among Teams etc.

Duration 5 Days 30 CPD hours This course is intended for This is a comprehensive course for team members responsible for implementation, administration, operations, or maintenance of the Infoblox BloxOne Threat Defense solution Overview Course Topics The Infoblox Grid Setting up the Grid Grid Manager Managing Grid Members Infoblox High Availability DNS Services DNS Zones DNS Resource Records DNS Anycast DNSSEC DNS and Network Views Reporting - Dashboards Reporting - Searches, Reports and Alerts DNS Firewall Overview Local RPZ and RPZ Rules BloxOne Threat Defense RPZ Feeds DNS Firewall Monitoring and Reporting Infoblox TIDE Infoblox Dossier Dossier API Threat Insight Overview Configuring Threat Insight Threat Insight Monitoring and Reporting ADP Overview ADP Appliance Configuration ADP Rulesets, Rules and Profiles ADP Monitoring and Reporting ADP Tuning Establish working knowledge of how to configure and administer Infoblox appliances, Infoblox Grid and manage DNS protocol as a prerequisite to protecting and securing your DNS infrastructure and network from attacks with Infoblox BloxOne Threat Defense Establish working knowledge of how to configure and administer Infoblox appliances, Infoblox Grid and manage DNS protocol as a prerequisite to protecting and securing your DNS infrastructure and network from attacks with Infoblox BloxOne Threat Defense

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Technology Consultants, System AdministratorsTechnical Architects, and Support Consultants. Overview Understand and use the Monitoring and Alerting Infrastructure (MAI) for monitoring the system landscape with SAP Solution ManagerSetup and Configure the monitoring types System Monitoring, Self- Monitoring, End-user Experience, Integration Monitoring, Job & BI MonitoringUse the features of the Technical Monitoring Work CenterUse Technical Reporting options (EWA, SL Reporting, Interactive Reporting)Use the SAP Solution Manager Administration work center for Troubleshooting In this course, students learn to understand and use the Monitoring and Alerting Infrastructure (MAI) for monitoring the system landscape with SAP Solution Manager Setup and configure the monitoring types. Course Outline Get an overview about the Technical Monitoring in SAP Solution Manager 7.1 Get an overview about the Monitoring and Alerting Infrastructure (MAI) architecture Get a deep understanding about Monitoring Templates Using the Alert Inbox including Guided Procedures Configure Work Mode Management and Notification Management Configure and using System Monitoring Configure and using Interface Channel Monitoring and Connection Monitoring Configure and using End-user Experience Monitoring Configure and using BI-Monitoring and Job Monitoring Configure and using PI-Monitoring, Message Flow Monitoring and Workflow Monitoring Using Technical Reporting (EarlyWatch Alerts, Service Level Reporting, Interactive Reporting and Dashboards) Get an overview about SAP IT Infrastructure Management Get an overview about SAP Mobile Apps for the Monitoring and Alerting Infrastructure (MAI) Configure and using SAP Solution Manager Self-Monitoring and Self Diagnosis Using Monitoring and Alerting Infrastructure Analysis Tools

Duration 2 Days 12 CPD hours This course is intended for This course is intended for System and network engineers, technical architects and technical support personnel Overview Upon successful completion of this course, students will be able to install and operate a Cisco DNA Center (DNAC) This course will cover the basics of installing and operation of the Cisco DNA Center (DNAC). The Cisco DNAC is a stand-alone product that provides a single dashboard for every fundamental management task to simplify running an enterprise network. The DNAC is the management piece of the Software Defined Access (SDA) solution. Intent-based Networking overview DNA Center overview. DNA Center as a Platform. DNA Center Architecture & Design. DNA Center Installation DNA Center/Identity Services Engine (ISE) Integration ISE Integration configuration in DNA Center. DNA - Global - Add servers (e.g. ISE server(s)). DNA Center integration configuration in ISE. Approve pxGrid in ISE.Verify DNA/ISE integration DNA Center - Device Inventory Add networks devices to the DNA Center device inventory. Verify DNA Center Inventory configuration. DNA Center - Design - Network Hierarchy. Verify DNA Center - design configuration DNA Center - Design - Software Image Management (SWIM) Review SWIM image repository listing. Create golden software image & role. Verify golden software image creation DNA Center - Design ? Templates and Policies Templates ? Apache Velocity Engine. Command Runner. Policies: Group-Based, Application,Traffic Copy, IP-Based DNA Center - Provision Configuration Add devices to newly created sites/locations. Plug and Play (PnP). Verify DNA Center - provision configuration. DNA Center - Assurance Collection. DNA Center ? Administration

Duration 2 Days 12 CPD hours This course is intended for DevOps Engineers Software Developers Telecommunications Professionals Architects Quality Assurance & Site Reliability Professionals Overview Automate basic freestyle projects Jenkins Pipelines and Groovy Programming Software lifecycle management with Jenkins Popular plugins Scaling options Integrating Jenkins with Git and GitHub (as well as other Software Control Management platforms) Triggering Jenkins with Webhooks Deploying into Docker and Kubernetes CI / CD with Jenkins This course covers the fundamentals necessary to deploy and utilize the Jenkins automation server. Jenkins enables users to immediately begin automating both their individual and collaborative workflows. Jenkins is a proven solution for a wide variety of tasks ranging from the helpful automation of scripts (such as Python and Ansible) to creating complex pipelines that govern the technical parts of not only Continuous Integration, but Continuous Delivery (CI/CD) as well. Jenkins is free, open source, and easily controlled with a simple web- based UI- it can be expanded by third party plugins and is deployable on nearly any on-site (Linux, Windows and Mac) or cloud platform. Overview of Jenkins Overview of Continuous Integration and Continuous Deployment (CI/CD) Understanding Git and GitHub Git Branching Methods for Installing Jenkins Jenkins Dashboard Jenkins Jobs Getting Started with Freestyle Jobs Triggering builds HTTP Web Hooks Augmenting Jenkins with Plugins Overview of Docker and Dockerfile for Building and Launching Images Pipeline Jobs for Continuous Integration and Continuous Deployment Pipeline Build Stage Pipeline Testing Stage Post Build actions SMTP and Other Notifications Programming Pipelines with Groovy More Groovy Programming Essentials Extracting Jenkins Data Analytics to Support Project Management Troubleshooting Failures Auditing stdout and stderr with Jenkins Jenkins REST API Controlling Jenkins API with Python Jenkins Security Scaling Jenkins Jenkins CLI Building a Kubernetes Cluster and Deploying Jenkins How to start successfully using Jenkins to automate aspects of your job the moment this course ends.