Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files. All measure groups by default have one partition but by splitting that partition you will gain improved query and processing performance.
Partitions can be split in any way you see… Read more
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted to see specific data. This can be accomplished by creating dynamic or table based security in Analysis Services which is much less difficult to setup… Read more
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 days writing calculations that return things like year to date, rolling twelve month, and period over period for every measure they have.
For the more… Read more
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 Designer to create a drag and drop datasets then it’s a piece of cake, but have you ever wondered what’s going on with all the… Read more
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 the Dimension Usage tab. The Dimension Usage tab is found when editing the cube in the cube designer. The screenshot below shows dimensions on rows… Read more
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 were. My goal with using Azure is to create an lab environment for student that fits the following needs:
- Easy to create new virtual…
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 a virtual machine you provide a size for the virtual hard disk (as shown below).
It’s pretty straight forward to expand the size of this… Read more
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, etc…) has becomes very apparent. In April 2014 Microsoft announced the release of Microsoft Azure Automation to handle such operations.
Activate Azure Automation
This new… Read more
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 Azure infrastructure world but I thought I could share some of my lessons learned in doing this. My first post will walk you through moving… Read more
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 take tools like Power Query to find and discover data and then quickly present it through tools like Power View and Power Map. These are… Read more
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 Excel and through Power Query select From Other Sources –> From Hadoop Files (HDFS)
Next you’re prompted to provide your Hadoop server name then click… Read more
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 now watch the recording here.
Following each webinar I like to post a quick Q&A session for everything I was not able to answer in the allotted… Read more
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 you can now watch the recording here.
Traditionally following a webinar I try to post a quick Q&A session for everything I was not able… Read more
I usually like to post follow up questions and answer that I wasn’t able to address during the webinar. Here’s… Read more
Come join me for this webinar on 4/17/2014 at 11:00 AM EST
Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest… Read more
Come join me for this webinar on 4/15/2014 at 11:00 AM EST
Q&A is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply… Read more
Come join me for this webinar on 3/13/2014 at 11:00 AM EST
The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and… Read more
I hope you were able to attend my free webinar on Choosing the Right Analysis Services: MOLAP vs. Tabular on February 11, 2014 that I delivered with Dustin Ryan. If you weren’t you can now watch the recording here.
Traditionally following a webinar I try to post a… Read more
Today Microsoft has officially announced the release of Power BI for Office 365. You can read the Power BI teams post on the release here:
Power BI has some pretty amazing features that allow users take control of their data. I’ve also written several posts in the past about… Read more
Today is the final day for the Power BI Contest voting and I could use your help to move on in the competition! Please take a moment and vote for my video here http://tinyurl.com/PowerBIDevin
Thanks for voting! Read more