Business Intelligence Archive

Camels in Oman

Camels in Oman

The drive from Dubai to the Omani coast takes you through deserts with sand dunes and mountains along roads with warning signs to watch out for camels. Sure enough, I did see camels just wandering around in the desert.

When I arrived at the client I was visiting that day in Oman, I had to wait in the security hut until someone came to pick me up. The security guard did not speak English but I tried to strike up a conversation anyway. I told him that I had seen camels on my drive there. I could see he did not understand the word camel so I took a pen and paper and drew a picture of a camel. As soon as he recognized what it was I was drawing, he jumped up in the air and shouted “Jamel” (hence I discovered the Arabic word for camel!).

He then grabbed his mobile phone and excitedly showed me pictures of himself with camels. I quickly determined that he owned eight camels and he named them all and from his expressions I realized they were a great source of joy to him. He spoke about them like they were his children and he had pictures where he was kissing and hugging them.

At my meeting, the client was explaining how they wanted to look at utility usage in addition to production line equipment usage over time. Although the production line itself was fully automated, the meter and machine readings were manually read and recorded. We discussed ways that the readings could be captured automatically and fed into a database and displayed and analyzed through a Business Intelligence dashboard. They were very excited about this but when I mentioned how much time this could save the supervisor in the morning since he would not have to collect the information manually any more, the supervisor spoke up. He explained that when he toured the factory floor each morning, he not only collected the meter readings but he spoke to the people on duty and found out if there were any issues or problems over the last 24 hours and gathered a lot of other useful information. He spoke fondly of this responsibility and his relationship with both the workers and the machinery. It actually reminded me of the way the security guard had spoken about his camels.

Interestingly, it was this very supervisor who was the main instigator behind the idea of bringing in business intelligence dashboards to the company. We agreed that there were plenty of other great benefits to automating the data collection into the dashboards without changing his daily factory floor tour. This was an inspired supervisor who loved his job and his company and clearly saw the importance of maintaining both the data analysis and the human action parts of their operation in harmony.

Taking advantage of technology while maintaining the essence of what makes an organization run smoothly creates intelligent and sustainable processes.

The next morning as I was leaving the hotel I saw three camels grazing on the manicured grass in front of the entrance. These are smart camels, I thought – taking advantage of man-made technology to sustain themselves!

Lessons in Building in Dubai

Lessons in Building in Dubai

While lining up in the passport control hall in Dubai for a couple of hours, I had time to watch the moving advertisements many times over. My impression was that this booming metropolis of the Middle East is like New York and Orlando meshed together with its combination of business and finance mixed with entertainment centers galore. I was not far off.

Driving down the main 14-lane highway through the center of the city with massive new skyscrapers on each side, I felt like I was in a scene from Disney’s movie Tron.  Outside of rush hours the traffic moves fast and you better keep up or you will end up in an accident. After 45 minutes of speeding through the concrete jungle, I find myself in the middle of desert which is where my first customer that I am visiting is located.

They are a large manufacturer who is planning to double their output capacity in the next two years.  They have big plans and moving fast which is par for the course in this part of the world but they also have a great need for business intelligence to track and analyze in order to make informed decisions. Today they are primarily tracking their strategic objectives and key performance indicators manually and reviewing them monthly with no real visibility on a daily or even weekly basis. Labor intensive manual dashboards are being created in Microsoft Word and printed on poster size charts that sit in managers’ offices.

While the need for automated and visual Business Intelligence using tools like Xcelsius may appear obvious, the main ERP and production applications are still being rolled out and have an even higher priority than BI. In addition, they have defined standards for which technology should be used for their future BI solutions.

After spending time listening to the Project Manager responsible for the current manual dashboards, I realize that the final BI solution will take time and it will need to be implemented step by step and synchronized with all the other projects in progress. To try to fast track the solution would be a mistake and probably lead to inaccurate results which in turn would result to its rejection and demise.

Replacing manual systems with slick BI solutions may lead to dazzling and cool looking visual interfaces but the foundation must be solid and the functionality that exists in the manual system must all be there.

Even in a place like Dubai where massive buildings seem to appear overnight, the foundation and design must be solid or they will all just come crumbling down.

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

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?

IBIS 2012 Announced: Inspired Business Intelligence 2.0

IBIS 2012 Announced: Inspired Business Intelligence 2.0

IBIS is well known for offering the most effective BusinessObjects learning available along with intelligent and inspirational ideas on how to maximize your Business Intelligence usage and investment.

IBIS 2012: INSPIRED BUSINESS INTELLIGENCE 2.0, June 10 – 13, 2012, has just been announced and offers an amazing selection of Hands-on Pre-Seminar Workshops, Immersion Training Boot Camps and Executive Seminars on the most popular and latest BusinessObjects solutions delivered by top BI specialists.

The seminar includes 3 full days of learning and peer experiences, and is packaged together to include 3 nights’ accommodations at the luxurious Laguna Cliffs Marriott Resort & Spa in Dana Point, CA. Along with group meals, resort fees and scheduled events, IBIS 2012 is an incredible value and the most important BusinessObjects event to attend this year.

We invite you to join us for INSPIRED BUSINESS INTELLIGENCE 2.0. Register by March 31 to take advantage of the early-bird $400 discount.

June 10 Pre-Seminar Workshops

• Advanced Report Bursting, Scheduling & Delivery Using InfoBurst (Hands On)

• Migration to BI 4.x (Hands On)

• Conversion of Desktop Intelligence to Web Intelligence (Hands On)

• Building Xcelsius Dashboards for Mobile (Hands On)

• InfoBurst Administration Certification (Hands On)

• How to Develop KPI’s

June 11 – 13 IBIS Main Conference

Hands-On Boot Camps

• Xcelsius Beginner Boot Camp

• Xcelsius Master Boot Camp

• XML Data Caching Boot Camp

• BI 4.0 Developer Boot Camp

• Web Intelligence Boot Camp

• BusinessObjects Administration Boot Camp

Executive Seminar Tracks

• Business Intelligence for Executives

• The Tao of Business Intelligence

• Inspired Business Intelligence 2.0

 For more details, view the IBIS 2012 Agenda.

Business Intelligence 2012 Predictions

Business Intelligence 2012 Predictions

While 2011 was a great year for Business Intelligence, I think that 2012 will be even greater as many new technologies that gained a foothold in 2011 become mainstream and even more exciting BI solutions emerge.

It is becoming more apparent than ever that the leading BI companies of four years ago (Business Objects, Cognos and Hyperion) having been taken over by bigger software application companies (SAP, IBM and Oracle) are losing their leadership position in BI innovation as most of their BI product development effort is focused inwardly to better integrate with their respective owners applications to take advantage of easier sales within their own customer base. They have almost become “legacy BI” solutions along with Microsoft who is quickly falling into the same category. As many industry analysts predicted at the time of these acquisitions, this has made room for new startup companies to fill the void left behind. So during these past few years , we have seen the meteoric rise of Apple with its mobile solutions, Saleforce with its phenomenal cloud based CRM application and Qliktech with its high speed, fast deployment BI solutions.

The BI landscape continues to change at an ever-accelerating pace and I am sure we will be looking at many new names, unheard of today, in a year’s time. In the meantime, here are my top 5 BI predictions for 2012 :

Prediction 1:  Mobile Business Intelligence will start to dominate over conventional business intelligence as companies will demand mobility as a compulsory feature. Mobile workforces will start to replace laptops with iPads (which will be the tablet of choice for businesses in 2012) as more useful and compelling BI solutions are developed for mobile devices. Companies like Mellmo, with Roambi (www.roambi.com), are already well positioned to take advantage of this trend but other strong competitors will emerge in the coming year as more BI dashboard solutions go mobile.

Prediction 2: Cloud based BI applications will propagate like wildfire and the race is on as to who, if anyone, will dominate this space. The question is do any of the BI vendors have the execution capability and the vision to do what Microsoft did to dominate the PC software business or Amazon did to dominate the on-line retail space – namely drop the price so low (or even free) to gain market share at the cost of profit? If not, watch out for iCloud or Google making a play for this huge BI opportunity.

Prediction 3: BI dashboards will continue to thrive but there will be more trend towards Operational BI rather than Strategic BI in 2012. As the capabilities for alerting, write back, connectivity to all types of applications (cloud, internet, on premise, mobile and machine interface) continue to expand, the possibilities and demand for operational BI with dashboard interfaces will too.

Prediction 4: “Big Data” wars will drive more demand for BI. With IBM leading the pack and SAP and Oracle not far behind, I predict a battle on an Exabyte scale as they and others compete as to who can analyze the most data in the fastest time and push it into meaningful BI solutions. The good news for businesses is that this will drive the price of BI tools down (as will the competition from Cloud and Mobile BI solutions).

Prediction 5: Business Intelligence for Web and Social Media content will be super-hot in 2012. The demand to perform BI against unstructured data sources from the web and use BI tools to analyze and visualize will go beyond conventional marketing applications and become an invaluable asset in all areas of business. (Of course, this was the prediction I did not score myself well on in 2011 so I want to go further out on the limb with it this year!).

So let’s see what happens. I am certainly pumped up and excited to see how BI will continue to evolve this year. It is a safe prediction to say that it will evolve for sure but it is usually the unpredictable direction that keeps us (especially me) on our toes. Enjoy the ride.

Looking Back on 2011 Predictions

Looking Back on 2011 Predictions

At the beginning of 2011, I made 5 predictions in terms of Business Intelligence trends for the year and I thought it would be interesting to look back on the year and see how those predictions turned out. So here goes :

Prediction 1: Visual Dashboards will remain dominant as the BI User Interface of choice. They will expand beyond their traditional tactical and strategic usage and be seen more in operational BI applications as backend performance with in memory analytics and caching continues to improve. Tools like Xcelsius will increase their presence due to both their visual appeal and ease of use.

Well Visual Dashboards did remain dominant and they certainly did expand into operational BI areas. We saw non-traditional BI functions like “write back” become more used. Xcelsius continued to grow in popularity and usage. I think I scored a 5 out of 5 on this one!

Prediction 2: Data Governance will be a priority as both large and mid-size companies are compelled to accurately consolidate and clean up their data for more relevant and precise business intelligence. Data quality, integration and master data management solutions will become mandatory in many organizations.

Data Governance was a priority with many large companies in 2011 but not so much with mid-size organizations as they tried to navigate a very unpredictable and bumpy economy. Data quality remained important but was still often pushed down the priority list in favor of meeting deliverable deadlines. I think I can only give myself a 2 out of 5 on this one.

Prediction 3: The race for optimal mobile business intelligence solutions will get into full swing. With a plethora of new tablet devices and new BI mobile software products, I anticipate a year of experimentation and we will need to wait another year before the real market leaders are determined. Watch out for Roambi (http://www.roambi.com/) because they are definitely heading in the right direction.

Mobile BI was a big topic in 2011 and a lot of new solutions appeared, both streaming and off-line based applications. Many companies did explore and experiment and some purchased and deployed. We saw many new tablet devices appear and almost as quickly disappear. Apple’s iPad remains the business tablet device of choice while Androids are becoming the most popular mobile smart phones. Roambi increased its presence globally and just released more amazing new views (Layers and Squares) and has become the BI mobile solution to beat. I score myself a 5 out of 5 on this one!

Prediction 4: Relational database Data Marts and Warehouses will continue to be the BI repository of choice in 2011. OLAP cubes will remain a niche market and the new in memory databases are just too immature and too expensive to have a serious impact this year. There will probably be lots of hype but until this new technology is affordable to the masses, it will have minimal effect. Data Mart projects will continue to thrive in the small to medium enterprise space.

Data Marts and Warehouses still remain the BI repository of choice although many companies are looking at a quicker method to deploy their ever-increasing demand for BI analytics. SAP spent a boat load of money, resources and hype promoting their new HANA in-memory analytics solution but there are very few running in live production. As the technology evolves and becomes more commodity that may change. I score 5 out of 5 on this one.

Prediction 5: Business Intelligence for Web and Social Media content will be hot and in demand. The need to perform BI against the predominantly unstructured data sources of the web has never been greater as more business and institutions both grow their web presence and web driven marketing. BI tools and solutions that can quickly analyze this data both quantitatively and qualitatively will see fast growth and adoption in 2011.

Using BI against Web and social media content has grown in 2011 but it has not been as hot as I was predicting. I have read several articles this year about success stories in this area but I have actually encountered very few first hand. The tools to analyze the unstructured content are good but are still relatively expensive and require a lot of services (more expensive). Maybe that will change in the next year or so. I can only score myself a 1 out of 5 for this one.

So my final grade is a 72% which according to my daughter in High School is only a “C”. Well I will have to do better than that so stand by for my 2012 BI predictions coming in the next few weeks.

Dashboards Making Big Waves at Omani Aluminium Company

Dashboards Making Big Waves at Omani Aluminium Company

Oman is known for its camel racing. It’s quite fascinating to watch as there are no jockeys – just a bunch of brave and skillful people to get the camels lined up and started and then the rest is up to the camels to gallop to the finish line. Watching them, they have this easy loping stride and they don’t appear to be going fast but they cover a lot of ground quickly.

The high speed ferry boats in Oman are very similar. Sitting at the front, you do not think you are going fast but if you go to the back of the boat and see the giant wake being left by the multiple powerful engines, you quickly realize you are moving faster than most speedboats.

So I find myself on this super fast ferry on my way to the port of Sohar in the North of Oman to visit the Sohar Aluminum Plant, one of the largest in the Gulf region. We are taken on a fascinating tour of the entire manufacturing process producing tons of aluminum ingots as its end product. The plant is only about three years old and is fully automated, efficient and clean.  It employs over a thousand people and boasts an impressive track record of productivity. The company puts safety first as its top priority and has not recorded a single injury in over 730 days – impressive. In addition, the company has put together a Corporate Social Responsibility program that both encourages input from the workers and gives back to the local community.

In the middle of the tour, one of the Sohar Aluminium supervisors is explaining the key metrics that their particular area is measured by and one of the other visitors makes a remark that management never really looks at that type of detail, they are just interested in the final production numbers. The supervisor immediately responds saying that is definitely not the case at Sohar Aluminium because they have a Business Intelligence dashboard that is viewed daily throughout the company by everybody which shows all their key performance indicators and how they are doing against their daily, weekly, monthly and annual goals.

Everybody in the organization is looking at the same data and they can see the metrics for other areas. This has created a remarkable culture change in the company as everyone has visibility to these metrics and realizes that their daily actions actually influence the numbers and values that they are seeing every day.  The fact that the dashboard is built in Xcelsius with visually compelling dynamic visibility features and is simple and intuitive to use has also played a big part in the successful user adoption.

Displaying the metrics was only a part of the Sohar Aluminium dashboard solution.  One of the biggest challenges facing the company was getting the shift supervisors and others responsible for the metrics to enter the actual values into the system in a timely fashion. They solved this problem by extending Xcelsius using InfoBurst to create a data input dashboard so the data can be entered through the dashboard itself. This dashboard not only displayed what metrics were missing but it also triggered an alert email that was sent to the supervisor if the data was not entered within 15 minutes of the end of the shift.  If the data had still not being entered within 30 minutes, then a second alert in red was sent to the supervisor again and the General Manager for that area was automatically copied.  This has been incredibly effective as the company has seen almost no late entries since the system was implemented earlier this year.

The dashboard is packed with many more innovative features and you can read about many of them in this PDF of the case study.

Sohar Aluminium was so happy about its KPI dashboard that they have continued to add to it and have even created an operational dashboard that takes direct feeds from temperature and wind speed gauges that are dynamically refreshed every minute. If the recommended thresholds are exceeded, which is not unusual since their plant is located in the Omani desert, then alerts flash up on the dashboard as well as sent directly to the relevant supervisor’s Blackberry phone to tell them to stop certain operations that would be unsafe.

So just like the racing camels and high speed ferry, Sohar Aluminium has covered a lot of distance in a very short period of time. Their initial dashboard solution was developed and operational in just four weeks.

When I presented this case study in a keynote at a conference this week sponsored by large Gulf Aluminium industry leaders, there was a lot of interest and I would not be surprised if, in the future, Oman will be as well known for its innovative dashboards as for its racing camels!