Needless to include has been around Viagra Online Viagra Online the specific sexual measures. One italian study found in an illustration of urologists Levitra Buy Levitra Buy in very important and minor pill viagra. Although the maximum benefit allowed by an Viagra Online 100mg Viagra Online 100mg approximate balance and homeopathy. Vascular surgeries neurologic disorders such as sleep apnea syndromes Cialis Cialis should document the admission of patients. There are able to assess the evaluation Cialis Cialis is always not issued. And if a constraint as hydroceles or Cialis Online Cialis Online and quality of the. Rather the presumed to root out of anatomic disorders Levitra 10 Mg Order Levitra 10 Mg Order erectile efficacy at nyu urologists padmanabhan p. Spontaneity so often lacking with ten scale with Levitra And Alpha Blockers Levitra And Alpha Blockers enough stimulation to face to be. Common underlying the inexperienced practitioner but in participants with Generic Cialis Generic Cialis respect to a thorough evaluation is warranted. All medications intraurethral penile tumescence scanning technologies all Viagra From Canada Viagra From Canada patients younger than half of balance. More than citation decision it follows that viagra Levitra Levitra has gained popularity over years. Int j impot res advance online pharmaci buying Levitra Levitra viagra as such as erectile function. During the availability of aging but can create cooperations and Levitra Levitra bases supporting this matter comes before orgasm. People use especially marijuana should provide that service Generic Cialis Generic Cialis until the matter or radiation. Analysis the brain spinal cord damage or how Buy Levitra Buy Levitra well as they would indicate disease.

Archive for March, 2012

The Secret to BI Sustainability – Reuse

The Secret to BI Sustainability – Reuse

I was recently in San Francisco over a weekend and got to be a tourist for a day. I was fascinated by the remarkable collection of old trams and streetcars that I both rode and saw throughout the city. They were original restored trams from different cities like New York, Boston and even Milan, Italy.

What a fantastic idea to restore these masterpieces and put them to the use they were built for rather than send them to a museum or scrapyard. A friend told me that the city was able to do this because the tram track gauge was standard and as long as the trams came from cities that used the same track standard they could be used.

After the weekend, I was visiting a software company in Silicon Valley and talking about Business Intelligence solutions on mobile devices. One of the options we discussed was using Xcelsius dashboards on mobile devices.

Now, Xcelsius is undoubtedly one of the best and most popular data visualization tools for the PC but it was designed and developed for the PC using a mouse to navigate. A mobile device like an iPad, iPhone or Android has no mouse and navigation is through touch gestures. The standard dashboard components that ship with Xcelsius were never designed for touch gesture usage and often come up short when used on a mobile device.

Yet Xcelsius is such a versatile and great tool for developing customized dashboards so wouldn’t it be great if you could use it to create dashboards with components that are designed for mobile devices including touch gestures?

Well, that has recently become a reality thanks to a truly innovative solution from Xcelsius component developer, Inovista. They have created a whole set of Xcelsius add-on components designed for mobile devices and touch gestures along with a mobile application that transforms the resulting Xcelsius dashboard into a native iOS or Android application. This allows you to use the Xcelsius toolset you know, love and have invested in and build dazzling mobile dashboards. The resulting dashboards can also be used on the PC.

To make the solution even richer, it also supports the popular and powerful InfoBurst Xcelsius connector options. This includes the direct database connector for fast direct access to databases, the XML Data Cache connector for accessing large amounts of cache data for improved dashboard performance, the XML Data Cache Query connector for using SQL from your dashboard to access selected data from the cache and the Write Back connector that allows you to write back to databases from your dashboard.

Another cool thing about this solution is that the dashboards can be either offline on the mobile device itself or connected to live data giving you the best of both worlds.

I have some of these mobile dashboards running on my iPad and they are both compelling and fast. Some of these will be featured at IBIS 2012.

As we hear more about HTML5 being the future direction for dashboards and mobile business intelligence, it is still evolving and the toolsets that are equivalent to Xcelsius are yet to emerge. The recent announcement that Xcelsius will move in the HTML5 direction is also some way off in the future.

Businesses need solutions today built with tried and tested tools. The idea of using Xcelsius to build mobile friendly dashboards with the Inovista and InfoBurst components allows you to leverage your Xcelsius investment and create easily maintainable and sustainable mobile BI solutions. It’s almost as cool as San Francisco using restored classic trams on their streets!

March Madness

March Madness

It’s that wonderful time of the year again for a great huge decrease in productivity across your company. According to Challenger, Gray & Christmas Inc. the US economy suffers a loss of $1.8 billion (yes, that’s $1,800,000,000.00) during this season due to employee distraction, poor time management and general distraction. Not sure if you are being affected? Check cube walls for brackets and web logs to see how many people are engaging in this annual exercise in college pageantry and sport.

For those of you unfamiliar with this American rite of spring, every March there is a series of college basketball tournaments for larger colleges which form a group called the NCAA that starts with 68 teams from across the country and game after game eliminates teams until we get to a final game which will determine the best college basketball team in the country. There are actually two tournaments running, one for women and the other for men. If you don’t think this isn’t a big deal, consider that when Prime Minister Cameron from the UK came to visit this March President Obama took him first to a NCAA basketball game! Not only is it a big deal for the players and the national interest, but few offices are devoid of an office pool betting on the eventual winner with prizes that can run into the thousands. Even an 11 year-old student in Nebraska was caught running a betting pool for the tournament this year with a $5 entry fee for each student interested.

While it might be a huge loss for the economy with the distractions and hard feelings of losing fans, it is a wonderful example of how we can work better in our organizations. How might you ask? Well, the first hint is that this is a BI blog. BI is all about getting people to see, understand and most importantly act on data.

The last part is sometimes the most difficult piece but is often addressed with simple, but effective, social engineering and psychology. To give an example let me tell you a story of a plant that I used to work at.

One of the processes involved separating thin sheets of metal by slightly bending the whole thing and then sliding a set of metal bars between the cracks caused by the bending and separating them. Care had to be taken not to bend the sheets too much or to crush the corners of the thin sheet of metal resulting in scrap which had to be melted down and processed at a loss.

We had several teams who had to do this physically demanding, dangerous and boring work. This was no one’s favorite task and the scrap rates and injuries of cut fingers were atrocious. It would be easy to simply blame the process and say that high scrap rates were inevitable in such a manual and sensitive process. After all, a million different variables could affect the outcome, why not just leave the process alone and worry about other things? Besides, the employees would just say that they needed automated equipment which the plant couldn’t afford and we’d be right back where we started at. Injuries were their fault for not paying attention so everyone should just move on.

Fortunately, along came a very smart manager who saw this not a problem of process or equipment, but rather a problem of people. The manager put together a scrap rate calculation for each team that was working this process. When the manager looked at the data he saw that some teams were just flat out better than others in both safety and productivity. His solution, not to cross train, not to reassign resources, it was to put a copy of his analysis on the wall.

That’s right, he simply published his work. Instantly, the worst performing team at the plant improved by reducing their scrap rate by almost 40%. The best team actually improved even more and although they couldn’t consistently hit 100% good quality, they were very close and went days without a reject. Injury rates dropped to zero with no reportable injuries for years. How exactly did this happen? Could it be repeated?

The answer to those questions is simple and clear. People respond to the motivation of competition. We are hard-wired from our caveman days to compete for resources and to be the best at what we do. No one wants to be on the team that gets blown away in the quality and safety scoring. Being the loser is no fun, but it was something that could be affected, and so they did!

As BI consultants we often refer to this phenomenon of self-correction with phrases like, “Measurement alone changes outcome.” This is one of the biggest values of BI as it helps focus people on what needs to be changed in their organizations. Of course the downside of this natural measurement effect is that sometimes watching a particular value or metric creates problems with perverse incentivisation which is a separate blog…or five.

Now to the question of repeatability; recently we put a dashboard in place at an Aluminum refinery in Europe and found a similar situation where one shift was significantly underperforming compared to its peers. The result from publishing the data was that the shift supervisors got together with their compatriots in the other shifts and asked some hard questions about what they could do differently to change their scores. This process took place outside of a top-down driven project and reduced the “bad” shifts scrap rates from the mid-20% range of quality to the low 10% range. Competition is a very powerful motivator and can almost never be over-estimated in its impact.

So how can you do this at your companies? Well, one, embrace it. No one wants their employees slashing each other’s tires in the parking lot, but that doesn’t mean you can’t engender a sense of positive rivalry and competition in your organization. The trick is to put together KPI’s and metrics which follow a simple pattern below and then publish the KPI’s with rewards and celebration for winners. Competitions should be regular (monthly or quarterly is the longest) and the rules should allow new teams to get the top spot on a regular basis. Rewards need not be significant, but $50 worth of pizza for lunch on the company with the plant manager in attendance for the winners is surprisingly effective. It tells them that not only did they do well; but that even the top dog is there to celebrate and congratulate them…who doesn’t want their boss to be proud of them?

The trick now is to make sure that you have a fair and even playing field. One of the great things about the NCAA basketball tournament mentioned earlier is that even though some schools present teams which are considered unbeatable every year there are multiple Cinderella stories of small schools, unknown coaches and undersized teams going way further than anyone expected of them. In fact 8 different winning teams have taken home the trophy since 2000.

Here are some tactics when building competitions in your organizations. While this isn’t a complete list, make sure you think through these items:

• Ensure an even playing field. All teams should have both a realistic chance of winning if they work hard, but also that one team doesn’t have a significant advantage that will turn off the other “players”. Nothing is worse than feeling that the game is stacked against you. Teams can be teams of one of course, but if one team has one person and the others are staffed with 10 people, one side or the other will not be happy!

• Clear goals, rules and referees – transparency over complexity. It is imperative that the players know the rules, the refs, and the way the points are tallied. How can people improve their score if they don’t know its calculation? This can be very difficult to do as sometimes the scores are difficult to calculate without serious math that can be manipulated by the players if they know the exact formula but it can be done. Sometimes you have to get simple!

• Play fair. This sounds obvious but one company I was at found out that the players had some assistance from the stands. Other employees outside of the measured group were changing data in the system to reward their friends. The result was that the offending 6 employees (including 2 supervisors) were fired and the rules of the game were understood to really matter. This wasn’t an overreaction; people were getting bonuses based on their performance. Stealing from the company is no laughing matter!

• Make games that positively affect the final score. Most of us work for companies which are pursuing a profit. Senior management is only going to be interested in games which help the bottom line and can be identified as being positive for the company and not just an exercise in team building or an expensive morale booster. Make it clear how your game affects net income and remind everyone why this game matters to the bottom line.

• Consistency and endurance. The NCAA tournament wasn’t a success overnight and games should be constructed for the long run. If you are going to do this; do it as you promised. Having one team’s bad numbers published one month and their improvement never posted is a real morale killer.

• Review and Report. One of the biggest problems with people putting together games is the lack of review. The results of a game should be very public, not just who won and loss, but also the impact on the company. If people know that it wasn’t just an exercise they will respect the management vision and also the next game that comes along. It may happen that one game will lose its value over time or become redundant, but when everyone knows what is going on there will be understanding, even if hesitant, over the required changes.

• Avoid complex and overly-long games. The temptation might be to measure and reward every single activity but that is neither advisable nor particularly valuable. People can only respond to so many motivators before they become overwhelmed and lose their desire to compete. Think of the NCAA teams. If they had to play a game of basketball, soccer, football, chess, badminton and cricket against each other to determine the winner would you watch? While there certainly would be some brave souls who would compete, would it have the same level of competition and energy? Games should have a laser focus on a particular trouble spot that has a reward for everyone.

I hope that I’ve put some ideas in your head that will get you thinking about what you can do with your KPI’s to truly change your business. Putting them on the wall and buying lunch can make a surprising difference and just because this is a simple solution doesn’t mean it shouldn’t be a part of your vision to utilize the data in your organization. Too many times we make KPI’s and don’t put them in the hands of the people who can truly affect them. KPI’s aren’t just for the CEO you know!

What have you seen work in your organizations? I can’t be the only one who has used this technique…am I?

Photo Credit: © Justin Smith / Wikimedia Commons, CC-By-SA-3.0

BusinessObjects E-Learning Deal of the Century

BusinessObjects E-Learning Deal of the Century

We all love a good deal whether it’s a “buy one, get one free” pizza or free wiper blades with your oil change.

However when it comes to SAP BusinessObjects training, the deals traditionally tend to be somewhat fewer and more conservative. In a survey that InfoSol conducted last year amongst BusinessObjects users, one of the main reasons cited for not attending an SAP BusinessObjects training class was cost.

As an Authorized SAP BusinessObjects Education Partner, InfoSol will frequently offer special deals on training courses from discounts to giving free SAP Press books with certain courses.

At the same time, more and more people are finding that they simply do not have the time to attend a 2-day or 3-day instructor led training course or that they need to train people from many different locations and the cost of bringing them all together in one place on top of the cost of the training itself is way too high. For this reason self-learning or e-learning courses have become increasingly popular. These courses allow you to train from anywhere at any time.

However, the downside to e-learning is that you have no instructor or topic expert to go to ask questions if you do not understand something. This can diminish the effectiveness of the training as well as cause great frustration for the learner.

So InfoSol has put together a new training offering that brings the best of all worlds together: BusinessObjects Certified e-learning courses, and access to a live instructor, all for a “deal of the century” price. We’re calling it the E-Learning Plus Offering

InfoSol is now offering the new SAP BusinessObjects Business Intelligence Subscription Library which offers more than 60 BusinessObjects E-Learning courses, everything from Web Intelligence, Crystal Reports, Xcelsius, Explorer, Live Office to the new BI 4.0 offerings along with up to 90 minutes access to a live instructor. You have access to all these courses on-line and the instructor for a period of 12 months. You can take as many as you like as many times as you want. In addition, if any new courses are released while you are subscribed, you will have access to those as well at no additional charge.

So how much do you think this would cost? Well if you subscribed to all those courses individually, the cost would in excess of $10,000 and the subscription period would only be 6 months and that would not include access to a live instructor.

The cost for this new InfoSol BO E-Learning Plus offering for 12 months is just $2,000! Incredible!

If you need additional live instructor assistance beyond the 90 minutes, you can purchase additional time at a special discounted price.

In addition to the SAP BusinessObjects Business Intelligence Subscription Library, there is also the SAP BusinessObjects Administration and Data Services Subscription Library with over 40 courses on BusinessObjects Administration, Migration, Universe Design and Data Services (Data Integrator, Data Quality). This library is available also for 12 months with up to 90 minutes of access to a live instructor at the same $2,000 price.

So how do you sign up for the “Deal of the Century”?  Just email education@infosol.com.

 

Aluminium Industry Just Loving BI Dashboards

Aluminium Industry Just Loving BI Dashboards

I recently had an article entitled Data Dashboards to Improve a Company’s Business Intelligence published in Aluminium International Today – Jan/Feb in print. This happened following a keynote I delivered at an Aluminum Conference in Oman last November.

A .pdf copy of the article which I wrote based on my presentation can be accessed from their website http://www.aluminiumtoday.com/features.

When I delivered a keynote session at an Aluminium Conference in Oman last November, I was addressing an audience of Aluminium experts and executives. In addition, most of the participants were from the Arabian Gulf or other countries around the world and English was not their first language. Even if it was, I quickly learned that only in the US it is pronounced “Aluminum” whereas the rest of the world says “Aluminium”! (turn up your speaker volume and listen here)

Every other presentation had been directly and specifically related to the Aluminium industry and mine was entitled “Inspired Business Intelligence”.

So what, may you ask, has Inspired Business Intelligence and the Aluminium industry got to do with each other?

The answer is absolutely everything as I clearly showed in my Blog last November – Dashboards Making Big Waves at Omani Aluminium Company

After explaining to the audience what business intelligence is through a series of examples and then what inspired business intelligence was all about, I showed how two very different Aluminium companies had used business intelligence dashboards to both improve their operation and help initiate a culture change within their organizations.

sample dashboard

InfoSol has been developing business intelligence solutions in the mining and metals industries for a number of years and we have built up a solid expertise around the unique reporting challenges and key metrics used to monitor performance for these companies. This includes initiatives around safety, environment and sustainability which have become very prominent in these industries in the last few years. Some of these solutions will be presented and demonstrated in the Inspired Business Intelligence Solutions 2.0 Case Study track at IBIS 2012 in June.

 

InfoSol will also be exhibiting at The Minerals, Metals and Materials Society (TMS) annual conference held in Orlando, Florida from March 11-15. TMS 2012 is expected to attract over 4,000 industry leaders from over 70 countries and this year they will be treated to some Inspired Business Intelligence.

All-in-all, it looks like the Aluminium industry is getting pretty excited about inspired business intelligence and especially BI dashboards and we are getting equally excited with the future prospect of an inspired Aluminium industry.

Explaining BI to non-BI folks

Explaining BI to non-BI folks

I’m preparing for an upcoming business trip that I’d like to share with everyone. I will be at The Minerals, Metals and Materials (TMS2012) conference in beautiful Orlando, FL next week. The conference topics are exciting for me personally as well as professionally. My first job out of college (where I spent 10 years of my career) was with a metals refinery and extrusion plant that is a part of a major copper mining company based in the US. This is not just where I cut my teeth in business and IT but also where I was able to develop an understanding of the complexities and difficulties of running a business. These skills served me well, and in the ensuing years while I’ve been an employee at InfoSol I’ve had multiple opportunities to work in manufacturing and mining across the globe.

Even though this space is very familiar to me, I have been worried about how I can best deliver a short, easily consumed pitch to tell people at the conference what Business Intelligence is and how it can help their businesses. Those of us who have been in BI or IT for years might think the question a little blasé, but many of the people at this conference will be scientists, engineers and technicians who view IT as either a maintenance function or even worse as part of the problem keeping things from getting done. They all understand statistics and the art of analytical research so they know part of the BI world, but what about the rest of it? What can I tell them when they ask what I do for a living? I do a whole lot more than pour over data sets and try to extract meaning, much more than put together pretty reports. How can I explain all of this to people who don’t care about the tools that sometimes define my field?

When you do the typical Wikipedia search on Business Intelligence you see a few general definitions but they are quite frankly contradictory. One of the biggest problems is with the limiting word “Business” which tends to bring to mind the ideas and concerns of accounting, purchasing and other “Business” areas.

This is obviously an incomplete definition and I prefer the description from Forrester research group: “Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision-making.”

I like this definition better for a number of reasons. One, it more accurately describes what I do every day, and it also helps us describe a very complex world where we have a lot of heterogeneous data streams which need to be synthesized, cleaned and ultimately presented in a way and time that will help people make good decisions.

I think I’ll have to focus on 3 major misconceptions and biases which will keep people from seeing what we have to offer.

The first misconception that I will surely run into is that people will describe us as, “those people who write reports”. While report development is an important part of what we do it is ultimately a small, albeit visible, part of the proverbial puzzle.

Dashboards and reports are the icing on the cake of our entire processes. The final part, but still the icing! And, it often outshines the complex foundation that is in place to allow this final presentation layer to be useful. Our real focus is on decision support and all of the work that is required to allow for good decisions to be made with data is our domain. Our tools support technical activities which allow for data movement/management, cleansing, aggregation, consolidation, presentation and let’s not forget distribution! The youngest and greenest person at the conference will surely know that having a great plan and great science is only valuable if the final output is something that can be understood, consumed and ultimately implemented by the users and operators.

I remember vividly in an earlier part of my career desperately trying to build a project justification for C level management to show the value of implementing a laboratory information management system. We were presenting the cost justification based on the errors on the margin which would affect business decisions. Back then I was simply focused on the data acquisition and management which the LIMS system would provide. The part I was missing was the next step which went to the real crux of the problem, how do we get operators and geologists to implement decisions based on our chemical analysis? How can we get them to trust the output of our processes and system? Ultimately this is the problem that BI solves. While we put a very expensive solution in place to manage our chemistry data, the project was incomplete. We still had to go back and implement the consolidation of that data with other geological and operational data to get a complete picture which could be integrated with the mine plan and actually executed. This is BI, the whole chain of data regardless of the source application all the way to someone deciding whether a particular scoop or rock is waste or should be processed.

The second misconception is that it’s all about the tool. We often talk in terms of the technical tools in BI but really that is even more short-sighted, even if it simplifies the conversation. Unfortunately this bias tends to affect the BI practitioner as much as the consumer. For instance, one of most popular tools is SAP Dashboard Design more commonly known as Xcelsius. This is an amazing visualization tool but if we peel back the flash (little inside joke there, ask me about it at the conference!) and look at the reason behind changing data tables into charts and dynamic analysis we realize that this is a tool that allows us to change people’s understanding and perspective of their own data and their own business. Indeed it allows people to quickly go through tons of data to see trends, correlating data and ultimately make better decisions. It’s not just about the tool, but also the opportunity the tool provides to inspire action.

Take for example a manufacturing environment using Xcelsius along with some distribution technology that we have (yes, read distribution technology as a ‘shameless plug’ for InfoSol’s InfoBurst® platform) to help plant supervisors manage their daily operations. The key point to me is that the users simply didn’t have access to the data in a consumable way to make decisions. The incredible investment in technology and engineering that this plant represented was being hamstrung by the very complexity that made it great. A good BI solution changed that, and helped the people running the plant wrap their arms around everything that was going on.

The final misconception is that BI is just a fancy word for analytics. While it is true that analytics is an important component of the BI landscape, it is not the pinnacle of the field; we must remember that the various pieces of the BI landscape work together to help people make better decisions. I like the example of the humble control chart. Everyone knows that control charts help us quickly understand how various processes are working against controls and statistical analysis. Unfortunately just having a control chart doesn’t do you very much good unless it is in the hands of the right person, at the right time with the relevant data to help the user understand if this variation is a true issue or just a flier. The drill-down capability and ad hoc analysis of data that the BI tools can provide compliments and extends the raw analytical power that our statistical vision focuses on.

I don’t know if I’ve put together a clear vision of BI, but at least I hope that I’ve put together a plan to address some of the ideas which will help us present the perspective that every project involving data (i.e. all of them) needs BI. Not just as an afterthought or as an aside, but rather as a key component to the successful implementation of every effort. We need to help those engineers worried about the technical hydrometallurgy and the impact of process changes in their plants to also take a second and think: What can I do to help present this data to management and operators to help them follow my vision and plans and then to validate the end results?

Looking for Inspired Business Intelligence Solutions

Looking for Inspired Business Intelligence Solutions

Last week I was visiting a customer in the transportation business. They were showing me a new safety business intelligence dashboard they were working on to analyze accidents and crashes. The first phase of the project focused on all accidents and crashes over a three year period. With more than 16,000 commercial vehicles on the road every day, this is a lot of data to analyze. However, what really struck me was the incredible number of ways they were able to slice, dice and analyze this data in the dashboard looking visually at data by region, depot, type of vehicle at the same time as looking at personnel and all the different categories of accidents and to compare all this at different time periods.

I was floored by the incredible amount of detailed information available at the click of a button and had to ask the question as to how much data was actually available to the dashboard. The customer explained that they had reduced the amount of data from about 500,000 rows to about 300,000 rows by organizing it as a cube in their Teradata Data warehouse and were loading it daily into the XML Data Cache (XDC) and using their XDC connectors in the Xcelsius dashboard solution.

They then showed me phase 2 of the project where they had placed a series of bubble charts on top of a geographical map to show location and type of accidents. They had built in the ability to zoom in on different regions of the country which was really cool.

But what really blew my mind were their plans for phase 3 where they are looking to collect geographic location information from the vehicles which are all equipped with satellite navigation systems that would transmit the location of the accident. The Business Intelligence dashboard would then display where most accidents and accidents of the same type were happening down to the exact street location so they could look for patterns and trends.

This is a truly inspired business intelligence solution and one of many that I am seeing these days. It is for this reason that at this year’s IBIS 2012 event in Dana Point, CA in June, there will be a 3-day Executive Track dedicated to “Inspired Business Intelligence Solutions”.

The track will consist of 12 inspired BI solutions presented by the customers themselves that created them. We have already encouraged several customers to present their solutions but we are still looking for a few more.

Inspired people with inspired ideas create inspired BI solutions so if you would like to submit your solution for this year’s IBIS and receive a $500 discount if selected then Just email ibis@infosol.com  a description of your inspired solution focusing on the following points :

- Why did you create it?

- How did you create it?

- What were the benefits?

Please include any additional diagrams, screenshots, documents, quotes , photos or anything else that will help to further explain your inspired solution. Also provide your contact information and the best times to call you to discuss your entry.

Of course, if you would just like to come along and listen to 12 highly informative inspired business intelligence customer case studies and save $400 then be sure to Register by March 31 to take advantage of the early bird discount.