Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Archive for the ‘PASS’ Category

Vote James Rowland-Jones For The PASS Board Of Directors

with one comment

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.

Written by Chris Webb

September 24, 2014 at 9:46 pm

Posted in PASS

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

with 27 comments

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.

Written by Chris Webb

September 22, 2014 at 11:06 am

Posted in PASS

Vote In The PASS Elections!

leave a comment »

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.

Written by Chris Webb

September 26, 2013 at 10:03 pm

Posted in PASS

PASS Business Analytics Conference Summary

with 3 comments

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?

Written by Chris Webb

April 14, 2013 at 2:59 am

Posted in Events, PASS

SQLBits and PASS Business Analytics Conference News

leave a comment »

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:
http://sqlbits.com/
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:
BAC521BL
You’ll get a $150 discount on the conference rate!
Unfortunately if you’ve already registered the discount can’t be applied retrospectively…

Written by Chris Webb

January 21, 2013 at 1:50 pm

Posted in Events, PASS

The PASS Business Analytics Conference is not the PASS Business Intelligence Conference!

with 8 comments

The call for speakers for the new PASS Business Analytics Conference (to be held April 10-12 next year in Chicago) is now live here:
http://passbaconference.com/Speakers/CallForSpeakers.aspx

Since I think this conference is a Very Good Thing, and because I’ve been asked to help shape the agenda in an advisory capacity, I thought I’d do a little bit of promotion for it here.

The important thing I’d like to point out is that this is not just a SQL Server BI conference: it covers the whole SQL Server BI stack, certainly, but really it aims to cover any Microsoft technology that can be used for any kind of business analytics. Which other technologies actually get covered depends a lot of who submits sessions but there are no end of possibilities if you think about it. I’d love to see sessions on topics such as F#, Cloud Numerics, Sharepoint, NodeXL, GeoFlow and especially non-BI Excel topics such as array formulas, Solver and techniques like Monte Carlo simulation, for example.

This brings me to the point of this post. Obviously I’d like all the SQL Server BI Pros out there who read my blog to consider submitting a session (or if you can’t travel to Chicago, the call for speakers for SQLBits is open too) and to attend. However what I’d really like is if the SQL Server BI community could reach out to the wider Microsoft Business Analytics community to encourage them to submit sessions and to attend too. This is where your help is needed! Who do you think should be speaking at the PASS BA Conference? Do you know experts outside the realms of SQL Server BI who you could persuade to come? What topics do you think should be covered? If you’ve got any ideas or feedback, please leave a comment…

Written by Chris Webb

December 3, 2012 at 9:35 pm

Posted in BI, PASS

Analysing #SQLPASS Tweets using NodeXL

with 5 comments

I’ve got a large backlog of serious technical blog posts to write but today, since I’m still recovering from my trip to the PASS Summit in Seattle last week, I couldn’t resist going back to my favourite data visualisation tool NodeXL and having some fun with it instead. Anyone that saw the keynotes last week will know that the future of BI is all about analysing data from Twitter – forget about that dull old sales or financial data you used to use on your BI project – and so, inspired by Sam Vanga’s blog post from today on that same topic I decided to take a look at some Twitter data myself.

In NodeXL I imported 1757 tweets from 515 different people that included the #sqlpass hashtag from the 8th of November when Twitter activity at the conference was at its peak (I couldn’t import any more than that – I assume Twitter imposes a limit on the number of search results it returns). In basic terms, when NodeXL imports data from Twitter each Twitter handle becomes a point on a graph, and a line is drawn between two Twitter handles when they appear in a tweet together. I won’t bother going into any detail about how I built my graph because analysing the results is much more interesting, so I’ll just say that after playing around with the clustering, layout and grouping options here’s what I came up with:

image

It looks very pretty from this distance but it’s not very useful if you can’t read the names, so I saved a much larger .png version of this image here for you to download and explore, and if you’ve got NodeXL you can download the original workbook here (don’t bother trying to open it in the Excel Web App). It’s fascinating to look at – even though the data comes from a very restricted time period the cliques in the SQL Server world emerge quite clearly. For example, here’s the group that the clustering algorithm has put me in  (I’m @Technitrain), which is at the bottom of the graph on the left-hand side:

image

There’s a very strong UK/SQLBits presence there (@timk_adatis and @allansqlis for example), but also a strong BI presence as well with @marcorus and @markgstacey, which is pretty much what you’d expect. There are several other small groups like this, plus a large number of unconnected people in groups on their own in the bottom right-hand corner of the graph, but on the top left-hand side there’s a monster group containing a lot of well-known SQL Server personalities. Jen Stirrup (@jenstirrup) is right in the centre of it, partly because she’s one of the SQL Server Twitter royalty and partly because of her well-deserved PASSion award that day. Highlighting in red just the tweets that involved her shows at the very highest level how well-connected she is:

image

Keeping Jen selected and zooming in shows the people clustered together with Jen a bit better:

image

Selecting not only Jen’s tweets but also the tweets of the people who tweeted to her and also to each other (which is one of many useful features in NodeXL), highlights just how close the members of this group are:

image

This is clearly where the popular kids hang out…

Anyway, I hope this gives you an idea of the kind of thing that’s possible with NodeXL and Twitter data and inspires you to go and try it yourself. Hell, NodeXL is so much fun it might prove to the DBA crowd that BI doesn’t need to be boring!

Written by Chris Webb

November 12, 2012 at 10:32 pm

Posted in NodeXL, PASS

Follow

Get every new post delivered to your Inbox.

Join 3,302 other followers