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

Thursday, July 15, 2010

BI Education - Post-Graduation in BI

The current Business Intelligence (BI) post-graduation degree at Universidade Portucalense (UPT) is near the end, and the next edition, as is typical in a well-organized institution like UPT, is already being prepared. According to the students, the current and first edition is being a success, which gives more motivation and enthusiasm for the entire teaching staff to continue the work and achieve the high expectations of the people who normally enroll in such courses.

I was again invited to take the course of BI, which made me very honored and proud and with a sense of accomplishment. There is always something to improve and innovate, and the next edition will be no exception. In terms of innovation will be my priority update all my modules and the used tools, and especially keep students of the 1st edition "tied" to the university for sharing knowledge among all, inviting them to attend some classes, workshops and mainly to present the final project done in the current edition. The following image show the general structure of my modules aligned with all the post graduation degree:

With the aim of bringing academia to the "real world", were created partnerships with large national and international companies with recognition in the area of BI. Among them are Microsoft, Primavera and Devscope as GOLD partners, and Microstrategy, Novabase, Critical Software, Informatica, PHC and Oracle as SILVER partners. My thanks to various partners for this partnership, even in the current crisis, providing the next edition students, with high quality workshops, BI books and awards for the best students.

A special thanks to students from the current edition for all their interest, dedication, kindness and friendship. I’m sure that for all their qualities their future is very promising. Personally, I see this graduation as only a training opportunity for sharing knowledge with students about this fantastic world of Business Intelligence and for which I am truly passionate.
Registrations are now open!

Wednesday, July 7, 2010

BI Thoughts – Writing on BlogNotions about BI

After Karen's (BlogNotions) invitation, today I’m starting a new adventure… writing about BI more often at the Business Intelligence BlogNotions website.

"BlogNotions Business Intelligence Blog delivers a diverse series of perspectives provided by BI thought leaders. Presented by NetLine, this forum delivers compelling updates on the latest technologies in the marketplace, discussions of competitive decision making, new ideas for analyzing data, and much more. Here you can find helpful information, ask questions, and collaborate freely"

This first post is dedicated to the Business Intelligence concept and for that reason, I should refer my main reference in this world: Drª Maria José Trigueiros.

I hope you read it and also enjoy it.
Check it here
Give feedback and let me improve with your experience and knowledge.
Regards,
Pedro

Tuesday, June 29, 2010

BI Article - Writing about BI in a Magazine

Today I accomplish one more important step in my professional evolution. Together with Drª Filomena Lopes (IT Director of Universidade Portucalense) I wrote an article for a Portuguese magazine about Business Intelligence. Naturally, this article is more interesting for Portuguese people than those that don’t have Portuguese as a mother or second language. But for those that don’t understand Portuguese don’t worry, because I was invited to write some stuff about BI in a english website... I’ll tell you more about it during this week.

Article published last week on "Semana Informatica" magazine.

I hope you enjoy this article.
Regards,
Pedro

Wednesday, June 23, 2010

BI Green - I Love You Earth


We are living in exceptional times. Scientists tell us that we have 10 years to change the way we live, avert the depletion of natural resources and the catastrophic evolution of the Earth's climate.

The stakes are high for us and our children. Everyone should take part in the effort, and HOME has been conceived to take a message of mobilization out to every human being.

For this purpose, HOME needs to be free. A patron, the PPR Group, made this possible. EuropaCorp, the distributor, also pledged not to make any profit because Home is a non-profit film.

HOME has been made for you: share it! And act for the planet. You can find this amazing documentary on YouTube in several languages, even up in Portuguese. Take some time on this and see how our home is right now

Start today the change of your lifestyle… follow this Mind-Map:

HOME official website
http://www.home-2009.com

Saturday, June 19, 2010

BI Interview – Donald Farmer BI Perspective

Today I want to share an amazing interview done by my friend Ella Maschiach’s with the “father” of Microsoft Business Intelligence… Mr. Donald Farmer. He’s responsible for the new amazing Microsoft products like Power Pivot and Sharepoint 2010. You can’t miss this interview. Ella… why do you not follow a career also as a journalist?
ehehhehehehehe

Part I


Part II

Check the entire post in Ella’s blog here
I hope you enjoy it.

Wednesday, June 16, 2010

BI Dissertation – MSIAD

Today I finally publish the presentation of my master BI dissertation, that I defended last year. I do it to share my perspective and experience with you, but mainly because I know that it was one thing that the teacher Maria Jose Trigueiros would want to see, if she was with us. For that reason, I’m also writing an article about this dissertation with my advisor, the teacher Drº Orlando Belo, in order to submit it internationally.


For now the presentation is in Portuguese, but I can easily translate it to English if I get some requests to do it. Unlike most of the master's students, I do not hide my dissertation and I share it with pleasure. I hope it could be helpful to you at least, to get some ideas.
Regards.

Wednesday, June 2, 2010

BI Blog - Three Years Blogging - Thank You!


Starts to be a routine add a post to commemorate the anniversary of this blog. :-) It’s a project created 3 years ago with great passion and dedication, and therefore remains alive for this long time. This is the place where I described some of my many stories, tips, news and even some personal moments/events.

For those who thought three years ago that the blog was more like a joke, today maybe are surprised. It has over 100 posts on various subjects related to Business Intelligence… But I do not cross my arms and I'm already preparing something to further improve this blog, not only in design but also related to the content. The promised remote BI sessions mentioned in a previous post, will really start soon…

Naturally these three years of life are due also to the thousands of visitors who passed through this blog, from the simple readers, to those who placed questions or requested some opinions/feedback. I know that many of those visitors have yet unanswered questions due to my immense workload during the last year… nevertheless I’ll try to answer soon.

A special thank to a person that is the huge driver of BI in Portugal and is undoubtedly my main reference… the teacher Maria José Trigueiros. She’s not physically with us anymore, but for sure, she’s seeing what we are doing here.

Some numbers...

Want to receive an alert via e-mail about new posts?
Add your email address in the box at the right side menu

Want to have alerts about new messages and/or posts?
Follow the links from RSS feeds in the right side menu

Want to share an experience? A tip? Some news?
I could give you permission to create your own blog in BIResort community or you could write a post here as a guest in section BI Guest Corner

This place will continue to be a meeting point for all those persons that have the same passion as me for Business Intelligence. Some more technical post’s continue to be published on BIResort community that I’m co-founder.

THANK YOU ALL
Pedro

LinkWithin

Related Posts Plugin for WordPress, Blogger...