Compare different Storage Engines for Semantic Models

About this event

Delivery: In-person Level : Mid to Advanced Food : Pizza and drinks will be provided

Agenda: 18:15-18:30 Registration and networking 18:30-19:00 Organizer and sponsor time (news, Power BI latest, sponsor marketing) 19:00-20:15 Main presentation by Marco Russo 20:15-20:30 Q&A

Overview: Semantic models can store data in several storage engines: VertiPaq (Import), Delta/Parquet (DirectLake), DirectQuery over SQL, and composite models (formerly known as DirectQuery over Analysis Services and Power BI datasets). This session analyzes these different engines, comparing their performance, scalability, and use cases. This knowledge helps you choose the best engine for new semantic models depending on your requirements.

Speaker : Marco Russo

Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services. A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.

Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips.

When he is not working, you can find Marco fine tuning his expertise of Neapolitan pizza or test driving electric cars.

From Atlanta Microsoft Business Intelligence Users