Login to online classes

Participate in Microsoft BI DataMashUp Contest & You could win $3000 Prize

  • Last updated on September 15, 2011
Picture of Chandoo

Chandoo

Share

Facebook
Twitter
LinkedIn

Hello Data Junkies & Chart Lovers,

I have a fun announcement for you. If you like to analyze data and present results in charts, then you can win up to $3000 in prizes by participating in Microsoft’s BI DataMashUp Contest. The contest is on from September 8th and runs until 28th.

MS BI DataMashUp Contest

How to Participate in this contest?

  • Head over to DataMashUp Facebook App
  • Follow the instructions to download PowerPivot CTP3 & Data sets
  • Analyze and present results using Excel
  • Upload your visualization screenshots to their site
  • And if you won, you could walk away with $3000 or $1500 or $500 worth prizes.

Guess who is judging this contest?

You are right. I am going to judge this contest, along with few other industry experts & Microsoft employees. I am eager to see what you can come up with and learn from your techniques. So go ahead and participate. Visit DataMashUp page for details.

Special thanks to Romain & BI Team at Microsoft:

Thanks to Romain, Emilie from Microsoft who invited me to judge this contest. 🙂

More info & Tutorials on PowerPivot:

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my story • FREE Excel tips book

Want an AWESOME
Excel Class?

advanced-excel-dashboards-course-chandoo
Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst

FREE Goodies for you...

Excel formula list - 100+ examples and howto guide for you
100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks
13 Advanced Pivot Table Skills

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Get started with Power BI

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Related Tips

11 Responses to “Who is the most consistent seller? [BYOD]”

  1. Hui... says:
    February 18, 2015 at 2:09 pm

    The Date column in the sample file is Text not Dates

    Reply
  2. Who is the most consistent seller? | CareWare says:
    February 19, 2015 at 4:59 am

    […] http://chandoo.org/wp/2015/02/18/calculating-consistency-in-excel/?utm_source=feedburner&utm_med… […]

    Reply
  3. Vishal Srivastava says:
    February 19, 2015 at 5:42 am

    Great Chandoo. Keep it up, Looking forward more from BYOD..

    Reply
  4. gayani says:
    February 19, 2015 at 9:41 am

    Thanks

    Reply
  5. Frank Tonsen says:
    February 19, 2015 at 1:15 pm

    With Excel 2013 the pivot table could be connected to the data model which provides a distinct count.

    Reply
  6. Mak says:
    February 19, 2015 at 4:21 pm

    This will do for invoice count
    =COUNTIF(F:F,H12)
    Instead of
    =COUNTIFS(sales[SELLER],$H12)

    Reply
  7. Alejandro says:
    February 20, 2015 at 8:24 pm

    Excellent document. How did you make the last graphic? Witch app. Thanks for answer.

    Reply
  8. Chris says:
    February 25, 2015 at 10:27 pm

    Can someone tell me what =countif(sales[date],sales[date]) is counting? The value is 19. Its found in the =SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))

    Reply
    • Vândalo says:
      May 12, 2015 at 2:14 pm

      Hi Chris,

      =countif(sales [date],sales[date]) function is counting the unique dates in the table.

      Vândalo

      Reply
  9. Nguyen says:
    March 25, 2015 at 7:18 am

    Excellent document!

    Can you explain more about the calculation on Weighted consistency? More specific the small number is 0,00001 ?

    How come the number should be smaller if there is more sellers?

    Reply
  10. TS says:
    September 5, 2018 at 6:40 am

    Hi,

    Not understood this formula: {=SUMPRODUCT(IF(sales[SELLER]=H12,1/COUNTIFS(sales[SELLER],H12,sales[date],sales[date]),0))}

    Please explain.

    Thanks.

    Reply

Leave a Reply