Видео 249
Просмотров 10 964

Challenge 224|EXCEL - Bonds, James Bonds

3:32

Challenge 223|EXCEL - Finding Salary Increase

9:27

Challenge 222|PYTHON - Python Financial Wizardry: Automating Financial Analysis for Logee Company

7:31

Challenge 221|TABLEAU - CT EV Volume

3:10

Challenge 220|ALTERYX - Workplace Wellness Wave

6:28

Challenge 219|Tableau - Addy Sales Visualization

7:56

Challenge 225|EXCEL&POWERBI – Managerial Margin Maximization

This video is the solution to Challenge 225 from TechHub.training. It walks through using Excel’s solver capacity and Power BI’s data visualization skills in tandem with one another. This challenge is built to test your CMA (Certified Management Accountant) skills. You have been hired to optimize a company’s product mix to maximize profit between two products that share a raw material input. Using Excel and Power BI, can you optimize this process and make a compelling presentation? You can participate in this challenge at www.techhub.training/t/225-excel-powerbi-managerial-margin-maximization/2712.

Видео

Challenge 224|EXCEL - Bonds, James Bonds

3:32

Challenge 224|EXCEL - Bonds, James Bonds

Просмотров 49 часов назад

This video is the solution to Challenge 224 from TechHub.training. In this video, we go over how to create filterable Pivot Tables and data tables that provide clients with information about their bond portfolio’s maturity. We also introduce the idea of advanced filtering in data tables for you to explore more on your own. You can participate in this challenge at www.techhub.training/t/224-exce...

Challenge 223|EXCEL - Finding Salary Increase

9:27

Challenge 223|EXCEL - Finding Salary Increase

Просмотров 99 часов назад

This video is the solution to Challenge 223 from TechHub.training. Excel is employed to analyze the salary increase between 2 years. This particular challenge focuses on creating analyzing salary summaries. The goal here is to simulate a real-world task. You can participate in this challenge at www.techhub.training/t/223-excel-finding-salary-increase/2708.

Challenge 222|PYTHON - Python Financial Wizardry: Automating Financial Analysis for Logee Company

7:31

Challenge 222|PYTHON - Python Financial Wizardry: Automating Financial Analysis for Logee Company

Просмотров 159 часов назад

This video is the solution to Challenge 222 from TechHub.training. Python and MatlibsPlot are employed to analyze and create a visualization of a CSV file. The goal here is to explore how you can learn how to visual complex data using Python. You can participate in this challenge at www.techhub.training/t/222-python-python-financial-wizardry-automating-financial-analysis-for-logee-company/2707.

3:10

Challenge 221|TABLEAU - CT EV Volume

Просмотров 19 часов назад

This video is the solution to Challenge 221 from TechHub.training. This challenge required you to create a Tableau dashboard with a map of all the electric vehicle chargers in Connecticut. You can participate in this challenge at www.techhub.training/t/221-tableau-ct-ev-volume/2706.

Challenge 220|ALTERYX - Workplace Wellness Wave

6:28

Challenge 220|ALTERYX - Workplace Wellness Wave

Просмотров 19 часов назад

This video is the solution to Challenge 220 from TechHub.training. In this challenge you will get to help HR in deciding which office activities to plan for the upcoming summer. You will use your skills in Alteryx to find answers from survey data. You can participate in this challenge at www.techhub.training/t/220-alteryx-workplace-wellness-wave/2704.

Challenge 219|Tableau - Addy Sales Visualization

7:56

Challenge 219|Tableau - Addy Sales Visualization

Просмотров 39 часов назад

This video is the solution to Challenge 219 from TechHub.training. Tableau are employed to create a visualization clothing companies sales. The goal here is to explore how you can learn how to visual complex data using tableau. You can participate in this challenge at www.techhub.training/t/219-tableau-addy-sales-visualization/2703.

10:04

Challenge 218|PowerBI - Payroll Pain

Просмотров 39 часов назад

This video is the solution to Challenge 218 from TechHub.training. Power BI is used to perform calculations on and audit payroll data for a company. You can participate in this challenge at www.techhub.training/t/218-powerbi-payroll-pain/2702.

Challenge 217|PowerBI - Construction Business Intelligence

6:45

Challenge 217|PowerBI - Construction Business Intelligence

Просмотров 69 часов назад

This video is the solution to Challenge 217 from TechHub.training. Power BI is used to perform calculations raw financial data from an accounting software export. You can participate in this challenge at www.techhub.training/t/217-powerbi-construction-business-intelligence/2701.

10:13

Challenge 216|PYTHON - Inventory Intel

Просмотров 249 часов назад

This video is the solution to Challenge 216from TechHub.training. The video covers data analysis concepts and provides a walkthrough of one of the several ways you can arrive at the solution by giving a line-by-line view of code. You can participate in this challenge at www.techhub.training/t/216-python-inventory-intel/2700.

Challenge 215|EXCEL - Powering Up PowerQuery

13:03

Challenge 215|EXCEL - Powering Up PowerQuery

Просмотров 8821 день назад

This video is the solution to Challenge 215 from TechHub.training. It covers some simple concepts behind data analysis and the importance of preserving source data, then goes through steps for using PowerQuery to arrive at the challenge solution. There is the use of both PowerQuery and PivotTable tools in Excel. You can participate in this challenge at www.techhub.training/t/215-excel-powering-...

Challenge 214|PYTHON&ChatGPT - Accounting Maestro - ChatGPT

9:15

Challenge 214|PYTHON&ChatGPT - Accounting Maestro - ChatGPT

Просмотров 6321 день назад

This video is the solution to Challenge 214 from TechHub.training. Python, Excel, and ChatGPT are employed to create your own personalized accounting dictionary. The goal here is to explore how you can learn accounting with ChatGPT and create an interactive platform with Python. You can participate in this challenge at www.techhub.training/t/214-python-chatgpt-accounting-maestro-chatgpt/2698.

6:45

Challenge 213|ALTERYX - Odd Bits Audit

Просмотров 521 день назад

This video is the solution to Challenge 213 from TechHub.training. This challenge was inspired by real feedback from a professional audit team. In this challenge, you are auditing a repeat client. Using Alteryx, you take their trial balance from last year, along with a list of transactions, and create an updated trial balance that you can then compare to their current trial balance figures to c...

5:11

Challenge 212|EXCEL - Pivot Perfection

Просмотров 2221 день назад

This video is the solution to Challenge 212 from TechHub.training, focusing on Excel XLOOKUP, VLOOKUP, OR, IFERROR formulas, and Pivot Tables. This challenge teaches the student to organize transaction data in a Pivot table to gain insights into expenses over time and in categories. The challenge can be viewed at www.techhub.training/t/212-excel-pivot-perfection/2694.

Challenge 211EXCEL - Car Rental Expense Reporting

21:00

Challenge 211EXCEL - Car Rental Expense Reporting

Просмотров 14021 день назад

This video is the solution to Challenge 211 from TechHub.training. This is an advanced real world challenge of a small accounting firm helping a Car Rental company upgrade their excel workbook. They needed to automate some expense reporting so that they can look at expense by car and by category within a given period. You can participate in this challenge at www.techhub.training/t/211-excel-car...