SQL Cheat Sheet: Retrieving Column Description in SQL Server

In SQL Server, details regarding a specific table column – e.g. column name, column id, column data type, column constraints – can be retrieved by joining system tables such as sys.tables, sys.columns, sys.types. Query 1: Fetching tables and object_id About sys.tables sys.tables is a system table and is used for maintaining information on tables in … Read moreSQL Cheat Sheet: Retrieving Column Description in SQL Server

More than Data: It’s Networked BI that Enables a “Single Version of the Truth”

Data governance is a broad topic that people seem to agree is important, but still argue about the details. Specifically, it’s hard to find an IT professional or BI and Analytics user who doesn’t believe that good execution on data governance will yield the “single version of the truth” required to make confident, accurate business … Read moreMore than Data: It’s Networked BI that Enables a “Single Version of the Truth”

AI+BI: Augmented analytics will soon bring data-driven insight to the masses

When you hear the words “artificial intelligence,” (AI) what’s the first thing you think of: robots doing backflips, Alexa, medical diagnostic innovations or something else? If you’re a business intelligence (BI) and analytics application user, it’s likely that “data-driven insight to the masses” will soon be top-of-mind. Machine learning will transform BI and analytics Any … Read moreAI+BI: Augmented analytics will soon bring data-driven insight to the masses

Use Analytics to navigate the digital transformation in manufacturing and distribution

Digital transformation in manufacturing and distribution is creating new possibilities, but also headaches for businesses.  The availability of new and smart technologies (for example, IoT, Big Data, Blockchain and Machine Learning) provides manufacturers and distributors with additional sources of data, which they can analyze to: Increase margins. Improve on-time deliveries. Boost customer satisfaction. Win in … Read moreUse Analytics to navigate the digital transformation in manufacturing and distribution

Jet Reports 2018 R2 Release: The Multi-Tasking Magic of Background Reporting Has Arrived

When it comes to groundbreaking innovations in reporting and business intelligence, the April 19th, 2018 release of Jet Reports doesn’t disappoint. This update to the Excel integrated solution introduces a new concept called “Background Reporting.” A Jet Reports original feature, Background Reporting delivers the ability to run, refresh, and save real-time reports while you continue … Read moreJet Reports 2018 R2 Release: The Multi-Tasking Magic of Background Reporting Has Arrived

New memory options for Analysis Services

We’re happy to introduce some new memory settings for Azure Analysis Services and SQL Server Analysis Services tabular models. These new settings are primarily for resource governance, and in some cases can speed up data refresh. IsAvailableInMdx The IsAvailableInMdx column property is available in Azure Analysis Services and SQL Server Analysis Services 2017 CU7. It … Read moreNew memory options for Analysis Services

Birst Named to Constellation ShortList™ for Cloud-Based Business Intelligence and Analytics Platforms for 4th Straight Time

Today, Constellation Research, a leading technology research and advisory firm based in Silicon Valley, announced that Birst, an Infor company, for the fourth consecutive time, has been named to the Constellation ShortList for Cloud-Based Business Intelligence and Analytics Platforms. The Constellation ShortList recognizes leading Cloud BI solutions that help companies gain deep, contextual insights from … Read moreBirst Named to Constellation ShortList™ for Cloud-Based Business Intelligence and Analytics Platforms for 4th Straight Time

Bitnami