Nu är det dags igen för SQLUG träff i Stockholm igen! Denna gång har vi återigen fått hit den mycket välkända SQL Server specialisten och MVP, Alberto Ferrari.
Han kommer denna gång att prata om erfarenheter av DAX i verkligheten
Plats: Citykonferensen, Malmskillnadsgatan 46, Stockholm
Tid: 11/6 kl 18.30 - 20.00
Obs! Obligatorisk anmälan. Begränsat antal platser.
The presentation will be held in English.
DAX FROM THE FIELD: REAL-WORLD CASE STUDIES
The Data Analysis Expressions (DAX) formula language is still relatively new to many BI practitioners. But with more than 4 years under its belt now, it is proving its value every day – including in large installations that push the xVelocity in-memory engine to its limit. In this session, we will dive into lessons from the field, where real customers are using DAX to solve complex problems well beyond the Adventure Works scenarios.
How do you make a database fit in memory if it doesn’t fit? How do you handle billions of rows with a complex calculation? Can you perform reporting in any time zone, with time intelligence, efficiently? What tools can you use to benchmark and choose the right hardware? How do you scale up performance on both small and large databases? What are the common mistakes in DAX formulas that might cause performance bottlenecks?
These are just a few questions we will answer by looking at best practices that are working for real customers. Don’t miss this session to learn efficient DAX solutions and how far you can push the limits of the system.
Alberto Ferrari bio:
Alberto Ferrari is a Business Intelligence consultant based in Italy. His competency ranges over the whole Microsoft BI stack: SSIS, SSAS, PowerPivot, Data Modeling.
His main interests are in BI development lifecycle methodologies and in the data modeling and performance tuning of large BI solutions, ranging from the ETL phase up to the most intricate MDX and DAX code development.
He worked for many software houses, helping them to take important decisions about the data model for complex data warehouse and for end users in the banking, manufacturing and statistical sectors.
He is also a speaker in international conferences like PASS, SqlBits, TechEd and a book author, having coauthored "Expert Cube Development with SSAS 2008" and "Microsoft PowerPivot for Excel 2010: Give Your Data Meaning". He is a certified SSAS Maestro and has been awarded MVP.