Advanced Customer Analysis in Power Pivot using DAX
Since ever the goal of BI solutions was to deliver insights on business process and do further
analysis on top of this data. One of the most common analysis thereby always was and still is customer analysis. With the release of Power BI this does not require any server-side solutions anymore but can be done directly in Excel using Power BI tools foremost Power Pivot. This session will show straight forward approaches how typical customer analysis like basket analysis, ABC analysis and many others can be implemented in Power Pivot using DAX very easily. One main focus is also to demonstrate how simply rephrasing business cases can be used to better understand how specific problems can be solved in the tabular world of Power Pivot and Analysis Services.
Sorry, there are no downloads available for this session.
I have been working with Microsoft BI tools since mid 2006 thereby mainly focusing on Microsoft SQL Server and its components, primary Analysis Services. In 2012 I achieved the SSAS Maestro certification and also received the Microsoft Community Contributor (MCC) award the second time in a row. With the release of SQL Server 2012 and Power BI I started shifting my focus towards there, especially to Power Pivot and DAX thereby also investigating into SSAS Tabular Models in detail. At about the same time I did my first steps with Windows Azure while trying to combine it with the other technologies I am by now already very familiar with.
The video is not available to view online.