This course is designed for users who want to create professional, comprehensive reports that give management an unparalleled insight into their business. It covers best practice examples on analysis, reporting, and planning techniques, so you can transform Excel spreadsheets into interactive business intelligence applications and drive action.
Learning Calumo Basics
The Calumo software suite.
What you can do with Calumo software.
Overview: How Calumo software works.
The Calumo portal.
The Calumo cube browser.
The Infinite Possibilities of the Member Explorer
Creating custom subsets.
Searching and selecting.
Creating Apps in Calumo.
Integrating Web Content and Published Reports into MS Word and PowerPoint with Calumo Skylights
Adding published reports to Word documents.
Adding web pages to Word documents.
Adding published reports to PowerPoint presentations.
Adding web pages to PowerPoint presentations.
Detailed Syllabus (cont.)
From Database to Dashboard: Enhancing Your Message with SPARKS
SPARK chart overview.
The SPARKS launch wizard.
Creating a Calumo SPARK.
SPARKS advanced settings.
Adding Functionality with Calumo-Excel Functions
Supported Excel functions for publishing.
Creating Reports and Publishing to Internet Explorer
Creating and publishing a report in Calumo.
Applying formatting features to reports.
Tips, Tricks and Best Practices for Developing Reports with Impact!
Create a Calumo report.
Create a dashboard.
Create an input template.
2 Days | Advanced
This course is designed for business users, IT professionals, consultants and system implementation specialists who have excellent working knowledge of Excel and Calumo. It covers how to develop sophisticated reports that solve common business problems, with practical examples and discussion on Calumo, Excel and MDX functionality.
An Introduction to MDX Reporting
What is MDX?
When to use MDX for reporting.
Advantages and disadvantages of using MDX.
Querying Data with MDX
Calumo browse and MDX.
Calumo in Excel and MDX.
CGET (Calumo CELL GET).
Members, tuples, and sets.
Tools for Writing MDX
SQL server management studio.
Commonly Used MDX Functions (Navigation)
Detailed Syllabus (cont.)
Commonly Used MDX Functions (Set)
Commonly Used MDX Functions (Date)
Pre-defined named numeric.
Format Member Properties for Reporting
Creating members and intrinsic properties.
Project: creating a dynamic report.
CALUMO TAILORED EDUCATION
4 Hours to 2 Days | From beginner to advanced, to ludicrously talented
Our consultants can design a training course suited to your needs, whether you need a few hours or a few days. We’ll take the time to understand your business needs and goals, as well as the specific areas where your team need support. Your training session will cover real-life challenges and solutions using your own data, so you can start implementing your learnings immediately.