Consulting, Microsoft Technologies, Personal

Why I tweet about work and personal topics from the same account

Over the last few years, I’ve had a few people ask me why I don’t create two Twitter accounts so I can separate work and personal things.

I choose to use one account because I am more than a content feed, and I want to encourage others to be their whole selves. I want to acknowledge that we don’t work in isolation from what’s going on in the greater world.

I love learning things from people on Twitter. I find a lot of quick tips and SQL and Power BI blog posts from Twitter. I love seeing all the interesting data visualizations shared on Twitter.

A wooden table with a phone and a cup of espresso. The phone is opening the Twitter mobile app, and you can see the twitter icon in the center of the screen.
I often start my mornings with caffeine and Twitter.

But I also love learning personal things about people. I love to see photos of your dogs and views while hiking. I like knowing that my friend Justin is really into wrenches. And my coworker Joey (who I followed on Twitter long before I worked with him) is really into cycling. And my friend Matt is into racing. I followed all these people before I met them in person. Many of my Twitter friends became “IRL” friends after we met at conferences.

I definitely lurked around the SQL community (Power BI didn’t exist yet) for a while before I ever worked up the courage to say anything to anyone. And I started out with mostly data/work-related tweets. But as time went on, I realized how much I appreciated when others shared personal info about themselves, that helped me get to know them better. And I became more comfortable sharing more about me. So now I’m sort of giving back, with both professional and personal information.

Note: I do this personal/professional crossover only on Twitter, because I have deemed that to be an appropriate audience for both. I don’t share many personal things on LinkedIn. And I don’t share professional things on Instagram or Facebook. That’s my personal preference.

Are there risks to this? Absolutely.

People might stop following me because they don’t care for the personal content. My political opinions or obsession with my dog might turn some people off. Someone might be offended by my tattoos or my occasional use of profanity (which I never direct at someone and use more to express frustration/excitement/surprise). Or they may tire of my frequent use of gifs.

I know that potential and current clients see what I tweet. And it can and does affect their opinion of me. But when you hire me as your consultant, you get my personality and personal experiences as well as my tech knowledge. So, I don’t see it as being so very different from meeting me in real life at a conference or at another social event.

So far, it’s been an overall positive experience of having IRL conversations with clients about something I tweeted that they found helpful or entertaining. I do make a point not to name specific clients or projects unless I have their permission to do so (sometimes there are legitimate exceptions). I respect client privacy and confidentiality online and in person.

Before I could get to this place, I had to be secure in myself and secure in my employment and professional network. I recognize that not everyone will like me. That is true in person and on Twitter. And that’s ok. If you want to unfollow me, I’m ok with that. If you want to engage in conversations only about work stuff, that’s great. Feel free to mute words to tune out the rest of my tweets (your best bets are “Colorado”, “Denver”, “dog”, “kayak”, and “hike”). If you want to talk only about dogs and nature and my adorable and efficient camper, that’s also fine.

If you dig deep enough, I’m sure you can find some tweet that wasn’t my best moment. I’m sure I’ve said something regrettable in the 14 years since I joined Twitter. But I’m going to extend myself a little grace and remember that I’m human. And I’ll accept feedback if you think something I’ve said was unkind or made you feel unwelcome.

There is also a risk that someone can use this personal info against me, for harassment or identity theft. That is a risk for anyone sharing anything personal online. For now, I have assessed the risks and the rewards, and I find the rewards to outweigh the risks. I may decide differently later.

Do I recommend this for you?

Here’s the thing: I don’t think there are absolutes when it comes to how people use social media. If it makes you happy and it’s not hurting anyone, it’s probably fine.

It’s important to me that we remember that the people who teach us Azure and SQL and Power BI are people with non-work interests and personal struggles and interesting life experiences. And their more personal content gives me ways to relate to them outside of technology. Sometimes I learn really useful things from them, like the right type of lubricant to fix a squeaky door. Sometimes I notice a current event in their life that I can use to start a conversation at a conference.

Basically, I choose to use Twitter in a more human way. It’s working pretty well for me so far. You can decide if you have the desire and ability to do that. When this way of interacting with people stops being rewarding for me, I’ll reassess and take a different approach.


Quick Programming Note: New Job!

I started this blog in 2013 during my first consulting job. In 2014, I joined BlueGranite, which is where I have been for the last 4 years. The knowledge gained while working with them has been the inspiration for a lot of the content on this blog. It has truly been a pleasure to work at BlueGranite. Work is fun when your leadership team is trustworthy and transparent and open to feedback, and your coworkers are smart and motivated and want to help you learn. I can’t express how much I appreciate the professional relationships and friendships formed during my time with them.

But an interesting opportunity presented itself to me, and I have decided to take it.

Denny Cherry & Associates logo

Today is my first day working for Denny Cherry & Associates! I’m excited to be working with Denny (B|T), Joey (B|T), Kerry (B|T), Monica (B|T), John (B|T), and Peter (T). I’ve known the consultants at Denny Cherry & Associates for years through the SQL Community. My chats with them at conferences and on twitter demonstrated their incredible SQL and Azure knowledge, and I can’t wait to learn from them. I might even teach them a thing or two about BI/Analytics. I feel very fortunate to work for a company that values and encourages participation in the technical community. There are five Microsoft MVPs (including me), and all 6 consultants are speakers and bloggers. DCAC does a healthy mix of implementations, migrations, health checks, support, and training. They have completed many interesting and impactful Azure projects, which was a big draw for me.

Otherwise, things should be business as usual for me: work from home with the bulldog and a little travel as needed. I’ll continue to blog here in my free time with new coworkers and projects to serve as my inspiration.

Microsoft Technologies, PASS Summit, Personal

Learning Better Presentation Skills (T-SQL Tuesday #108)

TSQLTuesdayThis month’s T-SQL Tuesday is hosted by Malathi Mahadevan (@SqlMal). The topic is to pick one thing I would like to learn that is not SQL Server.

I’m going to go a different direction than I think most people will. I spend a lot of time learning new technologies in Azure, but I am also focusing on learning better presentation skills and improving my use of related technologies. Yes, that often means PowerPoint. But sometimes I do presentations directly in Power BI when I am presenting data or mostly doing demos. Building presentations requires tech, design, and speaking skills. And I enjoy that mix.

I enjoy presenting at user groups and conferences, and lately I’ve been branching out in the types of presentations I give. At PASS Summit this year, I delivered a pre-con and a general session, and I participated in a panel and the BI Power Hour.  Each one required a slightly different presentation style.

Just like we may cringe when we go back and look at old code and wonder what we were thinking, I have the same reaction when I go back and look at old presentations.

As a data viz person, you would think I would be better at building engaging presentations since a lot of the data viz concepts apply to visual presentation, but it’s still a struggle and a constant endeavor to improve.  I have made some progress to date. Below is a sample from a presentation on good report design practices in SSRS that I gave in 2015.

Old Presentation

While it’s not the worst slide I’ve ever seen, it’s definitely not the best. Here are a few slides from my PASS Summit presentation called “Do Your Data Visualizations Need A Makeover?”, which cover the same topic as the above slide.


The new slides are much more pleasant and engaging. I have changed to this style based upon what I have learned so far from Echo Rivera’s blog and her Countdown to Stellar Slides program. I use more and larger images and less text on each slide. This naturally leads to having more slides, but I spend less time on each one. And there is less of a chance that I will revert to just reading from a slide since there is just less text. I get to tell you about what that one sentence means to me.

My goals is to learn how to deliver presentations that are more accessible and more engaging.

I blogged about accessible slide templates earlier this year. I got interested in accessibility when I was learning how to make more accessible Power BI reports.  I want people to feel welcome and get something out of my talks, even if they have visual, auditory, or information processing challenges. So far, what I have learned is that I can be more inclusive with a handful of small changes.

To continue my learning about presentation delivery, I plan to:

And of course, I plan to give presentations so I can try out what I learn and improve from there. I have already submitted to SQLSaturday Colorado Springs, and I’m sure I will add more presentations next year.

If you have resources that have been particularly helpful in improving your presentation delivery, please leave them in the comments.

Happy T-SQL Tuesday!


Conferences, Microsoft Technologies, PASS Summit, Personal

Join Me At PASS Summit 2018

The PASS Summit 2018 schedule has been published, and I’m on it twice! On Monday, November 5, I am giving a full-day pre-con with Melissa Coates on Designing Modern Data and Analytics Solutions in Azure.  We’ll have presentations, hand-on labs, and open discussions about architecture options in Azure when building an analytics solution. If you’ve been wondering how your architecture should change when moving from on-premises solutions to PaaS solutions, when to use SSIS versus ADF V2, options for data virtualization, or what kind of data storage technology to use, we would love to have you attend our pre-con.

I also have a general session at PASS Summit: Do Your Data Visualizations Need A Makeover?. I’ll share the signs that your data visualizations aren’t providing a good experience for your users, explain the most common reasons why, and give you tips on how to fix it. Data visualization is a skill that must be learned and that we all should continue to sharpen.  We’ll have some fun discussing common mistakes and looking at examples. This session is scheduled for Wednesday, November 7 at 4:45pm.

If you are on the fence about attending PASS Summit, I highly recommend it, especially if you have never been. There are so many benefits for data professionals:

The content:

  • There are opportunities to learn from some of the top Microsoft Data Platform experts in the world.
  • Microsoft product and customer advisory teams have a large presence at the conference, so you can ask them questions and get advice.
  • The wide array of content allows you to go deeper on topics with which you are already familiar or to get an intro to a topic that is adjacent to your current knowledge that just wasn’t clicking for you by reading blog posts or books.

The networking:

  • You get to meet data professionals from all over the world. You can make new professional contacts and friends with whom you can keep in touch afterwards.
  • If you are looking for a new job, it’s a great place to make connections.
  • You can talk to the speakers whose blogs you read and conference sessions you attend! If you spot your favorite speaker at PASS Summit, it is a great place to introduce yourself or ask a question.

The fun:

  • There are lots of community events, including happy hours, game nights, and more.
  • There is always something to do for dinner, between receptions, sponsor parties, and friendly groups to tag along with.
  • SQL Karaoke is happening somewhere pretty much every night.

These benefits are most definitely real, not just over-hyped advertising. I have friends and colleagues of many years that I first met at PASS Summit. I first met Melissa Coates at PASS Summit, and now I work with her and present with her. And I got to help edit the Power BI whitepaper she wrote with Chris Webb (whom I also first met at PASS Summit – I fan-girled a little and asked for his autograph on his Power Query book the year it came out).  I got job interviews after letting colleagues at PASS Summit know that I was looking one year. I had a blast singing karaoke with a live band at an evening event last year. I could continue this list for quite a while, but I think you get the picture.

If you will be attending PASS Summit for the first time, check out the attendee orientation from Denny Cherry on October 2nd as well as the buddy program and speed networking event at the conference.

If you haven’t registered for PASS Summit yet but are planning on it, check with your local SQL/Power BI user group or a PASS virtual chapter for discount codes.

I hope to see you there.

Azure, Conferences, Microsoft Technologies, Personal

Please join me for my PASS Summit Pre-Con with Melissa Coates

I’m excited to announce that I’m joining forces with Melissa Coates (aka SQL Chick) to do a full-day PASS Summit Pre-Conference Session this year!

We’ll be talking about Designing Modern Data and Analytics Solutions in Azure.

Many traditional data warehousing professionals as well as other data engineers are taking on analytics projects in Azure. There are more (and ever-changing) options available in Azure that extend our capabilities beyond what we had on premises. And there are several different ways to create an analytics solution in Azure, to the point that it can be difficult or overwhelming to have to make those technology decisions up front.  We want to help you get started in Azure, provide design patterns and reference architectures, and share our lessons learned from solutions we have implemented. We’ll talk through technologies such as Azure SQL DB, Azure SQL DW, Azure Data Lake, Azure Data Factory, Azure Databricks, HDInsight, Analysis Services, Azure Machine Learning, Power BI, Virtual Machines, and more.

Approximately 30% of the day will be hands-on labs, 50% presentation, and 20% open discussion and questions.

Attendees of our session will gain a broad understanding of the fundamentals for designing data solutions in Azure, techniques for navigating the wide variety of platform choices in Azure, and suggestions for developing sound architectural systems.

I hope you’ll join us on Monday, November 5th.


Conferences, Personal

Join Me on

I’m honored to join the great group of people at as a mentor. I think it’s a wonderful effort to help new speakers improve their skills and confidence. Speaking at conferences and user groups has brought me a lot of new knowledge, friends, job opportunities, and travel opportunities. I’m so grateful to the people who provided feedback and encouragement to me over the last 5+ years since I started speaking. If you’d like to know more about how Speaking Mentors came to fruition, you can read about it here.

It can be scary to put yourself out there, but it is well worth it. And you have a host of mentors from which you can choose to support you and cheer you on. If you’ve been thinking about trying your hand at presenting and would like some free one-on-one guidance, this is your chance. If you are feeling unsure about presenting, I have a couple of thoughts for you:

  1. There is room for you as a speaker. Don’t be too concerned about having an absolutely special/unique/creative topic or take on a subject. If you have knowledge that other people would find interesting or useful, that is a great place to start. Your point of view and way of explaining things is valuable. Sometimes a speaker covers a topic that has been done a million times but says something in just the right way that it finally clicks for someone. Or someone brand new to the topic attends your talk and gets excited to learn more.
  2. While you should practice your presentations before delivering them and make sure you have good knowledge on your topic, it’s perfectly ok to not know all the answers to all the questions anyone could possibly ask. Also, even great presenters have shaky sessions every once in a while. Give it a good effort, but don’t be worried about being absolutely perfect.

On a related note, the Denver SQL User Group is currently looking for speakers for our April through November meetings. We meet on the third Thursday of the month, and we have a 30-minute presentation and a 60-minute presentation in each meeting. A 30-minute presentation at a user group is a great way give speaking a try. If you learned something interesting about the Microsoft Data Platform or you solved a cool tech problem at work, volunteer to present about it. Contact me on twitter or send an email to Events (at) DenverSQL (dot) org to chat about speaking at a future meeting. We’re friendly and there’s free food.


Personal, Power BI

End of the Power BI Updates List

I just finished updating my Power BI updates list for the last time.  I started the list in November as a way to keep track of all the changes. When I first started it, they weren’t posting the updates to the blog or the What’s New sections in the documentation. Now that Microsoft is on a steady cadence of monthly releases and doing a great job of communicating updates, there isn’t much need for this except as a fun data source. It’s also been about a year since Power BI V2 became generally available, so it seems like a good stopping point.

I removed the link to my updates page, but I left the page available for anyone who has it bookmarked and put a note on the page that the list is no longer being updated. I want to leave it in place because I appreciated the comments and the Power BI visuals people made using the list as a data source.

If you would like a copy of it to continue your own list or to use as a data source, you can access the file at

PASS Summit, Personal

My PASS Summit Abstract Feedback

I wasn’t selected to speak at the PASS Summit this year. One of my talks was selected as an alternate, but I’m not holding out hope it will move up. Update: My session got bumped from alternate to scheduled. See here for more information. 

While I am a bit disappointed, I’m ok with it.  I delivered a general session and a lightning talk at PASS Summit 2014, then took a year off and didn’t submit anything in 2015. But I was on the abstract review committee last year and this year.  It’s interesting to see how abstracts are ranked and feedback is provided. I have a few quick thoughts on not being chosen:

  1. Congrats to everyone who was chosen! I am happy for you, and I hope you enjoy the experience.
  2. My career and my confidence as a speaker are just fine. If my perception of my career/speaking success rested solely/mostly on being selected to a single conference, I would probably need to re-evaluate my goals and priorities. I have learned a lot this year, and I’ve had some fun speaking opportunities so I’m satisfied with my accomplishments in the first half of 2016.
  3. Although my attendance at PASS Summit 2016 is TBD, part of me is happy that if I do get to attend, I will do so without having to worry about speaking. It’s nice to enjoy the company of others and stay out late without stressing over last-minute tweaks to demos or being tired while speaking.

I think it’s helpful for me to see others’ abstracts that were submitted and the feedback they received, so I’m sharing mine. It can be difficult to tell sometimes if you are missing something or if it was just luck/circumstances (there happened to be an abnormal amount of good abstracts on your same topic, etc.). While I can’t talk about the program committee or the criteria we used for judging abstracts, I will point out that if you look at the feedback you will see some common themes that may provide guidance for future abstract submissions.

I’ve listed the abstracts I submitted below along with the feedback they received as well as my thoughts.

Help! Someone Got Slowly Changing Dimensions in my Tabular Model! (Not Chosen)

Category: General Session
Track: BI Platform Architecture, Development & Administration
Topic: SSAS – Advanced Tips and Tricks
Level: 300
Session Abstract: Many developers shy away from slowly changing dimensions that capture history because they seem complicated, but they can be useful and worth the effort. We often need to see what an entity looked like at the time of an event rather than its current attributes; e.g., a customer’s marital status, address, and age at the time of purchase is useful for analyzing buying patterns. Having this historical view makes our analytics more accurate and useful. Many people can figure out how to add slowly changing dimensions to our SQL Server database. But what do we do when we get to our SSAS Tabular Model? It’s not quite as easy as trading the surrogate key for the natural key in your formulas. We’ll examine the mechanics of Type 2/6 slowly changing dimensions implemented in SQL Server. Then we’ll discuss good practices for adding slowly changing dimensions to the tabular model. Finally, we’ll review common DAX formulas and see how we should alter them to accommodate slowly changing dimensions.
Prerequisites: Basic familiarity with the idea of slowly changing dimensions, understanding of Tabular SSAS) and common DAX calculations.

  • Define and explain the types of slowly changing dimensions
  • Provide tips on how to optimize loading of a type 2 or 6 slowly changing dimension
  • Demonstrate common calculations and how to change them to make them work with a type 2 or 6 slowly changing dimension
  • Sounds like it could be a good session but the abstract seemed all over the place. Hard to follow.
  • abstract seems to ramble. grammatical anomalies. punctuation misuse.
  • Fantastic topic, and extremely well-constructed abstract!
  • Well written abstract, sold me in easily. Seems to be on level. Clear goals.
  • Nice abstract with clear goals and outlines.
  • Abstract OK. Learning goals a bit roughly defined – could be more precise in this narrow topic.
  • Good abstract. Could be an interesting session to attendees.

My thoughts: There are some conflicting reviews, which is to be expected from a diverse group of reviewers. One of the reviewers seems to be extremely picky about grammar. I have reviewed the abstract, and I still do not see any grammatical issues. I am rather picky about grammar myself, but I think the goal of reviewing grammar in abstracts is to ensure that the abstract will be easily understood by attendees. As long as the abstract sounds professional and appropriately communicates what the session is about, tiny grammar issues and preferences don’t matter.

How to Care for Your Type 2 Slowly Changing Dimension (Not Chosen)

Category: Lightning Talk
Track: BI Platform Architecture, Development & Administration
Topic: SSIS – Building and Deploying Solutions
Level: 200
Session Abstract: Your type 2 slowly changing dimension (SCD2) needs love and proper care. Don’t over complicate your relationship with your SCD2, but also don’t let it feel unappreciated. Be straightforward and set ETL expectations appropriately. Be accepting if your type 2 slowly changing dimension decides he wants to be a type 6. This talk will help you understand your SCD2 and how to provide for him using SQL Server Data Tools and SSIS.
Prerequisites: High-level grasp of type 2 dimensions used to capture effective dated historical attributes. SSIS dev expertise to understand design patterns.

  • Define a type 2 slowly changing dimension and how it works
  • Show example table DDL for a Type 2 slowly changing dimension
  • Show an example SSIS package with a good design pattern for loading a type 2 slowly changing dimension
  • can this really be covered in 10 minutes?
  • Misalignment in abstract, learning goals and level
  • Cute abstract. Title matches the abstract well; goals well defined and aligned. Would be a good lightning talk; level might be better suited for level 100
  • Really good abstract for a lightning talk. Sounds like a topic that a good amount of people and sounds like something I would enjoy attending.
  • Abstract is well written and easy to understand.
  • Good topic but not sure about whether the subject matter can effectively be presented in the time allotted.
  • Very focused topic – great for a lightning talk. Very good prerequisites and goals. The abstract is entertaining yet clear.
  • Well written abstract, on level
  • Well written and to the point.

My thoughts: I had fun writing this abstract, and I look forward to delivering this talk somewhere else. There seems to be some debate about whether slowly changing dimensions are a 100-level topic for SSIS. I think they are not. Whoever wrote that probably underestimates their own knowledge and has forgotten what SSIS basics at the 100 level are like. I think it would be a challenge to deliver in 10 minutes, and that is very valid feedback. I would have liked to try it though. Lightning talks are tough. They require a lot of editing and practice to pack useful, interesting, and coherent info into 10 minutes.

Overcoming Chartaphobia with Power BI (Alternate)

Category: General Session
Track: BI Information Delivery
Topic: Power BI
Level: 100
Session Abstract: Do reports in your organization consist mostly of giant tables of data? Perhaps you have gotten as far as adding KPI indicators or conditional highlighting to the tables. Maybe you have charts, but they are hideous and distracting. Although tables of data presented as reports are commonly found in many organizations, they may be doing you and your users a disservice. We’ll discuss why cognitive psychological studies tell us that graphs and pictures are more effective at communicating trends and comparisons and how to prepare to create good data visualizations. Then we’ll explore how to employ purposeful data viz designs to help users achieve their goal of making informed decisions, using a fun and useful Power BI dashboard. You’ll leave with guidance on how to take boring or unreadable tables of data and turn them into useful and visually appealing reports.
Prerequisites: Interest in data viz and/or Power BI

  • Understand the right questions to ask when preparing to create a data viz solution
  • Explain 4 tips for effective data viz design
  • Demonstrate effective data viz design in a Power BI report and dashboard
  • Well written abstract and concise goals. I’m not sure if this will be of great interest
  • Don’t care for the data “viz” usage. This should be spelled out to visualization.
  • Whilst I get why the title might have chartaphobia in it – it still didn’t sound right. It’s not an actual word. The abstract is good, it does tell me that I may have charts but they’re “hideous and disgusting”. This didn’t sound nice and might turn some audience members away. The topic of Power BI is a good topic, the delivery just needs some work for a 100 level – explain earlier in the abstract how Power BI will make the charts better or exist at all.
  • Abstract: The level would be 200 Objective: I would like to attend this session.
  • I would’ve liked the goals to be a little more thorough.

My thoughts: I can’t imagine anyone being confused by the use of the word viz, but it can be a good rule of thumb not to include abbreviations or at least explain them. The comment about “chartaphobia” not being a real word made me laugh, but perhaps it doesn’t work well with an international audience. I would have put it in quotes, but I knew Orator tool we use doesn’t display those characters correctly. We all use different tactics to create catchy titles. I didn’t coin that phrase, but I think we all understand it isn’t a “real” word. I give this talk at SQL Saturdays and user groups and it goes over very well, so I’m not worried about the content of the session.

Building an Effective ETL Framework in SQL Server (Not Chosen)

Category: General Session
Track: BI Platform Architecture, Development & Administration
Topic: BIML
Level: 300
Session Abstract: An effective ETL framework helps you start and complete SSIS projects faster, employ reusable design patterns, and be consistent across packages and projects, lowering the learning curve for junior developers and your support team. Biml (Business Intelligence Markup Language) automates your SSIS design patterns and eliminates the manual repetition of solving familiar problems and making the same update over and over in similar packages. In this session, we’ll discuss and identify SSIS design patterns, learn how to create and automate them using BIML, and then see a demo of a package execution framework built using BIML.
Prerequisites: Basic proficiency in SSIS. Ability to read/understand XML and C# is helpful but not at all required.

  • Provide a basic overview of BimlScript, how it works, and syntax for creating SSIS packages
  • Understand the usefulness of SSIS design patterns, identify common patterns, and practice abstracting details from a package to understand the pattern
  • Create a master package with an easily extensible execution framework, using BIML
  • Sounds like a good session.
  • Basic and 300 don’t coincide. Need to decide is it an advanced topic or not.
  • nice abstract
  • Good topic. More detail in the abstract about what will be covered would be helpful – include more of what was listed in the goals. Based on the abstract, the level seems too high, but it seems right based on the goals.
  • Seems like a lvl 200 session. Not the most interesting BIML abstract I’ve read.
  • Not sure I can identify the level 300 material in the abstract. Would recommend as level 200. Great story line and an important topic to teach; design patterns.
  • Well-developed outline and goals with details. The title may be clearer by adding BIML in it.
  • Good but average abstract. Could be an interesting session to some attendees.

My thoughts: This wasn’t my most inspired abstract writing. I agree it probably was more of a 200-level session than 300. I marked it as such because this session requires you to put all the pieces together and understand architecture more than just how to write Biml to make it do stuff.  In previous years there was no Biml track, so this year’s chosen abstracts will help me gauge how to write for this topic next year. I’m sure this session will continue to evolve as I deliver it more, and maybe I’ll come up with a better title and description.

Who needs SSAS when you have SQL? (Not Chosen)

Category: General Session
Track: BI Platform Architecture, Development & Administration
Topic: SSAS – Building and Deploying Solutions
Level: 200
Session Abstract: Analysis Services may seem foreign or unnecessary for SQL and .NET developers. However, it can offer many advantages for reporting and data exploration, even with the SQL engine’s latest indexing and in-memory analytics capabilities. In this session, we will cover useful features of SSAS and discuss conditions where it is beneficial. Next we’ll compare the two types of Analysis Services databases (Multidimensional and Tabular) and identify requirements that should influence your decision of which type is right for your solution. Then we will explore common ways to retrieve data and browse your SSAS database, such as Power BI and Excel, reporting tools like SSRS, and custom .NET applications.
Prerequisites: Basic familiarity with data warehousing, interest in learning more about SSAS

  • Identify the conditions in which SSAS is preferable to using just the SQL Engine
  • Explain the differences between SSAS multidimensional and tabular
  • Demonstrate various ways of browsing and querying an SSAS model
  • Title a bit misleading. Was expecting a SSAS bashing, but pleasantly surprised with the meat of the abstract. Learning goals in line with level and abstract.
  • concise engaging abstract
  • Demo percentage seems low for such a topic but, overall, looks like a good session.
  • Good abstract. Sounds like a good session.
  • The idea presented in the introduction would be a good session, but it seems like the abstract strays from that path and into a general discussion of how to use SSAS. The abstract is well-constructed otherwise, and it effectively conveys the goals stated. The title seems to present the opposite viewpoint of the introduction to the abstract.
  • Well outlined abstract but if it had more demo, it would sound more interesting and persuasive.
  • Interesting and descriptive abstract. Seems to match level and topic.

My thoughts: This was some of the most helpful feedback I received. I don’t remember exactly what percent I said was demo, but the session could probably be redesigned to include more demos. And I have given this session before and received feedback that they felt the title was misleading. I will consider renaming the session in the future.

Personal, Telecommuting

Eight Things I’ve Learned in My First 3 Months of Telecommuting

A few months ago, I started a new job in which I telecommute. I was worried about whether I would enjoy it and whether I would be productive, and I wasn’t quite sure what to expect. I began my job by being as prepared as I could be and just going with the flow to get everything (laptop, online accounts, office furniture and equipment) set up with few expectations of how things would work. Now three months in, I can tell you that I love working from home. I can see why it wouldn’t be for everyone, but it’s great for me at this point in my life and career.

I will note that my company is a virtual company, which might make things easier than having some remote employees while others work together in a physical office. Almost everyone works from home (and many of us travel a bit).  Since we are all telecommuting, we don’t have the problem of some remote workers feeling like they are left out of office activities and banter with employees who are physically in the office. It feels like we are all in this together, communicating online and by phone as needed. Occasionally we meet up in person if we are in the same city or working together on a project.

Another advantage for my situation is that no one except my bulldog is in my house during the day to distract me. I can understand that it would be more difficult to work from home with a spouse, a roommate, or a child at home. Luckily, my office mate mostly sleeps all day.

So now that I have explained how things are going,  I would like to share with you some of the things I have learned thus far, working from home for a virtual company.

1.  I love the productivity and ability to concentrate that comes with working from home and having a flexible schedule.

I love that I frequently get 2 – 3 continuous hours in a day without interruptions where I am able to concentrate and make a lot of progress or delve deeply into learning a new technology.  My previous job was in a physical office that had the “cool” open floor plan, and my schedule had many meetings and several developers and project managers needing my help throughout the day. So this uninterrupted work time was a welcome change for me. On top of that, my company allows us to have flexible work hours as long as we are delivering good results and are generally available during common work hours when coworkers or clients need us. This may not be true for all remote workers, but my company trusts employees to set our own schedule.  This means I can go to the gym over lunch or take my office mate (bulldog) out for a walk in the afternoon and not feel guilty about it.  Ultimately, I have been able to arrange my schedule to achieve better work/life balance and increased productivity.

2.  Docking Stations are worth it.

I worked for a month just plugging everything into my laptop and unplugging when I needed to travel or just move to a different room. I finally picked up a HooToo Universal Docking Station for a decent price on Amazon, and it was well worth the money. Now my monitors, mouse, keyboard, camera, and headset all plug into the docking station, so it’s quite easy to unplug the one USB cord and wander off somewhere else with my laptop. The model I have works well with my Win 8.1 laptop so it quickly recognizes my connection and all peripherals when I plug back in.

3.  Ensure the dog has his supplies available in the office, too.

Each morning before I start work, I make sure I have my breakfast and coffee and any supplies I need for work that are not already in my office. I also do the same for the dog. I think my dog is cute, but not cute enough to get a starring role in my conference calls. My dog has a bed, some treats, and a toy in my office at all times. If he wakes up and decides he is bored or hungry or whiny while I’m on a call, I am prepared to quickly remedy the situation, at least until I can get off the call and let him out or figure out what he wants.

4. Amazon Prime has lots of good free music.

My office is a relatively quiet place, and sometimes I need some music to add a bit of background noise to work to when I’m taking care of tedious tasks (or when I have an earworm I just can’t get out of my head).  I already had a Amazon Prime subscription because I like free shipping, so the music was free for me to explore. Prime Music allows me to add certain songs, albums, or playlists to my library for free. I can then listen to them online or download them to a device for offline listening.  In addition, Prime Music also offers stations that allow you to rate the songs to customize the content (similar to Pandora). I like the selection offered, and new music is frequently added. Your mileage may vary based upon musical taste.

5.  Invest the time to become proficient in the use of your online meeting software.

When most of your meetings are online, and most people spend anywhere from a few minutes to half of every online meeting fumbling with settings in Lync or Webex (or whatever application you use), you can imagine how much of your time is spent just trying to get the meeting started and the appropriate content shared. I’m still working on this one, but things definitely go better when you are more prepared and knowledgeable in this area.  Once you’ve got it down you can help others learn the settings and help meetings around the world be more productive (or at least end sooner).

6.  It takes more effort to communicate with people when you rarely see them in person.

This may not be true for you, but it definitely is for me: I naturally interact better with people when I’m face to face with them. I was also used to getting a lot of information and context in informal conversations that occurred in the hallways in the office. Since there are no hallway conversations with people now, I have to make more of an effort to communicate with others. I had to get over any concern about bothering them and ask questions via Lync, phone, or email when I needed to do so (but not to the point of disregarding a busy status). My communication style over Lync has also changed. Where I was somewhat lax about spelling and grammar and was very brief/to the point, I now try to pay more attention to how I type and make sure I provide enough context for the conversation (which many times means switching from instant message to a Lync call). For many coworkers, their only interaction with me is our Lync or Yammer conversations, so I try to be friendly, make a good impression, and show a little of my personality while respecting their time and making sure they get what they need from me in the conversation. I’ve been at companies that had online message boards and used Lync a lot, but things change when these are your main methods of communication.

7.  Some (but not all) UPS stores will verify I-9 forms.

Form I-9 is used for verifying the identity and employment authorization of individuals hired for employment in the United States. In order to complete the form, the employer must physically review and verify the information and documents provided by the employee. This is very standard and something we all do when we start a new job in the United States. It gets interesting when you start a new job as a virtual employee that does not live close (within a 5 hour drive) to any other employees, and the company’s lawyer has provided guidance that this verification should not be done over video chat. This is how I learned that some UPS stores offer a service where they have a notary do the physical review and verification and sign off on it. Then you can send the form back to your company with the notary’s signature indicating the review is complete. Not all notaries will do this, and not all UPS stores that employ notaries offer the service.  I was warned in advance to call ahead and check, so I did and found one not too far from me that got the job done. This was more just an interesting intricacy of telecommuting with a geographically distributed company, but maybe it will be helpful to you.

 8.  I’m not lonely, and I didn’t become a hermit.

This is what I worried about most before starting my job. Although I am an introvert, I’m a fairly social person. If you aren’t aware, introverts are not always shy; they tend to prefer to spend more time alone or interact with small groups of familiar people rather than larger crowds or new people. I wondered if I would really like a job where I didn’t physically interact with people on a daily basis. I wondered if I would just never leave my house because of lack of work/life balance or laziness. So far none of those fears have been realized. If anything, because I have a flexible schedule and better work/life balance, the activities I do outside of my house feel more meaningful. I leave the house to be productive or enjoy time with friends and family rather than just because it’s Wednesday and I have to go to the office to work. I don’t have to worry about running home at lunch or after work to let the dog out because he was with me all day and I let him out right before I left the house. I have 30-45 minutes back in my day that I used to spend on my commute that I can now spend on something more enjoyable. And because I’ve been home all day, I’m a bit more motivated to go out and do things. On top of that, I have friends and coworkers that I can chat with during the day. So if I just need some interaction, I know who to turn to that will gladly chat for a few minutes.

Further Reading

Here are some good materials to read if you are considering telecommuting:
The 10 Best Articles on Managing a Remote Team
Telecommuting, Month 9
Why I Don’t Look for a Telecommuting Job
Eight Things I Have Learned While Telecommuting
A Desk Too Far?: The Case for Remote Working
How to Telecommute: Staying Motivated
How to Telecommute: Getting Things Done
What I Know For Sure…After One Year at SQLskills


2014 in Review

2014 was a wonderful, challenging, exhausting, exciting year. I grew a lot as a person and as a BI professional. This blog grew in content and in popularity.  I’d like to take a moment (and several paragraphs) to celebrate the great opportunities and great people who made my year special.

Speaking engagements

I gained more experience as a speaker/presenter in 2014 and marked a number of firsts in this part of my career. In addition, I got to travel and see many lovely places and meet good people.

Along the way, I met several people who deserve some recognition for their efforts as event organizers, coordinators, and volunteers:

  • I met Paras Doshi (t|b) at SQL Saturday #305 in Dallas, and he gave me the opportunity and encouragement to speak at the PASS BA Virtual Chapter. He gave a great presentation at SQL Saturday about How To Train Your Business Users To Create Their Own BI reports.
  • Miguel Escobar (t|b) and Diana Betancourt(t) put on a successful inaugural SQL Saturday Panama. They were so friendly and welcoming. Miguel got on a Skype call before the event to make sure I had all the information I needed, and he provided recommendations of fun things to do while visiting. Diana Betancourt is congenial, and her enthusiasm is infectious. She was a great representative for Panama tourism (as a native with great travel tips), SQL Saturday (as a speaker and volunteer), and the PASS community (as a friendly face) at the event.
  • Marc Beacom (t|b) organized the first Mile High Tech Con in Denver. He (and his team) went out of their way to make sure all of the speakers felt appreciated and comfortable throughout the conference. I hope I get to speak at MHTC next year! I also had some great conversations with him that I truly appreciate about BI and career topics.
  • Lance Harra (t) helped us organize SQL Saturday Kansas City this year. He brought lots of great experience and ideas and helped us be better organized and less stressed. We couldn’t have done it (or at least wouldn’t have wanted to do it) without him! He also supported his fellow Kansas Citians by attending my presentation at PASS Summit. It was nice to have a friendly face in the room.
  • SQL Saturday #332 (Minnesota) was the best organized SQL Saturday I’ve attended to date. They had plenty of volunteers and great support from sponsors. Congrats to Rick Krueger(t|b), Mike Donnelly (t) and the rest of the team.

I also had the opportunity to be in the audience to experience some impressive and inspiring presentations from other speakers:


I made a goal to blog at least once a month in 2014. Although I didn’t get a blog post in exactly every month, I did end up with 12 blog posts by the end of the year. Other interesting statistics from my blog include:

  • My blog is less than 2 years old and has been viewed over 14,000 times.
  • The blog post with the most views in 2014 was Retrieving Lowest Level Hierarchy Members and Leaves in MDX.
  • The most common search term (of those available) that led people to my blog was “ssrs 2014 visualization”.
  • The most popular links from my blog to other resources go to Stephen Few’s Perceptual Edge.

New Job

In December, I joined BlueGranite, a business analytics consulting firm with an excellent reputation and many interesting projects and opportunities for a BI developer like me to enhance my skills. I’m still settling in, but I have to say that it is a pleasure to work with some of the nicest and most talented people I’ve ever met. My new career opportunity is due in large part to the PASS community. Many SQL People helped me make new connections, gave me great advice and encouragement, acted as a sounding board, listened to me vent my fears and frustrations during the job hunt and transition, and then celebrated my new opportunity with me. A few that stand out are David Klee, Bill Fellows, Tim Ford, John Morehouse, Marc Beacom, and Hope Foley. My former job and speaking experience prepared me well for this new opportunity, but networking in the SQL Community made it happen. I went to PASS Summit and told my friends and colleagues that I was interested in new opportunities. They gave me great leads and good contacts, and less than 3 weeks later I had a new job.

2015 Goals

I’m taking Q1 off from speaking so I can rest up and settle into my new job. I probably won’t speak quite as much as I did last year, but I will definitely submit to speak at some SQL Saturdays and other conferences.

I plan to publish 18 blog posts this year. While most posts will be technical in nature, I’d like to write a couple posts about my experience as a virtual employee who works from home.

I’ve become a mentor to a college student who thinks he might be interested in BI and process improvement. I’d also like to get more involved with my local PASS chapter. And I’d still like to try to make a SQL BI Cruise happen.

I’m looking forward to new friends, colleagues, opportunities and adventures in 2015.