Go to Top

Capitalize Analytics Blog

Upcoming Live Webinar – Use IBM Cognos Event Studio to notify you about ANYTHING!

Use IBM Cognos Event Studio to notify you about ANYTHING! (Live Webinar) 

Wed, August 30th, 2017 10:00 AM – 11:00 AM CST 

With data coming in from every direction, sometimes the biggest challenge is knowing WHAT to pay attention to! You may have hundreds of reports, dashboards, etc. available but which one should you look at today? With IBM Cognos Event Studio, you can easily set up alerts to notify you that something has happened. This works across every system you have!

Examples we’ve seen: 
“Alert me if any project is within 90% of budget.”
“Alert the store manager if inventory drops below X.”
“Alert the contract administrator if a contract is set to expire within 90 days.”
“Alert me if a new order is placed.” 
“Run a database job to delete access if a user is removed from Active Directory.” 
“Call a web service to add a user to a system if we have a new hire.” 

Let us show you how you can use IBM Cognos Analytics to be alerted about ANYTHING that happens within your systems!!


Upcoming Live Webinar – Expand Beyond Core for 360-View of Customer – We hope you are able to join us!

Expand Beyond Core for 360-View of Customers – Overcome Core Limitations with Cognos Analytics (Live Webinar)

Wed, July 26, 2017 12:00 PM – 1:00 PM CST

Across the banking industry analyst struggle to leverage existing reporting environments to examine customer behavior.  The right data analytic environment can provide vital insights into customer demographics and spending patterns by aggregating transactions and providing self-service capabilities to your front-line staff.

Join this interactive webinar with Capitalize Analytics and IBM to learn how data analysts in the banking industry are unleashing their data to:

  • Improve customer retention by offering better customer service
  • Analyze all customer data from a single interface
  • Use visual data discovery to identify trends and outliers

We look forward to speaking with you on July 26th.


Alteryx Inspire Conference June 5-7th, 2017

Alteryx Inspire 2017-2Alteryx Inspire Conference

Alteryx Inspire Conference June 5-7th, 2017 @ ARIA Resort & Casino, Las Vegas. Alteryx Inspire 2017 user conference celebrated these iconic achievements, learned from peers, and pushed the boundaries of what’s possible with data. Armed with tools that make insights more accessible to everyone, we all have the power to become Icons of Analytics!


Waterfield Sixth Annual User Group Event

Waterfield Energy Sixth Annual User Group 2017

We hope you were able to join us for the Sixth Annual Waterfield Energy User Group Meeting! We provided attendees with an overview of Waterfield’s strategic direction and review cross-functional product enhancements made in the last year. We appreciate your feedback on future production direction, and look forward to enhancements for 2018.
June 15-16, 2017 at the Hilton Dallas/Rockwall Lakefront, 2055 Summer Lee Drive, Dallas, TX 75032


Are you ignoring your data?

All the data flying at us everyday makes us want to just bury our head in the sand and ignore it! As we all know, this isn’t the best business strategy or approach but all to many organizations are operating this way. In fact, Forrester estimates that only 12% of the data collected by most organizations is ever actually analyzed – that means that your organization can be missing out on insights from a whopping 88% of your data! In today’s analytics driven environment, this just seems crazy!

Why is this happening? Most organizations fall into this trap by not having the right Business Intelligence and Analytics tools in place and the data needed is hard for various users in the organization to actually get to.

How do you take full advantage of all your data? Start by looking at what type or types of analytics tools you are currently using.

Traditional BI and analytics tools behave like a report card, telling you what happened in the past. Predictive analytics (PA) tools can instead provide you with a roadmap into the future. They allow you to apply real world “what/if” analysis to your data. The evolution of analytics solutions into intelligent, predictive tools is truly exciting.

It is easy to see why there is a lot of buzz around predictive analytics. Marketing and sales are obvious early adopters to anticipate customer and marketplace behaviors. It has extended into all areas of the organization.

HR is looking to improve talent acquisition, reduce turnover, and understand the most effective compensation strategies. Operations can use PA to increase efficiencies, improve resource utilization, and intelligently manage procurement and inventory.

So how do you get started with a predictive analytics project? There are several keys that can ensure its success.

  1. Predictive Analytics Is Not JUST a Technology Solution

While it is built on technology and can be used to solve some technology challenges, predictive analytics is first and foremost a business solution. You need to have a solid understanding of the business problem that you are trying to solve.

For a PA project to be a success, it must generate business value. That business value has to align with the overall objectives of your organization. This is critical to get buy-in from executive leaders that can provide the support you need.

  1. Analytics Is Now a Team Sport

Predictive analytics can generate more valuable insight when you have assembled a team with skill sets across the organization. Depending on the goals, you might need representatives from finance, operations, and marketing. Their collective insight will help boost the project forward.

You will also need the involvement of IT departments. While this is a business solution, it is built on technology. And IT will ultimately be called upon to support the solution, helping move the project forward from its beginning.

  1. Know and Understand Your Data

Another reason to involve IT early is they are the ultimate keepers of the data. You will need to conduct a complete data inventory so you understand what data you have, where it is stored, and who owns it. Once you understand your internal data, you might find gaps that need to be filled.

Your PA project is only as good as the data that it is built upon. So you might find areas that need improvement. This can include more structured data governance or heightened data security so that your information does not become corrupt or stolen.

  1. Have the Finish Line in View

If you are just getting started with predictive analytics in your organization, you will want to demonstrate business value as quickly as possible. It is much better to proceed with small steps that keep you moving forward than to take a giant leap where you fall on your face.

You might find many more ways you would like to analyze data during the project. However, be careful not to overextend yourself. A common problem is that the project keeps growing and the deadlines keep getting pushed back. Sometimes resulting in a loss of confidence in the project itself.

  1. Be Lean and Be Agile

The idea behind implementing predictive analytics is to anticipate factors that can affect your business.  Today, the pace of business is constantly moving, an analytics solution needs to be able to adapt to change rapidly.

Although this point might seem contradictory to number 4, they actually work together. You want to achieve your business objectives as quickly as possible. This forces you to keep the project lean. What we mean about staying lean is avoiding the urge to boil the ocean. Stick to the data critical to the project. Keeping the project lean will also allow you to be agile and adapt to business needs quickly.


Predictive analytics can have an amazing impact on your organization. It can help you identify business opportunities in time to take advantage of them. It can help you save money by shedding light on ways your business can be more efficient. It can also help in acquiring quality talent to your organization.

Like any project, the right steps need to be taken in order to provide the greatest opportunity for success. In addition to the 5 keys above, you will also want to make sure that you select the right analytics tools along with a solution provider that can help you get the most out of your investment.

If you are ready to take the next step or would like to discuss how to select a data analytics tool that is the right fit for your organization, give us a shout. We would love to work with you to get you started.


Upgrading to Cognos Analytics v11

If you haven’t heard about the latest release of Cognos Analytics (v11 R4), then read on. We have put together an overview highlighting some of the new and improved features. The functionality available in Cognos 10 is still there, but it’s a completely re-designed experience and delivers ease of use for the business user without compromising IT functionality all while dramatically increasing productivity for departmental and enterprise reporting.

  • Redefined consumption experience for any device
  • Accelerated business modeling and performance
  • Redefined report authoring and analysis
  • All your Cognos 8 and Cognos 10 content moves forward
  • Traditional studios are available

Cognos V11 WelcomePortal – Welcome screen

  • Coach marks to guide users
  • Find Content



Cognos_V11_Capitalize Analytics




Cognos V11_Schedules_Capitalize AnalyticsContent Management

      • New sliding panels for easy navigation
      • Maintains folder security specifications from Cognos 10
      • Create folder, sort, copy, move, change properties and more


Cognos V11_Schedules_Capitalize AnalyticsSchedules and Subscriptions

      • All schedules and jobs are maintained
      • Users can now subscribe to reports
      • The report is delivered to their Notification Center on a schedule



Cognos V11_Reports_DashboardsSimplification of the Studios

      • We’ve reduced the number of interfaces for simplicity:
        • Report
        • Dashboard
        • Data Module
      • IBM recommends to create new content using the new tools


Cognos 11_Cognos 10.0Where are the old Studios in Cognos Analytics?

      • Companion applications are still available for existing customers
        • Cognos 10 Studios
        • My Inbox
        • Drill-Through Definitions
        • My Watch Items


Cognos v11 Cognos v10 Matrix








Cognos Workspace in Cognos Analytics


      • Still available in Cognos Analytics, opens in a new browser tab
      • Removed certain capabilities such as the Do More
      • Announced for deprecation

Embedded items

      • Viewer URL API is unchanged – Opens in Cognos 10 style report viewer
      • SDK and CMS are unchanged – New capabilities like Dashboards are not currently accessible from the SDK
      • Embedding portlet widgets in the following 3rd party portals is unchanged: – SharePoint – WebSphere

Data_Metadata_Cognos V11Data, Metadata and Queries – Status quo for:

      • Framework Manager, models and packages (CQM/DQM) – exception: no CQM support for TM1, Essbase, SAP BW, Microsoft Analysis Services
      • Dynamic Cubes and Cube Designer
      • PowerPlay and Transformer


Manage_Cognos V11_Capitalize AnalyticsManage

      • Basic administrative capabilities
      • Targeted at the departmental admin
      • Links to Cognos Administration for Administrators
      • Perform a subset tasks that are in Cognos Administration


Are you ready to take advantage of all that Cognos v11 has to offer? Give us a shout and we can help you upgrade or start from scratch with Cognos V11.

SunGard (SNUG) 2016 National User Conference

It’s here – SunGard 2016 National User Conference

SunGard 2016 National User GroupLooking forward to seeing everyone at SNUG 2016 National Users’ Group Conference coming up next week in Ft. Worth. Hopefully you have selected your vendor sessions, but if not, sign up for one of our Cognos sessions:

Tuesday, October 11th, 2:00pm – 2:30pm: Cognos Training, Mentoring, and Dashboard Examples

In this session, we will discuss the training and mentoring options available from Capitalize and SunGard to ensure you’re fully utilizing the capabilities of IBM Cognos. We will also highlight some of the district solutions we’ve worked on recently that have helped districts Liberate Their Data! Add session to your schedule.

Wednesday, October 12th, 2:30pm – 3:00pm: Connecting Cognos to Other Data Sources.

In this session, we will show you how to pull new data sources into your Cognos environment. Cognos can pull from any system in your district, helping you to Liberate Your Data! Add session to your schedule.

Predictive Analytics – Worth the Investment?

The answer is YES! I have written a few blogs about predictive analytics, but wanted to take a small step back and define predictive analytics. There are various thoughts, ideas, perceptions etc. and a lot of talk about predictive analytics being the next wave in big data analytics. But what is it exactly? Remember the movie Minority Report? Well, we aren’t quite there – where we are predicting whether anyone will actually commit a crime – but, the concept of using big data to predict potential scenarios and bring new insights for your organization is here.

Predictive analytics allows you to add what/if scenarios alongside your historical data. It brings together advanced analytics capabilities spanning ad-hoc statistical analysis, predictive modeling, data mining, text analytics, entity analytics, optimization, real-time scoring, machine learning and more. It allows you to move forward from static reports to a more intelligent decision-making process. Basically, it helps guide you with answers to What happened?  Why?  What next? 

Predictive technology is here. Recently, Forrester Research looked at the major big data predictive analytics solutions and identified the top three (see page 11). At the highest point for leadership and market presence is IBM—which makes sense given that IBM has invested heavily in this space.

IBM and Predictive Analytics

Many people are aware of IBM Watson, the computer that beat human competitors Jeopardy! and talked with Bob Dylan about a possible collaboration. Watson is pretty cool, but there is another key component to IBM’s predictive solutions – IBM SPSS.

Some organizations struggle to get the maximum business value out of their data. IBM saw an easier way through SPSS. There are two primary modules that you work with: SPSS Modeler, which helps you create predictive models for your business processes, and SPSS Statistics, which provides advanced statistical analysis of your data for deep insights into your business challenges.

These two modules can be deployed in multiple configurations based on your unique requirements and the needs of various business units. The power of IBM SPSS predictive analytics solutions provide benefits across the entire enterprise. It puts capabilities into the hands of business users, data scientists, and developers.

Some examples of where predictive analytics is having an impact in various industries as well as areas within organizations are:

Customer Analytics – Understand who your most lucrative customers are, the best ways to attract them, and how to maximize their lifetime value through up-selling and cross-selling strategies. IBM SPSS has a social media analytics tool to help you tap into social media data to learn more about your customers and build a deeper connection.

Operational Analytics – Gain better visibility into your processes, people, and assets. Optimize your operations to maximize profitability and productivity. Inventory management improves through predictive analytics when you can bring in more data from sales forecasts, cyclical trends, market conditions, social content, and more.

HR Analytics – Use the data you currently have on employees to find, attract, and retain the best people. Based on your business information, you can not only help put your team in the best position to be successful, but you can also forecast future staffing requirements. HR recruiters can be more proactive instead of simply reacting to work orders and focusing on individual transactions.

Asset Analytics – Maximize the lifetime value of your critical assets. Use predictive analytics to optimize uptime by avoiding unexpected errors and proactively maintaining equipment. You can gain greater insight into the use of your assets so that you can make more informed purchasing decisions in the future.

Fraud and Threat Analytics – Secure your data, applications, and money using predictive data analytics, which is increasingly becoming more important in these areas. Every threat cannot be accounted for. It requires constant and consistent monitoring while assessing activities for suspicious behavior. And if there is an incident, how quickly you react can greatly affect your business. If you are the victim of a major fraud, that usually becomes apparent pretty quickly. However, smaller hits could take months to uncover. Very often, data breaches are not detected for over 6 months. Unlike losing money, when someone steals copies of your data, those files do not disappear.

K-12 Organizations –  School districts, colleges and universities are making the most out of their decisions by analyzing trends and predicting future outcomes centering around student retention, student enrollment, student performance/success and institutional research. 

Predictive Analytics Is Here

Implementing a predictive analytics solution can be the single most important investment you make in 2016. A successful implementation can alter the competitive landscape of your industry. You want to make sure that you choose a platform based on best-of-breed capabilities. In order to help, you can take a look at this study from Forrester Research, in which they evaluate 13 solutions and name three leaders in predictive analytics solutions.

Optimize the future with better decisions today. Let’s work together and put a predictive analytics plan together for your organization. Give us a shout today!

The 2 Hottest Buzz Words in Technology Today

Two of the hottest buzzwords in technology today: Internet of Things (IoT) and big data analytics.

Let’s start by defining what these technologies are. Internet of Things (IoT) is the amount of items that are connected to the Internet – which is about to skyrocket. IoT technologies can be found in all kinds of different industries from agriculture all the way to energy and transportation. In many cases, these devices are tiny, inexpensive sensors that report information back to large data collectors. The data can be for maintenance reasons or to improve performance.

Big data analytics is the use of advanced analytic techniques against very large, diverse data sets that include different types such as structured/unstructured and streaming/batch, and different sizes from terabytes to zettabytes. Big data is a term applied to data sets whose size or type is beyond the ability of traditional relational databases to capture, manage, and process the data with low-latency. And it has one or more of the following characteristics – high volume, high velocity, or high variety. Big data comes from sensors, devices, video/audio, networks, log files, transactional applications, web, and social media – much of it generated in real time and in a very large scale.

Gartner predicts that there will be 6.4 billion devices connected to the Internet by the end of 2016. They will be joined by 5.5 million new devices every day. These sensors could be items in your home, including your coffee maker, however the larger application of IoT is in the corporate world.

Take oil and gas organizations for example, there is data generated by all of the devices, control systems, sensors, SCADA, networks, applications and end users connected by industrial networks. With advances in sensors, the amount of data points has escalated so much that it now requires a new way to analyze that data. That is driving the advancement in big data analytics. Now, sensors can make it into many other applications. Big data analytics can be used to improve and streamline transportation, refinement, and distribution of oil and gas. Data gathered from a drill-bit or a reservoir might provide information that can save millions in production costs if it can be analyzed and combined with other data sources.

These insights are invaluable to this industry – especially during times of reduced oil prices and increases in competition. Now is the time for organizations across all industries to start preparing to ensure you are ready to take advantage of the tangible benefits that you can gain by leveraging machine data and the IoT.

Data Quality and Governance

Getting the most from data and making accurate decisions starts with quality data. All of the analytics in the world won’t matter if the data at the core is inaccurate.

The data also needs to be opened up to everyone in the organization who could benefit from it. Data traditionally resides in silos by department. IBM self-service solutions enable access to relevant data without having to rely on a technical expert or jump between numerous applications. Users can find answers quickly—on their own and take full advantage of analytics. You may learn that production and distribution are asking the same questions. Their data, when combined, could lead to millions in cost savings.

Predictive Analytics

The cost benefits created through big data analytics extends to just about any industry. If an asset such as a crane could predict when it was going to have a failure, maintenance could be scheduled in advance at a convenient time. This saves on maintenance costs, as well as improves productivity.

For a big data analytics project to benefit an organization, it needs to be data-driven, be actionable, and generate a monetary impact.

To learn how big data analytics and the expanded use of IoT can be used to improve your business and gain a competitive edge – let’s talk! Schedule a meeting with one of our data analytics experts today.


Top 5 Must-Go-To IBM Cognos Events

This time of year there are a lot of things going on – school is back in session, football is in full swing (yeah!) as well as a host of wonderful, fun community festivals like Octoberfest! The same is true in the world of Cognos – lots of things going on and some really great events coming up. Below are 5 of the “must-go-to” IBM Cognos events.

Capitalize Analytics SNUG2016SunGard National User Group (SNUG) Conference – Ft. Worth, TX, Oct. 10th-13th, 2016

We are excited to be a sponsor of this great event and it’s right here in our own backyard this year! SNUG is an educational, informative and professional development conference filled with sessions from respected SunGard K-12 subject matter experts, covering a wide variety of education-oriented topics, future technological trends and directions and much more!

Capitalize Analytics Splunk Dallas LiveSplunkLive! – Dallas, TX, October 13th, 2016

Please join us October 13th for SplunkLive! Dallas – and learn how more than 10,000 enterprises, government agencies, universities and service providers in over 100 countries use Splunk software to deepen business and customer understanding, mitigate cybersecurity risk, prevent fraud, improve service performance and reduce cost. You’ll hear from industry experts, customers and technologists on how they’re turning machine data into actionable insights.

Capitalize Analytics IBM SPSSIBM SPSS Predictive Analytics Data Mining Workshop – Houston, TX, October 20th, 2016

Join IBM SPSS experts in Houston on Thursday., Oct. 20th for a hands-on workshop. This event will focus on key areas geared toward helping organizations make the most out of their decisions by analyzing trends and predicting future outcomes. IBM experts will help you better understand the distinctive value of the easy-to-use, rapid prototyping, predictive modeling capabilities of Modeler software.

IBM Insight 2016 ConferenceIBM Insight 2016 – Las Vegas, NV, Oct. 24th-27th, 2016

IBM Insight 2016 is coming up @ Mandalay Bay, Las Vegas. See how to apply the latest advances in data science and analytics to gain unexpected insights that are hidden in your data. You won’t want to miss the Insight Expo either. This is the place where attendees can meet IBM Business Partners, preview new technology, and can check out hundreds of innovative products. Mark your calendar to attend IBM Insight 2016!

Capitalize Analytics Cognos WebinarLive Webinar: Cognos Reporting Tools – Wed, Nov. 16th, 2016 10:00am – 10:30am CDT

Discover how to create compelling interactive reports. A picture is worth a thousand words – it really is true. That’s why people want engaging visuals in their reports; it helps them make sense of all that data. If you’re responsible for delivering those reports, this webinar will show you how Cognos provides the fundamentals you need to create the interactive reports people want.