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.

Oracle Tips for MSBI Devs #6: Supporting SSAS Tabular Development

As SQL Server Analysis Services Tabular Models become more popular, models will use Oracle databases as sources. One of the key issues whenever you work with Oracle is understanding how to properly configure the necessary components to enable development.

Getting Started

If you have worked with Oracle before, you are… Read more

0 comments, 55 reads

Posted in DataOnWheels on 14 April 2014

Ten Years and Counting …

On March 8, 2014, I reached ten years of service at Magenic Technologies. When I started in 1999 (don’t do the math just yet), Magenic had only been around a few years and it was my first consulting job. I stayed at Magenic for about 5 1/2 years. During that… Read more

2 comments, 93 reads

Posted in DataOnWheels on 14 March 2014

Setting Up Tabular Models on Windows Azure

In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were questions about using SQL Server Analysis Services (SSAS) tabular models with Azure. This post will walk through setting up an Azure VM and deploy a tabular model to that… Read more

0 comments, 299 reads

Posted in DataOnWheels on 12 March 2014

Oracle Tips for MSBI Devs #5: Working with Oracle on Windows Azure

As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work with Oracle through the years while delivering BI solutions. One of the pain points of working with Oracle in development is setting up an Oracle development server. Even though… Read more

0 comments, 18 reads

Posted in DataOnWheels on 24 February 2014

Rochester – Welcome to the PASS MN Family

It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At the time, Paul Timmerman ( T | B ) and I were discussing the fact that only one user group existed in Minnesota. As we looked at other areas and… Read more

0 comments, 91 reads

Posted in DataOnWheels on 23 January 2014

Work Ethic and Family – A Tribute to My Parents

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 a few years ago. Check out my original post about him… Read more

1 comments, 87 reads

Posted in DataOnWheels on 9 January 2014

Exploring Excel 2013 for BI Tip #14: Sparklines and 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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

2 comments, 131 reads

Posted in DataOnWheels on 7 January 2014

2013 – A Year In Review

It is in our nature as humans to look back in order to understand where we have been.

Warning – some of this blog contains stuff about my family… In case you only want the technical stuff.

Family Fun

This past year has been very interesting for me personally and… Read more

1 comments, 170 reads

Posted in DataOnWheels on 3 January 2014

Exploring Excel 2013 for BI Tip #13: Connecting Slicers in Pivot Tables Sourced from a Power Pivot Model

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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

1 comments, 137 reads

Posted in DataOnWheels on 17 December 2013

Exploring Excel 2013 for BI Tip #12: Icon Sets

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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

1 comments, 1,310 reads

Posted in DataOnWheels on 3 December 2013

Traveling, Talking, and a PASS Attack Have Happened

Well, this fall has been crazy. As you may have noted from a couple of my previous posts, link to speaking and pass attack, I have been busy this fall. With multiple speaking engagements and additional travel for work, I have been on the road more than I have been… Read more

0 comments, 90 reads

Posted in DataOnWheels on 1 December 2013

Temporary Post Used For Theme Detection (ce478925-8370-4f2b-8509-8988dd7a717e – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (e6e588b0-6d28-4504-914d-36fc0145f1b9 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)


Read more

0 comments, 102 reads

Posted in DataOnWheels on 1 December 2013

PASS Attack!

It’s Friday. Tomorrow I present two sessions at SQL Saturday #238 – Minnesota. Then I take off for PASS Summit 2013 on Sunday. I then wrap up the week at SQL Saturday #237 – Charlotte BI Edition.

I hope to see a variety of you at these different events.

If… Read more

1 comments, 157 reads

Posted in DataOnWheels on 11 October 2013

Adding Top 10 Charts to Power View Which Honor Filters

Before I get too far in the weeds, I have to recognize Rob Collie, his blog (http://www.powerpivotpro.com) and his book DAX Formulas for PowerPivot: The Excel Pro’s Guide to Mastering DAX. His book has been a great resource as I work through fun with DAX. I… Read more

0 comments, 255 reads

Posted in DataOnWheels on 19 September 2013

Exploring Excel 2013 for BI Tip #11: Color Scales

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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 1,062 reads

Posted in DataOnWheels on 28 August 2013

Traveling and Talking to Wrap Up 2013

I am writing this blog post en route to New York City for SQL Saturday #235. This begins a fairly busy travel and speaking schedule for me this year. Having spent much of the summer at home with my family which was great, I now embark on some trips, primarily… Read more

2 comments, 196 reads

Posted in DataOnWheels on 16 August 2013

Exploring Excel 2013 for BI Tip #10: The Data Bar

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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 344 reads

Posted in DataOnWheels on 30 July 2013

Exploring Excel 2013 for BI Tip #9: Adding Calculated Members

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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 628 reads

Posted in DataOnWheels on 25 June 2013

Exploring Excel 2013 for BI Tip #8: Adding Calculated Measures

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.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not forget what… Read more

0 comments, 228 reads

Posted in DataOnWheels on 20 June 2013

The Changing World of BI, A New White Paper for Magenic

In the ever changing landscape that is Business Intelligence (or is that Business Analytics?), a fellow business analyst from Magenic, Chuck Whittemore (B), and I authored a white paper based on our experiences over the past months.

What I think makes our work unique, a BI architect and… Read more

0 comments, 307 reads

Posted in DataOnWheels on 19 June 2013

Older posts