Mô hình hóa dữ liệu Jobs

I need a polished Power BI report that pulls live data from my SQL Server instance, applies a handful of straightforward calculations (simple sums, averages, percentages—nothing too exotic), and then presents the results in an interactive set of bar charts, line graphs, and pie charts. You will start by configuring the data gateway or direct-query connection so the report can refresh without manual intervention. Once connected, build a clean data model with clear relationships, sensible field naming, and the calculated columns or measures we agree on. With that foundation in place, design the visuals so users can slice, filter, and drill down smoothly on the key metrics we track each week. Deliverables • A fully-functional .pbix file connected to my SQL Server database ...

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

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 have an existing analytics initiative that now needs a dedicated Redshift-based warehouse. The core objective is to design and implement a robust schema in Amazon Redshift, then ingest data coming from three different sources—our operational SQL databases, a set of RESTful APIs, and periodic flat-file drops in CSV or JSON. Here is what I’m aiming for: • A well-structured Redshift warehouse (star or snowflake schema, whichever is most appropriate) built to scale and documented clearly. • Reliable, automated ingestion pipelines for each source type. For SQL we currently use PostgreSQL and MySQL; for APIs the payloads are mostly JSON; the flat files live in S3. • Transformations that standardise data types, handle slowly changing dimensions, and enforce dat...

Busco a quien diseñe y ponga en marcha nuestros tableros de control en Power BI para una pyme. Alcance inicial • Crear dashboards interactivos que resuman las áreas de Ventas y Finanzas. • Priorizar visualizaciones con gráficos de líneas; si algún indicador lo exige, puedo aceptar otras vistas complementarias siempre que la narrativa principal se mantenga clara. • Conectar los tableros a mis datos ya organizados y dejar programada la actualización automática. • Documentar brevemente las medidas DAX clave y la lógica de cada página para que el equipo interno entienda los cálculos. Soporte continuo Acordemos un paquete de hasta 10 horas mensuales para mantenimiento: ajustes menores, incorpo...

Preciso de um dashboard em Power BI focado exclusivamente em dados de vendas. Quero que a principal métrica em destaque seja a receita gerada e que, sempre que fizer sentido, essa informação apareça em gráficos de pizza. Escopo básico: • Conectar-se à minha base de dados de vendas (posso fornecer arquivo Excel, CSV ou link SQL). • Modelar as tabelas para garantir atualização automática. • Criar páginas limpas e responsivas, usando principalmente gráficos de pizza para distribuir a receita por produto, região e período. Outros tipos de visualização podem ser incluídos se ajudarem a contar a história, mas o gráfico de pizza deve permanec...

Our organisation’s data assets sit in multiple platforms and formats, and the absence of a common language is starting to hinder everything from analytics to audit response times. I want to put in place a unified metadata management framework that improves governance across the board, with a special emphasis on meeting strict Compliance requirements. The scope covers information architecture, controlled vocabularies, and an enterprise-wide taxonomy that standardises terminology between systems. The work will culminate in a reusable model that makes stewardship activities—classification, retention, lineage tracking—far easier and more defensible. Key deliverables • A logical and physical data taxonomy covering all major subject areas • Controlled vocabu...

I need a Google Cloud / BigQuery specialist to stand up an end-to-end, webhook-driven data ingestion pipeline running in our production environment. When our external form system fires a webhook, your Cloud Function (or equivalent service) should capture the JSON payload, write the untouched record to a raw BigQuery table, then immediately process it. The processing step must • parse any nested JSON, • flatten and clean each answer field, • split the results into two purpose-built reporting tables, and • guarantee idempotency through a hashing technique that blocks duplicates. All components have to be secure, version-controlled, and able to scale with traffic spikes. This is strictly a backend/data-engineering job—no UI work is involved.

We are seeking an experienced Workday Adaptive Planning Consultant to support a post-go-live environment focused on enhancements, reporting, forecasting, and user support. This is a hands-on consulting engagement, not a greenfield implementation. The right consultant has already worked inside Adaptive Planning environments and can operate independently with minimal ramp-up. The initial engagement is 2–3 months, with a strong possibility of extension based on performance and project needs. What You’ll Be Doing Support and enhance existing Workday Adaptive Planning models Build and refine reports, dashboards, and forecasting models Assist with budget-to-actuals reporting and scenario planning Partner with finance and FP&A stakeholders to gather requirements and deliver...

We are seeking an experienced Workday Adaptive Planning Consultant to support a post-go-live environment focused on enhancements, reporting, forecasting, and user support. This is a hands-on consulting engagement, not a greenfield implementation. The right consultant has already worked inside Adaptive Planning environments and can operate independently with minimal ramp-up. The initial engagement is 2–3 months, with a strong possibility of extension based on performance and project needs. What You’ll Be Doing Support and enhance existing Workday Adaptive Planning models Build and refine reports, dashboards, and forecasting models Assist with budget-to-actuals reporting and scenario planning Partner with finance and FP&A stakeholders to gather requirements and deliver...

Role: Software Developer / Technical Partner (Equity Opportunity) I am looking for an experienced software developer to join me as a technical partner on the development of an AI-integrated desktop application, from MVP through to initial launch. This is not a contract-only role. For the right person, there is an opportunity to take on a meaningful equity stake, reflecting long-term involvement in architecture, implementation, and product evolution. The product is a stateful, non-trivial application that integrates AI as an interactive system component. It requires careful data modelling consistency management, and thoughtful UX for extended use. This is not a marketing website or a thin wrapper around an API. Core requirements: Experience building desktop applications (Electron, Tauri, ....

We are hiring an experienced professional to build Excel-based strategy and planning tools. These tools will be used for business planning, analysis, and decision-making. What You Will Develop You will build Excel tools and frameworks, such as: Planning and evaluation tools Scoring and comparison models Tracking and analysis templates Structured decision-support frameworks

I’m ready to turn a brand-new Zoho account into a fully functioning CRM that streamlines our entire sales cycle. My only goal for Zoho at this stage is CRM management, so every task revolves around perfecting lead management, sales tracking, and customer support inside Zoho CRM. What I need you to do • Design the data model: build the custom fields and tailored layouts that match the way we collect and view information. • Automate the routine: create custom workflows that capture leads, route them to the right owner, trigger follow-ups, update deal stages, and open support tickets when required. • Connect the stack: integrate Zoho CRM with the other tools we already rely on (I’ll share the list and API keys), ensuring data flows cleanly in both directions....

Project Title MS Access CRM + Quoting + Line-Level Costing + Production Workflow (multi-user ready, split DB planned) Goal Build a complete Microsoft Access application from zero that manages: Leads → Customers → Projects → Quotes → QuoteLines (each line can have its own version v1/v2…) Line-level costing and part-level breakdown Approvals, revisions, release to production Production machine lists and phase tracking Task management for all roles Document/file linking with a standardized folder structure Reports (Quote PDF, Production Pack PDF, KPIs) Role-based login + menu + permissions Designed to be split (FE/BE) for multiple concurrent users. 1) Data Model (developer must create all tables + relationships) 1.1 Master tables Users UserID (PK, Aut...

I’m ready to commission a custom PostgreSQL-based system that brings four critical workflows into one place: • Inventory control with real-time stock level monitoring and fast barcode scanning for check-in / check-out. • Employee schedule management so I can see who is assigned to each job at a glance. • Job costing and progress tracking that ties labor, materials, and overhead together for accurate profitability insights. • A secure API endpoint that pushes material usage from each job directly into QuickBooks, eliminating double entry. You will design the data model, build the web interface (any modern stack you’re comfortable with), and implement the QuickBooks integration. Clean, well-documented code and straightforward deployment instructions ...

Título: Power App Model-Driven — Gestión de Pedidos de Libros Presupuesto: $200 - $250 USD (Precio Fijo) Descripción: Busco un desarrollador con experiencia en Power Apps (Model-Driven) y Dataverse para crear una aplicación sencilla de gestión de pedidos de libros. ¿Qué necesito? Tengo un negocio de venta y distribución de libros. Hasta ahora vengo manejando todo con un archivo Excel, pero ya me quedó chico. Necesito una Power App (preferiblemente model-driven) que me permita llevar el registro de mis clientes y sus pedidos, preparar las órdenes de compra a mis proveedores, y registrar los envíos que hago a los clientes (shipping log). Voy a compartir mi archivo Excel para que veas los datos que manejo actua...

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