Blog

Living in a global, ever-expanding economy means there are more people interacting than every before. Consider retail giant Wal-Mart, for example. The company conducts over a million transactions with customers every hour. That may sound like a feat in and of itself, but the company also keeps records associated with those transactions.

Well, it was bound to happen. After all, since we live in an age in which meeting the love of your life is now as likely to be accomplished by how accurately you've completed an online dating questionnaire as anything else, is it really surprising that the same principle has begun to be used to determine educational outcomes too?

Late Sunday September 30th, all clients, partners, prospects, and friends were invited to join us for good times, good music, casino games, complimentary cocktails, and appetizers aboard the 100 foot luxury yacht. We transformed this yacht into a vegas-themed party spot for one special night.

So, your global enterprise has collected some data...  How do you start to make sense of all this raw data?

As part of a recent award win, we were asked to generate a short video that could be used as part of the various award ceremonies.   The objective was to capture, in less than a minute, the essence of KPI Partners... basically an extended elevator pitch with cool visuals.

KPI Partners Launches E-Book On Project-Based Decision Support Systems

BOSTON, MA – September 4, 2012 – There is a saying that if it cannot be measured, it cannot be managed. Traditionally, projects have used schedules and budgets to monitor progress. This only provides part of the answer. It does not address other variables.

KPI Partners Ranks #1480 On Inc. Magazine’s Annual Ranking Of The Fastest-Growing Companies In America

MINNEAPOLIS, MN – August 21, 2012 — KPI Partners, a a strategic data and business intelligence consultancy, today announced that the company was named to the prestigious Inc. 5000 list, a compendium of the most entrepreneurial and fastest growing companies in America. This is the company’s first year appearing on the list.

by Kurt Wolff

Suppose you have a series of datetime pairs in Oracle BI... The problem is to display the differences between DATE1 and DATE2 in days, hours, minutes, and seconds.

by Kurt Wolff

When you duplicate a table, you create a new physical table with a new name. If this table is involved in a query, the SQL FROM clause will list this table. If the table does not exist in the database, then an error will occur.

Creating an alias creates a copy of the metadata table object that will be referenced in SQL with a new alias name. The alias name in SQL, as it is for all tables, will be derived its metadata ID.

To see the table IDs in OBIEE metadata, use the Oracle BI Query Repository utility. Here are some physical tables (and aliases) in a repository that I’ve created. It’s the last five digits of the ID that will be used to create the table aliases in SQL.

by Kurt Wolff

Row level security (constraining a user’s view of the data to rows which meet pre-defined criteria) is a common requirement in OBIEE. This post will explore this topic, using a simple schema with a single fact table and three dimension tables, built around the theme of retail sales.

by Kurt Wolff

Suppose you have a dashboard with three pages (tabs). Suppose further that not every user should see all three tabs. Most users will see a limited set of the tabs – some will see two, some will see only one. You want to define web groups to cover all the possible combinations. How many web groups would you have to create?