Data Modeling Jobs

I have a SQL Server view that already aggregates every validation script we run on raw_valid and model_valid. What I now need is the front-end: an interactive Power BI dashboard built in a tabbed interface that surfaces those scripts, lets users explore them, and provides both basic text search and advanced filtering. Connection & data model • Connect directly to the existing view (read-only). • Expose the script name, object type, target table, last run date, status, and the full script body or a hyperlink to it. • Optimise the model so the dashboard opens quickly even when the view grows. Visual & navigation requirements • Two main tabs—one for raw_valid scripts, one for model_valid—each mirroring the same layout for consistency. ...

I have several up-to-date Excel workbooks that hold our raw sales data, and I want them transformed into an interactive Power BI dashboard focused squarely on sales performance. The core metrics to surface are: • Total revenue • Sales growth over time • Top-selling products, with the ability to drill down by category or period Everything sits in Excel today, so the first step will be organising clean data connections and refresh schedules from those files into a single Power BI model. Once that model is solid, I need clear, visually engaging reports—think KPI cards, trend lines, and ranked product visuals—that make it easy for the team to spot patterns and act quickly. Deliverables • A fully functional .pbix file connected to my Excel sources &bul...

I am working with a sizeable set of enterprise-level operational data and need a clear, defensible forecast of upcoming trends. Everything will be handled in Excel—no BI suites or code this time—so the entire workflow, from cleaning through modelling to final visualisation, must live inside a well-structured workbook. The primary scope centres on our operational metrics, yet the approach should remain flexible enough that I can later slot in sales or customer figures without re-engineering the model. Accuracy and transparency are critical: every assumption, formula, and transformation step must be traceable so managers can audit the logic. Key deliverables • A master Excel workbook containing raw data staging, cleaned tables, forecasting model, and dynamic charts &bu...

I need a seasoned Power BI developer to turn a very large, highly-granular data set into a single, dynamic dashboard focused on monitoring key operational-efficiency KPIs. Here’s the landscape you will step into: our raw information sits in both SQL databases and a series of regularly exported Excel/CSV files. I want a model that connects to each source, transforms the data so that it’s truly analysis-ready, and then visualises the metrics that matter—cycle times, throughput, bottleneck alerts, utilisation rates and any supporting drill-downs we decide to add. Scope of work • Build or optimise the data model, including merge logic between SQL and CSV tables, DAX measures, and relationships that guarantee a fast, responsive user experience even when the data vol...

I need a Power BI specialist who can turn my raw data into clear, reliable reports right away. My priority is rapid delivery, so if you have the skills to connect to varied data sources, shape the data model, and publish interactive dashboards that decision-makers can use immediately, I want to hear how you will tackle it. Please send a concise yet detailed project proposal outlining: • Your approach to building the report end-to-end (data import, modeling, visual design, publication). • Any relevant techniques or features you expect to leverage in Power BI (DAX measures, drill-through, row-level security, scheduled refresh, etc.). • A realistic timeline that respects the ASAP requirement and includes key checkpoints for feedback. Once we agree on scope, I will provide...

**Project Title:** Urgent Database Tutor Needed – Must Help Me Finish Everything in 2 Days **Project Description:** This project is **very urgent**. I need a highly qualified **database tutor** who can help me finish and understand **everything within 2 days**. I have a university Database course and I will provide the lecture files. I need someone who can work with me intensively and help me cover all the material quickly, clearly, and efficiently. **Topics included:** * ER diagrams and data modeling * business rules * entities, attributes, relationships * cardinality and constraints * strong and weak entities * associative entities * relational model and database constraints * keys, superkeys, candidate keys, primary keys, foreign keys * entity integrity and referential integr...

I want to create Data governance tool

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