Modelado de Datos Jobs

I have several business-critical Excel spreadsheets that I want transformed into clear, interactive dashboards inside Power BI. The job starts with connecting those workbooks, cleaning and modelling the tables so they refresh smoothly, and then designing visuals that let any stakeholder spot trends, outliers and KPIs at a glance. You’ll have freedom over DAX measures and layout as long as the end result meets these acceptance points: • One unified data model that auto-updates when the source files are replaced in the same folder • At least three slicer-driven report pages combining charts, tables and cards for quick drill-downs • Clear colour styling and titles so non-technical users understand every visual without extra guidance • A short hand-off note exp...

I need a clean, scalable backend drafted from scratch, starting with a solid PostgreSQL schema. The heart of the project is a referral module that pays out cash rewards when invitees convert, so the data model, triggers, and calculation logic must revolve around that requirement. Here’s what I’m expecting: • Database design in PostgreSQL, including all DDL scripts and a concise ER diagram. • Core API endpoints (or documented stored procedures) that record a referral, verify the qualifying event, and trigger the cash-reward payout. • Clear unit or integration tests demonstrating the reward rules in action. While tracking links or status updates are not mandatory right now, structure the tables so those features can slot in later without rewrites. Hand-ove...

I am looking for an experienced Power BI Dashboard Developer who can build an interactive and professional dashboard urgently based on the sample PDF/dashboard provided. Project Scope Develop a modern and interactive Power BI dashboard for election analytics and constituency profiling for Johor State constituencies (DUN). Dashboard Requirements The dashboard should include: * KPI summary cards * Total voters * Total PDM * Total polling streams * Total branches * Other key statistics * Interactive charts & analytics: * Voter breakdown by race * Voter breakdown by age group * Election results comparison (PRN vs PRU) * Majority analysis * Winning/Losing PDM analysis * Trend & performance visualization * Interactive filtering/slicers b...

I am competing in a HackerEarth data-science contest and I want to push my score into the top tier of the leaderboard before the challenge closes next month. I have already set up the competition workspace and can grant you immediate access to the dataset, rules, and current public-leaderboard baseline. Here is what I need from you: build, tune, and iterate a high-performing regression model, supply well-commented code (Python is preferred, but you are free to choose the stack you are fastest with), and hand over a prediction file ready for final submission. Along the way, please keep a concise notebook or script that allows me to reproduce your workflow end-to-end on my own machine. In your bid, include links or brief summaries of past work that demonstrate strong results in similar com...

I’m looking to turn a scattered set of rollout spreadsheets into one clear, interactive dashboard that lets me see exactly where every site sits in the life-cycle—from initial installation all the way to On-Air. I have no fixed preference on the platform, so feel free to build in either Excel (Power Query/Pivot, slicers, VBA if needed) or Power BI; choose whichever will let you structure the data model cleanly and keep future updates simple. Core view I need • Progress by site and phase: Installation → Integration → Testing → On Air, with automatic percentage-complete calculations. • At-a-glance flags for any milestones slipping behind their target dates. • Filters by region, vendor, tech (2G/3G/4G/5G) and project manager. Nice-to-have layers If ...

We are #Hiring - Freelance School Automation Architect (n8n) (Hourly) Itisva AI builds practical workflow automation for private Indian schools, helping teachers and admins eliminate repetitive manual work around attendance, fees, parent communication, and admissions. We're looking for an experienced automation architect to design and build end-to-end solutions using n8n, databases, and school integrations. Your Role: -Architect and implement school workflow automations from discovery to production -Design teacher-first input methods (tap interfaces, voice notes, micro-forms) that eliminate Excel dependency -Build n8n workflows connecting school ERPs, WhatsApp, SMS, payment gateways, and Google Sheets -Create clean data models for student/parent/staff records and workflow state...

I’m looking to turn a scattered set of rollout spreadsheets into one clear, interactive dashboard that lets me see exactly where every site sits in the life-cycle—from initial installation all the way to On-Air. I have no fixed preference on the platform, so feel free to build in either Excel (Power Query/Pivot, slicers, VBA if needed) or Power BI; choose whichever will let you structure the data model cleanly and keep future updates simple. Core view I need • Progress by site and phase: Installation → Integration → Testing → On Air, with automatic percentage-complete calculations. • At-a-glance flags for any milestones slipping behind their target dates. • Filters by region, vendor, tech (2G/3G/4G/5G) and project manager. Nice-to-have layers If ...

I have a de-identified hospital dataset and I need it transformed into a polished Power BI project that lives both in Desktop and the online Service. The focus is strictly on patient data—admissions, stays, discharges, readmissions, anything that helps hospital leadership understand what is happening with our patients at a glance. Here is what I’m after: • A clean data model with intuitive tables and relationships so the report refreshes smoothly. • Visuals limited to pie charts, bar graphs and line charts, laid out in a single interactive dashboard. Each visual should filter and cross-highlight the others. • Consistent healthcare-appropriate color palette and clear labeling so non-technical stakeholders grasp insights instantly. • A short screen-cap...

I have a growing collection of videos and need a solid JSON structure in place so every file carries accurate, future-proof information. The goal is to create (and, where necessary, parse or validate) JSON that ties each video to its metadata—think titles, descriptions, time-coded chapters, subtitles or any other data points we decide to expose to my platform or CDN. You will work directly with the raw video assets I provide, define a clear JSON schema that fits their needs, then deliver sample files and concise instructions so the same pattern can be reproduced by my team. Clean, human-readable code and reliable validation routines are important; I plan to plug these straight into an automated workflow once everything is tested. Please tell me a little about similar projects you h...

I need an interactive Excel dashboard that lets me analyse three core KPIs—sales performance, customer satisfaction and employee productivity—in a single, easy-to-read view. The workbook should focus on data analysis rather than static reporting, so everything has to update automatically when new data is pasted into the model. My preferred visual format is clear, well-labelled charts (bar, line or combo where appropriate). Tables can sit behind the scenes for calculations, but the front end must stay chart-centric and visually balanced. Slicers or drop-downs for date ranges, regions or product lines will help me drill into the numbers quickly, so please add them where you think they add value. Deliverables • One Excel (.xlsx) file containing:  – Dynami...

I need a model for predicting the success of bariatric surgery in adolescents with diabetes using parameter estimation. The model should be based on clinical data. Data Available: - Clinical data: Medical history, Laboratory results - Preferred methods: Combination of statistical analysis and machine learning Ideal Skills: - Expertise in statistical analysis and machine learning - Experience with clinical datasets - Strong background in medical data interpretation

I need a Power BI solution that pulls financial data directly from Dynamics 365 Finance & Operations and renders an interactive Profit & Loss statement. The report must break results down by Cost Centers and Departments so managers can drill from consolidated figures to the underlying details in just a few clicks. You will: • Connect Power BI to our Dynamics F&O environment (Entity Store or OData—let me know which you prefer). • Model the general-ledger data so it aligns with our chart of accounts and fiscal calendar. • Build a clean, dynamic P&L page with slicers for Cost Center and Department, plus tooltips and variance logic. • Optimise all DAX measures to keep refreshes under two minutes. • Deliver the finished .pbix along with a...

I have raw sales data coming in daily, and I need it transformed into clear, interactive Power BI dashboards that let me track performance at three levels—daily, monthly, and quarterly—without having to wrestle with spreadsheets. Scope of analysis • Sales volume trends so I can spot spikes or drops immediately. • Product-level insights that rank best- and worst-performing items at a glance. • Regional comparisons to show which areas are driving revenue and which need attention. .Sales person wise product and product category wise and product wise sales Preferred visuals Bar charts, line graphs, and pie charts work best for my team, so the finished reports should lean on those, switching automatically when I filter dates, products, or regions. D...

data analyst Search: Experiment with text ads, bidding, and campaign structures on Google, Bing, Baidu, Naver, and other search engines. Adapt to new product features and roll out changes from successful tests. Display: Test, analyze, and optimize campaigns on Facebook, Twitter, Instagram, and others. Modeling: Analyze the vast amounts of data generated by experiments, develop models we can use for optimization, and build dashboards for account managers.

I have an existing Power BI dashboard that already houses the raw data and category-level visuals. What I now need is a concise Balance-Sheet (BS) Overview page built directly inside that same PBIX file. The new view should pull the relevant category information already present in the model and present a clean, interactive summary that decision-makers can grasp at a glance. Preferred format The overview must live natively in Power BI—please do not export it to PDF, Excel, or PowerPoint. Instead, add a dedicated report page (or revise an unused one) and keep all calculations in DAX so totals stay dynamic when filters are applied. Scope of work • Identify the tables and fields that represent the balance-sheet categories. • Create measures for key BS lines (e.g., asset...

I have a sizeable MySQL database that needs to be turned into clear, decision-ready insights. The work begins with pulling the raw tables, writing efficient SQL queries, and cleaning or restructuring the data where necessary. Once the dataset is reliable, I’d like you to run deeper statistical analyses in Python (or Excel where it makes sense) to surface patterns, trends, and any significant correlations. The final step is to convert those findings into intuitive visuals and interactive reports in Power BI so my non-technical stakeholders can drill down by date, segment, and KPI without ever touching the underlying code. Deliverables I expect: • A cleaned, well-documented dataset (or SQL scripts) ready for downstream use • A concise statistical analysis report wi...

More details: What is the primary purpose of your graph database? This question was skipped by the user Do you already have a dataset to populate the graph database? This question was skipped by the user Which aspects are most important for your project? This question was skipped by the user

I need a focused Power BI report that clearly shows Expense vs Revenue trends for my finance team. All raw figures sit in a series of Excel spreadsheets, so the first step will be connecting those workbooks, modelling the data, and building a clean, refresh-ready dataset. From there, I want an intuitive dashboard with drill-downs, dynamic date filters, and visuals that let us spot cost overruns or income spikes at a glance. Because this will feed directly into monthly management meetings, I will require the finished .pbix file, any supporting M-code/DAX documentation, and a short walkthrough (screen-recording is fine) so the team knows how to refresh and extend the model. When you respond, include a detailed project proposal outlining your approach to: • importing and transforming ...

I need a focused Power BI report that clearly shows Expense vs Revenue trends for my finance team. All raw figures sit in a series of Excel spreadsheets, so the first step will be connecting those workbooks, modelling the data, and building a clean, refresh-ready dataset. From there, I want an intuitive dashboard with drill-downs, dynamic date filters, and visuals that let us spot cost overruns or income spikes at a glance. Because this will feed directly into monthly management meetings, I will require the finished .pbix file, any supporting M-code/DAX documentation, and a short walkthrough (screen-recording is fine) so the team knows how to refresh and extend the model. When you respond, include a detailed project proposal outlining your approach to: • importing and transforming ...

I need a focused Power BI report that clearly shows Expense vs Revenue trends for my finance team. All raw figures sit in a series of Excel spreadsheets, so the first step will be connecting those workbooks, modelling the data, and building a clean, refresh-ready dataset. From there, I want an intuitive dashboard with drill-downs, dynamic date filters, and visuals that let us spot cost overruns or income spikes at a glance. Because this will feed directly into monthly management meetings, I will require the finished .pbix file, any supporting M-code/DAX documentation, and a short walkthrough (screen-recording is fine) so the team knows how to refresh and extend the model. When you respond, include a detailed project proposal outlining your approach to: • importing and transforming ...