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.

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, 904 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, 167 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, 131 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, 162 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, 183 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, 248 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, 183 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, 5,233 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, 172 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, 258 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, 6,129 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, 243 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, 230 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, 187 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,143 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,733 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,764 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,235 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, 344 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,664 reads

Posted in DataOnWheels on 20 January 2015

Older posts