The author may receive compensation for purchases made through the products or services introduced.For those of you manually ...

As a follow-on from last week’s post about the new ApproximateDistinctCount function in DAX, I want to share something I found out from my recent testing for this function: ApproximateDistinctCount is ...

Building apps is something for young programmers, right?”“It’s impossible for someone like me without IT expertise...”If that ...

Excel’s vast functionality can often feel overwhelming, but mastering a few essential techniques can make a significant ...

Tableau Prep is two tools sharing one name. Prep Builder is where you clean and shape data into flows, on the desktop or on ...

SyncriTab provides a centralized, browser-based environment to connect to databases, run SQL queries, manage data, and ...

Excel is still my spreadsheet workhorse, but VS Code handles the awkward file-level jobs I don't want Excel touching.

This video shows how to create a combined PivotTable from multiple Excel worksheets and files. It demonstrates three ...

As you’ve probably seen in the blog post for the September 2026 release of Power BI, Import mode and Direct Lake mode semantic models now support the ApproximateDistinctCount() DAX function. I tested ...

Hackers abused a Microsoft SQL Server to run commands, steal credentials and source code, and move files in a Viva Aerobus-linked attack.

If you've been staring at Excel all week at work, the last thing you probably want to do this weekend is open another spreadsheet. Except Excel gets surprisingly interesting when ...

5 Excel tricks to boost your productivity This tutorial demonstrates five practical Excel skills: - Import live data from the web into Excel with a live connection. - Clean data using Power Query ...