Delete Most of Your Reports

If you are feeling inundated with reports and experiencing inconsistencies, it’s time to take stock and clean house. Ike Ellis shares his experience on a project in which he deleted nearly 650 out of 700 reports and offers three tips to get you started.

Options for BI on Big Data

What's the best way to tackle big data analytics in your organization? In this ebook, we cover the pros and cons of various approaches, and explain how you can enable Data-as-a-Service in your organization.

Create a Power Query Custom Data Connector in 10 Minutes

Eugene Meidinger demonstrates how to quickly—and easily—create a Power Query custom data connector.

What are the 3 Main Differences between ELT and ETL?

As you contemplate your path for moving, manipulating, and making your data available, you may be fixed on doing things as you have always done. In the case of data, this might be ELT or ETL processes which will allow for data to be available.

Azure Databricks & Spark ETL: Unifying Data Engineering at Cloud Scale

Since the introduction of Azure Databricks in 2018, there has been a lot of excitement around the potential of this Unified Analytics Platform and how it can simplify the complexities of deploying cloud-based analytics solutions.
One of the primary benefits of Azure Databricks is its ability to integrate with many other data environments to pull data through an ETL or ELT process. Josh Fennessy examines the E, L, and T to learn how Azure Databricks can help ease into a cloud solution.

Become an Official PASS Summit Blogger!

Make your voice heard through this official platform while gaining priority access to PASS Summit news, on-site press activities, interviews, and a discount to the main event.

If you are an experienced blogger on Business Intelligence who is actively involved with the PASS community, we want to hear from you! Apply before April 25, 2019 (23:59 UTC) to be considered.

SSIS Design Patter: Use Script Tasks for ETL Instrumentation

Find out why Andy Leonard considers scripting in SQL Server Integration Services (SSIS) his data integration "get out of jail free" card.

Updates to Geospatial Features in Azure Stream Analytics - Cloud and IoT edge

Azure Stream Analytics is a fully managed PaaS service that helps you run real-time analytics and complex event processing logic on telemetry from devices and applications. Numerous built-in functions available in Stream Analytics help users build real-time applications using simple SQL language with utmost ease. By using these capabilities customers can quickly realize powerful applications for scenarios such as fleet monitoring, connected cars, mobile asset tracking, geofence monitoring, ridesharing, etc.

Upcoming Virtual Events

Azure Intelligent Services with Amie Mason

Thursday, April 11. 17:00 UTC.

Azure Machine Learning Studio vs. Power BI

Monday, April 22. 16:00 UTC.

Building Trust in the Teams

Wednesday, April 24. 17:00 UTC.

Power BI Dataflows 201 - Beyond the Basics

Tuesday, April 30. 16: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
You just might see yourself featured in an upcoming edition!

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