Inteligencia comercial Jobs

Need to update few features and enhance the KPI dashboard tabulation with Automation and graphs

I have a raw Foodpanda dataset and want to understand how each restaurant truly performs. Your task is to run a focused exploratory data analysis that zeroes in on sales and revenue figures for every restaurant in the file. I’m interested in trends such as top- and bottom-line growth over time, seasonality, outliers, and any correlations you uncover between order volume, average basket size, discounts, or other revenue-related metrics you choose to engineer. Python, pandas, NumPy, and visualization libraries like Seaborn, Matplotlib, or Plotly are all welcome—as long as the code is clean, reproducible, and well-commented. Please avoid drifting into customer-review or delivery-time angles; the spotlight must stay on revenue-based performance. When you apply, attach a concise...

I need a polished, insight-rich Power BI dashboard that lets our leaders quickly understand three years of people data. The focus is on following KPI families: Employee headcount, Gender Diversity, Attrition and Training & Development. From project-level views to individual drill-downs, the visuals should reveal trends, outliers, and actionable patterns so managers can make decisions on coaching, promotions, and skill-building in seconds rather than hours. Scope of work • Connect to our raw HR data sources (excel files) and model them cleanly for year-over-year comparison. • Build interactive visuals—scorecards, slicers, heat maps, and time-series charts—that highlight performance and learning progress at department, team, and individual levels. • Opti...

Saya memiliki dataset Excel berisi data peternakan dan ingin mengubahnya menjadi dashboard interaktif yang selalu menampilkan informasi terkini. Ruang lingkup: • Bangun dashboard yang terhubung langsung ke file Excel sekaligus menulis data itu ke database terpusat, sehingga setiap penambahan atau perubahan di file otomatis tercermin di visualisasi. • Tampilkan semua informasi Dokumentasi: Saya butuh catatan langkah-demi-langkah (setup database, koneksi, transformasi, pembuatan grafik, dll). Kriteria penerimaan: 1. Dashboard berfungsi penuh secara interaktif yang memuat semua informasi dari dataset. 2. Data otomatis ter-update ketika file Excel berubah. 3. Dokumen proses lengkap beserta screenshot atau rekaman singkat.

I need a concept design operational scorecard built specifically for tracking our key performance metrics, with financial performance front and centre. The final tool has to give me a quick, visual grasp of how the business is doing at any moment. I’m open to how you present this - I will do the back end data, however the visual creation I need support with. When you reply, show me past work that proves you can turn raw data into an at-a-glance dashboard or scorecard. Screenshots, links or a brief case study are perfect; no need for a lengthy proposal at this stage. If that sounds like your wheelhouse, let’s talk and get this launched quickly.

I have a raw export of sales transactions and want to understand what the numbers are actually saying. Using Power BI and Excel, please transform the dataset into an easy-to-read snapshot of performance so I can see totals, averages, trends over time, and key segments at a glance. Scope – Clean and structure the file so every column is usable. – Produce descriptive statistics that highlight overall revenue, units sold, average order value, growth by month or quarter, and any noticeable seasonality. – Build an interactive Power BI dashboard (with filters for date ranges, product categories, regions, and sales channels) and a companion Excel workbook that mirrors the same insights for quick offline reference. – Include a brief written summary that calls out t...

I need a Power BI dashboard to track time, effort, and costs. This dashboard should effectively visualize: - Project timelines - Work hours - Expenses Ideal Skills and Experience: - Proficiency in Power BI - Experience in data visualization - Strong understanding of project management metrics

Requesting an existing software interface to Oracle software that will report sales from a hotel

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, ...