The Future of Power Query – Interviews with Chris Webb at PASS Summit 2017

In a series of interviews during PASS Summit 2017 in Seattle, the week of October 30 through November 3, I caught up with Chris Webb, who is an international BI community thought-leader and product team advisor for Microsoft.  We chatted about his love affair with Power Query, lessons learned from many years of expert Business Intelligence project work and his thoughts about the future of Power Query and other Microsoft tools.  Chris had just finished an all day preconference presentation the day before our interview and his experience was fresh in-mind.  He has a long history of deep expertise with SQL Server, Analysis Services multidimensional and tabular technologies, MDX and DAX.  His focus lately has been teaching, writing and using Power Query in practice.

He was so interesting and insightful that I honestly couldn’t edit anything out of the final recording, so I split it into three parts.

Chris Webb Interview Part 1 of 3

In the first installment, Chris talks about how he got started with Power Query and why he thought it was worth his investment of time and energy.  He said that didn’t plan to bet his career on Power Query.  He said “this tool was cool.  I liked playing with it…”.  He carried on playing with Power Query until he fell in love with the product and it’s awesome ability to transform data in ways that weren’t possible before with the same easy and elegance.

Chris Webb Interview Part 2 of 3

We began with the question: “Do you ever foresee Power Query being used as an enterprise ETL tool in lieu of something like SSIS?”  Chris shares his thoughts about Power Query as a self-service, desktop data transformation tool and its juxtaposition with other with older, more complicated data tools.  He says it is “a universal query generator”, capable of performing “query folding” (translating and pushing  queries back to the data source engine for each data provider).  We discussed how Microsoft is committed to supporting and enhancing Power Query, not only for desktop analysis but to perform tasks partitioning in Analysis Services tabular, with many other possible scenarios.  His passion for this tool is so apparent in our discussion.

Chris Webb Interview Part 3 of 3

How can you get started with Power Query and where is the best place to go for expert advice?  Chris wrote one of the best books on the topic that, in my opinion, is very relevant today.  I gave him the bait and he wouldn’t take it when I asked: “can you recommend any good books on Power Query?”  In his usual, humble, fashion he tells me how difficult it is to write a good book about a product that changes so much; and goes on to recommend several online learning resources.

We conclude with Chris’ advice about how to get started and where to go for best practices, to develop expertise and advanced knowledge.

You can follow Chris Webb’s frequent posts on his blog, at: blog.crossjoin.co.uk

Thank you, Chris, for your time and willingness to share your thoughts and expertise.

Microsoft Uses Predictive Analytics to Deliver Data Platform Product Documentation! Interview with Carl Rabeler

Carl Rabeler is a Content Strategist on the Microsoft Azure SQL team.  In this role, he is  much more that just a document writer. Carl works closely with the Customer Advisory Team (CAT), the MVP community and TIGER teams who support the most complex enterprise customer solutions.  In this 11 minute interview during the 2017 PASS Summit, Carl shares the teams’ strategies for analyzing content searches, reader and viewership analytics to move ahead of the curve and predict the kinds of learning and support documentation Microsoft users will find most valuable in the future.

He told me how product instrumentation, site search metadata and direct customer feedback allow them to target content that users need now, rather then waiting for comments and revisions.  The primary product documentation store is now hosted in Docs.Microsoft.com, which is an open Git repository where users can contribute and edit existing docs, which are then curated by the Microsoft product teams.  Between timely and aggressive technical content authoring, open source collaborative curation and advanced analytics performed on content search and usage, Microsoft is much better equipped to serve the masses and meet the needs of users who have very specific product usage requirements.

Carl and I have worked together over the past 10-12 years through several Microsoft product team interactions, MVP Summit sessions, and we worked on consulting client projects for a number of years through SolidQ – aka Solid Quality Mentors.  He was the guy we flew out to work on the big architecture configuration solutions when we needed the three-headed dog from Hell to play nicely with SharePoint and every conceivable service connecting through it.

Next time you go searching for how to encrypt a server connection, know that Carl and his team of content curators are looking for the best way to get you the answers you need in the most effective way possible.

Interview with Pinal Dave at PASS Summit 2017

While attending PASS Summit 2017 in Seattle, I had a chance to catch-up of several friends and industry experts, and I will be sharing these interviews in a series of posts.  On the 1st of November, Pinal Dave completed his 4200th post on SqlAuthority.com – a landmark by blogging once per day for eleven years.  Pinal shares this success story and humbly discusses his secrets about being the world-renound authority that we all know, along with some advice about tuning SQL Server.

Thank you, Pinal, for your time and all you do for the PASS community.

 

Look out, PASS Summit precons attendees

Just a little bit of last minute work to do… loading 196 USB drives with materials for the session. Looking forward to meeting you if you are attending the Tuesday precon.

It's not a requirement for the session to follow along, but if you would like, you may bring a laptop capable of running SQL Server 2017 and Reporting Services to follow along with demos. Some selected lab materials from my 2, 3 and 4-day classes will be provided.

Modern Reporting with SSRS 2016 & 2017, and Report Tool Options – PASS Sessions

It’s official.  The PASS Summit schedule was announced and I will be doing three sessions:  A full-day preconference, a regular session and a panel discussion with other industry professionals.  Come back to this post for follow-up information and selections of content from these sessions after the event.

The PASS Summit is my favorite event of the year and I always leave with so much valuable insight and information.  PASS is my annual battery recharge for the rest of the year.  It is a vibrant community of professionals and industry leaders who love to share and exchange learnings.  Not just an opportunity to attend sessions presented by top-notch experts and product owners from Microsoft but Summit presents many real opportunities to sit and talk, meet and socialize with these industry influencers.  My perspectives change and I go back to my clients, classrooms and projects with solutions and a fresh new approach.  I’ve been going to the PASS Summit for twelve years and every year is literally the best Summit ever.  In the industry, there is no better investment of time and energy compared with what you will gain by attending.  I look forward to meeting many of you at Summit.  Please introduce yourself and say ‘Hello’. Continue reading

Mobile Reporting in SSRS 2016 and 2017

If you are a Reporting Services practitioner, the Microsoft mobile report story can be a little confusing with two very different choices.  As I’m preparing to deliver a full day preconference session for the PASS Summit on October 31st titled “Modern Reporting with SQL Server 2016 and 2017 Reporting Services” and a general session during the main conference tiled “Clear Skies and Not a Cloud in Sight – Power BI On-Prem”, this has me pondering about what my mobile reporting message will be.  Being part of the Microsoft MVP Program and participating on a number of product team advisory boards provides insight into how things often work at Microsoft and how products tend to evolve and align over time.  I am forever enthusiastic about using and promoting Microsoft BI and reporting tools, but I am not bound by any covenant to adhere to a simplified marketing message from Microsoft or any other company.  To that end, I share some thoughts about the current state of mobile reporting… Continue reading

Implementing Row-Level Security in Power BI

The best method to implement row-level security in a published Power BI model or SSAS Tabular model consumed from the Power BI service will depend to some degree on your data structure and requirements.  The method I demonstrate here is one of the most flexible approaches and one that I commonly use in my projects. Continue reading