Willy Wonka and the Microsoft Business Intelligence Roadmap

Hold your breath… Make a wish… Count to three… Microsoft’s headspace for the next few years is to put the power of data in the hands of every business and person on the planet.   It is the objective to serve over a billion users with the Microsoft business...

Performance Point Per User Filter Caching

At BICG we have been using Performance Point filters and connecting them with custom SharePoint solutions to deliver top notch functionality and dashboards to our customers that are not available out of the box. But there are many tweaks and settings in PPS which is not fairly...
BI Analytics and Reporting

Overview of SQL Server 2016 features for Business Intelligence

No doubts that SQL Server 2016 is the hugest leap forward in Microsoft Business Intelligence platform history with features that increase performance, simplify management, and transform your data into actionable insights. Moreover, you have powerful reports and dashboards on the...

Create a Date Table in Oracle

Occasionally you may be working with non Microsoft data sources such as Oracle over front end tools like Power Pivot or Reporting Services. Some options for a date table include creating a linked table in Power Pivot or generating a table in the data source. Generate a date table...

Amazon Redshift and Tableau for Data Discovery

This multi-part tutorial demonstrates how to get instant data warehousing and reporting in place using Amazon Redshift and Tableau.  Once your data is available in Redshift, begin Reporting within Tableau by utilising the out of the box Redshift data connector.   If you...

PowerPivot Oracle query returns 0 rows

You have run and tested your Oracle query in your fave client, such as Oracle SQL Developer or Toad. The query tests fine and returns a bunch of rows. You create an Oracle connection (see https://msdn.microsoft.com/en-us/library/gg399158%28v=sql.110%29.aspx), you paste your...

Power BI for Office 365 Unveiled

Microsoft unveiled Power BI for Office 365. Power BI for Office 365 brings self-service BI solutions to everyday business users through the familiar tool they already use – Excel. Combining the familiarity of self-service BI capabilities in Excel with the ability to host...

PowerView for Multidimensonal Model is Released

SQL Server 2012 Service Pack 1 Cumulative Update 4 now has the release version of Power View for multidimensional model which was under Preview since November 2012. This is a exciting feature of SQL Server 2012 BI, we are waiting for long time. It present a great opportunity for...
Send