Tag Archives: WIMS Guide

WIMS Client Spotlight Charlotte Phoenix esports

WIMS Client Spotlight: Charlotte Phoenix eSports

The Charlotte Phoenix are a professional eSports organization dedicated to enhancing the Charlotte eSports scene. Founded in 2019, the Phoenix have competed in several different video games and pro leagues. As a part of the CLT Esports family, the Phoenix value their surrounding Charlotte communities and support all efforts rewarding passions in eSports, gaming, art, and technology. Whether streaming games online or holding in-person LAN events in the Queen City, the Charlotte Phoenix are hyped to entertain their fans and fellow gamers.

They have teams for the following games:

  • World of Warcraft
  • VALORANT
  • Rocket League
  • Call of Duty (Challenger Teams)
  • League of Legends (Challenger Teams)

After rising #FromTheAshes with a brand-new look in 2019, the Charlotte Phoenix have spread their wings into more games in 2020, starting with VALORANT.

Visit the website and stay tuned to their social channels for merchandise deals, news on upcoming events, and exciting announcements throughout the rest of the year! If you’re interested in partnership or sponsorship opportunities make sure to reach out as well as it’s a truly unique time and opportunity as their audience and influence is growing rapidly.

Get Ready Stay Ready

Get Ready. Stay Ready.

The more appropriate saying is, “STAY ready so you don’t have to GET ready.” Alas, I unfortunately wasn’t following these guidelines. Not too make excuses, but between baby #2, the holidays, and then just plain life I got out of shape and way off the rails. Don’t get me wrong, plenty of things still went really well during this time, but despite that I began to slack in two really important areas: health and finances. Worse yet, I know better than to fall into this downward spiral.

At the beginning of the CoVid-19 situation and quarantine this continued for a week or two (in fact it became even easier with the gym closing and more time at home, etc.). I had known for a while some sort of market correction was on the horizon, knew I should be incredibly prepared for it, yet I STILL didn’t do nearly enough.

Finally I realized I had to wake up and snap out of it! Just because I wasn’t where I should be, doesn’t mean you shouldn’t do everything in your power to start and get there. Better late than never, right?

This epiphany was a few weeks ago now, as I just finished Day 25 of a program called 75 Hard. 75 Hard is a program created by a game named Andy Frisella, the CEO of a supplement company called 1st Phorm. The criteria list is below. It’s part fitness challenge, but it is equally a mental challenge as well which is what was just as alluring.

As my companies WIMS Consulting, EolianVR, and ARRE (Augmented Reality Real Estate) all continue to grow and scale at a pretty rapid pace I have no choice but to continue leveling up. If I’m not practicing what I preach and leading by example then I shouldn’t expect many to follow. That very much includes health and finances, but also just the mental toughness and focus required as well (pretty obvious, right?)

I’m 1/3 of the way there, 2/3 to go! Here are the rules:

  • Work out two times a day for 45 minutes minimum. However, one of them has to be outside regardless of the conditions (I’ve had several late night workouts in the rain already and they were actually glorious).
  • NO booze.
  • Follow a diet – Mine is essentially based on NO dessert/sweets and intermittent fasting for at least 4 days of the week.
  • Drink a gallon of water a day.
  • Read at least 10 pages of a physical book (no audio books allowed).
  • Take a progress picture each day (luckily those are starting to get better now haha).

So far I’m already down about 15 lbs (I still have about another 15 to go). I’ve crushed 2 books – Zero to One by Peter Thiel and Bold by Peter Diamandis. Next up is finishing Blitzscaling by Reid Hoffman. That being said, there is still a long way to go. There is even more reason to ratchet up as in the next 1/3 as I hit my 34th birthday in about 4 weeks and I want to hit that milestone with serious momentum.

The hard part is getting back on track, the “getting ready.” Hopefully after this time around will make sure to stay ready across the board for whatever comes next.

What are you doing during this time to stay on top of your game and get better? Or are you just using this time to relax and reflect? Either way that is a deeply personal choice but I’d love to hear.

WIMS Client Spotlight Close Off Market

WIMS Client Spotlight: Close Off Market

Charlotte-Based Real Estate Tech Startup Close Off Market, Inc. Launches New (Beta) Platform
Close Off Market is a unique technology platform that offers subscription-based access to off market commercial real estate deals in an efficient and user-tailored manner.

Close Off Market, Inc. and its team has been working tirelessly to solve a major problem facing the real estate community, tighter margins because of slowly moving deals and antiquated business practices. The platform leverages pre-existing technology, such as e-signature, CRM, ecommerce, etc. and then added its own proprietary algorithm on top to bring it all together. The business is built off the hypothesis that further enabling technology to add another layer of efficiency will help streamline the entire sales cycle and will make a tremendous impact on their users’ business.

If you’re in the commercial real estate industry you know how important getting access to the best possible deals at the best possible time can be to help increase the ROI on a potential transaction. Whether you’re a developer, investor, property manager, or otherwise having access to the best information, operating an efficient business, maintaining great relationships, and making timely decisions can make or break your organization.

Close Off Market has completely systematized the process to streamline the entire cycle and present its users with off market deals that are fully customized to their specific desired criteria.

Close Off Market’s co-founders are Clifford Blanquicet, Jr. and his wife Anna Blanquicet. Clifford is an entrepreneur and CEO of Blanq Real Estate, he’s also a commercial real estate broker, investor, and property manager. This problem is something he experiences daily and is extremely familiar with. Finding a way to solve it became a passion project of his that eventually led to the spin off and creation of the new entity.

He wanted a simple, automated, yet functional platform that expedited the commercial real estate acquisition process, while also providing invaluable insight into what his clients needed and wanted in their respective businesses. After searching unsuccessfully for such a platform, he noticed a void, and a potential opportunity. This led him on the path of creating Close Off Market.

After allocating the necessary resources and assembling a team, he and the company recently finished their internal development and testing phases and have now launched the initial beta platform to the public. While there is an extensive product road map in place that will continue to be rolled out in the near future, the existing iteration of the Close Off Market platform is ready for further user testing.

ABOUT CLOSE OFF MARKET
Charlotte-based Close Off Market, Inc. is a real estate tech startup focused on streamlining the process of commercial real estate acquisitions. The company offers a secure, cloud-based technology platform that provides subscription-based access to off market commercial real estate deals in an efficient and user-tailored manner. For more information, please visit: https://www.closeoffmarket.com/.

###

Charlotte 2020

Charlotte 2020: Grow Your Business in the QC

If you live or do business in Greater Charlotte then you already know there’s a whole lot to be excited about in 2020 and beyond. The opportunities here are incredible, the city and state of NC in general are growing at a crazy fast pace and receiving all sorts of recognition nationally in “Best Places to Do Business” type articles. You can see for yourself (here, here, and here). Figuring out where to get plugged in or get more involved can be overwhelming, so I wanted to give you a few quick initial steps (4 to be exact) to take in the new year to kick things off, and I’ll elaborate and expand on this further throughout Q1.

Whether you’re new here, haven’t arrived yet, grew up here, or have been here for years now I highly recommend investing your time getting to know other professionals who are doing big things in business. Networking here has led to a substantial ROI for me and my businesses and I can’t encourage it enough. There are tons of organizations and resources with which to leverage at various price points and time commitments based on you and your company’s needs.

Personally, I’ve been involved in various capacities at board and committee levels with the Charlotte Regional Business Alliance (formerly the Charlotte Chamber of Commerce). I’d highly recommend it as a great place to start and get involved. However, to be fully transparent, after merging with the region’s economic development entity the organization’s mission and day-to-day focus are shifting pretty substantially.  Rather than solely focusing on greater Charlotte, The Alliance now has 15 counties across both NC and SC in its purview. Needless to say, that while it’s a positive shift overall that provides incredible opportunity, the scope and reach has shifted dramatically. Serving that wide an area comes with new challenges as well however, so clearly the day-to-day operations needed to change with it.

While I still very much intend to remain involved as a member and hopefully more, it would be a disservice to you if I didn’t say the new mission has simultaneously left a pretty sizable void for those with a more narrow focus of making an impact in greater Charlotte and don’t have the resources to have a target market that expansive. Again, yet another opportunity

This is where the Charlotte Business Group comes in. (Full disclosure: I recently joined the board in 2019 because I knew this transition was happening and wanted to prepare accordingly.) There are still a ton of business professionals who just have the capacity to focus on Greater Charlotte (it’s hard enough covering the Lake Norman to Rock Hill/Fort Mill area as it is, let alone a dozen plus other counties). So we decided to step in and do just that. We’re providing networking opportunities with our mixers, educational opportunities with our panel discussions, and we recently launched a membership program to be able to ramp up additional opportunities in the community (as well as with more focus on fostering referrals and connections but much more to come as the year rolls on). The focus will remain greater Charlotte, but everyone who wants to do business here is more than welcome to get involved. If you and your organization wants to align with that mission please reach out to me to set up a membership or sponsorship and we’ll get you plugged in.

Next up is another really non-negotiable if you’re serious about Charlotte. You need the Charlotte Business Journal in your life, by way of subscription (print and digital), attending their events, and you NEED the Book of Lists.

Charlotte Inno (formerly Start Charlotte) with their newsletter and PitchBreakfast events among others are also truly invaluable. Whether you want to learn about local start up success and origin stories, or see what other events are coming up on the horizon (they host many incredible ones themselves as well) you at least need to sign up for the newsletter and take it from there.

 

We’ll leave it here for now, as that’s 4 invaluable steps that you need to take in the new year if you haven’t already. But I’ll be adding much more with respect to the specific Charlotte focus moving forward (including a non-profit edition). Would love to hear your feedback on what organizations you’re involved with, what you’d recommend and to continue the conversation as it’s one that’s a major priority for me.

WIMS Client Spotlight Proteith

WIMS CLIENT SPOTLIGHT: PROTEITH Oral Hygiene System

Revolutionizing Oral Health Care

Proteith sport and healthy.

PROTEITH® Oral Hygiene System is an all-natural formulation of plant proteins, vitamins, enzymes, minerals, and antioxidants scientifically balanced to fight periodontal disease. PROTEITH® is dentist-certified to maintain a healthy mouth for protection from gingivitis, canker sores and aphthous ulcers, tartar build-up, dentin hypersensitivity, and oral malodors or halitosis. PROTEITH® natural toothpowder users have reported the following benefits with dentist-certified data:

  • Stops bleeding and receding gums
  • Heals mouth sores and cuts in the mouth
  • Cleans teeth and removes surface stains
  • Prevents tartar buildup
  • Reduces tooth sensitivity
  • Eliminates bad breath

Why Choose PROTEITH®?

PROTEITH® is a patent-pending formulation containing only the highest quality ingredients to support a safe and effective regimen for your teeth and gums. Not only is it one of the best products for gingivitis, but it has a whole host of other benefits as well.

Proteith Diagram

To learn more about the science behind Proteith, read testimonials from other users, or to purchase some for yourself please visit: https://www.proteith.com/. For a discount, email Mike Simmons at msimmons@wims-consulting.com.

If you have periodontal disease, consult your dentist for best results. These statements have not been evaluated by the FDA. This product is not intended to diagnose, treat, cure, or prevent any disease.  See A Study of Protein-based Toothpowder Effectiveness on Reducing Gum Tissue Pocket Sizes in Dental Patients for dentist-certified data.

Make Cannabis Legal Again SuperPAC

WIMS Client Spotlight: MCLA SuperPAC

“IN 2020 WE WILL MAKE CANNABIS LEGAL AGAIN”

“If we had to start from scratch and design a medicine to help lead us out of the opioid epidemic, it would likely look very much like cannabis.” — NEUROSURGEON SANJAY GUPTA, M.D.

Medical Proof
Marijuana is medicine. There is science-validated, medical proof that cannabis can be used in the treatment of Alzheimer’s, Cancer, Crohn’s disease, Epilepsy, Glaucoma, Multiple Sclerosis, muscle spasms, PTSD, pain management and more. The science is clear: cannabis delivers results to those who need it.

Based on science alone, North Carolina should have a medical marijuana program. The fact that people are suffering when they can have access to proven medicine is barbaric. We deserve better.

There are now 33 states in the U.S. that have functional medical marijuana (MMJ) programs.

WHY DOESN’T NORTH CAROLINA HAVE A MMJ PROGRAM?

Beyond Medicine
Medical Marijuana is good for the economy. A well-managed medical marijuana program greatly increases the need for not only farmers and the agricultural industry, but for white-collar professionals like accountants and lawyers, as well as skilled professionals like electricians and HVAC specialists. It also provides retail opportunities for equipment and nutrient suppliers.

Based on data provided from the current 33 medical marijuana programs, MMJ would create 25,000 jobs in North Carolina. The total value of added revenue to the N.C. economy would equal or exceed $2.5 BILLION per year.

NORTH CAROLINA WILL BENEFIT FROM A MMJ PROGRAM!

Help Us, Help All
The science and data are clear. North Carolinians deserve the choice to use medical marijuana to help treat illnesses and benefit our economy. We need your help to make the message clear.

Until recently, politicians were able to hide in gerrymandered districts, purposefully avoiding the discussion of medical marijuana. But in 2020, we’re hopeful this will change. Help us convince our politicians to support medical marijuana.

If you’re interested in getting involved you can click here to get more information, donate, and spread the word.

NORTH CAROLINA DESERVES A MMJ PROGRAM!

*The MCLA SuperPAC is a FEC Registered Independent Expenditure-Only Committee.”

Why Loyalty Programs Don't Work

Why Loyalty Programs Don’t Work…

As Marketers, one of the key metrics we follow is brand engagement, also known as Loyalty.  We often talk about the size of a market, or how much market penetration a particular business or campaign has achieved.  Loyalty is the measurement of how much of our captured market repeats business with us.

It’s said keeping a customer is cheaper than gaining a new one.  Considering the retail industry as a whole spent over $1.9 Billion in 2016 running Loyalty programs, I’d say it’s still pretty costly.  Businesses use “Loyalty Programs” or “VIP Clubs” as a way to grow customer loyalty.  Unfortunately, these programs are often costly to operate and rarely translate to any kind of loyalty to the brand using them.

The average house is participating in over a dozen loyalty programs, and less than half the users are active or engaged with the brands.  While the program is designed to increase loyalty, the business ends up spending money on the customer base that’s least likely to leave.  These programs effectively cut into the profit margins from customers that were likely going to return, regardless of any additional perks.  That last part is especially true considering most of the participants either don’t know how to redeem the rewards, or don’t care enough to find out.

You can find all of this information and research with a simple Google search.  However, there is one market segment adding these types of programs at a faster rate than previous years.  The beverage industry, specifically Breweries, Brewpubs, Tap houses, Wineries and Vineyards, Distilleries, and Hard Cider Mills.  The most common model is by far the Mug Club, or Mug Membership.  While some are a one-time payment, most are annual or monthly payments to a business, providing the member with added perks.  Now, as a former member of these clubs, I LOVED them.  I probably doubled my money with the perks I received.  An example of the perks is as follows:

-Personalized mug, typically 2-4 ounces larger than the standard pint but priced the same

-Brewery/Tap house Merchandise (T-shirts, Hats, Koozie, bottle openers, stickers, etc.)

-Discounts on Beer/merchandise

-Special Events (no cost to members)

-First in line for special events/product releases

-Free Growlers and discounted fills

The average cost of these programs to the members can range anywhere from $40 to a couple hundred, depending on the Brewery or Bar.  I spent $150 to join one, and $85 a year to keep it renewed, with additional shirts and events with each renewal.  The Breweries justify this by saying it creates a group of loyal customers that will promote the business outside the walls and gives the members a unique sense of community.  When most of the Brewery clubs have 100 members or more, that’s a big cut into a profit margin from a group of people that would likely be loyal customers with or without the club.  Can the breweries prove these members are promoting them in the community? What’s the return on the brewery’s investment?  If you can’t prove something works, how do you justify the expense?

 

Alternatives to the Club

Now you don’t think I’d sit here and rip apart an old system that’s been in place for years without offering alternatives, do you?  I love a good beer, and want to see these Breweries grow.  They stay in the same system, or don’t participate, because there aren’t many people out there talking about alternatives.  The end goal is to increase their market share, and promote loyalty within their current customer base.

 

Special Release Clubs

These kinds of membership clubs seem to work for those chasing the elusive “Whales”, or special limited run bottles.  Breweries can forecast what kinds of beer they want to make, based on cost of production, and divide that total into the membership count to give them the cost per member.  Tag on whatever margin they need to make it worth their time, and the membership group can turn a profit before the first batch ever goes into production.  This gives the members a sense of loyalty, status, and keeps them engaged with the brand as they look forward to the next release.  There’s a value add, and breweries can measure the benefit.  Club members typically have to travel to the brewery to pick up the bottles, and will often spend a bit more on beer during the visit.  POS systems can track the members and allow breweries to measure the additional revenue per member at the time of the visit.

 

Active Point Systems

This is a new take on the long-standing loyalty system, but with a twist.  Breweries, Distilleries, Cider Mills, and Vineyards/Wineries can easily turn their typical social and marketing engagements into a point system.  By continually engaging with their markets, breweries can put out a series of tasks that equal points.  Create a clear, public facing list of “award tiers” that customers can follow, and the point totals needed to reach each one.  World of Beer did something along these lines with their “1 point per beer purchased” programs, with prizes ranging from a free t-shirt to a private party with a free keg of your choice.  Not a bad start, but they could have gone further.

The one beer = one point model only works when people are in the building, and it isn’t typically something most of their market thinks about unless they’re already patronizing a location.  The prizes also need to be collected from the location they signed up for the program.  This negates the benefits if someone moves or a location goes out of business.  You can switch your “home” location, but that’s unnecessary friction for the customer.

Award Tiers need to not only benefit those already in the building, but also incentivize the market as a whole to either patronize a brewery, or promote the brewery.  Our team at WIMS put together a system that rewards your market for not only coming in to buy your product, but also promote your product to their own network.  You keep them engaged with your brand with regular bonus point activity, creating a sense of community.  We put a system in place that allows you to track and quantify the return on investment from the dollars spent on a marketing campaign.  The best kind of loyalty is from customers that not only frequent the brewery, but also promote the brewery when they’re not there.  Expand the market and increase loyalty within the new segments as it grows.

Whatever system you put in place for your Brewery, Distillery, Cider Mill or Winery, make sure you can measure the results.

If you have any questions or comments about this article, I’d love to hear from you.  Reach out in the comments below or sign up for our monthly newsletter.

Cheers!

-Tom Schaefer, Jr.

Part 1 of aseries…

Data Analytics Dashboard

How Anyone can Build a Custom Data Analytics Dashboard

If you could carve out an hour a month for analysis in order to save a dozen hours of work, the one-hour investment would be worth it, right?

How about if that same hour led to crucial details about your sales trends and customers insights?

On top of all that, what if that same one-hour investment came at no additional cost to you?

Seems like a pretty great deal.

Welcome to the benefits of an Excel-based analytical dashboard.

Benefits of an Analytical Dashboard

You’ve most likely heard of the powers and benefits of data analytics. You’ve probably seen examples from things like POS systems, Tableau, cloud-based software, and many others.

Some of these benefits include the following:

  • Saving you time and money through efficiency and more impactful insights

Spending time looking over your dashboard saves hours of debating anecdotal or piecemeal results and helps guide you towards the best path forward

  • Giving you better insights into your customer to improve marketing campaigns

Campaigns based on hard data are more successful as you can target your intended customer more effectively

  • Taking the guesswork out and make great, data supported, decisions in less time

The high end services all have their merits, but in a small business where you might not have the budget for those services (which are also potentially far beyond the capabilities you actually need), plus a large learning curve, those services don’t always make the most sense.

By learning (on a much faster learning curve) to make a dashboard in Excel, you can get the benefits you want in a completely customized dashboard at no cost (since you already have Excel on your computer).

 

Why use Excel for this

Let’s start with some common business questions.

How did your sales do last month? How does that compare to the same month of the prior year? How about compared to the pace you’ve been running at this year?

Now how about separating those numbers by project, item, or client? How about by distribution channel? Sales rep? What about the specific days you had promotions?

The first set of questions is somewhat easy to have a gut feeling for, if nothing else. You might even have some quick analysis created for you in QuickBooks (or similar software).

However, the second set of questions represents another level deeper. You might feel a bit less confident about your gut feeling. They require you to dive into the data each time you want to look, and maybe even anecdotally piece it together from a few different sources. It’s kind of a hassle, but they’re important insights, so it’s worth the time.

Here’s the good news from Excel – you can answer all of those questions, from top line revenue down to whatever level of detail you need, and have them at your fingertips in one place!

With a simple export of data from whatever source you need, you can populate dozens of custom views that you’ve templated and turn it into your very own analytical dashboard!

The only time intensive piece is building the template and framework for all your custom views.

After you create that, you’re essentially just updating with data each week/month/etc. and looking it over for trends. Making changes to it? Duplicating views with variations? Actually, all pretty easy.

The Excel Dashboard

Here is a very quick sample dashboard that shows that topline sales numbers (black chart) followed by a few, slightly deeper, analytical pieces that help evaluate performance (gray charts).

When I say “very quick” … this dashboard took less than an hour to fully create. Real life dashboards of this level of depth take a similar amount of time. Getting significantly deeper into the data does not necessarily mean significantly more time to create though.

Only a few “next level” type questions are displayed (although these may only be half a level deeper), but they are meant to be representative, and the great feature about the “behind the scenes” of the dashboard is that the building blocks for all levels of analysis can be VERY easily duplicated to get at any question you need.

Take a quick look at the dashboard, follow it along the yellow markers, 1 to 5. Any trends jump out at you?

You can likely see the following in a quick pass:

  • Sales are up in 2019! (Callout #1) – by 22.1% if we want to be specific

  • There seemed to be a change in performance starting in February (Callout #2). Perhaps a new item was released? Or a new marketing campaign?

  • All Sales Reps are selling more this year (Callout #3). Shawn leading the pack with a 28.7% increase over 2018

  • In Store sales have grown by over 60%! (Callout #4). However, Online sales have shrunk a tiny bit.

  • Further diagnosing, it looks like Jennifer and Oliver have really improved their In Store sales, while Shawn has faltered there (Callout #5). Perhaps there was a training that stuck with Jennifer and Oliver? Maybe Shawn has just focused all of his attention on Online sales?

Those types of insights are crucial to running your business and can be seen quickly from the dashboard. On top of that, there are still tons of different ways to cut the data… by product, by product and distribution channel, by sales rep by month, etc. All of these examples are (almost) as easy as copying and pasting.

Creating the Backend of the Dashboard – a General Guide

We start with one of the building blocks of an Excel-based analytical dashboard. Simply, the Pivot Table.

Depending on your level of familiarity with Excel, Pivot Tables might seem like “that complicated next level” or “that tool we use every day”.

The truth is, everyone can easily be at the latter, and if you’re already there, you could probably be using them more even more effectively. Investing just a bit of time can have a very outsized benefit to your business.

Pivot Tables are fantastic, for all levels of users, because of a few main pieces of functionality:

  • Very easy to build, use, and manipulate

Drag and drop methods, no complex formulas, no macros or coding

  • Ability to create charts and dashboards from the Table(s) easily

  • Build automatically updating formulas off the Table to create new data elements

It deserves mentioning that the quality of your data is very important. If the data is wrong to start, then there is no point is doing any analysis.

First… a few tips on how to create a Pivot Table

Feel free to skip this section if you’re already familiar.

For a detailed “how to” build a Pivot Table, I recommend watching from ~2:30 to ~5:30 in this video. The rest of the video has some good explanations as well, but for a quick guide, the 3 minutes is really all you need.

One piece I would highly recommend changing though, is in the data selection piece.

Important – select the entire column in the data, making sure the headers are in row 1. This allows you to add data in the future and have it included in the pivot table without having to change the data range.

The boxed-in range is okay as “ Sample Data!$A$1:$E$13 ”, but would need to be changed if you add more data to the end of it. The better version’s range “ Sample Data!$A:$E” highlights the entire columns.

Onto Creating the Dashboard

Start with creating a Pivot Table, and from there it is really just about dragging and dropping fields, copying and pasting, and picking a layout!

  • Let’s say you begin by creating a simple Pivot Table with sales by month:

  • From there, go up to the ribbon and find the “Pivot Table Analyze” or “Analyze” tab, depending on which version of Excel you’re working with.

  • Select the “Pivot Chart” option, and out pops a variety of options. Select your favorite chart option (bar chart, line graph, multiple types, etc.) and boom! You’ve got a working chart to help you analyze!

  • Any time you change what’s in the Pivot Table that created the Pivot Chart, the Pivot Chart will change accordingly.

Example, if you limited the data to just “Jennifer” (Sales Rep filter), you’ll see only her sales in both the Table and Chart.

Tip for the aesthetics of the Chart

To get rid of the “buttons” or ugly looking gray bubbles polluting your chart, you can right click on any of them and select “Hide All Field Buttons on Chart” and they’ll go away (as shown below).

If you don’t mind their appearance, each button acts as a filter for the Pivot Table. So instead of scrolling over to the Table, you can filter right from the Chart.

  • From there it is just preferences:

You can add a chart title, hide the legend, and a lot of other customization by clicking on the Chart, and then selecting the green “+” button that appears to the right of the Chart (shown below).

Once you’ve got your first chart, you can then start the duplication process!
  • To make another Pivot Table and Chart combo, you can just select the entirety of the Table, then copy and paste it elsewhere on the sheet

Copying the Pivot Table to be replicated
  • Drag and drop the fields (from the Field List on the right) you want to look at in the new Table (ex. Sales Rep in place of Month), and then go through the same quick process to create a Chart

The premise here is that each Table you create is referencing the same data. Each variation is just how you want to cut the data for that particular view.

Note – the formatting you select for one chart will not transfer to a new chart. The easiest method is to pick from Excel’s preset templates, which are normally visually appealing enough – both the black and the gray Charts above are in Excel’s preset templates. You can always customize the look of every chart individually to how you want though.

Best practice is probably to settle on a color scheme and layout after you’ve created all the charts you want, that way you can quickly go through each and select the same layout all at once.

After creating however many variations that get to your necessary level of depth, you’ve now just created yourself a dashboard! Congrats!

Best Way to Create Formulas Based on the Tables to get Additional Metrics in your Dashboard

You may notice that some pieces in the above dashboard (the tables with headers that have blue background and white text) are not Pivot Tables or Pivot Charts. These are created using the same information though.

Enter the GETPIVOTDATA formula. It is one of the most complicated looking formulas, but one of the most effective to use.

Note that it is simply complicated “looking”, but not actually that complicated to use.

Here’s an example. We’re going to walk through the Sales By Month table in the dashboard above (and referenced below).

Let’s say you wanted to get that 41.1% “Growth vs Prior Yr” for Feb from the information in the Pivot Table.

Naturally, you would do the following (referencing picture below) U10 / T10 – 1 = 41.1%

When you go to do that though, this scary looking formula comes out:

Let’s break it down and look at the first piece, before the “/”:

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

Translating, it is saying the following:

  • From the Pivot Table

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

  • Grab the metric “Sale Amount”

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

  • In the Pivot Table located in cell S7

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,”Month”,”Feb”)

  • Given the following criteria, Year = 2019

=GETPIVOTDATA(“Sale Amount”,$S$7,“Year”,2019,”Month”,”Feb”)

  • And the second criteria Month = Feb

=GETPIVOTDATA(“Sale Amount”,$S$7,”Year”,2019,“Month”,”Feb”)

You’ll notice the second GETPIVOTDATA (after the “/”) is the same formula, just referencing Year = 2018 instead of 2019.

It is the same formula as the nice and easy U10 / T10 – 1 above, just bringing in the functionality of the Pivot Table.

So why on earth would you actually use the complicated version?

Reason #1: Let’s say you add in another filter and the bulk of the Pivot Table shifts down by one row. The U10 / T10 – 1 will remain but will now be looking at a different month.

Reason #2: What if you changed the Pivot Table to include each Sales Rep’s details in each month (like below)?

Now that “U10 / T10 – 1” formula would be referencing Jennifer’s sales in Jan… not even close to total Feb sales.

If you used the GETPIVOTDATA formula, you would still get the result you want (Total Feb Sales Amount, 2019 over 2018) because you’re telling it what criteria to look at, regardless of what cells the intended data ended up in. It would still do $26,070 / $18,470 – 1, or 41.1%.

Note – in a scenario like the above picture, make sure Subtotals are enabled in the “Design” tab that appears when you click in the Pivot Table

Reason #3: You can completely customize the look of your created table, whereas you have limited aesthetic flexibility in the Pivot Table itself. I choose a blue header with white text.

Reason #4: You retain the copy and paste functionality of the “U10 / T10 – 1” formula but increase the accuracy of the formula.

Notice in our summary chart with each month’s “Growth vs Prior Yr”, we have the month abbreviation in the left column, then the % growth in the right column.

To utilize the copy and paste functionality of formulas in Excel, we just have to reference the month in the formula.

It is the same formula as above in every way except for the P9 in place of “Feb”. This just tells the formula to take the value in cell P9 as the criteria needed to be found in the “Month” section.
You can then copy and paste this formula to each of the months, and the “Growth vs Prior Yr” will fill out for each month, regardless of how many other variables are in the Pivot Table, or where the numbers you want are located (cell-wise).

Summary

So now you’ve learned…

  • The benefits of a dashboard, specifically one in Excel

  • How to make a Pivot Table

  • How to make a Pivot Chart based off it

  • How to duplicate those efforts (for efficiency)

  • How to reference the information in it to get analytical metrics that aren’t directly called out in the Pivot Table

  • (Most importantly) How to build your own fully functional, completely customizable analytical dashboard!

Updating the dashboard is an exercise that takes mere minutes to download the data and add it into your data sheet.

Reasonable time investment to make the dashboard, small time investment to update it, big business benefits.

WIMS BREWERIES & WINERIES

3 Marketing Tips for Breweries, Wineries, Cideries, & Distilleries

The brewery and winery industries have been fortunate to have experienced a major boom in public interest along with media attention over the past few years. Just opening a new location has been a major event that has typically generated a lot of buzz and received coverage by every Business Journal and local social media influencer alike. That’s not to say that marketing breweries and wineries has been easy of course, far from it.

Once the grand opening has passed, and the novelty subsides, the business must continue to attract a loyal and recurring customer base, in addition to the one-off tourists and large groups as well. While all businesses have their tried-and-true marketing methods that work, we wanted to offer up some that may appear obvious, but they truly work. And when done effectively in conjunction with a robust marketing and sales strategy, they’ll keep your brewery or winery full of customers for a long time to come.

Tastings and tours are a “must” for any brewery, winery, cidery, or distillery. However, even if you diligently open your brewery daily for happy hour, there’s much more you can do to raise product awareness. In order to broadcast your brand’s name, it helps to bridge the gap between physical and digital. While locals and tourists might stop in for some beer, wine, or cider, incorporating digital marketing into your outreach campaign will multiply your success. These digital marketing strategies help breweries and wineries attract interest and show off their new craft beer and wine releases, as well as just consistently get people through the door.

 

Blog Posts

Creating a new beer, wine, or cider is still big news. Your fans (and prospects) want to hear about it! However, people also want to know what they’re getting into before purchasing beer from a brewery. For many, that means doing some research beforehand. Introducing a new beer, wine, or cider through blogging is a fun, creative, and informal way to get word out of your newest product. Along with sharing information about the new release and the story behind your winery or brewery online, you can link to your social media pages as well. With these additional steps, you’ll effectively reach your social media followers and those who have signed up for email alerts or announcements (not to mention jack up your SEO rankings). This makes it easier for followers to share the news about your brewery or distillery on their social networks too.

 

Email Campaigns

While it often takes a back seat to social media, email marketing is still a significant part of a successful marketing strategy. Surprisingly, many breweries, wineries, and cideries use social media exclusively as their digital marketing strategy. Considering that 3.2 billion people use social media worldwide, tapping into a social network is a good start. Yet, email is even more effective in reaching a target brewery or winery audience than Facebook or the others. Studies show that 900 out of 1,000 people see a company’s message via email compared to just 20 out of 1,000 people on Facebook. Ultimately, it’s worth your time and effort to create a message that 90% of users will see. Email also has the power and convenience of automation. With social media, on the other hand, you’ll need to personally post a message every day or at least several times each week (which you should be doing ALSO).

 

Social Media Ads

Even though email campaigns are the fastest way to reach a broad audience, don’t underestimate the power of social media for your brewery or winery. About 67% of the US population uses Facebook, which translates to many potential views. Facebook advertising is simple and easy for breweries and wineries to use, and you can even try A/B testing to see which campaigns and strategies are most effective.

 

From tried-and-true email to web content and social media, there are many creative and effective avenues that breweries, wineries, distilleries, or a cideries, can use to increase brand awareness and spread news of a new wine, cider, or beer. If you’re interested in discussing how you can build upon your existing marketing and sales strategy reach out to us at WIMS Consulting and we’d be happy to help!

Starting a Company: When Do You Quit Your Day Job?

At a recent Charlotte Business Group event I moderated a panel on entrepreneurship. We hit various topics that provided the audience with a ton of value, so I wanted to share some of the key takeaways from the discussion with you. The event featured a great group of local entrepreneurs that covered a wide range of topics about starting, and running, a company.

Our panelists included:

To begin, as far as the “when do you quit your day job” question, there wasn’t a specific answer that fit everyone, as it’s a deeply personal situation. It truly varies for every individual. And in some cases, the answer is never. So, as you can imagine, most of the conversation surrounded providing details about what worked for each of the panelists, as well as them offering various ideas with respect to the way they thought about (act acted on) that at the time.

That being said, below are some of the key takeaways from the evening. There was a lot to unpack and share so I may come back and edit/add more in the coming days.

Ideas for businesses come from a variety of places. In some cases, you can innovate, break, and then reinvent the wheel. In others you can make small tweaks to existing business models that work elsewhere. Or you can find a specific niche and build from there. Business opportunities arise from a multitude of potential catalysts. One great takeaway that stuck with me was to use Bill’s “if you spend 30 minutes researching a problem and aren’t sold something (i.e. served ads) within that time frame you just might have a business idea.”

Just Start. You need to have a little bit of risk involved; you can never get rid of it completely so don’t let that keep you from starting. You don’t need to have absolutely everything figured out. The important thing is to take action consistently. Bill had another great gem; he created a list of 100 things/task and did 1 a day. By sticking to that he started his company in 100 days.

You don’t always NEED to quit your day job. It’s ok to keep your day job long term, keep it for a while as you get traction in the business, or “jump off the cliff and build the plane on the way down.” Everyone has a different risk tolerance and level of resources available to them. Others like Chris just like and prefer continuing to keep their job as they grow their businesses and don’t feel the need to quit.

Know your target market. Learn about what they value, the problems they need solved, and what needs they need met. These are the fundamental elements of launching a business. Market fit is crucial to identify the initial opportunity. Scalability comes later.

Create systems to lean on. As you build your business you want to create systems, procedures, automations, etc. to make sure the business can (eventually) run without you. You don’t need the latest and greatest technology for this, just implement processes that work to help you stay on top of managing everything as things can get overwhelming quickly.

Delegate the things you’re not good at. Pretty much everyone mentioned getting a good bookkeeper/accountant to manage the finances (as that wasn’t necessarily any of their strengths). That’s just an example to reiterate that in order to grow your business you need help and need to be able to delegate the tasks that aren’t suited to your strengths. This may take time as resources are limited, you may need to wear many hats in the beginning, but make this a priority as soon as you can.

There are a variety of ways to fund your business depending on your goals. This is yet another personal preference. Some people bootstrap, building with sales and revenue as they go. That was Elechia’s preferred approach as she met with doctor after doctor, potential patient after patient and growing along the way. Others raise money from investors to continue growing and scaling. You can also leverage debt with SBA loans, etc. There is plenty of research out there about ways to fund and grow your business.

Know what your long-term goals are. While you don’t need to do this first, eventually you should try to have an exit strategy in mind (or the lack there of) as you initially build your business. Whether you plan to eventually sell it, build a business you want to work at for the long haul, or simply want a side-hustle, they’re all fine as long as you’re transparent and honest with yourself and your partners.

All that being said, it’s ok to just have a short-term side hustle that only lasts a year or two and provides some additional income along the way. There doesn’t have to be a long-term vision if that’s your primary objective. As was mentioned several times, each situation and individual is different.

There are many other things to consider when starting and running a business. This was just a small snapshot of a great evening filled with plenty of additional takeaways. What are some of the things you’d add to the list?

The Charlotte Business Group has a lot more educational events like this planned where we share knowledge and experiences from local professionals. We aim to continue nurturing the business and entrepreneurial spirit and providing opportunities for the community to do so. Make sure to keep an eye our for the upcoming schedule!