Explore the importance of data analysis in an end-to-end BI system.
More articles by Anoop Kumar
Learn more about various Business Intelligence components, architecture, data modeling, and its importance.
Anoop Agarwal discusses the fundamentals of Business Intelligence (BI) and various data Warehouse design approaches. In this first article of the series, he shares how Big Data is different from traditional BI.
In today’s technology world, Big Data is a hot IT buzzword. To mitigate the complexity in processing large volumes of data, Apache developed Hadoop – a reliable, scalable and distributed computing framework. Read on to learn more.
Code coverage is a way to measure what percentage of the source code of a program has been tested. Read on to learn how code coverage can help to improve the overall quality of a program and how to leverage Microsoft VSTS to get code coverage for Windows Azure Service and .Net.
Learn how to improve your SQL query performance with these ten tips, including re-writing of queries and the creation and use of indexes.
Anoop Kumar shares his top 10 transformations to manage and change data in SSIS.
Anoop Kumar shows you how easily ETL performance can be controlled at any point of time by sharing 10 common ways to improve ETL performance.
Anoop Kumar discusses some common operators that are useful to interpret a graphical execution plan and troubleshoot any performance issue due to a badly written query.
Learn how SQL Server generates a query execution plan and the processes involved to achieve the task.
Learn how to identify a performance bottleneck on Windows Azure SQL Database using Microsoft System Center.
Learn how to use Microsoft Windows Azure SQL Database to deploy hassle-free relational database solutions on the cloud while realizing the benefits of a distributed data center that provides high availability, scalability and security.