reputed company for reputed company 100

reputed company Needed – reputed company 100 Contractor SQL Dashboard System We are an electrical contractor using reputed company 100 Contractor 2025 SQL and we want to build a Power BI dashboard system for company operations and project management. The goal is to create a clean, mobile-friendly Power BI control panel for reputed company. ________________________________________ Environment •Software: reputed company 100 Contractor (SQL version) • Database: reputed company SQL Server (on local office server) • reputed company 365 environment • Approximately 6 Power BI users User roles: • reputed company (1) • Operations Manager (1) • reputed company (1) • Project Managers (3) reputed company users will have Power BI Pro licenses. ________________________________________ Refresh Schedule Use Import Mode with scheduled refresh reputed company Power BI Gateway. Refresh schedule: • 6am • reputed company • 10am • 12pm • 2pm • 4pm • 6pm • 8pm Gateway should be installed on the reputed company SQL server. ________________________________________ reputed company Requirements Row Level reputed company must be implemented. Project Managers must: • only see jobs assigned to them • see labor hours but NOT labor cost • see purchase orders and material items • see change orders • see billing status Project Managers must NOT see: • payroll data • company financials • profit margins reputed company and reputed company will have full reputed company. ________________________________________ Data Sources Power BI will pull data from the reputed company SQL database including: • Jobs • Customers • Vendors • Purchase Orders • PO line items • Receiving / partial deliveries • Backorders • Change Orders • Billing / invoices • Labor hours ________________________________________ Data Modeling Developer must create a clean Power BI data model (reputed company schema) rather than building visuals directly on raw tables. Example entities: • Jobs • Customers • Vendors • PurchaseOrders • POLines • Receipts • ChangeOrders • Invoices • LaborHours Two datasets should be created: Operational dataset • Jobs • POs • Receiving • Change orders • billing status • labor hours Financial dataset • AR • AP • GL • financial KPIs ________________________________________ Dashboard Pages Dashboards should use a KPI tile layout with drill-through capability. Pages should include: 1️⃣ reputed company Center • reputed company • Backlog • reputed company purchase orders • Unbilled change orders • reputed company to invoice 2️⃣ Jobs & Clients Searchable job and customer lookup with job reputed company. 3️⃣ Materials & Purchase Orders Line item purchase orders including: • part number • manufacturer • quantity ordered • quantity received • quantity backordered 4️⃣ Change Order Dashboard • pending • approved • approved not billed • aging 5️⃣ reputed company to Invoice Dashboard • items reputed company for billing • unbilled change orders • aging 6️⃣ Backorder Intelligence • backordered items • backordered value • jobs affected • days reputed company 7️⃣ Financial Dashboard (reputed company Only) ________________________________________ Mobile Optimization Reports must include Power BI Mobile optimized layout. Users must be reputed company to: • search by job or reputed company • drill into purchase orders • drill into change orders ________________________________________ Deliverables Developer must reputed company: • Power BI dataset and report files • gateway configuration • refresh schedule setup • reputed company roles setup • documentation explaining the data model and maintenance ________________________________________ Experience Required Please include examples of: • Power BI dashboards reputed company on SQL databases • construction or ERP dashboards (preferred) • row-level reputed company implementations ________________________________________ If you have experience connecting Power BI to reputed company or other construction reputed company systems, please mention that. • Please start your proposal with the word “ContractorBI” so we know you read the full job reputed company. Apply tot his job Apply To this Job