Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

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, 102 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, 116 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, 138 reads

Posted in DataOnWheels on 22 April 2015

Excel Tip #25: Overlaying Charts

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, 2,837 reads

Posted in DataOnWheels on 21 April 2015

Techfuse MN 2015

Join me at Techfuse Minnesota 2015. I will be presenting on Excel Dashboards.


Read more

0 comments, 134 reads

Posted in DataOnWheels on 20 April 2015

Excel Tip #24: Removing “Buttons” from Excel Charts

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, 167 reads

Posted in DataOnWheels on 7 April 2015

Excel Tip #23: Adding a Trendline to Your Chart

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, 5,884 reads

Posted in DataOnWheels on 31 March 2015

Excel Tip #22: Combo Charts – Out of the Box Functionality

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, 186 reads

Posted in DataOnWheels on 24 March 2015

Excel Tip #21: Hiding Scrollbars in Excel Services Web Part

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, 154 reads

Posted in DataOnWheels on 17 March 2015

Check Out Josh’s Blog on Creating Percentile in DAX

I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering topics on business intelligence and data. I have worked with Josh for years at a Magenic and now Pragmatic Works. I look forward to seeing what he will be writing… Read more

0 comments, 142 reads

Posted in DataOnWheels on 24 February 2015

Excel BI Tip #20: Wingdings–an Excel Services Supported Indicator Alternative

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

4 comments, 6,025 reads

Posted in DataOnWheels on 10 February 2015

Excel BI Tip #19: Using the TEXT 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, 6,593 reads

Posted in DataOnWheels on 3 February 2015

Part 3 Adding Tab Controls – Create your own SQL tools with PowerShell and windows forms

Steve:

James recently published part 3 of his PowerShell and Windows Forms series for creating your own SQL Tools. In this post, he guides you through the process of adding tab controls. Enjoy!

Originally posted on JamesDataTechQ:

Using Tab Controls can help you organize and define your work…

Read more

0 comments, 6,632 reads

Posted in DataOnWheels on 30 January 2015

Excel BI Tip #18: Using CUBE Functions to Break Out of Pivot Tables

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, 6,047 reads

Posted in DataOnWheels on 27 January 2015

Excel Apps – Not Quite Ready for Primetime

While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I am always looking for ways to build Excel dashboards or do BI work with Excel that will help everyone. In this case, I am going to discuss a new feature… Read more

0 comments, 308 reads

Posted in DataOnWheels on 22 January 2015

Excel BI Tip #17: Using the Timeline Filter

 

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… Read more

0 comments, 5,477 reads

Posted in DataOnWheels on 20 January 2015

Part2 Adding a New CheckBox – Create your own SQL tools with PowerShell and Windows forms

Steve:

This is James’ second post on creating SQL tools with PowerShell and Windows forms. James is a DBA responsible for the management of a large number of SQL Server instances.

Originally posted on JamesDataTechQ:

This blog post is about adding a new CheckBox to the SQL Tool…

Read more

0 comments, 5,833 reads

Posted in DataOnWheels on 14 January 2015

Intro to Data Factory–Training on the T’s Follow Up Post

This is a follow up blog post based on the Intro to Data Factory session I gave on the Training on the T’s with Pragmatic Works. Find more free training from the past and upcoming here. I did my session on January 13, 2015.

 Intro To Data Factory

In… Read more

0 comments, 145 reads

Posted in DataOnWheels on 13 January 2015

She Taught Me to Code–A Tribute to Sheila, My Wife

A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals who have impacted my career. I do this as a tribute to my father-in-law, Ed Jankowski who passed away five years ago this past December (2014). Check out my original… Read more

1 comments, 133 reads

Posted in DataOnWheels on 12 January 2015

2014 Year In Review

As is our want, we must look back over the past year to see what happened. While I normally focus on work related items, this year was a crazy year for our family as well as my career. So let’s have a look at what happened this year.

Traveling Family

Read more

0 comments, 119 reads

Posted in DataOnWheels on 11 January 2015

Older posts