This dense hour of presentation will cover design techniques to leverage cube features that also consider possible maintenance of the database structure over time.
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
In this session we will introduce the new modeling capabilities of Vertipaq, showing how the same scenarios can be modeled in both Multidimensional (MOLAP) and Tabular (Vertipaq), looking at how to enable your data warehouse to support both.
In this session you will see how to create a BISM Tabular data model from scratch, providing the required metadata in order to improve user experience navigating the data model by using client tools like Excel PivotTable and Power View.
This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
Explore Power Query features to import data from existing Corporate BI systems.
Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
|
You are probably used to think to FIRSTNONBLANK and LASTNONBLANK as DAX functions related to time-intelligence calculations (usually for semi-additive measures). However, these functions have a syntax and a behavior that can be useful in other scenarios. For example: you might be aware that MIN ...
|
|
In the last two years, I and Alberto Ferrari delivered many courses about Power Pivot, SSAS Tabular, and DAX. We had DAX content in many of the courses, and this created some overlapping and the lack of a clear guidance for studying DAX, regardless of the tool you were using.
With the ...
|
|
I have seen many different types of custom calendars implemented in Power Pivot, Tabular, and DAX. I also wrote several articles (week based calendars and time patterns). However, there is a scenario that is hard to manage with the classical approaches, which I discussed in a new article. Suppose ...
|
|
Less than one year ago I published a pattern about ABC Classification in DAX. Such a pattern was static, so an item (e.g. customer, product) is classified statically when you process a Power Pivot or Tabular model, so filters and slicers querying data do not affect the classification’s results. In ...
|
|
Microsoft recently released a public preview of Power BI Dashboard. This new service is raising interest because of new visualizations and for the openness to developers, thanks to APIs that can be used also for real-time visualizations. Are you interested in Power BI services for your ...
|