What’s in my Stage? Automating Data Comparison with Biml

Ben Weissman shares an ETL solution that focuses on SSIS as the orchestrator and uses Biml to implement it.

Webinar: Loading A Data Warehouse in SSIS

Learn how to load a data warehouse using SQL Server Integration Services (SSIS).

Do Data Types Matter in Power Query?

Ken Puls discusses the question of whether or not Data Types matter. Based on a proposed theory, Ken delves into the topic in more depth.

Exclusive Microsoft Certification Program

PASS has partnered with Microsoft to bring you exclusive training, free practice tests, and discounted certifications. Earn a certification that demonstrates you are keeping pace with today’s technical roles and requirements.

Join exclusive virtual boot camps for guidance on how to succeed in your exam(s), including a recap of content, and tips and tricks on approaching exam questions. The first webinar will take place on September 25 and will cover the Azure Fundamentals Certification.

Blank Row in DAX

There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, explaining the details of the blank row added to tables for invalid relationships.

Implement Data Governance with Confidence

Companies who implement effective data governance can achieve up to a 150% increase in revenue. Learn how ER/Studio improves the quality, maturity, and compliance of your complex data landscape. Build your data governance foundation with ER/Studio!

Azure Data Share

James Serra covers a brand-new product by Microsoft called Azure Data Share. Currently in public preview, it allows any data, in Azure storage, to be securely shared between a data provider and a data consumer.

Do Tableau and Power BI Replace the Need for a Data Warehouse?

Does a business still need ELT data warehouse automation to achieve fast, efficient reporting from its data sources? Data sources which might range from Safe finance systems to Dynamics ERPs?

Upcoming Virtual Events

SQL Graph Revealed - Mala Mahadevan

Wednesday, September 18. 16:00 UTC.

Introduction to Azure Machine Learning - Ravi Kumar

Tuesday, October 08. 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 BI educational and technical content?
Log in to your PASS account and subscribe to the new Analyst, DBA, and Developer PASS Insights newsletters.