Data Visualization Archives - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Five wooden trugs of carrots sorted by length at the end of a vegetable bed, heaped to different heights.

Histogram Buckets in T-SQL: Counting Values per Range

October 12, 2023

SQL Tips and Tricks

Data Visualization, SQL Joins, SQL Scripts, SQL Server

Create histogram buckets in T-SQL with fixed widths or explicit ranges, retain empty buckets, and display scaled text bars.

A full glass pitcher of water on a garden table, while behind it a hand holds a tin cup under a dripping wall tap.

Getting SQL Server Data Into Power BI

May 24, 2010

SQL Tips and Tricks

Business Intelligence, Data Visualization, Query Store, SQL Server, SQL View

Power BI can read SQL Server through Import or DirectQuery; stable views, folding, and workload checks keep the database responsive.