Excel formulas are getting scary good.

Cloud-native data analytics startup Sigma Computing Inc. has closed on an $80 million Series E funding round that doubles its valuation to $3 billion, almost a year to the day after its previous ...

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 ...

In today’s competitive job market, securing a role in database management is difficult. SQL (Structured Query Language) remains a fundamental skill for database administrators, software developers, ...

But what if you aren't able to inspect the file before pivoting it, you just need to pivot based on whatever values are found in the table. This is where Snowflake's current ability to dynamically ...

Every data engineering team right now is being asked the same question: "How do we build a chatbot that talks to our data?" The prototypes are deceptively simple. A developer connects GPT-5.1 to a ...

Excel is more than just a spreadsheet tool; it is a comprehensive platform for data analysis and business intelligence. By using its advanced tools—Power Query, Power Pivot, and DAX—you can elevate ...

Excel has evolved into a robust platform for data analysis and reporting, thanks to its advanced business intelligence tools: Power Query, Power Pivot, Data Model, and DAX. These powerful features can ...

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 ...

I recently had some interesting problems and learned some cool solutions while working in Power Query in Excel =] ! The first problem I had was that I was trying to create a dynamic SQL query based on ...