BI Tool – SQL Server 2012 Released to Manufacturing

Today… I have one more reason to write here… Microsoft announced that SQL Server 2012 has released to manufacturing. Now it’s your turn to download and evaluate this new amazing version. Relating to SSIS 2012 I’ll write more often about it just because I passed the last 6 months investigating it through the SSIS book that I’m finishing with my friend Reza rad. For now, I want to highlight the following new updates:

Microsoft SQL Server Data Tools
Business Intelligence Development Studio known as BIDS there will not exist anymore. Now, the name is Microsoft SQL Server Data Tools. Take a look here.
Download SQL Server Data Tools

Microsoft SQL Server 2012 Data Mining Add-ins for Office 2010
I thought Data Mining strategy had died, but has not yet! Fortunately Microsoft update the old Add-In to the new SQL 2012 and Excel 2010 versions. This package includes two add-ins for Microsoft Office Excel 2010 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2010 (Data Mining Templates)
Download Data Mining Add-In

Today, don’t forget to attend the SQL Server 2012 Virtual Launch Event, featuring keynotes by Ted Kummert and Quentin Clark and a number of video presentations about SQL Server 2012 by other SQL Server expert.

BI Tools - Cumulative Update #8 for SQL 2008 R2

Dear Friends,
Just to inform you that a new cumulative update was released today! If you use SQL 2008 R2 version don´t forget to update it with these new fixes.

Take a look a the full details here:
CU#8 KB Article: http://support.microsoft.com/kb/2534352

Previous Cumulative Update KB Articles:
CU#7 KB Article: http://support.microsoft.com/kb/2507770
CU#6 KB Article: http://support.microsoft.com/kb/2489376
CU#5 KB Article: http://support.microsoft.com/kb/2438347
CU#4 KB Article: http://support.microsoft.com/kb/2345451
CU#3 KB Article: http://support.microsoft.com/kb/2261464
CU#2 KB Article: http://support.microsoft.com/kb/2072493
CU#1 KB Article: http://support.microsoft.com/kb/981355

Follow all Microsoft SQL Server Release Services here:
http://blogs.msdn.com/b/sqlreleaseservices

BI Award – SQL BI MVP Award 2011

Yesterday, I received the email from Microsoft with MVP Award related for all my contribution in the last year. It’s an honor to be again in the restricted group of those persons that spend huge time in what they believe and has passionate.

I have some projects related with this award that I’ll write here very soon. But for now, I want to thank primarily to my princess Joana that is always by my side and to my family. Some special thanks to all direct and indirect support from:

- All blog visitors
- All the post-graduation students on BI from Universidade Portucalense (Porto)
- All the master graduation students on BI from ISCTE (MSIAD + MEI) (Lisboa)
- Dra. Maria José Trigueiros for all the magic words (She’s still alive in my life)
- All those persons that believed in me, even more than myself

Thank you all! Regards.

BI Conference - Microsoft Portugal 2011 (day after)

Yesterday I attended the Microsoft BI Conference that took place here in Portugal. It was the first time that Microsoft organize a big and vertical conference focus specifically only in Business Intelligence. The advantage of this kind of focused event is that the attendees know exactly where they go and also is more easy to get support from Microsoft BI partners that could implement some interesting initiatives like show what they has being done in BI, but also to get the contacts of potential future customers and also employees. 700 attendees are a signal that Microsoft BI Tools and “BI world” have been gaining more confidence and support from the community. A special reference for my BI students from ISCTE (Lisbon) and also from UPT (Porto 300 kms distance) that were attending the event! This is just one more step on their interest on BI World… I hope they enjoyed it!

But because this is the first big BI event with 3 parallel tracks, naturally that has some contents that not fit at all in some group of attendees. Almost the sessions was too soft for Microsoft BI professionals, but was amazing for those people that were seeing Microsoft BI capabilities for the first time. Naturally this kind of event has a commercial purpose that allowed being a free event. So… a free event with a very good speakers and also with an amazing organization from Microsoft staff… what we can expect more?! I believe these kind of vertical/focused events are here to stay. And I hope to finally see an academic track where the BI students around Portugal could show their projects based on Microsoft amazing BI tools. And also we want to see more Portuguese speakers like Bruno Cortes that was planned to present at the beginning, but for some reason his session was canceled. There are huge potential in BI here in Portugal that Microsoft in my perspective should invest. What about the several conference partners? Just one Portuguese partner presents a session? This makes any sense? For me naturally not!

It was amazing to speak personally with Albert Ferrari that is one of my references since some many years. If you want to follow one of the discussions I had with him in SQL BI methodology click here. I confess that I don’t believe too much in Microsoft Power Pivot Excel Add-in (One of the main key areas of Albert Ferrari and also Marco Russo), but after speak for a while with Albert, he convinced me with some new features that I didn’t know. I am an advocate of a single repository of data, and create more “islands” of information scares me! I know that Power Pivot has huge performance, I know that could be amazing for a prototype, but I also know, Microsoft is interested in these islands (Office is a key area) and in a more realistic scenarios cannot be created by end-users, because they need to know a new query language (DAX)… If Integrated with Sharepoint I truly believe that could resolve some issues, even because the amazing Sharepoint design/layout could easily create a new end users habits that in spite of going to file system looking for their excel files, maybe start looking in Sharepoint that centralize them… Congratulations for all your sessions! Nice so see you here!


The Facilities and organization
Relating to the facilities and all organization, I just need to thank to João Bilhim e Miguel Vicente for all the amazing work they done on this event. They always give 200% to make these initiatives come true. On my side as a BI passionate I want to thank all the efforts done.


The Tagetik Session
In spite of their very good speaker’s performance, I was expecting a bit more about Tagetik tools. It was more a Sharepoint integration than a Tagetik session… for those that saw Sharepoint for the first time I imagine that it was amazing… but for those not, I think they was little disappointed because they have not seen the huge promise of Tagetik capabilities. Maybe in a next opportunity… but thanks for the speakers that made a very good session!


One day in a decision maker life session
The session was promising a lot… and despite almost attendees not having learned anything new, it was a funny and cool session… Basically, Sergio Ferreira (Microsoft) was telling us a history about BI (in Sergio BI perspective) and about how he deal with 400 new email messages every day and about the 1.200 meetings he has per month! He showed a power pivot excel file that reads data from outlook… It was a different session more focused on convinces business users, that they can do more with less effort. I think he made it well!


The Maciej Pilecki Sessions
Usually the speaker that comes from Project Botticelli Company is Rafal… See here my posts about this amazing speaker. Unfortunately he didn't come this time and Maciej Pilecki replaced him. Maciej is also a huge speaker, but the topics was very simple and generic and already included in previous Rafal events on Portugal. But for those who never had the opportunity to see Rafal sessions and are beginning a BI career, I don’t have any doubt they were convinced about Microsoft BI tools capabilities. Congratulations to Maciej!


The Alejandro Leguizamo session
Alejandro is Spanish and my MVP colleague. It was the first time I saw a session presented by him, and truly loved! He made a very good job in his session about “Designing scalable and complex Analysis Service Cubes”… it was for more advanced and tech users, and fits more in those people that already work with SSAS. Unfortunately I didn’t speak in person with Alejandro, because I left his session before the end, and I never found him again around the conference location. Congratulations Alejandro! Nice to see you here in Portugal!


More conferences like this one is desirable for sure!

BI Videos - SQL Server Denali Videos‏

Today I paste some very interesting SQL Server videos links for you... not only for BI professionals, but also SQL DBA's and DEV's. I hope you enjoy them!

The videos and links could be found below:

Upgrade Your Database (Denali)
Data Programmability Tools (Denali)
SQL Server appliance (Denali & R2)
Parallel Data Warehouse (R2)
SQL Server virtualization (Denali & R2)
SQL Server security (Denali)
SQL Server AlwaysOn (Denali)
SQL Server backup compression (R2)
SQL Server Integration Services (Denali)
SQL Server Non-Relational (Denali)
SQL Server CLR (Denali)
SQL Server Data Compression (R2)
SQL Server Manageability (Denali & R2)

BI Conference - Microsoft Portugal 2011

Microsoft is organizing a conference only about BI here in Portugal… I have no doubts that will be an amazing conference! It's a big surprise a Microsoft conference focused only in BI…

There are 3 tracks…
Track 01 – IT Decision makers
Track 02 – Deep Dive em Microsoft BI
Track 03 – Microsoft BI Ramp-Up

If you are in Portugal you cannot miss this conference next 25 March!!
It’s a free conference! Registration can be done here

BI Webminar - Free Data Mining Webinar

If you are curious to know more about Data Mining and you use Excel as one of your favorite tools, I truly suggest you to assist at the Predixion Webminar that will take place next 11th January. Microsoft changed the strategy concerning to the Data Mining, and it was perceptible not only by the new position of Donald Farmer at PowerPivot team, but also after the main Microsoft team elements abandoned Microsoft Data Mining team on 2009. These elements created a new and amazing company named Predixion. I truly believe on determination and capabilities of the main founders of this company since the first time (like Jamie MacLennan an Simon) and it’s an honor to be a Beta tester of their fantastic Data Mining Product since the beginning.

The main and big improvements comparing to MSFT Data Mining Add-In:

- The amazing design
- The easy and flexibility to manage the models done with Predixion
- The huge performance (mainly because their cloud plataform)
- No cost-prohibitive software license fees
- The possibility to use PowerPivot dataset as source that support the process of millions of rows in seconds
- Connectivity with SAS and SPSS (world leaders) through PMML language
- (…)

Even Microsoft recognizes today the importance of Prexition in the Data Mining field and also as a Microsoft partner. Donald Farmer (He was the Microsoft Data Mining team responsible and now he’s the Microsoft PowerPivot responsible) assume that with this opinion:

"Many businesses have ambitions to use predictive analytics to improve their practices and intelligence. Until now, such projects have often been shelved because current tools were either too difficult or limited to the desktop. Now, we see an alternative – Predixion Software.

Predixion Insight’s deep integration with SQL Server Data Mining brings analytic power; the integration with Microsoft PowerPivot for Excel brings flexibility for end users to prepare almost limitless data for analysis, and their business model makes experimentation and incremental deployments practical and attractive. The result is a truly agile, yet potent, solution for predictive analytics.” Donald Farmer, Microsoft Corporation

Take a look into Predixion Corporate video on the YouTube:

Predictive analytics and data mining are now available to business intelligence experts everywhere with Predixion's cloud-based predictive analytics software. Predixion brings affordable, sophisticated predictive analytics to Microsoft Excel and PowerPivot.
Do not miss the Predixion Webminar!

You will learn on this webminar:
- What exactly is Predictive Analytics & who needs it.
- Where & how Predictive Analytics is being used.
- What Predictive Analytics can do for your bottom line.
- How to get started using Predixion insight

I’m preparing a post to show you into deep detail, how it's easy to create a Data Mining model through Excel using Predixion tool. If you want know more about Data Mining and the session I presented last year at Microsoft TechDays 2010, follow this link

BI Seminar - Microstrategy BI Tools

Last Friday, I invited the "Microstrategy" to present a session based on their BI tools, to students from two different master degrees classes and also some BI passionate friends.
I confess that I didn’t have a very a good opinion about Microstrategy. But since some months ago, I surrendered to their products quality not for my own experience with the tools, but mainly by the market opinion and for the amazing staff that Microstrategy Portugal currently has.

Related to market opinion, Microstrategy is for Gartner, one of the world BI leaders. Mainly after this session, I truly believe on it, but BI is more than that… there is a huge work that BI should do to became a successful system. And because we are talking about tools... an ETL tool to extract, transform and load operational data into BI system is a critical step where almost projects in average spend 70% of the time. A BI system has a huge pillar on technology, but is required to be aligned with strategy, with business processes and with the people which almost the times resist to the change.

Related to the Microstrategy Portuguese staff, they are very kindly and always available to be in touch with the master degrees that I collaborate as assistant teacher. They are amazing and I’m sure that they make the difference in an increasingly competitive BI world.

The session was very interesting and concerning to the Microstrategy tools I highlight the big flexibility to create a dashboard, and also the huge performance that seemed to have! Also the dashboard showed directly in IPAD was wonderful!

The feedback from the audience was very positive... I highlight the following:

Take a look at this video to better imagine what was included on this seminar

Thanks again to Daniel and Carla from Microstrategy Portugal!

BI Tools – Microsoft Project Crescent

During the PASS Summit, Microsoft announced the launch of the community technology preview (CTP) of SQL Server 11, codename “Denali”. Unfortunately, this version doesn’t have yet almost BI functionalities promised by Microsoft. Only at the end of 2011 these functionalities will be available to try!

But for now, I’m very excited to see codenamed Project “Crescent” (entirely developed on Silverlight) available to try and test! Microsoft already have cool BI front-end tools, although it’s required a tool that gathers all the functionalities dispersed by these several tools in only one. Right now, we can explore information inside a Data Warehouse or OLAP Database, through very good tools like: Excel, Visio, Report Builder, Reporting Services, Power Pivot (Excel Add-in)… but Project Crescent is a hope that an amazing visualizing world is coming soon… I hope not be disappointed, but on 2011 we all see and prove!


If you want to download the SQL Server Denali CTP, follow this link

Regards, Pedro

BI Event – Microstrategy BI Symposium

Well… I come again with a post related to BI Events… Mainly because the entire world is open the eyes and the focus to BI world is growing a lot… I would not be fair if I don’t enclose Microstrategy in the more important events about BI realized in Portugal. Microstrategy is one of the top companies in BI on the entire world. After SAP and Oracle events you cannot miss Microstrategy event next 9th November 2010… Personally, I want to thank to Carla Bastos, Rodolfo Vale and Nuno Esculcas (Microstrategy Portugal) for all the support and availability to make this BI world better!

BI Events – Oracle and SAP BI Platform’s

Business Intelligence (BI) is the present and the future. Independently on which BI tools are used, the well succeeded companies don’t live without BI. Naturally BI is not only technology, but we all agree that they are the most important driver on BI. If you are a decision maker, an employee, a student, a teacher, or a simple person that are thinking to enter on this world, could be interesting see another perspective of BI. Oracle (15 September) and SAP (23 September) will hold this month their BI events with the latest news about their BI platform.

Join these events.

BI Tools - SQL 2008 R2 Digital Tour

My teacher Maria Jose Trigueiros is not physical present any more, but she’s always present in my mind. I’m sure that she’s watching what the persons that has the luck to has her as teacher and as a friend will be doing. She shared amazing words, enthusiasm and experiences with me that changed my life. Because I know that she wishes that I continue blogging... I’ll do it, and even with more power!

SQL Server 2008 R2 RTM is now available for download!
I already installed in a new virtual machine in order to preparing some posts about it. In Microsoft SQL Server 2008 R2, several components have new or improved features. I highlight the following new improvements:

PowerPivot for SharePoint
PowerPivot for SharePoint adds shared services and infrastructure for loading, querying, and managing PowerPivot workbooks that you publish to a SharePoint 2010 server or farm. To create PowerPivot workbooks, you use PowerPivot for Excel.

PowerPivot for Excel
PowerPivot for Excel is an add-in to Excel 2010 that can be downloaded from the web and installed on client workstations. You use PowerPivot for Excel to assemble and create relationships in large amounts of data from different sources, and then use that data as the basis for PivotTables and other data visualization objects that support data analysis in Excel

Reporting Services improvements
Reports can now include maps, sparklines, data bars, and indicators to depict data. Report parts enable collaboration through shared datasets, report items, and data regions that are centrally stored and managed. Dataset query results can be cached on first use or by schedule. SharePoint integration supports multiple SharePoint Zones, SharePoint Universal Logging, and local mode report viewing with Access Services and SharePoint lists. SharePoint lists, SQL Server 2008 R2 Parallel Data Warehouse, and SQL Azure Database can be used as data sources for reports

Take a look at additional news here
Take a tour on this new version of SQL through SQL 2008 R2 Digital Tour:

Regards,

Pedro

BI Tools - First Look to Excel 2010

Create Dashboards never been so easy ... the new version of Excel 2010 (Beta) is really amazing. Exploration of a multidimensional cube has never been so intuitive and simple like it is now. The image below shows a simple dashboard that I made in this new version in 20 minutes for the Northwind database sample...

There still are some features to improve in this version, anyway, the new features promise to make the life of the decision maker easier... and now, I sincerely believe that the democratization of business intelligence is beginning, and finally Business Intelligence will soon be available to all employees of an organization. And all because Excel is the best known tool in the world, where almost users who use a computer, know what Excel is and what Excel do. Many BI Vendors know it, and began to build few years ago, add-ins for Excel in order to take advantage of some previous limitations of Excel. And a question arises ... will these small businesses survive the constant improvement of Excel? Only time will tell whether they will be able to adapt or not with new solutions... I really hope so, becausee this small companies do a big important job… and Microsoft knows that!

As the most interesting features from Excel 2010, I highlight the slicers, the “sparklines”, and the possibility of creating Named Sets through Excel. The Slicers lets you visually filter the data in a PivotTable and quickly extract exactly the data you're looking for. Slicers can be moved and resized like charts and graphs. And each slicer could be connected to several pivot tables… for me it’s really amazing this feature. The “sparklines” is a copy of some products made before by XLCubed (check the SQL Bits session where XLCubed presented “Microcharts”) and it’s in a very early stage. And the last feature that I highlight today, is the possibility to create named sets from Excel, grouping a set of items and several other features like customize MDX statements of a pivot table.

I hope this post was helpfull to you.
regards, Pedro

BI Training - Free remote BI Sessions

This month is being hard for me because I’m writing my master thesis… and the deadline is in the final of this month… and for that reason I’m not writing so often. Almost two and a half years writing in this blog and there's a new idea... in addition to send my BI messages/opinions through writing, I'm thinking to contact via video/audio with all you that visit this blog and make it alive with all the comments and suggestions. At the moment I’m only formalize the intention and hoping to receive feedback for all you.

In brief I’m describing below the session plan:
What?

Business Intelligence training focused on learning the concepts and using the Microsoft tools that are more flexible than other players in the market.

Why?

To share knowledge, make new friends and also to train my oral english language.

Who?

For all the persons that usually visit and support this blog with comments and sugestions. (For portuguese people I’ll prepare soon a on-site training)

When?

I will try to do it on October or November of this year 2009 after finishing the master BI thesis and after the 20h00 (Portuguese time... because I have a job…)

How much?

Free

How attend?

Through Office Live Meeting that you can use to engage audiences in online meetings, training, and events. I need to make some tests to this software, even appoint a date for testing it with all the registered users.

Registration?

In order to know the number of interested users, please fill the registration form in the link below. (The number of users are limited)

Registration form

I’ll be waiting for you.

BI Tools - Microsoft beating the BI market

Today I finally received an e-mail from Microsoft announcing the release of the CTP version (Community Technology Preview) for SQL 2008 R2 ... and I'm really excited to take the first look and for sure tomorrow I’ll download it ... I'm still focused on my master thesis, any way I will try to "play" a little this release and give a little feedback to you.

I truly believe that today Microsoft made a big step to beat all the competitors. Microsoft doesn’t have several decades of proved work, but has few years that are being improving and investing a lot in the Business Intelligence “world”

But why as an independent BI consultant I believe in Microsoft?

1. Because Is open to the communities/and world in spite of almost other players that they follow a strategy to hide all information and knowledge from their products

2. Because Is a buyer in the market… Examples are the acquisitions of Datallegro, ProClarity, Mobicomp (mobile), Zoomix (data quality), Teradata… and for example partnerships with Dundas, Panorama…

3. Because in a near future BI will be for all users (to the masses) and not only for a few group of decision makers. Today BI is spread in all organization for operational, tactical and strategy areas. Nothing better than improve the capabilities of an existent product in the market that everybody knows what it is, and what it does… simple EXCEL.

4. Because almost the players (SAP, SAS, Microstrategy…) in the BI market provide very expensive tools that are not possible nowadays… Some years ago they could set these expensive costs, because in that time these tools could provide competitive advantage… today even open source solutions are available in BI…

Last decades this BI players was trying to convince the end users and decision makers that they need new applications/interfaces to analyze, monitor and plan their business, but they were wrong, and mainly because Microsoft enter few years ago in this market. The end users and decision makers doesn’t want to know what is behind excel… only wants to see their KPIs no monitor, analyze, plan and control their business in their preferred tool… EXCEL.

In the coming weeks Microsft will also launch CTPs in the Project Gemini (Excel and Sharepoint) and in the Project Madison (massively scalable data warehousing).

BI Technical Papers Step-By-Step

As you may already noticed, I’ve started this blog (two years ago) with several practice issues, and when I started my BI master degree (also two years ago) I realized that the theory and the concepts are fundamental to have enough capabilities to face all the issues independently of the tools you are using. I’m a practice and theoretical person and just because I think that one depends on the other. It’s difficult? Yes it is, but for me is the single way to understand and align each one.

And for not fill this blog too much, I decided to publish more technical and practice posts at the Business Intelligence community that I’m co-founder with several other BI professionals. These technical posts will be created and published in www.BIResort.net in a format Step-By-Step paper in order to help better not also the more technical persons, but also those persons that are starting to work in this amazing world of Business Intelligence.

I’ll focus in several key areas, but for now I only made three papers in SSIS/ETL area. I’ll start on areas like SSAS/OLAP, SSRS, EXCEL 2010, and others… follow this post through the link in the right bar.

Follow all the papers from this link:

http://biresort.net/blogs/pedrocgd/archive/tags/StepByStep/default.aspx

And you can also directly download each paper from here:

SSIS Area

StepByStep - SSIS Moving huge amount of files

StepByStep - SSIS Using Package Configurations

StepByStep - SSIS Extract data from multiple Excel worksheets

I hope I can help 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 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