Project Overview

We are a UAE-based company using NetSuite as our ERP and Power BI as our main business intelligence platform. We are seeking a skilled freelancer to:

Connect NetSuite to Power BI and create a robust, optimized data model.
Develop a professional executive dashboard for finance, sales, and operations.
Implement AI capabilities for natural-language querying, automated insights, and predictive analytics.
Deliver knowledge transfer and documentation so our internal team can maintain and expand the solution.
Work closely with the FP&A (Financial Planning & Analysis) team — FP&A will design and define the reporting requirements and dashboard structure, and the freelancer will be responsible for implementing these designs in Power BI.

Scope Of Work

Data Integration
Connect NetSuite Power BI using SuiteAnalytics Connect (OData) or third-party connector (e.g., CData). - Optimize queries for fast refresh performance. - Extract and prepare key datasets such as: - Sales Orders, Invoices, Payments - Items & Product Categories - Customers & Regions - Financial KPIs (Revenue, GP, etc.)
Data Modeling
Build a star-schema data model with proper relationships. - Create calculated columns & DAX measures for: As per business requirements defined by FP&A and management.
Dashboard Development
Design a visually appealing and user-friendly Power BI dashboard with: As per business requirements defined by FP&A and management.
AI & Advanced Analytics
Inside Power BI: - Enable & configure Power BI Copilot (if licensing supports it). - Implement Q&A visual for natural-language querying. - Add Smart Narrative for automated written insights. - Predictive Analytics: - Implement forecasting and anomaly detection in Power BI.

If required, integrate AI Builder, Python Prophet, or Azure Machine Learning for advanced forecasting models. - Optional: - Integrate Azure OpenAI or ChatGPT API for conversational querying of Power BI datasets.

Knowledge Transfer
Provide full documentation covering: - Data connections & refresh setup - Data model & DAX formulas - AI features & predictive models - Conduct a training session for internal users (1–2 hours).

Deliverables

Working NetSuite Power BI live connection.
Optimized Power BI data model with KPIs.
Executive dashboard with AI-powered features.
Predictive analytics capability for sales & finance forecasting.
Documentation & training handover.

Qualifications

Proven track record with NetSuite to Power BI integration. -
Strong DAX and Power Query expertise.
Experience with AI features in Power BI (Copilot, Q&A, Smart Narrative).
Familiarity with predictive analytics (AI Builder, Python Prophet, Azure ML).
Experience integrating Azure OpenAI or ChatGPT API is a plus.
Strong dashboard design & data storytelling skills.

Application Instructions

When applying, please:

Provide examples of NetSuite Power BI projects you've delivered.
Share AI and predictive analytics projects you have implemented with Power BI
Briefly outline your approach.

Power BI Developer - (NetSuite Integration + AI & Predictive Analytics)