Think like an Alteryx Pro - Volume 1

Learn to push Alteryx Designer beyond pivots by fetching remote data and images via URLs, building a lean workflow with under ten tools that outputs an AI art catalog PDF.

Walk through an ai art workflow: download images via the download tool, convert blobs to image report snippets, sort by image number, and render a pdf table of artworks.

Wrap up this lesson by showing how Alteryx uses clever tools to organize Midjourney AI art into a catalog, revealing data management and analysis potential.

Explore how Alteryx Designer reshapes data with parsing and preparation tools, builds conditional calculations in the Formula tool, and refactors workflows for clean, repeatable staffing insights.

Add a record id, reshape with transpose, parse dates, generate daily rows, compute staffing by day of week (Friday 10, Saturday 15, Sunday 5, others 3), reconcile.

Apply data transformation, reshaping, parsing, and calculating techniques in Alteryx to build a staffing plan for each day of the week, illustrating real-world data manipulation.

Analyze four gaming servers' logs to compute total active minutes per server, handle timestamps and regex parsing in Alteryx, avoid double counting overlaps, and optimize server usage.

Convert 12-hour timestamps with am/pm to 24-hour times, create begin and end times, compute minutes elapsed, generate per-minute rows, and summarize distinct timestamps by server to reveal active time mins.

Analyze server logs by parsing, regex, and converting time data; deduplicate and summarize with Alteryx tools. Uncover server usage patterns through time-related analytics.

explore Moneyball and sabermetrics, a data-driven approach to baseball, using an Alteryx workflow to analyze 2000 salary data for the New York Yankees, Oakland Athletics, Philadelphia Phillies, and Pittsburgh Pirates.

Analyze team rosters to identify highest salaries, top paid players, and mean salary by primary position, then compare cost per win for the Yankees and A's in Moneyball economics.

Unpack how raw data and the Moneyball approach reveal insights through cleansing and transforming data, showing the true cost of each win and salary patterns.

Learn to pull data from multiple sources, pivot and reshape it, and map one data set onto another with Alteryx Designer, producing a table of counties by 0% tax rate.

Transpose the dense 27-column data, parse revenue with regex, and blend datasets with joins, filters, and summarizes to identify counties at zero tax rate.

Master data transformation, parsing, blending, and summarization in Alteryx Designer across multiple sources, using tools like transpose, regex, text to columns, and join to produce a clean final dataset.

Use the alteryx designer workflow to decode IRS form 990 and pub 78 ca data, applying dynamic renaming and a data dictionary to identify donor-ready California charities.

Use dynamic rename to convert 990 field codes to readable descriptions, then filter charities by grants to individuals and professional fundraising, and join California data with pub 78 on EIN.

Analyze IRS data to identify a suitable California charity using multiple data sources and a data dictionary. Apply filters, dynamically rename columns, and join datasets to derive insights.

Master data preparation and analysis with Alteryx Designer through a no code data pipeline. Decode the UK charts music quiz and encode insights to reproduce the expected characters.

Analyze a 90s UK charts dataset in Alteryx, filter by date, summarize by artist and song to identify artists and songs, hash results, and reconcile britpop battle Oasis vs Blur.

Explore no code data pipelines to perform data prep and analysis on a UK music chart dataset, reuse and repurpose existing work to speed up insights, and sharpen data skills.

Analyze e-commerce transaction logs with prep and blending tools to identify the gap between first and second purchases and derive customer behavior insights.

Filter out canceled orders, identify customers with multiple purchases, and compute the days between first and second purchases, grouped by month for the average days between orders.

Apply data preparation and transformation techniques to filter cancelled transactions, identify customers with multiple purchases, and compute days between first and second purchases by month and year of first transaction.

Explore geospatial tools in Alteryx to analyze three birds migrating from Europe to Africa using lat/long, speed, and altitude in a CSV dataset to calculate travel distance.

Drop a Create Points tool to convert latitude and longitude into spatial points, then use st_distance between consecutive points and summarize each bird's total distance traveled.

Explore geospatial analysis in Alteryx Designer by calculating each bird's distance traveled during migration, and learn to analyze spatial data across multiple rows with versatile functions.