In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the Business Intelligence Semantic Model (BISM). BISM also includes the multidimensional model (formally called the UDM). The Tabular model is based on concepts like tables and relationships that are...
Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles. There is a lot of confusion on what is the best tool to use...
Version 2 of PowerPivot ( download ) is being made available with SQL Server 2012. There are many new features, and my top 5 are: Diagram View – Instead of looking at the defined relationships in a list format, v2 allows you to view the relationships in a diagram. This makes it much easier to view...
SQL Server 2008 R2 has opened gates for endless opportunities for Organisations & Developers to take advantage of newest technologies. I'm getting to know these new features such as PowerPivot Features , the technical documentation refers that PowerPivot workbooks are like Excel workbook (.xslx...
Waking up early morning for a technical webinar is so not me (I really love to have my sleep in the morning!); but then I was very interested in the PowerPivot webinar which was going to be taken by Rupesh Patric (Microsoft Partner Technical Consultant and an accomplished artist ) exclusively for people...
I gave a presentation on power pivot and its new features today. I discussed about various capabilities of power pivot including DAX and Slicers. I showed demo on "creating a power pivot model" and "enabling data refresh inside Share Point". It all went well, people were asking questions...
Tuesday, March 16, 2010 9:30 AM Pacific Time (US & Canada) Attend this webcast to learn how Microsoft IT is deploying PowerPivot as a service for Microsoft in collaboration with the Microsoft SQL Server Customer Advisory Team (SQLCAT) team. We share best practices for technical architecture, configurations...
In SSAS, one of the major challenge is processing time of dimensions and facts and there are many factors which may contribute to processing time. Dimension is one of the primary entities associated in SSAS eco-system. And while deploying the cube structure, first the entities of a cube are processed...