1-800-QUEBIT1 BLOG

Specials & Featured Products

CATEGORIES
MY ACCOUNT

IBM Cognos Analytics for Excel for TM1 (CAFE) (Self-Paced)
$425.00
Led By (Online, Self-Paced) Computer-Based Training
IBM Cognos Analytics for Excel for TM1 (CAFE) (Self-Paced)
$425.00
| Led By (Online, Self-Paced) Computer-Based Training
Add to Cart
Course Details
List Price: $425.00

Quantity:

IBM Cognos Analysis for Microsoft Excel – For TM1 brings the benefits of modern enterprise performance management to Microsoft Excel Spreadsheets.  It provides a way for business and financial analysts, line-of-business managers, and users to access data from a variety of sources, including IBM Cognos TM1 and IBM Cognos Business Intelligence to perform analysis in a familiar Microsoft Excel spreadsheet environment

Overview:  Students will be able to create spreadsheet reports from multidimensional IBM Cognos TM1 models and IBM Cognos Business Intelligence.  Retain the power of Microsoft Excel functionality and formatting while integrating with data between IBM Cognos TM1 and share results with IBM Cognos Business Intelligence-sourced reports in Cognos dashboards and reports

Knowledge Level:  Introduction

Prerequisites:  Knowledge of the use of web browser to access the corporate intranet environment is assumed.  Familiarity with Microsoft Windows and basic navigation. 

Performance Goals: 

  • Explore and Analyze TM1 Cube Data
  • Retain Excel Functionality and Formatting
  • Modify data and commit data back to TM1
  • Share Results

 

IBM Planning Analytics for Excel-PAx (Self-Paced)
$425.00
Led By (Self-Paced) Computer-Based Training
IBM Planning Analytics for Excel-PAx (Self-Paced)
$425.00
| Led By (Self-Paced) Computer-Based Training
Add to Cart
Course Details
List Price: $425.00

Quantity:

IBM Planning Analytics for Microsoft Excel (PAx) is an eight hour, self-paced, online interactive training course.  IBM Planning Analytics for Excel brings the benefits of modern enterprise performance management to Microsoft Excel Spreadsheets.  It provides a way for business and financial analysts, line-of-business managers, and users to access data from a variety of sources, including IBM Planning Analytics and IBM Cognos Analytics to perform analysis in a familiar Microsoft Excel spreadsheet environment.

Overview:  Students will be able to create spreadsheet reports from multidimensional IBM Planning Analytics models and IBM Cognos Analytics.  Retain the power of Microsoft Excel functionality and formatting while integrating with data between IBM Planning Analytics and share results with IBM Cognos Analytics-sourced reports in Cognos dashboards and reports

Knowledge Level:  Introduction

Prerequisites:  Knowledge of the use of web browser to access the corporate intranet environment is assumed.  Familiarity with Microsoft Windows and basic navigation.

Perfomrance Goals:

Upon successful completion of this course, students will be able to:

  • Explore and Analyze Planning Analytics Cube Data

  • Retain Excel Functionality and Formatting

  • Modify data and commit data back to Planning Analytics

  • Share Results

NOTE:  You will have 30 days to complete this course from the time of enrollment.  You do not need to take the course all at once. 

 

*QueBIT  also offers “customized” self-paced, courses, which enhance your learning experience and that of your users, ensuring it reflects your business goals. Inquire today!

 

IBM Planning Analytics Workspace (Self-Paced)
$425.00
Led By (Online, Self-Paced) Computer-Based Training
IBM Planning Analytics Workspace (Self-Paced)
$425.00
| Led By (Online, Self-Paced) Computer-Based Training
Add to Cart
Course Details
List Price: $425.00

Quantity:

IBM Planning Analytics Workspace Coursee - Self-Paced (7 hours)

IBM Planning Analytics capabilities span personal, functional, and enterprise requirements for planning, analysis and reporting to help Finance drive timely decision-making.  Analysts and Managers can use Microsoft Excel and a web interface to analyze their business performance.

Overview:  Attendees will learn to provide self-service analytics to key performance indicators to users through an interactive, customizable workspace, analyze data exploration and natural language queries based on common business terms, create clear, compelling graphics and integrated scorecards to share with decision makers, retain familiar Microsoft Excel spreadsheets with enhanced functionality, and plan detailed, what-if scenario modelling with powerful hierarchy capabilities, enabling you to model attributes of hierarchies for more granular analysis.

Prerequisites:  A knowledge of your organization’s data and structure, as well as Microsoft Excel experience, is necessary. 

Performance goals

Upon successful completion of this course, students will be able to:

  • ​explore and analyze data with Planning Analytics Workspace
  • modify data and work in sandboxes
  • create visualizations
  • build a synchronized dashboard
  • access data and objects quickly
  • share content

Course will be accessible for 30 days.

*QueBIT  also offers “customized” self-paced, courses, which enhance your learning experience and that of your users, ensuring it reflects your business goals. Inquire today!

 

IBM Cognos Analytics Authoring Reports Fundamentals (Instructor-Led) Jun 2018
$1,260.00
June 11, 2018 - Through - June 12, 2018
Led By (Online, Instructor-Led) Erik Herman
IBM Cognos Analytics Authoring Reports Fundamentals (Instructor-Led) Jun 2018
$1,260.00
June 11, 2018 - Through - June 12, 2018 | Led By (Online, Instructor-Led) Erik Herman
Add to Cart
Course Details
List Price: $1,260.00

Quantity:

IBM Cognos Analytics is a Web-based tool that professional report authors use to build sophisticated, multiple-page, multiple query reports against multiple databases.  With Cognos Analytics, you can create any report that your company requires, such as sales, inventory, and statements and dashboard reports.

Overview:  Students will learn to use Cognos Analytics to create new reports.  Aggregation, summaries, grouping and sorting will be covered.  Students will create filters and prompts, add detail and summary calculations, format reports, create list and crosstab reports, and drill-through to other reports.

Date:  This class is scheduled for Monday, June 11th, 2018 through Tuesday, June 12th, 2018. The class times are from 9:00 AM to 5:00 PM, US EST. This is a 2-day class.

To join the training:  You will need an internet connection and a web browser.  You can use your computer's microphone and speakers.  A headset and two monitors are recommended

Prerequisites:  Knowledge of the use of a web browser to access the corporate intranet environment is assumed. Familiarity with Microsoft Windows and basic navigation is expected.

Knowledge Level:  Introduction

Performance Goals:  Upon successful completion of this course, attendees will be able to:

  • Start and log into Cognos Analytics
  • Understand the components of Cognos Analytics
  • Navigate the Cognos Analytics interface
  • Create and modify reports
  • Focus reports using prompts
  • Extend reports using calculations
  • Present data using maps
  • Design effective reports
  • Customize reports with conditional formatting

About your instructor, Erik Herman
 

 

IBM Planning Analytics Advanced Reporting (Instructor-Led) Jun 2018
$1,260.00
June 25, 2018 - Through - June 26, 2018
Led By (Online, Instructor-Led) Sandy Midili
IBM Planning Analytics Advanced Reporting (Instructor-Led) Jun 2018
$1,260.00
June 25, 2018 - Through - June 26, 2018 | Led By (Online, Instructor-Led) Sandy Midili
Add to Cart
Course Details
List Price: $1,260.00

Quantity:

IBM Planning Analytics is a technology based on On-Line Analytical Processing or OLAP.  With Planning Analytics, you can quickly view and understand large sets of Complex business data.  Analysts and Managers can use Planning Analytics for Microsoft Excel, and Planning Analytics Workspace to analyze their business performance.

Overview:  Attendees will learn to create static and dynamic subsets for spreadsheets and views in order to analyze data.  In order to create dynamic subsets, you will also learn how to record and create MDX statements.  You will review the benefits and purposes for an Exploration View, Dynamic and Custom Reports, and create more advanced Planning Analytics Excel reports for distribution for your organization.

Prerequisites:  TM1 Introduction, Exploration, Planning Analytics Workspace, or Planning Analytics for Excel (PAx) courses or equivalent skill set are required.  You should be familiar with Planning Analytics concepts of views, cubes, and browsing data prior attending the Planning Analytics Advanced Reporting class.  A knowledge of your organization’s data and structure, as well as Microsoft Excel experience, is necessary.

Knowledge Level:  Advanced

Date:  The class is scheduled for Monday, June 25, 2018- through - Tuesday, June 26, 2017. Class times are from 10:00 AM to 6:00 PM, US EST.  This is a 2 day class.

​To join the training:  You will need an internet connection and a web browser.  You can use your computer's microphone and speakers.  A headset and two monitors are recommended.   

Performance Goals:  Upon successful completion of this course, attendees will be able to:

  • create static and dynamic subsets
  • modify an Exploration View
  • export a view to a Dynamic Report
  • design complex reports for distribution
  • understand best practices and tips

About The Instructor:  Sandy Midili

 

IBM Cognos Analytics Authoring Reports Fundamentals (Instructor-Led) Jul 2018
$1,260.00
July 19, 2018 - Through - July 20, 2018
Led By (Online, Instructor-Led) Erik Herman
IBM Cognos Analytics Authoring Reports Fundamentals (Instructor-Led) Jul 2018
$1,260.00
July 19, 2018 - Through - July 20, 2018 | Led By (Online, Instructor-Led) Erik Herman
Add to Cart
Course Details
List Price: $1,260.00

Quantity:

IBM Cognos Analytics is a Web-based tool that professional report authors use to build sophisticated, multiple-page, multiple query reports against multiple databases.  With Cognos Analytics, you can create any report that your company requires, such as sales, inventory, and statements and dashboard reports.

Overview:  Students will learn to use Cognos Analytics to create new reports.  Aggregation, summaries, grouping and sorting will be covered.  Students will create filters and prompts, add detail and summary calculations, format reports, create list and crosstab reports, and drill-through to other reports.

Date:  This class is scheduled for Thursday, July 19, 2018 through Friday, July 20, 2018. The class times are from 9:00 AM to 5:00 PM, US EST. This is a 2-day class.

To join the training:  You will need an internet connection and a web browser.  You can use your computer's microphone and speakers.  A headset and two monitors are recommended

Prerequisites:  Knowledge of the use of a web browser to access the corporate intranet environment is assumed. Familiarity with Microsoft Windows and basic navigation is expected.

Knowledge Level:  Introduction

Performance Goals:  Upon successful completion of this course, attendees will be able to:

  • Start and log into Cognos Analytics
  • Understand the components of Cognos Analytics
  • Navigate the Cognos Analytics interface
  • Create and modify reports
  • Focus reports using prompts
  • Extend reports using calculations
  • Present data using maps
  • Design effective reports
  • Customize reports with conditional formatting

About your instructor, Erik Herman

 

IBM Planning Analytics Developer (Instructor-Led) July 2018
$1,860.00
July 25, 2018 - Through - July 27, 2018
Led By (Online, Instructor-Led) Sandy Midili
IBM Planning Analytics Developer (Instructor-Led) July 2018
$1,860.00
July 25, 2018 - Through - July 27, 2018 | Led By (Online, Instructor-Led) Sandy Midili
Add to Cart
Course Details
List Price: $1,860.00

Quantity:

IBM Planning Analtyics is a technology based on On-Line Analytical Processing or OLAP.  With Planning Analytics, you can quickly view and understand large sets of complex business data.  Analysts and managers can use a  Microsoft Excel add-in, Server Explorer, and a web interface to analyze their business performance.

Overview:  Attendees will learn to define dimensions, create cubes and apply security to your multidimensional data using Turbo Integrator.  You will also be able to create basic rules to data in the cubes.

Knowledge Level:  Intermediate

Dates:  The IBM Planning Analytics Developer is a public, online, and instructor-led course that is 3 days in length.  The class is scheduled for Monday, July 24, 2017- through - Wednesday, July 26, 2017. Class times are from 9am to 5pm US Eastern time.

To join the training:  You will need an internet connection and a web browser.  You can use your computer's microphone and speakers.  A headset is recommended.  Two monitors are also recommended.

Prerequisites:  IBM Cognos TM1 Exploration course or equivalent knowledge, such as being familiar with Planning Analytics concepts of views, cubes, and browsing data prior attending the Planning Developer course.  A working knowledge of Microsoft Excel and your organizational structure and data is recommended. You will need the software installed.

Performance Goals:  Upon successful completion of this course, attendees will be able to:

 

  • understand OLAP and TM1 Servers
  • create dimensions
  • build and populate cubes
  • add business rules
  • create currency translations
  • implement Security
  • understand best practices
     

About The Instructor:  Sandy Midili

 

IBM Cognos Analytics Authoring Reports Advanced (Instructor-Led) Aug 2018
$660.00
August 6, 2018
Led By (Online, Instructor-Led) Erik Herman
IBM Cognos Analytics Authoring Reports Advanced (Instructor-Led) Aug 2018
$660.00
August 6, 2018 | Led By (Online, Instructor-Led) Erik Herman
Add to Cart
Course Details
List Price: $660.00

Quantity:

IBM Cognos Analytics reporting provides a deep well of advanced features and functionality for the modern report and business analytics developer.

Overview:  This Advanced course picks-up where the Cognos Analytics Report Authoring Fundamentals course leaves off. Students will understand and explore advanced report development concepts and techniques, including drill-through, manually building queries, creating query relationships (e.g. joins, unions etc.), report bursting, and advanced layouts and prompting.

Date:  This class is scheduled for Monday, August 6, 2018. The class time is from 9:00 AM to 5:00 PM, US EST. This is a 1-day class.

To join the training:  You will need an internet connection and a web browser.  You can use your computer's microphone and speakers.  A headset and two monitors are recommended

Prerequisites:

  • IBM Cognos Analytics Authoring Reports Fundamentals course.
  • Knowledge of the use of a web browser to access the corporate intranet environment is assumed.
  • Familiarity with Microsoft Windows and basic navigation is expected.

Knowledge Level:  Advanced

Performance Goals:  Upon successful completion of this course, attendees will be able to:

  • Understand drill-through
  • Create query modules
  • Create reports based on query relationships
  • Distribute reports with bursting
  • Create advanced dynamic reports
  • Design effective prompts

About your instructor, Erik Herman

 

IBM Planning Analytics Advanced Developer (Instructor-Led) Aug 2018
$1,260.00
August 8, 2018 - Through - August 9, 2018
Led By (Online, Instructor-Led) Sandy Midili
IBM Planning Analytics Advanced Developer (Instructor-Led) Aug 2018
$1,260.00
August 8, 2018 - Through - August 9, 2018 | Led By (Online, Instructor-Led) Sandy Midili
Add to Cart
Course Details
List Price: $1,260.00

Quantity:

IBM Planning Analytics combines a powerful, multidimensional database engine, Microsoft Excel add-in, Server Explorer front end, Web Interface, Turbo Integrator, and Extract Transform and Load (ETL) tools.  The combination of these utilities will allow developers and end users to access multidimensional data with speed and efficiency, regardless of the source.

Overview:  Attendees will learn to define dimensions, create cubes and apply security to your multidimensional data using Turbo Integrator.  Students will learn techniques and best practices to develop, test, and run effective Turbo Integrator processes.  You will also be able to create, test, and problem solve advanced rules to data in the cubes.

Dates:  The IBM Planning Analytics Advanced Developer is a public, online, and instructor-led course that is 2 days in length.  The class is scheduled for Wednesday, August 8, 2018- through - Thursday, August 9, 2018. Class times are from 9am to 5pm US Central time.


To join the training:  You will need an internet connection and a web browser.  You can use your computer's microphone and speakers.  A headset is recommended.  Two monitors are also recommended.

Prerequisites:  TM/Planning Analytics Introduction, TM1 Exploration, Planning Analytics for Excel, and TM1/Planning Analytics Developer courses or equivalent skill set. are required  You should be familiar with TM1/Planning Analytics concepts of views, cubes, and browsing data, TurboIntegrator processes, basic rule writing techniques prior attending the Planning Analytics Advanced Developer course.  A working knowledge of Microsoft Excel and your organizational structure and data is recommended.

Knowledge Level:  Advanced

Performance Goals:  Upon successful completion of this course, attendees will be able to:

  • Review SQL basic concepts and skills needed to develop TurboIntegrator scripts
  • Build dimensions and load data using TurboIntegrator
  • Add complex business rules
  • Utilize advanced business rule techniques


About The Instructor:  Sandy Midili

 

IBM Cognos Analytics Authoring Reports with Multidimensional Data (Instructor-Led) Aug 2018
$1,260.00
August 23, 2018 - Through - August 24, 2018
Led By (Online, Instructor-Led) Erik Herman
IBM Cognos Analytics Authoring Reports with Multidimensional Data (Instructor-Led) Aug 2018
$1,260.00
August 23, 2018 - Through - August 24, 2018 | Led By (Online, Instructor-Led) Erik Herman
Add to Cart
Course Details
List Price: $1,260.00

Quantity:

IBM Cognos Analytics report authoring provides users with a comprehensive product tool set appropriate for any business analytic development requirement. One of Cognos Analytics' core strengths is its ability to run against a myriad of data sources, including dimensional or OLAP data.

Overview: In this advanced, 2-day course, students will build upon their experience using Cognos Analytics and apply dimensional reporting development techniques, including working with members, sets, tuples, and functions.

Date:  This class is scheduled for Thursday, August 23, 2018 through Friday, August 24, 2018. The class times are from 9:00 AM to 5:00 PM, US EST. This is a 2-day class.

To join the training:  You will need an internet connection and a web browser.  You can use your computer's microphone and speakers.  A headset and two monitors are recommended

Prerequisites: Experience using Cognos Analytics reporting and/or completion of the IBM Cognos Analytics Authoring Reports Fundamentals course.

Knowledge Level: Advanced

Performance Goals: Upon successful completion of this course, attendees will be able to:

  • Discuss dimensional reporting
  • Understand dimensional data and report context
  • Explore dimensional data filtering
  • Use dimensional functions and calculations
  • Navigate dimensional hierarchies with functions
  • Review relative and relative time functions
  • Examine advanced drilling techniques and member sets
  • Discuss drill-through reports

About your instructor, Erik Herman