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 once and do a number of series. Here are some highlights from the past five years:

Top 5 Posts All Time

1. Adding Top 10 Charts to Power View Which Honor Filters
2. Simple batch script to generate XMLA and deploy SSAS DB
3. T-SQL Window Functions – Part 1- The OVER() Clause
4. Exploring Excel 2013 for BI Tip #14- Sparklines and Pivot Tables
5. O, There’s the Data- Using OData in SSIS

Top Series All Time

The Excel BI Tips series has changed it name a couple of times. However, this tip series still rings true even today even as Microsoft invests in other tools. Look for some more Power BI content this year, but this series will continue to have updates. Also, look to see some Excel 2016 topics added to the list as that release becomes available. Here are the top ten tips from the series:

1. Exploring Excel 2013 for BI Tip #14- Sparklines and Pivot Tables
2. Exploring Excel 2013 for BI Tip #15- Locking Slicer Position
3. Exploring Excel 2013 for BI Tip #10- The Data Bar
4. Exploring Excel 2013 for BI Tip #4- Adding a Slicer
5. Exploring Excel 2013 for BI Tip #5- Cleaning Up Slicers
6. Exploring Excel 2013 for BI Tip #9- Adding Calculated Members
7. Exploring Excel 2013 for BI Tip #8- Adding Calculated Measures
8. Exploring Excel 2013 for BI Tip #13- Connecting Slicers in Pivot Tables Sourced from a Power Pivot Model
9. Excel BI Tip #18- Using CUBE Functions to Break Out of Pivot Tables
10. Excel Tip #21- Hiding Scrollbars in Excel Services Web Part

Tributes

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 in December 2009. Check out my original post about him and his impact on me being in software development today.

• 2011: How I Got Started in Software Development-A Tribute to Ed
• 2012: Cultural Anthropology and Business Intelligence–A Tribute to Dr. Thomas C. Correll
• 2013: Work Ethic and Family – A Tribute to My Parents
• 2014: She Taught Me to Code–A Tribute to Sheila, My Wife

Some Stats

I want to thank everyone again for taking time to check out my blog. Here are some stats that I thought were cool and decided to brag about here:

• 2011 daily average: 9 – 2015 daily average: 162
• 156 posts
• 135,000 views
• Best ever views in a day: 584

Thanks again for checking out my “help” library. As I noted in one of my posts, I blog to not forget and to pass along what I have learned. The key for me is that I do it when I can about topics that interest me.

A Quiet Quarter

The last statement holds true here. I have had a very quiet end of the year. I had blogs which followed up sessions, a practice that I intend to continue, and one BI Tip. November and December were quiet as my job and family took precedence as Pragmatic Works closed out the year strong and we had holiday activities at home including getting my two kids in college home. Well, the dust has settled so I am getting a few more posts published now. Look for the Minnesota SQL Server User Group and Minnesota BI User Group follow up posts this week.

Looking ahead to 2016

After a busy year last year, I am looking forward to having some new opportunities to write about Azure, SQL Server 2016, and other technologies I have not even seen yet. Are you excited for what is coming? Let’s have a great year working with data and analytics.

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 post about him and his impact on me being in software development today.

She Taught Me to Code

My wife, Sheila, actually did get me started down the programming path. We had been married just over a year when she showed me how to use Microsoft Access to create databases, entry forms, and reports. She knew how to do some of the code behind to solve problems. As I noted in the first paragraph, her dad was a significant influence during the start of my career. His influence was not lost on her either. It was that work she did with me that got me interested in computers. If you ask her today, she is more a user of software and not a builder of applications. However, she was the first to show me the possibilities and joy of creating applications for practical uses.

My Success and My Wife

Over the years, I have worked in the corporate world and in consulting. As my career began to take off, Sheila supported me and the effort required to learn and move up in a career which I started after completing college. From Bethany Press to Magenic to Xata to Magenic and now Pragmatic Works, she has been supportive, even when it made life harder at home. Without her, I would not have been able to do much of what I have accomplished.

I really had this perspective reinforced with the article from Harvard Business Review – The One Thing About Your Spouse’s Personality That Really Affects Your Career. Here are a couple of highlights from that article that speak volumes about Sheila’s influence on my career:

First, conscientious spouses handle a lot of household tasks, freeing employees to concentrate on work (“When you can depend on someone, it takes pressure off of you,” Solomon told me). Second, conscientious spouses make employees feel more satisfied in their marriages (which ties in to the first study I mentioned). Third, employees tend to emulate their conscientious spouses’ diligent habits.

… what isn’t obvious is the extent to which so many people are parts of teams, in a sense — two-person teams that are based outside the office.

Being a data guy, it is really cool to see research reinforce the impact my wife has on my career. Interestingly, I have made job changes to retain that support as well. The companies that have supported my wife have been the most enjoyable to work at. Even when the job demands were rough, those managers and leaders who cared about my wife and family both in word and action were the best places I worked at. Here is one last quote from the HBR article about this topic as well:

We can’t and probably don’t want to know the details about these teams, but as Solomon points out, if organizations really understood the workplace effects of strong outside relationships, they might be more receptive to policies like flextime and telecommuting that make it easier for employees to spend time with their significant others.

I have been married over 20 years and have 4 teenage children. Without my wife and her support, I think that we would be in a very different place and I definitely would not be as happy.

So, to the love of my life, thanks for putting up with the long hours, working weekends and travel. I know it has been hard, but with you I am a better person and more successful. Thanks so much.