tag:blogger.com,1999:blog-89440735887027897022024-03-13T21:47:39.498+00:00Business Intelligence Blog (BI Blog)"What you need in Business is more information than the other guy. Not more smarts. Not more intuition. Just more information".
<br>
Welcome to my blog! Enjoy it and leave your mark commenting it!Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.comBlogger158125tag:blogger.com,1999:blog-8944073588702789702.post-26960540085329378222014-01-08T21:21:00.000+00:002014-01-10T15:45:26.590+00:00BI BLOG - News Update<div style="text-align: justify;">
<span style="font-size: 85%;">
Dear friends,
It was so many time since the last time I wrote here. Basically, it was very difficult to get time to share and learn from all you. I’m currently being prepared to start a new challenge and be happy in other place. Time to time, a change is needed to refresh the mind and also enrich ourselves with new experiences and know new persons. Last week, I left my previous company. Although we have different perspectives and strategies about BI world, I should share with all you that it was a very good experience. I knew amazing persons, consolidate old friendships and will be follow up all their progress.
Meantime, is time to calm down, learn, write, share, teach and keep on with my PhD on BI area. Right now, I can ensure with all you, that I’ll be writing more often here. This is my home… since 2007… It was 7 years since the first post!
Keep in touch!
</span></div>
<div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-yTOVwtb_8K0/Us3ANBC9x_I/AAAAAAAABzY/i4S5EkBYMZw/s1600/CONTINUAR.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-yTOVwtb_8K0/Us3ANBC9x_I/AAAAAAAABzY/i4S5EkBYMZw/s400/CONTINUAR.jpg" /></a></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com3tag:blogger.com,1999:blog-8944073588702789702.post-48457386524480903802013-03-25T23:56:00.001+00:002013-03-25T23:58:31.947+00:00BIG DATA – Just one more buzzword?<div style="text-align: justify;">
<span style="font-size: 85%;">I confess that I'm already tired of the buzzword Big Data! But as an invited lecture in several universities, I must motivate students to embrace new concepts to make them research and learn “new things”. But in my opinion it’s just a new buzzword, nothing more… is like Business Analytics or other buzzwords that BI vendors incorporate in their products and services to make the idea they are creating something new and different from the concurrency. Well… but I think we should take a look about what they purpose to at least can have an opinion about it. Maybe I’m wrong! For that reason, I invite you to join the BIG DATA event that will take place at one of the best universities in Portugal concerning to Business Intelligence and related buzzwords.</span></div>
<a href="http://www.upt.pt/noticia.php?n=169" imageanchor="1" target="_blank"><img border="0" height="536" src="http://1.bp.blogspot.com/-8SI3caW6nZc/UVDjOl2hfRI/AAAAAAAABwE/Nxx-vu_KYxY/s640/BIG_DATA.png" width="570" /></a>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com2tag:blogger.com,1999:blog-8944073588702789702.post-13213216024210003982013-03-04T23:43:00.002+00:002013-03-04T23:56:30.373+00:00MSIAD - Agile DW and ETL design<span style="font-size: 85%;"><a href="http://www.amazon.com/gp/product/0956817203/ref=as_li_tf_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0956817203&linkCode=as2&tag=busintblobibl-20" imageanchor="1" target="_blank"><img border="0" height="163" src="http://3.bp.blogspot.com/-_IB4a3Oe9oo/UTUsOC9n_cI/AAAAAAAABvg/i5lTgY06OH8/s400/Agile_DW_ETL.jpg" width="400" /></a>
</span><br />
<div style="text-align: justify;">
<span style="font-size: 85%;">It’s a big honor to have two amazing DW and ETL gurus in Portugal (<a href="http://www.amazon.com/gp/product/0956817203/ref=as_li_tf_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0956817203&linkCode=as2&tag=busintblobibl-20" target="_blank">Lawrence Corr</a> and Joe Caserta). It’s for me the most important BI training ever done in Portugal. The price is higher but acceptable for attend several sessions provided by these two references. Concerning to Lawrence Corr, you should read the book we wrote… it’s <a href="http://www.amazon.com/gp/product/0956817203/ref=as_li_tf_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0956817203&linkCode=as2&tag=busintblobibl-20" target="_blank"><b>the best book I ever read</b></a>! Better than Kimball or Inmon. I’ll post my review of this book soon in my blog!! For now, stay with official description about the training that will take place at ISCTE (Lisboa).</span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;">The Lisbon BI Course is the first training in Portugal in Agile Data Warehouse Design and ETL with renowned experts in the field, Lawrence Corr and Joe Caserta. Lawrence and Joe usually teach these courses all over the world, including in TDWI events. This constitutes a unique opportunity to learn and exchange ideas in a friendly but intense environment. The Lisbon BI Course will take place at ISCTE – University Institute of Lisbon (ISCTE-IUL), located in the centre of Lisbon, in the University City Campus. This is a joint effort promoted by ISCTE-IUL, particularly its Master in Integrated Systems for Decision Support (MSIAD)
</span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span></div>
<a href="http://www.amazon.com/gp/product/0956817203/ref=as_li_tf_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0956817203&linkCode=as2&tag=busintblobibl-20" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em; text-align: justify;" target="_blank"><span style="font-size: 85%;"><img border="0" height="200" src="http://2.bp.blogspot.com/--Muwd6RYIdU/UTUvUKcTKKI/AAAAAAAABvs/hmT1jpVqyzo/s200/AGILE.jpg" width="153" /></span></a><span style="font-size: 85%;"></span><br />
<div style="text-align: justify;">
<span style="font-size: 85%;"><a href="http://www.amazon.com/gp/product/0956817203/ref=as_li_tf_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0956817203&linkCode=as2&tag=busintblobibl-20" target="_blank"><b>Lawrence Corr</b></a> is the author of Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema. He is a leading data warehouse design specialist and highly experienced educator who has worked in Europe, USA, the Middle East and South Africa developing and reviewing data warehouses for healthcare, telecommunications, engineering, broadcasting, financial services and retail clients</span></div>
<br />
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><a href="http://www.amazon.com/gp/product/0764567578/ref=as_li_tf_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0764567578&linkCode=as2&tag=busintblobibl-20" target="_blank"><b>Joe Caserta</b></a> is the author of the best-selling book The Data Warehouse ETL Toolkit, the de facto standard for building dimensional data warehouses. Joe offers more than 25 years of IT experience and over 15 years of delivering dimensional data warehouse solutions including experience in Higher Education. Joe delivers his published best practices in a way that encourages participants to immediately apply his techniques in real-life situations</span></div>
<div style="text-align: justify;">
<br /></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com1tag:blogger.com,1999:blog-8944073588702789702.post-78073603063629113592013-02-17T13:46:00.003+00:002013-02-17T13:54:59.053+00:00BI Events - Oporto BizTalk Innovation Day<a href="http://1.bp.blogspot.com/-fewXu54nWAI/USDeXvXRGzI/AAAAAAAABuY/xSqlr5s0xw8/s1600/banner-home.png" imageanchor="1" style="clear: left; display: inline !important; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="140" src="http://1.bp.blogspot.com/-fewXu54nWAI/USDeXvXRGzI/AAAAAAAABuY/xSqlr5s0xw8/s400/banner-home.png" width="400" /></a><a href="http://1.bp.blogspot.com/-fewXu54nWAI/USDeXvXRGzI/AAAAAAAABuY/xSqlr5s0xw8/s1600/banner-home.png" imageanchor="1"><span style="font-size: x-small;"></span></a><br />
<span style="font-size: x-small; text-align: justify;"><br /></span>
<span style="font-size: x-small; text-align: justify;"><br /></span>
<span style="font-size: x-small; text-align: justify;"><br /></span>
<span style="font-size: x-small; text-align: justify;"><br /></span>
<span style="font-size: x-small; text-align: justify;"><br /></span>
<span style="font-size: x-small; text-align: justify;"><br /></span><span style="font-size: x-small; text-align: justify;"><br /></span><br />
<span style="font-size: x-small; text-align: justify;"><br /></span>
<span style="font-size: x-small; text-align: justify;">BizTalk Innovation Day is a one-day event focused purely on Microsoft BizTalk Server related topics that has been conducted in several major European cities since Feb 2011: Amsterdam (Netherland), Milan (Italy), and Stavanger (Norway). The last event took place in London and it was a huge success! It was fully sold out with 130 attendees from 16 different countries.</span><br />
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<span style="font-size: x-small;">During this event participants will have an opportunity to hear about the new upcoming features in the BizTalk Server 2013 platform, integration strategies, private and public Cloud, and many more.</span></div>
<span style="font-size: x-small;">
</span><br />
<div style="text-align: justify;">
<span style="font-size: x-small;">Join this five MVPs (Microsoft Most Valuable Professionals) and most active community members for a remarkable community event.</span><br />
<span style="font-size: x-small;"><br /></span>
<b><a href="http://obid.devscope.net/" target="_blank"><span style="color: #351c75;">Read more here!</span></a></b></div>
<span style="font-size: x-small;">
</span><br />
<span style="font-size: 85%;">
</span>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-75267782276111230672013-02-09T21:05:00.002+00:002013-02-10T13:07:16.600+00:00BI Paper - SSIS Extract Data Multiple Worksheets<div style="text-align: justify;">
<span style="font-size: 85%;">
Some time ago in 2009, I wrote several papers from a community that I created in that year. But after the community website broke, I received dozens of requests to provide the papers for those who didn’t downloaded it at that time. For that reason I have attached to this post the paper again for everyone.
</span><br />
<br />
<span style="font-size: large;"><b>Scenario</b>
</span><br /><span style="font-size: 85%;">
Every month a company receive customers data from an excel file to extract and load data into an enterprise data warehouse. In brief, is required to extract data from a single excel file with multiple worksheets with same schema into a single destination table in SQL server.
</span><br />
<a href="http://2.bp.blogspot.com/-jLpDVfJhL10/URa2_inLNwI/AAAAAAAABrI/MaXMMED7hvw/s1600/SSIS_EX_03_FELC.JPG" imageanchor="1" style="font-size: 85%;"><img border="0" height="323" src="http://2.bp.blogspot.com/-jLpDVfJhL10/URa2_inLNwI/AAAAAAAABrI/MaXMMED7hvw/s400/SSIS_EX_03_FELC.JPG" width="400" /></a>
<br /><span style="font-size: 85%;">
I hope this paper could be useful
</span>
<br />
<div style="text-align: center;">
<b><a href="https://www.dropbox.com/s/k953eyhpzsejluf/SSIS_EX_03_FELC.zip"><span style="color: blue;">DOWNLOAD PAPER HERE</span></a></b>
</div>
</div>
Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com3tag:blogger.com,1999:blog-8944073588702789702.post-12299482993032682662013-01-05T12:55:00.001+00:002013-02-10T01:01:09.358+00:002012 Review<div style="text-align: justify;">
<span style="font-size: 85%;">It passed 3 months from the previous post and I need to say sorry to all you that follow my blog. For all the visitors, friends and more than 500 followers I want to explain that the previous year were the most important of my life and for that reason I failed writing here more often. I started the most important project of my life with the birth of my daugter Diana, wrote an entire book with my friend Reza and moved from Lisboa to Oporto to embrace a new challenge in a new company (BI4ALL) and stay near my family</span><br />
<span style="font-size: 85%;"></span><br /><span style="font-size: 85%;"></span>
<span style="font-size: 85%;">The most important project of my life and the first smile:</span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-vaLC_RXuCnk/UOghDVhlDfI/AAAAAAAABps/wxxPKmUMiCg/s1600/DIANA2.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto; text-align: justify;"><img border="0" height="198" src="http://3.bp.blogspot.com/-vaLC_RXuCnk/UOghDVhlDfI/AAAAAAAABps/wxxPKmUMiCg/s200/DIANA2.jpg" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><br /></td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-GqymZI8C8vg/UOghaikOmWI/AAAAAAAABp0/hqMlUNacIrc/s1600/PORTO.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="150" src="http://3.bp.blogspot.com/-GqymZI8C8vg/UOghaikOmWI/AAAAAAAABp0/hqMlUNacIrc/s200/PORTO.jpg" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">The most amazing city of the world: Porto</td></tr>
</tbody></table>
<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; text-align: left;"><tbody>
<tr><td style="text-align: center;"><span style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto; text-align: justify;"><a href="http://pedrocgd.blogspot.pt/2012/03/bi-book-ssis-2012-integration-services.html" target="_blank"><img border="0" src="http://3.bp.blogspot.com/-ECHAT-DAH4M/UOgh6rPV0uI/AAAAAAAABp8/yhJ5N5xIxno/s1600/SSIS2012_Book.jpg" /></a></span></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><a href="http://pedrocgd.blogspot.pt/2012/03/bi-book-ssis-2012-integration-services.html" target="_blank">The book</a></td></tr>
</tbody></table>
<br />
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"></span><br />
<span style="font-size: 85%;"></span>
<span style="font-size: 85%;"></span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span>
<span style="font-size: 85%;"><br /></span>
<span style="font-size: 85%;"><br /></span>
<span style="font-size: 85%;">... and he company I currently work and the event I organized in Porto</span></div>
<div class="separator" style="clear: both; text-align: justify;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/S7W03kPCRBc?feature=player_embedded' frameborder='0'></iframe></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-size: 85%;">
I promise that I'll write more often! </span><br />
<span style="font-size: 85%;">I have several projects in mind to share with you all.</span><br />
<span style="font-size: 85%;">Pedro</span></div>
Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com6tag:blogger.com,1999:blog-8944073588702789702.post-42480993136685078062012-09-20T23:15:00.000+01:002012-09-20T23:31:57.961+01:00BI Book - Packt Publishing reaches 1000 IT titles<div style="text-align: justify;">
<span style="font-size: 85%;">
Dear friends, </span><br />
<span style="font-size: 85%;">The last two months was a big challenge for me. Working at one of the best BI companies of the world (<a href="http://www.bi4all.pt/" target="_blank">BI4ALL</a>) is not an easy task! But everything is running fine and it’s really amazing working with wonderful colleagues as I have at BI4ALL. But the reason for this email is to spread a marketing message from the Packt Publishing who gave me all the conditions and support to write an amazing <a href="http://pedrocgd.blogspot.pt/2012/03/bi-book-ssis-2012-integration-services.html" target="_blank">SSIS book with my friend Reza Rad</a>. </span><br />
<span style="font-size: 85%;"><br /></span>
<a href="http://www.packtpub.com/" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;" target="_blank"><img border="0" src="http://4.bp.blogspot.com/-pz2Emi2I91M/UFuYCyMWMBI/AAAAAAAABoM/4i2QFWplsJk/s1600/PACKTPUB.png" /></a><span style="color: #351c75; font-size: 85%;">Birmingham-based IT publisher Packt Publishing is about to publish its 1000th title. Packt books are renowned among developers for being uniquely practical and focused. Packt books cover highly specific tools and technologies which IT professionals might not expect to see a high quality book on.
Packt would like you to join them in celebrating this milestone with a surprise gift – to get involved you just need to have already registered, or sign up for a free Packt account before 30th September 2012.
Packt published their first book in April 2004. One of the most prolific and fastest growing tech book publishers in the world, they now have books on everything from web development to web graphics, e-learning to e-commerce, IT architecture to games, and app development.
Packt supports many of the Open Source projects covered by its books through a project royalty donation, which has contributed over £300,000 to Open Source projects up to now. As part of the celebration Packt is allocating $30,000 to share between projects and authors in a genuinely unique way, soon to be disclosed on their website. </span><br />
<span style="color: #351c75;"><span style="font-size: 85%;"><br /></span>
<span style="font-size: 85%;">Dave Maclean, founder of Packt Publishing explains, “<i>At Packt we set out 8 years ago to bring practical, up to date and easy to use technical books to the specialist tools and technologies that had been largely overlooked by IT publishers. Today, I am really proud that with our authors and partners we have been able to make useful books available on over 1000 topics and make our contribution to the development community</i>.” </span></span><br />
<span style="color: #351c75;"><span style="font-size: 85%;"><br /></span>
<span style="font-size: 85%;">For more information about Packt, the kind of books they publish, and to sign-up for a free account before the 30th of September, 2012, please visit their website: <a href="http://www.packtpub.com/" target="_blank">www.PacktPub.com </a></span></span></div>
Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-5701343524072257472012-07-21T00:59:00.000+01:002012-07-21T01:25:38.074+01:00BI Challenge – Moving to BI4ALL<div style="text-align: justify;">
<span style="font-size: 85%;"><span style="background-color: white;">This week I’ve started a new challenge in
my life: I moved to BI4ALL (</span><a href="http://www.bi4all.pt/" style="background-color: white;">www.bi4all.pt</a><span style="background-color: white;">).
BI4ALL is a specialized company on Business Intelligence and Corporate Governance
and was identified by Microsoft and IBM as a company with more experience in
developing Business Intelligence solutions in the Portuguese market. It has for
some years a reference for me in BI, not only by the quality of the solutions
developed, but also the quality of people who work here (about 60) that I had
the privilege of socialize over the last years.</span></span></div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;"><br /></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;">The BI4ALL with more than 10 years has the
headquarters in Lisbon and is investing heavily in Porto, where it already has
a customer base that represents<a href="http://www.bi4all.pt" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="BI4ALL" border="0" height="129" src="http://1.bp.blogspot.com/-Bvswf5sreJI/UAnxqw5oh5I/AAAAAAAABnA/64HsL3Ff_KE/s200/L_bi4all_pos_secundario.png" title="BI4ALL" width="200" /></a> 10% of the company and a Research Center for Business
Intelligence Mobile Solutions (over a year). The purpose of BI4ALL will be to
continue the growing on this amazing world of Business Intelligence and give
the Portuguese companies a competitive advantage over its competitors. This blog has more than 5 years and I will continue to share my insights and news on this amazing field!</span><span style="background-color: white; font-size: 85%;"></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;">Pedro</span></div>
</div>
<br />
<span lang="EN-US" style="font-family: Calibri, sans-serif; font-size: 11pt;"><br /></span>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com6tag:blogger.com,1999:blog-8944073588702789702.post-81697515818168245172012-06-16T00:06:00.000+01:002012-07-21T00:59:02.729+01:00BI Book - SSIS 2012 book winners<div style="text-align: justify;">
<span style="font-size: 85%;"><span style="background-color: white;">This week I’ve started a new challenge in
my life: I moved to BI4ALL (</span><a href="http://www.bi4all.pt/" style="background-color: white;">www.bi4all.pt</a><span style="background-color: white;">).
BI4ALL is a specialized company on Business Intelligence and Corporate Governance
and was identified by Microsoft and IBM as a company with more experience in
developing Business Intelligence solutions in the Portuguese market. It has for
some years a reference for me in BI, not only by the quality of the solutions
developed, but also the quality of people who work here (about 60) that I had
the privilege of socialize over the last years.</span></span></div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;"><br /></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;">The BI4ALL with more than 10 years has the
headquarters in Lisbon and is investing heavily in Porto, where it already has
a customer base that represents 10% of the company and a Research Center for Business
Intelligence Mobile Solutions (over a year). The purpose of BI4ALL will be to
continue the growing on this amazing world of Business Intelligence and give
the Portuguese companies a competitive advantage over its competitors<o:p></o:p></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;">This blog has more than 5 years and I will
continue to share my insights, work and news on this amazing field! <o:p></o:p></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;">We in BI4ALL make the things happen!!<o:p></o:p></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span lang="EN-US" style="font-size: 85%;">Pedro</span></div>
</div>
<br />
<span lang="EN-US" style="font-family: Calibri, sans-serif; font-size: 11pt;"><br /></span>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-79260425184625651372012-06-04T22:06:00.000+01:002012-06-04T22:59:59.354+01:00BI Book - Win Free Copies of SSIS 2012 book<div style="text-align: justify;">
<div style="font-size: 85%;">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.packtpub.com/microsoft-sql-server-2012-integration-services-expert-cookbook/book" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;" target="_blank"><img border="0" height="150" src="http://1.bp.blogspot.com/-5qQKL93UDio/T80oKE4eTdI/AAAAAAAABis/jhh2loe0mVY/s200/affiliate-marketing-contest-winner.jpg" width="200" /></a></div>
I'm happy to inform you that the SSIS book that I wrote with my friend (Reza Rad) is now published!! I also want to let you know that Packt Publishing accepted my contest suggestion for offering 4 books (2 Print books + 2 e-books) to my blog readers. You just need to use your Twitter or LinkedIn accounts! Keep reading to find out how you can be one of the Lucky Winner.</div>
<div style="font-size: 85%;">
<h2>
<b>How to Enter?</b></h2>
</div>
<div>
<b>1-)</b><span style="font-size: 85%;"> Tweet this post and/or share this post in LinkedIn – you can use the tweet button at the top of the article.</span></div>
<div>
<div style="font-size: 85%;">
<br /></div>
<b>2-)</b><span style="font-size: 85%;"> Visit the </span><a href="http://www.packtpub.com/microsoft-sql-server-2012-integration-services-expert-cookbook/book" style="font-size: 85%;">book page link</a><span style="font-size: 85%;">, check out what’s inside and see what you would like to learn most from the books – pick one that you like the best</span></div>
<div style="font-size: 85%;">
<br /></div>
<b>3-)</b><span style="font-size: 85%;"> Choose one of the following options to win the book:</span><br />
<span style="font-size: 85%;"></span>
<span style="font-size: 85%;"><b><span style="color: purple;"><u>Option 01</u></span></b> - Enter a comment under your twitter or LinkedIn account on what you’re looking forward to learn most in from this book. The two best comments win one print book and one e-book.</span><br />
<span style="font-size: 85%;">Example Comment:</span><br />
<span style="color: #073763; font-size: 85%;"><i>"I'd like to own the Microsoft SQL Server 2012 Integration Services Expert Cookbook as I'd like to master all transformations in SSIS and their usages with real-world scenarios"</i></span><br />
<span style="font-size: 85%;"><br /></span>
<span style="font-size: 85%;"><b><span style="color: purple;"><u>Option 02</u></span></b> - Write a post/article under Business Intelligence concepts to be published on this blog. The best two original posts/articles win one print book and one e-book</span><br />
<br />
<b>4-)</b><span style="font-size: 85%;"> Be sure that you are following me on Twitter (@PerfeitoP) and/or also on </span><a href="http://pt.linkedin.com/in/pedrocgd" style="font-size: 85%;" target="_blank">LinkedIn</a><span style="font-size: 85%;"> when the contest ends to monitor your participation and let you know the contest results. </span><span style="font-size: 85%;">(Winners from the U.S. and Europe can either choose a physical copy of the book or the eBook. Users from other locales are limited to the eBook only)</span><br />
<h2>
<span style="font-size: 85%;">Deadline</span></h2>
<span style="font-size: 85%;">The contest for the best comment (Twitter and LinkedIn) and best post/article will <b><u><span style="color: red;">close on 15/June/2012</span></u></b></span><br />
<h2>
<a href="http://www.packtpub.com/microsoft-sql-server-2012-integration-services-expert-cookbook/book" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;" target="_blank"><img border="0" height="200" src="http://3.bp.blogspot.com/-s4TLdgfP1M0/T80uXKdhkzI/AAAAAAAABjw/04VWMrtwV_w/s200/SSIS+Book.png" width="150" /></a><span style="font-size: 85%;">Promo codes</span></h2>
<span style="font-size: 85%;">If you don’t want to participate on this contest but want to <a href="http://www.packtpub.com/microsoft-sql-server-2012-integration-services-expert-cookbook/book" target="_blank">buy the book</a>, here you have special discount codes to use in the Packt Publishing website. They are as follows:</span><br />
<span style="font-size: 85%;">25% discount on print book </span><b>PRSQL25</b><br />
<span style="font-size: 85%;">35% discount on e-book </span><b>EBSQL35</b><br />
<span style="font-size: 85%;"><br /></span>
<span style="font-size: 85%;">Do let me know if you have any questions. </span><span style="font-size: 85%;">Hope you all enjoy this book and let us know your feedback</span></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com1tag:blogger.com,1999:blog-8944073588702789702.post-13475755777470961062012-05-06T21:32:00.003+01:002012-05-09T22:15:42.315+01:00BI White Paper - BI for Midsize Organizations<div style="text-align: justify;">
<a href="http://pedrocgd.tradepub.com/free/w_sapx345/prgm.cgi" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;" target="_blank"><img border="0" src="http://2.bp.blogspot.com/-7IgMNZje2rs/T6bfQ0t6eCI/AAAAAAAABiQ/hmaK-_EG_i4/s1600/sap.gif" /></a><span style="font-size: 85%;">Today I’m opening a new section on the blog… the “BI White Paper”! And in this first post, I want to share with you a very interesting whitepaper that I was reading during the weekend. This whitepaper was written by Michael Schiff from SAP and is free (but requires registration). The article is written in a very interesting and objective way. I’ve included below the conclusion provided in the whitepaper to let you know more about it. I hope you enjoy the paper as much as me!</span></div>
<br />
<div style="text-align: justify;">
<span style="color: #0b5394; font-size: 85%;"><i>"Managers have the responsibility to make the best decisions possible, based upon the data available to them to learn more about how products from at the time. If their ability to analyze this data and transform it into useful information is improved, the overall quality of their decisions will improve as well. Business intelligence provides a spectrum of tools and solutions to support this aim. It’s the underlying technology behind more effective decision making. By helping align individual and departmental efforts with overall corporate strategies, it should lead to improved organizational results.</i><br />
<span style="color: #0b5394; font-size: 85%;"><i><br /></i></span></span></div>
<div style="text-align: justify;">
<span style="color: #0b5394; font-size: 85%;"><i>While many small and midsize companies have relied on spreadsheets as their primary Bi tool, most of them have come to realize that this is a stopgap solution. This is not to say that spreadsheets should be abandoned; rather, they should be a part of an organization’s Bi tool set. The key is to choose the right commercial Bi product suite that integrates with spreadsheet environments while supporting your long-term growth"</i></span></div>
<div style="text-align: justify;">
<span style="font-size: 85%;"><br /></span></div>
<div style="text-align: justify;">
<div style="text-align: center;">
<b><a href="http://pedrocgd.tradepub.com/free/w_sapx345/prgm.cgi" target="_blank">Read more downloading the white paper here</a></b></div>
</div>
<div>
<div style="text-align: justify;">
<br /></div>
</div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-31398497188790149002012-05-01T01:40:00.001+01:002012-05-01T01:49:02.234+01:00BI Book - Free SQL Server 2012 e-book<span style="font-size: 85%;">Dear friends,<br />If you want to know the new Microsoft SQL Server 2012, I highly recommend you to download the SQL Server 2012 <a href="http://download.microsoft.com/download/F/F/6/FF62CAE0-CE38-4228-9025-FBF729312698/Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012_PDF.pdf">free e-book</a> (288 pages - 10.8MB) wrote by Ross Mistry and Stacia Misner. I already read it! It's a very interesting book that you should take a look!</span><br />
<h4>
<span style="font-size: 85%;">PART I - DATABASE ADMINISTRATION (by Ross Mistry)</span></h4>
<span style="font-size: 85%;">1. SQL Server 2012 Editions and Engine Enhancements<br />2. High-Availability and Disaster-Recovery Enhancements<br />3. Performance and Scalability<br />4. Security Enhancements<br />5. Programmability and Beyond-Relational Enhancements</span><br />
<h4>
<span style="font-size: 85%;">PART II - BUSINESS INTELLIGENCE DEVELOPMENT (by Stacia Misner)</span></h4>
<a href="http://download.microsoft.com/download/F/F/6/FF62CAE0-CE38-4228-9025-FBF729312698/Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012_PDF.pdf" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="200" src="http://2.bp.blogspot.com/-j9Q0wyMkXUM/T58wcxd6f3I/AAAAAAAABeA/63Zi7RvH3rY/s200/SQL2012_Book.jpg" width="164" /></a><span style="font-size: 85%;">6. Integration Services (SSIS)</span><br />
<span style="font-size: 85%;">7. Data Quality Services<br />8. Master Data Services<br />9. Analysis Services (SSAS) and PowerPivot<br />10. Reporting Services (SSRS)</span><br />
<span style="font-size: 85%;"><br />And not forget… if you want a more specific book about SSIS 2012, don’t forget to buy the <a href="http://pedrocgd.blogspot.pt/2012/03/bi-book-ssis-2012-integration-services.html" target="_blank">book I wrote</a> and will be published during the next days.</span>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com1tag:blogger.com,1999:blog-8944073588702789702.post-77855312729065530392012-04-25T23:21:00.001+01:002012-04-26T00:40:03.313+01:00BI Certifications - CBIP Material for the exam<div style="text-align: justify;">
<span style="font-size: 85%;">Finally I got some time to write something more about <a href="http://pedrocgd.blogspot.pt/search/label/CBIP%20Exam" target="_blank">CBIP certification</a>.</span></div>
<div style="font-size: 85%; text-align: justify;">
<br />
First off all, don’t think this certification is the ticket for your next job. It’s just a motivation to let you learn more and improve your skills. Naturally that if you improve your skills, you have more conditions and recognition to get your BI job, but don’t think a certification by itself do it for you. Relating to this certification, it's a way to TDWI makes money like all other certifications that exists around the world. But at least in this case, it seems more credible and more recognized than for example Microsoft certifications. Why? Just because there are a lot of “brain dumps” spread in the internet with exactly some questions of the real Microsoft exams. TDWI do a very good job on this field… although having a big number of question not aligned with the certification subject (like for example in ETL module) they are good and unique! The TDWI staff in Germany is also amazing and very kindly with you! <a href="http://pedrocgd.blogspot.pt/2009/11/bi-certifications-cbiptdwi.html" target="_blank">See my experience there in 2009</a>!</div>
<div style="text-align: justify;">
<div style="font-size: 85%;">
<br /></div>
<div style="font-size: 85%;">
Now let’s go to the main reason to write this post! I’ve promised to the dozens of people that contacted me (almost since the post I wrote about CBIP experience in 2009) for help them on getting material guidance. For that reason here am I with the promised post! (Sorry for the late reply).<br />
<br /></div>
<div style="font-size: 85%;">
To make these exams, you should have minimal real-world, or at least huge academic experience, on the exam specialty that you’re thinking to get. If you have this pre-requisite then I think you should consider the suggestions I’m writing below.</div>
<h4>
<span style="font-size: 14px;">Suggestion 01 - Examinations Guide</span></h4>
<div style="text-align: right;">
<a href="https://tdwi.org/forms/buy.aspx" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;" target="_blank"><img alt="CBIP Exam" border="0" height="200" src="http://3.bp.blogspot.com/-iIeEPuKJCGE/T5h6qEl09iI/AAAAAAAABdg/bZhQKqrHGkQ/s200/CBIP_Exam.png" title="CBIP Exam" width="153" /></a></div>
<span style="font-size: 85%;">You MUST buy and read the CBIP Examinations Guide. This guide contains detailed exam outlines, reference reading lists, sample exam questions, and answer explanations for each exam included in the CBIP program. Testing software and practice timed exams are included with the guide. Taking the sample exams will identify areas where additional study and/or work experience may be necessary prior to testing. If you don’t have this examinations guide you will probably feel lost during the exam… And don’t forget that you don’t have too much time to think! The testing software is for sure crucial!</span><br />
<div>
<div style="font-size: 85%;">
</div>
<h4 style="font-size: medium;">
<span style="font-size: 14px;">Suggestion 02 - Mandatory Books</span></h4>
<div style="font-size: 85%;">
<a href="http://www.amazon.com/gp/product/0071498516/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0071498516" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;" target="_blank"><img border="0" height="200" src="http://4.bp.blogspot.com/-Y1_PeEnNQ3E/T5h8nPzpwZI/AAAAAAAABdo/ORopx0Mb5no/s200/BI_Book.png" width="133" /></a>You MUST buy and read the “<a href="http://www.amazon.com/gp/product/0470589833/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0470589833" target="_blank">Performance Dashboard</a>” and “<a href="http://www.amazon.com/gp/product/0071498516/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0071498516" target="_blank">Successful Business Intelligence: Secrets to Making BI a Killer App</a>” books! Why? The first, in addition to being a very interesting book, was written by the TDWI director at that time: Wayne Eckerson! And the second is a book that resumes the concept of BI in a simple and objective way. These two books are an investment that you should have! (And buy it… do not try to find illegal copies of this book on the internet… because doing so, you’ll not encourage authors to write more amazing contents like these ones). I should add that on these books, you will find several answers to some exam questions.</div>
<div style="font-size: 85%;">
<br />
<br />
<a href="http://www.amazon.com/gp/product/0470589833/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0470589833" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;" target="_blank"><img border="0" height="200" src="http://4.bp.blogspot.com/-l8U_g04dnKA/T5iAOL7ML4I/AAAAAAAABd0/hMarsccHNYs/s200/PerformanceDashboard.png" width="135" /></a></div>
<div>
<span style="font-size: 85%;">Now let’s go to remaining materials that although not mandatory, should be read at least some of the topics where exist some doubts. You probably don’t have time to read more books, but I also suggest several others in a <a href="http://pedrocgd.blogspot.pt/2010/01/bi-books-my-suggestions.htm" target="_blank">previous post</a>. </span><span style="font-size: 85%;">Try also to get some information in the internet about the following topics: </span><span style="font-size: 85%;">Dimensional Modeling (</span><span style="font-size: 85%;">Techniques like Slowly Changing Dimension, Junk Dimension, Mini-Dimension, Outrigger, Role-Play Dimension… Fact table types: Transactional, Cumulative Snapshot, Periodic Snapshot, Factless and Factless Coverage), </span><span style="font-size: 85%;">Data Warehousing architectures</span><span style="font-size: 85%;"> (Bus model, Hub and Spoke, Federated and Independent Data Marts), </span><span style="font-size: 85%;">OLAP Architectures</span><span style="font-size: 85%;"> (MOLAP, ROLAP, HOLAP),</span><span style="font-size: 85%;"> </span><span style="font-size: 85%;">Data Warehousing Methodologies</span><span style="font-size: 85%;"> (Both Kimball and Larissa Moss methodologies), </span><span style="font-size: 85%;">Data Mining and make some research on</span><span style="font-size: 85%;"> terms like BPM, CRM, OLAP, ETL, BAM…</span><br />
<span style="font-size: 85%;">I hope this post helps you!</span><br />
<span style="font-size: 85%;">Regards,</span><br />
<span style="font-size: 85%;">Pedro</span></div>
<div style="font-size: 85%;">
</div>
</div>
</div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com11tag:blogger.com,1999:blog-8944073588702789702.post-31886306357277531212012-04-05T17:35:00.014+01:002012-04-05T19:56:23.026+01:00BI Award – SQL BI MVP Award 2012<div align="justify"><a href="http://4.bp.blogspot.com/-qGUUy1xJGdE/TZiivCs1gbI/AAAAAAAABWw/geLo5m8c5ac/s1600/MVPLogo.jpg"><img style="WIDTH: 400px; HEIGHT: 75px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5591397866442949042" border="0" alt="" src="http://4.bp.blogspot.com/-qGUUy1xJGdE/TZiivCs1gbI/AAAAAAAABWw/geLo5m8c5ac/s400/MVPLogo.jpg" /></a><span style="font-size:85%;"> Last Sunday, I received for the third year, the award from Microsoft for all participation on several communities and also for all contribution spreading to the world the Microsoft BI tools during 2011. These tools are in my opinion very robust, intuitive and with huge future! For that reason is a pleasure to work with.</span></div><div align="justify"><span style="font-size:85%;"><br />Last year was the most hard for me… not only the book, but the full time job on BI with amazing projects on several interesting institutions. I hope to receive the award again next year and for that reason I’ll participate even more on communities and maybe write another book! I want to dedicated this award to: </span></div><span style="font-size:85%;"><br /><span style="color:#000099;">- All blog visitors</span><br /><span style="color:#000099;">- All the post-graduation students on BI from Universidade Portucalense (Porto) and ISCTE (MSIAD + MEI) (Lisboa) for all important feedback on the Microsoft tools and also the direct and indirect support they gave me during the last year </span><br /><div><span style="color:#000099;">- To Dra. Maria José Trigueiros for all the magic words (You’re still alive in my life. I’ll never forget you!)</span><br /><span style="color:#000099;">- To my family and my girlfriend for all the support they gave me!<br /><span style="color:#000099;">- All those persons that believed in me, even more than myself </span><br /><div align="justify"></div><br /><div align="justify">Thank you all! Regards.</div><div align="justify"><br /></div></span></div></span>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com7tag:blogger.com,1999:blog-8944073588702789702.post-31182865919196129062012-03-18T20:15:00.008+00:002012-03-18T20:27:23.136+00:00BI Session – First Look to SSIS 2012<div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size:85%;">The day after...<br />The SQL Saturdays #115 that held in Portugal yesterday at Universidade Autónoma de Lisboa was in my perspective a fantastic conference. The organization provided by the Portuguese SQL user group SQL Port, was absolutely amazing! Everything worked perfectly and all the small issues raised, were faster resolved by volunteers that has a common passion like me: the SQL Serer. Speaking on the some track of persons that I follow for some years, like Alan Mitchel, Rui Quintino and Andro Moreira was a big honor to me… also, having the room complete on a Saturday at 9h30 AM was a big surprise. I just want to mention a fact that made me a little disappointed… some submitted sessions was not approved and I’m absolutely sure that the conference would be even better with the speakers like Rui Romano, Tiago Moreiras and Tiago Rente. But I understand that it’s impossible to have all speakers in action.<br /><br /></span></div><div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size:85%;">I've submitted two sessions about SSIS 2012, but just one session was approved by the organization. It were understandable but forced me to summarize the two sessions in only one. I was a little fast presenting my session, because my main goal was to provide the first impact to SSIS 2012 and cover the most new features and improvements to the attendees. I think almost attendees got the overall vision about this new version and I have no doubts that they will now go into deep detail on the new features and improvements they think more usefully.<br /><br /></span></div><div style="text-align: justify; "><span class="Apple-style-span" style="font-weight: normal; "><span style="font-size: 85%; ">I've included below my session slides presentation that I hope you enjoy and can share some feedback with me. As I already wrote on this blog, I’m finishing the <a href="http://pedrocgd.blogspot.pt/2012/03/bi-book-ssis-2012-integration-services.html">book on the SSIS 2012</a> version and I hope you could help me to continue writing on the future about subjects I love!</span><br /></span><div style="font-weight: normal; font-size: 100%; width: 425px; " id="__ss_12056515"><object id="__sse12056515" width="425" height="355"><param name="movie" value="http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=sqlsaturday115firstlooktossis2012en-120318150107-phpapp02&stripped_title=first-look-to-ssis-2012&userName=PedroCGD"><param name="allowFullScreen" value="true"><param name="allowScriptAccess" value="always"><param name="wmode" value="transparent"><embed name="__sse12056515" src="http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=sqlsaturday115firstlooktossis2012en-120318150107-phpapp02&stripped_title=first-look-to-ssis-2012&userName=PedroCGD" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" wmode="transparent" width="425" height="355"></embed></object></div><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><span class="Apple-style-span" style="font-size: 85%; "><b><div style="text-align: justify; "><span class="Apple-style-span" style="font-size: 85%; "><b><br /></b></span></div>A special thanks to the organizers, master BI students, friends, colleagues an all the attendees who chose my session.</b></span><br /></div><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script><script src="http://b.scorecardresearch.com/beacon.js?c1=7&c2=7400849&c3=1&c4=&c5=&c6="></script>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com2tag:blogger.com,1999:blog-8944073588702789702.post-56726734000627539062012-03-11T21:51:00.011+00:002012-03-11T22:22:31.412+00:00BI Conference – SQL Saturdays #115 Portugal 2012<div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size:85%;">Dear Friends,<br />Next Saturday I’ll present a session on SQL Saturdays Portugal! On this session I’ll show the first look to the SQL Integration Services 2012 based <a href="http://3.bp.blogspot.com/-li3sbXSEAxE/T10e7eaeQSI/AAAAAAAABcs/BlqCNOQo88g/s1600/sqlsat115_web.png"><img style="float:right; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 200px; height: 97px;" src="http://3.bp.blogspot.com/-li3sbXSEAxE/T10e7eaeQSI/AAAAAAAABcs/BlqCNOQo88g/s200/sqlsat115_web.png" border="0" alt="" id="BLOGGER_PHOTO_ID_5718761108955611426" /></a>on my last 6 months experiences <a href="http://pedrocgd.blogspot.com/2012/03/bi-book-ssis-2012-integration-services.html">writing a book</a> about it with my friend Reza Rad. We are currently writing the latest chapters and very excited with the updates made to this version. Some of those, are highlighted below: </span><span class="Apple-style-span" style="font-size: 95%; "><br /><b><br /></b></span></div><div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size: 95%; "><b>Legacy and Project deployment Models</b></span><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; "><br />The deployment approach used in the previous version of SSIS is called Legacy Deployment Model and the new one is the Project Deployment Model. If the new approach (Project Deployment Model) is used, almost custom logging made in the legacy deployment mode (previous versions) doesn’t make more sense now. This new approach has an important new SSIS Catalog that automatically logs all package execution activity along with some built-in reports that provide a more intuitive perspective over log activity and performance</span><span class="Apple-style-span" style="font-size: 95%; "><br /><b><br /></b></span></div><div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size: 95%; "><b>Change Data Capture (CDC) tasks and components</b></span><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; "><br />Change Data Capture (CDC) feature was included in SQL 2008 version and provides other possibility to detect change on data under a database. This version include a new CDC task and components to make the life easier for those persons that choose this approach to deal with changed data</span><span class="Apple-style-span" style="font-size: 95%; "><br /><b><br /></b></span></div><div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size: 95%; "><b>SQL Server Data Tools</b></span><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; "><br />The old Business Intelligence Development Studio (BIDS) does not exist anymore. Now is the SQL Server Data Tools (SSDT) and has a very intuitive layout with new tasks and components design and is under the very interesting Visual Studio 2010 environment</span><span class="Apple-style-span" style="font-size: 95%; "><br /><b><br /></b></span></div><div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size: 95%; "><b>Simple and important improvements</b></span><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; "><br />Several simple and important improvements were made. Some examples are the improvement on the variables toolbar, Undo & Redo capabilities, easier way to zoom and several other improvements</span><span class="Apple-style-span" style="font-size: 95%; "><br /><b><br /></b></span></div><div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-size: 95%; "><b>More new features</b></span><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; "><br />In addition to CDC task and components, I should highlight some other new features like: data flow column mapper, the expression task, package parameters, data quality services and several other very interesting features that I’ll highlight on the next weeks!<br /><br /></span></div><div style="font-size: 100%; font-weight: normal; text-align: justify; "><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; ">I hope to see you next Saturday on my session! More details about the conference could be shown <a href="http://www.sqlsaturday.com/viewsession.aspx?sat=115&sessionid=6728">here</a>!<br />I’ll add the slide presentation soon here<br />Just to remember that the book I wrote with Reza is not on <a href="http://pedrocgd.blogspot.com/2012/03/bi-book-ssis-2012-integration-services.html">Pre-Order here</a>! I hope to get feedback from you soon! :-) </span><br /></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-74424395587115908832012-03-07T00:30:00.010+00:002012-03-07T00:42:12.177+00:00BI Tool – SQL Server 2012 Released to Manufacturing<a href="http://www.microsoft.com/sqlserver/en/us/default.aspx"><img style="cursor:pointer; cursor:hand;width: 400px; height: 150px;" src="http://4.bp.blogspot.com/-kye_du69qzE/T1atctP5O3I/AAAAAAAABcQ/VUsA4L-AUew/s400/SQL2012_RTM.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5716947485687626610" /></a><br /><div style="font-size: 100%; text-align: justify; "><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; ">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 <a href="http://pedrocgd.blogspot.com/2012/03/bi-book-ssis-2012-integration-services.html">SSIS book</a> that I’m finishing with my friend Reza rad. For now, I want to highlight the following new updates:</span><br /><span class="Apple-style-span" style="font-size: 95%; "><br /><b>Microsoft SQL Server Data Tools</b><br /></span><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; ">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.<br /><a href="http://msdn.microsoft.com/en-us/data/hh297027">Download SQL Server Data Tools</a><br /></span><span class="Apple-style-span" style="font-size: 95%; "><br /><b>Microsoft SQL Server 2012 Data Mining Add-ins for Office 2010</b><br /></span><span class="Apple-style-span" style="font-weight: normal; font-size: 85%; ">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)<br /><a href="http://www.microsoft.com/download/en/details.aspx?id=29061">Download Data Mining Add-In</a><br /><br />Today, don’t forget to attend the <a href="http://www.sqlserverlaunch.com/ww/Home">SQL Server 2012 Virtual Launch Event</a>, featuring keynotes by Ted Kummert and Quentin Clark and a number of video presentations about SQL Server 2012 by other SQL Server expert. </span><br /></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-35724656949451014472012-03-06T00:11:00.041+00:002012-05-01T02:04:21.022+01:00BI Book – SSIS 2012 Integration Services Book<div style="font-size: 100%; font-weight: normal; text-align: justify;">
<span class="Apple-style-span" style="font-size: 85%;">I've never been so long without writing on the blog. The last months have been very complicated in terms of time, but I promise that I will not be so long time without writing! <a href="http://www.amazon.com/gp/product/184968524X/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=184968524X" target="_blank"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5716578440374296562" src="http://3.bp.blogspot.com/-MTgDsHD5Uj4/T1VdzcUqn_I/AAAAAAAABcE/m2dkOp7q6wU/s200/SSIS2012_Book.png" style="cursor: hand; cursor: pointer; float: right; height: 200px; margin: 0 0 10px 10px; width: 164px;" /></a> The main reason for such a long absence was undoubtedly the book I'm writing since September 2011! Yes…I’m writing a book and you know it now in first hand! This book is focused on the next version of SQL Integration Services (SSIS 2012 version) and is being written with my friend Reza Rad. This book is being reviewed by SSIS world reference professionals Phil Brammer and Rafael Salas that I need to thank for all the feedback they are giving to us!<br /><br />The book is almost complete and has been an incredible challenge for me! It has been an authentic miracle working in a full-time job, teaching at the weekend and still has time to investigate and write a book! I want to thank all the effort that has been made also by Reza Rad (co-author), all reviewers, and especially PacktPub publisher staff. Thanks to Joana, my girlfriend, that always supported and motivated me to take this up until the end and never give up.</span><br />
<i><span class="Apple-style-span" style="color: #000099; font-size: 85%;">Microsoft SQL Server 2012 Integration Services: An Expert Cookbook<br />Reza Rad, Pedro Perfeito<br /><br />"SQL Server Integration Services (SSIS) is a leading tool in the data warehouse industry - used for performing extraction, transformation, and load operations. This book is aligned with the most common methodology associated with SSIS known as Extract Transform and Load (ETL); ETL is responsible for the extraction of data from several sources, their cleansing, customization, and loading into a central repository normally called Data Warehouse or Data Mart.<br /><br />Microsoft SQL Server 2012 Integration Services: An Expert Cookbook covers all the aspects of SSIS 2012 with lots of real-world scenarios to help readers understand usages of SSIS in every environment.<br /><br />Written by two SQL Server MVPs who have in-depth knowledge of SSIS having worked with it for many years. This book starts by creating simple data transfer packages with wizards and illustrates how to create more complex data transfer packages, troubleshoot packages, make robust SSIS packages, and how to boost the performance of data consolidation with SSIS. It then covers data flow transformations and advanced transformations for data cleansing, fuzzy and term extraction in detail. The book then dives deep into making a dynamic package with the help of expressions and variables, and performance tuning and consideration"</span></i><br />
<span class="Apple-style-span" style="font-size: 85%;"><br />Me and reza didn't wrote this book for money, but by the desire of writing about what we like to do. Help us continue to share knowledge with the comunity. The book is now in pre-order and will available soon in several places like <a href="http://www.amazon.com/gp/product/184968524X/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=184968524X" target="_blank">Amazon</a>, Lehmans and in the <a href="http://www.packtpub.com/microsoft-sql-server-2012-integration-services-expert-cookbook/book#overview">PacktPub Publisher Website</a></span></div>
<br />
<div style="font-weight: normal; text-align: center;">
<span style="font-weight: bold;"><a href="http://www.amazon.com/gp/product/184968524X/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=184968524X" target="_blank">Order the Book NOW</a></span></div>
<div style="font-size: 100%; font-weight: normal; text-align: center;">
<span style="color: red; font-size: 100%; font-weight: bold;"><br /></span></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com6tag:blogger.com,1999:blog-8944073588702789702.post-52007290572934910452011-12-15T20:19:00.044+00:002011-12-15T22:12:47.346+00:00BI Certification – Microsoft MCTS 70-448 Exam<div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">Dear friends,</span></div><div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">Yesterday I updated my MCTS-BI certification on SQL 2008 version realizing the 70-448 exam with a 972 score. The score and certificate achievement are not important; what is really important for me is to have one more reason to learn new things or to re-learn old things! Take a look at <a href="http://pedrocgd.blogspot.com/2008/09/bi-certification-microsoft-mcts-70-445.html">my previous experience</a> doing this exam in the previous SQL version (SQL 2005 – exam 70-445)</span></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;"><br /></span></div><div style="text-align: justify;"><span class="Apple-style-span"><b>How did I study?</b></span></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">I spent one day studying hard through the exams provided by the MS Press Training Kit book (written exclusively for this exam) and through the exams provided by uCertify. Both Microsoft Press book and the software provided by uCertify, have very good resources to study and learn into deep detail the subjects required for this exam. The learning method I’ve followed was to read the book on each failed question included in the book and in the uCertify software.</span></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">The well-known dumps not exist here, and I don’t recommend anyone to use it. Using dumps the merit realized on passing on exam does not exist and mainly, you’ll not learn anything! I cannot understand the logic of using dumps and I think Microsoft should do something about it.</span></div><br /><a href="http://3.bp.blogspot.com/-axTis_EGhB8/TupXMnq4XZI/AAAAAAAABbI/MY7-91ff9v4/s1600/TrainingKit0.png" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img style="cursor:pointer; cursor:hand;width: 200px; height: 130px;" src="http://3.bp.blogspot.com/-axTis_EGhB8/TupXMnq4XZI/AAAAAAAABbI/MY7-91ff9v4/s200/TrainingKit0.png" border="0" alt="70-448" id="BLOGGER_PHOTO_ID_5686453353827556754" /></a><a href="http://1.bp.blogspot.com/-9qNZrI8boU0/TupXHKq0KpI/AAAAAAAABa8/xN-Sm_qOFfA/s1600/TrainingKit.png" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img style="cursor:pointer; cursor:hand;width: 200px; height: 130px;" src="http://1.bp.blogspot.com/-9qNZrI8boU0/TupXHKq0KpI/AAAAAAAABa8/xN-Sm_qOFfA/s200/TrainingKit.png" border="0" alt="70-448" id="BLOGGER_PHOTO_ID_5686453260143307410" /></a><br /><br /><div><span class="Apple-style-span"><b>Skills Being Measured</b></span></div><div><span class="Apple-style-span" style="font-size:85%;">Implementing an SSIS Solution (17%)</span></div><div><span class="Apple-style-span" style="font-size:85%;">Configuring, Deploying, and Maintaining SSIS (15%)</span></div><div><span class="Apple-style-span" style="font-size:85% ">Implementing an SSAS Solution (21%)</span></div><div><span class="Apple-style-span" style="font-size:85%;">Configuring, Deploying, and Maintaining SSAS (17%)</span></div><div><span class="Apple-style-span" style="font-size:85%;">Implementing an SSRS Solution (17%)</span></div><div><span class="Apple-style-span" style="font-size:85%;">Configuring, Deploying, and Maintaining SSRS (13%)</span></div><br /><div><b><span class="Apple-style-span">Courses associated with this exam</span></b></div><div><span class="Apple-style-span" style="font-size:85%;">6236A:Implementing and Maintaining SQL 2008 Reporting Services (3 Days)</span></div><div><span class="Apple-style-span" style="font-size:85%;">6235A:Implementing and Maintaining SQL 2008 Integration Services (3 Days)</span></div><div><span class="Apple-style-span" style="font-size:85%;">6234A:Implementing and Maintaining SQL 2008 Analysis Services (3 Days)</span></div><br /><div><span class="Apple-style-span"><b>Key subjects to focus in</b></span></div><div><span class="Apple-style-span" style="font-size:85%;">The following list shows some of the key subjects that I remember from my exam and I consider very important for all those persons that want to learn and do the exam:</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSIS Protection Level Options (about 3 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSIS command-lines DTExec and DTUtil (about 3 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSRS RSConfig and RSReportServer Configuration File (about 4 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSRS Encryption Keys and Configuration tool</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSAS Data Mining (about 1-2 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSAS Processing Options (about 4 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSAS Deployment Wizard and XMLA (XML for Analysis) scripts</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSAS IsAggregate, Usage and AtributeHierarchyEnabled properties</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSAS Roles (about 2 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">SSAS Usage Base Optimization (about 2 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;color:#993399;">MDX Languages (3-4 questions)</span></div><div><span class="Apple-style-span" style="font-size:85%;"><br /></span></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">I think the most questions were focused on SSAS and less on Data Mining. The questions I think many persons will have some difficulty during the exam are configuring a SSIS, SSAS and SSRS Servers that are typical tasks more related with SQL Database Administrators (DBA)… Except in small/middle companies, rarely a BI developer needs to administer a SQL database. Although and based on my last experience helping implementing a critical BI system, some DBA’s issues aroused often, and our team needed to do everything including DBA tasks. For that reason, I am planning to take SQL DBA certification next weeks. But before it I’ll take BI exam 70-452 to update MCTIP BI certification for SQL 2008</span></div><div><br /></div><div><a href="http://4.bp.blogspot.com/-0Ijf_f7ksTY/TupW5WzCZkI/AAAAAAAABaw/hXkAtvHe-lA/s1600/MSFT_BI_PATH.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img style="cursor:pointer; cursor:hand;width: 400px; height: 208px;" src="http://4.bp.blogspot.com/-0Ijf_f7ksTY/TupW5WzCZkI/AAAAAAAABaw/hXkAtvHe-lA/s400/MSFT_BI_PATH.jpg" border="0" alt="BI Microsoft Exams" id="BLOGGER_PHOTO_ID_5686453022880851522" /></a></div><br /><div style="text-align: justify;"><b><span class="Apple-style-span">uCertify Experience</span></b></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">uCertify kindly asked me some weeks ago to try their product on 70-448 exam. I accepted the challenge but in one condition… use it in real for making the exam! The experience was very interesting and <img src="http://2.bp.blogspot.com/-uiVckwXIVok/TupeUf5oOWI/AAAAAAAABbs/WwVIgIWPq_g/s200/uCertify.gif" border="0" alt="uCertify" id="BLOGGER_PHOTO_ID_5686461185762277730" style="float: right; margin-top: 0px; margin-right: 0px; margin-bottom: 10px; margin-left: 10px; cursor: pointer; width: 145px; height: 40px; " /> I changed my opinion about these kinds of products. The uCertify product has several exams to test your skils but also a study helper. The exams are not Dumps and if you want to pass the exam learning, I truly recommend that you invest on this product. If you fail the exam, at the end you’ll spend more money. <a href="http://www.ucertify.com/exams/Microsoft/70-448.html?af=PedroCGD">Visit the uCertify software for this exam</a></span></div></div><br /><a href="http://www.ucertify.com/exams/Microsoft/70-448.html?af=PedroCGD" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><img style="cursor:pointer; cursor:hand;width: 200px; height: 129px;" src="http://3.bp.blogspot.com/-BHoSry7CNDU/TupXgiQEIcI/AAAAAAAABbg/dg-WjxMzWdM/s200/uCertify0.png" border="0" alt="uCertify 70-448" id="BLOGGER_PHOTO_ID_5686453695970288066" /></a><a href="http://www.ucertify.com/exams/Microsoft/70-448.html?af=PedroCGD"><img style="cursor:pointer; cursor:hand;width: 200px; height: 129px;" src="http://4.bp.blogspot.com/-dCOgXDUn5fg/TupXb-9UxpI/AAAAAAAABbU/kZNGyb0DNVo/s200/uCertify.png" href="http://www.ucertify.com/exams/Microsoft/70-448.html?af=PedroCGD" border="0" alt="uCertify 70-448" id="BLOGGER_PHOTO_ID_5686453617776969362" /></a><br /><div style="text-align: justify;"><b>If you plan to invest on uCertify testing software, I can send you a 10% discount voucher</b></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com4tag:blogger.com,1999:blog-8944073588702789702.post-58986375065868467682011-11-08T00:35:00.024+00:002011-11-09T00:39:59.979+00:00BI Graduation – Best student award!<div style="text-align: justify;"><a href="http://pedrocgd.blogspot.com/search/label/UPT%20BI" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><span class="Apple-style-span"><img style="cursor:pointer; cursor:hand;width: 400px; height: 151px;" src="http://4.bp.blogspot.com/-2DuzkY_s5JM/Trh6fIqVt5I/AAAAAAAABak/UumEJox8lUg/s400/2011-11-08%2B00h29_35.jpg" border="0" alt="BI Master" id="BLOGGER_PHOTO_ID_5672418405992740754" /></span></a></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">One more season, one more success!</span></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">This success is merit of the 24 talent student’s with willingness to learn and share their knowledge with everyone. Last week, was held the awards ceremony where congratulations were made to all students for their efforts over the last year especially to Carlos José Monteiro who got the best result. The ceremony was then followed by a final convivial dinner offer by the University. </span></div><div style="text-align: justify;"><a href="http://1.bp.blogspot.com/-WaW7HIoXGLA/Trh6V_RjQqI/AAAAAAAABaY/B0ZOCFi7uCM/s1600/2011-11-08%2B00h28_54.jpg" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><span class="Apple-style-span"><img style="cursor:pointer; cursor:hand;width: 400px; height: 136px;" src="http://1.bp.blogspot.com/-WaW7HIoXGLA/Trh6V_RjQqI/AAAAAAAABaY/B0ZOCFi7uCM/s400/2011-11-08%2B00h28_54.jpg" border="0" alt="Pos-Graduacao BI" id="BLOGGER_PHOTO_ID_5672418248854028962" /></span></a></div><div style="text-align: justify;"><span class="Apple-style-span"><span class="Apple-style-span" style="font-size:85%;">The 3rd edition took off at the same day with 25 students enrolled, which is proof that this graduation is on the right path and is becoming increasingly a national BI reference on this field. This success is far beyond the interest of students who have gone there, but also due to the magnificent organization exists in this University primarily to Filomena Lopes. For my part, I thank the confidence placed on me and it is with great pride that I accepted the invitation to re-join the team of the 3rd edition</span></span></div><div style="text-align: justify;"><span class="Apple-style-span"><br /></span></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">This success has allowed dreaming up with new projects that would make this graduation getting more visibility at national and international levels... One of the main projects for this purpose, is underway and I hope it becomes reality with the students support.</span></div><div style="text-align: justify;"><span class="Apple-style-span"><br /></span></div><div style="text-align: justify;"><span class="Apple-style-span" style="font-size:85%;">Special thanks to the post-graduation partners, which allowed some approximation between “real” and academic world through several seminars and mentoring the students in their final projects</span></div><div style="text-align: justify;"><span class="Apple-style-span"><br /></span></div><div style="text-align: justify;"><a href="http://pedrocgd.blogspot.com/search/label/UPT%20BI" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"></a><a href="http://pedrocgd.blogspot.com/search/label/UPT%20BI" onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}"><span class="Apple-style-span"><img style="cursor:pointer; cursor:hand;width: 400px; height: 105px;" src="http://3.bp.blogspot.com/-MRWdWvBzGJ8/Trh6OaTXRNI/AAAAAAAABaM/ljCrqmhAmqc/s400/2011-11-08%2B00h28_14.jpg" border="0" alt="Mestrado BI" id="BLOGGER_PHOTO_ID_5672418118670435538" /></span></a></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com2tag:blogger.com,1999:blog-8944073588702789702.post-50140429901923817042011-09-23T00:04:00.015+01:002012-05-01T02:27:06.653+01:00BI Book - SQL Server MVP Deep Dives - Volume 2<img alt="SQL MVP Deep Dives" border="0" id="BLOGGER_PHOTO_ID_5655325036010828434" src="http://2.bp.blogspot.com/-7mPY8emL6do/TnvAKDTMcpI/AAAAAAAABZw/z-wDsOrYmmw/s200/delaney_cover150.jpg" style="float: right; height: 187px; margin-bottom: 10px; margin-left: 10px; margin-right: 0px; margin-top: 0px; width: 150px;" /><br />
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-size: 85%;">Dear friends,</span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-size: 85%;">I’m not writing for too much time... almost 2 months! Although we are on summer (usually time for vacations) I was working almost day and night! Yes… it’s true! Too many challenges and few much time to vacations or to write here some posts) One of the challenge was being a co-author of the <a href="http://www.amazon.com/gp/product/1617290475/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=217145&creative=399373&creativeASIN=1617290475" target="_blank">MVP Deep Dives book (2nd Volume)</a>. The book is almost available for sell! See here more details from the chap<span class="Apple-style-span"><span class="Apple-style-span">ter I wrote: “<a href="http://pedrocgd.blogspot.com/2011/06/bi-book-excel-as-bi-front-end-tool.html">Excel as BI FrontEnd tool</a>”.</span></span></span></div>
<div style="font-size: small; text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b><span class="Apple-style-span">Book Description</span></b></div>
<div style="font-size: small; text-align: justify;">
<i><span class="Apple-style-span" style="color: #000099; font-size: 85%;">Individually, each SQL Server MVP possesses an impressive wealth of knowledge and skill. Collectively, the 63 MVPs who contributed to SQL Server MVP Deep Dives, Volume II represent over 1000 years of daily experience in SQL Server administration, development, training, and design. This incredible book captures this expertise and passion in a collection of sixty concise chapters, each handpicked by lead editor Kalen Delaney and section editors Louis Davidson, Greg Low, Brad McGehee, Paul Nielsen, Paul Randal, and Kimberly Tripp, and written by an active SQL Server MVP.</span></i></div>
<div style="font-size: small; text-align: justify;">
<i><span class="Apple-style-span"><br /></span></i></div>
<div style="font-size: small; text-align: justify;">
<i><span class="Apple-style-span" style="color: #000099; font-size: 85%;">This second volume picks up where the first SQL Server MVP Deep Dives leaves off, offering completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques. The chapters fall into five parts, Architecture and Design, Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence</span></i></div>
<div style="font-size: small; text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span class="Apple-style-span"><b>About the Authors</b></span></div>
<div style="font-size: small; text-align: justify;">
<i><span class="Apple-style-span" style="color: #000099; font-size: 85%;">This book includes contributions from 63 SQL Server MVPs. All chapters were selected and edited by Kalen Delaney and section editors Louis Davidson (Architecture and Design), Paul Randaland Kimberly Tripp (Database Administration), Brad McGehee (Performance Tuning), Paul Nielsen (Database Development), and Greg Low (Business Intelligence)</span></i></div>
<div style="font-size: small; text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b><span class="Apple-style-span">Your purchase supports Operation Smile</span></b></div>
<div style="font-size: small; text-align: justify;">
<i><span class="Apple-style-span" style="color: #000099; font-size: 85%;">An international children's medical charity dedicated to healing cleft lip, cleft palate, and other facial deformities through safe and effective surgical care. Every donation can help change a life! Learn more at <a href="http://www.operationsmile.org/">www.operationsmile.org</a> </span></i></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com2tag:blogger.com,1999:blog-8944073588702789702.post-16824464728064275552011-07-26T23:51:00.011+01:002011-07-27T00:03:54.899+01:00BI with US against Moodys<div align="justify"><span style="font-size:85%;">I don’t like to publish this type of videos, but this time I think Moody’s deserve this message just because we are making all the efforts to overcome our problems. I know that almost problems we are currently facing, are the responsibility of the latest government’s, but this time the latest Moody’s downgrade was really an injustice and an attack against Portugal. </span></div><br /><iframe width="400" height="295" src="http://www.youtube.com/embed/eJMLn-SxJvI?fs=1" frameborder="0" allowfullscreen=""></iframe><br /><br /><div align="justify"><span style="font-size:85%;">There's always something good in the bad moments, like many of you that can know now a country called Portugal. Visit us and know this amazing country!</span></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-60828610448225873852011-07-12T23:16:00.005+01:002011-07-12T23:45:01.760+01:00BI Tools - SQL Denali CTP3 Released<div align="justify"><span style="font-size:85%;">Microsoft announced today in the Microsoft Worldwide Partner Conference the release of the Community Technical Preview (CTP 3) of Microsoft SQL Server Code Name “Denali”! I’m really very excited to install and check all the new BI features that I have at very high expectations! The world is moving fast and I hope that all you can stay connected with the future!!!<br /></span><a href="http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/07/12/sql-server-codename-quot-denali-quot-ctp3-including-project-quot-crescent-quot-is-now-publically-available.aspx"><span style="font-size:85%;"><img style="WIDTH: 400px; HEIGHT: 297px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5628599098170883010" border="0" alt="" src="http://4.bp.blogspot.com/-VNJAOcbRlCk/ThzNDuWPO8I/AAAAAAAABZY/DM8aymwigew/s400/Denali_Strategy.JPG" /></span></a><span style="font-size:85%;"><br />Take a look to the keynote presented by Satya Nadell (President of Server and Tools Business Group) to see all the news about Microsoft products, best partners and strategy for the next year<br /></span><a href="http://www.digitalwpc.com/#fbid=OFa1i1KWBqp"><span style="font-size:85%;"><img style="WIDTH: 400px; HEIGHT: 268px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5628599291268612418" border="0" alt="" src="http://2.bp.blogspot.com/-B7UblNiCE9E/ThzNO9sUwUI/AAAAAAAABZg/5e-DaqiRr8U/s400/WPC_02.JPG" /></span></a><br /><span style="font-size:85%;">More details </span><a href="http://blogs.msdn.com/b/sqlrsteamblog/archive/2011/07/12/sql-server-codename-quot-denali-quot-ctp3-including-project-quot-crescent-quot-is-now-publically-available.aspx"><span style="font-size:85%;">here</span></a><span style="font-size:85%;"><br />SQL "Denali" CTP3 </span><a href="https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx"><span style="font-size:85%;">Download</span></a> </div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0tag:blogger.com,1999:blog-8944073588702789702.post-67685503674522150632011-06-29T22:53:00.012+01:002012-05-06T17:00:37.850+01:00BI Book – Excel as BI Front-End Tool<div align="justify">
<span style="font-size: 85%;">I’m very happy to announce that finally I submit the chapter for the next <a href="http://www.amazon.com/gp/product/1617290475/ref=as_li_tf_tl?ie=UTF8&tag=busintblobibl-20&linkCode=as2&camp=217145&creative=399373&creativeASIN=1617290475" target="_blank">MVP Deep Dives Book</a> that I’m a co-author with some other MVP professionals around the world. The book will be published next October and for sure I’ll give you here more news about it.<br /><br />The chapter I wrote, explains the construction of an Excel Dashboard from an IT and Business perspective in a retail sector scenario. It was not intended to explain the best way to create a dashboard for the retail sector, but to describe some tips and tricks for a low-cost dashboard using a familiar tool commonly implemented across organizations: Excel.<br /><br />Excel 2010 seems to be the strongest candidate to be chosen as preferable tool. It's certainly true that Excel 2010 doesn't yet have the design features of some BI Front-End competitors, but the low cost and welcome acceptance from end users are big advantages to it. Naturally, there are huge commercial interests in favour of more robust solutions that generally stand by their promises, but in turn, the return on the investment (ROI) is the question.</span><br />
<a href="http://4.bp.blogspot.com/-JxjephckSLQ/TgufmBKOD0I/AAAAAAAABY0/T8XoSG-bY2A/s1600/Figure08.JPG"><span style="font-size: 85%;"><img alt="Excel Dashboard" border="0" id="BLOGGER_PHOTO_ID_5623764035197341506" src="http://4.bp.blogspot.com/-JxjephckSLQ/TgufmBKOD0I/AAAAAAAABY0/T8XoSG-bY2A/s400/Figure08.JPG" style="cursor: hand; height: 285px; width: 400px;" /></span></a><br />
<span style="font-size: 85%;">The dashboard created along the chapter is shown in the previous figure. I highlight the fact that beyond this dashboard, information is centralized inside an OLAP cube, and the dashboard was created without any line of code! At one hand, you make IT department satisfied (because they still control data quality, data governance…) and at another hand, business has the freedom to create their own dashboards and reports not only through Excel 2010, but also through Report Builder 3.0.<br /><br />All the money from the book sales will be donated to charity. And the organization selected by almost co-authors of this book is the </span><a href="http://www.operationsmile.org/"><span style="font-size: 85%;">Operation Smile</span></a><span style="font-size: 85%;">. I hope you buy this book to learn new things but also to help to make the difference for these children! For those interested in doing more charity work, check out <a href="http://www.socialworkdegree.org/">Social Work Degree.</a></span></div>
<br />
<div align="justify">
<span style="font-size: 85%;"><a href="http://www.operationsmile.org/"><img alt="Operation Smile" border="0" id="BLOGGER_PHOTO_ID_5623763475491303138" src="http://4.bp.blogspot.com/-px2vmRJqW4A/TgufFcF5ruI/AAAAAAAABYs/9BLq8_Vw0Yc/s400/OperationSmile.JPG" style="cursor: hand; height: 227px; width: 400px;" /></a></span><br />
<span style="font-size: 85%;">I'll keep you informed about book published date!</span></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com20tag:blogger.com,1999:blog-8944073588702789702.post-1907008195260154242011-06-22T00:05:00.003+01:002011-06-22T00:13:44.700+01:00BI Tools - Cumulative Update #8 for SQL 2008 R2<div align="justify"><span style="font-size:85%;">Dear Friends,<br />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.<br /><br /><strong>Take a look a the full details here:<br /></strong>CU#8 KB Article: <a href="http://support.microsoft.com/kb/2534352">http://support.microsoft.com/kb/2534352</a><br /><br /><strong>Previous Cumulative Update KB Articles:<br /></strong>CU#7 KB Article: <a href="http://support.microsoft.com/kb/2507770">http://support.microsoft.com/kb/2507770</a><br />CU#6 KB Article: <a href="http://support.microsoft.com/kb/2489376">http://support.microsoft.com/kb/2489376</a><br />CU#5 KB Article: <a href="http://support.microsoft.com/kb/2438347">http://support.microsoft.com/kb/2438347</a><br />CU#4 KB Article: <a href="http://support.microsoft.com/kb/2345451">http://support.microsoft.com/kb/2345451</a><br />CU#3 KB Article: <a href="http://support.microsoft.com/kb/2261464">http://support.microsoft.com/kb/2261464</a><br />CU#2 KB Article: <a href="http://support.microsoft.com/kb/2072493">http://support.microsoft.com/kb/2072493</a><br />CU#1 KB Article: <a href="http://support.microsoft.com/kb/981355">http://support.microsoft.com/kb/981355</a><br /><br /><strong>Follow all Microsoft SQL Server Release Services here:<br /></strong><a href="http://blogs.msdn.com/b/sqlreleaseservices">http://blogs.msdn.com/b/sqlreleaseservices</a> </span></div><br /><div align="justify"></div>Pedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.com0