One very common cause of Power BI performance problems is having a table with a large number of rows on your report. It’s a problem I wrote about here, and while I used an Import mode for my example ...

Paid media is often treated like a checklist item in a marketing plan: launch a few search ads, run a Meta campaign, maybe test YouTube if there’s budget left. But not all paid media is created equal, ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

Natural language interface to databases is a growing focus within artificial intelligence, particularly because it allows users to interact with structured databases using plain human language. This ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data. In May 1974, Donald Chamberlin and Raymond Boyce published a paper on ...

An illustration of a magnifying glass. An illustration of a magnifying glass.

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...