Power BI for Communication and Marketing

Published On: 2019-09-26By:

We often focus on deep analysis and insights generated by machine learning when we talk about Power BI these days because it’s super cool and very fancy. But I think it’s important to remember that you can also use Power BI for simple communication of data. As humans, we are hard wired to process visual information faster than text alone. And it’s often more efficient and concise to convey information in a visual rather than text. We can show in one image what it takes paragraphs to describe. Outside of historical analysis and operational reporting, we can use data visualizations as an engaging way to convey simple facts in a communication or marketing effort. Many people do this with infographics.

Visualization can make simple numbers and facts more memorable and engaging. I enjoy using Power BI for this marketing communication purpose, so I made a report about the people I work with at Denny Cherry & Associates Consulting. I knew most of them before I started working at DCAC, so I was already aware that they were exceptional. But now you can see it, too, with our new Power BI report located at https://www.dcac.com/about-us/learn-more-about-us.

Screenshot of the home page of our About DCAC Power BI report

Data is some people’s preferred language. We can use it to discuss specific points as well as broader trends and comparisons. I have a sticker on my laptop that says “Please Talk Data To Me” for a reason. I can make sweeping statements about how my team is full of accomplished consultants, speakers, and authors. But it is much more impactful when you see the numbers: 27 Microsoft MVP awards and 8 VMWare VExpert awards over the years, a combined 113 years of experience with SQL Server, 86% of us having been a user group leader.

My Surface Pro tablet with a “Please Talk Data To Me” sticker on it

And because Power BI is interactive, you get to interact with my report, choosing which categories you want to learn more about. There is also a little guessing game built into the report. (Although there is currently a Power BI bug that I had to work around, so the answers are limited to values 1-800 and 2001-2300. But that is a blog post for another time, and for now you get a hint as to possible answers.) If I had just told you these stats, you might have listened, but you probably would have tuned out.

Our team even had fun browsing the report, seeing our collective achievements, and guessing who provided which answers.

Building the report

It was quick and easy to use Microsoft Forms to gather the data and then dump the responses to Excel. From there, I made a quick Power BI data model and put together my visualizations. The report is embedded on our website using a Publish to Web link. A few people have said they would like to do something similar for their organizations, so I’ll offer a couple of tips:

  1. Make sure the questions you ask aren’t violating any HR rules, and that employees know that some or all questions are optional. For example, I asked personal questions in the Fun Facts section about number of children employees have. This question was optional and our team felt comfortable answering it.
  2. Try to group your questions into categories so you can easily the separate sections and pages like I did. Then you can associate a color with each category.

If you do make something similar, I’d love to see it. Tweet me a link or screenshot at @mmarie.

Contact the Author | Contact DCAC

Power BI for Communication and Marketing

Published On: By:

We often focus on deep analysis and insights generated by machine learning when we talk about Power BI these days because it’s super cool and very fancy. But I think it’s important to remember that you can also use Power BI for simple communication of data. As humans, we are hard wired to process visual information faster than text alone. And it’s often more efficient and concise to convey information in a visual rather than text. We can show in one image what it takes paragraphs to describe. Outside of historical analysis and operational reporting, we can use data visualizations as an engaging way to convey simple facts in a communication or marketing effort. Many people do this with infographics.

Visualization can make simple numbers and facts more memorable and engaging. I enjoy using Power BI for this marketing communication purpose, so I made a report about the people I work with at Denny Cherry & Associates Consulting. I knew most of them before I started working at DCAC, so I was already aware that they were exceptional. But now you can see it, too, with our new Power BI report located at https://www.dcac.com/about-us/learn-more-about-us.

Screenshot of the home page of our About DCAC Power BI report

Data is some people’s preferred language. We can use it to discuss specific points as well as broader trends and comparisons. I have a sticker on my laptop that says “Please Talk Data To Me” for a reason. I can make sweeping statements about how my team is full of accomplished consultants, speakers, and authors. But it is much more impactful when you see the numbers: 27 Microsoft MVP awards and 8 VMWare VExpert awards over the years, a combined 113 years of experience with SQL Server, 86% of us having been a user group leader.

My Surface Pro tablet with a “Please Talk Data To Me” sticker on it

And because Power BI is interactive, you get to interact with my report, choosing which categories you want to learn more about. There is also a little guessing game built into the report. (Although there is currently a Power BI bug that I had to work around, so the answers are limited to values 1-800 and 2001-2300. But that is a blog post for another time, and for now you get a hint as to possible answers.) If I had just told you these stats, you might have listened, but you probably would have tuned out.

Our team even had fun browsing the report, seeing our collective achievements, and guessing who provided which answers.

Building the report

It was quick and easy to use Microsoft Forms to gather the data and then dump the responses to Excel. From there, I made a quick Power BI data model and put together my visualizations. The report is embedded on our website using a Publish to Web link. A few people have said they would like to do something similar for their organizations, so I’ll offer a couple of tips:

  1. Make sure the questions you ask aren’t violating any HR rules, and that employees know that some or all questions are optional. For example, I asked personal questions in the Fun Facts section about number of children employees have. This question was optional and our team felt comfortable answering it.
  2. Try to group your questions into categories so you can easily the separate sections and pages like I did. Then you can associate a color with each category.

If you do make something similar, I’d love to see it. Tweet me a link or screenshot at @mmarie.

Contact the Author | Contact DCAC

Time for a Change

Published On: 2017-04-17By:

I am ecstatic to say I have joined Denny Cherry and Associates Consulting.

Lone No More

I am happy, excited, and nostalgic to announce that I am hanging up my Lone DBA hat and becoming a consultant. Yep, you read that correctly, I’ve decided after 16 years that I am going to change things up a bit. I am switching gears and will be helping those who are Lone DBAs and others by lending them a hand with their work loads.

Don’t get me wrong, I absolutely love being a Lone DBA. So, I will continue to speak on the topic and mentor others in that boat, but it’s time to give myself a little more freedom. Over the past 16 years I have been on call 24/7, even working while in labor, on vacations, nights, and weekends. I really think now is the time to slow down just a bit. My normal speed is 150 miles an hour so down shifting to 100 will allow me to spend time on what is important to me, my family.

Why DCAC?

First and foremost, the people. I am looking forward to working with and learning from Denny (B|T), Joey (B|T), and Kerry (B|T). These guys are wicked smart and most importantly know the importance of the SQL Community. They have a wealth of knowledge to share and I cannot wait to tap into it. With DCAC, I will be getting exposure to so many new environments as they are a renowned global provider of IT consulting and work on the cutting edge. I absolutely love learning new things and can’t wait to dive into things like Azure, which they excel at.

DCAC will give me the flexibility to speak and blog more which I genuinely want to do. Getting out into the community is also a strong passion of mine and moving out of the Lone DBA role will give me greater ability to do so.

Thanks, DCAC for bringing me on board, can’t wait to get started.

About Denny Cherry & Associates Consulting

The vetted and certified experts at Denny Cherry and Associates Consulting assist companies with attaining IT goals such as HA, scalability, SQL Server virtualization, migration and acceleration reliably, while finding ways to save on costs. With clients ranging from Fortune 50 corporations to small businesses, their commitment to each is the same: to provide a deft, high-speed IT environment that leverages every aspect of their platform: from architecture, to infrastructure, to network.

DCAC was named by CIOReview’s 20 Most Promising Azure Solution Providers of 2016.

Contact the Author | Contact DCAC

Welcome Kerry Tyler to Denny Cherry & Associates Consulting

Published On: 2015-11-19By:

I’m thrilled to announce that Denny Cherry & Associates Consulting has grown for the second time this year.  This time we have hired Kerry Tyler to join our company.  Kerry is based in the Nashville area but like the rest of us will travel to where the work is as needed.

Kerry has a well rounded background having been a SQL Server Consultant for the last two years and working with SQL Server for the last 10 years both with the core database engine as well as in the BI features of the product.  Kerry is going to continue to expand his knowledge of the SQL Server product while working with both new clients as well as our existing clients.

Kerry has spoken at several SQL Saturday events, and assists with running the Nashville SQL Saturday each year.  Kerry looks forward to the companies support of his continued speaking and hopefully his speaking at the PASS Summit in the future.

We welcome Kerry to the company, and we look forward to a long relationship together.

Denny

Contact the Author | Contact DCAC
1 2

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award    FT Americas’ Fastest Growing Companies 2020   
Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers