Archive | Business Intelligence RSS feed for this section

Cognos 10.1 install on CentOS 6.3 64 bit

yum update (then reboot if kernel has been patched) yum install glibc.i686 yum install openmotif yum install libgcc.i686 yum install openmotif22 yum install openmotif22.i686 yum install xauth yum install libXtst tar xvzf bisrvr_linuxi8664h_10.1.1_ml.tar.gz cd linuxi38664h/ ./isetup


Leave a comment Continue Reading →

How to flatten a dimensional data model built in Excel with pivot tables

To flatten a dimensional model built in Excel using pivot tables, follow these steps: save the original worksheet with the pivot table as a CSV (tab delimited is even better) select the range or column that contains the blanks (if you have blanks under the header, don’t select the column header in the range) select [...]


Leave a comment Continue Reading →

Intro to Statistics

Q: Could you recommend some books on statistics that would allow me to be more efficient at Business Analytics?   A: Below are some sites that you may find useful. 1)      The online copy of StatSoft, the Statistica textbook, a good resource, and it’s organized as a book. http://www.statsoft.com/textbook/ 2)      UCLA has an online probability and [...]


Leave a comment Continue Reading →

Enterprise Social Media Analytics with Atlas for Connections

The key benefits from deploying an enterprise social media software are to improve customer satisfaction by building stronger relationships with customers, staff effectiveness by simplifying access to existing internal expertise, staff retention by allowing employees to build a stronger network and stronger relationships within the enterprise. Atlas for IBM Lotus Connections is a social networking [...]


Leave a comment Continue Reading →

Installing a Secure Certificate on IBM Smart Business Server (VERDE)

At the time of this writing, the IBM Smart Business Server’s control panel doesn’t allow importing a secure certificate (SSL cert). Never-the-less it is possible to install a valid (CA signed) secure certificate from the command line. This article assumes that the reader is familiar with SSL and the basic SSL KEY, CSR, and CRT [...]


Leave a comment Continue Reading →

Free IBM training video for CloudBurst Appliance

IBM CLoudBurst Appliance Training Video IBM just published fresh training videos for their CoudBurst Appliance. “This video, based on five online lectures and five online demonstrations, provides in-depth information about WebSphere CloudBurst Appliance and WebSphere Application Server Hypervisor Edition. It demonstrates how to: configure resources managed in the cloud; create virtual systems for deployment to [...]


Leave a comment Continue Reading →

Business Analytics Software Efficiencies are Key

Business Analytics, Business Intelligence and the Hardware Upgrade Tarpit A common misconception about business analytics, is that better business analytics usually requires better hardware. Business Analytics: Software rules over Hardware A number of blogs have recently reflected on the “REPORT TO THE PRESIDENT AND CONGRESS DESIGNING A DIGITAL FUTURE: FEDERALLY FUNDED RESEARCH AND DEVELOPMENT IN [...]


Leave a comment Continue Reading →

Updating the Rate Sheet in the COGEXO Rating Engine

Rate table update on MySQL backed database The concepts in this guide apply for the DB2 version of the rating engine. Data Fromat product_code_call,description,cost,call_type Data Upload For the MySQL back-end, use phpMyAdmin to upload the data: Log in to phpMyAdmin Select the rate table Click the import tab Select the file that has the comma [...]


Leave a comment Continue Reading →

Migrating Data Between DB2 Servers

DB2 Support for Data Migration When it is time to upgrade from DB2 on Intel to DB2 on Power for example, taking a backup/restore approach isn’t possible as DB2′s backups are platform dependent. The solution is to use a DB2 command called db2move. Basics of db2move db2move allows to export data from DB2 at different [...]


Leave a comment Continue Reading →

Understanding Business Intelligence

What is Business Intelligence? From the thread “My Quest for Understanding Business Intelligence” this comment was posted by Leslie Dudley: Business Intelligence Background A little off topic perhaps, but as an IT business intelligence worker who was interviewing during the economic downturn, I have a slightly different perspective. First, I found myself to be fortunate [...]


Leave a comment Continue Reading →