Siddharth Mehta's Blog

Intelligent Reporting on fluid data sources using Analyzer

2011-12-21T09:03:00.000-08:00

Microsoft Excel is one of the most widely used tools for a variety of business purposes, due to its simplicity, calculation abilities and efficiency as a client tool for accounting purposes. Excel is the tool of choice for not only business users, but for a wide variety of users, right from field...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Difference between DirectQuery and In-memory mode in tabular mode analysis services

2011-12-18T14:01:00.000-08:00

Tabular models are one of the new enhancements coming in SQL Server 2012 especially with tabular mode analysis services. Querying data from these models is available in two modes: DirectQuery mode and In-memory mode. Those who are well versed with Multidimensional mode analysis services can grasp...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

How to install PowerView ? Why Data Alerts and Powerview are not available in native mode SSRS ?

2011-12-06T12:12:00.000-08:00

This blog has been silent for quite some time. I am recovering from an accident, a few turbulence in personal life including laptop crash. I am also busy these days in my new book authoring assignment. I would like to keep the details of the book under the covers, till the time gets mature to...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Operational Data Analytics using Analyzer

2011-10-19T12:40:00.000-07:00

Any quantitative data analysis would mean that there are a huge number of data points to analyze using visualizations and derive meaningful readings from this sea of data. A major part of the reporting world is composed of analysis of operational data, compared to analytical data. Reporting and...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Excel Services data source in Performancepoint Services 2010, Hadoop Data Source : New breed of data sources

2011-10-17T13:55:00.000-07:00

Data is the only currency that is generated every second in IT business and its the only currency that every business was to gather and utilize in the best possible way. BIG data and Unstructured data are creating tsunami sized data related challenges for storage, processing, as well as analysis....

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

SQL Azure Federation Architecture Solution

2011-10-11T12:28:00.001-07:00

Federations is one of the most effective aspect of any architecture design, which basically provides de-centralization of operations, effectively providing parallelism, scalability, de-coupling and multi-tenancy. Cloud has become a dominant platform for any kind of architectures, and federations on...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Tribute to Sir Steve Jobs

2011-10-06T11:33:00.000-07:00

Edward Tufte and Stephen Few are two of the most famous names in the field of Information Visualization Design. But in my views Apple has done wonderful work in this field, and Sir Steve Jobs contribution in the field has been immense and which cannot be explained in words. Sir Steve Jobs needs no...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Powerpivot and BISM in SQL Server Denali

2011-10-03T11:57:00.000-07:00

Business Intelligence Semantic Model (BISM) is the new philosophy in MS BI analytics parlance, that is taking shape in SQL Server Denali. Tabular projects and MOLAP with choice of MDX or DAX can be termed as a brief definition of BISM, in tangible terms. SQL Server Denali CTP3 ships with all the...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Data change alerts in SSRS Denali and Performancepoint Services 2010

2011-09-25T12:42:00.000-07:00

Time is money and this philosophy turns into a requirements when it comes to reporting. RSS changed the way people access information, as one no longer needs to continuously poll the source of information to check for updates. Reporting environments may start with a modest set of reports, but over...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

SSRS Denali enhancements in Sharepoint integrated mode

2011-09-13T13:24:00.000-07:00

I apologize to my blog readers that I have been very passive in blogging these days, but I am just recovering from some personal issues and getting on track. I promise to be back on normal pace of my blogging within a weeks time. Advancements in SSRS Denali, as heard and seen in TechEd seems to be...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Intelligent Distribution Analysis using Analyzer

2011-09-07T06:28:00.000-07:00

Business intelligence reporting tools should be capable of analyzing massive amounts of quantitative data via categorization into distributed frequencies and groups. The intelligence expected here is facilitating analysis of data density distribution across various logically-related or unrelated...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Azure Design Patterns

2011-08-29T10:17:00.000-07:00

I have been very busy these days with personal matters, and have not been able to extract time for blogging. I apologize to my readers for the same. Microsoft Azure cloud environment is a rapidly growing cloud platform. With the release of Hadoop connectors for SQL Server, support for Hadoop...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Using Graph Database on Windows Azure

2011-08-21T01:04:00.000-07:00

Unstructured data is the newest and most vibrant source of data, that organizations want to mine for rich business intelligence. SQL Server and Sharepoint and the front runners from the Microsoft platform in the field of BI. SQL Server being a RDBMS, is not the right choice to contain unstructured...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Unstructured data in SQL Server Denali

2011-08-14T12:22:00.000-07:00

Microsoft seems to be floating support for unstructured data in bits and pieces, which increases its sustainability towards the upcoming challenges posed by BIG and unstructured data. RDBMS is going obsolete gradually, and BI professionals are almost abandoning plain vanilla RDBMS, which I have...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

MS BI and Hadoop Integration using Hadoop Connectors for SQL Server and Parallel Data Warehouse to analyze structured and unstructured data

2011-08-09T02:38:00.000-07:00

Not-only SQL (No SQL) is ruling the world of unstructured data for data storage, warehousing and analytics, with Hadoop being the most successful and widely used technology. There are two choices you can make when something is gaining immense acceptance: either you can abandon and keep competing...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Columnar Databases and SQL Server Denali : Marathon towards being world's fastest analytical database

2011-08-07T11:13:00.000-07:00

Have you ever heard of what are columnar databases? You might be wondering this is something new - The answer is No and Yes. Columnstore is not a new technology that has evolved suddenly and is making waves in the database community. It has been in the industry for quite some time. Generally...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Geospatial Reporting and Analytics using Analyzer

2011-08-03T23:09:00.000-07:00

Data representation has many forms. The intended method and purpose of analysis as well as the nature of the data will determine which form of data representation is most appropriate. With the growing need for better analytics, reports today are increasingly expected to be interactive enough to...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

SSIS on Cloud with SQL / Windows Azure : Future Applications

2011-08-02T14:15:00.000-07:00

Generally cloud and ETL have a typically known application of facilitating ETL, which mostly harnesses the elasticity of computing resources. ETL on cloud is ideal for applications where data is already stored on the cloud. Regular line of business applications would process data from OLTP sources...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Infographics in a BI Solution

2011-07-31T11:49:00.000-07:00

These days my interests have been converging a lot on subjects related to extracting BI from unstructured data. Editing a few properties, learning a few functions, developing few queries for faster data access, authoring colorful reports and more tasks like these make many professionals feel so...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Data Warehousing and Analytics on Unstructured Data / Big Data using Hadoop on Microsoft platform

2011-07-25T07:00:00.000-07:00

A major community of data warehousing professionals grow up from the old school of Kimball and Inmon methods of data warehousing. Lots of professionals do boast on virtualization, complex MDX querying, performance tuning OLAP engines and managing data warehouse environments of the size of a few...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

DQS Cleansing Transform in SSIS - Data profiling and cleansing using SSIS and DQS

2011-07-18T12:04:00.000-07:00

Data Quality Services has come up with some interesting concepts. 1) Two main pillars of DQS concepts are - Knowledge Base and Domains. 2) In laymen terms I would consider KB as tables and domains as fields of those tables. Domains have datatypes, constraints, and other attributes just like...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

MS BI for Time Series Analysis, Deviation Analysis, Regression Analysis, Correlation Analysis and Distribution Analysis

2011-07-15T08:57:00.000-07:00

Few questions are very important to get answered before anyone dives into the sea of business intelligence. You would find many professionals who cannot make out the difference between reporting data and business intelligence. I recently met one senior professional having approx 14 years of...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Install SQL Server Denali CTP3 - SSDQS and BISM leads the show

2011-07-13T11:18:00.000-07:00

SQL Server Denali CTP3 and SQL Server 2008 R2 SP1 have been publicly released, and is available for download. You can read about the official announcement from here and the quick link to download Denali CTP3 is here. Star of the release seem to be SQL Server Data Quality Services and Business...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

MS BI Architecture Design Layers - classifying layer specific logic

2011-07-11T13:11:00.000-07:00

Any architecture design diagram is composed of several layers vertically and horizontally. Horizontal layers are discrete logical areas and their association in the diagram describes the way they are connected to each other. Vertical layers run across the entire solution and all these logical...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com

Evaluate MS BI Architecture Design

2011-07-10T10:42:00.000-07:00

Architecture Design of any solution in general is done by a solution architect or a group of architects like App Architect, Data Architect, Infra Architect etc and this group is guided by a solution architect. Design is one part of the SDLC but other part is reviewing the design. Design review is...

Please visit Siddharth Mehta's Blog for entire article: http:\\siddhumehta.blogspot.com