Modélisation des données Jobs

Strong Microsoft SQL Server DBA background (8+ years) but last ~5 years on build/installation. Goal: intensive, hands‑on refresh of day‑to‑day DBA tasks, plus Azure SQL and migrations from SQL Server to Azure SQL. Schedule: 1 hour per day, Monday to Friday, 7–8 pm CST, starting March 9. Duration: ~7 weeks total (about 4 weeks SQL Server, 3 weeks Azure SQL/migration), adjustable based on progress. Emphasize that you want practical labs, troubleshooting, and real‑world scenarios. Explicitly state: “No blockchain, crypto, Web3 or related topics involved.

I need a specialist who can build analytic stories directly inside SAP IBP that bring our supply-chain data to life. The goal is to give planners an at-a-glance view of forecast accuracy and emerging demand trends, refreshed every day without manual effort. Here is what I am after: • Connect to the existing supply-chain planning areas and model the data so that forecast versus actuals, MAPE, bias and trend lines appear clearly. • Design intuitive, drill-down dashboards using the embedded SAP Analytics Cloud functionality in IBP—no external BI tools. • Set up an automated refresh schedule so the stories pull the latest numbers daily. • Make the layout clean and on-brand, with navigation that even occasional users can follow. Acceptance criteria 1. At ...

My workbook already asks SerpApi for data the moment I type a model number in the “Model” sheet, and Power Query pushes the results into the “Result” sheet. Two nagging issues stop it from being production-ready: 1. The cache sheet that should store the API response has stopped working, so every look-up now triggers a new, slow call instead of re-using the last fetch. 2. On the “Result” sheet the sale price reaches the correct cell, but the regular (full) price column stays empty. I need someone who understands Power Query, Excel data model, and REST/API connections (SerpApi in particular) to: • Diagnose and restore the caching logic so the workbook re-uses previously fetched JSON. • Update the query/transform steps so the full price fi...

Veuillez vous inscrire ou vous connecter pour voir les détails.

I am pulling information from multiple systems every day—iCloud exports, purchase and revenue files, our CRM, even stray WhatsApp logs—and it is getting messy. I need a detail-oriented analyst who can turn this scattered data into clear, trustworthy insights. Here is what I want to achieve: • Build an accurate data forecast so I know exactly how much usable customer data we have and how long it will sustain current campaigns. • Mine fresh data from every available source, then consolidate everything into one clean dataset. • Audit purchase and revenue records to spot and remove any duplication, with special attention to iCloud–generated files. • Reconcile datasets across systems so customer counts, lead statuses in the CRM, and revenue totals ...

I need a comprehensive costing model created. This model should be automated and take into account various pricing factors for procurement and IT services. Essential Requirements: - Pricing factors: Supplier prices, Logistics costs, Tax implications, FTE, - Input data: Excel spreadsheets - Automation is key - Must be delivered ASAP Ideal Skills and Experience: - Expertise in Excel and data modeling - Experience with procurement costing models - Strong background in logistics and tax implications

I need a GoHighLevel specialist to implement a true multi-site data model using Custom Objects + Associations. This is specifically for Real Estate / Body Corporate / multi-property clients, where: One customer/contact must link to multiple Properties/Sites Each Property/Site must link to multiple Site Contacts (tenant, property manager, billing contact) Adding a new property must NOT create a duplicate customer/contact This project is ONLY for the multi-site / custom objects / associations part (not general GHL cleanup). Non-negotiable: NDA-safe proof BEFORE engagement Before I award any milestone or grant access, you must provide NDA-safe Loom or NDA-safe screenshots showing this working inside GoHighLevel: Settings → Custom Objects list page Properties/Sites custom object ...

(Solo perfiles con experiencia demostrable en diseño de esquemas PostgreSQL en producción. No busco desarrollo web, sino arquitectura y consistencia relacional.) Tengo una base de datos PostgreSQL alojada en Supabase que recoge partidos, goles, tarjetas, convocatorias, sustituciones y más. Ya está conectada a Power BI y funciona, pero quiero garantizar su integridad antes de seguir creciendo. Lo que necesito • Revisar el esquema actual y unificar los tipos de clave (codigo_equipo, codigo_jugador, codigo_acta). • Definir y aplicar PK, UK, FK e índices que mejoren consistencia y tiempos de consulta. • Detectar registros duplicados y proponer claves naturales para cada tipo de evento. • Renombrar o re-codificar columnas problem&aa...

Necesito diseñar e implementar una base de datos que centralice la información de producción, clientes e inventario de mi negocio. Todavía no he decidido si conviene un modelo relacional (SQL) o no relacional (NoSQL), así que valoro tu recomendación según escalabilidad, costo y facilidad de mantenimiento. Alcance que tengo en mente: • Modelado del esquema para datos de producción, clientes e inventarios, asegurando integridad y relaciones claras. • Funciones básicas de consulta y reporte: totales de producción por periodo, niveles de stock en tiempo real y resumen de clientes activos. • Documentación breve que detalle la estructura, credenciales genéricas, instrucciones de respaldo y c&oa...

I need a full Environment, Health & Safety management application built in Zoho Creator as soon as possible. The solution must cover incident reporting, audit & inspection management, and compliance tracking in a single, streamlined workspace. Key deliverables Create a comprehensive EHS (Environment, Health & Safety) Management Application for an organization. The application must be web and mobile friendly, role-based, and workflow-driven. User Roles: Super Admin – Full access to all modules, edit/delete rights, dashboard analytics, user control. Admin / EHS Manager – Can create audits, templates, incidents, training, assign actions, manage documents, and generate reports. Auditor / Safety Officer – Can conduct audits, fill checklists, submit inciden...

Two live, one-hour screen-sharing sessions will kick-start our work with Clay AI. Session #1 needs to dive straight into performing Google Map searches inside Clay and then pushing those enriched results back into our current database. I also want clear guidance on defining triggers and actions, setting up reliable notifications, and keeping the data model tidy through proper database normalization. If extra time is needed after the first two calls, I am happy to book follow-up sessions so I leave feeling fully confident building entire Clay workflows from scratch, tweaking simple custom AI models, and exporting everything cleanly. Any screen-sharing platform—Zoom, Google Meet, Skype, or whichever tool you prefer—is fine as long as we can see each other’s screens clea...

I’m building an internal security tool and need a solid PostgreSQL foundation that starts as a single, multi-tenant database yet can be cleanly split into separate databases—and separate servers—later on. The first release will concentrate on storing architectural components (a very well defined structure) alongside threat-intelligence data (mapped to the components metadata), so the schema must keep cross-tenant isolation strict while still allowing swift relational join matching across those two domains. What I need from you • A full relational schema (ERD and DDL) optimised for multi-tenant operation—think shared-table with isolated tenant-id or schema-per-tenant, whichever you can justify—and documented so the eventual extraction path is clear. &...

I have several Excel workbooks that need to be transformed into clear, interactive visuals built in Power BI. The priority is comparative analysis: I want end-users to see how figures stack up against one another across products, time periods, or any other relevant dimension we identify together. At this stage I’m concentrating purely on visual exploration rather than a full narrative report or enterprise-wide dashboard, though I appreciate designs that could scale in that direction later. You will receive the raw Excel files along with a brief that highlights the main metrics to compare. I expect you to model the data inside Power BI, choose the most effective visual types, and apply slicers or drill-through where they add value. Please keep the visuals clean, performance-friendly,...

I need a fully-interactive marketing performance dashboard built in Power BI that lets me slice and explore data by channel, campaign, lead source, and region. The core data set includes social media, email campaigns, and paid search; from it I want to surface four headline KPIs—Total Revenue, Total Budget, Conversion Count, and ROI %—and be able to drill down quickly with dynamic filters, date-range controls, and campaign-level selectors. The visual layer should rely on clear, insightful charts and graphs: • side-by-side budget-versus-revenue comparisons for each channel • trend lines that react instantly when the date slider is adjusted • conversion funnels or stacked visuals that reveal strengths and gaps across regions Behind the visuals, please set u...

I need a comprehensive technical-and-functional blueprint for a new specialized digital platform. To ground every recommendation in real-world evidence, you will first study competitor platforms as well as several user-nominated platforms that my team will share. Drawing from that analysis, you will then produce a single, well-structured document that details the platform’s architecture, key modules, data flows, integration points, and any compliance or scalability considerations. The final blueprint should read like a roadmap that an engineering team could pick up and start building from. Clear diagrams, precise feature descriptions, and rationale for each technology choice are essential. Your background in technical writing and software documentation—especially where technic...

I will hand over a clean dataset that tracks our globalization work; it includes progress metrics, current status markers and a field we label “DVA9” for one specific language group. I need you to turn that raw information into a single-page, visually striking report built in Looker (Looker Studio or Looker BI). The page should spotlight overall text-localization progress, surface any issues you uncover and make the narrative immediately clear to an executive reader. Use the platform’s native charting, colour-coding and drill-through features so stakeholders can see at a glance where we stand and where problems still sit. Keep the layout crisp—headlines, key KPIs, and a compact visual timeline or bar that shows completion versus open issues. When possible, struct...

FlutterFlow + Firebase Developer Needed – Social Sports & Events MVP Project Overview I am building an MVP for a location-based sports and social events platform. The product combines: • Event creation & RSVP system • Vertical short-form video feed • Subscription monetization • Structured user interaction logic • Payment integration The design system, flows, and monetization model are already defined. I am looking for an experienced FlutterFlow + Firebase developer to implement the MVP with scalable architecture and clean data modeling. ⸻ Core Requirements (High-Level) MVP includes: • User authentication • Event discovery & RSVP (public + private events) • Payment processing (Stripe) • Subscription management &bul...

I need a set of automated dashboards in Google Sheets that continuously pulls data from our recurring CSV exports and turns it into a live view of company performance. The two figures I must see at a glance are Revenue and Net Profit, with the option to slice by product line and date once the basics are stable. Here is what the finished workbook should let me do: • Drop the latest CSVs into Drive and watch the data model update without manual copy-pasting. • View clean, interactive charts and tables that refresh on schedule or at the click of a button. • Export or share the P&L dashboard with teammates while keeping formulas locked down. Please build whichever mix of formulas, pivot tables, named ranges, or Apps Script you feel is best to keep refresh times f...

I need an engineer who already works comfortably with the MZ Automation (openIEC61850) library to build a complete, Edition 2.1–compliant SCL file for one of our Smart Grid systems. All logical nodes to be modelled are spelled out in my internal specification document, so you will not have to guess any class names or data objects; just implement exactly what is listed. I need SCL files and tools (preferably automatic or semi-automatic) to generate the required files (ICD, CID, SSD, SCD) starting from our plant configuration file for each specific installation in the future. Alongside the SCL you will prepare the full set of IEC 61850 conformance paperwork: • PICS • PIXIT • TICS • MICS

SAP HANA / SAP Analytics Role-Based Dashboard Development (Finance, Procurement, Production) Project Overview We are looking for an experienced SAP HANA / SAP Analytics consultant to design and implement a set of role-based executive dashboards that will allow us to monitor our company operations in a clear, fast, and strategic way. The dashboards must cover three core business areas: • Finance • Procurement • Production We require dashboards for 5 different user roles, each with customized access and KPI visibility: 1. Chairman of the Board 2. CEO 3. CFO 4. CPO (Chief Procurement Officer) 5. Production Manager The system must be clean, highly visual, drill-down enabled, and performance optimized. ⸻ Scope of Work 1. Role-Based Dashboard Architecture • D...

I am assembling a full-stack solution that ingests live financial databases, open-source macroeconomic feeds, and user-submitted figures, then turns all of it into forward-looking insights. The core of the product is an AI layer that delivers predictive analytics and runs configurable scenario simulations; the results need to surface instantly inside an intuitive web dashboard where users create and save their own reports and visual layouts. What I need from you is an end-to-end build: • Data layer – connectors that automatically pull structured and unstructured data from the three source categories above, plus a storage design that can scale as historical records grow. • ML & simulation engine – time-series forecasting models, Monte Carlo or agent-based simula...

I need a comprehensive costing model created. This model should be automated and take into account various pricing factors for procurement and IT services. Essential Requirements: - Pricing factors: Supplier prices, Logistics costs, Tax implications, FTE, - Input data: Excel spreadsheets - Automation is key - Must be delivered ASAP Ideal Skills and Experience: - Expertise in Excel and data modeling - Experience with procurement costing models - Strong background in logistics and tax implications

Proposal using CRISP-DM (not coding): •Describe problem, data, prep, modeling, evaluation •When doing Data analysis, add before and after measurement per company •Use this survey to extract the data structures and the data lookup: •Generate random dataset with 1000 records for the form shown at open-dma link above. Strictly from what the form offers!!! Generate Before and then a After dataset (a separate one with improved results). Save it to excel as and •Process the data in python •Create a function in python that will generate individual reports (word or PDF format) – sample 5 reports (for delivery), not 1000 and produce them as files. •Create visuals for the web report or individual reports as needed. •Elaborate any correlation between ...

I’m refreshing my GitHub profile for upcoming university applications and I need a concise, well-architected Django backend that illustrates how I approach data modelling, API design and clean code. Tech stack is fixed: Python 3.x with Django (latest LTS). Because this is a portfolio piece, clarity, documentation and sensible project structure matter more than production-grade scaling or DevOps extras. Scope of the system The app should let authenticated users track items in and out of stock and generate simple reports. I expect models for items, categories and basic stock movements, JWT or session-based authentication, and a small reporting module summarising current inventory levels and movement history. Deliverables • Django project and apps organised with reusable, ...

I need a custom Deneb visual in Power BI. The data will live entirely inside the visual specification—no Excel sheets, databases, or APIs to connect—so you can reference it directly as inline arrays within the Vega-Lite JSON. I've attached a mockup of how I need this visual to look, I've also attached some Vega Lite code which I've attempted to make work but it is a starting point, the code also contains an in-line dataset

Overview We are looking for a Senior Data Engineer to join the team that owns our core data product, the platforms and infrastructure that support it, and the data services consumed by our customers. You will work closely with other engineers, product stakeholders, and customers to design, build, and operate production-grade data systems, focusing on reliable ingestion, transformation, and exposure of data through APIs and product integrations. As a senior member of the team, you will be expected to help set technical standards, improve data quality and operational reliability, and contribute to shared ownership of systems from design through to reliable operation in production environments. What you’ll do • Design, build, and maintain data ingestion pipelines • Develop and...

I need a single, self-refreshing Excel solution that pulls every lawyer’s daily timesheet from our shared folder and rolls them into one master file. Power Query should pick up any new or updated workbook the moment I hit Refresh, clean the data, and store it in a structured table. From there I want totals by lawyer, by case, and by date, all available at a click. The management dashboard must offer both a quick high-level snapshot for partners and a drill-down view for finance, presented through pivot tables alongside clear charts and graphs. Think slicers that let us slice by matter number, lawyer, week, or month without waiting. Key items I expect: • Automated data import via Power Query • Data model that supports views by lawyer, case, and date simultaneously &bul...

I have a Computer Science systems-design assignment due in three days that focuses specifically on database design. I need a clear, well-structured submission that demonstrates solid theoretical understanding and practical application. Scope – Analyse the problem statement I will share and extract data requirements. – Produce an ER diagram, explain entity choices, relationships, cardinalities, and constraints. – Normalise the model up to 3NF, documenting each step and the rationale. – Provide the final relational schema with primary and foreign keys clearly indicated. – Supply brief written explanations (2–3 pages) that justify design decisions and reference best practices. Acceptance Criteria • Diagram delivered in a common format (PDF or...

I need my operational data—currently stored across several Excel workbooks—turned into interactive Power BI reports that make trend-spotting and drill-downs effortless. The focus is on robust reporting and analytics rather than a one-off dashboard, so the solution should be scalable and easy for me to refresh whenever new spreadsheets arrive. If you’re interested, send a detailed project proposal outlining the steps you would take to: • connect and clean multiple Excel sources • model the data for accurate relationships and DAX measures • design intuitive visuals that highlight KPIs, variances, and historical trends • deliver a ready-to-share .pbix file plus a short hand-off guide Everything will be built on Excel inputs for now, though I...

Project Overview Project Name: School Student Attendance System Goal: Build a system that allows teachers/staff to mark student attendance (possibly with location/time), notifies parents via push notifications when the student is ready for pickup or has been picked up, enables parents to confirm/view status, and handles basic student/parent/teacher data. Architecture: • Mobile App (Teachers / Parents) • Oracle APEX Backend (Admin / Reports / APIs) • Oracle Database Duration: 2 Months (8 Weeks) System Architecture 1) Mobile Application Users: • Teachers → mark attendance and deliver students • Parents → Students receive and students tracking. • Security → deliver students (optional) Features: • Login • Class & student list •...

I’m looking for a senior systems architect to design the technical foundation for a payment-gated booking network that controls access to real-time, high-demand service slots. From the user’s perspective, the flow is simple: select a slot → pay → receive instant confirmation. Behind the scenes, the platform must reliably handle concurrency spikes, subscription validation, atomic booking, and fast payment settlement, while guaranteeing zero double-booking. This is an architecture-first engagement. No UI or app build is required at this stage. Core Objectives Model the end-to-end flow for payment-gated real-time bookings for high-demand services. Design a subscription layer that wraps booking access. At launch we will offer a single monthly plan; the architecture m...