Microsoft SQL Server has been a favorite for years for organizations that want to implement business intelligence (BI) functionality - even in traditionally non-Microsoft shops. Especially since the ...

Here’s a real-world story: Data collection and analysis is, ironically, for a data management profession, one of the toughest parts of my job. I regularly pull data from our various databases and ...

AtScale now natively supports Data Analysis Expressions (DAX), enabling Microsoft Power BI to connect to AtScale with the richness of live connection mode, unlocking the full potential of AtScale’s ...

Accelerator for Business Intelligence (Accelerator for BI). The Accelerator for BI is a rapid application development tool to automate the process of building the infrastructure of an analytical ...

In the past few weeks, Microsoft has pushed out September updates to various components of Power BI. The desktop variant of the service was the first to be updated this month, followed by improvements ...

Adding a calculated column in Microsoft Power BI can return helpful information at the table level. Here’s how. Not every piece of information you need will be in a table. For instance, if you want to ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

If the natural data can’t support the sorting and filtering requirements, you might need to add an index column and sort by it. Unlike Microsoft Excel, Microsoft Power BI doesn’t have the ability to ...