TARGIT University

Reach out, and we’ll contact you with more information about your desired course.

Beginner

TARGIT Fundamentals

TARGIT Fundamentals is a course for you with little to none experience with TARGIT Decision Suite. It's designed to teach you how to work with TARGIT Decision Suite as an analytics tool, and how to design analyses and dashboards, for consumption by yourself and your colleagues.

Requirements

The course requires a basic knowledge of operating standard Windows applications.

You'll learn

basic analyzing techniques
how to design dashboards with crosstabs and graphs
how to format objects for the best visualization
how to work with dynamic criteria and user dimensions
how to add simple calculations and color agents
how to export data.

Duration

1 day

Get Info

Intermediate

TARGIT Data Discoverer

TARGIT Discoverer is an ad-hoc exploration of data outside the traditional data warehouse. With the course TARGIT Data Discoverer, you'll experience that an unlimited number of data sets are available from external data sources, and the possibilities are endless for combining internal and external data.

Requirements

The course requires basic skills for creating TARGIT analyses. Basic knowledge about data relations is an advantage as well.

You'll learn

how to upload single files for immediate analysis
how to mash up data from multiple data sources
how to pull data from online data providers
how to un-pivot, cleanse, and modify data sources to match requirements.

Duration

1 day

Get Info

Intermediate

TARGIT Report Designer

Become a TARGIT Report Designer and design multi-page reports and experience the power of well-crafted report design, sharing valuable information and insights across the organization.

Requirements

The course requires a fundamental knowledge of TARGIT Decision Suite through either daily use of TARGIT Decision Suite or by completing our TARGIT Fundamentals course.

You'll learn

about report templates
about flowing data into the next pages
about various report design examples and exercises
how to iterate your report through dimension members
how to use dynamic content in your reports
how to create multi-page and multi-design reports.

Duration

1 day

Get Info

Intermediate

Data Warehouse Developer – Basic

The course will give you the fundamental knowledge that you need to implement a multi-dimensional data warehouse. After completing the course, you’ll be able to implement minor adjustments and additions to your data warehouse.

Requirements

The course does not require previous training. During the course, you’ll primarily be working on building and designing a multi-dimensional data warehouse in a Microsoft SQL Server environment. No matter your level of knowledge and expertise, TARGIT's experienced instructors will guide you through the course.

You'll learn

about basic data warehouse terms and definitions
how to plan, supervise, and monitor the implementation of a data warehouse from beginning to end
how to construct multi-dimensional data models with Microsoft SQL Server Analysis Services (SSAS)
how to utilize Named Calculations and Calculated Members
how to migrate data with Microsoft SQL Server Integration Services (SSIS)
how to ensure data quality and integrity · how to build an advanced time dimension
how to expand data models with new data using data manipulation.

Duration

2 days

Get Info

Intermediate

TARGIT Visualization Wizard

Be an expert on data visualization best practices. Use storytelling to guide end-users through your data and learn how to make TARGIT Decision Suite accessible via structured navigations, increasing the ultimate user adoption.

Requirements

The course requires a completed TARGIT Fundamentals course, and you should have a clear knowledge of TARGIT Decision Suite.

You'll learn

how to increase consistency in templates
how to create textboxes and KPI objects
how to create menus for easy navigation
how to build a portal
how to disclose hidden information with advanced labels
how to publish data as slideshows.

Duration

1 day

Get Info

Advanced

TARGIT Calculations Expert

Release the full potential of TARGIT Decision Suite. Become your company's number cruncher by offering everyone in the organization clear insight into complex data. Learn the syntax to make dynamic ad-hoc calculations. The calculation syntax can also be put to work with your intelligent agents, your user dimensions, and other active functions within the TARGIT Decision Suite.

Requirements

The course requires you to be thoroughly versed in TARGIT Decision Suite, minimally equivalent to the TARGIT Fundamentals course. You’ll get the most out of the course if you have worked with your data for some time.

You'll learn

the basic syntax for referring columns, rows, and measures
to apply modifiers according to data visibility, hierarchies, etc.
about if-then-else-constructs
about endless opportunities for boosting your data with calculations.

Duration

1 day

Get Info

Advanced

Data Warehouse Developer – Advanced

The course will give you advanced knowledge of the implementation of data warehouses for the use of business intelligence. After completing the course, you'll be able to implement a variety of data warehouses - multi-dimensional, relational, or tabular data warehouses - from scratch.

Requirements

The course requires knowledge of multi-dimensional data warehouses equivalent to the level represented in the TARGIT Data Warehouse Developer Basic course. During the course, you'll be working on further developing a multi-dimensional data warehouse while including optimization and best practices. Additionally, you'll learn to design alternative data warehouses: relational and tabular mode.

You'll learn

how to implement a business intelligence data warehouse from scratch
how to identify the advantages and disadvantages of different design solutions
how to utilize advanced optimization techniques and best practices to benefit the most from a data warehouse

And further to this gain knowledge within

Microsoft SQL Server 2012 Tabular Model Data Warehouse
TARGIT Relational Model Data Warehouse
Normalization vs. Denormalization
Display folders
Dimension member translations
Drill through action
Aggregations (Wizard design, usage-based design, and advanced design)
Partitions
Dynamic Time dimension - Basic to advanced via Lookup table
Fiscal Time dimension; Period Table Task offset
Attribute relationships; natural hierarchies
Incremental update.

Duration

2 days

Get Info

Advanced

Back-end Administrator

Implement and manage the daily administration of your TARGIT solutions. You'll be able to install different TARGIT components, troubleshoot errors, and manage end-users and web integration.

Requirements

The course requires you to be familiar with the basic concepts of TARGIT and analytics Data Warehouses along with a good level of IT technical knowledge.

You'll learn

how to recognize the TARGIT components and understand their role in TARGIT
how to manage the daily administrative tasks
how to find and fix possible errors without or with minimal external assistance
how to ensure stable performance of the TARGIT solution
how to integrate TARGIT via Sharepoint web part.

Duration

1 day

Get Info

Advanced

Certified Specialist Exam

You are already TARGIT Super User or a TARGIT Consultant, and you need the certification proving your excellent skills with the TARGIT Decision Suite. Become a TARGIT Certified Specialist by earning the seal of approval for your extensive knowledge of TARGIT.

TARGIT Certified Specialist is offered online and at select locations throughout the world.

Requirements

To become certified, you must prove your Designer skills in the TARGIT front-end. You can achieve this by having completed the courses mentioned below. To pass the exam, you’ll need to be thoroughly versed in all aspects as a Designer of the TARGIT front-end. You’ll be required to design a number of dashboards, analyses, and reports within a set time frame of 2½ hours. To pass the exam, you must have completed a minimum of 70 percent of the total assignment correctly.

Exam subjects

The exam exercise will cover content from the TARGIT end-user courses:

TARGIT Fundamentals
TARGIT Report Designer
TARGIT Visualization Wizard
TARGIT Calculations Expert

Duration

2½ hours

Get Info

Advanced

Certified Professional Exam

You're already a developer of SQL Server data warehouses and/or a professional TARGIT Consultant. Still, you need proof of your skills in handling the technical back-end of a TARGIT solution.

TARGIT Certified Professional is offered online and at select locations throughout the world.

Requirements

To become certified, you must have completed the courses mentioned below. To pass the exam, you’ll need to be thoroughly versed in the areas within each course. Within a set time frame of 5 hours, you’ll be required to solve various practical tasks that consist of designing one or more data warehouses. You’ll also be tested on the most important administrative functions in the TARGIT Management Studio. To pass the exam, you must have solved a minimum of 70 percent of the total assignment correctly.

Exam subjects

The exam exercise will cover content from technical courses:

TARGIT Data Warehouse Developer Basic
TARGIT Data Warehouse Developer Advanced
TARGIT Backend Administrator

Duration

5 hours

Get Info