The official PASS Blog is where you’ll find the latest blog posts from PASS community members and the PASS Board. Contributors share their thoughts and discuss a wide variety of topics spanning PASS and the data community.

Filling a Vacant Board Seat

I wanted to share a change to the composition of our current PASS Board. Jennifer Moser has resigned from her role as a community elected Director-at Large on the Board and this resignation has now taken effect.

When a Director-at Large seat becomes vacant outside of a standard election cycle, the PASS Bylaws indicate that the Board of Directors may appoint a candidate for up to one year, by a majority vote, to fill the remainder of the term until it can be added to a general election.

Read more

Azure Cognitive Services

In the first article of this two-part series, we briefly introduce Azure cognitive services Text Analytics API. Using the example of a team health survey, we walked through the steps of:

  • Creating Azure Cognitive services resource,
  • Loading the raw data into Power BI,
  • Creating and Invoking Custom Functions in Power BI, to extract key phrases and generate sentiment scores from raw text,
  • Saving the Key phrases and sentiment scores as new columns to the data table loaded in Power BI.

At the end of the first article, your Power BI Desktop Data Pane should have a table with 6 fields. The fields “Period”,” Manager”,” Team” and “Response” are from the raw data file. The fields “KeyPhrases” and “SentimentScore” are added and populated by the steps in we took in the first article.

Read more

A Game of Hierarchies: Graph DB with SQL Server 2019

Graph DB, a feature for the SQL Server relational database engine was introduced in version 2017. With this addition Microsoft made it very easy to maintain and query graphs via enhancements to T-SQL and to allow access to the graph in combination with “normal” tables.

Before we take a look at new features available with SQL Server 2019, let’s take a look at what a graph is and how you can create a graph in SQL Server 2017.

Read more

How to Run a SQL Server Job Using Power Apps and Flow


The introduction of Power Platform tools addresses a common issue for BI developers: giving more interactivity to end-users. Now, using Power Apps it is possible to write-back values directly to a SQL Server table, simulate what-if scenarios, and so on. Your users can finally “press a button” and make something happen.

In this article I want to show you how to use Power Apps and Flow for running a SQL Server job, something that I always missed. In such a case, you can allow your users to update a small amount of data on-demand.

Read more

Power BI Governance

Power BI started out as a pure self-service tool, but has increasingly been moving to be more of an enterprise tool and can rightly be called a hybrid BI tool. No matter if you use Power BI as a self-service tool, as an enterprise BI tool or both, it’s important to include governance into your implementation. Far too many organizations start using Power BI without thinking about governance and then have the problem of trying to get their users to stop doing things as they are used to and to start using process they are not used to, that they often feel will hinder their progress.

Read more

Privacy, Security and Ethics for the Data-Driven Professional

It’s challenging to talk about Data Privacy without mentioning either Security or Ethics.

Potentially we should also be discussing process and governance – which can go a long way to ensuring that both privacy and security are as tight as possible.

The purpose of this short article is to generate thinking around these concepts and hopefully foster some thoughts into how we might make our industry more secure and less prone to the damaging articles we see everyday concerning data breaches and the misuse of data.

Read more

PASS Summit 2020 Location Announcement

When I announced that PASS Summit 2019 was staying in Seattle last year, I also shared that the conference location is decided years in advance, the result of a complex evaluation process. This process involves considering many different factors impacting our event, including attendee feedback, budget, accessibility, and scale.

When planning started for PASS Summit 2020, we recognized that attendee numbers and the scale of our conference was increasing. This raised concerns that based on the current layout of the Washington State Convention Center (WSCC), these facilities may no longer be suitable for our conference in 2020.

Read more

History of PASS, Part 3: Bylaws Version 1

This blog has been reposted from its original source:

I’ve been taking some spare time, which doesn’t come along very often, to record some of the details of PASS during its very first years of existence. In case you haven’t seen the earlier entries in this series, here they are:

In the History of PASS, Part 1: Foundation, I described how the money, the executive willpower, and the corporate support came together to set the wheels in motion.

Read more

PASS Summit Speaker Presentation Template Updates

By Meagan Longoria and Chris Yates

As you may have already noticed, the speaker presentation template looks a bit different this year. To shed light on how the template was created, the talented Meagan Longoria, PASS HQ, and myself are taking some time to give you a behind the scenes look.

Last PASS Summit, I had the privilege of talking with many of you on a myriad of topics; one of the more intriguing ones was the conversation I had with Meagan. Our discussions focused on the speaker templates currently being used and what can be done to improve them. She has a lot of great content on her blog and one specific post that ties into what we are discussing today can be found here

Read more

PASS FY 2020 Financials

Posting our annual budget and financials each year is an opportunity for us to give our community members transparency into our financial planning and where our money is going in support of the organization.

As an additional layer of clarity to the line items throughout the statement, this year’s financials are once again accompanied by a high-level summary and FAQ document:

View FY 2020 Budget

Read more


Theme picker

Back to Top