Story
Understanding the Grain
The grain of a dataset is the most fundamental modeling decision you make before writing a single query. Get it wrong and no DAX fix will save you.
All Blog Posts
Filter by Author: 
Oscar MartÃnez
30 posts
Sajjad Ahmadi
3 posts
Anton Storozhuk
1 post
Aditya Kumar Darak
1 post
Bernie Smith
1 post
Nicholas Lea-Trengrouse
1 post
Hamza Boubou
1 post
Bushra Amjad
1 post
Ilfat Galiev
1 post
Olga Rudakova
1 post
Gregor Brunner
1 post
Sara Rodriguez
1 post
Diana Maier
3 posts
Raziel Colosia
5 posts
Select categories
Select tags
F
Building Claude Dashboards on Microsoft Fabric with Fabric IQ MCP
Build a Claude Dashboard from a Microsoft Fabric semantic model via the Fabric IQ MCP server: DAX queries, CSV snapshots, and the quirks we hit along the way.
D
Power BI SVG Measures: 7 Use Cases, 17 Rules, and an AI Prompt
Power BI SVG measures: stop breaking yours. Learn where to use them, follow 17 priority-based rules, and grab an AI prompt template for bulletproof visuals.
P
Connecting Clockify to Power BI: Three Integration Patterns That Work
Connect Clockify to Power BI three ways: hand-rolled Web.Contents calls, the free custom connector, or a ready-made template. Pick by build versus ship.
Series · 2 posts
Series
bibb series
bibb Analytics: Build in Public
Documenting the real marketing analytics setup behind bibb.pro: strategy, implementation, and results. Built with Dashflow. Published as it happens.
2 posts
F
Git for Power BI and Fabric Users: A Beginner's Guide
Power BI and Fabric development is moving toward programmatic workflows. Here is what Git is, how to install it on Windows, and how to use it as a BI or Fabric developer.
Series · 5 posts
Series
bibb series
Dashboard Design from Scratch
A practical sequence from design principles to finished Power BI reports. Grid systems, whitespace, wireframes, and layout.
5 posts
D
6 Power BI Modern Button Slicer UI Patterns for Better Dashboards
Learn 6 Power BI Button Slicer UI patterns to build modern dashboards: segmented controls, tabs, KPI cards, toggle buttons, and more.
P
Partner
Salesforce Power BI Integration: A Practical Comparison Guide
Salesforce Power BI integration done right: compare native connectors, custom API, and the Metrica connector to choose the best approach for your team.
B
How to Design Better KPIs Before They Mislead You
How to design better KPIs starts with knowing what your formula isn't measuring. A real BI case study in dashboard blind spots, with DAX examples and a fix.
A
AI Agent Skills: Stop Paying for Tokens You Don't Need
AI agent Skills replace bloated instruction files with on-demand context loading — cutting token waste by 80% for Excel and Power Query workflows.
B
Partner
KPI Tree for Performance Management: A Visual 7-Step Guide
KPI Tree for Performance Management: a practical 7-step method to align strategy with KPIs, cut metric overload, and create dashboards people actually use.
B
Why Your BI Team Needs a Product Mindset, Not Just Reports
Discover why developing a BI team product mindset is essential for building compounding value. Learn how to shift from reactive reporting to strategic product thinking.
D
DAX and UDF SVG Charts in Power BI: Complete Guide
Learn to build DAX and UDF SVG charts in Power BI with this complete guide. Create custom visualizations using pure DAX code with dynamic scaling and conditional formatting.
D
DAX + UDF = the React of Power BI
Learn how to combine Power BI DAX user-defined functions with HTML visuals to build reusable KPI cards, tables, and progress bars that wow report stakeholders.
P
What is a Template in Power BI? Settling the debate.
Understand what each Power BI Template type does, when to use it, and how it shapes the user experience.
P
Data Exfiltration in Power Query - Understanding the Risk and Protections
Data Exfiltration in Power Query: Understanding the Risk and Protections
P
Automation of the 'Meet the Team' PDF Slides with Power BI
Automate 'Meet the Team' PDF slides using Power BI, SharePoint, and Power Automate to save time, ensure consistency, and scale across proposals.
D
Master Power BI Time Comparisons and Top N Analysis for Optimal Performance
Learn how to perform Power BI Time Comparisons and Top N Analysis with optimal performance using calculation groups and field parameters instead of slow RANKX functions.
D
Learn How Startups Can Harness Power BI and User-Centred Design for Impactful Dashboards
Discover how Startups Power BI User-Centred Design transforms raw data into actionable insights, improving decision-making and business success.
D
Charticulator Visual Community: A New Chapter in Custom Visual Design
Discover the evolution of Charticulator from its origins to the new community-driven version, featuring enhanced capabilities, dataset editor, public charts, and improved visualization tools for Power BI.
A
Power BI AI CV Analysis for Recruitment: Automating Candidate Matching with OpenAI
Discover how Power BI and OpenAI work together for AI-driven CV analysis in recruitment, enabling efficient candidate matching and insights for data-driven hiring.
B
Review of The Data Storyteller's Handbook: How to Create Business Impact Using Data Storytelling by Kat Greenbrook
An in-depth review of Kat Greenbrook's comprehensive guide to data storytelling for business impact, covering foundational knowledge and advanced techniques for BI professionals.
D
Modern Design in Business Intelligence: Glassmorphism in Power BI
Learn how to implement glassmorphism design techniques in Power BI reports using transparency, blur effects, and modern UI principles for enhanced visual appeal.
D
Dynamic Heatmap Selection: Enhancing Dashboard Interaction and User Experience
Learn how to create interactive heatmaps in Power BI that respond to user selections, improving dashboard functionality and user engagement through dynamic conditional formatting.
D
Effective Dashboard Design: Essential Layout Strategies for Clear, Actionable BI Dashboards
Explore key strategies for effective dashboard design, ensuring data is visible and actionable. Learn Z-pattern layouts, fast vs slow dashboards, and proven design principles.
P
Optimizing User Experience: Cleaning and Improving Power BI Reports and Models
Learn how to optimize Power BI semantic models using Measure Killer to improve performance, enhance user experience, and streamline development workflows.
A
Enhancing BI with AI-Driven Data Analysis and ChatGPT Power Query Integration
Discover how AI-driven data analysis through ChatGPT and Power Query integration can revolutionize your Business Intelligence workflows and data preprocessing capabilities.
A
Harnessing AI-Driven Data Storytelling to Connect and Inspire
Learn how AI-driven data storytelling can help you understand your audience better and create more engaging business intelligence experiences that resonate emotionally and drive action.
D
Elevating BIBB to UX Driven Mastery
A journey through BIBB's transformation from 'Design Driven' to 'UX Driven' BI, exploring our identity evolution, product development, and new visual design principles that enhance user experience.
P
Web.Contents and APIs in Power BI
Learn how to consume APIs in Power BI using Web.Contents function with practical examples including Chuck Norris API, authentication methods, and real-world implementations.
D
Unveiling the Atomic Artistry: Crafting Seamless Data Table Experiences for Users
Learn how to design exceptional data tables using atomic design principles, understanding user behavior patterns, and implementing best practices for optimal user experience.
P
PnP PowerShell for SharePoint for Power BI Users
Learn how to use PnP PowerShell to manage SharePoint data sources for Power BI projects, including creating test lists, adding fields, and automating data management tasks.
P
Power BI JSON Report Theme Generator by BIBB
Discover BIBB's free Power BI Theme Generator that simplifies theme creation with live previews, multiple customization methods, and one-click JSON export.
P
ServiceNow data in Power BI
Learn two ways to connect Power BI to ServiceNow data: using the API with Web.Contents() and the AlphaServe connector for seamless integration.
P
Replicating a Harvard Business Review (HBR) Infographic with Power BI, Deneb, and HTML
Learn how to recreate complex HBR infographics in Power BI using Deneb visualizations and HTML visuals. A step-by-step guide to replicating quantum computing industry data visualizations.
D
Cracking the Color Code: How to Design Better Power BI Dashboards
Step into the world of Power BI dashboards, where data visualization meets the art and science of color. Learn about color harmonies, neutral colors, contrast, and minimal color usage to create impactful dashboards.
P
Everything’s OK Alarm
What Homer Simpson’s ‘Everything’s OK’ alarm teaches us about analytics, KPIs, and business dashboards. Learn why tracking the right metrics matters more than tracking everything.
D
Having a Light and Dark Version of Your Power BI Reports
Discover three effective approaches to create light and dark versions of your Power BI reports, from JSON themes to DAX methods and duplicate items, with pros and cons for each.
P
Securing Your API-Power BI Data with Azure Key Vault
Learn how to secure API secrets in Power BI developments using Azure Key Vault. A comprehensive guide with step-by-step instructions for implementing secure API coding practices.
D
The Power of BI User Personas
Learn how to create and implement Business Intelligence user personas to design more effective Power BI dashboards and analytics solutions focused on user needs.
D
Wireframing in Power BI
Learn how to create effective wireframes for Power BI dashboards and reports using various tools and proven methodologies to improve design workflow and stakeholder collaboration.
P
SharePoint API use in Power BI
Learn how to use SharePoint's API to efficiently load data in Power BI, improving performance and providing better control over your data connections.
D
Dashboard/Report design from scratch: Grid system, Information design, and Wireframe. Part 2
Learn information design principles for dashboard creation, including organizing information, visual hierarchy, and the inverted pyramid structure for effective data storytelling.
D
Dashboard/Report design from scratch: Grid System, Information Design, and Wireframes - part 1
Learn how to apply grid systems to dashboard design using modular grids in Power BI. Discover how to create structured, organized layouts for better report design.
D
Grid System Applied to Report Design in Power BI
Learn how to apply grid system principles to create well-organized and visually appealing Power BI reports using proper alignment, spacing, and layout techniques.
D
Build a Navbar using buttons in Power BI
Learn how to create a professional navigation bar in Power BI using blank buttons, with design considerations, button states, and implementation steps.
D
UX/UI applied to my Power BI report - Part 1: Navigation
Learn essential UX/UI principles for better Power BI report navigation, including Jakob's Law and how to create user-friendly navigation experiences.
P
How to Use SharePoint OData in Power Query
Learn best practices for using SharePoint OData in Power Query to streamline data imports and overcome common challenges with large datasets.
D
Using HTML Buttons in Power BI - Step-by-Step Guide
Learn how to enhance your Power BI reports with custom HTML buttons for improved interactivity and design. Complete guide with code samples and implementation steps.
P
Azure DevOps in Power BI: Optimizing Data Extraction
Learn how to integrate Azure DevOps data into Power BI using OData and REST API methods to overcome the limitations of native connectors and access comprehensive reporting data.
P
Power Query Text Cleaning Function
Streamline text manipulation in Power Query with a versatile custom function that handles character replacement, word swapping, and comprehensive text cleaning operations.
D
Dashboard Design UX Basics - Whitespace and Alignment
Learn how to optimize your BI dashboard design using whitespace and alignment principles. Discover key UX strategies that transform data displays into compelling visual stories.
No posts match your filters.
