We solve complex problems of data modeling and develop tools and solutions to let business perform best through data analysis.

Alberto Ferrari

 

Alberto Ferrari is a Business Intelligence consultant. He shares his interests in two main areas: methodological approach to the BI development lifecycle and performance tuning of ETL and SQL code. His main activities are with SSIS and SSAS for the bank, manufacturing and statistical areas. He is also a speaker in international conferences like European PASS Conference and PASS Summit.
 
 

Books in English

Conferences

Alberto has been a speaker at several conferences since 2005. The most relevant in the last years are:
  • Microsoft SQL Server & Business Intelligence Conference 2009 (April 1-2, 2009 – Milano)
    • SQLBI Methodology: how to model a BI solution
    • Implementing Slowly Changing Dimensions
  • European PASS Conference 2009 (April 23-24, 2009 – Neuss, Germany)
    • SQLBI Methodology: how to model a BI solution
    • Implementing Slowly Changing Dimensions
    • Automating Partition Management in SSAS
  • Microsoft Virtualization Conference 2009 (September 22-23, 2009 – Milano, Italy)
    • SQL Server performance in virtual machines: OLTP vs OLAP
  • Microsoft Tech Days 2009 (November 24-26, 2009 – Milano, Italy)
    • SQLBI Methodology: how to model a BI solution
  • PASS Summit 2009 (November 2-5, 2009 – Seattle, USA)
    • SQLBI Methodology: how to model a BI solution

Other info

Alberto helped several software houses to build complex BI solutions, from the OLTP to the final OLAP cubes, providing planning hints all over the development lifecycle. In 2006 he started to write SSIS custom components (one of which is TableDifference) to get better performance for ETL code.