Converting a PowerPivot model into an Analysis Services Tabular model can be seen as the wormhole bridge between the Business and I.T. worlds. Self service B.I. gives the desktop Excel user the power to create sophisticated data models without much engagement with I.T. other than securing some data sources. This gets the business going on refining concepts and […]
Unpivoting your data means grabbing a data series from buckets across the columns of your data source (usually a spreadsheet) and transposing along the rows instead. This can be accomplished with a wide variety of tools, however two will be covered here, T-SQL and the Data Explorer plugin for Excel 2013. The TQL Example […]
Excel Power View reports encourage you to drag the elements you need for your chart onto the report surface in the way of a table first, then you can convert that table to a number of different chart visualisations in a second step. Having trouble converting to a chart ? First you need to have something worth […]
What a lame duck Visio 2013 is when it comes to reverse engineering a database – gone. Try Visio 2010 Professional or Premium editions instead. The following blog outlines the differences in the editions http://blogs.msdn.com/b/visio/archive/2010/04/09/visio-2010-editions.aspx.
Need a percentage of total measure in DAX? Read on… Lets say you want a report on products, showing % of each product’s Sale Amount to the total Sale Amount for all products selected. Business Formula is SUM(Product Sales) / SUM (All Selected Product Sales). Best to split the formula up into a set of seperate measures, […]
First time users of Excel 2013 running 64 bit – Power View requires Silverlight to be installed, however if your default browser is set to anything but Internet Explorer, you need to ensure you paste the install link into Internet Explorer and install from download IE created instead. Browser wars !
Useful reference for converting Vmware images to Virtualbox http://www.howtogeek.com/125640/how-to-convert-virtual-machines-between-virtualbox-and-vmware/. The approach uses the ovftool executable from your VMPlayer or VM Workstation installation to create an OVF file, which is then imported to Virtualbox using the Import Appliance feature from the Virtualbox File menu. The conversion to OVF file is reasonably slow, so you will have […]