Click on the links below to view course outlines, pre-requisites, course length and course objectives.
Click on the links below to view course outlines, pre-requisites, course length and course objectives.
Course Number:
This course provides a practical, all-encompassing overview of the use, architecture, scaling, configuration and development of ElasticSearch and Kibana as a distributed search and reporting solution.
Audience:
Click on the links below to view course outlines, pre-requisites, course length and course objectives.
Course Number:
This hands-on instructor-led course will give students the skills to create comprehensive SAP BI 4.x Universes. Students will learn how to create, document, test, maintain, and distribute Universes which will meet the reporting needs of their organization.
Audience:
Prerequisites:
No prior IDT experience is required. Familiarity with database design and SQL is very helpful.
After completing the course, student will be able to:
Course Number:
In this course, students will learn to connect to a database, extract data and present it as a report. Content is designed for people who need output from a database when the database programs have limited reporting tools or such tools may not be accessible.
Prerequisites:
Before taking this course, students should be familiar with the basic functions such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft Windows. In addition, students should been familiar Microsoft Office Access 2010 and basic database concepts.
Upon successful completion of this course, students will be able to:
Course Number:
This hands-on instructor-led course will give students the skills to visualize data using SAP BusinessObjects Dashboards 4.x. Students will learn how to use the SAP BusinessObjects Dashboards suite of tools, determine which components best represent different types of information, and set up the relationships between these components. Students will have the opportunity to practice creating different types of models and dashboards through a series of hands-on exercises.
Audience:
Prerequisites:
No prior SAP BusinessObjects Dashboards experience is required. Familiarity with Microsoft Excel is required.
After completing the course, student will be able to:
Course Number:
This three-day course is designed to equip the student with the comprehensive skills necessary to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes. In this course students will learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools.
Audience:
Prerequisites:
Course Number:
This course is designed for people who know how to create basic list and group reports but need to create reports that include subreports, cross-tabs, advanced formulas and charts based on more than one data series.
After participating, they will be able to create complex reports using Crystal Reports’ tools.
Audience:
Prerequisites:
Students should participate in Crystal Reports 2011: Level 1 before taking this course. Knowledge of programming and/or SQL is also helpful.
Upon successful completion of this course, students will be able to:
Course Number:
This hands-on instructor-led course will give students the skills to create comprehensive BusinessObjects Universes. Students will learn how to create, document, test, maintain, and distribute Universes which will meet the reporting needs of their organization.
Audience:
Prerequisites:
No prior Designer experience is required. Familiarity with database design and SQL is very helpful.
After completing the course, student will be able to:
Course Number:
This hands-on instructor-led course will give students the skills to administer their BusinessObjects BOE XI 3.x and BI 4.x. system. Students will begin with administration basics and work their way to advanced concepts. They will learn how to size, install, and configure a system that will best meet their needs. Students will master the daily tasks that are necessary to keep an SAP BusinessObjects BI system up and running.
Audience:
Prerequisites:
No prior SAP BI system administration experience is required. Familiarity with network security and administration concepts is helpful.
After completing the course, student will understand:
Course Number:
This course is delivered both in the classroom and virtually (remote classroom). Participants will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. After completing this course, participants will be able to create combined queries and use sub-queries. They will also be able to use character and date string functions, create variables using “If” logic, and redefine calculation contexts. They will learn how to link Web Intelligence documents using the hyperlink functionality and also create their documents using various SAP data sources.
Audience:
Prerequisites:
Students should attend our SAP BusinessObjects Web Intelligence course. We also recommend they have experience designing Web Intelligence reports.
Course Number:
This hands-on instructor-led course will give students the skills to visualize data using Crystal Xcelsius. Students will learn how to use the Crystal Xcelsius suite of tools, determine which components best represent different types of information, and set up the relationships between these components. Students will have the opportunity to practice creating different types of models and dashboards through a series of hands-on exercises.
Audience:
Prerequisites:
No prior Crystal experience is required. Familiarity with Microsoft Excel is required.
After completing the course, student will be able to:
Course Number:
This hands-on instructor-led course will give students the skills to secure their BusinessObjects BOE XI 3.x and BI 4.x. system. Students will begin with security basics and work their way to advanced concepts. They will explore functional and data security, define a rights model, and secure data sources and universes. Step-by-step instructions ensure that you can implement important security techniques in your administration and design work.
Audience:
Prerequisites:
No prior SAP BI system administration experience is required. Familiarity with network security concepts is helpful.
After completing the course, student will understand:
Course Number:
This hands-on instructor-led course will give students the skills to create comprehensive SAP BusinessObjects Web Intelligence 4.x reports. Students will learn how to analyze information, distribute information, and use the major reporting features of Web Intelligence.
Audience:
Prerequisites:
No prior reporting experience is required. Familiarity with Microsoft Office is helpful.
After completing the course, student will be able to:
Course Number:
This hands-on instructor-led course will give students the skills to visualize data using SAP BusinessObjects Dashboards 4.x. Students will learn how to use the SAP BusinessObjects Dashboards suite of tools, determine which components best represent different types of information, and set up the relationships between these components. Students will have the opportunity to practice creating different types of models and dashboards through a series of hands-on exercises.
Audience:
Prerequisites:
No prior SAP BusinessObjects Dashboards experience is required. Familiarity with Microsoft Excel is required.
After completing the course, student will be able to:
Course Number:
This hands-on instructor-led course will give students the skills to create comprehensive BusinessObjects Web Intelligence reports. Students will learn how to analyze information, distribute information, and use the major reporting features of Web Intelligence.
Audience:
Prerequisites:
No prior reporting experience is required. Familiarity with Microsoft Office is helpful.
After completing the course, student will be able to:
Click on the links below to view course outlines, pre-requisites, course length and course objectives.
Course Number:
Splunk is innovative technology and a comprehensive business intelligence tool used to query and visualize enterprise data. Users can search machine data across an enterprise where the data is located in various repositories, in different formats, and available via various sources. Splunk makes searching, examination, collating, and reporting on disparate data flexible and possible. Students will leave class with the ability to leverage Splunk in their workplace and interpret machine data in their domain.
Splunk provides a single syntax and user interface for accessing a variety of data. In class, students will learn the essentials of this syntax to create simple and complex search results and reports. User will also learn how to navigate the Splunk user experience.
Every module starts with an upfront exercise and then a series of walkthroughs designed to reinforce important concepts and skills. At the end of the course, you are prepared to create real world solutions using Splunk from the knowledge gained from this training.
Course Number:
Splunk is an innovative, comprehensive business intelligence tool used to query and visualize enterprise data. Users can search machine data across an enterprise where the data is located in various repositories, different formats and is available via various sources. Splunk makes searching, examination, collating and reporting on disparate data flexible and possible. Students will leave class with the ability to leverage Splunk in their workplace and interpret machine data in their domain.
Splunk provides a single syntax and user interface for accessing a variety of data. In this class, students will learn the essentials of syntax, create search results of varying complexity and generate reports. Several typical and advanced commands are introduced, and upon completion of the course, participants will know how to confidently navigate the Splunk user interface.
Installing, configuring and administering Splunk can be challenging, so this course provides the necessary tools to deftly setup and manage Splunk for clients. The students will receive a “cheat sheet” during class. This sheet is a comprehensive and an invaluable guide, especially for someone new to Splunk.
Every class module starts with an upfront exercise followed by a series of walkthroughs designed to reinforce important concepts and skills. At the end of the course, students are prepared to create real-world solutions using Splunk from the knowledge gained from this training.
Click on the links below to view course outlines, pre-requisites, course length and course objectives.
Course Number:
This is for students who are new to Tableau or who have limited experience with the software. Students will learn the fundamentals of the tool and how to use all the basic functionality to visualize their data. Students will learn how to connect to various data sources, build a variety of basic charts, and combine those insights into a useable dashboard. Students will also about sharing and publishing options.
Prerequisites:
None
Tableau Fundamentals (Day 1)
Visual Best Practices and Visual Analytics (Day 2)
This class is designed for someone who has moderate experience with Tableau and is ready to take basic skills to an advanced level. This class will put more tools in your analytical tool box, such as more complex calculations, more powerful interactivity, more complex chart types, and more ways to slice and dice your data to mine for critical insights.
Prerequisites:
Successful completion of the Tableau Analyst course, or other introduction to Tableau course, or moderate exposure and use in the tool. Students in this class should already understand the basics of connecting to data and building charts and dashboards.
Calculations and Interactivity (Day 1)
Advanced Analytics and Storytelling (Day 2)
Bonus Material (if there is time or if specifically requested)
End of Day 4 could be workshop time to answer questions, help them create some dashboards off their data, etc.
Course Number:
This intensive 3-4 day bootcamp is designed to turbocharge your Tableau skills and take your analytical ability and the insights you provide to the next level. This assumes you’re already very familiar with the Tableau interface and want to go beyond bar charts and learn a variety of advanced charts, when to use them and how they help you be a better data analyst. This course will also teach you how to turn your formatting into magazine-quality infographics, as well as quantify impacts.
Prerequisites:
3-6 months of regular Tableau usage; familiarity with calculations and a desire to move fast
How to understand what keeps the CEO up at night
How to ask the right questions
Where to find answers to these questions
What makes a visualization effective
The Ninja Analyst Framework
Advanced Time Series Analytics
Distributions
Correlation Analytics and Relationships Between Data
Outlier Analysis
Advanced Geographic Analysis
Other Advanced Charts
Advanced Dashboards
Using these skills to advance your career and get promoted
Course Number:
This two-day hands-on course will teach you how to use Tableau Prep, Tableau’s data preparation, data cleansing, and ETL tool. In this course, you will learn how to get your data in the right format for optimal efficiency while in Tableau itself.
Prerequisites:
Prior experience using Tableau, joining data in Tableau, and working with calculations
Introduction to the workspace
Data cleansing and preparation concepts, such as joins, unions, wildcard matches, fuzzy matching, and addressing nulls, irregularities and outliers
When to do your data preparation in Tableau Prep vs. the normal Tableau Desktop
Understand data sampling
Connecting to and configuring data
Exploring data
How to create workflows
Preferred data structures in Tableau
Cleaning data
Shaping data
Combining data
Joining and unioning data
Opening a data sample and creating an output file
Best practices for data preparation
Complex flows
Exporting to various Tableau formats
Validating results
At the end of the course, students will be able to overcome many of their thorniest data cleaning and preparation issues, enabling their Tableau analysis and visualization process to be smoother and easier. In some cases, it can replace or ease data prep challenges being solved in other ways currently, such as using SAS for ETL processes or waiting long periods of time for IT to get the data just so, or doing a lot of manual rework in Excel.