Monday, March 25, 2013

BIG DATA – Just one more buzzword?

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.
 

Monday, March 4, 2013

MSIAD - Agile DW and ETL design


It’s a big honor to have two amazing DW and ETL gurus in Portugal (Lawrence Corr 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 the best book I ever read! 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).


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)


Lawrence Corr 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


Joe Caserta 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

Sunday, February 17, 2013

BI Events - Oporto BizTalk Innovation Day











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

Join this five MVPs (Microsoft Most Valuable Professionals) and most active community members for a remarkable community event.

Read more here!

Saturday, February 9, 2013

BI Paper - SSIS Extract Data Multiple Worksheets

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.

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

I hope this paper could be useful

Saturday, January 5, 2013

2012 Review

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

The most important project of my life and the first smile:

The most amazing city of the world: Porto


The book














... and he company I currently work and the event I organized in Porto

I promise that I'll write more often! 
I have several projects in mind to share with you all.
Pedro

LinkWithin

Related Posts Plugin for WordPress, Blogger...