Learn how to use Excel's new GROUPBY and PIVOTBY functions through five real-world examples, ranging from easy to hard. This tutorial covers: - Basic GROUPBY to calculate the sum of revenue by ...

Excel formulas are getting scary good.

DuckDB is an amazing tool with deep integration with Python and R, but sometimes you just need data in Excel. xlDuckDb allows DuckDB SQL to be run within Excel. Query results are returned as regular ...

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment in its ...

Have you ever felt like your Excel skills hit a ceiling, no matter how many pivot tables you create? You’re not alone. While standard pivot tables are a reliable tool for summarizing data, they often ...

There are many database management systems (DBMS) out there. But there is no one-size-fits all database system. All take different trade-offs to better adjust to specific use cases. DuckDB is no ...

I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI In Python, you can use the pandas library to work with tabular data, and the core ...