Himanshu Gupta

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...

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...

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...

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...

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...

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...

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...

SQL Server 2012 SP1, SharePoint 2013 and Office 2013 are next generation business intelligence platform from Microsoft that will enable organizations democratize the concept of business intelligence. This new BI solution provides end-to-end capabilities...