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…
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…
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…
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…
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’.
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…
BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, SSAS Administration, SSAS Design
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.
24 Hours Of PASS, Data Visualization, Excel BI, Microsoft BI Platform, Power BI, SQL Server, SSAS Design, SSRS Administration, SSRS Design
Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together
Please join me and other 2017 PASS Summit speakers for 24 Hours of PASS: Summit Preview on July 19th and 20th. 24HOP is a series of 60 minute on-line sessions presented back-to-back for 24 hours, from the same professionals who will deliver preconference and main conference sessions during the Summit the first week of November this year. These online sessions are free of charge and normally attended by thousands of individuals to gain insight and knowledge about the topics. 24 Hours of PASS features free educational webinars delivered over 24 hours. Topics covered in this edition include Performance Tuning, SQL Server 2017, Linux, DevOps, Azure, PowerShell, SSRS, Power BI and much more. Browse all sessions. These webinars provide a sneak peek at some of the best practices, expert tips and demos you’ll find at this year’s PASS Summit in Seattle.
Modern Reporting with SQL Server 2016 and 2017 Reporting Services full day pre-conference session
Please join me and other 2017 PASS Summit speakers for 24 Hours of PASS: Summit Preview on July 19th and 20th. 24HOP is a series of 60 minute on-line sessions presented back-to-back for 24 hours, from the same professionals who will deliver preconference and main conference sessions during the Summit the first week of November this year. These online sessions are free of charge and normally attended by thousands of individuals to gain insight and knowledge about the topics. 24 Hours of PASS features free educational webinars delivered over 24 hours. Topics covered in this edition include Performance Tuning, SQL Server 2017, Linux, DevOps, Azure, PowerShell, SSRS, Power BI and much more. Browse all sessions. These webinars provide a sneak peek at some of the best practices, expert tips and demos you’ll find at this year’s PASS Summit in Seattle.
Session Recordings: Advanced Data Transformation Techniques, and Power BI Options for the Enterprise
Absolutely amazing…. The Microsoft Data Insights Summit was a series of one great learning experience after another. My greatest impressions of the summit were that the Power BI community is coming together as a cohesive group of data professionals. I think Power BI and Microsoft data platform have a solid story now as a solution rather than just a product and it was apparent that business people and technologies are taking it seriously.
In my post before the Data Insight Summit, I shared an overview of the two sessions we were preparing to deliver. It took the organizers only one day to post all the session recordings from the entire conference for public viewing. Let me say that again… every session, in its entirety, is available to watch for free online. Here are my two sessions.
From the Keynote at the Microsoft Data Insights Summit
In sitting up front in the Data Insights Summit waiting for the keynote to begin. It’s Monday, June 12, 2017. I’ll update this post with announcements. We’ve been told to expect some important news and announcement today. Internet connectivity is pretty spotty so you may see some updates later in the keynote session.
I’m sitting in the Press section with fellow bloggers, who are also sending updates from the Summit keynote. Check out their notes as well.
Reza Rad: http://radacad.com
Marco Russo: http://sqlbi.com
Matt Allington: http://exceleratorbi.com.au/exceleratorbiblog
James Phillips on stage: “we need to get a bigger room… we’re over capacity. please don’t tell the fire marshal …just kidding. No, really… I’m just kidding”
Microsoft Data Insights Summit Live Streaming & Free Sessions
If you are fortunate enough to be attending the Microsoft Data Insights Summit in Seattle along with about 2,000 others on June 12 & 13, I’ll look forward to seeing you there. This will be a great community event and a chance to meet, network and learn from well-known speakers, authors and product team leaders responsible for the best data analytics tools in the industry. The summit has been sold-out for a few weeks. If you can’t make it to Seattle to be there in person, you can still attend the conference! I don’t just mean that you can watch a few cherry-picked sessions and keynote addresses… You can watch every session for free. Selected sessions, which do include the keynote addresses, will be streamed lived during the conference but all of the sessions are recorded and will be available within two weeks after the last sessions wrap-up on June 13. This an awesome learning experience. I will post links and more details here about the recorded sessions after they become available.
If you are going to the summit, please attend my two sessions:
Chapter 18–Implementing a Mobile report with Design-First Development
This post is part of the series: “Professional SSRS 2016 Book Preview Posts” which are excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports. Each of the posts is a condensed version of the material covered in a corresponding chapter from the book. The goal for this posts is to provide useful and meaningful information you can use. For more comprehensive details, I refer readers to the rather lengthy book itself. Note that large portions are copied directly from the book manuscript that may refer to figures and screen capture images that have been removed for brevity.
Using design-first report development
Creating and using shared datasets
Using Time navigators
Using Selectors
Using Number gauges and charts
Applying mobile layouts and color styling
Deploying and testing a completed mobile report
Chapter 17–Introducing Reporting Services Mobile Reports
An excerpt from Chapter 17…
This chapter is the first in a series of three chapters comprising PART IV, which includes coverage for these topics:
Basic mobile report design approaches and applications
Appropriate use of navigators, selectors, gauges, charts, maps, and data grids
Advanced report design techniques with complex visual controls
Filtering and interactions
Report navigation
How to use parameters for dashboard filtering
User parameters for drill-through navigation
How to drill-through to other reporting tools with URL paths and parameters
Chapter 9 – Advanced Queries and Parameters
This post is part of the series: “Professional SSRS 2016 Book Preview Posts” which are excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports. Each of the posts is a condensed version of the material covered in a corresponding chapter from the book. The goal for this posts is to provide useful and meaningful information you can use. For more comprehensive details, I refer readers to the rather lengthy book itself. Note that large portions are copied directly from the book manuscript that may refer to figures and screen capture images that have been removed for brevity.
Understanding T-SQL queries and parameters
Understanding MDX queries, parameters, and expressions
Managing report parameters
Using parameter expressions