InfoSol Archive

IBIS 2010 Surfs and Serves Some Cool BI

By
Paul
Published: June 28, 2010Posted in: Blog Featured, IBIS, Paul Blogs on BITags: , , , , , , , , , ,
IBIS 2010 Surfs and Serves Some Cool BI

Hands-on immersion training can be tough but when your classroom looks out on to the Pacific Ocean of Southern California and during the breaks you can walk out on to the balcony and watch surfers riding the waves, it’s not so bad.

IBIS 2010 Beach view

This year’s InfoSol Business Intelligence Seminar (IBIS) was just packed with high quality and in-depth boot camps and seminars covering Xcelsius, Web Intelligence, Crystal Reports, Data Services, BO XI 3.1 Administration and lots more. It was also located at the beautiful Ritz Carlton, Dana Point on a bluff overlooking the Pacific Ocean which was the perfect remedy after a day of absorbing tons of knowledge.

The Welcome reception on Sunday night, entitled “Seeing Beyond Business Intelligence” was set in the Solutions Showcase area where sponsors demonstrated and discussed some of their latest business intelligence solutions.  I delivered the keynote the following morning on the same “Seeing Beyond” theme and highlighted some interesting business intelligence customer case studies.  The keynote on the Tuesday from Santiago Becerra, CEO of Mellmo, was quite fascinating as he took the audience through “the Evolution of Think” and cleverly demonstrated how putting fun into regular tasks can change people’s habits as well as their adoption of solutions. Showing Roambi, the latest business intelligence solution for the iPad, really brought the point home well.

The 2010 Best Xcelsius Awards demonstrated how far many companies have come in applying Xcelsius in very complex and powerful applications and inspired many others to go even further so I would watch out for next year’s awards.

I had the opportunity to meet with many people during the event and dive into some great discussions on both existing challenges in various BI implementations as well as future directions. In general, it appeared that most companies lag about 3 to 5 years behind the latest releases of SAP BusinessObjects and other BI solutions. Occasionally there is some critical new functionality that will compel a company to adopt a new release sooner but that tends to be the exception to the rule.  Many customers expressed that having reliability, stability and consistent performance are more important than most new functionality. Some of the newer solutions like Xcelsius dashboards and Roambi mobile business intelligence appear to circumnavigate this pattern since they can often be deployed and highly effective outside of the main business intelligence and production applications. A further big factor here is cost as many companies are more hesitant, due in part to the recent global recession, to spend large amounts of time and money on new software until they have conclusively proven a solid return on investment. For this reason incremental software purchases and pilot projects have become very popular in the BI space.

This was evident at IBIS as customers expressed a lot of interest in Xcelsius, XDM, Roambi, XWIS, GMaps, 360View, Version Manager and SAP BO EDGE solutions for very specific business issues and needs.

All in all, IBIS 2010 was a great BI gathering and information exchange and continues to grow in popularity. A couple of lucky attendees won iPads and a couple of not-so-lucky attendees dropped their phones in the ocean, but judging by the feedback everyone can’t wait to do it again.

Here are a few of the comments received back on IBIS 2010 :

“The IBIS conference was terrific this year.  I can’t wait to incorporate write-backs into our dashboards, and InfoBurst 2009 with dashboard bursting opens new doors for delivering customer information.  I also really enjoyed Aluchemie’s customer demo with all of their challenges they had to overcome!”

Kim Marshall, Waldinger Corporation

“I wanted to commend you and your team on the wonderful seminar.  My colleagues are very enthusiastic about their boot camp and the knowledgeable instructors they have met. You and your team have been wonderful throughout the past few days and everyone’s terrific attitudes have made the seminar a great success”

Melinda Dennis, Aluchemie

 

When asked, “What was the best part of the seminar for you?”, here are some of the responses :

“User Panel – excellent recognition of organizations with creative solutions”

“The class time. The first time I have ever been to a seminar where I was asked right from the beginning to reverse engineer an example”

“ The chance to talk and network with pros, find out what SAP doesn’t tell you about the product and get the best practices from people who have been in the trenches”

“…invaluable talking with other companies and knowledge sharing”

“… the workshops were excellent and very exercise intense so there was no boredom factor”

“Meeting with other users of the tools – It is a great way to get new ideas”

“The tips on real life best practices were extremely valuable – something that you cannot always get from other conferences”

“Size of the event led to good instruction and interaction”

“The training far surpasses any other training in the BI field. InfoSol has created a habitat for intensive training efforts at an economical price”

“The fact that I am learning things that are actually going to help me solve current problems – which also helps me sleep better at night”

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!

Europe Trip 2010: Day 6 Snowboarding Lessons

By
Paul
Published: April 18, 2010Posted in: Business Intelligence, Europe Trip 2010, InfoSol, Paul Blogs on BITags:
Europe Trip 2010: Day 6 Snowboarding Lessons

After my previous disastrous attempts to ski when I visited my son last year, he suggested I try snowboarding. When I told him I had heard it was more difficult than skiing, he just shrugged and said that I couldn’t do any worse. I figured he had a point and agreed to give it a shot.

After spending 20 minutes putting on all the protective equipment and some bright purple pants that my son insisted were an essential part of any serious snowboarder’s attire, we headed for the slopes where he showed me how to strap my boots to the snowboard.  The next part was significantly more challenging, namely how to stand up when attached to your board. After scores of failed attempts that amused the groups of youngsters watching to no end, my son finally showed me that if I rolled on my belly and then pushed myself up while facing up the mountain, I could actually stand up without immediately falling over again! Of course, this made me look like a beached whale, but it did work!

My first run down the slope was not very graceful and ended with a spectacular head first crash into the snow.  On my second run I collided with my son who bravely tried to slow me down and paid the price as I simultaneously wiped us both out.

The third and forth runs were not actually bad as I completed a couple of 50 yard runs at some speed. Amazingly, I survived my first ever 90 minutes of snowboarding with no broken bones or serious bruises but I was so exhausted from all the falls and attempts to stand up, that I could barely move a muscle.

As we sat and ate lunch, my son explained that I did better on a snowboard than I did on skis because my feet were locked in a position on the board and I could not move them like I can with skis.

Sometimes when there are less options or steps involved, we tend to master them quicker.  The same is true in Business Intelligence. If you give a user a Universe or View with access to hundreds of objects in different databases and a tool like Web Intelligence for self-service query and analysis, they will usually struggle to create any type of useful report, get themselves tied up in knots and become frustrated to the point of blaming the tool and not wanting to use it again.

If, on the other hand, you create a small specialized universe or view for a user with just a few relevant objects and a pre-made report that with which they can start, they have less options and directions to choose and they can master the tool a lot easier. They can still add, delete, modify, sort, filter and save in different formats but they are working from an already created report and do not have an overwhelming number of choices to select.

While many Business Intelligence tools have become more powerful, feature-rich and versatile, most users just want information delivered in a simple, easy-to-understand way and do not want to spend time learning products and becoming experts in tools that they may not use that often.

InfoSol has developed many self-service business intelligence solutions using Web Intelligence, Xcelsius Dashboards and InfoBurst and applying best practices to allow users to get immediate benefit from them without weeks of training and usage.

Now, not everyone wants to be a casual user and those individuals should take more advanced training.  But, for the novice snowboarders like me, just standing, staying up and gliding for 50 yards is great!

Europe Trip 2010: Day 5 The French Alps – Social Networking in the Snow

By
Paul
Published: April 13, 2010Posted in: Europe Trip 2010, InfoSol, Paul Blogs on BITags:
Europe Trip 2010: Day 5 The French Alps – Social Networking in the Snow

A weekend in the middle of my trip gives me the opportunity to visit my son who works and snowboards in the French Alps for six months of the year.

He has to work on the Saturday so he sets me up in an Italian restaurant /pub with WiFi so I can catch up on a week of being out of the office. So for four hours, I diligently work away as various interesting characters come in and out – mainly to use the bathroom but sometimes for food or a drink.

At about 6 pm, I hear a lot of noise outside in the street; a combination of shouting and honking car horns.  Then suddenly, this man with his pants around his ankles and wearing a thong and a tiger mask bursts into the restaurant shouting in English with a strong French accent, “I am not John Lennon, I am John Lion!”

He continued to repeat this mantra multiple times as people either stood there smiling or made a quick exit in the opposite direction. Since the people in the bar (the smiling ones) offered him a drink and patted him on the back, I figured that this was not an uncommon occurrence.  A few minutes later my son shows up to tell me that it was this guy’s birthday and that before he came into the restaurant, he had run into his shop minus the thong!

When my son finished work, we went to a different restaurant for dinner which also had free WiFi for customers and since I still had my computer, my son wanted to show me a couple of things on Facebook.  We ended up on my Facebook page where I had very little written on my wall so I decided to post a message saying, “Visiting my son in the French Alps and watching naked Frenchmen running around in the streets”.

Now I only have about 15 friends on Facebook who can see my messages but within minutes I had 7 or 8 responses to my posting in addition to several requests to become my friend!

In this tiny little example, I had learned firsthand the power and effectiveness of social networking and viral messaging on the internet. No wonder so many businesses are shifting their sales, marketing and collaboration focus to this medium.

It is no longer sufficient just to have a nice looking web site to promote your business or interact with your customers and prospects. Without an internet social networking presence  through Blogs, Forums, Twitter, YouTube, LinkedIn, Plaxo, Facebook and others, many businesses and institutions are simply missing out on marketing, sales, technical, cost savings, recruitment and collaboration (just to name a few) opportunities .

There is no other medium in the world today where information can be disseminated to so many people so quickly.

So get ready to see a lot more from InfoSol in the social networking arena in the coming weeks and months but that will not include video clips of naked Frenchmen running around in the Alps.

Related links: InfoBurst 2009 YouTube channel and 9 ways to use social networking for blog promotion

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

Xcelerate Your Xcelsius Xcellence with Dynamic Dashboard Development Services from InfoSol

By
Yolande
Published: April 10, 2009Posted in: Business Intelligence, InfoSol, XcelsiusTags:

With more than a dozen Xcelsius Black Belt specialists on staff, InfoSol provides a complete range of Dashboard development, deployment and support services including:

  • Proof-of-Concept Services
    Building and delivering Xcelsius dashboard solutions in your environment to demonstrate the value prior to a full deployment
  • Dashboard Design and Planning Services
    Assistance in designing and planning effective dashboard solutions
  • Dashboard Solution Development Services
    Developing complete dashboard applications, including connectivity, distribution, refresh and security
  • Dashboard Knowledge Transfer Services
    You drive, we navigate, as we work along side you to show you how to develop and maintain effective dashboard solutions
  • Dashboard Education
    As a Business Objects Authorized Education Partner, we offer a complete range of scheduled,
    on-site and e-learning offerings on BusinessObjects Dashboard solutions

Visit our company website at www.infosol.com

Other blog posts on Xcelsius Dashboards

« Older Entries

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