Who is online?  0 guests and 0 members
Home  »  Blogs  »  DevinKnight

Communifire Blogs

Blogs RSS Feed

DevinKnight : Most Recent postings

DevinKnight

Creating a Reporting Services Subscription

10 days ago by DevinKnight  -  Comments: 0  -  Views: [367]

Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either by email or Windows File Share. Subscriptions can also be scheduled so if your end users need a report monthly you can automate the delivery process. The steps given in this article will show you how to configure subscriptions using the Windows File Share delivery method. Before you start to configure your first subscription make sure to have the following taken care of first:...

Read More

DevinKnight

Optimizing Power BI Q&A with Synonyms and Phrasing using Cloud Modeling

22 days ago by DevinKnight  -  Comments: 0  -  Views: [1544]

If you’ve have used or even just seen a demo of Power BI Q&A you’ve likely seen there’s great potential in the feature for even low-tech user. I usually say, “If the user knows how to use a search engine then they can interact with Q&A.” You can read the basics of how Power BI Q&A works from my previous post here . While having this capability is great it can take some fine tuning to perfect for users interacting with it. Power BI provides you with the a...

Read More

DevinKnight

Analysis Services Partitions

9/5/2014 by DevinKnight  -  Comments: 1  -  Views: [1157]

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 fit. Many people choose to separate measure group data by date. This makes sense because just about every fact table is going to have a date dimension associated with it. It also makes for a clear ...

Read More

DevinKnight

Analysis Services Dynamic Security

9/3/2014 by DevinKnight  -  Comments: 0  -  Views: [772]

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 than it sounds like. In this article I will walk you through the setup needed on the relational database side as well as Analysis Services side to get this working in your environment. You will start by identif...

Read More

DevinKnight

MDX Time Calculations Built to Scale

8/14/2014 by DevinKnight  -  Comments: 2  -  Views: [1183]

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 adventurous developer they have tried using the Business Intelligence wizard which automates the process of writing time calculations on selected measures. It creates an attribute in the...

Read More

DevinKnight

Writing Parametrized MDX for Reporting Services

8/4/2014 by DevinKnight  -  Comments: 0  -  Views: [987]

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 MDX that the Query Designer creates. Or how about how do the parameters work that it creates inside MDX. I’ve heard many report writers that use Analysis Services as a data source (including myself) say it is too difficult...

Read More

DevinKnight

Understanding Analysis Services Relationships using Dimension Usage

7/15/2014 by DevinKnight  -  Comments: 0  -  Views: [2605]

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 and measure groups on columns. The points at which they intersect define how they are related. These relationships are automatically defined when the two objects (measure groups and dimensions) are added to the cub...

Read More

DevinKnight

Using PowerShell to Build your Azure VM Environment

6/30/2014 by DevinKnight  -  Comments: 0  -  Views: [2596]

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 environments Easy to power down virtual environments Easy to power up virtual environments Easy to delete all virtual environments The point of this post is to guide you through how to easily create virtual machines for multiple students or empl...

Read More

DevinKnight

Using a Hyper-V VHD in an Azure VM

6/19/2014 by DevinKnight  -  Comments: 0  -  Views: [2521]

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 an existing Hyper-V virtual machine image to be hosted in Azure. Limitations Before you start this process here’s a couple things to be aware of: Virtual Machines in Azure must be .vhd files. They cannot be .vhdx ...

Read More

DevinKnight

Reducing the Disk Size of a Hyper-V Virtual Machine

6/19/2014 by DevinKnight  -  Comments: 0  -  Views: [2081]

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 virtual disk but if you need to shrink the disk size there’s a few extra steps to make the change. Here’s the simple steps for expanding a virtual disk: To expand a disk you can go into the Settings of your virtu...

Read More

DevinKnight

Setting up Automation in Azure

6/18/2014 by DevinKnight  -  Comments: 0  -  Views: [1907]

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 feature is still in beta but you can sign up your Windows Azure account to try the feature by going here: https://account.windowsazure.com/PreviewFeatures?fid=automation Once ...

Read More

DevinKnight

Power Pivot as the Core to your Power BI Solution

6/3/2014 by DevinKnight  -  Comments: 0  -  Views: [1396]

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 really impressive demonstrations of what you can do in Excel in a matter of a few minutes to start with no data to quickly making business decisions through some form of a reporting layer. While I reall...

Read More

DevinKnight

Power Query to HDFS – Remote Name Could Not Be Resolved

5/2/2014 by DevinKnight  -  Comments: 0  -  Views: [1970]

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 OK. I’ll be using the Hortonworks Sandbox environment for this demo. I then see all the files available on HDFS. If I try to explore the data in these files by clicking Binary next to any of the...

Read More

DevinKnight

Creating Power Map Reporting Solutions Recording and Q&A

4/18/2014 by DevinKnight  -  Comments: 0  -  Views: [1136]

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 time. Q: Am I correct in that you need the Pro Plus version of Office 365 and not the Home or University version? Yes, that’s correct most of the Power BI features in Excel (Power Pivot, Power View, etc..) req...

Read More

DevinKnight

Bringing Power BI Q&A to your Organization Recording and Q&A

4/17/2014 by DevinKnight  -  Comments: 0  -  Views: [1591]

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 to answer in the allotted time. Q: Does Power BI require SharePoint Online or can it work with public facing on premises SharePoint? Yes, Power BI sites and Power BI Q&A are only available if you’re using SharePoi...

Read More

DevinKnight

Upcoming Webinar – Creating Power Map Reporting Solutions

3/20/2014 by DevinKnight  -  Comments: 0  -  Views: [1496]

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 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 ways to present data is called Power Map. Power Map allows you to create engaging 3D map visualizations to help understand your geographical data better. This session will walk you through the beginning to end process of ...

Read More

DevinKnight

Upcoming Webinar – Bringing Power BI Q&A to your Organization

3/18/2014 by DevinKnight  -  Comments: 0  -  Views: [1990]

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 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 type traditional English sentences to return interesting results about your data. This session will walk through how to get a Power Pivot data model ready to use and also the end user experience of Q&A from the Power BI site. Re...

Read More

DevinKnight

Introduction to Power BI Recording and Q&A

3/18/2014 by DevinKnight  -  Comments: 0  -  Views: [926]

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 download the recording and slides . I usually like to post follow up questions and answer that I wasn’t able to address during the webinar. Here’s several that may help you! Q: Can you explain quickly how to use Power View on SharePoint 2010? To use these together you must have SharePoint 2010 SP1 Enterprise and SQL Server 2012 Enterprise or BI...

Read More

DevinKnight

Upcoming Webinar - Introduction to Power BI

2/28/2014 by DevinKnight  -  Comments: 3  -  Views: [958]

Come join me for this webinar on 3/13/2014 at 11:00 AM EST Introduction to Power BI 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 more self-service innovations. In this session you will gain an understanding of what Power BI is and get an overview of each of the components. This includes Power Pivot, Power View, Power Query and Power Map, Mobile P...

Read More

DevinKnight

Choosing the Right Analysis Services: MOLAP vs. Tabular Recording and Q&A

2/17/2014 by DevinKnight  -  Comments: 0  -  Views: [3163]

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 quick Q&A session for everything I was not able to answer in the allotted time. Q: Since Tabular solutions are many ways better than Multidimensional..then my question is when to go for Multidimensional solution You would l...

Read More

DevinKnight

Power BI for Office 365 Released

2/10/2014 by DevinKnight  -  Comments: 0  -  Views: [1566]

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: http://blogs.msdn.com/b/powerbi/archive/2014/02/10/announcing-the-general-availability-of-power-bi-for-office-365.aspx 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 the Power BI features you can browse here: Power Pivot PowerPivot – Creating KPIs PowerPivot ...

Read More

DevinKnight

Final Day for Power BI Voting, Can I Have Your?

1/30/2014 by DevinKnight  -  Comments: 0  -  Views: [723]

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

DevinKnight

Power BI Contest Entry Voting

1/20/2014 by DevinKnight  -  Comments: 0  -  Views: [1143]

You’ve watched my video (hopefully) now vote for it! In a previous post I wrote about my Power BI contest entry (Read more about it here ). I really enjoyed making this video and hopefully you enjoyed watching it. Please take a few moments and vote for my entry here. http://j.mp/1cFcLGj

Read More

DevinKnight

Power BI Contest Entry

1/8/2014 by DevinKnight  -  Comments: 1  -  Views: [1267]

Today I submitted my Power BI contest entry and I’d love for you to take a look! Here’s a short description of entry and the video itself: In this submission I have used Power BI to help me plan a vacation with my wife. We both love thrill rides so I wanted to make the best decision on planning our next trip. Using Power Query I imported data from the web to find all possible roller coasters and amusement parks. I then took that raw data and made relationships and calculations using ...

Read More

DevinKnight

Power BI Q&A Preview Now Live On Your Data

12/18/2013 by DevinKnight  -  Comments: 0  -  Views: [2117]

With the recent updates to the Power BI preview and Q&A features added I thought I would do a quick tutorial of how it all works. This post will walk you through uploading a workbook to Power BI, Using Q&A against that workbook, enhancing the workbook with synonyms and the creating features questions. First, sign up for a trial at www.PowerBI.com . Once your trial Power BI site has been issued to you login and add your own Power Pivot workbook by selecting Add as shown below. After you a...

Read More