Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

DataOnWheels

Steve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. He also provides insights from the field on his blog at http://dataonwheels.wordpress.com.

Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)

On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group.  This session is based on five blog posts that I created in August 2015.

You can find the presentation here: Powering Up HDInsight with Power BI (pdf).

The details can be found in the… Read more

0 comments, 134 reads

Posted in DataOnWheels on 4 February 2016

Five Years, A Quiet Quarter, A Look Ahead to 2016

Five Years of Blogging

From to

My blogging story started on December 7, 2010. I have now had a blog for over 5 years. I want to thank all of you who have read my blog and interacted with me through it. You have seen me change the theme… Read more

1 comments, 107 reads

Posted in DataOnWheels on 18 January 2016

Boston BI User Group Meeting–Dashboard Design with Microsoft: Power BI vs Datazen (10/13/15)

Thanks for joining Anthony Martin (@SQLMartini) and I at the Boston BI User Group Meeting in October. During the session, we demo’d and built dashboards in Power BI Desktop and Datazen Publisher.

Power BI

www.powerbi.com

Couple of thoughts from our demo:

  • Power BI is a way to get…

Read more

0 comments, 1,942 reads

Posted in DataOnWheels on 20 October 2015

SQL Saturday #437–Boston BI Edition 2015–You Can Still Analyze Data with T-SQL

Thanks for attending my session on analyzing data with TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post… Read more

2 comments, 164 reads

Posted in DataOnWheels on 17 October 2015

SQL Saturday #453–Minnesota 2015–A Window Into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post… Read more

0 comments, 146 reads

Posted in DataOnWheels on 10 October 2015

Excel Tip #29: Forcing Slicers to Filter Each Other when Using CUBE Functions

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

1 comments, 162 reads

Posted in DataOnWheels on 9 October 2015

TechFuse Minnesota Follow Up

 

My Session: Using Azure SQL Database for Enterprise Needs

On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some of the highlights from the session included a comparison of the various SQL Server offerings and how Azure SQL Database fits into the overall picture. During the session we… Read more

0 comments, 131 reads

Posted in DataOnWheels on 6 October 2015

Powering Up HDInsight with Power BI–

On Tuesday, September 15, I presented on this topic for Pragmatic Works. You can find that session here. This session is based on five blog posts that I created in August 2015.

Powering Up HDInsight with Power BI (pdf)https://dataonwheels.files.wordpress.com/2016/02/powering-up-hdinsight-with-power-bi.pdffoundin the

Setting Up and HDInsight Cluster (No Scripts… Read more

0 comments, 177 reads

Posted in DataOnWheels on 15 September 2015

Using Power BI with HDInsight Part 2: Power BI Desktop and Hive

With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster… Read more

0 comments, 433 reads

Posted in DataOnWheels on 28 August 2015

Using Power BI with HDInsight Part 1: Power Query and Files

With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster… Read more

0 comments, 204 reads

Posted in DataOnWheels on 27 August 2015

Uploading Files to an HDInsight Cluster (No Scripting Required)

As I noted in my first post, I am not a fan of scripting. In that post we set up a cluster without using scripts to do so. Now we are going to look at how to upload files without scripts. While this will work for our demo and… Read more

0 comments, 251 reads

Posted in DataOnWheels on 26 August 2015

Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)

As I noted in my previous post, I am not a fan of scripting. In that post we set up a cluster without using scripts to do so. Before we get to the steps to load our own data, I wanted to take a moment and explore the HDInsight… Read more

0 comments, 786 reads

Posted in DataOnWheels on 25 August 2015

Setting Up an HDInsight Cluster (No Scripts Required)

Let me start by saying, I am not a fan of scripting. It definitely has its place and a lot of my peers really like it. It is the easiest way to get functionality out from software vendors such as Microsoft. PowerShell is an incredibly powerful tool which can do… Read more

0 comments, 897 reads

Posted in DataOnWheels on 24 August 2015

Excel BI Tip #28: Using member expressions in the CUBEVALUE Function

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 1,339 reads

Posted in DataOnWheels on 21 July 2015

Excel BI Tip #27: CUBESET and CUBESETCOUNT Functions

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

2 comments, 463 reads

Posted in DataOnWheels on 16 June 2015

How I Got Started in Software Development-A Tribute to Ed

Steve:

Happy Memorial Weekend everyone. This is a time to remember those who have gone before and in some cases have left us. I started a tribute series that celebrates those who have had an impact on me as a person and on my career. It started with my…

Read more

0 comments, 206 reads

Posted in DataOnWheels on 22 May 2015

Join me Tues, May 12 – Consumption Based Architecture for BI

Join me on Tuesday, May 12 as I discuss consumption based architecture for BI Solutions with Pragmatic Works.


Read more

0 comments, 233 reads

Posted in DataOnWheels on 6 May 2015

Building Your Data Team’s Make Up and Culture

Join Adam Jorgensen and Pragmatic works to learn about Building Your Data Team’s Make Up and Culture on Tuesday, May 5.


Read more

0 comments, 251 reads

Posted in DataOnWheels on 1 May 2015

Excel BI Tip #26: Using a Data Spreadsheet or Tab

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 409 reads

Posted in DataOnWheels on 30 April 2015

Optimizing the Modern Data Platform with SQL Server 2014

Join Jason Strate and Pragmatic Works in Minneapolis on May 7. Learn about Optimizing the Modern Data Platform with SQ Server 2014. Register here.


Read more

0 comments, 328 reads

Posted in DataOnWheels on 22 April 2015

Older posts