Sales & Margin Audit Dashboard with Row-Level Security
Budget: $1,500 – $3,000 USD
Description:
We need a Power BI dashboard that implements Row-Level Security (RLS) to control access to regional and individual sales performance data. The model must support multiple companies and dynamic filtering based on user roles.
Key Tasks:
Integrate data from Excel and MySQL
Model tables: customers, orders, products, sales reps
Calculate KPIs:
Gross Margin
Average Order Value
Top Clients by Sales
Product Performance by Region
Apply RLS using role-based filters
Build a clean and responsive dashboard UI (desktop/tablet)
Preferred Experience:
Previous BI projects for sales teams
Strong documentation and logic explanation skills
Skills Needed:
Power BI, SQL, DAX, Data Security, Data Modeling, Excel, Data Integration
We need a Power BI dashboard that implements Row-Level Security (RLS) to control access to regional and individual sales performance data. The model must support multiple companies and dynamic filtering based on user roles.
Key Tasks:
Integrate data from Excel and MySQL
Model tables: customers, orders, products, sales reps
Calculate KPIs:
Gross Margin
Average Order Value
Top Clients by Sales
Product Performance by Region
Apply RLS using role-based filters
Build a clean and responsive dashboard UI (desktop/tablet)
Preferred Experience:
Previous BI projects for sales teams
Strong documentation and logic explanation skills
Skills Needed:
Power BI, SQL, DAX, Data Security, Data Modeling, Excel, Data Integration