Search results matching tags 'SSAS', 'PowePivot', and 'Analysis Services'

Advanced DAX course in May - unique date in 1H 2013 #dax #tabular #ssas #powerpivot

sqlbi — Mon, 22 Apr 2013 08:55:00 GMT

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 of companies, with and without a previous experience on former versions of Analysis Services.

For this reasons we decided to offer a first public edition of our Advanced DAX Workshop, a training on DAX that is aimed at Advanced PowerPivot users and Analysis Services developers that want to master the DAX language. Up to now, we offered this course only for private classes, because of the limited demand, but now there is enough interest and adoption to justify an open class.

The goal of this DAX training is learning to write DAX expressions for measures and calculated columns, DAX queries for reporting needs, read DAX query plans and optimize DAX formulas. The course is a three-day workshop that includes many hands-on lab sessions, with exercises that will guide you in the learning process of the more advanced DAX concepts, enabling you to master the writing of DAX code.

The course will be in London on May 13-15, 2013. There are direct flights with a huge number of countries and cities, also outside of Europe. We do not expect to deliver other editions of this course before other 5-6 months, so don’t lose the chance to attend this intensive DAX master course. I will be the teacher in this edition and Chris Webb will assist me in organization with Technitrain. So don’t wait, early bird discount will expire in a few days, register now and join us in London!

Interviewed in SQL Down Under podcast #sqlserver #ssas #powerpivot

sqlbi — Mon, 01 Apr 2013 18:03:00 GMT

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…).

You can hear this interview from the SQL Down Under Show 58 page (it is an MP3 format) and if you like it there are many other past shows available. The PodCast is also available on iTunes and you can hear other podcasts in SQL Down Under page on iTunes Preview.

End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI

sqlbi — Thu, 27 Dec 2012 18:26:38 GMT

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 Power View are both integrated in Excel 2013 and I think that they are the most compelling reason to upgrade your Excel. Power View alone worth the effort
SQL Server 2012 has been released and I’m seeing the first SSAS Tabular projects going in production in these days.
I, Alberto and Chris published the book Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model, which has good reviews and is selling well. It’s clear that the interest is high in this new technology for Corporate BI
We also run several SSAS Tabular Workshops, many sessions about Tabular topics in conferences and user groups.
I stopped writing blogs/article in the last weeks, but don’t worry, it’s just that I and Alberto are just writing another book…
We recorded several videos about DAX for Project Botticelli and we’ll enhance this library in 2013.

So what’s next in 2013? Let’s see some anticipations and personal predictions:

SharePoint 2013 and Office 365 are going to further innovate Self-Service BI. Maybe that this process is not so fast as Microsoft hopes, but it’s a clear direction and I hope that new features in this area will appear with a sooner release cycle, we simply cannot wait other 3 years to get more features on the cloud.
Mobile BI with Microsoft Technologies is going to be a real thing in 2013. And Office for iPad should be real, too. Power View for iPad as a native application is also another important step.
I will speak at PASS BA Conference 2013 in Chicago, IL (April 10-12, 2013) – at that time, I hope much of the MS Mobile BI tools will be available to anyone.
In March 2013 our new PowerPivot book Microsoft Excel 2013: Building Data Models with PowerPivot will be published by Microsoft Press. We are working hard these days in order to complete the drafts, we listened to all of the feedback we received, especially from Excel users. Time will tell if we did a good job on that.
We will publish other content on SQLBI web site and we have some interesting news for PowerPivot users and Tabular developers… but it’s too early to discuss that. Just stay tuned! Why not registering to our newsletter? (hint – scroll down to the end of the page to insert your email)
We will announce a new PowerPivot Workshop for Excel 2013 (we are working on an updated web site – it should be ready by the end of January)
In January we will announce new dates for our SSAS Tabular Workshop and the new DAX Advanced Workshop.
I hope DAXMD will be released this year, it is already available as CTP. If you create canned reports for SSAS Multidimensional, consider using DAX as a query language when DAXMD will be released.
DAX will be always more important…

Economy is not going well in many countries, and I’ve seen this impacting also our ecosystem. Sometimes you might think that your efforts are worthless, but in the long term the investments in updating skills produces a good return, at both company and individual level. Don’t give up!

I wish you a Great 2013!

Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

sqlbi — Tue, 19 Jul 2011 07:24:00 GMT

If you have 30 seconds available, please vote the following items on Connect:

https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot

When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in the query generated by the query designer. There is a possible workaround, creating a calculated measure with an MDX expression which return the attribute key value corresponding to the current member of the related attribute, but not many users are able to do that.

https://connect.microsoft.com/SQLServer/feedback/details/679677/ragged-hierarchies-cannot-be-imported-in-powerpivot-tabular

When you import data coming from an Analysis Services cube in PowerPivot, you cannot import a ragged hierarchy. I've already described this issue in an older post.

The reason I ask your support is that in Denali CTP3 both PowerPivot and BIDS for Tabular projects has these issues. It really hurts PowerPivot end users, but it is also a waste of time for the experienced BI developer, who need to write a calculated measure in MDX for each attribute key he wants to import it using the query designer (writing MDX by hand is always the preferred alternative, I know) and have to write an MDX query by hand if the levels in the ragged hierarchy are not exposed as browsable attributes (which is not a best practice in cube design!).

Help me to rais the priority for this issues - A multidimensional model in Analysis Services should be a better data source for PowerPivot and BISM Tabular!

#BISM Introduction and #PowerPivot Advanced Data Modeling #sqlbits video available

sqlbi — Sat, 28 May 2011 16:16:52 GMT

As Chris announced in his blog, some of the sessions from the SQLBits 8 in Brighton are already available (for free!).

Yesterday I watched more than half of my BISM Introduction session just to check that no NDA was broken. And, believe it or not, the session had to be really “balanced” in order to not disclose anything of the news announced at TechEd but at the same time I wanted to avoid giving a completely different message. I think that the result is good enough. You just have to replace “BISM Tabular Model” wherever I mentioned “BISM” and with this simple hotfix you can still watch a fresh content!

Also the PowerPivot Advanced Data Modeling session from Alberto Ferrari is available. If you never joined us in a PowerPivot Workshop, take a look at the Alberto’s session. We are just scratching the surface of the innovations in data modeling patterns opened by PowerPivot/Vertipaq usage. We are working on extending these patterns these days and I have to say it is challenging and rewarding to find new solutions to old problems offered by this new tool.

I hope to see other videos available soon, in particular my session about SSAS best practices… I’ll write a new blog post as soon as it is available.