# Challenges **URL:** https://www.techhub.training/c/challenges/5.md [Latest](https://www.techhub.training/latest.md) · [Categories](https://www.techhub.training/categories.md) · [Tags](https://www.techhub.training/tags.md) --- ## [Guidelines for Posting Solutions to Challenges](https://www.techhub.training/t/guidelines-for-posting-solutions-to-challenges/10)
**Author:** [@David\_Wood](https://www.techhub.training/u/David_Wood)\ **Replies:** 0\ **Last updated:** [October 5, 2022, 11:07pm UTC](https://www.techhub.training/t/guidelines-for-posting-solutions-to-challenges/10 "2022-10-05T23:07:39Z")
Challenges cover many technologies and vary in difficulty. Return to the website frequently or follow the TechHub.training LinkedIn webpage to be alerted when we post new challenges We encourage you to post solutions to… --- ## [255|PYTHON – RAG](https://www.techhub.training/t/255-python-rag/4880)
**Author:** [@Kiya\_Smith](https://www.techhub.training/u/Kiya_Smith)\ **Replies:** 0\ **Last updated:** [April 23, 2025, 12:50am UTC](https://www.techhub.training/t/255-python-rag/4880 "2025-04-23T00:50:20Z")
BYU Student Author: @Kiya\_Smith Reviewers: @Keanu\_Gauthier, @James\_Behling Estimated Time to Solve: 2.5 hours We provide the solution to this challenge using: Excel Python ChatGPT Need a program? Click here. Overv… --- ## [269|ALTERYX – Access Termination Control](https://www.techhub.training/t/269-alteryx-access-termination-control/4853)
**Author:** [@Kiya\_Smith](https://www.techhub.training/u/Kiya_Smith)\ **Replies:** 1\ **Last updated:** [April 1, 2026, 10:09pm UTC](https://www.techhub.training/t/269-alteryx-access-termination-control/4853 "2026-04-01T22:09:01Z")
BYU Student Author: @Kiya\_Smith Reviewers: @James\_Behling, @Jason\_Nguyen Estimated Time to Solve: 40 Minutes We provide the solution to this challenge using: Excel and ChatGPT Alteryx Need a program? Click here. O… --- ## [268|EXCEL – Sales Stats Showcase](https://www.techhub.training/t/268-excel-sales-stats-showcase/4852)
**Author:** [@Kylie\_Larsen17](https://www.techhub.training/u/Kylie_Larsen17)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 11:07pm UTC](https://www.techhub.training/t/268-excel-sales-stats-showcase/4852 "2025-04-17T23:07:43Z")
BYU Student Author: @Kylie\_Larsen17 Reviewers: @Abraham\_Reyes\_Leon, @Keanu\_Gauthier Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Excel Need a program? Click here. Overview A… --- ## [267|POWERAUTOMATE – Focused Email Box](https://www.techhub.training/t/267-powerautomate-focused-email-box/4851)
**Author:** [@Kaden\_Sandberg](https://www.techhub.training/u/Kaden_Sandberg)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 10:57pm UTC](https://www.techhub.training/t/267-powerautomate-focused-email-box/4851 "2025-04-17T22:57:55Z")
BYU Student Author: @Kaden\_Sandberg Reviewers: @Kiya\_Smith @Jason\_Nguyen Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Power Automate Need a program? Click here. Overview Yo… --- ## [266|POWERBI – Employee Performance Tracker](https://www.techhub.training/t/266-powerbi-employee-performance-tracker/4850)
**Author:** [@Saul\_Esplin](https://www.techhub.training/u/Saul_Esplin)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 10:46pm UTC](https://www.techhub.training/t/266-powerbi-employee-performance-tracker/4850 "2025-04-17T22:46:18Z")
BYU Student Author: @Saul\_Esplin Reviewers: @James\_Behling, @Michael\_Barney Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: PowerBI Need a program? Click here. Overview You ar… --- ## [200|PYTHON – NBA Expansion Draft](https://www.techhub.training/t/200-python-nba-expansion-draft/4849)
**Author:** [@Abraham\_Reyes\_Leon](https://www.techhub.training/u/Abraham_Reyes_Leon)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 10:31pm UTC](https://www.techhub.training/t/200-python-nba-expansion-draft/4849 "2025-04-17T22:31:46Z")
BYU Student Author: @Abraham\_Reyes\_Leon, @Carter\_Lee Reviewers: @James\_Behling, @Keanu\_Gauthier, @Dallin\_Gardner, @Benjamin\_Lau Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Pa… --- ## [265|POWERAUTOMATE – Basic Company Survey Bot](https://www.techhub.training/t/265-powerautomate-basic-company-survey-bot/4848)
**Author:** [@James\_Behling](https://www.techhub.training/u/James_Behling)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 10:09pm UTC](https://www.techhub.training/t/265-powerautomate-basic-company-survey-bot/4848 "2025-04-17T22:09:38Z")
BYU Student Author: @James\_Behling Reviewers: @Kaden\_Sandberg Estimated Time to Solve: 45 Minutes We provide the solution to this challenge using: Microsoft Forms Power Automate Need a program? Click here. Overvie… --- ## [258|CHATGPT – Orion Tech Solutions](https://www.techhub.training/t/258-chatgpt-orion-tech-solutions/4847)
**Author:** [@Michael\_Barney](https://www.techhub.training/u/Michael_Barney)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 9:41pm UTC](https://www.techhub.training/t/258-chatgpt-orion-tech-solutions/4847 "2025-04-17T21:41:00Z")
BYU Student Author: @Michael\_Barney Reviewers: @Saul\_Esplin, @Kiya\_Smith Estimated Time to Solve: 15 Minutes We provide the solution to this challenge using: ChatGPT Need a program? Click here. Overview You are a… --- ## [259|EXCEL – Techware Logistics](https://www.techhub.training/t/259-excel-techware-logistics/4846)
**Author:** [@Michael\_Barney](https://www.techhub.training/u/Michael_Barney)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 9:32pm UTC](https://www.techhub.training/t/259-excel-techware-logistics/4846 "2025-04-17T21:32:04Z")
BYU Student Author: @Michael\_Barney Reviewers: @Kylie\_Larsen17, @Saul\_Esplin Estimated Time to Solve: 40 Minutes We provide the solution to this challenge using: Excel Need a program? Click here. Overview Techwar… --- ## [246|POWERBI – EcomX](https://www.techhub.training/t/246-powerbi-ecomx/4845)
**Author:** [@Michael\_Barney](https://www.techhub.training/u/Michael_Barney)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 9:22pm UTC](https://www.techhub.training/t/246-powerbi-ecomx/4845 "2025-04-17T21:22:55Z")
BYU Student Author: @Michael\_Barney Reviewers: @James\_Behling, @Saul\_Esplin Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Power BI Need a program? Click here. Overview EcomX… --- ## [264|EXCEL&VBA – Purchase Order Creation](https://www.techhub.training/t/264-excel-vba-purchase-order-creation/4844)
**Author:** [@Jason\_Nguyen](https://www.techhub.training/u/Jason_Nguyen)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 4:56pm UTC](https://www.techhub.training/t/264-excel-vba-purchase-order-creation/4844 "2025-04-17T16:56:48Z")
BYU Student Author: @Jason\_Nguyen Reviewers: @Kaden\_Sandberg, @Keanu\_Gauthier Estimated Time to Solve: 60 Minutes We provide the solution to this challenge using: Excel Need a program? Click here. Overview You wo… --- ## [262|EXCEL – First Time Home Buyer](https://www.techhub.training/t/262-excel-first-time-home-buyer/4843)
**Author:** [@Keanu\_Gauthier](https://www.techhub.training/u/Keanu_Gauthier)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 4:38pm UTC](https://www.techhub.training/t/262-excel-first-time-home-buyer/4843 "2025-04-17T16:38:43Z")
BYU Student Author: @Keanu\_Gauthier Reviewers: @Kylie\_Larsen17, @Jason\_Nguyen Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Excel Need a program? Click here. Overview Congra… --- ## [261|EXCEL – Access Termination Control](https://www.techhub.training/t/261-excel-access-termination-control/4842)
**Author:** [@Kiya\_Smith](https://www.techhub.training/u/Kiya_Smith)\ **Replies:** 1\ **Last updated:** [April 27, 2026, 11:08pm UTC](https://www.techhub.training/t/261-excel-access-termination-control/4842 "2026-04-27T23:08:18Z")
BYU Student Author: @Kiya\_Smith Reviewers: @Kylie\_Larsen17 @Abraham\_Reyes\_Leon Estimated Time to Solve: 15 Minutes We provide the solution to this challenge using: Excel ChatGPT Alteryx Need a program? Click here. … --- ## [260|PYTHON – Sales Automation](https://www.techhub.training/t/260-python-sales-automation/4840)
**Author:** [@Jason\_Nguyen](https://www.techhub.training/u/Jason_Nguyen)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 2:34am UTC](https://www.techhub.training/t/260-python-sales-automation/4840 "2025-04-17T02:34:04Z")
BYU Student Author: @Jason\_Nguyen Reviewers: @Kaden\_Sandberg, @Saul\_Esplin Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Python Need a program? Click here. Overview You are … --- ## [256|POWERAUTOMATE – Automating the Bean Counter](https://www.techhub.training/t/256-powerautomate-automating-the-bean-counter/4839)
**Author:** [@Kaden\_Sandberg](https://www.techhub.training/u/Kaden_Sandberg)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 2:11am UTC](https://www.techhub.training/t/256-powerautomate-automating-the-bean-counter/4839 "2025-04-17T02:11:47Z")
BYU Student Author: @Kaden\_Sandberg Reviewers: @Kiya\_Smith, @James\_Behling Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Power Automate Need a program? Click here. Overview … --- ## [13|PYTHON – Transform Your Data!](https://www.techhub.training/t/13-python-transform-your-data/4838)
**Author:** [@Kylie\_Larsen17](https://www.techhub.training/u/Kylie_Larsen17)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 1:46am UTC](https://www.techhub.training/t/13-python-transform-your-data/4838 "2025-04-17T01:46:08Z")
BYU Student Author: @Kylie\_Larsen17 @Klayton Reviewers: @Saul\_Esplin, @Kaden\_Sandberg @Nate, @MitchFrei, @summers Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Excel Python Ne… --- ## [253|ALTERYX – Block Until Done](https://www.techhub.training/t/253-alteryx-block-until-done/4837)
**Author:** [@James\_Behling](https://www.techhub.training/u/James_Behling)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 1:29am UTC](https://www.techhub.training/t/253-alteryx-block-until-done/4837 "2025-04-17T01:29:56Z")
BYU Student Author: @James\_Behling Reviewers: @Abraham\_Reyes\_Leon Estimated Time to Solve: 15 Minutes We provide the solution to this challenge using: Alteryx Need a program? Click here. Overview In this challeng… --- ## [252|ALTERYX – Retail Reveal](https://www.techhub.training/t/252-alteryx-retail-reveal/4836)
**Author:** [@Saul\_Esplin](https://www.techhub.training/u/Saul_Esplin)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 1:10am UTC](https://www.techhub.training/t/252-alteryx-retail-reveal/4836 "2025-04-17T01:10:17Z")
BYU Student Author: @Saul\_Esplin Reviewers: @Michael\_Barney, @Kylie\_Larsen17 Estimated Time to Solve: 45 Minutes We provide the solution to this challenge using: Alteryx Need a program? Click here. Overview You h… --- ## [251|CELONIS – Process Mining](https://www.techhub.training/t/251-celonis-process-mining/4835)
**Author:** [@Jason\_Nguyen](https://www.techhub.training/u/Jason_Nguyen)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 12:53am UTC](https://www.techhub.training/t/251-celonis-process-mining/4835 "2025-04-17T00:53:09Z")
BYU Student Author: @Jason\_Nguyen Reviewers: @Michael\_Barney, @James\_Behling Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Celonis Need a program? Click here. Overview You a… --- ## [250|POWERPOINT – Visual Tax Insights](https://www.techhub.training/t/250-powerpoint-visual-tax-insights/4834)
**Author:** [@Kylie\_Larsen17](https://www.techhub.training/u/Kylie_Larsen17)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 12:33am UTC](https://www.techhub.training/t/250-powerpoint-visual-tax-insights/4834 "2025-04-17T00:33:11Z")
BYU Student Author: @Kylie\_Larsen17 Reviewers: @Saul\_Esplin, @Kiya\_Smith Estimated Time to Solve: 60 Minutes We provide the solution to this challenge using: PowerPoint Excel Need a program? Click here. Overview … --- ## [249|SQL – FoodImports CTE Practice](https://www.techhub.training/t/249-sql-foodimports-cte-practice/4833)
**Author:** [@Kaden\_Sandberg](https://www.techhub.training/u/Kaden_Sandberg)\ **Replies:** 0\ **Last updated:** [April 17, 2025, 12:13am UTC](https://www.techhub.training/t/249-sql-foodimports-cte-practice/4833 "2025-04-17T00:13:00Z")
BYU Student Author: @Kaden\_Sandberg Reviewers: @Abraham\_Reyes\_Leon Estimated Time to Solve: 15 Minutes Need a program? Click here. Overview As an analyst at Global Trade Insights, you’ve just learned about Common Ta… --- ## [248|TABLEAU – S&P 500 Analysis](https://www.techhub.training/t/248-tableau-s-p-500-analysis/4832)
**Author:** [@James\_Behling](https://www.techhub.training/u/James_Behling)\ **Replies:** 0\ **Last updated:** [April 16, 2025, 11:58pm UTC](https://www.techhub.training/t/248-tableau-s-p-500-analysis/4832 "2025-04-16T23:58:03Z")
BYU Student Author: @James\_Behling Reviewers: @Abraham\_Reyes\_Leon, @Jason\_Nguyen Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Excel Tableau Need a program? Click here. Overv… --- ## [247|AI – RAG Model Basics](https://www.techhub.training/t/247-ai-rag-model-basics/4831)
**Author:** [@Kiya\_Smith](https://www.techhub.training/u/Kiya_Smith)\ **Replies:** 0\ **Last updated:** [April 16, 2025, 11:41pm UTC](https://www.techhub.training/t/247-ai-rag-model-basics/4831 "2025-04-16T23:41:53Z")
BYU Student Author: @Kiya\_Smith Reviewers: @ Kylie\_Larsen17 @Kaden\_Sandberg \*Estimated Time to Solve: \*20 Minutes We provide the solution to this challenge using: ChatGPT Need a program? Click here. Overview This… --- ## [245|CHATGPT – Sales Script Switch](https://www.techhub.training/t/245-chatgpt-sales-script-switch/4830)
**Author:** [@Kylie\_Larsen17](https://www.techhub.training/u/Kylie_Larsen17)\ **Replies:** 0\ **Last updated:** [April 16, 2025, 11:15pm UTC](https://www.techhub.training/t/245-chatgpt-sales-script-switch/4830 "2025-04-16T23:15:07Z")
BYU Student Author: @Kylie\_Larsen17 Reviewers: @Keanu\_Gauthier, @Michael\_Barney Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: ChatGPT Excel Python Need a program? Click here. … --- ## [244|CHATGPT – FASB codification expert](https://www.techhub.training/t/244-chatgpt-fasb-codification-expert/4828)
**Author:** [@Keanu\_Gauthier](https://www.techhub.training/u/Keanu_Gauthier)\ **Replies:** 0\ **Last updated:** [April 16, 2025, 4:12am UTC](https://www.techhub.training/t/244-chatgpt-fasb-codification-expert/4828 "2025-04-16T04:12:27Z")
BYU Student Author: @Keanu\_Gauthier Reviewers: @Kylie\_Larsen17 @Kaden\_Sandberg Estimated Time to Solve: 45 Minutes We provide the solution to this challenge using: ChatGPT Need a program? Click here. Overview Are… --- ## [127| PYTHON – P&L Prep](https://www.techhub.training/t/127-python-p-l-prep/4827)
**Author:** [@Keanu\_Gauthier](https://www.techhub.training/u/Keanu_Gauthier)\ **Replies:** 0\ **Last updated:** [April 16, 2025, 3:43am UTC](https://www.techhub.training/t/127-python-p-l-prep/4827 "2025-04-16T03:43:14Z")
BYU Student Author: @Keanu\_Gauthier , @Spencer Reviewers: @Abraham\_Reyes\_Leon, @Jason\_Nguyen Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Excel and VBA Python Need a program?… --- ## [144|PYTHON – Solver](https://www.techhub.training/t/144-python-solver/4826)
**Author:** [@Kiya\_Smith](https://www.techhub.training/u/Kiya_Smith)\ **Replies:** 0\ **Last updated:** [April 16, 2025, 2:29am UTC](https://www.techhub.training/t/144-python-solver/4826 "2025-04-16T02:29:03Z")
BYU Student Author: @Kiya\_Smith @Dallin\_Gardner Reviewers: @Carter\_Lee, @Benjamin\_Lau Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Excel Python Need a program? Click here. O… --- ## [9|PYTHON – Fred’s Fairly Reliable](https://www.techhub.training/t/9-python-fred-s-fairly-reliable/4811)
**Author:** [@Saul\_Esplin](https://www.techhub.training/u/Saul_Esplin)\ **Replies:** 0\ **Last updated:** [April 12, 2025, 4:01am UTC](https://www.techhub.training/t/9-python-fred-s-fairly-reliable/4811 "2025-04-12T04:01:50Z")
BYU Student Author: @Saul\_Esplin, @Brett\_Lowe Reviewers: @Kylie\_Larsen17, @Michael\_Barney, @Mike\_Paulsin, @Christian Estimated Time to Solve: 20 Minutes We provide the solution to this challenge using: Python Excel … --- ## [7|PYTHON – Goliath Cleaning](https://www.techhub.training/t/7-python-goliath-cleaning/4810)
**Author:** [@Christian](https://www.techhub.training/u/Christian)\ **Replies:** 0\ **Last updated:** [April 12, 2025, 3:46am UTC](https://www.techhub.training/t/7-python-goliath-cleaning/4810 "2025-04-12T03:46:02Z")
BYU Student Author: @Christian @Kaden\_Sandberg Reviewers: @Spencer, @Brett\_Lowe, @Boston, @James\_Behling, @Kylie\_Larsen17 Estimated Time to Solve: 30 Minutes We provide the solution to this challenge using: Python G… [Next page](https://www.techhub.training/c/challenges/5.md?page=1)