Seamless migration
Efficient version control
Automated pipelines
Global scalability
Fractal implemented an advanced smart-order solution using R Studio at the store level, designed to support operations across three regions in Pakistan. This solution was then successfully scaled to cover Pakistan, India, and Indonesia, ensuring simultaneous output generation across all regions.
Key challenges
Customizing for regional needs
Adapting the solution across regions
Ensuring timely generation for all regions
The solution
Scalability and integration
Migrated to Databricks for scalability
Integrated parallel pipelines across regions
Used PySpark for SQL Server data extraction
Efficient data management
Centralized storage in Blob
Optimized computing with DBFS
Enabled smooth file handling via DBFS
1
Databricks setup
Migrated to Databricks for cloud execution
Optimized performance and scalability
Configured pipelines for parallel processing across regions
2
Data flow management
Extracted data with PySpark from SQL Server
Stored and ensured consistency in Blob using DBFS
Enabled real-time processing
3
Script automation
Managed child snippets with Master Script
Automated execution with parameters
Simplified code management
Scalability
Facilitated multi-region execution
Moved to production to support scalability
Automated pipelines using Azure Data Factory
Code management
Integrated GitHub for version control
Improved deployment and upgrade efficiency
Optimized team interaction
Data processing
Enabled real-time R execution
Streamlined workflows
Streamlined manual processes
Scalability
Expand to new regions and handle more data
Automation
Boost efficiency with enhanced automation
Optimization
Improve processing speed and real-time analytics