BI Developer Network Community blogs

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

Communifire Blogs

Blogs RSS Feed

Blogs: Most Recent postings

Daniel

SQL Saturday 302 Albany NY July 26th. Crossroads of the Northeast, just 3 hours from everywhere.

7 days ago by Daniel  -  Comments: 0  -  Views: [559]

I am speaking on SSIS Optimization. Just a few more days to register and make your plans. I hope to see you there. More info here: http://www.sqlsaturday.com/302/eventhome.aspx

Read More

DustinRyan

Script To Populate AdventureWorksDW DimDate

13 days ago by DustinRyan  -  Comments: 6  -  Views: [380]

I do quite a bit of training for Pragmatic Works so I find myself working a lot with the AdventureWorksDW data warehouse database. AdventureWorksDW is a great test database if you're wanting to demonstrate a concept or test a theory, but one of the things that has always bugged me is that the date dimension (dbo.DimDate) has holes in the data! Having a complete date dimension is important when working with SSAS. Well yesterday was the final straw, so I put together the following script that will...

Read More

DevinKnight

Understanding Analysis Services Relationships using Dimension Usage

15 days ago by DevinKnight  -  Comments: 0  -  Views: [394]

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

DustinRyan

How To Display 0’s Instead of NULL in your SSAS Cube & MDX Query Results

15 days ago by DustinRyan  -  Comments: 0  -  Views: [617]

I've done a decent amount of SSAS and MDX query development over my career and one of the requirements that continually pops up is to display zeros instead of NULL when browsing the cube. Take the following query as an example: Select {[ Date ].[Calendar Year ].Children} on 0, NON EMPTY {[Geography].[ State -Province].members} on 1 From [Adventure Works DW] Where [Measures].[Reseller Sales Amount] And here are the results: There are a couple ways display 0's instead of NULL. The first way is to ...

Read More

DevinKnight

Using PowerShell to Build your Azure VM Environment

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

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: [852]

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: [801]

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: [1019]

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: [672]

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

DustinRyan

SQL Saturday #298 Session Material Now Available (SSAS Tabular Models)

5/12/2014 by DustinRyan  -  Comments: 0  -  Views: [2120]

Another fantastic SQL Saturday event is in the books and it did not disappoint! There was a great crowd at University of North Florida in Jacksonville, FL and plenty of amazing sessions and speakers. Thank you to everyone that attended my session! I hope you enjoyed the session as much as I enjoyed presenting. It was a blast! If you're interested, the slide deck I used during the presentation is now available for your viewing pleasure, which you can see here . If you have any questions or would ...

Read More

Anil

Using Power Query to tell your story form your Facebook Data.

5/6/2014 by Anil  -  Comments: 0  -  Views: [971]

Using Power Query to tell your story form your Facebook Data. Most of the time of this weekend, I spent my time to extract the story behind my Facebook data by using Power Query. Power Query can connect data across a wide variety of sources, where facebook is one of the data source. By using Power Query you can extract your facebook data easily and do analysis your own story by using your own facebook data. Talking about Power Query: Microsoft Power Query for Excel is an Excel add-in that enhanc...

Read More

Tyler

Documenting SharePoint Integrated Report Servers using DOC xPress

5/5/2014 by Tyler  -  Comments: 0  -  Views: [840]

Before we get into the steps taken to setup DOC xPress to work alongside a SharePoint Integrated Report Server, let's give a brief overview on what DOC xPress actually is. DOC xPress is a powerful document generation tool that allows users to create entire "snapshots" of their BI environment: SQL Server Instances and Databases, SSIS Packages, SSAS Databases, SSRS Reports, Oracle Databases, Hive Servers, and Informatica PowerCenter Repositories. For DOC xPress, a snapshot is simply a "picture" of...

Read More

DevinKnight

Power Query to HDFS – Remote Name Could Not Be Resolved

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

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

ShawnHarrison

Intro to SSIS Webinar Follow-up

4/30/2014 by ShawnHarrison  -  Comments: 0  -  Views: [451]

Thanks to all who attended yesterday?s webinar. Since I ran short on time and wasn?t able to answer any questions, here are all the questions and their answers. Q: Does the lookup transform require the data (join key) to be sorted? A: No sorting required. The Merge Join requires a sort, but not the Lookup transform. Q: Could you have used "False"? A: This was a question in regards to an SSIS expression that was used to check a boolean value in a column. In the expression I used ?0? to represent ...

Read More

DustinRyan

Learn to Design Tabular Models at SQL Saturday #298 Jacksonville, FL on 5/10/2014

4/29/2014 by DustinRyan  -  Comments: 0  -  Views: [1335]

I'm excited to announce that on Saturday May 10th in a couple Saturdays I'll be speaking at SQL Saturday 298 in Jacksonville, FL! SQL Saturday in Jacksonville always has an awesome turnout and I love speaking at this event! There will be tons of great free training sessions from the likes of Devin Knight, Robert Cain, Andy Warren, Adam Jorgensen, Max Trinidad, and tons of other great experts! If you're in the North Florida area on May 10, you need to get registered for this event ! The session I...

Read More

DevinKnight

Creating Power Map Reporting Solutions Recording and Q&A

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

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: [1069]

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

Anil

How to transpose rows to columns in oracle.

4/16/2014 by Anil  -  Comments: 0  -  Views: [582]

In some case we need to transpose the table data that means we need to change the rows value into columns, and then this blog post will be surely helpful. Let’s say we have to find out the trend of expenses of the customer or say some account no or mobile no for some few months to find out his or her behavior such as we have a data in table ‘ Pivot_Table’ as MobileNO TotalExpenses Date 1 3000 20140101 2 5000 20140101 3 7000 20140101 1 5000 20140201 3 9000 20140201 2 3000 201402...

Read More

KathiKellenberger

SSIS 2012 Deployment Webinar followup

4/6/2014 by KathiKellenberger  -  Comments: 0  -  Views: [498]

You can find my followup for the webinar here .

Read More

KathiKellenberger

Where did I go?

4/3/2014 by KathiKellenberger  -  Comments: 0  -  Views: [476]

You may be wondering why I haven't posted here for a few weeks. I decided to move over to my own Wordpress blog: http://auntkathisql.com . I will be slowly moving my favorite posts from this blog over to the new one. Please check out my new blogging home!

Read More

DevinKnight

Upcoming Webinar – Creating Power Map Reporting Solutions

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

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: [1485]

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: [676]

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

KathiKellenberger

T-SQL Window Function Performance webinar follow up

3/14/2014 by KathiKellenberger  -  Comments: 2  -  Views: [912]

I gave a presentation this week on T-SQL Window Function Performance. You can view the presentation here . You can also download the code and the slides . I had just a couple of questions during this presentation. If you watch the recording and have a question, be sure to post the question as a comment, and I'll be sure to answer it here. Q. Please explain how to determine which columns should be used in the POC index. A. The "P" stands for Partition. If you are using a Partition By clause, then...

Read More

KathiKellenberger

My speaking schedule

3/13/2014 by KathiKellenberger  -  Comments: 2  -  Views: [599]

I love speaking about SQL Server, and I have submitted to several SQL Saturdays and events. If you would like for me to speak at your user group, especially remotely, please leave me a comment here. Here is the my speaking schedule for this year so far. I hope to see you at one of these events! Event Location Date Presentation The Greater Midwest SQL Relay St. Louis February 22, 2014 T-SQL Window Functions T-SQL WIndow Function Performance SQL Saturday #279 Phoenix March 29, 2014 T-SQL Window Fu...

Read More