Microsoft Twitter Analytics Tools(Consuming Big Data from Hadoop on Azure) with PowerPivot for Excel 2010 & Build PowerView Reports on SharePoint 2010 & SQL Server 2012 Analysis Services


Microsoft Twitter Analytics tool (Download from here) is part of SQL Azure Social Analytics Labs & leverages built in support for consuming Big Data (Hadoop on Azure, Hive Tables data, HDFS ) on BI tools(PowerPivot for Excel 2010, SSRS 2012 , SSAS 2012 & PowerView Reports on SharePoint 2010). Twitter Analytics is computed data for analysis of Social Analytics tool (Twitter, LinkedIn, Facebook) to compute Top Tweets of the Day, Top Tweeter, Top Mentions etc. Overall computation focuses on Big Data Analytics on Windows Azure features commonly consume big data from Apache Hive, HDFS on Azure to MS BI tools.

  • Lets start first installing the tool on local system. It needs PowerPivot for Excel 2010 as recommendation engine to analyse the analytics sheet.

  • The Twitter Analytics installer installs the Twitter Analytics PowerPivot Excel 2010 sheet on your desktop. Analyse the Twitter Analytics PowerPivot sheet by providing the comma seperated queries to get data for Top Tweets for Top MSFT Products(Bing, Windows Phone, SQL Server etc.)

  • Lets check for Top People section of the Twitter Analytics tool for Favourite MSFT Products.

  • The Top Tweet Tones & Mentions about Top MSFT Products renders as follows.

  • The Details data shows off the Twitter Data Analytics according to Search Query,Date, Time of Day,Type, Tone & Tweeters.

  • Next, upload the Twitter Analytics PowerPivot Excel sheet into SharePoint 2010 PowerPivot Gallery part in order to build interactive PowerView Reports on SharePoint .

  • After uploading to SharePoint PowerView Gallery, Click on PowerView Report icon to build up the PowerView Report.

 

  • Implement the PowerView Report on MSFT Twitter Analytics Social Analytics Big Data with SharePoint 2010 web part & select Top Tweets of the day, Top Mentions of the Day about top MSFT Products, Tones count & People Positive , Negetive & Neutral Tones on Products like Bing, Office, SQL Server, Windows Phone.

SharePoint 2010 with Windows Phone 7 Traning Kit is now Available


Accessing SharePoint 2010 applications are quite easy with the help of Windows Phone 7 which integrates directly with SharePoint. The training kit helps to leverage custom development using Microsoft SharePoint 2010 applications with Windows Phone 7 for OAuth services, Twitter API, Windows Azure, SQL Azure , Office 365, LinkedIn API, Silverlight Web parts & Bing Maps API.

Download the training kit from here: http://www.microsoft.com/download/en/details.aspx?id=26813

  • One of the great tool sharepoint 2010 with Windows Phone 7 toolkit is now available in codeplex which helps the windows phone 7 apps to access the SharePoint 2010 applications using Forms authentication.
  • It downloads lists of data with prepackaged filters to limit the data without writing CAML.

 

Social Computing with SharePoint 2010


Social Computing is an integrate part of SharePoint 2010 which helps to organise Corporate Organisation view in more social networking way like with LinkedIn, Twitter, Facebook , Microsoft Lync server 2010 integration. SharePoint ‘s MySite is a default example of Social Computing improvement starting point which build the personal blog site, wiki , personal profile, organization hiearchy, latest feeds from team – members etc.

  • The default profile page which shows the sample social web’s homepage in SharePoint 2010. Organise your profile & edit information in collaborative view.

  • Where you can edit the your MySite page with Web Parts options.

Building Silverlight Bing Maps based API with Cloud application in SharePoint 2010


Developing Bing Maps API based Silverlight applications are quite easy integrating with Windows Azure , SQL Azure databases with Microsoft SharePoint 2010. Bing Maps API provides a rich set of geolocation APIs which helps to easy integrate with Silverlight, Windows Azure application.

  • To use Bing Maps with Silverlight Web applications , you need to get the Bing Maps Developer key which can be obtained from www.bingmapsportal.com , register there with your Windows Live ID & get a developer key by clicking on create or view key.

  •  Next, you need keep the key in clipboard & should be used while developing your Silverlight application. Now create a new Silverlight application from Visual Studio & modify the following XAML into it.

  • Write in MainPage.XAML :

<UserControl x:Class=”SimpleBingMap.MainPage”

xmlns=”http://schemas.microsoft.com/winfx/2006/xaml/presentation&#8221;

xmlns:x=”http://schemas.microsoft.com/winfx/2006/xaml&#8221;

xmlns:d=”http://schemas.microsoft.com/expression/blend/2008&#8243;

xmlns:m=”clr-namespace:Microsoft.Maps.MapControl;assembly=Microsoft.Maps.MapControl”        

xmlns:mc=”http://schemas.openxmlformats.org/markup-compatibility/2006&#8243;

mc:Ignorable=”d”

d:DesignHeight=”300″ d:DesignWidth=”400″>

<Grid x:Name=”LayoutRoot” Background=”White” HorizontalAlignment=”Stretch”

VerticalAlignment=”Stretch” Width=”888″ Height=”394″>

<Grid.ColumnDefinitions>

<ColumnDefinition Width=”888*” />

<ColumnDefinition Width=”314*” />

</Grid.ColumnDefinitions>

<Grid.RowDefinitions>

<RowDefinition Height=”auto” />

<RowDefinition Height=”*” />

</Grid.RowDefinitions>

<StackPanel Grid.ColumnSpan=”2″>

<TextBlock Text=”Map Me!” FontWeight=”Bold” FontSize=”14″ Width=”888″ />

<StackPanel Orientation=”Horizontal” HorizontalAlignment=”Stretch” Margin=”12,0,12,0″>

<TextBox x:Name=”txtbxLatitude” Width=”322″ Text=”Type your latitude here,e.g. 47.7656″ FontSize=”10″ />

</StackPanel>

<StackPanel Orientation=”Horizontal” HorizontalAlignment=”Stretch” Margin=”12,0,12,0″>

<TextBox x:Name=”txtbxLongitude” Width=”322″ Text=”Type your longitude here, e.g. -122.9957″ FontSize=”10″ />

</StackPanel>

<StackPanel Orientation=”Horizontal” HorizontalAlignment=”Stretch” Margin=”12,0,12,0″>

<Button x:Name=”btnFindMe” Content=”Map It!” Width=”65″ Click=”btnFindMe_Click” />

</StackPanel>

</StackPanel>

<m:Map CredentialsProvider=”Av1a04p5K8Ubd97aV5dMMX7tRSbDxWz8hm01_4ZA8BA2kE7o56VvsNfjMOOrTnV5″ x:Name=”MyMap” Grid.Row=”1″ Mode=”AerialWithLabels” HorizontalAlignment=”Stretch” VerticalAlignment=”Stretch” Margin=”0,14,0,0″ Grid.ColumnSpan=”2″>

<m:Map.Children>

<m:MapLayer x:Name=”PushPinLayer” />

</m:Map.Children>

</m:Map>

</Grid>

</UserControl>

  • Write in MainPage.XAML.CS:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Animation;

using System.Windows.Shapes;

using  Microsoft.Maps.MapControl;


namespace SimpleBingMap

{

public partial class MainPage : UserControl

{

public MainPage()

{

InitializeComponent();

}

private  void btnFindMe_Click(object sender, RoutedEventArgs e)

{

Location myLocation = newLocation();

myLocation.Latitude = Double.Parse(txtbxLatitude.Text);

myLocation.Longitude = Double.Parse(txtbxLongitude.Text);

// Create a new pushpin to add to the map.

Pushpin myPPin = newPushpin();

myPPin.Width = 7;

myPPin.Height = 10;

myPPin.Location = myLocation;

PushPinLayer.AddChild(myPPin, myLocation, PositionOrigin.Center);

// Set the main view of the map using location with a zoom level

MyMap.SetView(myLocation, 10);

}

}

}

 

  • Map yourself in Bing Maps API by providing Latitude & Longitude:

  • Now, it’s time to integrate with your SharePoint 2010 website. Open the Add Documents Library option & Click on Add, Click browser & paste the path of Silverlight .xap file in SharePoint directory.
  • Click on Site Settings & Click on Edit Page to open the .xap file in SharePoint Web Part, Now open the insert tab-> Click on Media Content-> Silverlight Web Part -> paste the path of the Silverlight .xap file in the clipboard. Access it in Silverlight portal.

 

  • Configure the height & width according to configuration :

  • That’s it, The SharePoint applications is integrated with Silverlight web part along with Bing Maps API integrated in Cloud.

Installation of SharePoint Server 2010 & SharePoint Designer on Windows 7 SP1


Installation of SharePoint Server 2010 & SharePoint Designer 2010 is quite tricky on Windows Clients, as it’s prerequisites are built to work with Windows Server 2008 SP2 onwards.

  • But, it’s easily achievable by Cinfiguring the Setup/config.xml in SharePointServer.exe / SharePointFoundation.exe. First extract the contents of SharePoint Server 2010 by typing the following command from command prompt as elevated mode in Windows 7.

D:\SharePointServer.exe /extract:c:\SharePoint  (pointing that your SharePoint Server.exe exists in following drive & extraction folder the same)

  • Open config.xml from c:\SharePoint\files\Setup & add the following line under <configuration> tag:

                                     <Setting Id=”AllowWindowsClientInstall” Value=”True”/>

  •   Save it & close the config.xml
  • Next , try to follow the setup.exe from the command prompt as follows:

  • Find the installation option StandAlone or Server – farm & proceed to installation.

  • now configure the installation with the SharePoint Products Configuration according to the settings choosen.
  •     Install Microsoft Chart Controls , Windows Identity Foundation & start the SharePoint Product Configuration settings:

  • Check out the IIS application pools running the SharePoint Web farm & check  app-pools settings must be Enable 32 bit applications to FALSE & all SharePoint services should be started.

  • Installation of SharePoint Designer 2010: SharePoint Designer 2010 can be installed on Windows Clients according to the office 2007/2010 x86/x64 settings.
  • If you installed office 2010 x86 on your x64 Windows then please install SharePoint Designer 2010 x86 version.

SharePoint Designer 2010 SP1 Default Page 

Follow

Get every new post delivered to your Inbox.

Join 176 other followers

%d bloggers like this: