When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS they likely have spent several
Author: devinknight
Writing Parametrized MDX for Reporting Services
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all you need is the Query
Understanding Analysis Services Relationships using Dimension Usage
As a part of designing an Analysis Services cube you must define how each dimension is related to each measure group in your cube through
Using PowerShell to Build your Azure VM Environment
In a previous post I wrote about Using a Hyper-V VHD in an Azure VM. Today I’d like to show you what my next steps
Reducing the Disk Size of a Hyper-V Virtual Machine
Have you ever created a Hyper-V virtual machine and later needed to change the size of the disk on the VM? When you initially create
Setting up Automation in Azure
As I’ve started digging deeper into using Azure the need to automate tasks (turn off all VMs, turn on all VMs, automatically resize all VMs,
Using a Hyper-V VHD in an Azure VM
I’m in the process of moving some my lab environments that I use for teaching SQL Server classes to Azure. I’m pretty new to the
Power Pivot as the Core to your Power BI Solution
I’ve noticed a recent trend with many presentations and articles on Power BI and Excel functionality. Many of these presentations show how quickly you can
Power Query to HDFS – Remote Name Could Not Be Resolved
I wanted to share a quick resolution I had to a problem with connecting Power Query to data stored in HDFS. Seems easy enough. Launch
Creating Power Map Reporting Solutions Recording and Q&A
I hope you were able to attend my free webinar on Creating Power Map Reporting Solutions on April 17 2014. If you weren’t you can
Bringing Power BI Q&A to your Organization Recording and Q&A
I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014. If you weren’t
Upcoming Webinar – Creating Power Map Reporting Solutions
Come join me for this webinar on 4/17/2014 at 11:00 AM EST Creating Power Map Reporting Solutions Excel 2013 with Office 365 brings many new
Upcoming Webinar – Bringing Power BI Q&A to your Organization
Come join me for this webinar on 4/15/2014 at 11:00 AM EST Bringing Power BI Q&A to your Organization Q&A is an amazing new feature
Introduction to Power BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on March 13, 2014. If you weren’t you can now
Devin Knight 