Predictive Analytics Workshop – Public Session

The focus of this workshop is to introduce predictive analytics to anyone interested in learning more about statistics and software. Participants range from students to business and technology professionals interested in learning more about this emerging power new field. This is a beginner class so no experience is required. Participants will learn about Predictive Analytics, Data Mining and IBM SPSS Modeler software and take a hands-on tour of Modeler at our complimentary three-hour instructor led session. Get hands-on experience with IBM SPSS Modeler software to help you better understand the distinctive value of its easy-to-use, rapid-prototyping, predictive modeling and deployment capabilities.


Experience the intuitive, interactive IBM SPSS Modeler interface, which features expert nodes for experienced analysts and automated modeling capabilities for novices


Get step-by-step guidance through 3 common applications of predictive analytics: finding patterns and groups, using the past to predict the future and decision optimization.


Apply automated data preparation that incorporates structured and unstructured data, predictive techniques, and deployment options to real-world business issues

Predictive Analytics Workshop


(Public Session)

with IBM SPSS Modeler

Wednesday May 28th, 2014

8:30am – 12:00pm

Calgary, AB  IBM Calgary Headquarter  (Rocky Room B)  227 11 Ave SW

Sponsored By:

Bow River Solutions Inc.

Bow River Solutions Inc.

Calgary Cognos User Group – May 29th Event

Join us for another event hosted by the Calgary Cognos User Group (CCUG) which brings together industry professionals in the business intelligence and analytics space for a fun evening of drinks and networking with friends.

This is an open event for anyone in the local technology community in Calgary, not just Cognos enthusiasts. Everyone is welcome, so bring a friend and come mingle with some local techies.

May 29, 2014 | 5:00 pm – 7:00 pm

@ Craft Beer Market

(345 10 Ave SW)

Sponsored By

Love coffee? Have one on us!

In working with companies to help them improve their financial performance, we’ve found that Controllers are often the ones who are experiencing the most challenges getting the information and reports they need. One of the main issues is not being able to access the right data they need to report on their company’s finances.

  • Excel is difficult when doing forecasting and planning, and trying to consolidate plans in excel is tedious and error prone
  • Companies’ financial system doesn’t allow for the deeper analysis needed to understand where money can be saved or profits increased. For example, looking at sales per region isn’t as effective as drilling down to cities and individual stores or locations
  • Producing accurate and timely reports for executives is labour intensive and it is difficult to access all the required information in the proper format
We’ve had great success in tackling these issues and ones like them. We are always open to sharing knowledge in this area and grabbing coffee with anyone interested in chatting about company accounting and finance. It’s great to meet new people and if we can’t help, we might know someone who can.

If you have 10 minutes, drop us a line and we’ll take you out for coffee.

Get in Touch! – or call us at  (587)-885-1090  
Not located in Calgary? We can take the coffee date virtual – lets chat on the phone and we’ll send a Starbucks eGift Card your way to enjoy later.
Send us an email at or call us at  (587)-885-1090  for further information. We’re happy to meet with you at our Calgary office at 330 5th Avenue SW, Suite 1800 or at your location in Calgary or western Canada.

Statistics for World Leaders


Torrent of Data…

Behavioral science shows that 40% of the decisions we make throughout a day aren’t really decisions — they’re habits. Yahoo’s CEO told Bloomberg News that her goal for Yahoo as a web destination was to make it a habit: “I think that there’s a real opportunity to help guide people’s daily habits in terms of what content they read. That is something that we are really working on. All of these daily habits — news, sports, games, finance, search, mail, answers, groups — these are all things we have been underinvested in.” Launched in 1994, Yahoo is one of the old dogs of the tech world. In 2012, former Googler Marissa Mayer came on as CEO, amid much fanfare and a few photo shoots. Beyond the publicity, she quickly executed several smart strategies that have shaken up Yahoo.

7 Brilliant Strategies Marissa Mayer Used To Shake Up Yahoo


Did you know…

Don’t believe people who say they work 60 hours a week. People overstate the number of weekly hours they “usually” work by 5% to 10%, with those on the higher end being more likely to overestimate, according to a study le by John P. Robinson of the University of Maryland. By examining US workers’ time diaries, the researchers found that people who say they usually work 55 to 64 hours per week are off by an average of about 10 hours; people who say they work 65 to 74 hours are overstating by about 20 hours. Respondents may inflate their estimates because of a desire to appear industrious, the researchers suggest. Stats & Curiosities from Harvard Business Review – Page 57

Statistics for Social Media Sharing…

80% Of Facebook’s Likes And Shares Come From Outside The U.S. The Asia-Pacific and Western European regions accounted for the largest share of the clicks, claiming 21% each. Like and Share buttons are least popular in the Middle East, which only accounted for 3% of all engagement. Here’s a breakdown of the stats: Asia-Pacific accounted for 21% of impressions of Facebook’s Like and Share buttons Latin America: 13% U.S.: 20% Western Europe: 21% Central and Eastern Europe: 18% Africa: 3% Middle East: 2% Canada: 3%

Smart Solutions…

Enterprise risk management is a critical differentiator that drives business performance and better outcomes. It helps protect your brand, provides a framework for implementing enterprise-wide governance policies, ensures regulatory compliance, and increases revenue through improved risk-aware decision making. Fraudulent attacks grow increasingly more sophisticated. Using advanced customer screening, monitoring across channels in real-time for unusual behavior, and centralized case management for effective handling of detected events, you can: Improve transaction integrity Prevent sophisticated internal and external fraudulent activities Ensure client trust Managing financial risk effectively is vital to a bank’s success. Apply data modeling, predictive analytics, decision support tools and comprehensive reporting to better monitor, measure and manage market and credit risk exposure across multiple silos. You will enjoy improved liquidity, better capital management and decision-making consistent with business objectives and prudential norms.


The Canadian dollar capped its 5-year appreciation by achieving parity against the US dollar late in September. The increase accompanied higher commodity prices, notably records for oil and wheat, and a cut in US interest rates. The latter was motivated by the turmoil in financial markets that began in mid-August, and renewed weakness in the US housing market In Canada, however, there were few signs that the disruption in some financial markets (notably asset-backed commercial paper) was affecting the real economy. Most importantly, employment jumped 0.3% in September, helping to send the unemployment rate to a 31-year low of 5.9%. Higher commodity and stock market prices in September also pointed to the underlying strength of the economy
 We’re always happy to set up a conversation and discuss these points: helping with examples to show the value, realizing the need and potential gains and talking through how we’ve seen support grow. We can also discuss the overall vision with examples of how value has been delivered with many business intelligence projects. Send us an email at or call us at  (587)-885-1090  for further information. We’re happy to meet with you at our downtown Calgary office or at your location in Calgary or western Canada.

Calgary Cognos User Group – April 3rd 2014 Event

Calgary’s Cognos User Group will be hosting an event this April that brings together industry professionals in the business intelligence space.


April 3rd, 2014 Write this down in you agenda & Invite your colleagues! (Door prizes, Food & Drinks)

The IBM Building 227 11 Ave SW


5:00 pm – Welcome to the CCUG

5:10 pm – The Power of Location Analytic by ESRI Canada

5:55 pm – Q & A

6:00 pm – Break | Food | Drinks

6:10 pm – 3D Facial Recognition – Marketing by nVisio

6:55 pm – Q & A

7:00 pm – Data for Good

7:30 pm – Q & A

7:35 pm – Networking

Everyone is welcome! Be sure to RSVP and check out our Invitation. – Bow River Solutions Inc  @ If you have any questions, please contact Oscar Cruz at Call at  (587)-885-1090
Report Studio versus Analysis Studio

Which Studio is the Right Studio? Report Studio vs. Query Studio vs. Analysis Studio

Here a studio, there a studio, everywhere a studio!
IBM Cognos Business Intelligence has a Studio for every job and using the right tool or Studio is the best way to have a smooth experience with Cognos Business Intelligence suite. Some reporting and information gathering can be done in any of the Studios so the choice typically is the Studio that one knows the best – when you have a hammer all the data looks like nails. But for all of the nuts and bolts of the information out there it is helpful to know which tool is the right tool.

Report Studio

Report Studio is the top level tool with all of the bells and whistles. Reports can be made against dimensional data sources or relational data sources and all sorts of complex functions and multiple lists, charts and crosstabs can be used within one report. This Studio is typically used by the developers creating standard reports where formatting requirements are specific or complex reports with multiple pages and complex formatting. This is the tool of choice for the developer creating one standard report for multiple users.
Once you get past the complex reports or the very specific formatting that’s needed in Report Studio the determining factor for tool choice is based on the process of either ‘Query then Analyze’ or ‘Analyze then Query’. Do you know what information you need so you can Query the data and then Analyze it to find what you need? Or will it be a process of you need to find out what’s going on and then you’ll know the right question to ask in an Analyze then Query fashion?

Query Studio

If you know what you are looking for and the importance is in getting the data quickly then turn to Query Studio. This is where you know what you want to report on and you just need the information without worrying about exactly how it will fit to a printed page or how many lines exactly will show up on each page. Query Studio is great at answering these quick questions, but only one question at a time. The complexities can be left to Report Studio while the quickness is in Query Studio. This is typically the studio that business users will be using to the point where they’ll be so comfortable here that they’ll know more about it than most of the developers. Query Studio is the tool for Query then Analyze functionality. The greatness and the downfall of Query Studio lies in it’s simplicity. It’s easy to pick up with a quick tutorial you can be off and running for all of the queries you have, but when it comes to moving beyond simplicity into areas such as creating an ‘IF’ statement within the report this has to be done in Report Studio, or if it’s a standard IF statement then it can be put into the Framework Manager model and used as any other data item.

Analysis Studio

Analysis Studio doesn’t solve the issue with IF statements but it is the tool of choice for the alternative: Analyze then Query type of process. This is, to put it simply, for Analysis. When users are analyzing their business and looking for more information, they don’t have the query already formed in their mind but they want to be on top of whatever is happening then Analysis Studio is the place to go. Here is where you start off by seeing the big picture, with all of the numbers summarized so you can see sales for all regions or inventory for all regions or maybe the total headcount of all employees across the organization, but you start with that big picture. Then in a fashion of ‘Analyze then Query’ you have the ability to drill down into more information. If the numbers look particularly high or low for a given time period or a given region you can click and drill down on that area and find out all the details about this number and what’s necessary to take the next step of action. Beyond the method of working with the information the data sources are also important when choosing a tool. The Analyze then Query functionality is only available with dimensionally modeled data sources where the data is easily summed up along hierarchies and then can be drilled down to see more detail. When the data is not organized in nice hierarchies but is relational then Analysis Studio cannot be used. This is easy to determine as Analysis Studio will only give you the option of opening dimensionally modeled data sources.
So which studio is the right one: to put it generally Report Studio for complex reports, Query Studio for quick answers to queries already in mind and Analysis Studio for quick analysis and further digging. Having said that, my tool of choice is still Analysis Studio, this is the one that really puts the Performance in Performance Management and the Intelligence in Business Intelligence (BI). The other Studios have a lot of value in their areas, but this is the real power of BI; finding the information that business users were not expecting and being able to further query that data to find out more about it.
 We’re always happy to set up a conversation and discuss Cognos and Business Intelligence: helping with examples to show the tools and all their features. We can also discuss the overall vision of BI with examples of how value has been delivered with many business intelligence projects. Send us an email at or call us at  (587)-885-1090  for further information. We’re happy to meet with you at our office in downtown Calgary or at your location in Calgary or western Canada.