Data Dilemmas
You receive a dataset containing thousands of transactions from a proposed merger review and load it into your favorite software. Your manager asks you to identify only transactions where the purchase amount exceeds $10,000.
What is a filter?
This practice area evaluates conjoint surveys to evaluate damages in product defect disputes and addresses disputes involving false advertising.
What is Consumer Protection, Product Liability, and Environment?
Also accept: What is CPPLE?
This case was recently in the news after a verdict was reached in April 2026 that found that this ticket sales and distribution and live entertainment company violated federal and state antitrust laws. The Taylor Swift Eras Tour debacle is commonly linked to this case.
What is DOJ v. Ticketmaster/Live Nation?
This is the typical end workproduct in EDI.
What is an Expert Report?
You have some tables in Excel; one table containing Employee ID and Department, and a second table containing Employee ID and Salary. Your manager asks you to add each employee's salary to the first table by matching on Employee ID.
What is XLOOKUP?
Also accept: What is VLOOKUP? / What is INDEX/MATCH?
This practice area works with organizations to evaluate wage and hour compliance issues such as allegations of off-the-clock work or timekeeping issues.
What is Labor and Employment?
This 2020 high profile lawsuit where the creator of Fortnite challenged app store policies, resulted in a ruling that forever changed app store platform fees for the industry.
What is Epic v. Apple?
This is the name of the document where the Expert is required to turn over a list of all sources and data that contributed to their final conclusions.
What is a Materials Considered list?
Your manager sends you transaction-level data in Excel from a proposed antitrust merger and asks for an urgent summary showing total revenue by product category and geographic market.
What is a pivot table?
This practice area applies economics to a wide range of cases including collusion, vertical agreements, and abuses of market power.
What is Antitrust and Competition?
Also accept: What is Antitrust?
This California class action lawsuit was filed against a company’s operating system for consuming users’ cellular data without consent. The jury awarded the class more than $314.6 million.
What is Attila Csupo et al. v. Google?
Every expert report must disclose this information, giving the opposing side insight into the expert's financial relationship with the client.
What is the Expert’s compensation?
Accept: Bill Rate
Your manager asks you to perform the same 12-step process every month on a new production of documents from an investigation: remove blank rows, standardize date formats, flag duplicate records, generate summary statistics, and prepare a reporting table. Rather than manually repeating these steps each time, you want Excel to execute them automatically with a single click.
What is a Macro?
Also accept: What is an Excel Macro / What is a VBA Macro?
This practice area conducts and evaluates survey research for products and services to address issues that include likelihood of confusion, secondary meaning, and dilution.
What is Intellectual Property?
Also accept: What is IP?
This case was a landmark environmental settlement for a specific state’s claims related to PFAS and other contamination from manufacturing sites. This case resulted in a settlement valued at over $2 billion for the State.
What is NJ v. DuPont?
An expert's calculations may be correct, but without this process, a typo in an exhibit or citation could still make its way into a filed report, leading to disastrous consequences for BRG.
What is auditing?
Also accept: What is QC?
You are analyzing two datasets in R/Stata related to a consumer protection matter. One contains customers who submitted complaints, and the other contains customers who requested refunds. You need a single dataset containing all customers from both lists, including those who appear on only one list.
What is a full join?
This practice area specializes in Securities and Exchange Commission, NASDAQ, and New York Stock Exchange market regulation investigations, securities valuation, share price modeling, and commodities trading matters.
What is Securities and Financial Markets?
This case went to the Supreme Court in 2021 and was between two states. The dispute centered on the apportionment of interstate waters within the ACF River Basin following the 2012 collapse of the Apalachicola Bay’s oyster fisheries.
What is the State of Florida v. the State of Georgia?
This watermark must be removed from the Report on the day of filing.
What is “DRAFT”?