Creating Basic Report in SSRS by importing Data from Microsoft Dynamic CRM 2013

In this blog we will see how to connect CRM 2013 environment to create reports using FetchXML in Sql Server Reporting Services (Visual studio 2012 ) & uploading back to CRM.

1.  From the CRM 2013 click on Advanced find functionality to import FetchXML query for the given Entity

2.  Click on Results & then Download Fetch XML to generate the query as shown

3.  Open SQL Server Data Tools and create Reporting Service Project Wizard

 

4.  Give a name for your data source and the connection string followed by user credentials of CRM 2013. Then click OK.

5.  Click Query Builder and copy-paste the FetchXML query & click OK

6.  Select the fields which you need to display in the Report from the given dataset

 7.  Finally design and preview your report in SQL Server Data Tool

 

After final designing, you can upload the same report .rdl file back to Dynamics CRM 2013 so that it can be viewed by the clients for better understanding and  gaining crucial information.

Microsoft Windows Azure HDInsight - "A Cloud based Big Data Solution"

       What is HDInsight?

• HDInsight is Microsoft's Hadoop-based service that brings a 100% Apache Hadoop solution to the cloud. 

• HDInsight comes in two flavours: 

1.  HDInsight Server for local on premise installation of the Hadoop distribution
2.  HDInsight on Azure Service which is the easiest way to deploy, manage and scale Hadoop based solution

Why HDInsight?

•  Allows to easily build a Hadoop cluster in minutes when you need it, and tear it down after you run your MapReduce jobs which makes cost efficient

• Works seamlessly with Windows Azure Blobs, mechanisms for storing large amounts of unstructured data that can be accessed from anywhere

Why it can be useful for a particular organization

•  HDInsight service is Microsoft's azure based cloud service that allows you to gain deep & richer insight for better decision making from any data, any size and any location.

• Basically used to manage, analyse, and report on big data.

       Technology used & Skillset required

• Windows Azure Cloud service subscription
• Apache Hadoop
• MapReduce & HDFS
• Pig, Hive, Sqoop
• Programming language (C#, Java, Python)
• Structured Query Language (SQL)

      Scenario where we can opt to use HDInsight

1.  Problem statement: The famous Word count problem

Assume we have a large text file or probably a novel. We need to find the occurrence of each word in the given file.

Solution:

We can use Hadoop MapReduce for quick processing and getting the desired result in HDInsight

Later we can analyse the same result using Power BI
                          For a sample demo on word count problem click here

2.  Problem statement: Analysing crime data

Suppose we have a crime data for past 5 years containing billions of records.

We need to perform simple goal such as calculating the number and type of crime incident 

Solution:

We can achieve this in HDInsight using Hadoop MapReduce or Hive where output can be similar like shown below 

Table1. Crime data summarized by type (showing top 5 crimes)

Theft	823689
Murder	746563
Malicious mischief	445654
Drink & drive	339823
Damage to property	123377

For more details visit azure.microsoft.com