Tag Archives: analytics

become rich and famous, well kind of famous, next year

Stephen Few, over at Perceptual Edge, last month launched their 2012 Dashboard Design Competition and you need to hurry up and get cracking as the closing date is Sept 21, 2012!

The basic idea is to present student performance data in a dashboard so that a teacher can rapidly and effectively monitor the performance of students to help them improve their math skills.

Links to the data are provided on the blog post here and contain behavior, aptitude, and achievement information for students in a single high school mathematics class.

I wish I had some spare time to devote to this exercise.

The winner of the competition will get their dashboard included in Stephen’s Second Edition of Information Dashboard Design, due out in 2013.

Bootnote:  Stephen has also just released the Second Edition of his first book:  Show Me the Numbers, available now.

kscope12 is less than one month away

June is just around the corner and the Kscope12 conference is coming up fast.

Check out the agenda, presentations and presenters for the 250 sessions.

For those of you unsure whether it’s worthwhile, how you can convince your manager and what attending can give you, the great folks at ODTUG have prepared some justification letters for different participants:

Get your request in today, the Advance rate ends on June 9th!  Hope to see some of you there!

The BI/EPM letter is as follows:

Memo: Request for Approval to Attend ODTUG Kscope12, June 24-28, 2012,San Antonio,TX

To: (Manager’s Name)

Submitted By: (Your Name)

Date:                                                   

It’s hard to find a conference that’s big enough to attract world renowned speakers and small enough to get the chance to share knowledge. ODTUG Kscope12 is that conference.

This is my opportunity to learn from the best technical minds in the business and bring back knowledge that will enhance our organization. No other conference in the Oracle world features this kind of development-specific training and content including lessons learned by other companies facing similar challenges and hundreds of opportunities to learn money-saving techniques.

Below are the reasons why my attendance at this conference is of value to our organization:

  • 100+ technical sessions focused on BI/EPM
  • 3 days of Hands-on Training – No extra charge
  • An all day BI/EPM symposium – No extra charge
  • Great networking opportunities including: Lunch-and-learn sessions with Oracle ACE Directors, meet the Oracle experts, Vendor showcase, and special events

The technical sessions are based on tools and techniques we utilize in our work on a daily basis.

  • Business Intelligence
  • Essbase
  • Hyperion Applications
  • EPM Business Content
  • Essbase Beginner

ODTUG Kscope12 is very reasonably priced compared to other conferences in our industry, and it is the most specific one for developers—with its wealth of learning and networking opportunities, it’s definitely worth the investment.

The Full Conference Registration, Advance rate is $1,800 for ODTUG members and $1,950 for non-members. In order to take advantage of the Advance registration discount, I would greatly appreciate a response by
June 1, 2012.

Thank you in advance for your consideration.

Visit www.kscope12.com to find out more.
Sincerely,

Name

smart view 11.1.2.2 review

Several of the updates to the Hyperion 11.1.2.2 suite are behind the scenes, not noticeable for users, except for users of Planning – with new predictive and chart functionality and Smart View users – who don’t have to upgrade the back end (server services) to take advantage of some:

  • Support for 64-bit Microsoft Office 2010

  • Planning Enhancements for: cell history – so you can review changes to a cell or range of cells and reverse changes, master composite forms (a new type of form), attachment of multiple comments to data cells, customized confirmation messages and support for approvals security
  • Smart View supports Financial Management configurable dimensions
  • New VBA features for: HypGetMemberInformationEx, HypGetActiveMember, HypSetActiveMember, HypGetDimensions, HypSetDimensions, HypGetMembers, HypSetMembers, HypGetBackgroundPOV
  • New Logging Levels: Extended and Profile
  • Excel Formatting enhancements to maintain formats when zooming in and pivoting
  • New Extensions for Predictive Planning and Strategic Finance
  • Smart Query – which is a new reporting tool which allows users to construct report sets from members and filters. these sets can be combined to create complex queries with joins and intersections of data from the defined data sets
  • Changes to the Smart View ribbon to include Panel and Connection buttons for easier, more intuitive access (According to Oracle) to Smart View connections

I’ll spend some more time reviewing the new Smart Query feature next time, so stay tuned.

For more info, check out the Smart View documentation on the Oracle Doc Library:

What’s new in Smart View

Smart View User Guide

Oracle EPM 11.1.2.2 Doc Library

Bootnote: As with any software upgrade, this one is not necessarily a slam dunk – in that it should always be installed. Please review the Readme paying particular attention to the known issues list – while Oracle have fixed 46 issues in this release, there are 104 known issues across all smart view components.

There has also been the following identified as an unknown issue:

BUG 14055582: When selecting a range of cells, then attempting to use the right click range menu, the right click deselects the range and only the last cell is highlighted. A work around is to select whole rows or columns to perform right click selections.

So review the docs and test, test and test again making sure the enhancements don’t take away any functionality key for your users.

a sign of the i-times

ImageAfter attending the recent Oracle update on their business analytics strategy, including the latest Hyperion release and Exa-everything supercharged hardware and software stacks I had expected the usual follow up emails asking me to buy and sell to clients.

However, along with the links to the recorded presentations and content (in pdf), there was also link to download in ibook format.

That just goes to show how ubiquitous the iphone/ipad has become in the  corporate world.

Of course Oracle has been pushing their mobile applications, which run as part of the OBIEE suite, which don’t require any special coding. but you do need OBIEE.

Interesting to see that it’s not just a pdf converted, there are links as well as video embedded (see image below).

 Now I only need an exalytics box to play around with …. 😉

hyperion 11.1.2.2 released

Hyperion 11.1.2.2 is now available on the Oracle edelivery site:

There will be some busy consultants over the new week pouring over the readmes and installation files 😉

PS, Still no love for Solaris x64, guess I’ll have to make do with Windows or maybe Linux 😛

chartjunk – oracle helping reduce the urge to clutter

When Tufte defined ‘chartjunk’ back in 1983, he probably didn’t realize how easy computers and software would make it for people to add the “… graphic paraphernalia routinely added to every display that passes by: over-busy grid lines and excess ticks, redundant representations of the simplest data, the debris of computer plotting, and many of the devices generating design variation.”

Consider the above Hyperion Analyzer sales graphic, did you notice the important figures, or was your focus diverted by the colored circles and bright colors?

It’s very difficult to indeed see that the south and central regions aren’t performing as well as the east and west – although both still over budget.

Nor can you easily compare the colors on the maps for east in blue, with the chart for east in purple.

In fact if you measure the screen it seems that the actual data (and I’ll be generous here and include the map) is less than 40% (or 15% without).

While Hyperion and Oracle have previously been enablers in adding headers, panels and other junk it’s refreshing to see the latest version of OBIEE present a cleaner surface – which users can still mess up, but it’s more difficult 😉

Here’s a sample dashboard from OBIEE, notice how the headers and panes take up less room, enabling the designer to cram six sections onto the space. While it’s a step in the right direction, it’s still up to report designers and system architects to present data that is clear and enables the user to quickly see the important data and trends – so they can take action.