HeyJaredBIWave Substack
Welcome to BIWave, a place where we dive deep into the world of Data Analysis and Visualization.
- Indexed issues, last 90 days
- 12
- Latest publication
- Sep 24, 2026
- Audience
- Checking…
- Earliest in this view
- Jul 9, 2026
Latest issues
Little-Known Ways to Deal with Nulls in SQL (opens the original)
Read excerpt
<img alt="SQL NULL values explained - three-valued logic TRUE FALSE UNKNOWN, NULL comparison pitfalls, and SQL query behavior" class="sizing-normal" height="630" src="https://substackcdn.com/image/fetch/$s_!lFe1!,w_1456,c_limit,f_auto,q_auto:good,fl_progres
Forget Everything You've Heard About Tabular Model Definition Language (opens the original)
Read excerpt
<img alt="Power BI Semantic Model and TMDL concept illustration with dark blue digital background, glowing data network lines, and orange‑blue nodes representing analytics and tabular model definition language." class="sizing-normal" height="630" src="https://substack
Everything You Know About Data Transformation Is Wrong (opens the original)
Read excerpt
<img alt="What is dbt? Data Build Tool Explained - Complete Beginner's Guide 2026" class="sizing-normal" height="630" src="https://substackcdn.com/image/fetch/$s_!6fSS!,w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media
Five Things About ETL in Python That Nobody Will Tell You (opens the original)
Read excerpt
<img alt="ETL pipelines in Python for beginners tutorial: dark abstract background with glowing interconnected data nodes and network connections representing data engineering workflow" class="sizing-normal" height="630" src="https://substackcdn.com/image/f
8 Lessons I Learned From Building User-Defined Functions In Power BI (opens the original)
Read excerpt
<img alt="A guide to user-defined functions (UDFs) in Power BI, covering how to create custom functions in Power Query M language and DAX for reusable data transformations and advanced data modeling." class="sizing-normal" height="630" src="https://substackcdn.com/image/fet
Publishing over time
Last 90 days. Choose a month to open its work.
Recurring subjects
Named in the text we hold. One piece can cover several.
Audience
No verified audience measurement yet.
About this data
Counts cover the work we have indexed. Tone needs enough text and a confident classification. Excerpts and episode notes are not full articles or transcripts.
Identity or attribution wrong? Suggest a correction.