Wednesday, May 27, 2009

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...

Thursday, May 21, 2009

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

Sunday, May 17, 2009

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:

Sunday, May 10, 2009

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!

Tuesday, April 21, 2009

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...

Thursday, April 16, 2009

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

Thursday, April 9, 2009

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

Friday, April 3, 2009

BI Discussion - Concepts Oriented vs Tools Oriented

Today I will talk about an issue that I think it matters to all IT professionals... which is until the point that we should guide by the concepts and tools? There surely a point of equilibrium between the two and for that reason I’m opening this discussion to hear from you.

The recent discontinuation of the performance point server Planning module by Microsoft, was alerting me to an important problem that starts becoming increasingly important, mainly for high increasing of globalization.

In our day to day during the work or during the leisure time, we should give more importance to the concepts or to the tools? Well ... it seems a simple question to answer ... but in fact there are many professionals in this area of BI that are very targeted to the tools ... which on the one hand can give an advantage to acquire a unique know-how, but on the other hand, is somewhat to isolate that knowledge, which could bring great disappointments fruit of great changes and development of technology that is easy to aware. Who guarantees us, that tools like SAS, Microsoft, Microstrategy, Cognos, SAP ... will not be used less or simply disappear?

So, I’m increasingly seeking knowledge through concepts, for example acquired during my master BI degree at ISCTE (MSIAD), which started in 2007. So many of you ask me ... then why are you an unconditional fan of Microsoft tools? And I say that for the simple reason of being a company with a strategy geared to the communities, for customers and for students, and has tools for easily accessible, portable, flexible and a great community always ready to help ... (where you can find me at the MSDN forums or in Experts-Exchange)

With Microsoft, is easy to implement concepts in practice with their more intuitive and simple tools, because besides the risk of opting for Microsoft to be lower due to its policy of acquisitions really strong (For example the acquisition of Panorama, ProClarity, some Dundas funtionalities, DataAlegro, Mobicomp, and some day Yahoo...) there is a lower risk in terms of knowledge ... because in spite of wasting long time learning the tools, we can release time for learning the concepts that it’s for me one of the keys to success.

An interesting research from DM Review can give you a better perception about the most used tools and the reasons to be on the top… take a look
here
And since we talk about keys to success, I would ask you another question... What in your perspective, the other keys to success? Do you have discovered it yet? Well ... unlike the previous question, this is undoubtedly not easy to answer ... in my opinion, the other keys to success are with no doubt the motivation and the professionalism that we show in our day to day.

By Motivation I mean focused on ourselves and in what encourage us day to day, to be better and better.

By Professionalism I mean:
Our image to others. Reflects the level of consistency, punctuality and the capacity to assume our mistakes and errors
Be organized Reflects the capacity to be organized. As my project management teacher told us in the classes, if you are not organized, how you are able to convince the others that you can organize or manage their projects?

Help me identify the keys to success! Leave your opinion... This is just my first draft...

Saturday, March 28, 2009

MSIAD - Stock Market with Data Mining (BI Thesis)

I was a little absent this month in preparation for my thesis ... I promise to write more often now! Yesterday was my first battle on my dissertation, which I think it was well reached. Naturally, any research in this complex world of stock markets, in this case of applying data mining techniques, requires first understanding the financial world... I tried to demystify the complex stock market world... His movement, the factors that influence decision making, forecasting and the investor that feeds this whole game markets... and it was presented yesterday

After understanding the stock market as I did, I‘ll now focus on the application of Data Mining techniques (initially only with neural networks) and the implementation of a strategy that will be based from all rules made public by some researchers. That is, I will create a decision support system that in addition to track my portfolio of shares, it’ll generate the final output of the day that will be a buy, sell or hold signal.My strategy will assume the loss and also fix a limit on earnings. I do not need to be monitoring the stock market during the day, because I will use Stop Loss functionality in all investments that fire automatically an order of sale if the price of some share will excess my defined limit (applied only if I’m on the market)

In this matter, I'll then begin to examine in more detail the research of Dr. Chong from Chinese University of Hong Kong, that he’s the only economist, investor and researcher I know at the moment and who kindly offered me help and sent me all Articles that he has done. Dr. Chong is in the photo at right. Check his website at :

I already have done ETL processes to import historical data from a group of stock in my folder and a Datamart that stores the data in the form of information. It’s time to deepen into practice and return in May for a short presentation to be evaluated again. I assume the risk of this project that it’s very ambitious and attractive to me.

With nothing to lose! Regards!

Pedro

Wednesday, February 25, 2009

BI Conference - SQL Bits IV and Rafal Lukawiecki

SQL Bits IV
SQL Bits IV is coming… and this time it will be in Manchester, 28 of March…Unfortunately, I will not go to Manchester because I will have to expose my master BI dissertation on the day before (27th of March), but I will attend to it on-line!

My friend Tomislav Piasevoli will be responsible for the session “Universal calculated measures in MDX queries”… I will try to purpose one session in the next event... maybe about my master BI dissertation.

Rafal Lukawiecki
Microsoft are hosting a one-day seminar presented by Rafal Lukawiecki for IT Managers and BI practitioners wanting to improve decision making and getting the valuable business insight by using Microsoft solutions at the Microsoft Offices in London and Lisbon. As I told before in this blog, Rafal is the best communicator of the world, if you are near Lisbon or London, you cannot miss it.


In Lisbon (Portugal), March 24th

In London (UK), March 26th
Regards,
Pedro

LinkWithin

Related Posts Plugin for WordPress, Blogger...