🔵 Part 4: User Experience & Tools

Here is progressive video learning path to understand how to use D4E.


🟢 Part 1: Introduction & Core Concepts

Introducing D4E (Data Mart for Excel) Standard Edition - 6:32 mins 
Two-Tier Collaboration of SQL Developer and Business User - 6:18 mins
JDBC and ODBC Example Side-by-Side - 6:37 mins
Running Your First SQL Tutorials - Invoices vs Payments Flash Report (XLSM packaged demo) - 13.53 mins

🟡 Part 2: Parameters & Placeholders

Parameter Prompts - 3:53 mins
File-based Parameters - 2:15 mins
Store and Manage SQL Codes - 2:21 mins 
Complex SQL - 5:22 mins
Encoded Passwords - 4:15 mins

🟠 Part 3: Automation & Productivity

Scheduling - 3:19 mins
Macro Recording and Execution - 4:18 mins
Use with Servers and Devices - 4:24 mins
Update Databases - 2:07 mins
Create Mini App - 5:09 mins

🔵 Part 4: User Experience & Tools

Excel Ribbons - 2:04 mins
Run SQLs from Command Bar Menu - 2:23 mins
Excel Task Pane - 1:59 mins
Extensive Logging - 2:07 mins
Windows Security - 1:24 mins
Compiled COM DLL - 1:24 mins

🟣 Part 5: AI & Advanced Features

Introducing the Built-in D4E AI Agent - 4:02 mins
Plain English to Clickable SQL Apps with AI and D4E - 7:22 mins

Plain English to Excel Action (using on-the-fly VBA) -15:35 mins
Plain English to Access REST API Data Sources (like SAP or Salesforce) - 9:48 mins 

Plain English to Deliver Flash Reports to iPhone - 5:50 mins  

Plain English to Solve eSports Excel Problem - 25:21 mins

Plain English to Solve MEWC Connect 4 - 5:20 mins



⚫ Part 6: Platform Integrations

D4ESQL Excel Formula Function - 7:11 mins
Office JS Add-in - 6:16 mins
Google Sheets™ Add-on - 7:22 mins



🟡 Part 2: Parameters & Placeholders

🟠 Part 3: Automation & Productivity

HOW TO USE D4E APPS (WITH VIDEO LINKS)

Watch the videos here:


🟢 Part 1: Introduction & Core Concepts

🟣 Part 5: AI & Advanced Features

⚫ Part 6: Platform Integrations