Power View Resources

I was doing some research on Power View capabilities recently and came across some good blogs on it, thought I will compile and share it:

Video Series: Visualizing the Summer Olympics. Microsoft Senior Program Manager Sean Boon created a good blog series on Power View. He talks about how you can set custom images in power view.

http://blogs.msdn.com/b/microsoft_business_intelligence1/archive/2012/08/09/visualizing-the-olympics-with-power-view-in-excel-2013.aspx

Power View Design Tasks:

http://office.microsoft.com/en-us/excel-help/power-view-explore-visualize-and-present-your-data-HA102835634.aspx?CTT=5&origin=HA103040163

http://office.microsoft.com/en-us/excel-help/power-view-basic-design-tasks-HA102835646.aspx

Images in PowerView: Static and data linked images

http://office.microsoft.com/en-us/excel-help/images-in-power-view-HA103240499.aspx?CTT=5&origin=HA103276078

PowerPivot Model for PowerView Reports

http://technet.microsoft.com/en-us/library/hh759324.aspx

Power View Help for SQL Server 2012

http://technet.microsoft.com/en-us/library/hh965698.aspx

Posted in Business Intelligence, PowerPivot, PowerView, SharePoint | Leave a comment

Workflow Manager Installation Error: Adding host to Service Bus Farm

I was trying to get the new workflow engine installed and configured with SharePoint 2013 but was encountering an error in the Service Bus configuration step.

Installation Instruction for Workflow Manager and SharePoint 2013 Workflow Configuration:

The full installation steps are provided here (in a video series): http://technet.microsoft.com/en-us/library/dn201724.aspx and here: http://technet.microsoft.com/en-us/library/jj193478

The instructions provided above are pretty detailed and helpful except that I kept getting this error while configuring workflow manager and there was not much to go with online.

The Error:


System.InvalidOperationException:

Program C:\Program Files\Windows Fabric\bin\Fabric\Fabric.Code.1.0\FabricDeployer.exe exited with error: Windows Fabric deployment failed.DeploymentValidator:

warning: The Fabric Data Collection Agent is disabled for this deployment.
None of the declared nodes is for the current machine.


 

Finally i looked at the hosts file on the Developer VM and noticed that I had an entry for 127.0.0.1. Since I was using FQDNs for my workflow configuration, I commented this line and that fixed the error.

so open the file: C:\Windows\System32\Drivers\etc\hosts in notepad or a text editor and comment out the line with entries to the local host (127.0.0.1)

Posted in Installation, SharePoint, SharePoint Server, Tips and Tricks, Workflow | Tagged , , | Leave a comment

The Science of User Experience Design

User Experience design has always been, and continues to be, a field riddled with ambiguous labeling and nomenclature. We hear all sorts of conjecture and debate as to what terms have what specific meaning. Are profiles and personas the same thing? When exactly do wireframes become mock-ups? Is “mock-up” supposed to hyphenated? These are issues of semantics, and when it comes to the actual meat of the work we do, we could call a wireframe a “whosamawhatsit” and it wouldn’t change it’s purpose. From the perspective of standardizing our professional space, common labeling is important. This is not in doubt. Client, asset, and project management aside, there is something vital to the decisions that we make as designers that is not addressed as often as it should be: Science. Read More »

Posted in Graphic Design, Interaction Design, Motion Design, User Experience, User Experience Design | Tagged , , , , , , | 3 Comments

Why the 100 Parameter Limit in the BizTalk Table Looping Functoid Shouldn’t Matter

If you have ever used the Table Looping functoid in a BizTalk map, then you’re aware of its ability to take multiple inputs (whether they’re links from a source schema or other functoid outputs), and configure them as a table looping grid, so that these values can be used to create multiple nodes in the destination schema.  Essentially, this functoid can be used to unpivot repeating or flattened data into multiple nodes.

For example, in the mapping below, I’m taking a flat file that has repeating fields to represent ten Line Items, all on a single record.  Using the Table Looping functoid, I can map these repeating fields to create multiple LineItem records in my destination.

TableLoop1_BlogEdit

Read More »

Posted in BizTalk | Tagged , , | Leave a comment

BizTalk Server – How to Route Failed Messages to ESB on Send Ports where Delivery Notification is Enabled

The Issue

The ESB Toolkit 2.1 Exception Handling Framework provides the ability to easily report and and alert on both routed failed messages (where Failed Message Routing is enabled on a Receive or Send Port), as well as ESBFaults created from exceptions within an Orchestration. 

However, if you try routing failed messages on a Send Port that is bound to a Logical Port that has Delivery Notification enabled, you’ll get a Send Port failure with the following exception:

ESBAllExceptions_EventLog_ErrorMsg_BlogEdit

Read More »

Posted in BizTalk, ESB Guidance and SOA | Tagged , , | Leave a comment

Using Data Graphics in Visio 2013

Visio 2013 was released recently with updates including the new visio file format .vsdx, easier collaboration abilities and my favorite, the ability to provide data graphics to shapes. In this blog I will be discussing some of the basics of creating and using these data graphics with both internal Visio data and external data sources.

Read More »

Posted in Uncategorized | Tagged , , | Leave a comment

SharePoint Rolodex Using the Query String Filter Web Part

Navigating through a list or library with dozens or hundreds of items or folders can be a tedious task.  There are a few ways to make it easier to find the information you are looking for.  One unique way is to build a rolodex to filter the list items conveniently.

The rolodex is configured by using a Query String Web Part and Content Editor Web Part to filter a list or library. The high-level steps to accomplish this are:

  1. Create an “Index” field in the list or library.
  2. Add a Query String Filter Web Part, a Content Editor Web Part, and the web part for the list to a site page.
  3. Add code to the Content Editor Web Part with links that reload the page with the query string value.
  4. Configure the Query String Filter Web Part to send data to the list web part.

I’ll use a Customers list for this example.

Read More »

Posted in SharePoint 2010 | Tagged , , , | Leave a comment

Setting up an External Domain Trust in a simple SharePoint 2010 Extranet with separate AD Domains – and completing a profile sync.

Background

The requirement for a domain trust relationship depends on how a SharePoint Farm is configured, the SharePoint Farm could either reside in a perimeter network (or hosted environment), or the SharePoint Farm could be split between a perimeter network and the internal network.

Scenario

In this post we will assume a simple SharePoint Extranet where a SharePoint Farm and an Active Directory are in a hosted environment, and resource from the local Corporate domain (domain.local) are needed in the hosted environment (domain.ext).

 

Extranet Topology

Read More »

Posted in SharePoint 2010 | Tagged | 2 Comments

Whats new in BizTalk360

We have a great love for BizTalk 360 here at Tallan, and the many capabilities it affords to the realm of BizTalk monitoring, alerting, and governance.  For those not familiar, BizTalk 360 is a web based portal designed in Microsoft Silverlight which monitors BizTalk environments and is designed to address the the common hurdles enterprises face when managing BizTalk environments.  One great example of this is the fact that by default, there are two windows groups used by BizTalk for the purpose of administering a BizTalk environment, the BizTalk Administrators group, and the BizTalk Operators group.  The problem comes into play when an enterprise tries to control the access that users have to the BizTalk environment and realize that the BizTalk Operators group lacks most of the rights needed to properly administer an environment, and the BizTalk Administrators group has too many permissions necessary for normal day to day operations.  BizTalk 360 solves these issues and more.

Read More »

Posted in BizTalk, Performance Tuning, Upgrading | 1 Comment

An Overview of BizTalk Server 2013

Microsoft BizTalk Server 2013 was recently released and it includes many new features that make developing and deploying for BizTalk considerably more efficient.  There are also many new features which expand on the already vast capabilities of a BizTalk Solution.

In this post I will go over the new features of Microsoft BizTalk Server 2013.  And explain how a few of the new features can contribute to a more efficient solution.

Read More »

Posted in BizTalk, Cloud, General, Upgrading | Tagged , | 1 Comment