Dave’s Adventures in Business Intelligence

I was checking the weather this morning and noticed that weather.com now offers a social media component to their web site. It seems that if I am so inclined, I can see what other folks in my area are saying about the weather. Without doing much, well, any research I am guessing that they’re simply looking at the location information that can optionally be provided on tweets and then scanning for certain weather-related keywords.

Here’s a screen shot of the fail I noticed. Have a look at some of the tweets.

How many of them are about the weather versus something else?

First I see a person from Garland (not far away from me) who is tweeting what appears to be various national headlines, including one about the real estate situation in Florida. Apparently there are “clouds on the horizon.” Does that have anything to do with weather in my area? No, but it does have a key word “clouds” included.

I like the next example even more. We certainly have clouds here in Texas, but I can’t remember the last time we had a blizzard. Yet someone from Lewisville, Texas, just a few miles up the road from me, is tweeting his disappointment about being left out of (again I’m assuming) a beta program for the game company Blizzard Entertainment and their next incarnation of the Diablo game series. Yes, there is a weather-related keyword in that tweet, but would it not make sense to tie key words to geographical areas? The odds of having a blizzard in Texas (the weather kind, at least) are slim.

This is part of what makes text analytics so difficult. Business Objects purchased a company several years ago (Inxight) that delivers text analytics; this product is now a part of the Data Services product line. It would be interesting to see if they have a feature that would allow me to tie geo-location services to keywords so that I could discount tweets mentioning blizzards in Texas, or hurricanes in Alaska.

Ultimately it comes down to context. When I read those tweets, I can immediately see that they’re not really talking about the weather, even if they do have weather-related keywords. Apparently it’s still challenging for software to do the same thing. Then again, it’s hard enough to predict the weather correctly, so maybe I can forgive them a few errant tweets.

Earlier this year I got to see Web Intelligence 4.0 documents on an iPad. It was one of my few tweet-worthy nuggets that I shared from the BI 4.0 launch event. A few weeks ago I started building out some reports for a co-worker so we could experiment with MOBI and see just how well it worked in our environment. Along the way I picked up a copy of the “known limitations” document from SAP. Some of them are big, perhaps even show-stoppers for many folks. Continue reading “Web Intelligence on iPad – Not Ready For Prime Time Yet”

Timo Elliott published a great blog post this morning:

Why In-Memory Analytics is Like Digital Photography: An Industry Transformation

Timo is an avid photographer as well as a BI evangelist, and in this post he combines his knowledge of both, making some excellent points along the way. It’s well worth hopping over to his blog to check it out.

There has been some confusion around HANA the product, but also around HANA the name. Originally it was an acronym, but it isn’t anymore as detailed in this blog from SCN that clarifies just what HANA means as far as the product name goes.

A few weeks ago I attended the quarterly meeting for the Dallas/Fort Worth ASUG chapter. I didn’t get to stay for the entire day, but I did get to hear the keynote by Dr. Jeffrey Word about HANA. The talk was less about the technical aspects of HANA and more about the genesis of the idea. He started with a very interesting comparison. It seems that HANA is SAP’s iPod. Continue reading “Still More HANA: Report from DFW ASUG Chapter Meeting”

Author Note: I realize that SAPPHIRE is old news by now, but I felt this post still had enough to offer that I would finish and publish it.

As a technical guy myself, I tend to prefer the SAP Business Objects conference or SAP TechEd over SAPPHIRE, mostly because I find more technical content at those events. However, the Wednesday keynote address from Vishal Sikka and Hasso Plattner of SAP certainly gave me plenty to chew on from a technical perspective.

Vishal Sikka

Vishal kicked off the keynote talking about HANA, and continued that theme throughout his entire (long!) presentation. In a prior post about the conference I answered the question, “what is HANA, exactly?” very simply: HANA is a database. It can be presented in a number of different ways, but ultimately that’s the function that HANA provides. I don’t install HANA to provide new functionality. In order to do anything with it, I need what I have started calling “HANA Plus One” instead. The “plus one” can be Web Intelligence, Xcelsius, or any other query tool. It can also be application code. HANA is an accelerator or an enabler. With HANA I can do the same things I did before but much faster. Or quite possibly I can now do something I wasn’t able to do before because the process took too long. (True story: A very long time ago I was asked to optimize a daily report that was taking 20+ hours to run. By the time the report was finished it was too late. With a few report tweaks and one additional database index I got the report down to 20 seconds.) Continue reading “SAPPHIRE 2011 Wednesday Keynote – HANA, HANA, and More HANA”

Not too long ago I got (yet another) flowchart from SAP that attempts to help me decide when to use a particular tool. SAP has the rather unenviable position of having to complete the integration process started a few years back when BusinessObjects purchased Crystal, and then to also figure out how to integrate / update all of the legacy SAP tools as well. For customers the situation can be even worse, as they may or may not have access to all of these options based on what they’ve purchased over the years. Fellow SAP Mentor Ingo Hilgefort delivered a presentation to ASUG members last month that covered this same subject. Ingo’s presentation – like many I have seen – started by covering each of the primary products, discussing their major features, and talked about how they were suited for various business cases. It’s a good presentation, and if you’re an ASUG member I’ve included a link so you can download it. (He’s also doing it at the 2010 Annual Conference coming up in a few weeks.)

What I liked about slide I got was that it was based more on use rather than function. In other words, it didn’t focus on the features of the products but instead asked what was going to be done with the products. The first decision point in the flowchart was simple: is the user request for delivery or discovery?

What does that mean, and what products ended up on either side? Continue reading “Delivery Versus Discovery”

A few days ago I posted about my initial experiences with OnDemand.com, the software-as-a-service offering from SAP BusinessObjects. One of my frustrations was I was not able to compare year-to-year performance with the data set that I uploaded. I made the assumption that I could upload two data sets (one from each year) and merge them to obtain the desired result. The answer, I am happy to say, is yes. I made a few stupid mistakes along the way, but the end result is much closer to what I was trying to accomplish with my first attempt. Not only that, but I found out that I can merge data in two different directions. Continue reading “Exploring with OnDemand.com Part II”

Last week I signed up with an account at ondemand.com, a “software-as-a-service” offering from SAP BusinessObjects. I wanted to play around with Explorer for a bit, and we don’t yet have that product installed in house. It seemed like a good time to take advantage of their free demo account. I have no idea what is required to set up Explorer, or what sort of data issues I might encounter along the way. I am going into this experiment completely devoid of any knowledge of the product other than what I have seen in demonstrations. One of the selling points of the tool is that there are no training classes for this product; it’s supposed to be just that intuitive. It will be interesting to see how I do.

I first looked all over the site to find out what the restrictions are. Since I was going to be using a free trial account, I didn’t expect to be able to upload my entire two billion row fact table, nor would I want to. However, I did want to stretch the system to show of what Explorer can do. I could not find anything, anywhere, that detailed the specific limits of the free account. I even tried to find out what pricing would be in the event that I decided to host more data, and I could not find that anywhere either. If anyone finds that information online, please post a link.

Other than these site issues, how did my initial exploration go? Continue reading “Exploring with OnDemand.com”