Data Modeling Jobs

Hi I will share the details with the shortlisted candidates. Thanks

Sales Analysis Dashboard using Power BI Developed an interactive Sales Analysis Dashboard in Microsoft Power BI to gain actionable insights into business performance across multiple dimensions such as category, state, city, and payment modes. The dashboard provides a comprehensive overview of total revenue (2M+), total quantity sold (5615), and total transaction amount (438K). It analyzes sales performance across key product categories including Electronics, Clothing, and Furniture, highlighting revenue contribution, quantity sold, and average revenue per category. Key features of the project include: Category-wise Analysis: Identified Electronics as the highest revenue-generating category (~819K), followed by Clothing and Furniture. Geographical Insights: Highlighted top-performing ...

We are seeking an experienced Data Engineer to build and maintain scalable, high-performance data pipelines and infrastructure for our next-generation data platform. The platform ingests and processes real-time and historical data from diverse industrial sources such as airport systems, sensors, cameras, and APIs. You will work closely with AI/ML engineers, data scientists, and DevOps to enable reliable analytics, forecasting, and anomaly detection use cases. Shape Major Skills : Spark, Flink, Iceberg Key Responsibilities · Design and implement real-time (Kafka, Spark/Flink) and batch (Airflow, Spark) pipelines for high-throughput data ingestion, processing, and transformation. · Develop data models and manage data lakes and warehouses (D...

Please Sign Up or Login to see details.

Stroke Rehabilitation MVP (Phase 1: Part 1 + Part 2) Platform: (mandatory) Objective Develop a functional MVP of a stroke rehabilitation support system that combines daily task management, caregiver interaction, and basic recovery tools within raccoonai.tech. The system must be accessible, simple, and reliable for daily use, specifically designed for users with cognitive and motor limitations. Phase 1 Scope (Divided into 2 Parts) Part 1 – Core System & Daily Task Foundation Focus: Build the core structure and “daily anchor” Requirements: Set up data models: Users (Patient, Caregiver) Tasks (medication, appointments, daily routines) Reminders (time-based) Develop core features: Daily dashboard (Today’s tasks) Task creation/editing (user + caregiver-ready structu...

I need my live Odoo 15 Enterprise instance on upgraded to version 19 while ensuring smooth operation. The core platform upgrade is straightforward; the main focus is on three custom modules that handle Australian phone-number formatting and phonebook sync, manage wholesale vs. retail price displays, and add weight calculations to paperwork. Since these modules have never undergone a major version upgrade, their data models and views require careful migration. Custom module details: Split one module into separate components: • A module for reformatting phone numbers to Australian international format (possibly native in v19) and syncing phonebook/call logs with our VOIP provider. • A pricing module with editable retail price lists for two zones (wholesale = retail – 10%),...

Please Sign Up or Login to see details.

I need a clean, well-structured Excel workbook that lets me drop in raw performance-metrics data and immediately see customer segmentation, trend analysis, and behavioural insights without any extra manual work. Structure & flow • One “Raw_Data” tab where I can paste or Power-Query-refresh the latest export. • A calculation layer (hidden or clearly marked) that handles all formulas, dynamic named ranges, and any DAX/Power Pivot measures you think will keep things fast. • Separate, presentation-ready dashboards: – Segmentation: break customers into meaningful tiers or cohorts and surface key KPIs for each. – Trend Analysis: month-over-month and YTD views, spark lines, variance indicators. – Behavioural Analysis: visualise e...

Sales Analysis Dashboard using Power BI Developed an interactive Sales Analysis Dashboard in Microsoft Power BI to gain actionable insights into business performance across multiple dimensions such as category, state, city, and payment modes. The dashboard provides a comprehensive overview of total revenue (2M+), total quantity sold (5615), and total transaction amount (438K). It analyzes sales performance across key product categories including Electronics, Clothing, and Furniture, highlighting revenue contribution, quantity sold, and average revenue per category. Key features of the project include: Category-wise Analysis: Identified Electronics as the highest revenue-generating category (~819K), followed by Clothing and Furniture. Geographical Insights: Highlighted top-performing ...

We have Dynamics 365 Customer Engagement instance and need a developer who can step in to extend and streamline what we already have. You’ll be working on three main fronts: • Management – I’m specifically looking for help with data-centric administration. That includes migrating legacy records into CE, cleaning what’s already there, and wiring up ongoing data integrations so our information stays consistent. On the reporting side, I want polished, role-based dashboards that surface KPIs without the usual noise. • Modeling – Custom tables, relationships, forms, and views all need refinement. Expect to shape the underlying data model so future features can be added without re-work. If you’re comfortable with solution layering and ALM best pra...

We are looking for an experienced Palantir Foundry Developer to support data and AI use cases. Scope of Work: * Build and maintain Foundry data pipelines (Pipeline Builder, Transforms) * Work with Ontology (object types, link types, data modeling) * Develop Workshop applications for business users * Implement AIP Logic workflows and basic agent integrations * Write production-quality Python, SQL, and PySpark code Requirements: * Hands-on experience with Palantir Foundry (mandatory) * Strong skills in Python, SQL, and PySpark * Experience with Ontology, Pipelines, and Workshop * Basic understanding of AIP (preferred) Project Details: * Budget: ₹45,000+(Negotiable) * Location: India

I’m looking for an experienced Power BI developer to build a financial dashboard that provides clear visibility into performance, with a strong focus on budget vs actual analysis and KPI tracking. All underlying data will be provided in Excel format. The goal is to transform this data into a clean, interactive, and management-ready dashboard that supports decision-making. Scope of Work • Review and structure the provided Excel data • Build a robust data model within Power BI • Create DAX measures for key financial metrics • Develop an interactive dashboard with filters and drill-down capability Key Metrics to Include • Revenue, Costs, and Net Profit • Budget vs Actual (with variance analysis) • Monthly and Year-to-Date (MTD/YTD) performa...

I have a set of raw transactional records sitting in several CSV files. I need them imported into Power BI, cleaned, and reshaped into a star-style model. The core relationships I must see are Customer → Orders and Region → Revenue; anything else you add for best practice is welcome provided it remains documented. Once the model is in place, create DAX measures for: • Total revenue • Number of orders • Distinct customers • Return rate With those measures, build visuals that show: • Revenue distribution by region • Seasonal revenue patterns (month and quarter) • Any revenue-concentration risk—e.g., regions or customers that contribute a disproportionate share • Key performance trends over time I will consider the job c...

BACKGROUND I maintain an Excel‑based dashboard used by International Office staff at several European vocational colleges to manage and monitor Erasmus+ administration. The workbook is used daily and already contains accurate data and calculations. The main need is to improve the layout, visual hierarchy, and usability, while keeping everything fully maintainable in native Excel. WHAT THE DASHBOARD TRACKS The dashboard monitors the following 6 key performance indicators (KPIs), each with planned vs. registered values where applicable: 1. Total Erasmus+ budget available 2. Available budget for partner countries 3. Available budget per college location (planned vs. registered) 4. Total number of participants with fewer opportunities (planned vs. registered) 5. Total number of participants i...

The project aims to design and implement a comprehensive, model-driven Computer Aided Facility Management (CAFM) system based on Microsoft 365. The solution establishes a unified conceptual data model as the digital backbone, connecting buildings, spaces, assets, documents, contracts, tickets, and operational FM processes within one integrated platform. By orchestrating SharePoint Online, Power Apps, Power Automate, Power BI, and related Microsoft 365 services, the system will provide modular functionality for space management, maintenance, asset management, booking, energy monitoring, workplace management, and further facility-related processes. The platform is designed to be scalable, multi-tenant capable, role-based, and certification-ready according to GEFMA 444, ensuring long...

I need a production-floor MIS dashboard built in Power BI that lets our garment-manufacturing managers see every line’s output and efficiency at a glance. The single most important view is line-wise production and performance tracking, but the same report must also surface quality indicators so we can spot defect trends early. Here is the flow I picture: • A landing page that shows yesterday’s pieces produced per line, the corresponding efficiency %, and an overall quality score. • Time-based slicers (day, week, month) that instantly recalc every visual. • Drill-through or drill-down so a supervisor can jump from a plant summary into an individual sewing line, then right into an operator if the data exists. • Clean, executive-level visuals that someo...

Financial Analytics Dashboard Power BI Business Insights and KPI Tracking I developed a Financial Analytics Dashboard to help businesses track performance, monitor KPIs, and make data-driven decisions. Key Features: Profit and Loss Analysis (Revenue, Cost, Net Profit) Budget vs Actual comparison Monthly and Year-to-Date (MTD/YTD) insights Job analysis (Active, Closed, Aging) Receivables and Payables tracking Interactive filters (Region, Country, Department, Currency, Year) Dashboard Insights: Operating Income and Net Profit After Tax Revenue vs Budget comparison Cost analysis with variance tracking Job performance and aging insights Financial health indicators (Receivables and Payables) Tools Used: Power BI, Excel, Data Modeling, DAX Outcome: Identify financial trends Track perform...

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