Ten Years and Counting …

14 03 2014

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 time, I went from an application development consultant in Visual Basic to a Business Intelligence Architect specializing in SQL Server Analysis Services and MDX.

Magenic Logo At that point in my career, I was beginning to travel more and take on a much larger leadership role as Magenic was growing beyond that first office in Minneapolis, MN. I went to work for one our customers, XATA Corporation, as their Data Architect. For the next 4 1/2 years I learned a lot about transportation management and how important data was in that area. (My Twitter handle and domain name, DataOnWheels, was established during this time.) I also learned what it meant to live with your code and architecture after the consultant left. While at XATA, I continued to be involved in the SQL Server community which was very helpful for the next step.

There came a time in my stint at XATA, that it was clear that it was time for me to move on. I started the process of looking at what was available in the market. When I went to Magenic’s career site, I found that my job or its nearest equivalent was available. I called Carole Cuthbertson, “V-mom”, and asked about coming back. We had lunch a week later and the transition back to Magenic was set in motion. (So, if you leave a company you like for good reasons, never burn bridges! You might want to go back.)

When I told my wife that I was going back, she was glad I was. This kind of surprised me as I had been doing a lot of traveling before I left. She noted that I was happier working at Magenic which was better for our family. That was the final push I needed and I returned to Magenic. As I come up on this anniversary, I am really at great point in my career. I truly enjoy being a Practice Lead at Magenic and still consider it a a great place to work.

I recently was talking with a customer who pointed out that communicating ideas with 3 points is very effective. Ironically, I probably should have known that from all of the ministry training I went through. So, I thought I would conclude this post with the three reasons why I enjoy working for Magenic.

1. Family

As I noted above, my wife was happy when I went back to Magenic. What I realized is that no matter how hard it got, Magenic would do what they could to help your family while you worked for them. I realize that everyone’s experience is different, but I saw them work with consultants who were going through tough times with their family.

My Kids During my first couple of years there, I lost both of my maternal grandparents over two successive Christmases. I was close to my grandparents so when the news came, I still remember Tim Wold, my project manager and Magenic’s employee #1, telling me to go take care of my family and he would work out the details on his end. That was characteristic of management and leaders throughout my time here. Family matters to the owners, Greg Frankenfield and Paul Fridman, and that is carried through to the company.

My family has always been treated very well and they enjoy participating at the various events that the company has had from the Christmas party to the summer picnics.

2. Opportunity

When I joined Magenic, I had no idea what it meant to be a consultant. With mentoring and coaching, I was able to grow from a consultant to a practice lead. I am a technical leader in the company and have been able to expand my career throughout the years with their help. One of the biggest career changes was moving from application development to business intelligence. This has significantly shaped my career today in ways I would have never thought 15 years ago. During my time there, I was also encouraged to give back both internally and externally. This has opened up some great opportunities through the years.

3. Appreciation

Appreciation can take on a couple of different forms. Of course, being paid to do what you love is awesome! Even better when it pays well. However, there is more to appreciation than the paycheck. Magenic has an interesting culture which I had to learn through the years. Because we are hired to go and work at customer sites, it was not always known what or how we were doing. Magenic is a place where you can and should speak up about what your doing. While seeming counterintuitive and self serving at times, letting managers and other leaders know what I was doing, paid dividends for my career. Just as importantly, they were able to understand more about what was going on.

To me and my experience with Magenic, these are 3 key reasons that I returned and stay today. I am now in a place in my career where I need to give recognition to those whom it is due more than receive it. I have the opportunity to impact others in their careers and to help Magenic continue to grow.

I encourage all of you who read this to look at where you work. What is the culture like?Source: http://www.michaelhammack.com/2012/10/05/the-grass-is-always-greener-on-the-other-side/ Do you like what you do? Can you see yourself there in 5, 10, 15 years? Keep your core values in mind as you seek to change companies or careers. If you have had a job move conversation with me, I have likely told you something like “The grass is always greener on the other side, but a lot times it’s because of the manure.”





2013 – A Year In Review

2 01 2014

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 professionally. In the past year, my youngest, Mikayla, has entered Junior High officially taking our family out of elementary schools. Mikalya joined me at the SQL Saturday event in Omaha. At the same time, my oldest, Kristyna, is now a senior at Burnsville Senior High School. Both of my boys, Alex a junior and Andrew a freshman, are both taller than me and staying active. Alex joined us at the Minnesota SQL Saturday and did a lot of volunteering. Andrew probably had the best event of all as he joined me at SQL Saturday in Fargo. There he got to see Bill Gates in person. I am proud of all of them, they are great kids. This was also the year I celebrated 20 years with the woman I love, Sheila. Without her support, I would not have been able to get this far in my career as well. Yep, it has been a busy year personally. Soon there will be lots of college, marriage, and maybe even grandkids. Wow, I must be getting old.

Magenic and the Server Development Practice

2013 is my first full year as a Practice Lead at Magenic. I started out as the Practice Lead for our Business Intelligence and Data Practice. In August, my role expanded to include SharePoint, Biztalk, and TFS. This allows us to focus server technologies at Magenic. Along  the way, I have had to learn a lot about VMs (still a work in progress). I really enjoy working with the pros across the company that we have. We some very talented BI, SharePoint and BizTalk consultants including a few virtual TSPs in SQL Server, Business Intelligence, and BizTalk.

During this past year, I have traveled around the country to consult, to speak, and to meet customers. I have had the privilege of speaking at multiple SQL Saturdays, Modern Apps Live, SQL Live, and Code Mastery events. It has been fun. I almost made it to all of our offices including the locations we opened this year. I made it to Minneapolis, Chicago, Atlanta, Charlotte, Boston, New York City, and San Francisco. Still need to get out to Los Angelos and Manila.

image

While it has been hard at times, the travel experience has been good overall. I try to keep my speaking engagements up to date, maybe I will see some of you next year.

This year I also authored outside of the blog. Chuck Whittemore (The Insight Analyst)The Changing World of Business Intelligence: Leading with Microsoft Excel - Custom Software Development White Paper and I coauthored a white paper on Leading with Excel: The Changing World of Business Intelligence. This was a fun project where we bring together Microsoft Excel and Microsoft BI in a real world way. We continue to successfully work this strategy with our customers and it was the impetus for my Excel BI Tips blog post series. I SQL Server Analysis Services 2012 Cube Development Cookbookalso had the privilege to coauthor a book that is just being released: SQL Server Analysis Services 2012 Cube Development Cookbook by Packt Publishing. This the third book I have worked on and it has been a while since was last published so this was a good experience for me. I still don’t know if I would take an entire project on, but maybe someday.

This year wraps up with me becoming a virtual TSP with Microsoft to further support their efforts with SQL Server and Business Intelligence in the marketplace.

One other thing that has been interesting for me is that with the release of Power Pivot and SQL Server Analysis Services Tabular Model, I am seeing a huge shift in how I work with and sell BI. I have always worked with cubes, but now I see the in-memory space as a more compelling and leading edge solution that will continue to change what my career will look like. While I had a lot of fun being a cube and MDX wizard, the ability to deliver results to business users in a timely fashion with great visualizations is actually more fun. The more things change …

Happy New Year!

I hope you and your family had much to look back and celebrate this year. I thank God for the blessings of a great company to work for and an awesome family to be with.





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

19 06 2013

MagenicLogo2012x70tallIn 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 a business analyst came together to show our worlds colliding in the age of modern BI tools.  While the goal has always been to bring the data to the users and let them work with it as creatively as possible, the tools to do this were IT focused.  What we see now is that with the advent of in-memory, client-side BI tools, users are now able to get to this on their own.  Microsoft has invested heavily in Excel to make it a first-class BI tool.  Our paper discusses this disruptive nature of the new tools and how Excel is being pushed to the next level.  After all, Excel is everywhere already.

Enjoy the read and I welcome your feedback.

The Changing World of Business Intelligence: Leading with Microsoft Excel





Exploring Excel 2013 as Microsoft’s Business Intelligence Client

4 02 2013

Excel 2013 LogoA little over six months ago, I wrote an article on Magenic.com about Excel 2013’s Impact for BI Users.  This coincided with the Office 2013 Preview release.  I discussed the addition of Power View and PowerPivot into the product.   Last week, I followed that article up with another on the fact that Excel appears to be Microsoft’s BI client platform now and into the future.

It appears that I am not alone in this assessment.  Michael Koploy of Software Advice, a company that reviews BI software, did a Q&A session with Rob Collie, a.k.a. PowerPivotPro ( T | B ), where Rob came to some similar conclusions.  He notes that “the powerpivotprotoday[1]inclusion of PowerPivot in 2013 is a major inflection point” for users to implement BI in Excel more fully.  I really like his take on the relationship between BI specialists and IT pros and the end users of Excel.  Microsoft has been pushing a concept of BI for the masses and ironically today’s Excel is the helping this happen.  Check out the rest of the Q&A about whether Excel is the next great BI tool for more insights from Rob.

As I start to deliver more solutions with customers using Excel, SharePoint and soon Office365, I am going to kick off a new series here on my blog – Excel 2013 BI Tips.  My goal is to document XLTipsthose tips, tricks and discoveries from my journey with the new Excel.  Some of them may be seem common, but I just don’t want to forget so I will be noting them as well.  Join me for this interesting journey through Excel and BI.





SQL Saturday #149 and CodeMastery–Minnesota Events

18 09 2012

sqlsat149_webWe are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference sessions on September 28.  In case you haven’t heard, we are having the main event on a Saturday.  Yes, the precons are on Friday this year.  Check out the details here.  I am really excited about this event as we have a great group of local, regional, and national speakers at this event.  There are nine rooms being used for this event, so go out to the site and build your schedule.

cm-logoThe following Tuesday, Magenic is hosting CodeMastery with a BI track at the Microsoft Technology Center in Edina, MN.  This event includes a sessions on managing the BI stack in SharePoint and xVelocity.  The other track is Windows 8 development with sessions on WinRT and Game Development.

I’m a Speaker at Both Events

Besides plugging these two awesome events on their own, I am also a speaker for both events.  Here is what I will be speaking on at each event:

SQL Saturday #149: A Window into Your Data: Using SQL Window Functions

In this session, I will walk through the window functions enabled by the OVER clause in SQL Server.  Come join me as we celebrate the SQL Server 2012 release of analytic functions and expansion of aggregate functionality to support tasks such as running totals and previous row values.  Thankfully, this is a demo heavy session as it is one of the last sessions of the day.

CodeMastery: Data Mining with the Tools You Already Have

The next week, I will be presenting on data mining tools which Microsoft has made available to us in SSAS and Excel.  The goal of this session is to help developers understand how to implement data mining algorithms into their business intelligence solutions.

I look forward to seeing you at both events.  They are priced right, FREE!





#meme15: Reasons I Like My Job

15 08 2012

meme15new

When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on.  Before I get into my reasons, some history is in order.  I will have been employed at Magenic ( T ) for over 8 years.  My employment has not been contiguous, as I left for about 4 1/2 years.  In my first stint at Magenic, I came into consulting with no idea what I was getting into.  When I left, 5 1/2 years later, I was doing a lot of travel while leaving my wife with 4 kids under 10 at home.  My reason for leaving Magenic was to be closer to home with less travel.  Now, on to the topic because the reasons I like my job and the reasons I returned are very similar.

Reason #1:  My wife likes where I work

When I mentioned to my wife that I was ready to go back into consulting, she noted that going back to Magenic would be good for me and for the family.  As it turns out, Magenic provided me with a supportive and fulfilling environment which meant a better home life.  Furthermore, she likes how they treat our family as if they matter as well.

Reason #2:  This too shall pass …

I work in consulting.  I really like the freshness of each contract and the knowledge that no matter how bad it looks, it will pass as well.  Keeps the work new and exciting without the burden of working on the same thing for years.  (FYI – did that for 4 1/2 years.  I like consulting better.)

Reason #3:  I get paid.

I don’t do the job for free and I still get a paycheck.  Given the economy of the day, this is a valid reason for liking my job.

Reason #4:  Blah, blah, blah

One of the reasons I came back to Magenic is the fact that they enabled me to find more speaking engagements.  While blogging for me at times can be a chore, speaking at user groups, SQL Saturdays, conferences and other events is fun.  It is one of the things I really love about my job.  This year I will likely get over ten speaking engagements in with over 12 sessions delivered on various SQL Server and BI topics.  Yes, this is fun.

Reason #5:  Coworkers and peers

My final reason is my coworkers and peers.  I get to work with a lot of smart, fun, and driven people.  It is refreshing to go to work and see how each and everyone is finding ways to push the envelope.  Not only that, many I am able to count as friends who I would keep in contact with whether or not we worked at the same place.

I am really pleased with where I work and enjoy what I am doing and who I work with.  I can only hope that I can help improve it for those around me.  What I found interesting about this meme is that it did not prompt a “career” response.  My job enables me to pursue my career, which is awesome.  I could do this elsewhere, but why?





Upcoming BI and Data Events with Magenic in Fall 2012

14 08 2012

As I started looking over my event calendar, I was amazed at how many events Magenic is sponsoring, hosting or providing speakers for over the next couple of months.  As always, one of my goals is to make everyone aware of opportunities to increase their knowledge in BI and data or even network with other data pros.  Not all of the events are Magenic events, but Magenic has stepped up to sponsor or provide speakers for the event.  I will update this blog with more details as they become available, but I want to get you thinking about the possibilities to learn and connect.bi-summit-logo

BI Summit (Chicago, August 23, 2012)

This event is coming up very soon.  Register today to hear about BI topics that matter to you as a customer and in particular as a business user.  Ted Krueger ( B | T ) and Aaron Lowe ( B | T ) will be showing off some of the new Microsoft BI capabilities.  I will be joining them for the round table at the end of the day.  Sign up today as space is limited!

Code Mastery (Chicago, September 12, 2012)

cm-logoNot to be outdone, a few weeks later Magenic’s Code Mastery event comes to Chicago.  There is an opening session by Ted Krueger discussing query tuning for developers and admins alike.  Then, a full track will be offered on a variety of BI topics.  The speakers include your truly, James Phillips ( T ), and Aaron Lowe.

SQL Saturday #156 (Providence, September 15, 2012)

Join James Phillips at this event as well.  If you see him at Code Mastery in Chicago then at SQL Saturday in Providence let him know.  I am sure we all would be interested in how and why you SQL Saturdaytraveled the country to hear him.  He will be speaking on SSIS 2012 and loading data warehouses.

SQL Saturday #149 (Minneapolis, September 28-29, 2012)

We are loaded to bear for this event.  Steve Hughes and Ted Krueger will be conducting preconference sessions.  Beyond that, a number of Magenicons have submitted sessions.  We expect the final list before the end of the week and I will update this post when they list is finalized.  Magenic is also a Gold Sponsor for this event.  Oh, and this year the precons are on Friday with the full event on Saturday.  Thought we would try something new this year.

8/15/2012 UPDATE:  Magenic speakers announced:  Ted Krueger, Aaron Lowe, Jeff Prom and I have sessions at this event.

Code Mastery (Minneapolis, October 2, 2012)

This event is still being finalized, but hold the date!  We have a BI track that includes implementing BI with SharePoint.  Our speakers include Jeff Prom ( B ), Josh Owens ( T ), Curtis Smith and Greg Moser ( T ).  Look for more details coming soon.

Minnesota SQL Server User Group (Minneapolis, October 14, 2012)

Magenic is the sponsor for October’s user group meeting and Jeff Prom will be speaking on Data Quality Services.  PASS_2012_120x240

PASS Summit (Seattle, November 6-9, 2012)

And the Summit wraps up a busy fall season.  I have two sessions at this conference.  Ted will be a part of Ask the Experts and Birds of a Feather.  A number of other Magenicon’s will also be in attendance.  We will look forward to wrapping up a this fall’s data and BI community events at the Summit.

Join Magenic’s data pro’s at any of these conferences or meetings.  Magenic is a huge promoter of business intelligence and data related education within the SQL Server community.  We look forward to seeing you at any of these events.








Follow

Get every new post delivered to your Inbox.

Join 730 other followers

%d bloggers like this: