PASS Summit 2014 Day 1 Keynote

I’m sitting on the blogger’s table for the PASS Summit 2014 keynote, and this post is a quick summary of all of the BI-related announcements (minor and hopefully major) made this year. The really interesting developments will get their own, dedicated blog posts later…

  • Azure Machine Learning is now available to everyone with a Microsoft Account ID with no credit card or subscription necessary
  • It was announced (again) that Power BI in the cloud will be able to connect back to on-prem SSAS servers via the Data Management Gateway soon
  • James Phillips, the new guy in charge of MS BI, showed the same – new – Power BI that he showed at WPC this summer. This is not the Power BI that’s released today, but one with a much nicer dashboard experience and one that can be edited (rearrange charts, change chart types, combine two charts into a single combo-chart) directly from the browser.
  • Also in this new Power BI you can connect direct to services like SalesForce or upload Excel spreadsheets direct from the browser – you are building your models in the browser, not in Excel. This is significant for people who don’t have the right version of Excel/Office 365 right now, a very welcome development.
  • And all of this is HTML5, no Silverlight thank goodness. So it will work on far more devices.
  • Public preview of the new Power BI is coming soon!

PASS Summit And Other Speaking And Training Dates

This is just a quick post to advertise some upcoming speaking and training dates…

PASS Summit

I’ll be at the PASS Summit in Seattle next week, and if you see me around be sure to say hello! I’ll be presenting a deep dive session on MDX scoped assignments at 9:45am on Friday November 7th, and I’ll be signing copies of my new Power Query book on the Apress stand in the exhibition hall at 1pm on Wednesday November 5th.

I will also be live-tweeting (I’m @technitrain on Twitter if you aren’t following me already) and blogging throughout the keynotes each day too. I suspect there will be some big announcements this year – Jen Underwood dropped some hints, and a list of interesting sessions to attend, on her blog last week.

Future Decoded

On Wednesday November 12th I’ll be speaking about Power BI at Microsoft’s Future Decoded event in London, alongside the likes of Jen Stirrup, James Rowland-Jones and assorted celebrities like Professor Brian Cox, Sir Nigel Shadbolt and David Braben (the guy who co-wrote Elite!)

Training in London

There are a whole bunch of new courses up on the Technitrain site, taught by me and various other SQL Server experts (such as James Rowland-Jones, Jamie Thomson, Klaus Aschenbrenner, Andy Leonard and Allan Hirt) from around the world, and covering a wide variety of SQL Server and Microsoft BI topics. There are still places available on my Power Query course on Thursday November 13th if you’re interested in attending.

Training in Aarhus, Denmark

In December I’ll be teaching two one-day courses with my friends at Orange Man in Aarhus in Denmark: an introduction to Power BI on December 3rd and my Power Query course again on December 4th.

Vote James Rowland-Jones For The PASS Board Of Directors

I apologise for two posts in a row on PASS politics, but this will only be a short one and normal service will be resumed soon. If you’re a member of PASS then it’s likely you’ll have received an email allowing you to vote in the PASS Board elections. I’ve just voted for my friend James Rowland-Jones (aka JRJ) and I humbly submit that you should consider doing so too. Here’s why:

  • Although I resigned from SQLBits earlier this year, for a long time I worked alongside him on the SQLBits committee. I know first-hand that he’s intelligent, organised and an experienced manager. His skilful handling of the SQLBits sponsorship portfolio is one of the main reasons why its finances are so healthy and therefore why the conference is so successful.
  • He’s the only European candidate standing and is committed to expanding PASS internationally.
  • He understands the needs of the BI community within PASS.
  • Most importantly he has the diplomatic skills that the job requires. You only have to look at how he has conducted himself in the recent mudslinging over the PASS name-change and the BA conference to know this.

You can read JRJ’s full manifesto here.

Why I Support The PASS Name Change And Its Efforts To Expand Into The BA Community

Unless you take a close interest in the politics of PASS you may have missed the kerfuffle around it changing its name from the “Professional Association of SQL Server” to just PASS a month or so ago. Blog posts from Andy Warren and R. Brian Kelley seem to sum up a lot of people’s feelings. There was a similar outcry on Twitter following an announcement about the way speakers will be selected for next year’s PASS BA Conference. In both cases I read the news when it came out and didn’t give much thought to it, because I agreed with what PASS were doing and I could understand why they were doing it. The strength of feeling these moves stirred up surprised me, and it made me realise that what made perfect sense to me was not so clear-cut to other people in the SQL Server community and needed to be defended – hence this blog post.

Let me start with the name change. I don’t think PASS will ever be anything but a SQL Server-centric organisation, whatever its name. However the definition of what is “SQL Server” and what isn’t has blurred in recent years. You could argue that PASS should confine itself to products that have “SQL Server” in its name, but if you were to apply that rule strictly you’d exclude Azure SQL Database. Aha, you say, that would be silly because the technology behind Azure SQL Database is so closely related to on-prem SQL Server and people who use the former will almost certainly use the latter. But in the same way Power Pivot is SQL Server Analysis Services running inside Excel – it’s more or less the same code base, the development experience is the same, the development team is the same, and the DAX language is identical in both SSAS Tabular and Power Pivot. The SSRS team gave birth to Power View and a lot of MS people closely associated with SSIS now work on Power Query. The worlds of corporate BI and self-service BI are drawing ever closer and soon it will be difficult to say where one starts and the other ends. A lot of SQL Server BI consultants and companies (like me) are now using and building Power BI solutions in addition to the SQL Server BI stack. This is why PASS is right to concern itself with Power BI and self-service BI: it’s a big deal for a lot of PASS community members.

What’s more, Microsoft is working on a number of new product that may have no technological link to SQL Server but will be used and championed by members of the PASS community. Azure Document DB and Azure Machine Learning are two good examples. To me it’s right that PASS takes an interest in these products even if other technical communities do so as well. Anyone with a background in SQL Server – anyone with a background in managing and analysing data with Microsoft’s traditional data platform – will have a natural interest in Microsoft’s new tools for managing and analysing data.

The argument against what’s happening seems to be that it means PASS is no longer focused solely on SQL Server, that it will end up spreading itself too thin. The people making this argument, as far as I can see, are from the DBA side of the SQL Family who equate “SQL Server” with the SQL Server relational database. That’s an easy assumption to make for those who only work with the relational engine. It’s true that “SQL Server” is the name of the relational engine, but “SQL Server” has also meant more than the relational engine for a long time: SQL Server is a suite of tools, and the relational engine is just one part of it. I’ve been a SQL Server MVP for nine years and have almost nothing to do with the relational engine. I started working with OLAP Services with SQL Server 7 and spoke at my first PASS event at (I think) the 2005 PASS European Conference in Munich. I haven’t been involved in the SQL Server community as long as some people, I know, but I feel like I’ve been part of it for long enough for my definition of what “SQL Server” is to carry some weight. As I’ve just argued, SQL Server Analysis Services, the tool that I have worked with for almost all of my professional career, has found a new expression in Power Pivot (even while traditional SSAS still exists) and so I think it is right for PASS to follow me as my career changes. This isn’t PASS losing its focus; this is PASS keeping its focus on what SQL Server has become and what its members are working with. I’m not leaving the world of SQL Server behind. SQL Server itself is changing and I’m changing with it.

Nor do I see any evidence of this stopping PASS from providing support and education for DBAs and those who work exclusively with the relational engine. As the PASS community has grown, as the PASS Summit adds yet more tracks, as other events like SQLBits and SQL Saturdays have taken off, I see that the economies of scale that come from the wider definition of “SQL Server” to include the relational engine and the BI tools have provided even more opportunities for those who are focused on the relational engine alone to learn and grow. Each sub-community may have a smaller slice of the pie, but the pie itself is much larger than it would be if we all went our separate ways.

This brings me on to the topic of the BA Conference. Andy Warren’s assertion, in the blog post I linked to above, that the BA Conference should have been the BI Conference is an opinion I hear repeated a lot and one I disagree with strongly. Before I do get onto that topic, though, I want to be clear that I’m not picking on Andy in particular – I’m engaging with him because he puts his side of the argument in a clear, thoughtful way which I respect (this more recent post is a great example of why I admire him and his thoughts on PASS). Unfortunately this particular discussion risks being turned into a very unpleasant argument, and I hope the PASS Board takes action to stop this happening. Twitter is where this is most obvious: it’s easy to be angry in 140 characters, less easy to have a nuanced debate. The tradition of heckling by certain members of the DBA community on Twitter during PASS Summit keynotes while BI features are announced is something that particularly p*sses me off: I feel like it’s rude and disrespectful to the large number of people in the audience who are interested in these features, and to the people on stage announcing them. Let’s stop this kind of thing, it can only be divisive.

OK, back to the topic of the BA Conference. When it was first announced I wrote a post entitled ”The PASS Business Analytics Conference is not the PASS Business Intelligence Conference” but I think my arguments here need to be clearer. First of all, I do not agree that BI content should be split off from the PASS Summit into its own conference. Some DBAs are not interested in BI; some BI pros like me are not interested in relational engine topics. However we are in the minority. I know from my friends and customers that a lot of people who work in the SQL Server community now deal with both the relational engine and some or all of the BI tools, and having the PASS Summit cover both BI and DBA topics at the same conference makes it appeal to a much wider audience than it would  if it concentrated on just one or the other. Indeed, part of the reason why I felt disappointed with this year’s PASS BA Conference, and why I felt it was a bit of a failure, was because it had fallen into the trap of being a PASS BI Conference.

So why then should PASS have a BA Conference, and why is BA<>BI? Let me give you an example. Last week I ran a private SSAS Tabular/DAX training course for a large company in London. The people on the course were traditional corporate BI developers, smart guys, the kind of people I have worked with all my career. This week I’m going back to the same company to deliver training on Power Pivot, DAX and Power BI to the business analytics team of the same company. A lot of technical topics I’ll be covering will be the same but the people attending will be very different. They are equally smart guys who work outside the IT department, but in close association with the IT department, analysing data to answer business questions. They don’t have the kind of technical background that someone in the IT department might have but they do use many of the same tools and technologies (SSAS as a user; Power Pivot and Power BI; Excel). They ask the business questions and they then work together with the IT guys to find the answer. This is the BA community.

A BA community has always existed within the Microsoft ecosystem, originally around Excel and Access, but with the advent of Power BI and the wider self-service BI and Big Data movements it has grown in size and confidence recently. Evidence of this growth includes the “New Excel” user groups that Rob Collie is involved in organising, and the London Business Analytics User Group that Mark Wilcock organises. Should PASS reach out to this community? Yes, I think so. There is a clear overlap between the technologies that the BI side of the PASS community uses and those that the Microsoft BA community is using. Also, I think the BA community can benefit from the passion, experience and infrastructure built up by PASS. As far as I can see, the BA community is also happy to collaborate and engage with the PASS BI community too. In the past few years I’ve made a lot of new friends in the Excel world, for example Excel MVPs like Bob Phillips, who have this attitude. BI pros and BA pros are now working side by side in the office, so it makes sense that we come together as a professional association.

The BA community is not, however, interested in being swallowed up by an organisation that identifies itself purely with the IT department. It is interested in joining an organisation that has IT focused people as a major component but which also recognises the importance of collaboration between IT and the business to work with data. This is why the PASS name change, and especially a separate BA conference, is important. DBAs will only ever want to attend the PASS Summit. SQL Server generalists, and BI pros, will also want to attend the PASS Summit. Some BI pros will want to attend the BA Conference as well as or maybe instead of the PASS Summit. BA pros will only want to attend the BA Conference. BI pros like me will be presenting on topics like Power BI alongside Excel pros at the BA Conference; this is where the overlap between the existing BI community inside PASS and the new BA community is obvious. There are also a lot of topics such as machine learning, R (which is a big part of Azure Machine Learning as well as a massive topic in its own right), Hadoop and pure Excel that do belong at the BA Conference and do not belong at the PASS Summit.

As I already said, I felt like this year’s second BA Conference was a bit of a step back from the first because it had too much pure BI content. Part of the reason for this was, I suspect, because PASS relied too heavily on its existing speaker community and did not make enough effort reach out to the BA community’s speakers. I believe the PASS Board has come to the same conclusion as me and this is why the BA conference next year will not have an open call for speakers. Brent Ozar did a valiant job of trying to imagine why this has taken place here; he falls a little wide of the mark with his explanation in my opinion, even if he’s dead right that the PASS Board need to make a clear and positive case for why they are doing this. Here’s my take. A large Microsoft BA community undoubtedly exists. There are a number of great speakers out there too, but they are not yet convinced that PASS is serious about engaging with the BA community so they are cautious about investing the time and money to speak at the BA conference. What’s more the economics of the BA community are very different from the economics of the traditional PASS community. In the world of SQL Server there is a virtuous circle that allows someone like me (or Brent, and any number of other well-known speakers and trainers and consultants) to invest our own time and money in attending the PASS Summit, SQLBits and SQL Saturdays and so on because we know that it strengthens the community and therefore benefits our own businesses, which are based on high-rate consultancy and training. I’m not saying that we do this cynically – we are genuinely motivated by a love of the community, it’s just that what benefits the wider community benefits us as well. Unfortunately this virtuous circle does not exist (yet) in the BA community. Potential speakers in the BA community are more likely to be full-time employees, or academics, or people like Mr Excel who make a living from selling their content to a mass market, rather than from a small number of customers who pay high rates. They may not be able to afford the time and money to come and speak, and giving away their content for free at the BA Conference might be detrimental to their business. If PASS is going to make the BA Conference work then it will have to approach these potential speakers individually, convince them that the conference is worth their while to attend, and probably pay travel expenses and maybe also pay them a rate. Let’s not forget that this is normal practice in many other technical communities, and I know that top speakers have in the past been paid quite handsomely to speak at TechEd.

The last thing I want to say is that it could be argued that PASS is changing its name and focus because Microsoft wants it to, and indeed that it depends on Microsoft so much that it has to do Microsoft’s bidding. I don’t accept this argument though. PASS should support the interests of its members regardless of the whims of the marketing folks at Microsoft. My point is that I believe that the changes that PASS has made have been for the right reasons, because they are in the interests of a large number of people like me from the BI pro community who have been part of PASS for a long time. The forces that Microsoft is responding to in the wider world of data are the ones that PASS itself must respond to.

I think this post has gone on for quite long enough, and if you’ve read this far then I’m very grateful. I expect that I’ll provoke yet more debate by what I’ve said here, but I also think it needed to be said because the arguments so far have been one-sided. I don’t pretend to speak for the PASS Board or have any more inside information than anyone else already involved in this discussion. However I do believe that the more we talk about these issues, the more likely we are to understand each other’s points of view and come to some kind of agreement that we are all happy with.

Vote In The PASS Elections!

If you’ve been a member of PASS since before June 13th this year, you’ll have received an email telling you that voting has opened in the PASS Board of Directors Elections. This is a friendly reminder to you to use that vote! Check out the candidates here.

For those of you who (like me) live in Europe, the Middle East or Africa, you should realise that for the first time one seat on the board is reserved for someone from this region. I welcomed this change when it was announced, and even though I was a little disappointed to see that the only EMEA candidates who made it this far are from the UK I still think it’s important that PASS is reaching out beyond its North American heartland.

I cast one of my votes for Jen Stirrup. While I know many of the candidates to a greater or lesser extent, Jen is the one I know best and I have always been impressed with her energy, organisational ability, integrity and vision. I think she would make a great contribution to the Board if she was elected.

PASS Business Analytics Conference Summary

The PASS Business Analytics Conference in Chicago finished yesterday, and because I was there and because I did a fair amount of cheerleading for it (see here and here for example) I wanted to post a few thoughts on how it went.

I’ll be honest and say that I had a few worries before the event. Would anyone want to go? Would the sessions be a repeat of what get on the BI tracks at the PASS Summit and hundreds of other SQL Server conferences? In fact, everything went really, really well. Some of the sessions were quite sparsely attended (though this had nothing to do with the quality of the content – some of the best sessions didn’t get much of an audience) but overall there was a very respectable number of people (1200ish?). I had as many people in my session on OData as I’d get at any other large conference, and it was standing room only in at least one of Marco’s sessions. I also rather liked the fact that it was smaller than the Summit – it made it much easier to meet all the people I wanted to meet. If it carries on for a few years it could easily attract a much larger number of people.

Regarding the content I was particularly pleased because a lot of the topics I’d asked for turned up on the schedule. In fact one thing that struck me (and a few other people said the same thing to me as well) was that this was the first conference I’d been to in a long time where there were sessions that I really wanted to see in every time slot. My favourite session of the whole conference was Marc Smith on NodeXL; anyone that reads my blog knows I’ve been a big fan of NodeXL for a long time, but I learned a lot from this session because it concentrated on the basics of social network analysis rather than the tool itself. This was a prime example of the kind of topic that you simply wouldn’t get at a regular SQL Server conference – it was a business analytics session. Even the more technical presentations, such as the one on HPC Services for Excel, was outside the usual boundaries of SQL Server BI. Incidentally, I must get round to playing with HPC Services for Excel – you could use it to parallelise some DAX calculations, or even to batch process large numbers of PowerPivot models on desktop machines overnight…

So, in summary, the conference was a big success and I had a great time. I’ll definitely be going back next year. And did I mention that I got to meet Steven Levitt of Freakonomics fame?

SQLBits and PASS Business Analytics Conference News

I’m going to be speaking at quite a few conferences this year (I’ll blog about them all soon once they’re confirmed) but I thought I’d post something quickly about the two big events in the first half of this year that I’ll be going to.

First of all, registration for SQLBits XI, which will be taking place on May 2nd-4th in Nottingham, UK, is now open. You can find all the details here:
SQLBits is the largest SQL Server conference in Europe and a must-attend if you’re serious about SQL Server (but then I would say that – I’m one of the organisers). We’ve attracted some big names to come and speak this time: just take a look at the precons and the sessions that have been submitted. There will also be some Robin Hood-themed fun, so don’t forget your bow and arrows!

I’ll also be speaking at the PASS Business Analytics Conference in Chicago in April. Again, there’s a great line-up of sessions plus a keynote from Steven Levitt of Freakonomics fame; you can get an idea of what’s going to be presented by attending the Business Analytics 24 Hours of PASS on January 30th. Also, if you use the following code during registration:
You’ll get a $150 discount on the conference rate!
Unfortunately if you’ve already registered the discount can’t be applied retrospectively…

%d bloggers like this: