Blogs

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

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

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

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

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

A little bit late I know , but now in english,. Thanks for the "heads up" Pedro. Anyway, here it is, all the materials I've used on the DevDays session.Notes of interest: Report/Dashboard that shows the mdx trace log, properly organized...

Este é o meu primeiro artigo nesta comunidade BI sendo um pouco uma introdução, e como tal, gostaria antes de mais, desejar que seja um ponto de encontro para todos os estudantes, professores e profissionais na área de BI,...

Nigel Pedse of the The Olap Report has posted a commentary on Project Gemini: http://www.olapreport.com/Comment_Gemini.htm He also has posted a preview review of Gemini (available to subscribers).