Cloudfide’s Business Intelligence newsletter / Week 42–43, 2025

20 min

Sebastian Jagniątkowski

Published Oct 29, 2025

Welcome to: Cloudfide’s Business Intelligence Newsletter. We’ve prepared a curated digest of the most interesting and practical Power BI materials from the past two weeks to help you stay on top of trends and steadily sharpen your skills; below you’ll find a carefully selected list of practical and strategic resources, each entry explains why it matters, provides a concise summary, and includes a direct link so you can dive straight in.


1️⃣ How to Handle Multiple Date Columns in Power BI

  • Why is it interesting? Learn advanced modeling techniques using USERELATIONSHIP to handle multiple date columns and answer complex business questions with cleaner DAX.

  • Audience: Intermediate → Advanced

  • Area: Data Modeling / DAX / Relationships


2️⃣ Learn to Use Calculated Columns Effectivel

  • Why is it interesting? Discover why creating calculated columns in Power Query instead of DAX enables reusability across models and better performance optimization.

  • Audience: Beginner → Intermediate

  • Area: Power Query / Data Transformation / Best Practices


3️⃣ New DAX Time Intelligence Explained

  • Why is it interesting? Master the new calendar-based time intelligence feature that simplifies DAX for fiscal and custom calendars while future-proofing your models.

  • Audience: Intermediate → Advanced

  • Area: DAX / Time Intelligence / Calendar Tables


4️⃣ How to Build Models Online in Power BI Service:

  • Why is it interesting? Discover the new capability to build semantic models directly in the Power BI Service without Desktop, streamlining cloud-based development workflows.

  • Audience: Intermediate

  • Area: Semantic Models / Power BI Service / Cloud Development


5️⃣ Using VALUES in SUMMARIZE:

  • Why is it interesting? Learn when to use VALUES with SUMMARIZE to handle blank rows from invalid relationships and avoid common aggregation mistakes.

  • Audience: Intermediate → Advanced

  • Area: DAX / Data Modeling / Optimization


6️⃣ SQL Order of Operations Explained

  • Why is it interesting? Grasp how SQL processes queries step-by-step to write more efficient code and troubleshoot performance issues effectively.

  • Audience: Beginner → Intermediate

  • Area: SQL / Query Optimization / Fundamentals


7️⃣ Overcoming Initial Full-Load Failures (part 1 & part 2)

  • Why is it interesting? Solve common incremental refresh setup challenges with proven strategies for handling initial data loads and partition failures at scale.

  • Audience: Advanced

  • Area: Incremental Refresh / Troubleshooting / Performance


Ready to optimize your Power BI change management processes? Let our experts conduct a thorough assessment of your current reporting practices. We will define a strategy to streamline your reporting system, restore trust in data, and propel your business to the next level with data-driven decisions. Don’t let competitors overtake you - get in touch to schedule your consultation.

Sebastian Jagniątkowski

Business Intelligence Developer

Oct 29, 2025

Sebastian Jagniątkowski

Business Intelligence Developer

Oct 29, 2025

Looking for a trusted partner for your next cloud project?

Reach out to us and tell how we can help