Blog Featured Archive

Xcelsius Will Always Be Xcelsius

By
Paul
Published: August 3, 2010Posted in: Blog Featured, Business Intelligence, Paul Blogs on BI, Sapphirenow, XcelsiusTags: ,
Xcelsius Will Always Be Xcelsius

So what’s in a name? Some people will tell you “everything” while others will tell you it depends on what you are naming.

Some products have not only become defined by their name but have been so successful they end up defining all products of the same type like “Kleenex” and “Band-Aid” .  Others have found out that their product name can end up portraying the wrong image like Chevrolet’s Nova car – “No va” meaning “it doesn’t go” in Spanish! The French company Bull Computers also had a hard time with its “Bull” named products in North America.  However, Bull also launched a clever marketing campaign around the ambiguity of its name entitled “Know Bull” which did get some attention.

At this year’s Sapphire, Sir Richard Branson told this great story of how when he went to register the name “Virgin” for his company in the UK, the company registration official turned it down because they deemed the name as rude. So Branson returned the next day with a dictionary showing the definition of “virgin” as being pure and they accepted it.

So I have been somewhat intrigued about recent forum discussions surrounding SAP’s decision to rename Xcelsius – their amazing and very popular dashboard product.

Xcelsius already had some name recognition when Business Objects acquired Infommersion (the original developers) in November 2005 but then proceeded to rename it Crystal Xcelsius. This resulted in a lot of confusion as people started to relate the product to Crystal Reports and thought it was an add-on to this report writer product.  So when the next major release was developed, the decision was made to drop the Crystal name and so Xcelsius 2008 came to market.

For the last two years Xcelsius has become one of the most popular and prolifically used BI dashboard products in the marketplace and its name has become synonymous with data visualization and dynamic dashboards. 

So why would you take this very well known product with such a cool and catchy name as Xcelsius and rename it SAP Crystal Dashboard Design or SAP Enterprise Dashboard Design?

Well apparently this is because SAP uses a “master brand strategy” where SAP is the master brand and the product brand name takes a back seat. 

So why not SAP Xcelsius?

Well this is because SAP also uses “descriptive naming” for all its products so in the case of Xcelsius, the back seat has been completely removed!

Since “SAP Crystal Dashboard Design” is so long, it is bound to become abbreviated. However, I doubt this will be shortened to “SCDD” since a Google search points you to the “California State Council on Development Disabilities” .  It is more likely to become “Dashboard Design” since that is the new descriptive product name.  A Google search on “Dashboard Design” comes up with about 2.5 million results starting off with Qlikview, followed by Tableau Software then Corda and SAP Crystal Dashboard Design comes in at about number 14.  Interestingly, there is little ambiguity when you search on “Xcelsius”.

Translating Dashboard Design into other languages may also prove interesting.  Xcelsius will always translate into Xcelsius in all languages and I have a feeling the name will persist. At the end of the day, it is not just the name that counts, it’s the product itself. Xcelsius is as unique as a product as it is as a name. I will never forget that day in 2005 when I first saw it and was totally blown away. Infommersion created something truly amazing and ahead of its time. It remains top of its class and, for me, Xcelsius will always be Xcelsius.

Winners of 2010 Best Xcelsius Dashboard Awards Announced at IBIS 2010

By
Paul
Published: June 14, 2010Posted in: Blog Featured, Business Intelligence, IBISTags: , , , ,
Winners of 2010 Best Xcelsius Dashboard Awards Announced at IBIS 2010

As Xcelsius becomes more widely used and more mature, the level of complexity and creativity in its usage in Business Intelligence applications appears to grow exponentially.  This was the third year of InfoSol’s Best Xcelsius Dashboard Awards and there was no shortage of great dashboards on display at IBIS 2010 at the Ritz Carlton, Laguna Niguel, California.

IBIS 2010 Winners

Most Valuable Dashboard SPX Service Solutions Detroit, MI
Most Innovative Dashboard United Educators Washington, DC
Best Business Dashboard Aluchemie Rotterdam, Netherlands
Most Xcellent Dashboard ARI Mt. Laurel, NJ

 

SPX wins Most Valuable Dashboard

This year’s winner of the Most Valuable Dashboard was SPX Service Solutions who developed a series of complex dashboards to provide on-line interactive views of Global Strategic Customers and Line of Business P&L’s for company executives and financial managers. The data was retrieved from an SAP BW (Business Warehouse) and delivered comparisons and analysis never previously available.  The number of possible comparisons and drill-downs is huge and created some real challenges for the BI/BW team at SPX in terms of the amount of data to be retrieved. However, SPX overcame the data quantity and performance hurdles by using InfoBurst XDS with its Intelligent Caching.

The Most Innovative Dashboard Award is for the dashboard that is designed and developed in an innovative way or for an innovative solution.  United Educators, who provide insurance to educational institutions, needed a solution to enable their clients to Self-Serve and Leverage Policy Data to make informed decisions.  The United Educators dashboard application was certainly an innovative solution with its peer selection function that retained anonymity of the institutions being compared. Also, the design using selection /de-selection of multiple peer groups and write-back to prevent users “gaining” the system was unique and creative.

Best Business Dashboard won by Aluchemie

The Best Business Dashboard was awarded to Aluchemie, a manufacturer of anodes needed for the electrolysis process by which aluminum is extracted from ore, based in Rotterdam in the Netherlands. They were looking for a way to get Team Leaders, Production Managers and Executives excited about the roll out of their Manufacturing Execution System software, used to manage and monitor work-in-process on the factory floor. Xcelsius was the answer and they created a comprehensive set of options in a multi-tab dashboard with more than 120 different dynamic graphs showing trend analysis along with shift-by-shift and day-by-day comparisons of key production line metrics. The dashboard revolutionized their manufacturing reporting and brought to light critical production issues that could be seen clearly for the first time.  As one Team Leader put it, he felt like they were finally, “coming out of the Stone Age”.

ARI receives Most Xcellent Dashboard Award - IBIS 2010

Last but not least, the Most Xcellent Xcelsius Dashboard was won by ARI, an international fleet Vehicle Leasing and Management Company.   ARI already had the ability to compare and analyze key life cycle metrics of any vehicles through their existing customer portal but they wanted to make it more visually dynamic and add even more useful functionality. They used Xcelsius to create a visually intuitive interface with picture icons, dynamic sliders and a lot of pizzazz.

ARI’s Dashboard Prototype was shown at a key trade show and received rave reviews.

Representatives of the winning companies received their prestigious glass pyramid awards and also participated in a customer panel to explain how their dashboards were conceived and how their respective businesses are benefitting from them.  In addition, three of the winners also presented insightful case studies on their dashboards.

Bursting Xcelsius Dashboards

By
Paul
Published: June 6, 2010Posted in: Blog Featured, InfoBurst, Infoburst 2009Tags: , , , ,
Bursting Xcelsius Dashboards

A company recently approached us with an interesting requirement concerning how to more efficiently distribute information about mobile phone usage to each of their hundreds of customers. The method they were currently using was manual and labor intensive as they were pulling information into Excel spreadsheets, creating graphs and then cutting and pasting into PowerPoint presentations that were emailed to their Account Managers who would present them to the various customers.

They had seen Xcelsius dashboards and were impressed by the dynamic visualization and felt this could make both an attractive and appealing way to present the information to their clients. However, they were faced with several challenges regarding automatically populating the dashboards initially and then automatically distributing them as standalone offline entities that could be used by both their Account Managers and clients without being connected back to the originating system.

They did not want to run separate jobs for each client to populate each dashboard. They wanted to run one job that would provide all the statistics for all customers and then split or burst that data by customer to feed each customer’s unique data into the same dashboard template. The amount of data that would be initially retrieved was large (many tens of thousands of rows) and even some of the individual customer dashboards had a fair amount of data (several thousand rows). Once the data had been burst for each customer it would need to be populated into the dashboard template, published as a shockwave file (SWF) and attached to an email that would need to be sent to the right group of people for each dashboard.

While this may seem like a tall order, the new InfoBurst 2009 solution was able to achieve all this relatively simply and quickly. InfoBurst 2009 is a scheduling, bursting and publishing solution for both Business Intelligence reports and dashboards . It has a built-in scheduler that can be either time or event based triggered. The event can be the result of a SQL statement which makes it very versatile for starting a job only when data has changed or other dependent events have occurred. InfoBurst can accept data from SQL, a Stored Procedure or a Business Intelligence query or report (Web Intelligence, Crystal, Desktop Intelligence, Microsoft Reporting Services etc.).

When handling Xcelsius dashboards, InfoBurst 2009 uses unique mechanisms for both ‘OFFLINE’ and ‘CONNECTED’ distribution requirements.

 For a ‘CONNECTED’ scenario, the Cache can be accessed from the Xcelsius dashboard in a variety of ways so that only the data required for a particular component of the dashboard is retrieved when required. We provide a number of components that we collectively call ‘INTELLIGENT CACHE’. The CACHE QUERY mechanism in InfoBurst 2009 allows you to use the full power and capability of SQL to selectively retrieve, aggregate and sort the data required for your Xcelsius dashboard from the Cache. The CROSSTAB mechanism allows you to generate crosstab tables in advance or on-demand. The FLIP mechanism allows you to PIVOT an existing Crosstab, switching the X and Y axis data. These features save an enormous amount of time and effort over other methods of pulling data into an Xcelsius dashboard and it’s fast! For ultimate flexibility, it is possible to have multiple caches and to populate a cache with data from multiple data sources.

 For an ‘OFFLINE’ scenario, InfoBurst 2009 is able to create and manage separate ranges within the Cache, and Burst these ranges to a common Dashboard, embedding the data inside of the SWF file and delivering the same Xcelsius dashboard with different data for each individual client.

InfoBurst 2009 also has intelligent distribution capabilities where it can read from an LDAP compliant address book, a database table or an Excel spreadsheet to select the relevant email addresses or target destinations for the dashboard or report. Since this customer required the offline dashboards to be sent via email , the information was read from a database table containing all the individual’s information and is able to determine the customer name and criteria and select just the email address for the relevant recipients.

This company is now using InfoBurst 2009 to distribute offline Xcelsius dashboards automatically , intelligently and swiftly to its customers and is saving a lot of time and money in the process.

For more information or a free demonstration and trial on InfoBurst 2009, go to www.InfoBurst2009.com

Sustainability and Sizzle at Sapphire – Day 1

By
Paul
Published: May 23, 2010Posted in: Blog Featured, Paul Blogs on BI, Roambi, SapphirenowTags:
Sustainability and Sizzle at Sapphire – Day 1

For a humble BusinessObjects follower used to attending conferences where 3,000 attendees was considered big, stepping into my first SAP Sapphire event was somewhat like the small town guy going to the city for the first time.  With some 15,000 attendees, an exhibit and keynote area the size of half a dozen football fields and “no expense spared” technology on display everywhere, it was quite an experience. At times it felt like being at a baseball game with line ups for food, bathrooms and big projection screens showing live events in progress everywhere.

The incredible number of sessions , demos , exhibits and collaboration meetings means you can only participate in a fraction of what is available and you need to be quite discriminating – it’s a bit like going to Disneyworld and, in fact, I think by the second day a lot of people did wander off there!

The keynotes on the first day were impressive starting with an interview style session with Sir Richard Branson, the founder of the Virgin Empire. He provided some excellent insights into the success of Virgin explaining how employees who are proud of the company they work for will more likely be passionate about their jobs.  Branson also stressed the importance of reducing carbon emissions and talked about the new “carbon currency” and how they were working on new “clean” fuels projects producing fuels that will not harm the environment.

This aptly led into the second keynote from Al Gore who talked eloquently and intelligently about the importance of the sustainability initiative that is becoming an integral component of companies and institutions around the world.  Gore emphasized the need to build consensus and the brand enhancement that many companies are gaining by going green and implementing sustainability initiatives.  SAP has made a commitment to reduce its carbon footprint by 50% over the coming years while still substantially growing the company.

SAP had set up a whole segment in the exhibit area dedicated to its Sustainability offerings. I sat in on one of the presentations and was impressed at how comprehensive and integrated it appeared to be. 

Paul Grill, Giant iPad and Santiago Becerra

With so much to see in the Exhibit area, I tended to gravitate at first to the booths that had the most traffic. Since everyone appeared to be raffling off an iPad (no shortage here!), there had to be something more appealing to draw people in. That was certainly the case at the Mellmo booth with their giant-sized iPhone and iPad displaying its Roambi solution with some amazingly visual Business Intelligence analytics. Since SAP has identified one of its three major initiatives for this year as being mobile integration and delivery, this was a hot topic at Sapphire and RoamBi was white hot.

The best presentations I attended were the customer case studies and there was a great one in the Small and Medium Enterprise track where 3 customers were interviewed about the business benefits realized after implementing SAP Business Intelligence solutions.  One of the customers was an on-line supermarket chain and he explained how implementing BusinessObjects with a Data Mart allowed them to see that they were receiving a large number of complaints about their egg deliveries – mainly that some of the eggs were cracked or damaged. Their BusinessObjects solution allowed them to drill down on this data on a daily basis and analyze further what might be the potential causes. They subsequently discovered that there were a much larger number of complaints with eggs delivered in cardboard cartons compared to plastic cartons so they switched to plastic cartons only. In addition they implemented a simple new procedure for the packer to quickly visually check the eggs in the carton prior to packaging. The result of these two actions was a 75% reduction in complaints of egg deliveries.

I love these type of stories because it so clearly shows that Business Intelligence is a combination of analyzing data and human interpretation and action on the results.

All in all, it was a “cracking” first day at Sapphire!

Europe Trip 2010: Day 7 Switzerland – Finding a Common Language

By
Paul
Published: April 19, 2010Posted in: Blog Featured, Europe Trip 2010, Paul Blogs on BITags:
Europe Trip 2010: Day 7 Switzerland – Finding a Common Language

Although Switzerland is a relatively small country, there are four distinctive cultures speaking four different languages within its borders. There are French, German, Italian and Rumantsch regions all speaking their respective languages.

This leads to some interesting situations as I discovered when meeting with perspective partners there. The first partner was primarily based in the French region and most of their clients were also based in the French region whereas the second partner was from the German region as were most of their clients. Even more fascinating was that the French Swiss prefer not to speak German to the German Swiss and vice versa even though they learned the respective languages growing up. Ironically they often end up speaking to each other in English which is not a native language to either of them!

When I enquired about the Italian region of Switzerland, I was referred to another partner that is Swiss Italian based!

In the world of Business Intelligence, we find a similar situation with the different vendors’ product suites. BusinessObjects, Cognos, Oracle and Microsoft BI all have their native tools that communicate very differently and there is no easy way to dialog between them.

In many customer situations that is changing as the demand and desire to use multiple vendor tools has become a necessity for many businesses.  The common dialog in this case is the portal or the main application where the user first logs in.  The most common portals I encounter are either the homegrown kind or Microsoft’s SharePoint. Through this portal, it is possible to seamlessly connect with different applications and different vendors Business Intelligence tools. Reports, dashboards and ad-hoc queries can all be accessed and viewed as if they were coming from the same application. Utilizing single sign-on also makes it possible to transparently pass authentication credentials to the various applications and tools without the user having to tediously log on to multiple systems and applications.

I end up discussing with my perspective Swiss partners how many corporations in North America are using mixed Business Intelligence tools through portals like SharePoint and how key solutions like Web Intelligence, Xcelsius and InfoBurst integrate easily.

As I head to Geneva airport, I spot a chocolate store and have to go in to browse and inhale the smell of heaven (I have a weak spot for chocolate). As I float through the store in my element, I cannot help wondering that while the Swiss may speak different languages, they have their chocolate as their portal to universal communication!

Welcome to the New and Improved InfoSol Blog

By
Yolande
Published: November 3, 2009Posted in: Blog Featured, Business Intelligence, InfoSolTags: ,
Welcome to the New and Improved InfoSol Blog

Our hope is to share with you some of our passion for Business Intelligence.  If you would like to contribute content, please contact Yolande by email her at ygrill@infosol.com

Posts from our original blog have been moved here and we tried to preserve the date/time stamp for continuity.  The ratings and comments have been lost.

We welcome your comments and suggestions.

InfoSol Green Services

By
Paul
Published: November 3, 2009Posted in: Blog Featured, Business Intelligence, InfoSolTags: , ,
InfoSol Green Services

InfoSol’s GreenServices is an innovative offering of remote Business Intelligence consulting and training services that save the environment while saving you money. InfoSol offers a comprehensive set of Business Intelligence consulting and education services that can be performed remotely, without the need for you or us to fly, drive, or spend hours in transit—saving you time and money while also helping to save the planet by reducing carbon emissions.

For more information visit http://www.infosol.com/buildpage.aspx?k=greenServices

Analytics Plugin created by Jake Ruston's Wordpress Plugins - Powered by Paiste Cymbals and Paramedic to RN Bridge Programs.