BI Blog -

BI Education - Post-Graduation in BI

The current Business Intelligence (BI) post-graduation degree at Universidade Portucalense (UPT) is near the end, and the next edition, as is typical in a well-organized institution like UPT, is already being prepared. According to the students, the current...

Published 07-15-2010 0:20 by PedroCGD

Filed under: BI, pos-gradução em BI, Universidade Portucalense

BI Interview – Donald Farmer BI Perspective

Today I want to share an amazing interview done by my friend Ella Maschiach’s with the “father” of Microsoft Business Intelligence… Mr. Donald Farmer. He’s responsible for the new amazing Microsoft products like Power Pivot...

Published 06-19-2010 20:21 by PedroCGD

Filed under: Donald farmer, BI, Power Pivot, Sharepoint 2010

Yes we can! Yes we can see Donald Farmer in Portugal!

For many years I have been following Donald Farmer work in Business Intelligence, mainly in Data Mining. Now and thanks to Microsoft Portugal we can see and make some questions to him in the first person. "What do medieval archaeology, fish farming...

Published 03-24-2010 21:15 by PedroCGD

Filed under: Data Mining, Donald farmer

BI Tools - First Look to Excel 2010

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

Published 12-19-2009 22:56 by PedroCGD

Filed under: Slicers, Excel 2010, Sparklines

StepByStep - SSIS Calling a WebService with Web Service Task

Dear friends, I'm back again and with a new StepByStep paper. This paper focus on a way to call a Web Service from a SSIS package. There is lot of issues relating to this subject and I decided to publish about it... I hope this can help you. Please...

Published 11-30-2009 19:09 by PedroCGD

Filed under: SSIS, StepByStep, XML Task, Web Service Task

BI Certifications - CBIP/TDWI Certifications done!

I started writing this post on the return trip to Portugal. It was a very enriching and experience trip, which I reached one more objective I had in mind for more than two years. I passed the four exams and got the specialization in Business Analytics...

Published 11-13-2009 0:20 by PedroCGD

Filed under: CBIP, TDWI, Certifications, BI Exams

BI Tools - SQL Server 2008 R2 CTP version Announcement

Today I finally received an e-mail from Microsoft announcing the release of the CTP version (Community Technology Preview) for SQL 2008 R2 ... and I'm really excited to take the first look and for sure tomorrow I’ll download it ... I'm still...

Published 08-11-2009 0:29 by PedroCGD

Filed under: SQL 2008 2008 R2, BI news

StepByStep - SSIS Extract data from multiple Excel worksheets

Scenario Every month a company receive customers data from an excel file to extract and load data into company data warehouse. In brief, is required to extract data from a single excel file with multiple worksheets with same schema into a single destination...

Published 08-06-2009 12:22 by PedroCGD

Filed under: SSIS, Scrip Component Source, Excel Source, Foreach Loop, StepByStep

SQL2008 - Cumulative Updates

Microsoft released last week new updates for the recent SQL Server 2008 edition. Check links below and don't forget to maintain your SQL Server updated. Cumulative Update #3 for SQL Server 2008 SP1 Cumulative Update #6 for SQL Server 2008 RTM regards...

Published 07-26-2009 22:23 by PedroCGD

Filed under: SQL 2008, Cumulative packages

BI SSAS - What is an OLAP cube?

I was answering some questions at Experts-Exchange website and found an interesting question with an even more interesting, simple and objective answer wrote by Josh. I did not resist to share with you… could be very intuitive for the beginners…...

Published 06-04-2009 17:44 by PedroCGD

Filed under: SSAS, cube

BI Events - Tech Ed 2009, SQL Server 2008 R2

Last year Microsoft shared information about Kilimanjaro at the company’s second annual Business Intelligence Conference, which kicked off on October 6 in Seattle. Kilimanjaro is set to include self-service analysis tools (codenamed “Gemini”...

Published 05-17-2009 20:12 by PedroCGD

Filed under: BI Events, SQL 2008 R2

BI Concepts - SQLBI Methodology

I could not talk about business intelligence and Microsoft tools not mentioning Marco Russo and Albert Ferrari. Both have contributed greatly to help simplify complex problems in architecture and methodologies for complex problems. The discussion was...

Published 05-16-2009 0:18 by PedroCGD

Filed under: BI Methodology, BI Architecture, SQLbi, SSAS

StepByStep - SSIS Moving huge amount of files

Scenario You have a huge amount of files in a file system folder and you need to move the new or modified files to another location. This example could be applied to several other scenarios, like reading data for some specific file (depending on file...

Published 05-14-2009 17:09 by PedroCGD

Filed under: SSIS, For Each Loop, Scrip Task, StepByStep

StepByStep - SSIS Using Package Configurations

Dear friends, Today I’ll add to the community a new type of post, a StepByStep post, based on the support that I usually provide to users from MSDN Forums and Experts-Exchange… some real examples and real scenarios from real world. I'm...

Published 05-13-2009 17:11 by PedroCGD

Filed under: Package Configurations, SSIS, StepByStep

TDWI European Conference (Munich/June2009)

TDWI will present next June, the European Conference held in Munich. For those who have ability or financial support from their companies (as are several that will be the sponsor) is without doubt an event not to be missed ... surely the best speakers...

Published 05-12-2009 0:26 by PedroCGD

Filed under: CBIP, TDWI, Conferences

BI Blog

Syndication

Recent Posts

Tags

Archives