Business Intelligence Jobs

My existing Power BI report pulls several large tables from Microsoft Dynamics 365 Business Central through the standard API. The model works, but the scheduled refresh now fails with frequent time-outs; reliability is my biggest concern. So far I have: • enabled incremental refresh on the largest tables • tuned a handful of queries • experimented with splitting data into smaller API calls None of these measures has eliminated the failure. I need an expert who can: 1. pinpoint the exact bottleneck within the current data model, gateway settings, or API calls 2. redesign the retrieval strategy so the report finishes every refresh window without timing out 3. leave me with a clean, documented PBIX (or dataflow) that follows best practice for query folding, pa...

I have a dataset that needs to come alive inside Excel. Using Pivot Tables as the core engine, I want the workbook to surface trends, outliers and drill-down views that update automatically when fresh data is dropped in. On top of that, I’d like the same model—or its cleaned data layer—pulled into Power BI so I can compare the interactive experience between the two platforms and understand how each handles refreshes, slicers and visual storytelling. Here’s what I need from you: • Build the Excel file so every chart, KPI card and slicer is driven by well-structured Pivot Tables, not hard-coded ranges. • Set up a companion Power BI report that mirrors the logic and lets me explore identical metrics there. • Give me a short screen-share walkthrough...

I’m looking for a seasoned inventory professional who can step straight into our advanced inventory management environment and tighten up the way we handle our retail product stock. The core of the assignment revolves around three interconnected objectives: 1. Ongoing stock tracking 2. Precise reorder-point configuration 3. Thorough, scheduled inventory audits We already operate with a fully featured inventory platform, so you’ll be working in a system that supports real-time data feeds, barcode/RFID inputs, and multi-location reporting. Your task is to use those capabilities—not rebuild them—ensuring on-hand counts stay accurate, replenishment triggers align with realistic lead times, and audit results flow back into the system to close any discrepancies. ...

I need an interactive Power BI dashboard that turns the raw data coming from our project-management tool into clear, actionable employee-performance insights. The goal is to track operational metrics such as task throughput, on-time delivery rate, average cycle time, and workload balance so team leads can spot bottlenecks and coach in real time. You will connect directly to the project-management platform’s API or flat-file exports, build a clean data model, and write the DAX needed for accurate calculations and time-intelligent trends. Visuals should follow good UX practices—consistent colour palette, dynamic tooltips, and intuitive slicers—so non-technical managers can explore the numbers without guidance. Deliverables: • A fully functional .pbix file with data m...

End-to-End Petroleum Logistics Visibility Dashboard (Excel + Power Query, Power BI-ready) 1. Background & Objective We operate a bulk petroleum logistics and distribution business involving: • Import of petroleum products at Dar es Salaam • Storage of petroleum at depot in Dar es Salaam • Dispatch through petroleum tanker fleet (owned and 3PL) • Cross-border transportation through Tanzania → Zambia → DRC • Delivery into owned depots and client depots in DRC • After offloading, trucks return empty from DRC → Zambia → Tanzania • In Dar es Salaam, trucks go to workshop for maintenance, and then go to depot for loading • In DRC, Last-mile distribution from our owned DRC depot to end customers in owned-local truck fleet Currently, ...

Analyzed 10,000 rows of raw retail sales data and built a complete analytics system with 11 professional charts and an automated PDF report that runs with a single click. The biggest challenge was identifying why profit margins were inconsistent across different product categories and regions despite strong overall sales numbers. Using Python and Pandas I cleaned and transformed the raw data, removed errors and inconsistencies and built a complete analysis pipeline from scratch. KEY FINDING: Discounts above 40% were generating negative profit across hundreds of transactions. Capping discounts at 20% identified a $50,000 annual profit recovery opportunity the business did not know existed. WHAT WAS DELIVERED: 1. Complete data cleaning and preparation 2. 11 professional char...

Part-Time Market Intelligence Collector Needed (Hearth & Home Technologies Expo, New Orleans) 【Project Background】 We are looking for a part-time assistant based in or traveling to New Orleans, USA, to collect market intelligence at the 2026 Hearth & Home Technologies Expo. 【Event Details】 -Event Name: Hearth & Home Technologies Expo -Date: March 18–21, 2026 -Location: Ernest N. Morial Convention Center, New Orleans, LA (900 Convention Center Blvd) -Organizer: HPBA (Hearth, Patio & Barbecue Association) 【 Responsibilities】 The selected candidate will be responsible for the following tasks during the expo: o List the names of all exhibiting Chinese suppliers. o List the names of local US exhibiting companies. o Take photos of Chinese booths and collect/photograph busi...

Ya cuento con un archivo Excel donde consolido todas mis ventas y finanzas personales; solo necesito trasladarlo a Google Sheets y convertirlo en un panel gráfico completamente interactivo. Qué espero ver • Gráficos de barras, líneas y pastel que se actualicen automáticamente cuando cargue nuevos datos. • Filtros interactivos (confirmado que los quiero): selector de mes/año, vendedor, moneda (dólares o pesos) y un ranking dinámico de mejores ventas. • Panel limpio y ordenado, pensado para que en un par de clics pueda comparar períodos, vendedores y monedas sin tocar fórmulas. • Estructura de datos optimizada (tablas dinámicas, rangos nombrados o lo que aconsejes) para que el dashboard ...