Speaking Kick Off 2016 – Slow start!
On Monday 23rd, I will be speaking at the Microsoft Business Intelligence Professionals, Denmark [MsBIP] user Group meeting. It’s been about two years since I was the host of one such meeting, while I was at Maersk Line. This time it’s at the new Microsoft HQ in Lyngby – And it will be my first visit there.
This will also be my first public talk this year.
The MsBIP User Group, is a community group dedicated to share information about Microsoft BI technologies, such as:
- SQL Server (DB, SSAS, SSIS, SSRS, MDS, DQS)
- SharePoint (PPS, Excel, SSRS…)
- Excel og Power BI (PowerPivot, Power View, Power Query, Power Map)
- 3. Party Products
The User Group is also part of the Microsoft Power BI User Group Program.
There will be two talks at this session:
Time Intelligence is probably the most interesting feature of any analytical solution. Computing Year To Date, Month To Date, Same Period Previous Year is quite easy in DAX but, as soon as the customer requests for time intelligence require working days evaluation, complex and custom calendar shapes, seasonal pattern recognition, the DAX formulas start to be harder to write.
In this session we are going to show how to compute classical time intelligence with the built-in DAX functions. Then, we will show some more complex time intelligence formulas that require to think out of the box, using advanced data modeling and querying techniques to produce interesting and useful formulas.
Getting the techniques in your tool belt right, makes a world of a difference. Did you ever wonder, how to deploy a cube, with minimum impact to query performance? Or how to optimize processing performance? Are you really ready to deploy when its required? Or do you get nervous every time?
Attend this session to build and improve your SSAS Developer skills, by exploring:
- Custom Assemblies – To improve Query Performance
- Partitioning – To improve Processing Performance
- Unit Testing – To improve Cube Release Quality
- Synchronization – To improve End User Experience
- PowerShell to tie all the ends together
My session will be presented for the first time at this event, and I hope you will join me for some SSAS Fun. Seating is limited to 50, or so I heard.