Data Extraction with SQL
Structured Query Language (SQL) is the standard for interacting with relational databases. This section provides an interactive way to understand how basic SQL queries are constructed to ask questions of your data.
Interactive SQL Query Builder
Click the buttons in order to see how a query is built. Each clause adds a new layer of specificity to your data request.
Data Integration
Analysis rarely relies on a single source of truth. Data integration is the process of combining data from different sources—such as internal databases and external market data—to create a richer, more contextualized view for decision-making.
Example: Financial Analysis Integration
Internal Financials
(e.g., Sales Database)
External Market Data
(e.g., Bloomberg, Yahoo Finance)
Integrated Analysis
Compare company performance against industry peers, interest rates, and other economic indicators.
Visualizing Processes & Data Flow
To understand how a business works, we visualize its processes. This section explores two standard methods: BPMN for modeling business activities and Data Flow Diagrams (DFDs) for tracking how data moves through a system. Click on the symbols to learn their meaning.
BPMN: Business Process Model and Notation
BPMN is a standardized flowchart method that models the steps of a business process from end to end. Interact with the symbols below to see their function.
Click a symbol above
The description will appear here.
Data Flow Diagrams (DFD)
DFDs offer a granular view of how data moves through a process or system. They have fewer symbols than BPMN but focus specifically on the data's journey.
Click a symbol above
The description will appear here.
