In today’s data-driven world, the ability to visualize and interpret complex datasets has become a crucial skill. Businesses, non-profits, and government agencies alike rely heavily on data to make ...

I've been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to the data tier. Writing the ...

Since data-driven decision-making is central to modern businesses, the demand for skilled Tableau professionals is on the rise. It is one of the best tools when it comes to creating visual ...

remove-circle Internet Archive's in-browser bookreader "theater" requires JavaScript to be enabled. It appears your browser does not have it turned on. Please see ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

I don’t have anything against the use of calculated columns in Power BI semantic models in general but you do need to be careful using them with DirectQuery mode. In particular when you have a ...

DAX (Data Analysis Expressions) is a powerful formula language used for data modeling and analysis in Microsoft Power BI, Excel, and SQL Server Analysis Services. It allows users to create complex ...

For the last 7 years, I have worked professionally with Tableau, and for 7 years we have been asked questions about write back to a database. Can it be done, and what does it require? This blog post ...

When you build a Power Apps canvas app there are many different data sources you can choose to use such as SharePoint, Microsoft Dataverse, SQL (on-premises), Azure SQL (online), Excel, and others ...

A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what ...