Wednesday, August 18, 2010

BI Guest Corner - Six Sigma Business Intelligence

Dear friends,
Today I have the honor to publish an article submitted by Alexis Bonari exclusively for this our blog. The subject purposed has been taking increasingly importance in the BI world… The benefits and challenges of six sigma certification in relation to BI is discussed below. Take five minutes and read it... is it worth reading:

Many educational institutions that teach Business Intelligence are taking on a new challenge: quantifying Business Intelligence quality. The most obvious way to quantify or define the quality of Business Intelligence is to create a marriage between the concepts that define Business Intelligence, and the popular Six Sigma Black Belt program.


Six Sigma strategies are defined by their adherence to a statistics-driven model.Six Sigma BI These models are designed to eliminate resource waste and streamline operational performance within a company. A marriage of Six Sigma statistical strategies with Business Intelligence principals would provide a mathematically based model for cost-effective Business Intelligence implementation. There are two main challenges inherent to applying the Six Sigma model to Business Intelligence.

1. How should the Business Intelligence product be defined?
Although much of the literature surrounding Business Intelligence relies upon terms and definitions that seem to defy strict quantification, data still represents the foundation upon which the definitions are based. Six Sigma techniques can be applied to this foundational data, thereby defining the Business Intelligence product.

2. How should we define the success of Business Intelligence?
The needs and desires of the client define the success of Business Intelligence. Therefore, quality can only be determined if the factors that clients care about are adequately identified. These factors generally include pre-defined industry standards such as performance, accuracy, clarity, availability of data, etc. Metrics can then be used to measure these factors.

A high quality Business Intelligence model will deliver these collated metrics to team members who are in the best possible position to act on them effectively. Six Sigma techniques are well positioned to judge how effectively the information is passed along. As more managers are trained in Six Sigma Business Intelligence, businesses will be better able to efficiently transfer data to the appropriate hands. By streamlining the processes employed in Business Intelligence strategies, companies will effectively reap many benefits that can be passed along to their customer base.

Bio: Alexis Bonari is a freelance writer and blog junkie. She often can be found blogging about general education issues as well as information on college scholarships. In her spare time, she enjoys square-foot gardening, swimming, and avoiding her laptop.

Monday, August 16, 2010

BI Conference - SQL Bits VII


Today I want to inform you about an amazing conference that will take place from September 30th to Saturday October 2nd in York (UK). It will be the 7th edition and for sure is an event that you could not miss. I don’t know yet if I’ll attend, but I’ll try! I attended two times in the past… check here and here to read my experiences at SQL Bits II Birmingham and SQL Bits III London

"Just as a reminder, SQLBits 7 will take place over three days from Thursday September 30th to Saturday October 2nd in York. Day one will be a training day, featuring in-depth full day seminars by leading SQL Server professionals such as Chris Testa-O’Neill and Chris Webb; day two will be a deep-dive conference day with advanced sessions delivered by the best speakers from the SQL Server community; and day three will be the traditional SQLBits community conference day, with a wide range of sessions covered all aspects of SQL Server at all levels of ability. There will be a charge to attend days one and two, but day three, Saturday October 2nd, will as usual be completely free to attend allowing everyone to attend and experience a great day of training even if they have no training budget"

If you think to register let me know.
Pedro

Wednesday, August 11, 2010

BI Article - Writing for Portuguese Microsoft KB

Recently I was invited by Microsoft to write to Portuguese Knowledge Base on SQL Server, more specifically in the Business Intelligence (BI) area. It was an honour and extra motivation for me, despite I’m being increasingly busier and with difficulty to contribute with my BI perspective in the various communities I am currently involved. This is also a challenge to test my capability for manage my time.


My articles on Microsoft's KB will follow a structure of "from theory to practice" in the BI area and they can be less or more detailed and addressing various issues on Data Warehousing, OLAP and Data Mining using tools such as Microsoft SQL Server R2, Excel 2010 , Power Pivot and Sharepoint 2010. This first article focuses on an approach that I typically use to design the date dimension. I hope this article is useful and also contribute for more complex approaches on date dimensions that you may need to implement on your BI System.

Take a look at my first KB article (KB2293691)
here and follow this link or press on the image below to download the files refered on the article!

If you want to know my perspective about BI concept, I suggest you to read my article on BlogNotions here

LinkWithin

Related Posts Plugin for WordPress, Blogger...