Does Your Identity/Biometric Research Project Need Excel…or Bredemarket?

Does your identity/biometric firm require research?

Introduction

When talking about marketing tools, two words that don’t seem to go together are “marketing” and “Excel” (the Microsoft spreadsheet product). Because I’m in marketing, I encounter images like this all the time.

Daniel Murrary (of Marketing Millennials fame), who used the image above in a LinkedIn post, noted that the statement is incorrect.

You never realize how much math marketing has, but excel is an underrated marketing skill.

From https://www.linkedin.com/posts/daniel-murray-marketing_you-never-realize-how-much-math-marketing-activity-7071849222035177472-Pp_-/

It’s true that marketing analytics requires a ton of Excel work. I’m not going to talk about marketing analytics here, but if you have an interest in using Excel for marketing analytics, you may want to investigate HubSpot Academy’s free Excel crash course.

But even if you DON’T pursue the analytic route, Excel can be an excellent ORGANIZATIONAL tool. As you read the description below, ask yourself whether my Bredemarket consultancy can perform similar organization for YOU.

Excel as an organizational tool

As I write this, Bredemarket is neck-deep in a research project for a client. A SECRET research project.

By Unnamed photographer for Office of War Information. – U.S. Office of War Information photo, via Library of Congress website [1], converted from TIFF to .jpg and border cropped before upload to Wikimedia Commons., Public Domain, https://commons.wikimedia.org/w/index.php?curid=8989847

While I won’t reveal the name of the client or the specifics about the research project, I can say that the project requires me to track the following information:

  • Organization name.
  • Organization type (based upon fairly common classifications).
  • Organization geographic location.
  • Vendor providing services to the organization.
  • Information about the contract between the vendor and the organization.
  • A multitude of information sources about the organization, the vendor, and the relationship between the two.

To attack the data capture for this project, I did what I’ve done for a number of similar projects for Bredemarket, Incode, IDEMIA, MorphoTrak, et al.

I threw all the data into a worksheet in an Excel workbook.

By Microsoft Corporation – Screenshot created and uploaded by Paowee., https://en.wikipedia.org/w/index.php?curid=58004382

I can then sort and filter it to my heart’s content. Ror example, if I want to just view the rows for which I have contract information, I can just look at that.

Bredemarket as an identity/biometric research service

And sometimes I get even fancier.

From Spreadsheet Web, “How to combine data from multiple sheets.” https://www.spreadsheetweb.com/how-to-combine-data-from-multiple-sheets/

For one organization I created a number of different worksheets within a single workbook, in which the worksheet data all fed into a summary worksheet. This allowed my clients to view data either at the detailed level or at the summary level.

For another organization I collected the data from an external source, opened it in Excel, performed some massaging, and then pivoted the data into a new view so that it could then be exported out of Excel and into a super-secret document that I cannot discuss here.

Now none of this (well, except maybe for the pivot) is fancy stuff, and most of it (except for the formulas linking the summary and detailed worksheets) is all that hard to do. But it turns out that Excel is an excellent tool to deal with this data in certain cases.

Which brings me to YOUR research needs.

After all, Bredemarket doesn’t just write stuff.

Sometimes it researches stuff, especially in the core area of biometrics and identity.

After all, I offer 29 years of experience in this area, and I draw on that experience to get answers to your questions.

Unlike the better-bounded projects that require only a single blog post or a single white paper, I quote research projects at an hourly rate or on retainer (where I’m embedded with you).

By Staff Sgt. Michael L. Casteel – [1], Public Domain, https://commons.wikimedia.org/w/index.php?curid=2407244

So if you have a research project that you haven’t been able to get going, contact Bredemarket to get it unstuck and to move forward.