Modelare de date Jobs

我目前在重构一套核心业务系统，后端数据库将全部改用 MySQL。为了确保这一次升级既稳又快，我需要一位真正熟悉关系型数据库的高级开发人员全程协助。 主要工作内容 • 数据库设计 – 根据现有业务逻辑，梳理并重新设计表结构、索引与约束，确保高并发下的可扩展性与数据一致性。 • 性能优化 – 对现有查询与存储过程做 Profiling，调整索引、SQL 语句与服务器参数，给出量化的性能提升报告。 • 数据迁移 – 从旧库安全迁移到新库，编写脚本、制定回滚方案，并在迁移后进行完整校验。 验收标准 1. 提供完整的 ER 图、DDL 脚本以及相关文档。 2. 在测试环境下，比现状平均查询延迟至少降低 30%。 3. 迁移过程零数据丢失且可追溯。 开发与测试均以 MySQL 8.x 为准，常用工具（如 MySQL Workbench、Percona Toolkit、pt-online-schema-change 等）请自备。沟通语言可中文或英文，期待与你一起把这套数据库做到极致。

I’m planning a full-scale systems integration that will let our HubSpot CRM talk seamlessly with our enterprise-grade ERP. The goal is to create a real-time, bidirectional flow of customer, order and inventory data without disrupting either platform’s native workflows. I already have clear process maps and sample datasets; what I need now is an experienced Solutions Architect who can turn those business requirements into a concrete technical blueprint. That means defining the overall integration architecture, documenting data models, selecting the optimal middleware or iPaaS layer, and outlining security, error-handling and scalability considerations. REST and webhook experience with HubSpot is essential, but I’m open to your recommendations on the ERP side—wheth...

I'm seeking an expert in predictive modeling to develop a point spread prediction model for NFL games. This model will be crucial for making informed betting decisions. Key Requirements: - Develop a statistical model to predict point spreads - Use historical data and advanced algorithms - Provide clear documentation and usage guidelines Ideal Skills and Experience: - Strong background in statistics and machine learning - Experience with sports data, especially NFL - Proficiency in Python, R, or similar programming languages - Ability to deliver within a month

I need a well-structured SQL database that turns raw sales transactions into clear insight for our monthly analytics and reporting. The core job is to design the schema, import existing sales data, and build the queries (or stored procedures) that generate our standard monthly sales report with totals, trends, and key breakdowns. Right now the data lives in CSV exports from our point-of-sale system. I want it migrated into a relational database—engine choice is open (PostgreSQL, MySQL, MS SQL, or another you recommend) as long as it handles growth and lets me run additional ad-hoc reports later. Good indexing and normalization are essential because report runs must stay quick when the dataset scales. Deliverables: • SQL scripts for creating all tables, constraints, and index...

I'm looking for a PowerBI expert to create an interactive and insightful report page using data from Excel spreadsheets. The visuals should help in analyzing spend data and can be filtered and sliced by Matter, Region, Department, and Paid Date (with options to filter by quarter and year). Requirements: - Visuals should include, but not limited to: Bar charts, Pie charts, Line graphs, etc., depending on what best displays the data. - Key metrics to be included: Total Spend, Total Spend per Quarter, Total Spend by Year, Spend by Department - The report should be user-friendly and allow for easy data exploration Ideal Skills and Experience: - Proficiency in PowerBI and Excel - Strong data visualization skills - Experience with spend analysis reports - Ability to create interactive fil...

We are looking for an experienced Power BI and Excel Dashboard Developer to help finalize an enterprise-level Business Intelligence and reporting platform built on Microsoft Excel and Microsoft 365. This is not a simple dashboard project. The platform has already been architected and includes project management, KPI management, executive reporting, organizational hierarchy, master data management, and operational workspaces. We need an experienced consultant to help complete, optimize, and polish the dashboards and reporting layer into a production-ready solution. ⸻ Project Overview The platform already includes: * Enterprise Master Data * Project Portfolio Management * PMO Framework * KPI Management Framework * Employee Performance Management * Organizational Hierarchy * Executive R...

I need a well-structured Excel workbook that lets me drop in raw customer data and instantly see meaningful insights. The core objective is data analysis focused specifically on customer behaviour, so the file should make trend analysis and segmentation analysis both quick and intuitive. Here is what I have in mind: • A clean, instruction tab where I can paste or import new customer records (CSV friendly). • Automated tables, formulas, or Power Query steps that transform that raw feed into an analysis-ready data model. • Pivot tables, charts, or a compact dashboard that highlights purchase trends over time and breaks the customer base into clear segments I can act on. • Everything unlocked and documented so I can tweak filters, date ranges, or add new fields la...

Excited to share my latest Starbucks Sales Dashboard built using Power BI, Excel, SQL, and DAX. This interactive dashboard provides valuable business insights into sales performance, product trends, customer behavior, and store profitability. It enables decision-makers to monitor KPIs, identify top-performing products, analyze monthly revenue, and optimize business strategies with real-time visual analytics. The Starbucks Sales Dashboard is a professional Business Intelligence solution designed to analyze and visualize Starbucks sales data. It transforms raw business data into meaningful insights through interactive charts, KPI cards, filters, and dynamic reports. The dashboard helps stakeholders understand sales trends, customer purchasing patterns, product performance, regional sales, a...