Module 3: Foundational Data Science + Analytics
Overview
After completing this module, you will be able to use the Data Manager and Flow Builder in LOGIBLOX with ease. You'll learn data preparation techniques, workflow automation, and advanced analytics to extract business insights from real-world supply chain data.
This module is structured into three progressive sections:
- Data Preparation and Massaging - Master the basics of importing, viewing, and manipulating datasets
- Data Workflow and Automation - Learn to build automated data pipelines using Flow BLOX
- Data Analytics and Exploration - Create informative visualizations and perform advanced analysis
What You'll Learn
Data Manager Skills
- Work with LOGIBLOX Data Manager
- Load and import datasets
- View and explore data
- Understand data relationships
Flow Builder Skills
- Work independently with Flow Builder
- Join and merge datasets
- Split and filter data
- Aggregate and sum operations
- Create data visualizations
- Build automated workflows
Mission Structure
Missions are hands-on exercises using real business transaction data to build practical data science skills.
1. Data Preparation and Massaging
- Mission 1: Import and Study Training Data
- Mission 2: Build Your First Flow and Create a Selective View
- Mission 3: Split Columns and Store Results
- Mission 4: Filter and Retrieve Supplier Names
- Mission 5: Create Flow Versions
2. Data Workflow and Automation
- Mission 6: Concatenate Reference Tables
- Mission 7: Filter Unnecessary Records
- Mission 8: Automate Your Flows
3. Data Analytics and Exploration
- Mission 9: Aggregate Data and Create Bar Charts
- Mission 10: Create Pie Charts Using Data Operations
- Mission 11: Apply Statistical Operations
Datasets Used
Download the required datasets for this module:
- business_transaction.xlsx - Main transaction data
- lookup_category01.xlsx - Category reference table 1
- lookup_category02.xlsx - Category reference table 2
- lookup_category03_new.xlsx - Category reference table 3
- lookup_category04.xlsx - Category reference table 4
- lookup_supplier.xlsx - Supplier reference table
Understanding the Data
Business Transaction Table
The business_transaction table contains raw ERP data transactions with references to suppliers and commodity groups by ID.
Sample Data:
| Document Number | Document Date | Supplier ID | Category | Posting Date | Account | Cost Centre | Amount |
|---|---|---|---|---|---|---|---|
| 49112921 | 5/4/2021 | 83500207 | Expenses Proj. 1B | 5/3/2021 | 4383 | Branch: New Scott | 44 CHF |
| 63028710 | 8/16/2021 | 81007530 | Expenses Proj. 1B | 8/23/2021 | 1898 | Branch: South Rebecca | 132 CHF |
| 49114865 | 8/31/2021 | 81001008 | Expenses Proj. 1B | 9/5/2021 | 6265 | Branch: Angelaborough | 1003 CHF |
Key Characteristics:
- Contains supplier and category IDs (not names)
- Includes formatting and content errors to be resolved
- Hierarchical category structure (Level 1-4)
- Department information (Operations, Finance, Real Estate, Retail)
Reference Tables
The five lookup tables (lookup1-4 and lookup_suppliers) provide:
- Mapping of supplier IDs to supplier names
- Mapping of category IDs to category names
- Hierarchical category relationships (Level 1 = highest, Level 4 = lowest)
Learning Path
This module builds upon the data management and AI skills from previous modules. The missions are designed to be completed sequentially, with each building on the previous one.
By the end of this module, you'll be proficient in:
✓ Importing and managing datasets
✓ Building data transformation Flows
✓ Joining and merging multiple data sources
✓ Filtering and cleaning data
✓ Creating automated workflows
✓ Performing statistical analysis
✓ Building visualizations (bar charts, pie charts)
✓ Conducting ABC and XYZ analysis
Ready to begin? Start with Business Scenario to understand the context, then proceed to Mission 1!