Business Events — Trading Data Analysis#
📓 Download Exercise Notebook | Answer Key
Section 1: Fetching and Summarizing#
- Exercise 1.1 — Fetch bizevents and filter on buy/sell events
- Exercise 1.2 — Summarize by "amount" and visualize as single value
- Exercise 1.3 — Summarize amount by account
- Exercise 1.4 — Summarize trading volume by AccountID and EventType
Section 2: Counting Events#
- Exercise 2.1 — Summarize buy and sell events based on count
- Exercise 2.2 — Summarize buy and sell counts over time
Section 3: Trade Analysis#
- Exercise 3.1 — Count number of buy events by accountId
- Exercise 3.2 — Multiply purchase by current stock price ($12) to get total trade amount
- Exercise 3.3 — Identify accounts with highest trade values and count trades over $40
Section 4: JSON Parsing#
- Exercise 4.1 — Identify JSON data and set fields
- Exercise 4.2 — Expand JSON object
- Exercise 4.3 — Pull names and format them
- Exercise 4.4 — Pull names and totals from products
- Exercise 4.5 — Summarize totals by name