HASSUG Update 3/16

Dear Friends
John Miner will be presenting a brand new topic about Data Build Tool.

#### Description

Why are some many people using dbt? Even Microsoft is adding dbt jobs to Fabric.

Many people learn from the Jaffle Shop sample dbt project. However, the complexity of the project is quite simple. What I really wanted is a project that goes over the following dbt concepts:

• Seed raw data tables
• Transform raw data using views
• Support multiple databases with macros
• Capture slowly changing dimensions type 2
• Incremental loading of large data with append or merge
• Use ephemeral tables as a place holder
• Use dbt utils package to make a date dimension
• Create a dimensional model for reporting
• Save pre-canned queries in analyses directory
• Test data quality using property/schema files
• Output custom data quality exceptions to a table
• Create documentation based on model design

Further, he is also conducting a full day workshop on the same topic on Friday April 24th from 9-4:30 at Microsoft office. The link for registration is here

Link for Pinal Dave's session on SQL Server Performance Tuning on4/24 from 9-4:30 is open for registration here

Whereas the link for our AI and Analytics Saturday registration is open here
Please share the links above with your internal IT circles and social media.

If you like to volunteer or speak, please contact us.
Regards.
Team HASSUG