Data Glossary Lab

Apache Airflow is a platform to programmatically author, schedule, and monitor workflows; it is not simply a task scheduler. While Cron allows you to run scripts at specific times, Airflow allows you to define complex dependencies between them. It transforms isolated scripts and fragile batch jobs into a resilient, code-based ecosystem.

Microsoft Azure is a cloud computing platform and infrastructure service provided by Microsoft. It offers a vast array of integrated services, including Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS) ,enabling organizations to build, deploy, and manage applications through Microsoft’s global network of data centers.

Market Basket Analysis (MBA) is a data mining technique used to uncover relationships between items. While standard sales analysis might list top-selling products by volume, MBA groups them by association. It answers the question: "If a customer buys Product A, how likely are they to buy Product B?" By analyzing transaction sets, MBA transforms raw receipt data into actionable merchandising insights. It evaluates three key metrics: Support (how frequently items appear in the data), Confidence (the conditional probability that buying item X leads to buying item Y), and Lift (the strength of the association compared to random chance). Instead of viewing a shopping cart as a random collection of goods, MBA reveals hidden patterns, identifying "Complementary Goods," "Substitute Items," or "Anchor Products," allowing a business to optimize layouts and cross-selling strategies.

The Pareto Principle, commonly known as the 80/20 Rule, is a statistical concept stating that roughly 80% of consequences come from 20% of the causes. While standard reporting might view all data points as having equal weight, Pareto Analysis recognizes an unequal distribution of impact. It answers the question: "Which minority of inputs is driving the majority of my outputs?" By sorting data by frequency or impact, it separates the "Vital Few" (the small percentage of elements that create the most value or damage) from the "Trivial Many" (the large percentage of elements that have minimal impact). In Data Science, this is crucial for feature selection, identifying that a small subset of variables often holds the most predictive power in a model.

BI Interactive Dashboards are advanced data visualization tools that provide a centralized, real-time view of Key Performance Indicators (KPIs) and business metrics. Interactive dashboards allow users to manipulate, filter, and drill down into datasets to uncover hidden insights and trends, facilitating data-driven decision making across an organization.

Power BI is a unified business intelligence ecosystem, not just a visualization tool. While Excel allows you to organize data, Power BI allows you to experience it. It transforms isolated spreadsheets and disparate databases into a cohesive, immersive narrative. The core difference is connectivity and scale. In a traditional setup, data lives in silos,trapped in SQL servers, CRMs, or local files. In Power BI, these sources are fused into a single Semantic Model. The interface serves as a bridge between raw numbers and human insight, allowing users to aggregate millions of rows from different sources and visualize them instantly. It solves the "version of truth" problem. Instead of emailing five different spreadsheet versions with conflicting numbers, Power BI offers a single, cloud-based destination that updates automatically. It is intelligence through integration.

RFM (Recency, Frequency, Monetary) is a behavioral segmentation technique used to analyze customer value. While standard analysis might group customers by age or location, RFM groups them by actual purchasing behavior. It answers the question: "Who are your best customers, and who are you about to lose?" By analyzing transaction history, RFM transforms raw data into actionable customer personas. It evaluates three key metrics: Recency (how closely to the present a customer made a purchase), Frequency (how often they transact), and Monetary Value (how much they spend). Instead of viewing a customer base as a monolith, RFM creates dynamic clusters, identifying “VIP”, “Needing”,  "Champions," "Hibernating" users, or "New Potential", allowing a business to treat different segments with distinct strategies.

Cloud Computing is the on-demand delivery of computing power, database storage, applications, and other IT resources via the internet with pay as you go pricing.

Tableau is a visual analytics platform, not just a reporting tool. While Excel allows you to record data, Tableau allows you to see and understand it. It transforms static tables and rigid reports into an interactive, exploratory canvas. The core difference is the philosophy of "flow." In a traditional setup, analysis is a linear, stop-and-start process of querying databases and formatting charts. In Tableau, these actions happen simultaneously. The interface serves as a direct extension of the user’s thought process, allowing them to drag, drop, and pivot data to answer questions as fast as they can think of them. It solves the "insight gap." Instead of waiting for IT to generate a static report, Tableau empowers business users to connect to live data, blend sources, and discover trends on their own. It is intelligence through visualization.