Tabular Archives -

About us

Shock horror !!! Guess what are your most valuable assets… your DATABASES! BICG’s SQL Server On Premise and Cloud Database experience is exemplary. BICG have been developing solutions in SQL SERVER, REPORTING SERVICES, ANALYSIS SERVICES and POWER BI since the get go. We’ve helped organisations architect National Data Sharing portals and we’ve trained people to transform their own business taking them from Zero to Hero.

We’ve got plenty of track record too. BICG’s portals are already providing bottom line benefits to dental and medical practices around Australia. BICG’s Data Cloud is already streaming source data out of Health, Financial and Education enterprises, into the cloud where the fast moving world of cloud analytics can work its magic. BICG’s Vault accelerates your Data Warehouse development by 90% over traditional approaches with clever Data Warehouse generation for on premises or cloud. BICG’s Cohort Power BI Widget demonstrates our passion and importance of finding the right visual for the right purpose. BICG’s SAP BO to SSRS converter accelerates your Business Objects migration effort by transforming every business objects report into a Reporting Services report shell. BICG’s Health Analytics provide subscription access to tried and tested predictive models that have been proven to solve real world problems in the Health sector. Products with tangible and proven benefits leading to lowering costs and promoting revenue growth.

With many forces and trends rapidly changing the face of business intelligence and spearheaded by cloud-based real time and mobile BI, BICG are the face to the new eco-system and methodology for future state data and analytics. Our products and experience take the heat and the cost out of data initiatives bringing bottom line benefits to the business from the start.

Tabular

Actions in Tabular Model using BIDS Helper – Part 2

by ANUPAMA AGARWAL February 21, 2015 in Tabular, Training 1 comment

Watch the video demonstration of using MDX in Caption, Condition and Expression for Action. This is Part 2 of 2 parts series about Tabular Action. In the last post we have seen how to create simple Drillthrough, URL and Report actions for Tabular Model using BIDSHelper. In this post we […]

Actions in Tabular Model using BIDS Helper – Part 1

by ANUPAMA AGARWAL February 21, 2015 in Tabular, Training 1 comment

Watch the view demonstration of creating actions in tabular model using BIDS helper. In the demo I have created 3 types of Actions – Drillthrough, Url and Report. As discussed last time, Tabular model does not support actions out of the box and since this is one of the sought […]

Introduction to BIDS Helper Add-in

by ANUPAMA AGARWAL February 20, 2015 in Tabular, Training 0 comments

Watch the video demonstration of BIDSHelper add-in for SQL Server Data tool. BIDS helper is Business Intelligence Development Studio/SSDT add-in to enhance functionality of the BI projects. BIDS helper has lots of features to enhance your Tabular/Multidimensional Cube, Integration service package and Reporting service reports. So if you want to […]

Importing Power Pivot to Tabular Model

by ANUPAMA AGARWAL February 19, 2015 in Power Pivot, Tabular, Training 0 comments

Watch the video demonstration of importing power pivot model to tabular model. In the last post, we have discussed the difference between Power Pivot and Tabular Model. Why do we need to Import Power Pivot in Tabular Model? In a scenario where Business users create a prototype power pivot model […]