Siddharth Mehta's Blog

Building Social Analytics with MS BI

2013-02-07T11:10:00.000-08:00

Every form of analysis needs data, but it's not possible that one might have that data generated and stored in organizational repository. Many forms of analysis depends upon data from third-party, and platforms like Windows Azure Marketplace are based on the same principle. Social Analytics...

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

Amazon Web Services (AWS) pocket reference for Business Intelligence Architects / Architecture Design

2013-02-02T23:53:00.000-08:00

Every large scale IT organization is organized in some form of verticals / Strategic Business Units (SBU), or in some other form. These may be grouped by geography / technology / industry groups etc. Almost inevitably every such organization has a cloud computing capability, and most of cloud based...

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

Data layer requirements for applications with cloud hosting and NoSQL databases - Cloudant

2013-01-30T06:59:00.001-08:00

MVC is one of the most famous and widely adopted application development design patterns. Typically data layer of applications starts off with features that requests actions related to data manipulations. If an application is public facing where users can sign-up on the app and consume...

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

Database Sharding, SQL Azure Federation, SQL Server 2012 and Sequence

2013-01-27T13:51:00.000-08:00

Almost everyone who is a SQL Server professional directly or indirectly knows the newly introduced Sequence object in SQL Server 2012. This post is not about explaining how to use it. Just google what most famous blogger have to say about Sequence object, and you would find that the only content in...

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

70-463 Exam Guide - Part 2

2013-01-24T04:06:00.002-08:00

How does dimensional modeling of a data warehouse enable / empower analytics ? 1) Data analysis often requires pivoting huge amounts of data. Attributes of a dimension (i.e. columns in a dimension table) ideally contains non-continuous data. Such data is often suitable to slice /...

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

70-463 Certification Exam Guide / Notes - Part I

2013-01-09T10:25:00.000-08:00

This blog has been silent almost across the previous year with very little activity. I got married, got 7 projects at a time on my back, worked as a Senior Architect, reviewed a book and lots more. I struggled striking a balance between personal life and professional life, and now I am trying to...

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

Using SSRS with Silverlight, HTML5, JavaScript, Flash, Google Charts and other third party products.

2012-10-14T04:18:00.000-07:00

SSRS, Powerpivot, Powerview, Excel Services, Powerpoint Services, Sharepoint Dashboarding all offer variety of data visualizations. But most of them end up with a static graphic image on a web browser, which is neither interactive nor appealing enough to the end users. Many architects take the...

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

Using Microsoft Office Project Server with MS BI ( SSIS, SSAS, and SSRS )

2012-10-06T10:55:00.000-07:00

Microsoft Office Project Server (MSPS) is one of the healthiest source of data in the microsoft ecosystem. Many departments especially CIOs have the greatest potential and probability to make extensive use of the data contained in Project Server. Almost every organizations have different projects...

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

HTML5 Browser Compatibility for BI Solutions

2012-10-02T10:28:00.000-07:00

Consumers of a BI solution are increasing and BI solution are increasingly becoming web-based. Technologies like Silverlight are not supported on platforms like iOS and browsers like Safari Mobile. HTML5 due to its capability to render rich media on mobile devices, is receiving more and more...

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

SSRS Report prototypes using Google Charts

2012-09-27T11:43:00.000-07:00

Contemplating and conceptualizing design of any application starts with almost no tools at hand. MS Office - Powerpoint and Excel, or similar products are the tools that remain available with the design and development teams for developing application screen design prototypes. MS Visio is generally...

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

SSRS reports on iPhone, iPad, Android, Windows Mobile for Mobile UI

2012-09-25T11:13:00.000-07:00

Viewing applications on mobile devices might sound like a small problem statement, but the actual solution requirement is much broader than just resolution adjustment. Some of the major challenges involved in the solution architecture are: 1) Single codebase for the model and controller...

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

Hadoop tools for SSIS, SSRS and SSAS like Integration, Reporting and Analytics

2012-09-23T10:43:00.001-07:00

Data hosting, processing and reporting is dramatically changing on a variety of extremely different platforms than ever. With the emergence of NoSQL and Big Data, systems such as Hadoop host unimaginable volumes of data. Google is soon to hit 1 Billion Android device activations. US and China...

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

iOS integration with MS BI Solution Architecture

2012-09-17T11:55:00.000-07:00

In my career experience, reporting has been the biggest piece of any solution. Mobile applications owns a large stake these days as an end-client application. Web is thought to be the ultimate platform for exposing your applications, but native applications that sits on mobile computing platforms...

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

Excel 2013 BI versus SSRS 2012

2012-09-10T11:55:00.000-07:00

1) Excel 2013 has PowerPivot 2012 integrated / inbuilt into it. This means access to vertipaq engine, data processing, and dashboard related benefits. Powerpivot 2012 is able to harness the power of Windows Azure Data Market too. More on the same can be read from here. 2) Excel 2013 had...

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

Excel 2013 Visualizations with SSRS 2012 Visualizations

2012-09-08T12:24:00.001-07:00

I see lot of data management and exploration giants busy in building bridges with big data territory driven by Hadoop. But once the mashed query results are out of heterogeneous data stores made up of relational as well as big data, humongous amount of data would be returned. Tabular or even...

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

Architecture Design Tools for MS BI

2012-09-08T02:52:00.000-07:00

I got married last month, just returned from my honeymoon and catching up with the workload and routine life. Visual Studio 2012 got RTM and can be downloaded from here. Some of the new enhancements introduced in VS 2012 caught my attention and I find it really impressive. One of the famous...

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

PowerView with SSRS 2012 Native mode and Excel 2013

2012-07-28T03:17:00.000-07:00

Office 2013 Preview has been released and is available for download from here. More about Office 2013 enhancements can be read from here. Powerpivot has now become a native part of Excel 2013, which was available as a separate add-in in prior version. This very of powerpviot comes with few new...

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

Download Free SQL Server Ebooks , Download Free Sharepoint Ebooks and more

2012-07-26T15:03:00.001-07:00

Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio Tom Dykstra Step-by-Step This series of tutorials shows you how to make an ASP.NET web application available over the internet by deploying it to a third-party hosting provider. The deployment method used is Visual...

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

Cloud Video and Cloud Computing Infographic

2012-07-18T16:29:00.000-07:00

Ever wondered how a datacenter looks like and the kind of equipments used to power the same ? What is the metal that sits beneath the service we address as Cloud ? Watch this short 10 mins video that takes you on a guided tour of Microsoft Data Centers which hosts the data stored in Windows Azure...

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

Career in Windows Azure and Career challenges due to Windows Azure

2012-07-17T14:16:00.001-07:00

Recently Microsoft made announcement about new feature releases and additions to Windows Azure. Scott Guthrie gave a keynote speech about the guided tour of Windows Azure enhancements, which can be downloaded from here. Some of the very impressive enhancements are as below: 1) IaaS offering:...

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

Migrating SQL Server and application server deployments across cloud environments

2012-07-08T16:48:00.000-07:00

Big names in the cloud business are Amazon, RackSpace, Azure (which is still catching up) and others. For those who don't know, Amazon makes more money from it's cloud business than selling books on the web. Another interesting fact is that Amazon had built its vast infrastructure for its...

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

Data warehouse certification , Business Intelligence and Analytics certification

2012-07-05T01:39:00.001-07:00

In Data warehousing and Analytics, lack of standard certifications have made it very hard for recruiters to identify "A" league professionals from impostors. When the topic of certification comes, there are basically two questions, why to get certified and how and what to get certified. I would...

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

Data Integration Services on SQL Azure platform

2012-07-04T03:08:00.000-07:00

They say that any knowledge never goes waste, but in IT parlance this saying can be redefined as any knowledge or DATA never goes waste. In my career till date, my experience has been that any successful business would have lot of external data processing as a part of its business functions....

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

Chart Chooser tool for SSRS. It's Free.

2012-07-02T01:28:00.000-07:00

Reporting is perceived to be a very common and underrated skill, as its comparatively easy to learn. DB and well as application professionals gain grip of reports development with a short learning curve. But in my views that does not make one an insightful reporting professional. Often due to the...

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

Microsoft Roslyn and SQL CLR 2012 : Impact analysis

2012-06-29T13:52:00.000-07:00

Few weeks back Microsoft announced CTP release of a new application development framework codenamed Microsoft Roslyn. To define it in one line for database professionals, it can be perceived as "Compiler as a Service" and gives more granular control of application code compilation. An in-depth...

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