数据建模 Jobs

We are looking for a skilled professional with strong experience in healthcare data systems and data modeling concepts. The ideal candidate should have hands-on experience working with Electronic Health Records (EHR) data and a good understanding of clinical and Revenue Cycle Management (RCM) domains within hospital systems. Key Responsibilities •⁠ ⁠Work with healthcare data from leading EHR platforms such as EPIC, Oracle Cerner, MEDITECH, or other top-tier EHR systems. •⁠ ⁠Understand and model clinical and RCM entities, including relationships within hospital and healthcare ecosystems. •⁠ ⁠Apply Kimball modeling techniques and core data modeling concepts for analytics and reporting solutions. •⁠ ⁠Support data integration, transformation, and structuring for health...

I developed an interactive BMW Global Sales Analysis Dashboard using Microsoft Excel to analyze sales performance across different regions, models, and time periods. The goal of the project was to transform raw sales data into a clear and insightful dashboard that helps users quickly understand business performance and trends. In this project, I performed data cleaning and transformation, then used Pivot Tables, Pivot Charts, and slicers to create an interactive dashboard. The dashboard includes key metrics such as: *Total Units Sold *Total Revenue *Average Car Price *Total Models Sold It also provides deeper insights through visualizations like: *Monthly sales trend analysis *Sales comparison by region *Revenue distribution by car model *EV growth trend over multiple years *Fuel pri...

I’m preparing a migration from our Sapiens ID3 platform into the FAST Technology system and need a precise field-by-field mapping created. The source data centers on policy records, and I must be sure that every element tied to the customer—name and contact details, policy-specific attributes, and related transaction history—lands in the correct destination tables in FAST. Right now each field is stored in ID3’s proprietary format. I will supply sample extracts as well as the FAST data dictionary; your task is to analyse both structures, match every like-for-like field, and flag any gaps where a transformation or new target field is required. Deliverables • A comprehensive mapping document (spreadsheet or equivalent) showing source field, data type, descrip...

I need a Power BI dashboard for leadership review. The primary focus is to visualize the organization chart. Requirements: - Connect to Excel spreadsheets - Create a comprehensive organization chart Ideal Skills: - Proficiency in Power BI - Experience with Excel data integration - Strong data visualization skills

We run our entire accounting stack on Tally Prime and now need all that knowledge in one clear, interactive Power BI view. The project covers three data feeds—financial, inventory and sales—pulled directly from Tally Prime, modelled cleanly and presented through intuitive visuals so anyone on the leadership team can spot trends, drill into details and export insights on demand. Here’s what I expect: • A reliable extraction process (ODBC, XML exports or your preferred connector) that refreshes automatically. • A star-schema model in Power BI with well-written DAX measures for ratios, period comparisons and cumulative calculations. • A set of pages that surface cash flow, P&L, aging, stock movement, reorder alerts, revenue by product and region, plus ad-...

I already have a clean, curated dataset sitting in Salesforce CRM Analytics . What I now need is an engaging dashboard that turns those rows into insight. The data is loaded and modeled, so the task is purely visual: build the bar and line charts I specify, arrange them into a single interactive dashboard, and apply any filters or bindings required so users can drill down without delays. The subject matter is banking-related, so every chart should highlight the metrics that matter to that sector—think revenue flow, account growth, and other teller-to-boardroom indicators—yet all of the source fields are ready for you to pick up. I will share a short spec for each widget; you translate it into lenses, add the SAQL tweaks if needed, and publish the finished dashboard to our CRM ...

We are seeking an experienced Microsoft Power Platform developer to create a simple and efficient administrative system for an early-stage Pilates studio. This project aims to develop an MVP (Minimum Viable Product) for the exclusive use of the internal team (administration and instructors), without direct access for students in this first version. There is the possibility of continued improvements and new features after the initial project delivery. Essential Technologies: * Microsoft Power Apps * Microsoft Power Automate * Microsoft Dataverse Required Key Features: * Student registration: Management of basic student information. * Instructor registration: Registration and data of instructors. * Class registration: Definition and organization of Pilates sessions. * Instructor calend...

I need an interactive HR analytics dashboard that lets me explore employee attrition, workforce demographics, and job-satisfaction trends in one place. The finished product should surface essentials such as total headcount, overall attrition rate, age distribution, department-level turnover, education-field breakdowns, and satisfaction scores, all with drill-through and filter capability so the HR team can quickly pinpoint patterns behind employee exits and make data-driven decisions. I marked “data analytics” as the preferred environment because I care more about seamless insight discovery than about whether the final interface is strictly web-based or desktop; feel free to recommend the most practical hosting approach as long as the experience remains smooth and secure. Pow...

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

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

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