Pivoting Stacked Data with Power Query

No matter the program you use to build your self-service BI solution, data will be at the heart of it. The challenge with data – of course – is that it’s seldom ready to be consumed; even if it’s as simple as just changing a column name, you’ll no doubt want to modify something. Ken Puls shows how to pivot stacked data with Power Query.

Secure the Lowest Registration Price for PASS Summit – Before Rates Increase TOMORROW!

Prices are set to increase by $400 to attend PASS Summit 2019 tomorrow! Future-proof your career at PASS Summit with the latest tips on how to master the tuning, optimizing, and visualizing of your data!

Calendar Over Run While Comparing Last Year's Data

Matt Allington uses a sample database to solve the issue of calendar over run while comparing values from the previous year.

#DevOps for Machine Learning

Most organizations have two non-overlapping work streams when building an AI enabled application: a development path and a data science path. Learn how these swim lanes converge.

PASS Marathon: Achieving AI Analytics - Call for Speakers is Open!

We’re looking for Analytics experts to share real-world examples of implementing AI into your workflow, reporting, and visualizations. Whether you’re a seasoned speaker or looking for an opportunity to present your first session, submit your abstract today!

10 Significant Visualisation Developments: July to December 2018

Andy Kirk looks back at the last months of 2018 in the data visualisation field, presenting a collection of significant developments, projects, events, new sites, trends, personalities, and general observations that are making an impact in the data visualisation field.

Beyond Interactive: Notebook Innovation at Netflix

Notebooks have rapidly grown in popularity among data scientists to become the de facto standard for quick prototyping and exploratory analysis. Learn how Netflix pushes the boundaries by reimagining what a notebook can be, who can use it, and what they can do with it.

Upcoming Virtual Events

Women Talk Tech

Tuesday, March 12. 17:00 UTC.

 


We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to insights@pass.org.
You just might see yourself featured in an upcoming edition!

Looking for more than just Analyst educational and technical content?
Log in to your PASS account and subscribe to the new BI, DBA, and Developer PASS Insights newsletters.