Resources

dbtanalytics-engineeringdata-modelingsemantic-modelingresources

dbt project best practices guide

A structured reference for dbt projects covering folder structure, model contracts, materialization choices, testing strategy, semantic models and metrics, dbt Mesh, SQL conventions, snapshots, and consistency for AI-assisted analytics engineering.

Open resource
data-visualizationstorytellinganalyticsresources

Data visualization best practices guide

A structured guide to effective data visualization—defining the insight before the visual, guiding attention, choosing encodings, and presenting clearly for BI and analytics teams.

Open resource
excelbusiness-analyticstemplatesforecastingresources

Excel data analysis templates toolkit

A structured toolkit of business analytics techniques with ready-to-use Excel templates (PEST, Porter, regression, time series, scenarios, and more) for fast decision support.

Open resource
power-bifabricsemantic-modelingresources

Power BI development best practices guide

A structured reference from solution purpose through modeling, security, refresh modes, deployment pipelines, and AI-ready semantic models for Microsoft Power BI and Fabric.

Open resource