Best practices in modelling Power pivot.
Duration: 60 minutes
Track: Business Intelligence
Power pivot in Excel or SQL server have quite similar in user interfaces. Power pivot in SQL server has a lot more to offer, which you, as Excel user, will like. You prototype in Excel Power pivot, while bearing in mind you want to port your Excel power pivot model to SQL server Power pivot. There are best practices you should stick to in order to port without problems. This session will discuss the advantage and disadvantages of porting your Excel Power pivot model to SQL. After that the best practices in using formula, structuring Power pivot models and even before that how to look at your data will be showed.