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.
August 23rd will be the day I speak publicly for the first time. The sorry crowd will be members of the Microsoft BI Professionals Denmark User Group, in short MSBIP. See more at http://msbip.dk/ or http://www.linkedin.com/groups?gid=4069528&trk=hb_side_g
I will be speaking about how to create a custom assembly, in order to use the power of the relational engine knitted into MDX. I will be taking the information described in this blog post here, and combine it with the bloated version of AdventureWorks, thanks to Bob Duffy (blog|twitter), in order to get some critical mass to display the advantages.
Yesterday I attended the second meeting in the newly started LinkedIn group called MsBIP (Microsoft BI Professionals Denmark). I was anxious to find out who would show up, what would the agenda be and what level of knowledge would be on display.
I can honestly say that I was not disappointed in any way. The meeting was held at Microsoft’s premises in Hellerup, and offered very nice accommodation in regards of fruit, coffee, beverages etc.
First man on the stand was Thomas Skytte Damø ( LinkedIn – Twitter ) who gave a thorough introduction to all, well not all, new features of SQL Server 2012. Thomas did some demos along the way to show some of the new cool stuff coming from Redmond early next year. Thomas was granted extra time, to show more features, on behalf of Just Blindbæk ( Blog – Twitter ).
After a short break and some more of Thomas’s demos, Just took over for a very quick introduction on SSAS Performance Testing (not Tuning). Just showed just how easy it is to create a baseline and what tools would help in this regard. See Just’s blog entry on the subject: link
All in all I left the with the feeling, that I was definitely going to the next meeting. Maybe even presenting some AMO tricks or maybe some topic will present itself on future meetings.
Only negative remark would be that every other meeting is held in Aarhus, and meetings are two months apart, which leaves a four month gap between meetings…But I’m definitely there next time!