Formula for Matching Data Sets

Hey all,

 

I am working on an analysis project for a tradeshow and am having a difficult time writing the formula to match up different data sets with each other. I’ve attached the general problem we’re trying to solve below.

 

data set 1: An attendee indicates during registration a product they’re interested in.

data set 2: Exhibitor’s register their booth under the same products attendees selected above.

data set 3: We have a scan list of every attendee that visited every exhibitor booth.

I am trying to write a formula to solve how often attendee’s made it to the booths that sell the products that they indicated they were interested in. I have been successfull in doing it for a very basic test but my current formula would not scale. 

Just for extra in we’re looking at ~15k attendees with who pick an average of 3 products each. with ~600 exhibitors who sell 3-5 different products a piece.

By: Kyle Craig

19 thoughts on “Formula for Matching Data Sets

  1. coconut oil off

    Hola! I’ve been following your website for some
    time now and finally got the bravery to go ahead and give you a shout out from
    Porter Tx! Just wanted to tell you keep up the good work!

  2. quest bars cheap

    Pretty nice post. I just stumbled upon your blog and wished to mention that I
    have really enjoyed browsing your weblog posts. In any case I will be subscribing for your rss feed and I hope you write once more soon!

  3. quest bars cheap

    Hello I am so delighted I found your blog page, I really found you by mistake, while I was searching on Askjeeve
    for something else, Regardless I am here now and would just like to say thanks for a
    incredible post and a all round thrilling blog (I also
    love the theme/design), I don’t have time to read it all at the moment
    but I have bookmarked it and also added your RSS feeds,
    so when I have time I will be back to read more, Please do keep
    up the awesome jo.

  4. ps4 games

    Hey! I know this is kinda off topic nevertheless I’d figured I’d ask.
    Would you be interested in trading links or maybe guest authoring a blog post
    or vice-versa? My site covers a lot of the same subjects as yours and I believe we could
    greatly benefit from each other. If you are interested feel free to send me an email.

    I look forward to hearing from you! Superb blog by the
    way!

  5. Theron Avance

    The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you could fix if you werent too busy looking for attention.

  6. coconut oil

    My programmer is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the expenses.
    But he’s tryiong none the less. I’ve been using WordPress on several websites
    for about a year and am nervous about switching to another platform.
    I have heard excellent things about blogengine.net. Is there a way I can import all my wordpress posts into it?
    Any kind of help would be greatly appreciated!

  7. sling tv

    Wonderful article! That is the kind of information that are
    supposed to be shared across the net. Shame on Google for now not positioning this submit upper!
    Come on over and visit my website . Thanks =)

  8. sling tv

    Greetings! I know this is kinda off topic however , I’d figured I’d ask.

    Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa?

    My website discusses a lot of the same subjects as yours and I feel we
    could greatly benefit from each other. If you might be interested feel free to send me an e-mail.

    I look forward to hearing from you! Terrific blog by the way!

Leave a Reply

Your email address will not be published. Required fields are marked *