|
|
|
|
SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus
Browse by Tags
All Tags » Analysis Services (RSS)
-
I received this request in many courses , messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature Read More...
|
-
If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models . This is the Read More...
|
-
One year after the release of SQL Server 2012 I see the growing demand for DAX. There are two reasons for that: an higher number of PowerPivot users started to build more complex data models, and SSAS Tabular is starting to be adopted by a larger number Read More...
|
-
I’ve been interviewed by Greg Low in SQL Down Under show 58, and this is *not* an April fool! We talked for one hour about Tabular, Multidimensional, Data Warehouse and just a little bit about music (you can discover which music genre I’m used to listen…). Read More...
|
-
If you are using Microsoft BI stack and you still didn’t start learning DAX, you should not wait any longer. One of the option you have is starting with one of our books , or you can also attend one of our workshop about Tabular or PowerPivot . But if Read More...
|
-
I recently received a question about the memory required to run a Process Defrag on a Tabular model in Analysis Services. The Process Defrag is useful when you run incremental processing of a table frequently, or when some of the values in the dictionary Read More...
|
-
One month ago I wrote about my sessions at PASS Business Analytics Conference 2013, in Chicago, IL on April 10-12, 2013. If you still have not registered, you can save $200 by using the code BAC228BL and you should hurry up, because there is another discount Read More...
|
-
There is a new whitepaper from Microsoft, Microsoft BI Authentication and Identity Delegation , which describes all the authentication and delegation scenarios with Microsoft BI technologies: Personal BI Scenarios (Excel) Team BI Scenarios (SharePoint) Read More...
|
-
As I mentioned a couple of weeks ago, I and Alberto are starting to travel again, delivering SSAS Tabular Workshop and other free community events around Europe. This is the updated list of our next dates, including community events: Online – SSAS Tabular Read More...
|
-
I and Alberto Ferrari will speak at SQLBits XI (Nottingham, UK – May 2-4, 2013) and there are many good reasons to join us there, especially if you are interested to DAX! Here are our sessions: Thursday, 02 May 2013 – Training Day - From 0 to DAX The Read More...
|
-
DAX offers a set of Time Intelligence functions that simplify writing DAX expressions such as YTD, YOY and other time-related calculations. However, these functions only works when some assumptions are valid: your periods should be “natural” months and Read More...
|
-
A common question I receive is about how to correctly size a server for an Analysis Services Tabular instance. I always answer that an analytical evaluation is partly an empiric process, because there are many variables involved and the simplest approach Read More...
|
-
Spring is a conferences’ season and the upcoming one is no exception. I will be speaking at PASS Business Analytics Conference 2013, which will be the first event this year, so I’d like to spend a few words about my sessions. PASS Business Analytics Conference Read More...
|
-
Are you working with SSAS Tabular? Are you an experienced PowerPivot user? In both cases, you should be aware that there is only one skill that is important for PowerPivot and SSAS Tabular, and it is the DAX language. I and Alberto have been using DAX Read More...
|
-
Spring is coming and we published many dates of SSAS Tabular Workshops around Europe and online. Alberto Ferrari is coming to Aarhus, Denmark , for a 2-day SSAS Tabular Workshop on March 12-13, 2013 (you can see more info and register here ). And Alberto Read More...
|
|
|
|
|
|