数据建模 Jobs

I need an interactive Power BI dashboard that lets our team grasp operational efficiency at a glance. The emphasis is less on cramming in every possible visual and more on presenting the information so anyone—from frontline supervisors to executives—can instantly read, filter, and understand it. My core goal is clear, intuitive report display and understanding. Once the model is in place I should be able to slice results by date, team, and location without waiting for new queries or edits. You’re free to recommend the visual types that best communicate the story; the key requirement is that they remain consistent, on-brand, and easy to interpret. I will supply the raw operational data in Excel and CSV. If calculated columns, DAX measures, or a star-schema redesign will ...

I have raw customer-focused data coming in from several marketing platforms (think Meta Ads, Google Ads, and similar). I need that information cleaned, modelled, and turned into an interactive Excel dashboard that lets me monitor customer acquisition in near-real time. Here is what I’m looking for you to deliver: • A well-structured Excel file that imports the marketing-platform exports, applies repeatable cleaning steps, and stores the tidy tables on separate, clearly named sheets. • Dynamic calculations that surface the key acquisition metrics we care about (cost per lead, cost per customer, conversion rate, and any other ratios you typically track for this goal). • An intuitive dashboard tab: slicers, drop-downs, and visually appealing charts so I can filte...

I have a complete, season-wise IPL dataset ready to go and I’d like a single interactive dashboard built from it. My focus is on three core metrics—player performance, team standings, and detailed match statistics—so the layout should let me filter by season, team, or individual player and instantly see those numbers update. Because the information will not change once uploaded, static data handling is perfect; there’s no need to wire in any live feeds or APIs. You are free to choose your preferred BI stack (Tableau, Power BI, or even a polished Python/Plotly solution) as long as the final result is intuitive and runs locally without special licensing on my side. Charts and visuals are up to you—bar, line, pie, or any combination that best tells the story&mda...

I have a petroleum hydro-processing unit that requires a robust reactor model built from the ground up. My immediate priority is model creation rather than plant-wide optimisation, and the focus is strictly on the reactor section handling petroleum-based feedstock. Here is what I need: • A first-principles or data-driven reactor model that captures hydrogen consumption, sulfur/nitrogen removal and catalyst performance under typical HDS/Hydro-cracking conditions. • Calibration against operating data I will provide (feed assays, reactor temperatures, pressures and product qualities). • Well-documented equations or code (Python, MATLAB, gPROMS, Aspen Custom Modeler—whichever you prefer) plus a short validation report comparing predictions with plant data. If you...

This is a highly challenging, research-level task that requires strong expertise in chemical engineering and advanced process simulation, particularly Aspen Custom Modeler (ACM), Aspen HYSYS, Aspen Plus. The project involves making membrane block for gas separation using Aspen Custom Modeler. Here is a reference for the result of the membrane block should be able to achieve: Merkel et al. (2010) - Power plant post-combustion carbon dioxide capture: An opportunity for membranes (Paper link also attached to this project for direct download). Scope (Summary): Develop a complete Aspen Custom Modeler (ACM) model of a membrane Implement mass & energy balances, reaction kinetics, and mass and heat transfer correlations and every other correlation. Deliver: - ACM model file - ACM model ...

I need a set of interactive Power BI dashboards built from our telephone system’s API. The goal is to surface core call-center metrics—call duration, number of calls, call resolution time—and several additional KPIs we will define together, then publish these insights for teams across Customer Service, Sales, and any other department that touches the phone. Here’s what I’m looking for: • Connect directly to the API, pull and transform the raw call logs, and design a clean data model that supports easy filtering by date, queue, agent, and department. • Build visually clear report pages that highlight the metrics above and leave room for the extra KPIs we agree on. • Configure scheduled refreshes so every team always sees up-to-date numbers w...

Necesito convertir grandes volúmenes de datos de operaciones en insights claros y accionables. Trabajo exclusivamente con Power BI, por lo que todo el flujo —desde la limpieza hasta la publicación— debe construirse dentro de esa plataforma. Alcance • Conectar y depurar nuestras fuentes operativas • Modelar los datos siguiendo buenas prácticas • Diseñar un dashboard interactivo que destaque gráficos de sectores para mostrar distribuciones clave (turnos, , incidencias, etc.). • Automatizar la actualización diaria y programar la entrega de reportes PDF por correo. • Documentar el modelo y dejar un breve manual de usuario. Criterios de aceptación – Tiempo de respuesta ágil al filtrar. ...

Our business is moving several core processes into the Zoho ecosystem and I need the environment configured end-to-end. Scope • Zoho CRM: build the data model with custom fields, tailor workflows for lead-to-deal progression, and surface actionable insights through bespoke dashboards and reports. Seamless integration with the other Zoho apps and any required third-party tools (via API, Deluge, Zoho Flow, or native connectors) is part of the brief. • Zoho Books: automate invoicing and billing cycles, streamline expense capture, and generate management-ready financial reports. All automations must respect tax rules already set in my Books instance. • Zoho Inventory: align product, stock, and order data with CRM and Books so quantities, pricing, and fulfilment statuses...

I manage the finance stack for an established logistics and warehouse business and already have a working Power BI file in place. While the data connections and DAX logic are mostly sound, the insights are hard to read and the dashboards do not tell a clear story. My priority is therefore to overhaul the data-visualisation layer while tightening up any calculation issues you may spot along the way. The finished report must let me move seamlessly from a high-level snapshot to granular detail across: • Profit & Loss • Balance Sheet • Cash Flow • Core warehouse and logistics KPIs such as inventory turnover, pick-pack accuracy and on-time dispatch What I need you to do • Inspect the existing data model, relationships and measures, correcting errors where r...

I'm looking for an expert to set up Supabase with pgvector for efficient data storage and querying. The primary focus will be on handling complex joins and aggregations. Key Requirements: - Set up Supabase with pgvector integration. - Optimize for complex joins and aggregations. - Documentation for maintenance and queries Ideal Skills: - Proficiency in Supabase and PostgreSQL. - Experience with pgvector and data querying. - Strong understanding of database optimization techniques. - Good documentation skills

I manage the finance stack for an established logistics and warehouse business and already have a working Power BI file in place. While the data connections and DAX logic are mostly sound, the insights are hard to read and the dashboards do not tell a clear story. My priority is therefore to overhaul the data-visualisation layer while tightening up any calculation issues you may spot along the way. The finished report must let me move seamlessly from a high-level snapshot to granular detail across: • Profit & Loss • Balance Sheet • Cash Flow • Core warehouse and logistics KPIs such as inventory turnover, pick-pack accuracy and on-time dispatch What I need you to do • Inspect the existing data model, relationships and measures, correcting errors where r...

I need a Power BI specialist to take the sample report my team has built for testing and convert it into a polished, production-ready dashboard that surfaces just over twenty key performance indicators. The layout, colour palette, and general flow of the sample should remain intact, yet the underlying model must be tightened so calculations run smoothly once we point the report at live data. All required data connections are already available—SQL tables, spreadsheets, and a couple of cloud endpoints—and I will grant you access as soon as we kick off. Your job is to wire those sources into a single, reliable data model, create or refine the DAX measures behind each KPI, and publish the finished piece to our Power BI Service workspace with an appropriate refresh schedule. Deliv...