Emergence of Big Data 2.0

In last five years or so we have seen emergence of a whole new way to analyses data. Latest Gartner report indicates that 85% of data generated in an enterprise today is of new data types, those that we aren’t used to storing in traditional data warehouse systems. We have almost traversed half of the…


Working with compressed files in HDInsight

Ability to work with compressed data in a data-warehouse is well understood. It becomes even more pronounced when warehouse size runs in hundreds of terabytes and petabytes. Hodaap provides a way to interact with compressed files natively. Tools like Hive and Pig can read these compressed files and process them, thereby reducing storage requirements to…


Analyze semi-structured data using HDInsight

  Why should you care? Recent Gartner reports suggest that 85% of the modern data is generated in new data types – those that were traditionally not stored in data warehouses. By 2015, organizations integrating high-value, diverse, new information types and sources into a coherent information management infrastructure will outperform their industry peers financially by…


Understanding Memory configuration in BI Semantic model

Memory is by far the most critical resource for tabular model. Being able to monitor how much memory is being used and being able to configure it optimally is important in ensuring predictable performance.   First and foremost, let us understand how memory is used by SSAS. Processing: During processing, SSAS needs memory to load…


Get Started with Microsoft Data Explorer – Preview

What is Data Explorer? Data Explorer is an Excel plug-in that helps users discover data and convert it into a shape or form that they need. Data Explorer is only available as a preview at this point and works with Excel 2010 SP1 or Excel 2013.  You can download the Data Explorer preview from http://www.microsoft.com/en-us/download/details.aspx?id=36803…


Integrate Power View with SharePoint using web parts

SharePoint is one of the most widely used collaboration platform and its importance as an integrated business intelligence platform cannot be undermined. Microsoft BI platform has a comprehensive set of data exploration and reporting tools that truly democratizes the concept of business intelligence in an organization. While these gives you insights at different level, SharePoint…


Implementing Dynamic Security in Tabular Models

Before I discuss various options available for implementing dynamic security in tabular models, let me first pause for a moment and elaborate what I mean by the word dynamic security. What is Dynamic Security? In my view, dynamic security is a technique that enable a single role to apply different permissions for different users based…


Power and Simplicity of Time Intelligence in DAX

Almost all data analysis have to deal with dates/time. DAX offers a number of functions that simulate many calculations on dates, but using right function in the right way requires some explanation. Defining a separate date table is a common practice in any star schema and this is a suggested technique for any tabular model….


SQL Server 2012 Data Quality Services

Microsoft® SQL Server® 2012 Data Quality Services (DQS) is a new offering as part of SQL Server 2012 allowing customers to cleanse, de-duplicate, standardize, and enrich their data to deliver trusted information for business intelligence, data-warehouse, and transaction processing workloads. It is a user-driven, computer-assisted solution to identify incorrect or incomplete data and modify, remove,…


Building Windows Azure Reporting Services Application

Windows Azure SQL Reporting is a cloud-based reporting service for the Windows Azure Platform built on SQL Server Reporting Services. SQL Reporting provides many benefits, such as ·        Rapid provisioning ·        Cost-effective scalability and High availability ·        Reduced management overhead ·        Secure access for viewing and managing reports. Windows Azure Reporting offers the following capabilities:…