BI Conference - SQL Bits & Tech-Ed Europe 2009

Just to let you all know that some interesting events are coming… and the dates for the two events that I’m currently writing are... next November 2009.

SQLBits (19-21 November 2009)

Thursday 19th Pre-conference Training Day

Friday 20th SQL 2008 & R2 Conference Day

Saturday 21st Free Community Conference

“This is the biggest event yet, with 3 days of top quality SQL Server content. It starts with the pre-conference training day on Thursday 19th, more details coming soon. We have had a lot of feedback about weekday versus weekend during previous events so this time we have added a paid conference day on the Friday 20th, with a SQL 2008 and R2 theme. Finally we have the free Saturday community day, with speakers from around the world covering all manner of SQL Server topics.” By SQLBits

Tech-Ed 2009 Europe/Berlin (9-13 November 2009)

Business Intelligence Track

“Now more than ever, your business needs a quick means of getting the right information to the right people so that they can make smarter, more informed decisions. Microsoft’s Business Intelligence solutions enable you to do just this. The Business Intelligence track offers sessions covering how to integrate, analyse, and report on all of your corporate data easily using the Microsoft Business Intelligence platform, end-user tools, and analytics applications. Learn how to build custom, robust Business Intelligence solutions using Microsoft® SQL Server® 2005 and 2008 (Integration Services, Analysis Services, and Reporting Services), Microsoft® Office PerformancePoint™ Server 2007 (Monitoring, Analysis, and Planning) and the 2007 Microsoft® Office system (Microsoft® Office Excel®, Excel Services, and Microsoft® Office SharePoint® Server technologies) and how to easily manage them” by Microsoft

I’ll try to be in the both events. If you are thinking to attend one of these events, let me know to organize the trip or to meet you there!

TDWI - The importance of BI Standards

As you have noticed from previous posts, I appreciate a lot all the work that is being doing by TDWI ... not only for their great organization but also for its importance in the creation of standards that everyone can follow and speak the same "language". As I have already said earlier, I am currently preparing for the global certification of TDWI Business Intelligence in Germany ... when I feel prepared I take a flight and go to Germany and make the exams… of course with my princess because Business Intelligence only makes sense to me with the unconditional support of my princess Joana.

But not moving too much from the main reason of this post, I want to share with you some interesting posters from TDWI that you should print. Attention… follow this mind map or other posters from TDWI but not be a fundamentalist… you don’t need to follow all this approaches in details, because each project is different and the requirements as well.

TDWI's BI Usability poster visualizes all the elements that contribute to making a BI solution "usable." The mind map clusters the attributes into four categories, each of which has multiple branches that support related attributes. The four categories of usability are: Change Management, Architecture, Support and Analysis/Design.

The poster also depicts the dynamics of BI growth and decline using a model from systems theory. The model shows that usability is one of several key leverage points that BI managers can use to alter systems dynamics and move a program from a negative reinforcing loop to a positive one.

Request your free copy

Also take a look to other posters from TDWI:

Master Data Management

Business Intelligence Maturity Model

Regards,

Pedro

Two Years Blogging - Thank you!

Passed two years and two months and this blog is still alive! The tendency is always to grow following my ambition and motivation on Business Intelligence area. Thanks to my familly, to my fantastic girlfriend that always supported me, and to all the persons that directly or indirectly stimulated and keeping the blog alive with comments and suggestions.

My option to write this blog in English, following Google analytics dashboard, confirm that it was a fantastic decision, because most visitors are coming from outside Portugal

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

Thank you!

BI Future - Microsoft Surface Demos

The post today is not much to write ... images and videos of the attached links, speak for themselves ... is a future increasingly close to the present that I want to have the pleasure of being alive to watch it! Microsoft Surface ... really promises because is a tool that will make the difference in the near future ... today, is still quite expensive to have the opportunity to try this tool, but I’ll be waiting to watch it in the first seat.

Watch the following videos ... the previous is obligatory... do not lose the opportunity to see what awaits us...

In leisure...


In the Ellit Model Management... and in a bookstore object recognition...


In patient consultation... and in Super Bowl security...

The future promisses...

BI News - Data Mining for Terrorists Is Urged

I found an interesting article that I want to share with you about Data Mining.

The article was Published at "The New York Times" on October 7, 2008 by Eric Lichtblau

WASHINGTON — "A federal panel of policy makers and scientific experts urged a government-wide evaluation Tuesday of programs that sift through databases looking for clues on terrorism, to determine whether the programs are effective and legal. The federal government has made aggressive use of so-called data-mining tools since the attacks of Sept. 11, 2001, as counterterrorism officials in many intelligence agencies have sought to analyze records on travel habits, calling patterns, e-mail use, financial transactions and other data to pinpoint possible terrorist activity.

The National Security Agency’s program for wiretapping terror suspects without warrants, the screening of suspicious airline passengers and the Pentagon’s ill-fated Total Information Awareness program, shut down by Congress in 2003 because of privacy concerns, have all relied on aspects of data mining.

But in a 352-page government study released on Tuesday, a committee of the National Research Council warned that successfully using these tools to deter terrorism “will be extremely difficult to achieve” because of legal, technological and logistical problems. It said a haphazard approach to using such tools threatened both Americans’ privacy rights and the country’s legitimate national security needs.

Mining through data patterns has been shown to work in commercial settings to predict what kind of toothpaste people may buy and what kind of movie they are likely to rent, or to detect casino card-counters or those engaged in credit card fraud.

But there is little evidence to confirm that the techniques work to actually find terrorists, despite the growing use in the last seven years, committee members said. Part of the problem, they said, is that the sample of known terrorists and actual attacks is so small that it is difficult to establish patterns of suspicious behavior.

The push to accumulate enormous amounts of information has also produced the risk of “a huge number of false leads” that could implicate people with no actual connections to terrorism, the committee said.

“More data does not mean better data,” said William J. Perry, the former defense secretary who was co-chairman of the panel, with Charles M. Vest, president of the National Academy of Engineering. "

Read entire article here

BI Conference - Tech Ed 2009, SQL Server 2008 R2

Last year Microsoft shared information about Kilimanjaro at the company’s second annual Business Intelligence Conference, which kicked off on October 6 in Seattle. Kilimanjaro is set to include self-service analysis tools (codenamed “Gemini”) that Microsoft is saying will allow information workers to better “slice and dice data and create their own BI (business intelligence) applications and assets to share and collaborate on from within the familiar, everyday Microsoft Office productivity tools they already use.”

But last week at TechEd 2009 conferences, Microsoft announced SQL Server 2008 R2, which you might recall as previous code of Kilimanjaro. What? You thought Kilimanjaro was SQL Server 2010? Well, if you Google it, you'll see that many others think the same, and in fact there are announcements from very significant sources over the last few months talking about SQL Server 2010. So the information now is that there is no SQL Server 2010. "Never was." That the BI and self-service tools that were part of the release were actually the R2 release. That "Kilimanjaro" always referred to R2. The next full release of SQL Server will follow the R2 release by about 24-36 months. You can expect to see full release of R2 in the first half of next year - CTPs should follow later this year for testing.

I understand that Microsoft, like any company has to adapt its strategy when the world is currently in a big financial problem. In my opinion, Microsoft will be easier to convince customers to upgrade a SQL 2008 to SQL 2008 R2 than convince SQL 2008 to SQL 2010... well ... but starting to be many products, many names, many service packs, many cumulative packages, many functionalities ... truly begin to create confusion in people, that usually have great difficulty accept the change. I hope at least, that Microsoft does not change the format and design of the next version of Excel which is expected to have many more capabilities than Excel 2007. We shall see ... I am very curious about the improvements on the analytical tools and on the "Master Data Services"

Also, their advertising video is pretty funny (the introduction part). You can also sign up to receive notifications of the CTP. You can see it here:

http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
Regards, Pedro

BI Resort - The BI Community

Finally I will present to my friends and to all those anonymous people that visit my blog, the BIResort comunity. I’m one of the founders of a BI community here in my beautiful country, Portugal! The community has the name of BI Resort, and we all wish to be a place to share knowledge, experiences and organize events about BI.

The founding members of this community work in Microsoft's partner companies, but could be many other professionals with an interest in "this world". The first step is taken, and we hope to have all your support to make this initiative a success. For my part, I promise to be present here for long… I have this blog for two years and have not lost my breath in this long journey.

If you feel curious to know something more about the Business Intelligence ... If you feel you can help someone to solve theoretical or practical problems ... if you had an experience in this area that could be shared... If you think it could be interesting bring to Portugal some communicators in this area ... if you think you can help make this world better ... then participate in this community. The doors are open to all! As we progressed, more details on objectives in the short, medium and long term will be shared with you.

For those who can create a blog in this community, contact me. It'll be an honor! I'll be waiting for your visit, not only here in my blog, but also in the www.BIResort.net

From Portugal to the rest of the world through this BI comunity!

For a better world!

OFF-TOPIC - Britains Got Talent 2009 - Susan Boyle

I rarely put posts out of context here, but I think Susan Boyle deserves a moment in this blog. Susan has 47 years, is unemployed and wants to be a professional singer... Watch the video and then see my first comment about it...

BI Guest Corner – BI Becomes Military Intelligence

Today, I will start a new type of posts… and I’ll call it BI Guest Corner.

I will publish articles directly from visitors of “our blog”. Feel free to send me an article or some subject do you think that will be interesting and related with Business Intelligence… For example if you are currently attending a Master BI Degree or if you are involved in an interesting project, why you don’t share with us your experience? Feel free… this blog is for you and for the people that has passion on this… I'm proud that this blog receive about 80 different visitors per day... Thanks for your attention!

This article was written by Katie Wilson and I really love this article… Thanks Katie!

BI has been used for a while now in helping corporations collect, analyze and make sense of their vast amounts of data so that they’re able to make more informed decisions that benefit their organization. It’s time for a change of arena though, and the tools of business intelligence are being used intelligently by the U.S. Department of Defense to help track and monitor injured military personnel who are transported for medical care to various places around the world depending on their locations.

The ongoing wars in Iraq and Afghanistan have fueled the necessity for such a system, which is why the U.S. Transportation Command has sought the services of Information Builders’ WebFocus business intelligence tools. The Transcom Regulating and Command and Control Evacuation System (Trac2es) allows the monitoring of military personnel who need medical attention while they’re in transit so that the necessary arrangements can be made for them when they reach the location of the medical facility. This allows for more effective and personalized treatment depending on the condition of each wounded or sick man.

The system includes tools for decision support, reporting and analysis, and when information regarding location and medical needs are fed in, it facilitates medical and military personnel to make better and more informed decisions. This will enable patients to receive the best medical care in the shortest possible time.

The system also allows the tracking of military personnel who have not been injured in the line of duty but who need medical attention anyway and are able to take commercial flights to get to the location of the medical facility.

The goal of the system is to improve the treatment that the injured receive and to keep the military high command informed about their condition. Besides this, it also helps improve planning for the future so that mistakes can be eliminated and patient care made more effective.

Trac2es is a multi-user system that is used by around 2,500 personnel including doctors, nurses, medical clerks and military leaders.

This post was contributed by Katie Wilson, who writes about the accreditation for online universities. She welcomes your feedback at KatieWilson06 at gmail.com

BI Conference - Self-Service BI with Rafal

Finally I found some time to describe the session that Rafal, following Microsoft invitation, held here in Portugal. As I already wrote in previous posts, Rafal in their specialty is the best in the world. A simple and objective way to show the concepts of Business Intelligence reconciled with several practical demonstrations are fantastic. Of course I attend these moments with great intensity, because they contribute, not only to continue learning, but also to mark and remember these moments. I will describe, in my opinion, the more relevant key points of the presentation.

The first point was approaching the concept of BI as a tool for self-service, where users are rewarded by a high level of autonomy for their daily needs for information.

The second point was the interesting and comical suggestion to be followed by consultants, when they want to sell their Data Warehousing solutions... they should not try to sell a Data Warehouse, but try to sell KPI's... this advise should be follow because the managers do not understand much of these technologies and are more attracted by KPI for making a mapping between their business and technology

The third point was the OLAP off-line functionality, which although this functionality already exists since Excel 2003, only now is beginning to gain more strength with the increasing importance that Excel is having nowadays. (These offline/Local cubes can be browsed by most OLAP client tools)

The fourth point is on the increasing quality of data mining Microsoft products. The feeling is that there is still a little more to move on this matter to “fight” against some competitors such as SAS (Enterprise Miner)... But it promises ... and in my BI thesis I'll show until where

The fifth and final point to highlight is the explanation of the strategy for Microsoft Performance Point Server product... especially on the discontinuation of the Planning module and the inclusion of the monitoring module through SharePoint product... soon will be called the Performance SharePoint Services.

I hope you have left with the feeling of having been present

Regards,
Pedro