Marco Russo (firstname.lastname@example.org) is a founder of SQLBI.COM. He provides consultancy and training on Business Intelligence, with a particular specialization in the Microsoft Technologies related to BI. He has written several papers about these topics, with a particular mention for "SQLBI Methodology," which is a complete methodology for designing and implementing the back-end of a BI solution (from OLTP to OLAP cubes through Data Warehouse and Data Marts) using the Microsoft BI stack of technologies, and "The Many-to-Many Revolution," which is a paper dedicated to modeling patterns using many-to-many dimension relationships in Analysis Services.
In 2009, he has co-authored Expert Cube Development with Microsoft SQL Server 2008 Analysis Services, which is considered an important set of guidelines and best practices for using Microsoft Analysis Services in the real world.
He also wrote several books for .NET development, in Italian and English language.
Marco is also regular speakers at major international conferences about Microsoft SQL Server PowerPivot for Excel, Microsoft SQL Server Analysis Services, and .NET Framework development.
I recently read the blog post from James Serra Tabular model: Not ready for prime time? (read also the comments because there are discussions about a few points raised by James) and the following post from Christian Wade Multidimensional or Tabular. In the last 2 years I worked with many… read more
You can use the USERELATIONSHIP function in DAX to apply a non-active relationship in a particular DAX calculation. This approach is usually simple in a measure (just use USERELATIOSHIP in one of the filter arguments of CALCULATE) but as soon as you try using it in a calculated column, you… read more
I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock for every day and every product, creating a table that in certain business is huge and expensive,… read more
"I learned a lot from this book about all the different types of programs and ways you can use this very useful data program."
--Stephaine Szostak, cybertron reviews
"Keep this baby close by. You'll be looking in it every eleven seconds."
--Jenilee, Kick Ass Book Reviews
"I would recommend this book to those who have to handle business analysis but are not looking for an extensive business intelligence solution."
--Susan Donnelly, eJournal of the Tucson Computer Society, March 2011, Volume 29, Number 3
"Authors Paolo Pialorsi and Marco Russo, have done an outstanding job of writing a book that covers Language Integrated Query (LINQ) both deeply and widely."
--John Vacca, Amazon.com