BusinessIntelligence

Cognos/general BI usage audit dashboard : BusinessIntelligence – Business Intelligence Article

As some of you know, I work for an IBM analytics consulting partner. We recently released our product PMsquare Thrive, which gives a comprehensive view of what users are doing in Cognos. We’ve been considering adding additional BI tools to the mix. I’m curious what you guys think and whether or not there would be a good case for something like this in your BI tool of choice. Thanks for the feedback! EDIT: I should clarify, we’re considering adding other…

Read More

Any experience with Quicksight? : BusinessIntelligence – Business Intelligence Article

https://aws.amazon.com/quicksight/ Has anyone used this? I live in Seattle and some friends at Amazon have told me it “sucks” and they all use Tableau. However, their “pay per session” pricing model seems intriguing/disruptive. I find it hard to imagine it’s that bad. Especially with the recent Gartner BI MQ and some subpar products making it up the list imo. Was curious not to see this on the MQ at all. This is only a snippet of a Business Intelligence Article…

Read More

A Guide to Building a High Functioning Data Science Department : BusinessIntelligence – Business Intelligence Article

I don’t get the hate for ETL work. At worst a task is boring, yet at the same time easy and can be knocked out quickly. With something more complicated, it can be challenging but in those cases it feels more like solving a puzzle than hard work. Setting up an elegant solution to a complicated process, turning it on, and watching it go about its business while you can proceed to pretend it doesn’t exist unless you’re alerted to…

Read More

How to audit an Excel file : BusinessIntelligence – Business Intelligence Article

If you find yourself working with ballooning Excel files, it can be immensely frustrating. They break all the time and are generally a pain share and work with. I once picked-up a 120MB Excel file that was a beast. It crashed all the time and took hours to use. Sadly Excel doesn’t include any tools to help you to audit what is going on. There is no easy way to find out what is taking up all the space. If…

Read More

Improving Conversion Rates and Customer Insights with RFM analysis : BusinessIntelligence – Business Intelligence Article

RFM analysis is a simple to understand and easy to apply data analysis model to segment your customers. It allows you to quickly develop and present targeted strategies for each customer segment for improved conversion rates. Below guide is a step-by step tutorial on how to create such a model in Google Sheets. Furthermore it shows you specific strategy recommendations for each of the key customer clusters (and if you want to get started quickly you can plug-in your data into the…

Read More