An intelligent Azure Logic Apps workflow that leverages OpenAI's GPT models to provide automated business insights and analysis from structured business data.
- Automated Business Analysis: Transform raw business data into actionable insights
- Multiple Analysis Types:
- Trend Analysis
- Forecasting
- Executive Summaries
- Strategic Recommendations
- AI-Powered: Utilizes GPT-4 for intelligent analysis
- Serverless Architecture: Built on Azure Logic Apps for scalability
- Secure by Design: API keys stored as secure parameters
- REST API: Easy integration with existing systems
ai-business-insights-workflow/
β
βββ src/
β βββ logic-app.json # Exported Logic App definition
β βββ openai-prompt.txt # Prompt engineering examples
β βββ sample-data.json # Example business data payload
β
βββ docs/
β βββ architecture.md # Detailed architecture documentation
β βββ diagrams/
β βββ workflow.mmd # Mermaid workflow diagram
β
βββ .github/
β βββ workflows/
β βββ ci.yml # Continuous Integration workflow
β
βββ README.md
βββ LICENSE
- Azure subscription with Logic Apps enabled
- OpenAI API account and key
- Basic understanding of REST APIs and JSON
git clone https://github.com/Itsskell/improved-palm-tree.git
cd improved-palm-tree- Open Azure Portal and navigate to Logic Apps
- Create a new Logic App or select an existing one
- Go to "Logic app code view"
- Copy the contents of
src/logic-app.json - Paste into the Logic App designer
- Save the Logic App
Set the following parameters in your Logic App:
openai_api_key: Your OpenAI API key (securely stored)openai_endpoint: OpenAI API endpoint (default: https://api.openai.com/v1/chat/completions)
Send a POST request to your Logic App HTTP trigger URL:
curl -X POST https://your-logic-app-url.com \
-H "Content-Type: application/json" \
-d '{
"businessData": {
"revenue": 125000,
"expenses": 87500,
"customers": 1250,
"period": "Q3 2023"
},
"analysisType": "trend"
}'{
"success": true,
"analysisType": "trend",
"insights": "Based on Q3 2023 data showing $125,000 in revenue with $87,500 in expenses, your business demonstrates a healthy 30% profit margin...",
"timestamp": "2023-10-15T10:30:00Z"
}trend: Identifies patterns and trends in your business dataforecast: Predicts future performance based on historical datasummary: Provides executive-level overview of business performancerecommendation: Offers strategic recommendations for improvement
Use the provided src/sample-data.json for testing:
{
"businessData": {
"revenue": 125000,
"expenses": 87500,
"customers": 1250,
"period": "Q3 2023"
},
"analysisType": "trend"
}- Architecture Overview - Detailed system architecture
- Workflow Diagram - Visual workflow representation
- Prompt Engineering - Examples and best practices
- API keys are stored as secure parameters
- All communication uses HTTPS
- No sensitive data is logged
- Follows Azure security best practices
Run the CI workflow to validate the configuration:
# The CI workflow automatically runs on push and pull requests
# Manual trigger available in GitHub ActionsContributions are welcome! Please feel free to submit a Pull Request.
- Fork the repository
- Create your feature branch (
git checkout -b feature/AmazingFeature) - Commit your changes (
git commit -m 'Add some AmazingFeature') - Push to the branch (
git push origin feature/AmazingFeature) - Open a Pull Request
This project is licensed under the MIT License - see the LICENSE file for details.
Project Link: https://github.com/Itsskell/improved-palm-tree
- Azure Logic Apps for serverless orchestration
- OpenAI for GPT-4 AI capabilities
- The open-source community
Note: This workflow requires an active OpenAI API subscription. API costs apply based on usage.