🚀 ETL Scenarios
Discover powerful automated workflows that transform your data into actionable insights
📤 Portal Upload Pipeline
Upload files through the web portal with automated ETL processing
🎯 How It Works
Upload CSV/Excel files directly through the Smart BI View portal. Azure Data Factory automatically processes your data, transforms it, loads it into your on-premise SQL Server database, and refreshes your Power BI reports in real-time using DirectQuery.
(Flask + Azure App Service)
(customer-uploads)
(ETL Pipeline)
(On-Premise/Azure SQL)
(DirectQuery)
🛠️ Technology Stack
⚡ Real-Time Updates
DirectQuery ensures your reports always show the latest data from SQL Server without manual refresh
🔄 Automated Processing
Data Factory automatically detects new files, extracts customer IDs, and processes data without manual intervention
🔒 Secure & Isolated
Customer ID-based separation ensures each user only sees their own data with row-level security
📦 Scalable Architecture
Handles thousands of files with automatic cleanup and archiving to prevent database bloat
📧 Email-to-Report Pipeline
Send files via email and watch them automatically appear in Power BI
🎯 How It Works
Simply send your data files to support@sbiview.com. Power Automate detects the email, extracts attachments, stores them in SharePoint, updates the Power BI Dataflow, and refreshes your reports—all automatically without any manual steps.
(support@sbiview.com)
(Flow Trigger)
(Document Library)
(Data Processing)
(Auto-Refresh)
🛠️ Technology Stack
📧 Zero-Click Upload
No portal login required—just email your files and they're automatically processed
🤖 Fully Automated
Power Automate handles everything: file extraction, storage, processing, and notification
📂 Centralized Storage
All files stored in SharePoint with version history, audit trail, and collaboration features
🔔 Status Notifications
Receive email confirmations when your file is processed and reports are updated
📝 Survey-to-Dashboard Pipeline
Collect feedback via Microsoft Forms and visualize it instantly
🎯 How It Works
Create surveys using Microsoft Forms to collect customer feedback, employee data, or any structured information. Responses are automatically stored in SharePoint, processed by Power BI, and visualized in real-time dashboards—perfect for live event monitoring, satisfaction tracking, or ongoing research.
(Survey Creation)
(Data Collection)
(Response Storage)
(Scheduled Refresh)
(Live Analytics)
🛠️ Technology Stack
📝 Easy Data Collection
Microsoft Forms provides intuitive survey creation with multiple question types and logic branching
⚡ Real-Time Analytics
See survey results update in your Power BI dashboard as responses come in—perfect for live events
🎨 Interactive Visualizations
Transform raw survey data into beautiful charts, trends, and sentiment analysis automatically
📱 Multi-Channel Access
Respondents can complete surveys on any device, and stakeholders can view results anywhere
Ready to Transform Your Data?
Choose the ETL scenario that fits your workflow and start automating your data pipeline today.
🚀 Get Started Now