AB Data Consulting
AB Data Consulting
  • 86
  • 236 203
Alteryx Weekly Challenge #279 - AB Data Consulting
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu
Join us while we build our solution for Alteryx Weekly Challenge #279!
The dataset includes a list of city, country, year, continent, and season (winter or summer) for each Olympic Games except those canceled.
Your challenge is to find:
- How many times has each continent hosted the Summer Olympics?
- How many times has each continent hosted the Olympic Winter Games?
- What is the total of the Olympic Games hosted for each continent, summer and winter combined?
community.alteryx.com/t5/Weekly-Challenge/Challenge-279-How-many-Olympic-Games-per-Continent/td-p/795234
***********************************************************************************************
What is Alteryx?
Revolutionizing business through data science and analytics, Alteryx offers an end-to-end analytics platform that empowers organizations to break data barriers, deliver insights, and experience the thrill of getting to the answer faster. Hundreds of thousands of users all over the world rely on Alteryx daily to deliver real business results.
***********************************************************************************************
AB Data Consulting understands data challenges and equips teams with the knowledge, tools and confidence to overcome those obstacles and lead a digital transformation. Automation enables you to provide detailed process documentation, remove any key person risk, and transition away from ‘unwritten rules’ in data processing.
www.abdataconsulting.com/
Alteryx Weekly Challenges is a video series produced by AB Data Consulting for educational purposes and for use by anyone interested in learning Alteryx. To request additional tool videos, email videos@abdataconsulting.com.
มุมมอง: 1 457

วีดีโอ

Alteryx Weekly Challenge #264 - AB Data Consulting
มุมมอง 9443 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #264! Everyone loves a good invoice! There’s just something about seeing the amount you paid for each item and finding that everything is as it should be, adding up to the total amount. And for the most part invoices are created by automated processes which reduce the chance o...
Weekly Challenge #259​: Disenvowel - AB Data Consulting
มุมมอง 2543 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu​​ Join us while we build our solution for Alteryx Weekly Challenge #259​​! community.alteryx.com/t5/Weekly-Challenge/Challenge-259-Disenvowel/td-p/733763 In this challenge we need to create a workflow to remove vowels from text, excluding vowels that are the first letter in a word. Y is included as a vowel for this challenge... What is Alte...
Weekly Challenge #257: Palindromes
มุมมอง 2793 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu​ Join us while we build our solution for Alteryx Weekly Challenge #257​! Palindromes are words that are spelled the same backwards as forwards. They aren't inherently better than other words, but they have a special name and we think that counts for something! Speaking of counting... For this week's challenge, count the number of palindrome...
Alteryx Weekly Challenge #256 - AB Data Consulting
มุมมอง 6443 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #256! Did you know that professional golf tournaments start on Thursday and last through Sunday. The players compete on the first two days and only the players with the best scores are allowed to finish the tournament. This is referred to as "making the cut" and it comes with ...
Alteryx Weekly Challenge #249 - AB Data Consulting
มุมมอง 6283 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #249! Have you ever reviewed a test and marked the wrong answer, only to realize that you overlooked the correct answer when evaluating your options? Humans are fairly unreliable when reading in data, especially when it isn't in a friendly format. Computers on the other hand.....
Alteryx Weekly Challenge #248 - AB Data Consulting
มุมมอง 3923 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Weekly Challenge #248 - Holi-dates can be found at the following link. community.alteryx.com/t5/Weekly-Challenge/Challenge-248-Holidates/td-p/685824 Looking to the new year (2021), we want to produce a log for our staff showing workdays for the upcoming year. 2 employees follow the US holiday schedule and 1 employee follows the Australian (...
Alteryx Weekly Challenge #243 - AB Data Consulting
มุมมอง 2753 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #243! In general, there are slightly more men than women in the world. According to the United Nations, the number of men is rising gradually each year since 1960. However, some statistics show this is not the case in certain countries. In former Soviet republics, for example,...
Alteryx Weekly Challenge #242 - AB Data Consulting
มุมมอง 2433 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #242! This week's challenge is to find the most central office location to meet up, given a list of cities in which Alteryx has offices. The dataset contains the City, Region, and coordinates of the cities. Your task is to determine the city that is most central for each regio...
Alteryx Weekly Challenge #241 - AB Data Consulting
มุมมอง 2193 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #241! There is no escape! This Friday will be another Friday the 13th. Whether or not you consider yourself to be superstitious, odds are you're familiar with this dreaded calendar configuration. But just how common are these occurrences? For this week's challenge, construct a...
Alteryx Weekly Challenge #240 - AB Data Consulting
มุมมอง 2173 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #240! What’s your favorite flavor of ice cream? Hard to choose just one? With ranked choice voting (RCV), you don’t have to! With RCV, you can rank your favorites in order of choice. For this week’s challenge, we have the results of a Favorite Flavors of Ice Cream poll. Build ...
Alteryx Weekly Challenge #239 - AB Data Consulting
มุมมอง 2103 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #239! For this week's challenge, we will use Designer to solve/prove a classic verbal arithmetic problem. In this case, each letter in the equation "SEND MORE = MONEY" will have a unique value between 0 and 9. Your job is to find the solution that makes the equation true. comm...
Alteryx Weekly Challenge #238 - AB Data Consulting
มุมมอง 2533 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #238! The Ideal Gas law is a staple of Chemistry classes around the world. You may recall that it is defined as PV=nRT; where P = pressure, V = volume, n = the number of moles, R = the ideal gas constant, and T = temperature. This week's challenge is to create an app that requ...
Alteryx Weekly Challenge #237 - AB Data Consulting
มุมมอง 1173 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #237! The Wareki is a Japanese date format which includes an extra character to signify the era. The eras indicate the emperor at the time and they impact the year only. For example, H04/01/31 represents the 4th year of Heisei era, but the 01/31 is in fact January 31st of that...
Alteryx Weekly Challenge #236 - AB Data Consulting
มุมมอง 1893 ปีที่แล้ว
Download a Free Trial of Alteryx! tinyurl.com/y5alktlu Join us while we build our solution for Alteryx Weekly Challenge #236! For this week's challenge, you are the skipper of a large container ship destined for Belfast harbour. You must navigate through the exact centre of the navigation channel due to the large draft of your ship. The origin - current position of your ship, the destination an...
Alteryx Weekly Challenge #234 - AB Data Consulting
มุมมอง 1773 ปีที่แล้ว
Alteryx Weekly Challenge #234 - AB Data Consulting
Alteryx Weekly Challenge #233 - AB Data Consulting
มุมมอง 1333 ปีที่แล้ว
Alteryx Weekly Challenge #233 - AB Data Consulting
Alteryx Weekly Challenge #231 - AB Data Consulting
มุมมอง 1333 ปีที่แล้ว
Alteryx Weekly Challenge #231 - AB Data Consulting
Alteryx Weekly Challenge #230 - AB Data Consulting
มุมมอง 2183 ปีที่แล้ว
Alteryx Weekly Challenge #230 - AB Data Consulting
Alteryx Weekly Challenge #229 - AB Data Consulting
มุมมอง 3723 ปีที่แล้ว
Alteryx Weekly Challenge #229 - AB Data Consulting
Alteryx Weekly Challenge #228 - AB Data Consulting
มุมมอง 1633 ปีที่แล้ว
Alteryx Weekly Challenge #228 - AB Data Consulting
Alteryx Weekly Challenge #226 - AB Data Consulting
มุมมอง 2473 ปีที่แล้ว
Alteryx Weekly Challenge #226 - AB Data Consulting
Alteryx Weekly Challenge #225 - AB Data Consulting
มุมมอง 2374 ปีที่แล้ว
Alteryx Weekly Challenge #225 - AB Data Consulting
Alteryx Weekly Challenge #224 - AB Data Consulting
มุมมอง 1234 ปีที่แล้ว
Alteryx Weekly Challenge #224 - AB Data Consulting
Alteryx Weekly Challenge #223 - AB Data Consulting
มุมมอง 1594 ปีที่แล้ว
Alteryx Weekly Challenge #223 - AB Data Consulting
Alteryx Find Nearest Tool Demonstration
มุมมอง 2.9K4 ปีที่แล้ว
Alteryx Find Nearest Tool Demonstration
Alteryx Spatial Match Tool Demonstration
มุมมอง 2.1K4 ปีที่แล้ว
Alteryx Spatial Match Tool Demonstration
Alteryx Spatial Info Tool Demonstration
มุมมอง 8794 ปีที่แล้ว
Alteryx Spatial Info Tool Demonstration
Alteryx Weekly Challenge #222 - AB Data Consulting
มุมมอง 2734 ปีที่แล้ว
Alteryx Weekly Challenge #222 - AB Data Consulting
Alteryx Weekly Challenge #221 - AB Data Consulting
มุมมอง 1374 ปีที่แล้ว
Alteryx Weekly Challenge #221 - AB Data Consulting

ความคิดเห็น

  • @wojtekw6040
    @wojtekw6040 5 หลายเดือนก่อน

    Is there a way to populate a custom docx file with data from few table tools ?

  • @milthorcasco8992
    @milthorcasco8992 10 หลายเดือนก่อน

    Great video! Super clear. Thanks

  • @ChrisVallance
    @ChrisVallance 11 หลายเดือนก่อน

    You changed the "Num Rows" from 1 to 5, but you didn't explain why. I'm not sure what that option is doing, or why you changed it to 5 in that one example...

    • @abdataconsulting7729
      @abdataconsulting7729 11 หลายเดือนก่อน

      Hi @ChrisVallance - I believe it was set to 5 so that you can see that you are not limited to only looking up/down 1 or 2 rows at a time.

  • @K2SCAMBAIT
    @K2SCAMBAIT ปีที่แล้ว

    Is your website down and are your services active

  • @ryansodhi1815
    @ryansodhi1815 ปีที่แล้ว

    Thank you

  • @sushkak
    @sushkak ปีที่แล้ว

    can you explain one more time this challenge clearly....please

  • @ryansodhi1815
    @ryansodhi1815 ปีที่แล้ว

    Hi, if I want to present 2 table tools data in same sheet horizontally & Other table tools data in separate sheet, how to do that?

  • @faisalmalik2549
    @faisalmalik2549 ปีที่แล้ว

    Great example thank you

  • @jamesparry7089
    @jamesparry7089 ปีที่แล้ว

    Awesome tutorial guys! Thank You!

  • @amgdhussein7040
    @amgdhussein7040 2 ปีที่แล้ว

    Anyway we can render file with 4 sheets into multiple file, each with 4 sheet grouped/filtered by department?

  • @suzhou1704
    @suzhou1704 2 ปีที่แล้ว

    So few likes? Such great video!

  • @faisalmalik2549
    @faisalmalik2549 2 ปีที่แล้ว

    from where I can have these example that you shown to us

    • @paramjassingh7851
      @paramjassingh7851 ปีที่แล้ว

      You can find the tool in the parse section and then click open example to take a look at the examples they are showing!

  • @bainbz77
    @bainbz77 2 ปีที่แล้ว

    how can you add subtotals and a grand total for each group?

  • @amanchiskitchen
    @amanchiskitchen 2 ปีที่แล้ว

    please provide data sources for all challenges

  • @saylidaga
    @saylidaga 2 ปีที่แล้ว

    If i want to have a new column that will simply merge two columns (what the '&' function does in excel) then what formula can I use?

  • @priyadsouza5990
    @priyadsouza5990 2 ปีที่แล้ว

    Would you be able to advise , if I had to delete multiple columns if the column had text e.g Time on row no 3

  • @dheeraj787
    @dheeraj787 2 ปีที่แล้ว

    Thanks for the video but the Two different voices are very annoying and confusing.

  • @lakshmiven2600
    @lakshmiven2600 2 ปีที่แล้ว

    The video doesn’t provide any insight on how the row generation happen.it just repeats the steps from the Alteryx example guide

  • @pgplanas
    @pgplanas 2 ปีที่แล้ว

    Thank you so much! This one was a life saver... Had been looking for ages the way to format Excel spreadsheets, and this video was spot on!

  • @SD-eu7ht
    @SD-eu7ht 2 ปีที่แล้ว

    Love your videos and thanks for the clarity. It would be great if your videos had a hint of the topic covered. It would make it easier to find what we are mostly interested in

  • @skybee4212
    @skybee4212 2 ปีที่แล้ว

    If we use multiple group by function only, it will work similar to unique tool?

  • @blighali7468
    @blighali7468 3 ปีที่แล้ว

    A great way my teacher I have a project about it

  • @mariabeltzer9312
    @mariabeltzer9312 3 ปีที่แล้ว

    Super helpful!! Thank you so much.

  • @earthlogo7088
    @earthlogo7088 3 ปีที่แล้ว

    I have a column example type that includ to many rows with information like ( burger, Pizza, Salad, Soup, Side ,Drink ) if I need to recatogrize in you column and will name it Meal type and it should show Food for Pizza & purger , Other for salad & Soup, Drink , side

  • @mwendabaimwendabai4923
    @mwendabaimwendabai4923 3 ปีที่แล้ว

    This is exactly what I am looking for. Can you add a dynamic table to each one of the snippets? And is there any way to limit the information based on viewer? So in your example, say Colorado folks only need to see whats important to them? Lastly, how can you make this report visible? Can you pass it through to a visualization e.g. Qlik?

  • @roes5654
    @roes5654 3 ปีที่แล้ว

    Thank you!

  • @lakshmiven2600
    @lakshmiven2600 3 ปีที่แล้ว

    Is there a way to publish the output tables in the same tab of the excel with some extra spacing in between the tables.Thanks !

    • @abdataconsulting7729
      @abdataconsulting7729 3 ปีที่แล้ว

      Yes, instead of using "vertical with section breaks' as the orientation in your layout tool, you can just use 'vertical'.

    • @ryansodhi1815
      @ryansodhi1815 ปีที่แล้ว

      @@abdataconsulting7729 hi Ab, I have a query, regarding the table tool. Is it possible that I can highlight only a specific cell instead of rows which has a value greater than 10 or something?

    • @abdataconsulting7729
      @abdataconsulting7729 ปีที่แล้ว

      @@ryansodhi1815 Yes, do you have a bit more specific of an ask or example? We can guide you through it or you may want to post on the Alteryx community where someone will be able to answer relatively quickly. Thanks!

  • @emilywahkahquah6132
    @emilywahkahquah6132 3 ปีที่แล้ว

    Can you share the workflow?

  • @Laxmanmane007
    @Laxmanmane007 3 ปีที่แล้ว

    👍👍

  • @Laxmanmane007
    @Laxmanmane007 3 ปีที่แล้ว

    👍

  • @abdataconsulting7729
    @abdataconsulting7729 3 ปีที่แล้ว

    Yes! We upload videos weekly. Subscribe to our channel so you can get notifications of when we upload. Thanks!

  • @Laxmanmane007
    @Laxmanmane007 3 ปีที่แล้ว

    Coudl you please upload more videos on Alteryx

  • @elishmuel1976
    @elishmuel1976 3 ปีที่แล้ว

    you guys are awesome. great work for newbies jumping in and needing to know quick, concise info. Looking forward to your more advanced vids!

    • @abdataconsulting7729
      @abdataconsulting7729 3 ปีที่แล้ว

      Thanks Michael! Are there any topics in particular that interest you?

  • @Laxmanmane007
    @Laxmanmane007 3 ปีที่แล้ว

    Thanks 👍

  • @Laxmanmane007
    @Laxmanmane007 3 ปีที่แล้ว

    👍

  • @Laxmanmane007
    @Laxmanmane007 3 ปีที่แล้ว

    Thank you ❤️

  • @Laxmanmane007
    @Laxmanmane007 3 ปีที่แล้ว

    Thanks for valuables video on Alteryx ❤️

  • @abdataconsulting7729
    @abdataconsulting7729 3 ปีที่แล้ว

    You can ask a question at community.alteryx.com/t5/Alteryx-Designer-Discussions/bd-p/designer-discussions

  • @NaveenKumar-wb9yy
    @NaveenKumar-wb9yy 3 ปีที่แล้ว

    I have a workflow and need assistance in filtering multiple selection. Let me know how to share

  • @emilio6117
    @emilio6117 4 ปีที่แล้ว

    Wonderful explanation!

  • @emilio6117
    @emilio6117 4 ปีที่แล้ว

    I appreciate your hep!!

  • @brenrzr
    @brenrzr 4 ปีที่แล้ว

    Thank you for your explanation. This tool is very useful for creating fast and automatic values "bucketing" instead of building multiple IF clauses, isn't it?

    • @abdataconsulting7729
      @abdataconsulting7729 4 ปีที่แล้ว

      You got it. It can dynamically create buckets whereas multiple IF statements are very rigid.

  • @manojjagwani8502
    @manojjagwani8502 4 ปีที่แล้ว

    Nice and informative video Could you please send this spatial object workout for my reference

  • @abdataconsulting7729
    @abdataconsulting7729 4 ปีที่แล้ว

    th-cam.com/video/g6eBmQDVzaM/w-d-xo.html you'll want to use the summarize tool

  • @avlenderyadav9796
    @avlenderyadav9796 4 ปีที่แล้ว

    Can you please demonstrate the "Sumifs" (multiple condition Sum) in Alteryx, Like we need to calculate the persons performance, so I need the performance data (Total by name and Total by Date, weekly or monthly). If you have any link of some video with solution, please share.

  • @jikkujosephmathew2928
    @jikkujosephmathew2928 4 ปีที่แล้ว

    How to remove weekends and Holidays in between the selected period?

  • @blakeehutch
    @blakeehutch 4 ปีที่แล้ว

    You can use the select tool to rename individual fields. See this video for a walkthrough of the select tool th-cam.com/video/7oROQ_tQcP8/w-d-xo.html

  • @davidlopez-fe2lb
    @davidlopez-fe2lb 4 ปีที่แล้ว

    If I wanted to change the name of field "Address" to "Home" how would I do that?

  • @gauravarora6611
    @gauravarora6611 4 ปีที่แล้ว

    Can you please do alteryx weekly challenge 180 I am not sure about macros