Μοντελοποίηση Δεδομένων Jobs

I need an end-to-end Excel solution that turns my raw operational data into clear, action-oriented insights. The workbook should import or paste data easily, clean it behind the scenes, then surface the story through a mix of charts, pivot tables, and an interactive dashboard. Here’s what I expect to receive: • A structured data model ready for refresh without breaking formulas or links • Dynamic pivot tables that let me slice performance by date, department, and any additional fields you spot as valuable • Visually consistent charts and graphs that highlight trends, outliers, and KPI progress • A dashboard page with slicers, drop-downs, or buttons so non-technical users can explore the numbers themselves • Clear documentation of any VBA, Power Q...

1. IMPLAN Model Setup & Execution The consultant will: Use the most current IMPLAN dataset for Prince George’s County, MD Confirm alignment with the County’s recently released IMPLAN-based analysis methodology Select appropriate NAICS codes aligned with: Motion Picture & Video Production Post-Production Services Sound Recording Creative Technology Services Studio / Production Facility Operations Construction & Build-Out (capital phase) Input project-specific data including: Capital expenditures (construction, build-out, equipment) Annual operating budget projections Projected payroll and employment levels Vendor and supply chain assumptions (if applicable) Run IMPLAN modeling to calculate: Direct impact Indirect ...

My existing Power BI report pulls several large tables from Microsoft Dynamics 365 Business Central through the standard API. The model works, but the scheduled refresh now fails with frequent time-outs; reliability is my biggest concern. So far I have: • enabled incremental refresh on the largest tables • tuned a handful of queries • experimented with splitting data into smaller API calls None of these measures has eliminated the failure. I need an expert who can: 1. pinpoint the exact bottleneck within the current data model, gateway settings, or API calls 2. redesign the retrieval strategy so the report finishes every refresh window without timing out 3. leave me with a clean, documented PBIX (or dataflow) that follows best practice for query folding, partitioning, and ...

I already hold a raw-data workbook that lists each product, its department and the associated revenue, plus a separate sheet with customer details. What I need now is to turn those rows into insight while watching the entire process in real time. Here is what I want us to tackle together: • Spot revenue trends month-over-month and year-over-year. • Compare product sales by department so I can instantly see top and under-performers. • Layer in customer demographics to explain the “why” behind the numbers. We will meet on Zoom or Teams, share screen, and co-build both an Excel model (pivot tables, slicers and chart dashboards) and a Power BI report (clean data model, DAX measures, interactive visuals). I will be asking questions throughout, so please be c...

I already hold a raw-data workbook that lists each product, its department and the associated revenue, plus a separate sheet with customer details. What I need now is to turn those rows into insight while watching the entire process in real time. Here is what I want us to tackle together: • Spot revenue trends month-over-month and year-over-year. • Compare product sales by department so I can instantly see top and under-performers. • Layer in customer demographics to explain the “why” behind the numbers. We will meet on Zoom or Teams, share screen, and co-build both an Excel model (pivot tables, slicers and chart dashboards) and a Power BI report (clean data model, DAX measures, interactive visuals). I will be asking questions throughout, so please be c...

Urgeent request (within next 2 hours) I need a Sankey chart to analyze data distribution using mixed data types. Requirements: - Visualize complex relationships and flows - Handle both categorical and numerical data - Provide clear, insightful visual representation Ideal Skills: - Experience with data visualization tools - Proficiency in handling mixed data types - Strong analytical skills Please include detailed project proposals in your application.

I need a reliable workflow that pulls Sales, Customer, and Inventory data from my Microsoft SQL Server into both Google Sheets and Excel on an automatic schedule. Once the feed is live, I want the data modeled and visualized in Google Data Studio so I can slice performance by product line, customer segment, and time period without manual intervention. The last piece is real-time, rule-based notifications that reach mobile devices—push or SMS—whenever metrics cross predefined thresholds (for example, daily sales drop below target, inventory hits a reorder point, or a new high-value customer signs up). Deliverables: • Scripted or no-code connector that syncs SQL Server to Google Sheets and an Excel workbook on OneDrive/SharePoint, running at set intervals. • A...

My existing Power BI report pulls several large tables from Microsoft Dynamics 365 Business Central through the standard API. The model works, but the scheduled refresh now fails with frequent time-outs; reliability is my biggest concern. So far I have: • enabled incremental refresh on the largest tables • tuned a handful of queries • experimented with splitting data into smaller API calls None of these measures has eliminated the failure. I need an expert who can: 1. pinpoint the exact bottleneck within the current data model, gateway settings, or API calls 2. redesign the retrieval strategy so the report finishes every refresh window without timing out 3. leave me with a clean, documented PBIX (or dataflow) that follows best practice for query folding, partitioning, and ...

Urgeent request (within next 2 hours) I need a Sankey chart to analyze data distribution using mixed data types. Requirements: - Visualize complex relationships and flows - Handle both categorical and numerical data - Provide clear, insightful visual representation Ideal Skills: - Experience with data visualization tools - Proficiency in handling mixed data types - Strong analytical skills Please include detailed project proposals in your application.

I’m putting together a short-run, high-impact training series for a group of advanced Power BI users who already build reports daily and are hungry for deeper mastery. The focus is squarely on data modeling strategies and sophisticated DAX techniques that move beyond calculated columns and measures into row-level security, dynamic relationships, optimization, and real-world performance tuning. The assignment is time-critical: I’d like to roll out the first session as soon as we lock in the schedule, so please be comfortable jumping in immediately. Sessions can be live online, but recordings and reusable reference material (PBIX examples, slide deck, and answer keys to exercises) must follow each class. To keep expectations crystal clear, I’ll sign off once I can: &bul...

My daughter is making a career switch into data engineering from a completely non-science background. She already writes basic Python and SQL, but everything else—cloud services, robust pipelines, modelling, and modern storage patterns—remains a mystery to her. I want a personalised training programme that: • Builds solid foundations in data pipelines, cloud infrastructure, data modelling, and database & storage concepts. • Uses both Microsoft Azure and AWS so she can compare services and deploy end-to-end solutions on each. The format, pace, and depth are open to your professional guidance; however, by the end of the engagement she should be comfortable designing, building, and operating production-ready workflows on either platform. A brief outline of ...

I need to streamline the operational datasets that feed our current Power BI reports. The main objective is to redesign and optimise the existing data models so refreshes are faster, calculations stay accurate, and maintenance is painless. You will start by auditing the PBIX in Power BI Desktop, refactoring tables into a clean star schema, and rewriting any expensive DAX measures or calculated columns. Power Query steps must be consolidated and parameterised, with an eye toward incremental refresh and reliability through the on-premises gateway once everything is published to the Power BI Service workspace. Advanced DAX, solid M language skills, and a working knowledge of SQL objects are crucial because some changes may require tweaks to underlying views or stored procedures. Experience ...

Project Objective We are building a complete reporting environment that connects our operational SQL database to a clean, intuitive Power BI reporting suite designed for two primary audiences: 1. Executive Leadership – high-level commercial insights and company performance 2. Operational Managers – actionable operational metrics and drill-downs The goal is to transform raw operational data into clear, reliable decision-making dashboards that update automatically and can be trusted across the organization. The final solution should deliver real-time business intelligence including revenue performance, operational activity, and commercial trends. ⸻ Data Environment Source System SQL Server operational database containing: • Sales transactions • Customers &bu...

I need an interactive Power BI dashboard built from Excel/CSV exports that I’ll provide. The sole focus is customer engagement, so the model and visuals should surface churn, retention, active-user trends, session frequency, and any other insight you recommend for quickly reading engagement health. You’ll connect the flat files, shape them in Power Query, build a clear data model, write the DAX needed for metrics and time intelligence, and design a clean, uncluttered layout that works on both desktop and the Power BI Service. The report must refresh seamlessly whenever I replace the source files and come with a short note explaining tables, relationships, and calculated measures so I can extend it later. Deliverables: • Finished .pbix file with the customer-engagement da...

I need a data engineer to implement liquid clustering with z-ordering to enhance performance. This project is critical for optimizing our data processing and retrieval speeds. Key Requirements: - Expertise in data engineering - Strong understanding of z-ordering and liquid clustering - Experience in performance optimization techniques Ideal Skills: - Proficiency in SQL and relevant data processing frameworks - Background in managing large datasets - Ability to work independently and meet deadlines Please provide examples of similar work and your approach to the task.

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