Calumo Software Training
Instructor Led Training
Led by a Calumo instructor, each training session provides the knowledge and skills your team needs to make the most of Calumo. Instructor led training is perfect for both new hires looking to be brought up to speed, and seasoned professionals looking to expand their knowledge of Calumo product functionality through a low-cost, highly convenient design. Courses range from beginners to advanced and can be tailored to meet the needs of your organization.
CALUMO ESSENTIALS
1 Day | Beginner to Intermediate
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.
Detailed Syllabus
- 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
- Reordering members.
- Creating subsets.
- Creating custom subsets.
- Searching and selecting.
- Calumo Apps™
- Creating Apps in Calumo.
- App properties.
- 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.
- MDX overview.
- Creating Reports and Publishing to Internet Explorer
- Creating and publishing a report in Calumo.
- Customising reports.
- 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.
- Write-Back
CALUMO ADVANCED
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.
Detailed Syllabus
- An Introduction to MDX Reporting
- What is MDX?
- When to use MDX for reporting.
- Advantages and disadvantages of using MDX.
- MDX Terminology
- Dimensions
- Hierarchies
- Members
- Cubes
- Querying Data with MDX
- Select statement.
- Calumo browse and MDX.
- Calumo in Excel and MDX.
- CGET (Calumo CELL GET).
- Formatting MDX.
- Members, tuples, and sets.
- Tools for Writing MDX
- SQL server management studio.
- MDX studio.
- Commonly Used MDX Functions (Navigation)
- Children
- Parent
- Descendants
Detailed Syllabus (cont.)
- Commonly Used MDX Functions (Set)
- Order
- Topcount
- Bottomcount
- NONEMPTY
- DrilldownLevel
- Crossjoin
- Commonly Used MDX Functions (Date)
- ParallelPeriod
- LastPeriods
- Except Functions
- Calculated Members
- Pre-defined named numeric.
- Format Member Properties for Reporting
- Intrinsic properties.
- Creating members and intrinsic properties.
- Final Exam
- 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.
Inquire About Training
Please use the form below to request training for your organization. A customer success expert will be in touch regarding scheduling and pricing.
"*" indicates required fields
CPA Continuing Professional Development (CPD) and Chartered Accountant's (CA) Training & Development
Subject to the relevant member forming their own view as to the applicability of the course material, Calumo courses are equivalent to structured CPD and CPE. For more information, phone Calumo on (02) 8985 7777.