Both Excel and SQL databases have their pros and cons. But most people are more familiar with Excel than a database. For this reason, you might want to turn your Excel into a sort of SQL database ...

I’ve just started exploring Excel 2016. As one of the tentpole applications for the new Office 2016, it has a raft of new features for lucky upgraders. Take a closer look with me and see what you ...

With the new Get & Transform capabilities in Excel 2016, you can now import, transform and combine data from different sources—thanks to the integrated Power Query technology in Excel. Today we are ...

Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We are excited to let you know that your get-data experience in Excel is about to ...

With the recent release of SQL Server 2016 some of you old faithful SSAS Multidimensional users out there might be wondering if it’s worth upgrading. There is an official page describing what’s new in ...