View our profile on LinkedInFollow us on TwitterLike us on FacebookView our videos on YouTubeVisit our blog

In This Issue
Clear Insight Services
Budgeting, Planning and Forecasting

Clarity 7 - Tips & Tricks  

About Us  

Contact Us 

Financial Reporting and Disclosure
Business Intelligence and Analytics

Let's stop re-inventing the wheel!

Upcoming Events

WEBINAR -The Illusive Executive Financial Dashboard


 EVENT - IBM Financial Forum 

EVENT - IBM Business Analytics Summit

 EVENT - IBM Vision 2014 in Orlando, Florida 

About Us
Clear Insightaboutus
is a solutions provider to the office of finance for our international base of clients.  Our clients view us as business partners delivering excellence in IBM Clarity, IBM Cognos TM1 and the remaining family of IBM Cognos solutions.

Our team of project managers, business consultants and technical consultants bring unmatched understanding of the business issues and superior technical expertise to maximize ROI and value in every relationship.


Clear Insight is an authorized IBM Business Analytics software reseller so we are able to provide complete solutions with consulting, software and services. We can process your product and support renewals at very competitive prices.
Contact us
P: 905-473-6989
F: 416-981-3534



1011 Upper Middle Road
Suite 1149
Oakville, Ontario, L6H 5Z9


United States

1051 Clinton Street
Suite 212
Buffalo, New York

Follow Us
Clear Insight Newsletter
April 2014


As we write this months newsletter we look out on a very busy May.  For most of you reading this newsletter who work in the office of finance the months of April and May are the best times to look at enhancements and new solutions.
We are working with many clients during this time and look forward to sponsoring and attending a number of conferences which you will see mentioned throughout this newsletter. 

Remember you can always click on our social links in this newsletter to get to our full Blog and YouTube channels etc.

On behalf of Clear Insight - Happy Reading and Watching!
Ian Margerison


Clear Insight Services & Helps

Archiving - How to improve performance by archiving historical data


Any database application should be able to deal with data growth. As an application is used, data is created and evolves. With a corporate performance management tool, data can nicely sliced by a (Scenario, Year) combination. For example (Actual, 2004) would be the actual transactions that happened in 2004. (Budget, 2006) would be the approved budget for 2006). If a system has been in use for 5 years and each year is focused on building only a 1-year plan, 80% of the data is static. Many administrators do not know that, in most cases, all active data is reprocessed each night. 

Watch our "How To" YouTube Video on Archiving 


Have you outgrown Excel for your business analytics?Outgrownexcel

Accountants love Excel. Accountants hate Excel. Excel as a general purpose spreadsheet is a great way for people to interact with their data; however as the saying goes "if all you have is a hammer then everything looks like a nail". Using Excel for everything is the perfect example of a familiar technology being applied obsessively to many problems.  If you are suffering from any of the following, you may need more than Excel.

Read More 


Financial Reporting & Disclosure 

Let's stop reinventing the wheelwheel  

Presenting to management again?

It's a basic fact of business decision-making. Access to accurate data, and timely commentary and analytics is critical to making sound business decisions.


Yet, for many departments, report building is often a tedious, time consuming and error prone process.   Yet, for many departments, report building is often a tedious, time consuming and error prone process.

Download the full white paper


Business Intelligence & Analytics 
Wondering want Business Analytics could do for your company?BAEWorkshop

Clear Insight is preparing to sponsor "The Business Analytics Experience" for people just like you!  


The Business Analytics Experience Workshop is a highly interactive event ideal for providing your cross-functional team with a taste of what's possible for an analytics-driven organization. Divided into small competitive teams, participants role play executives in a fictitious company in a fun hands-on environment. Using simulated data and challenged with specific business goals, they must use business analytics in real time to determine:

"what's possible in an analytics driven organization"

Read More 


Upcoming Events  

IBM Vision 2014 Conferencevision2014
Join Clear Insight at Vision 2014, Orlando, Florida,
May 18-21, 2014. 

Vision 2014 is the premier global conference for finance, risk management, and sales compensation professionals. In three information-packed days, you can see how IBM Business Analytics solutions help you drive profitable growth, manage risk and optimize performance.
IBM Financial Forumforum
Join Clear Insight at the IBM Financial Forum, Toronto, Canada.
May 12, 2014

At Finance Forum, you'll hear from the experts how leading organizations are delivering stronger business foresight through analytics to improve management decision-making. You will find out how to put to work the latest insights from the IBM Global C-suite Study.
IBM Business Analytics Summitsummitt
Join Clear Insight at the IBM Business Analytics Summit, Toronto, Canada.  May 13, 2014. 

IBM Business Analytics Summit is a series of complimentary events held in cities around the world. These events feature how-to sessions where you'll learn how to get more from your existing deployments-especially in providing more self-service sufficiency to the end users who depend on you-and how to apply analytics to address core business imperatives and drive game-changing results.


Webinar - The Illusive Executive Financial Dashboarddashboardwebinar

The Illusive Executive Financial Dashboard

Complimentary Webinar
Date:   May 15, 2014
Time:   2:00 - 3:00pm