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 if you register within March 15, 2013. If you are too lazy to click on the previous post, ...

SSDTBI for Visual Studio 2012 enables customers to use the Analysis Services, Integration Services, and Reporting Services project templates within the Visual Studio 2012 shell.  The components are delivered as a web download on the Microsoft Download center and will be available through Web Platform Installer.   This release is the ...

SQL Server Analysis Services (SSAS) Multidimensional (MD) is a great product, and in my opinion it’s still the only real option to go for when building complex enterprise BI solutions. It’s still very fast when implemented correctly and it’s mature and therefore very stable.   The only real downside is cell security, which, in my opinion, is ...

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 2013 April 10-12, 2013 | Chicago, IL – United States This conference is targeted to ...

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 since 2010, wrote several books containing several chapters about DAX and we know that there is ...

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 will also deliver a free session in a community event on March 12 evening: the session is ...

Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but not a Table (see the Table option disabled in the next picture). However, the workaround is to create a connection file and ...

This year is going to end, Maya failed their predictions and while this is bad for predictive industry, it’s also good for all of us! We’ve seen many news in Microsoft BI stack: Excel 2013 has been RTM’d – its General Availability is expected in early 2013 but many early adopters are already using it daily (myself included) PowerPivot and ...

Today at PASS Summit 2012 there have been several announcements during the keynote. Moreover, other news have not been highlighted in the keynote but are equally if not more important for the BI community. Let’s start from the big news in the keynote (other details on SQL Server Blog): Hekaton: this is the codename for in-memory OLTP ...

Next week I and Alberto Ferrari will be in Seattle at PASS Summit 2012. You can meet us at our sessions, at a book signing and hopefully watching some other session during the conference. Here are our appointments: Thursday, November 08, 2012, 10:15 AM - 11:45 AM – Alberto Ferrari – Room 606-607 Querying and Optimizing DAX (BIA-321-S) ...