Data Modeling Jobs

I'm looking for assistance in creating a flowchart using Prisma for an EBSCO database. Requirements: - Familiarity with Prisma and EBSCO - Experience in flowchart design Ideal Skills and Experience: - Database management - Diagramming tools expertise

I’m halfway through a Power BI report and need an expert hand to finish the data-modeling side. All source data arrives as clean CSV files, each holding coordinate pairs alongside several lookup fields. Here’s what’s left to do: • Write DAX (or Power Query M if you prefer) that calculates the Euclidean distance between two coordinate columns in each row. • Build proper one-to-many relationships so my fact table links cleanly to the lookups. • Implement value-based filtering so end-users can slice results by numerical thresholds rather than dates or categories. I will share the PBIX, the raw CSVs, and a short explainer video that walks through the current model. Feel free to add supporting tables, custom measures, or quick visuals that prove each form...

I have a set of weekly-refreshed sales figures that I want to explore in depth through a single, well-structured Excel workbook built around Power Pivot. The file must let me load new data each week, refresh the model with one click, and instantly see the impact across all reports. Here is what I need you to put in place: • Robust Power Pivot data model that ingests my raw sales tables and maintains clean relationships • Import and export routines (ideally via Power Query) so I can pull in CSV files and, when required, push summarized data back out • A suite of advanced DAX calculations: period-over-period growth, cumulative totals, top-N products, regional contribution, and any other metrics that help reveal trends • Interactive visualizations—charts, sli...

I have a spreadsheet that tracks container-throughput from the Port to the ICD over time. I need a clean, reader-friendly report that tells the whole story hidden in those numbers. Scope of work First, lay out a solid descriptive analysis that covers total throughput and the day-to-day movement patterns. Next, build a predictive model so I can see how volumes may evolve in the near future. Finally, compare key periods and parameters to uncover how performance differs across time frames or operational variables. The descriptive section must highlight: • Total throughput • Daily trends • Trends specifically linked to Containers Received and any relationships you uncover between variables Deliverables • A written report (Word or PDF) summarising findings from the ...

I am looking for someone who can create biomass gasification from EFB and carbon capture by MEA. The result for both biomass gasification and carbon capture by MEA need to be validated with results from the journals (biomass gasification and carbon capture by MEA has their own experimental journal). Both of them needs to be done by Aspen Plus. At the first stage, there are 2 different simulation : biomass gasification & carbon capture using MEA. The biomass gasification simulation needs to have the same result of syngas composition (CH4, CO, CO2 and H2) with the result from journal. The result needs to be validated based on the temperature at 650,700,750,800,850 and 900 Celcius. While for the MEA-carbon capture, the results need to be validated by the concentration of the MEA at 30%,...

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

I have a set of Excel sheets that hold all of our raw financial data and I need them turned into a polished, interactive Power BI dashboard focused on Financial analysis. The visuals must spotlight Revenue and profits alongside Expenses and costs so management can track performance at a glance, compare periods, and drill into any outlier quickly. You will import the spreadsheets, model the tables, and build the DAX measures required for accurate revenue, gross-profit, expense, and margin calculations. Time-intelligence (YTD, MoM, QoQ) and dynamic filtering by business unit, product line, and date are essential. Layout should be clean, brand-coloured, and optimised for both desktop and the Power BI service, with refresh paths that continue to work as new Excel files are dropped into the de...

I have a large, raw Flipkart sales export that needs to be turned into a polished, insight-rich Power BI dashboard. The core story I want told is product performance—specifically which items are driving the most revenue, which are lagging, and how return rates are affecting overall profitability. Beyond that focal point, the model should still let me glance at revenue trends, customer-purchase patterns, seller distribution and the impact of discounts, but competitor benchmarking is not required this time. Your work starts with data shaping in Power Query, progresses to a well-structured star schema, and ends with elegant, drill-through visuals built in Power BI Desktop. I rely heavily on DAX measures, so clear, well-named calculations are essential. Deliverables • Cle...

I have a clean historical-weather spreadsheet and I want to turn it into a set of engaging dashboards and interactive 3d models. I am trying to prove a thesis that wind direction during winter months contributes to snow blocking a road. The key stories I need to see are: • Predominant wind direction, average wind speed, and peak gusts broken down month-by-month. These should be sliders on a model. • Daily snow-depth trends across the winter, with an overlay or clear link to the prevailing wind direction on each day or month. Focus is on Dec-March Please build whatever pivot tables, Power Query steps, or helper columns you feel are necessary and then surface the insights in a mix of 2D and 3D models—I’d like to be able to switch between the two for presentations. ...

Database Migration Specialist: MySQL to Supabase/PostgreSQL We're looking for a data migration expert who doesn't just move data — you ensure it arrives clean, complete, and production-ready. You have deep experience migrating large-scale databases and understand the nuances of moving from MySQL to PostgreSQL in Supabase environments. What You'll Do: - Plan and execute end-to-end migration of large MySQL databases to PostgreSQL on Supabase - Audit source data for inconsistencies, duplicates, and schema incompatibilities before migration - Design and implement migration scripts, transformation logic, and validation checks - Handle data type mapping, constraint differences, and stored procedure conversions between MySQL and PostgreSQL - Perform dry runs, staged migrati...

The task is to build an interactive Power BI dashboard that visualises my organisation’s consumption volume. All data sits in a set of Excel spreadsheets and must stay synced automatically, so the model should refresh cleanly whenever new files overwrite the existing ones. Key focus • Showcase yearly comparisons of total consumption, with clear visuals that allow users to spot growth, decline, and outliers at a glance. • Simple slicers or filters for year, product line, and region (the columns are already present in the source files). • A clean layout that can be shared through the Power BI service without additional configuration on my side. Data • Excel workbooks reside in a OneDrive folder; Power BI should connect directly to that location to preserve the...

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

I'm seeking an expert to help normalize my SQL database to the 2nd Normal Form (2NF). The primary goal is to reduce redundancy. Key Requirements: - Expertise in SQL databases - Strong understanding of 2NF principles - Experience in database normalization Ideal Skills: - SQL proficiency - Database design and architecture - Problem-solving skills for redundancy issues Please provide relevant experience with your bids.

Here are some important exam details: Logistics: You will have the full 90 minutes to complete the exam. No Cheat Sheet/Calculators: The exam is closed-book, and no sheets are allowed. You will not need a calculator for the exam, as most questions are conceptual or will not require much calculation. As such, calculators are not allowed. Format: The exam will consist of multiple-choice (with no partial credit), short answer, and long form answer questions. Content: Modules 1-9 (see below for module names) from the beginning of the semester up to and including this Thursday's lecture (2/19) will be included on the exam (each module will be represented approximately evenly, and we will mainly focus on the content in the HWs and lectures). Module 1: Intro to Big Data Analytics Modu...

I am building a backend service that acts as a decision layer between an internal platform and multiple external service providers. This is not a simple integration bridge. The goal is to design a scalable, extensible decision engine that: • Normalises heterogeneous API responses into a canonical internal schema • Applies configurable business rules to determine optimal outcomes • Abstracts external providers behind adapter contracts • Allows new providers to be added without modifying core logic The first external provider integration will serve as a reference implementation. However, the architecture must support rapid onboarding of additional providers via a pluggable adapter model. ⸻ Core Requirements 1️⃣ Canonical Data Model Design a clean internal schema...

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

Ho un cliente che deve rafforzare in tempi rapidissimi la loro practice Oracle Analytics: il focus principale è innalzare il livello di sicurezza di report, dashboard e modelli dati già in produzione, mantenendo allo stesso tempo l’agilità di sviluppo. Il lavoro sarà full-remote e richiede disponibilità immediata. Cosa farai nel dettaglio • Sviluppo e ottimizzazione di report e dashboard in Oracle Analytics (ex-OBIEE), con design responsive per Oracle BI Mobile. • Repository modeling (RPD): progettazione e revisione dei livelli fisico, logico e di presentazione, assicurando coerenza e performance. • Gestione avanzata di sicurezza, utenti e ruoli; definizione di regole Row Level Security e oggetti catalog protetti. • Creaz...

Minha aplicação Rocket. Chat e MeteorJs, com volume de acessos crescendo diariamente, usa MongoDB como único banco de dados. Em horários de pico o serviço simplesmente congela: todas as operações ficam bloqueadas até que o processo seja reiniciado. Já brinquei com a configuração – aumentei o cache e reduzi a taxa de novas conexões – mas o problema volta sempre que o tráfego dispara. Preciso que alguém faça um diagnóstico completo, identifique a real causa do travamento e implemente a correção definitiva. Espero uma análise minuciosa de métricas, logs, índices e do modelo de dados, além de recomendações (e execu&...