Netwoven Tech-talk

All posts by Viraj Bais

Dynamics CRM Content Pack for Power BI

Posted by
Date : April 4, 2017

Part 1: Embedding Content Pack in Web Page

The Microsoft Dynamics CRM content packs for Power BI allow you to easily visualize data in your Dynamics CRM Online or on-premises tenant. The Sales Manager content pack focuses on sales related CRM entities such as Leads, Opportunities, Accounts etc. and analyzes sales performance through key metrics like Won and Lost Revenue, Sales Leaders, and Top Accounts. Similarly the Service Manager content pack includes data from service CRM entities such as Cases, Queues, and Knowledge Articles. You can deploy the content packs in Power BI service to show data from your Dynamics CRM online or on premises tenant, and customize the content packs to display custom fields or option set values you may have added to the CRM entities as part of your deployment. Continue Reading…

The Basics of Hadoop

Posted by
Date : September 11, 2013

In this blog series, we will discuss the Hadoop ecosystem (with a focus on Hortonworks distribution of Hadoop for Windows Server and HDInsight Service for Azure) – core technologies such as HDFS and MapReduce, Pig (containing a data flow language to support writing queries and dataset transformation on large datasets using richer data structures than MapReduce), Hive (a SQL abstraction on top of MapReduce for more structured data), Sqoop (a tool to transfers bulk data between Hadoop and relational databases), Mahout (an open source machine-learning library facilitating building scalable matching learning software), and Pegasus (a peta-scale graph or data mining system running on Hadoop). Continue Reading…

Install and Configure SQL Server 2012 PowerPivot for SharePoint 2010 Using PowerShell

Posted by
Date : September 4, 2012

The PowerPivot feature in SQL Server 2012 provides powerful data mashup capabilities to support self-service BI scenarios. It’s based on the xVelocity in-memory analytics engine that achieves very high performance for analytic queries by leveraging columnar storage, compression, and parallel data scanning and aggregation algorithms. PowerPivot integrates with SharePoint Server 2010 to provide a reliable platform for building the managed BI collaboration environment such as avoiding proliferation of spreadmarts, ensuring data consistency and data refresh across user-generated workbooks, and providing and monitoring usage patterns. It also takes advantage of core SharePoint capabilities such as role-based security, versioning, compliance policies, and workflows. Continue Reading…