Oscar MartĂnez
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.
All Blog Posts
Select categories
Select tags
F
Oscar MartĂnez
Automating Power BI Themes with Fabric, Notebooks and BIBB Theme Generator API: A Complete Guide
Learn how to automate Power BI report theme updates using Microsoft Fabric, Python, and the BIBB Theme Generator API for seamless theme management.
P
Oscar MartĂnez
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.
U
Francesco Marino
Improving BI User Experience in Corporate Environments: Practical Strategies That Work
Discover actionable techniques for improving BI user experience in corporate environments, focusing on user personas, training, and documentation.
P
Oscar MartĂnez
Data Exfiltration in Power Query - Understanding the Risk and Protections
Data Exfiltration in Power Query: Understanding the Risk and Protections
P
Oscar MartĂnez
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.
P
Hamza Boubou
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.
U
Bushra Amjad
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.
P
Ilfat Galiev
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.
P
Oscar MartĂnez
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.
U
Oscar MartĂnez
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.
U
Oscar MartĂnez
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.
U
Sajjad Ahmadi
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.
U
Olga Rudakova
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.
U
Gregor Brunner
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
Oscar MartĂnez
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
Sara Rodriguez
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.
U
Diana Maier
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.
M
Oscar MartĂnez
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.
U
Diana Maier
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.
D
Oscar MartĂnez
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
Oscar MartĂnez
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
Oscar MartĂnez
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
Oscar MartĂnez
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.
P
Diana Maier
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
Oscar MartĂnez
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.
U
Oscar MartĂnez
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
Oscar MartĂnez
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.
U
Oscar MartĂnez
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.
U
Oscar MartĂnez
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.
M
Oscar MartĂnez
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.
U
Raziel Colosia
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.
U
Raziel Colosia
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.
U
Raziel Colosia
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.
U
Raziel Colosia
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.
U
Raziel Colosia
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.
M
Oscar MartĂnez
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.
P
Oscar MartĂnez
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
Oscar MartĂnez
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.
M
Oscar MartĂnez
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.
U
Oscar MartĂnez
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.