Tsql xquery query jobs

...gRPC/Websockets: Deep knowledge of Shelly Gen3 communication protocols to force unicast peer configuration, reducing multicast traffic and ensuring status updates reach Home Assistant instantly. Linux Basics: Ability to SSH into the Smattex Raspberry Pi 5 for troubleshooting and low‑level configuration if needed. ### Special Functional Requirements Consistent Group Toggle: Implementing a state‑query mechanism (e.g., using a reference dimmer or majority decision) to guarantee that all lights in a group switch together without “fighting” states. Welcome‑Button Logic: Detecting simultaneous long presses on both halves of a Gira Doppeltaster and triggering a configurable “Welcome” scene (all lights on/off, Hauptlichter, etc.). Time‑of‑Day & Sun‑Elevation...

...significant data transformation. You may need to: • split or merge fields, • convert formulas into more efficient functions, • normalise units and naming conventions, and • maintain link integrity for embedded or referenced images. A clean, well-structured final functional pricing workbook is the primary deliverable, ready to drop straight into everyday use. If you rely on VBA, Power Query, or other automation to perform the migration, please include those scripts or queries so I can repeat the process in future. A short change log explaining the mapping decisions and any calculated adjustments will complete the hand-off. Accuracy and consistency are critical; once the transfer is finished I’ll run random spot-checks against the original fi...

...and amount formatting. 2. A concise processing log (plain text or a second sheet) summarising any assumptions, transformations, or fields that could not be recovered verbatim. I will spot-check totals against the original PDF, so accuracy is critical. Automated extraction tools are fine as long as the final result passes visual inspection and basic sum checks. If you rely on Python, Power Query, or similar, feel free to include your script; that’s optional but appreciated....

...standard and custom fields so I can launch a personalized email campaign without manual fixing on my end. The task is straightforward: reorganize and relabel the existing columns, split or merge any compound fields where needed, and verify the final sheet will upload to Constant Contact without warnings. If look-ups or formulas are the quickest way to get there, feel free to use them; VBA or Power Query is also fine as long as the end file is tidy and non-volatile. Deliverables: • Reformatted file ready for Constant Contact import • A brief note that shows which original columns map to which Constant Contact fields so I can reuse the template next time Once the sheet passes a quick test upload, the job is done....

Each week I’ll send you a fresh export of our inventory data straight from the ERP. Your job is to turn that raw sheet into an easy-to-digest story in both Excel and Power BI. Here is what I’m after: • In Excel: a cleaned, well-structured workbook with dynamic tables, formulas or Power Query steps that let me drop in the new file and refresh. Pivot tables and slicers should make it effortless for me to drill down by SKU, warehouse and ageing bucket. • In Power BI: an interactive dashboard that mirrors the Excel logic but adds richer visuals—bar charts, pie charts, line graphs and any other view you feel best highlights stock movement, excess, and potential shortages. The report needs to refresh from the same data source I provide and should be easy f...

...“page not loading” bug tracked down and resolved in the Node/Express API or React view (whichever is responsible). • Database: move the current MongoDB data to an AWS RDS instance that you will provision. After migration the app must connect seamlessly with zero data loss. • Dashboard graphs: the existing user-activity chart is wired up in React/ but returns empty results. Fix the data query so the graph renders correctly, and add quick-select filters for “Last 7 days”, “Last 7 weeks”, and “Last 7 months”. • CI/CD: configure a clean pipeline from GitHub to AWS for both the frontend and backend so every push to the main branch runs tests and deploys automatically (GitHub Actions or your preferred tool on AWS Code...

I need an experienced automation developer to connect our 5PM project-management instance with n8n and the WhatsApp Business API so that our contractors experience faster, more consistent customer service. The goal is to let a query arrive on WhatsApp, have n8n classify and route it automatically, log the exchange inside 5PM, and feed key metrics to a live data dashboard. You will design, build, and document the complete flow: • n8n workflows that watch for incoming WhatsApp messages, apply simple AI routing logic, trigger templated replies, and open or update the matching task in 5PM. • Secure integration with the WhatsApp Business API, including message templates and webhook configuration. • Reliable sync of conversation and task data into a dashboard (I&rsq...

I need a rock-solid n8n workflow that, whenever I trigger it, navigates through selected e-commerce sites and public business directories, captures every piece of business information that is publicly available, and stores it in a clean, query-ready format. The data I care about includes the business name, category or type, “about” text, founders’ names, any additional corporate details the site reveals, plus all images properly downloaded and tagged. I will be running various data-analysis models on the output, so accuracy, consistency, and tidy structuring are non-negotiable. The flow must: • Accept a list of target URLs and run on demand (no fixed schedule). • Respect and site rate limits while still remaining efficient. • Handle pagination...

...entry errors • Standardize formatting across columns and rows (dates, numeric precision, text casing, etc.) Along the way you’ll also re-enter or adjust individual records where information is missing or inconsistent, keep clear notes of any assumptions, and leave me with a tidy workbook that’s filter-ready and pivot-table friendly. A good eye for detail, solid command of Excel functions (Power Query, conditional formatting, data validation, VLOOKUP/XLOOKUP), and a track record of working with mixed datasets are important. If you’ve done similar cleanup projects, attach a brief sample or describe the approach you took—seeing your method matters more than file size. I’ll review proposals as they come in and aim to choose someone who can star...

The Workday technical consultant will design and implement scalable Workday data ingestion pipelines and provide recommendations on best practices for extracting and integrating Workday data across hyperscaler environments (Azure, AWS, or GCP). Integration Approaches Under Evaluation REST API SOAP API RaaS (Report as a Service) WQL (Workday Query Language) RaaS has been the traditional approach but is not preferred for future implementations. Key Requirements 5+ years of Workday technical experience (integrations, reporting, or data extraction). Proven experience implementing Workday data ingestion to cloud data platforms. Strong understanding of REST/SOAP APIs, RaaS, and WQL. Experience working with modern data platforms and ETL/ELT pipelines. Ability to recommend optimal ingestion...

Who we’re looking for We’re looking for an AI Engineer / expert to partner with us in building a practical, high‑impact solutions using Microsoft Copilot Studio. The core of this project involves Taking raw, unstructured content (e.g. instruction manuals, policies, long‑form documents) Designing the most effective structure and format for that content Enabling users to query and retrieve information naturally through AI The end goal is simple but powerful: Turn lengthy information into something people can just ask questions of, reducing repeat enquiries and pressure on our Customer Service teams. How we like to work How we work really matters to us, we prefer: Iterative, collaborative problem‑solving 1:1 working sessions via Microsoft Teams Building together, tes...

I need an experienced AWS data engineer to design and build production-ready ETL pipelines in AWS Glue. The work centres on moving and transforming data from several source systems—relational databases (e.g., PostgreSQL, MySQL), NoSQL stores, real-time streams coming through Kafka/Kinesis, and a handful of internal/external REST APIs—into a clean, query-friendly layout in S3 and, ultimately, Redshift. Requirements: Strong AWS data engineering experiences with various aws services Experience building end-to-end data pipelines (schema discovery, ingestion, transformation, orchestration, monitoring) Experience working with relational databases like Oracle, MySQL, and SQL Server etc Experience with data ingestion from on-prem systems to cloud Experience with streaming pl...

...There might be a need to scrape data as well. Both the full address string and the explicit lat/long coordinates have to be preserved so I can map or geocode later. The ODB occasionally stores lookup tables in separate relations; bring those values across so the sheet is human-readable— no foreign-key IDs left unresolved. If you use any transformation scripts (Python, LibreOffice Base, SQL, Power Query, etc.) please hand those over as well; I may need to re-run the process when updated releases appear. If I decide to add extra columns later, I’ll let you know, so keep your workflow flexible enough to accommodate a quick re-extract. Deliverables for acceptance: • Clean, filter-ready .xlsx file with every building in Canada • Any code or queries used for ...

...instructions. Technical Requirements The solution can be built using any suitable stack, for example: Python (FastAPI / Flask) Node.js simple API + frontend or a lightweight search solution The key requirement is fast matching of user questions to the dataset. No generative AI is required. Deliverables The project should include: A working web demo with search functionality The ability to query the dataset and return answers A 5-question demo limit Simple instructions for updating the dataset Deployment instructions Goal of the Project The goal is to create a working demonstration of the Civil Enforcement Compass system that organisations can try before licensing the full system. Optional Future Work If the demo works well, I may later expand the project to inc...

I'm looking for an experienced SQL Server optimization specialist to improve performance on my SQL Server 2019 instance. Key Areas of Focus: - Query performance - Indexing strategies - Database design Ideal Skills and Experience: - In-depth knowledge of SQL Server 2019 - Proven track record in optimizing SQL Server databases - Strong analytical skills to identify bottlenecks - Expertise in indexing and query optimization techniques - Familiarity with database design best practices Please provide examples of previous work and success metrics.

...similar frameworks. -Hands-on experience managing cloud infrastructure on AWS and Azure platforms. -Familiarity with IT infrastructure components including RBAC (Role-Based Access Control), Linux server environments, and application deployment strategies. -Proficiency with version control tools such as GitHub, SVN, and Git. -Knowledge of database systems including MySQL and SQL Server along with SQL query optimization skills. -Experience working within Agile methodologies to deliver high-quality software solutions efficiently. Background or interest in quantum engineering is a plus but not mandatory. Excellent problem-solving skills with the ability to work independently or collaboratively in a fast-paced environment. This position provides an exciting opportunity for a senior-l...

I’m halfway through a Power BI report and need an expert hand to finish the data-modeling side. All source data arrives as clean CSV files, each holding coordinate pairs alongside several lookup fields. Here’s what’s left to do: • Write DAX (or Power Query M if you prefer) that calculates the Euclidean distance between two coordinate columns in each row. • Build proper one-to-many relationships so my fact table links cleanly to the lookups. • Implement value-based filtering so end-users can slice results by numerical thresholds rather than dates or categories. I will share the PBIX, the raw CSVs, and a short explainer video that walks through the current model. Feel free to add supporting tables, custom measures, or quick visuals that prove ea...

...cell. Your task is to take that column and cleanly break each record into the following dedicated fields: • Address 1 • Address 2 • Address 3 • City • County • Country • Postcode Because the source data uses mixed delimiters—commas, line breaks, an occasional extra space—formula-only solutions rarely catch everything. I’m therefore fine if you use a mix of Excel functions, Power Query, VBA, or even an external script (Python/pandas, etc.) as long as the end result lands back in Excel and each component sits in its own column with consistent casing and no trailing punctuation. Before final delivery please spot-check for obvious anomalies (e.g., missing postcodes or shifted columns) so I receive a ready-to-us...

...depth through a single, well-structured Excel workbook built around Power Pivot. The file must let me load new data each week, refresh the model with one click, and instantly see the impact across all reports. Here is what I need you to put in place: • Robust Power Pivot data model that ingests my raw sales tables and maintains clean relationships • Import and export routines (ideally via Power Query) so I can pull in CSV files and, when required, push summarized data back out • A suite of advanced DAX calculations: period-over-period growth, cumulative totals, top-N products, regional contribution, and any other metrics that help reveal trends • Interactive visualizations—charts, slicers, and graphs—that update automatically after each ref...

...resolve a critical 9.7-second TTFB (Time to First Byte) on a site hosted on WP Engine. The site uses the WPresidence real estate theme. I am NOT looking for someone to install "all-in-one" speed plugins (NitroPack, WP Rocket, etc.). I am looking for manual, code-level, and database-level optimization to fix the root cause of the server lag. Required Technical Scope TTFB Diagnosis: Analyze Slow Query Logs and PHP execution times to identify why the server takes 9+ seconds to respond. Database Optimization: Manual cleanup of the wp_options table (specifically targeting bloated "autoloaded" data), transients, and orphaned metadata. Theme Script Management: Dequeue/Disable heavy WPresidence scripts (Maps, Sliders, AJAX) on pages where they are not required. W...

...entry errors • Standardize formatting across columns and rows (dates, numeric precision, text casing, etc.) Along the way you’ll also re-enter or adjust individual records where information is missing or inconsistent, keep clear notes of any assumptions, and leave me with a tidy workbook that’s filter-ready and pivot-table friendly. A good eye for detail, solid command of Excel functions (Power Query, conditional formatting, data validation, VLOOKUP/XLOOKUP), and a track record of working with mixed datasets are important. If you’ve done similar cleanup projects, attach a brief sample or describe the approach you took—seeing your method matters more than file size. I’ll review proposals as they come in and aim to choose someone who can star...

...entry errors • Standardize formatting across columns and rows (dates, numeric precision, text casing, etc.) Along the way you’ll also re-enter or adjust individual records where information is missing or inconsistent, keep clear notes of any assumptions, and leave me with a tidy workbook that’s filter-ready and pivot-table friendly. A good eye for detail, solid command of Excel functions (Power Query, conditional formatting, data validation, VLOOKUP/XLOOKUP), and a track record of working with mixed datasets are important. If you’ve done similar cleanup projects, attach a brief sample or describe the approach you took—seeing your method matters more than file size. I’ll review proposals as they come in and aim to choose someone who can star...

A handful of text blocks inside my WordPress editor have become impossible to click into or modify, while others remain fine. At the same time the list view of posts and pages inside the dashboard is displaying strange fonts and mis-aligned columns, making day-to-day management awkward. The trouble began after I swit...the offending code without disrupting existing content or layouts. • Deliver a short report outlining what was changed, so I can avoid a repeat. The site runs the latest public WordPress release on standard shared hosting; I can supply wp-admin and FTP (or a staging clone) for deeper inspection. Let me know your estimated turnaround time and the diagnostic tools you like to use—Health Check, Query Monitor, WP-CLI, or anything else—so we can get thi...

...what I need now is a clear, interactive dashboard that turns those raw rows into insight. The layout should feature bar charts, pie charts, and line graphs so supervisors can see at a glance where we stand. Key metrics are straightforward—total production volume and accumulated downtime—updated automatically each day as fresh data is entered. The solution must sit entirely inside Excel (Power Query, PivotTables, dynamic arrays, or light VBA—use whichever combination keeps the file fast and maintenance-friendly). A single click refresh is plenty; real-time streaming is not required. Deliverables • One dashboard tab with the visualisations laid out cleanly for shop-floor display • Any supporting queries, tables, or macros, clearly organised and named...

...customer as: (Item Price + 25 SAR Return Fee). 5. Automated Financial Dashboard (P&L) Real-time summary of Total Sales, Total COGS, Total Shipping Costs, and Total Net Profit. Visual charts for sales trends and Top 5 Selling Products (e.g., Tripowin Vivace, Zero:RED). Accounting for 15% VAT on all domestic transactions. Technical Skills Required: Advanced Google Sheets Formulas (VLOOKUP, XLOOKUP, QUERY, IFS). Google Apps Script (for automation and dynamic updates). Experience in E-commerce financial modeling and logistics calculation. Data Visualization (Charts/Dashboards). Deliverables: A fully functional, inter-connected Google Sheets file. A brief guide on how to import new data and manage inventory batches. EVERYTHING SHOULD BE EDITABLE AND CHANGEABLE SO I CAN U...

...adjust connection strings, and confirm that all read/write operations still function. • Set up a simple CI/CD pipeline so that pushes to the main branch redeploy automatically. • Hand over a concise README describing the steps you took, the services used, and how I can redeploy or scale in the future. Below is my tech stack: Frontend: React 18 with TypeScript Wouter for routing TanStack React Query for data fetching/state Tailwind CSS for styling (light/dark mode) shadcn/ui + Radix UI for components Framer Motion for animations Recharts for data visualization React Helmet for SEO Backend: Node.js with Express 5 TypeScript with ESM modules Zod for request validation Drizzle ORM for database access Database: PostgreSQL If you have prior experience lifting apps ...

...including sanitary, storm, and potable water networks. * Roadworks & Earthworks: Detailed cut/fill analysis and asphalt paving layering consistent with BC Ministry of Transportation (MoTI) standards. * Electrical & Dry Utilities: Coordinating with BC Hydro and Telus standards for underground duct banks and street lighting. 2. Methodology & Software For this project, I prefer using Excel (with Power Query for data management) or CostX. * Why: Excel provides the highest level of transparency for your internal budgeting, allowing you to "stress test" unit rates by adjusting labor or fuel surcharges in real-time. * Data Sourcing: I utilize current RSMeans data adjusted for the BC market (Lower Mainland/Interior indices) supplemented by recent historical bid ...

...strings, and a handful are genuine serial numbers. I need the whole column cleaned so every entry follows one consistent, true-date format that Excel recognises natively. Your task is strictly data cleaning: standardise every date, verify the change with a quick formula check (COUNT, MIN, MAX—whatever you prefer), and hand back a file that requires no manual fixes from me. Feel free to tap Power Query, formula tricks, or simple formatting commands; I only care that the resulting dates sort, filter, and calculate correctly. Deliverables • The cleaned workbook with a single, uniform date format (I’m happy with yyyy-mm-dd, but let me know if you spot a better option for the dataset). • A short change log noting any outliers you had to correct manually. I...

...matters and flagging inconsistencies you discover. • Clean and re-format the data—remove duplicates, standardise dates, align text casing, and make sure numeric fields behave like numbers. • Once everything is pristine, create a simple summary tab that gives me quick counts or basic statistics I can build on later. I’m comfortable if you lean on functions such as VLOOKUP, IF, SUMIFS, or Power Query where helpful—whatever keeps the process reliable and repeatable. Deliverables I expect at hand-off: 1. A single, well-structured Excel file containing all entered data. 2. A “Clean Log” sheet briefly noting any major issues you corrected (e.g., duplicate IDs or unreadable values). 3. The summary/report tab described above. Accuracy matter...

...matters and flagging inconsistencies you discover. • Clean and re-format the data—remove duplicates, standardise dates, align text casing, and make sure numeric fields behave like numbers. • Once everything is pristine, create a simple summary tab that gives me quick counts or basic statistics I can build on later. I’m comfortable if you lean on functions such as VLOOKUP, IF, SUMIFS, or Power Query where helpful—whatever keeps the process reliable and repeatable. Deliverables I expect at hand-off: 1. A single, well-structured Excel file containing all entered data. 2. A “Clean Log” sheet briefly noting any major issues you corrected (e.g., duplicate IDs or unreadable values). 3. The summary/report tab described above. Accuracy matter...

...project. The goal is to build a system where a language model can query a structured knowledge base while enforcing strict safety and retrieval rules. The system will be used in a clinical / healthcare-related context, so accuracy, traceability and rule enforcement are critical. --- Current Infrastructure The current setup includes: WordPress website hosted on Hostinger (content origin / source of truth) Cloud environment on Hetzner available for backend deployment Initial automation infrastructure already started The WordPress site must remain separate from the AI backend. It acts only as the knowledge source, not as the execution environment for the AI system. --- Objective Build a RAG pipeline that allows an LLM to query a curated knowledge base while enfo...

"I need a Python developer to build a high-concurrency data logger for Dhan API. The script must maintain 5 parallel WebSocket connections simultaneously to fetch 200-level market depth for 5 FUTURES AND OPTIONS instruments. The incoming order-book snapshots must be written to excel .csv file continuously so I can query them later for research and back-testing. Process: Login to DHAN api - auto login setup using authenticator (PYOTP) Initially NIFTY index and BANKNIFTY index, live data to be fetched using websocket, then using the live data we will make OPTION and FUTURE instruments using certain formulas, then we will fetch the market depth (200 level) of those instruments. Finally store that data continuously preferably in .csv excel As per dhan api documentation, depth leve...

... • API/Backend: tRPC 11, Express 4, and Node.js. • Database: MySQL/TiDB using Drizzle ORM. • Storage/Auth: S3-compatible object storage and OAuth/Credential-based login. • Testing: Vitest. Key Deliverables & Responsibilities: • Database Migration: Implement the Drizzle ORM schema changes. Note that the Budget module stores data directly on the projects table (budget, spent, etc.) to optimize query paths. • Backend Integration: Set up the tRPC routers for Navigator, Budget, and Users-Team. • Frontend Implementation: Integrate the .tsx page components while maintaining existing state logic, such as the PROJECTS_COLLAPSE_THRESHOLD = 4 constant in the Team module. • Server-Side Logic: Ensure the Navigator status cache (60-second in-memory...

I have a collection of Excel and CSV files that need to be consolidated, reviewed, and cleaned so they are ready for analysis and reporting. The raw sheets contain blank cells, occasional typos, inconsistent date and number formats, and some possible duplicate reco...workbook. 2. The original, unaltered dataset for reference. 3. A “Before / After” changelog sheet summarizing the corrections and adjustments made. **Additional Details** * Files will be shared through Google Drive. * Accuracy is more important than speed. * First draft required within 5 days. * One revision round should be included if anything needs adjustment. Experience with Excel, Power Query, or data cleaning tools is a plus, but manual cleanup is acceptable as long as the final output is precise a...

...There might be a need to scrape data as well. Both the full address string and the explicit lat/long coordinates have to be preserved so I can map or geocode later. The ODB occasionally stores lookup tables in separate relations; bring those values across so the sheet is human-readable— no foreign-key IDs left unresolved. If you use any transformation scripts (Python, LibreOffice Base, SQL, Power Query, etc.) please hand those over as well; I may need to re-run the process when updated releases appear. If I decide to add extra columns later, I’ll let you know, so keep your workflow flexible enough to accommodate a quick re-extract. Deliverables for acceptance: • Clean, filter-ready .xlsx file with every building in Canada • Any code or queries used for ...

I have a collection of Excel/CSV files that need to be consolidated, checked, and polished so they are ready for analysis and reporting. The raw sheets contain a mix of blank cells, occasional typos, uneven date and number formats, and some possible duplicate records. Your job is to: ...original, unaltered copy for reference. I’ll share the files via Google Drive. A brief “before / after” changelog inside a separate tab will help me follow what you did. Accuracy is far more important than speed, but I would like the first pass within three days, with one revision round included if anything was missed. If you are comfortable working directly in Excel or with tools like Power Query, that’s a plus—though manual cleanup is perfectly fine as long ...

My customer list lives in a single Excel workbook and it needs a proper scrub before import into our CRM. The file contains a mix of new and legacy records; my priority is to remove every duplicate while keeping the original formatting intact and ensuring no valid entry is lost. You’ll work directly in Microsoft Excel—Power Query, advanced filtering, or any reliable technique is fine—as long as the final sheet is spotless and ready for upload. Deliverables • A cleaned Excel file with all duplicate customer records removed • A short summary sheet noting how many duplicates were identified and deleted, plus any edge cases you spotted If you can start right away and finish quickly without sacrificing accuracy, let’s get this done.

...helps manage insurance claims and significantly reduce claim rejections. The platform’s core capability will be a powerful AI-based claim validation system that analyzes claims before submission and identifies potential issues that may lead to rejections or insurer queries. The system should also integrate with insurance/TPA portals to retrieve claim status information and provide rejection and query analytics through dashboards. The platform must support multiple hospitals using a secure multi-tenant architecture. 2. Users The system will be used by hospital staff responsible for insurance claims processing. Users include: • Hospital Billing Team • Insurance / TPA Desk Staff • Hospital Management There will be no external users such as patients or in...

...hand-over video or notes outlining filters, data refresh steps, and any gateway settings Acceptance criteria The dashboards must refresh cleanly from the source file without manual intervention, all figures must reconcile with the original Excel totals, and navigation between Department, Time Period, and Project views should remain under two clicks. Tools expected: Power BI Desktop, DAX, Power Query. I will provide the Excel file immediately on award and can answer clarifying questions in real time to keep the one-day turnaround achievable....

...WWE/UFC coverage, entertainment grids, audio embeds, affiliate blocks, and multiple ad placements. You will be provided with a detailed visual layout map, section‑by‑section instructions, banner sizes, and content structure. Core Requirements Expert-level experience with GeneratePress Premium and GenerateBlocks Ability to build clean, responsive, block‑based layouts using Containers, Grids, Query Loops, and Hooks. Strong understanding of Gutenberg This build must be done entirely with Gutenberg + GenerateBlocks (no page builders). MUST HAVE EXPERIENCE MONETIZING WEBSITES WITH EZOIC. Must understand: AD MANAGEMENT placeholder placement ad sizing in‑content ad logic sticky sidebar ads video player embeds site speed considerations avoiding layout shifts MUST HAVE AFFILIATE...

...record raw-material purchases and note any other operational cost or wage payment. • Behind the scenes the sheet should assign batch numbers, update current stock, calculate cost of goods and flag shortages. • Dashboards that instantly show production totals, sales vs. returns, raw-material consumption and real-time profit or loss. I’m expecting you to weave in modern Excel capabilities—Power Query for data consolidation, dynamic arrays and structured tables for error-proof calculations, plus lightweight AI touches such as automated data validation, smart prompts or predictive analytics that suggest reorder points. Everything must stay “one-click” simple so my staff can’t break formulas. Deliver the finished .xlsx (no external add-i...

...Record every sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive i...

...performance—specifically which items are driving the most revenue, which are lagging, and how return rates are affecting overall profitability. Beyond that focal point, the model should still let me glance at revenue trends, customer-purchase patterns, seller distribution and the impact of discounts, but competitor benchmarking is not required this time. Your work starts with data shaping in Power Query, progresses to a well-structured star schema, and ends with elegant, drill-through visuals built in Power BI Desktop. I rely heavily on DAX measures, so clear, well-named calculations are essential. Deliverables • Cleaned and documented data model (PBIX) • Interactive report pages for: top-selling products, low-performing products and product return ra...

...task is to audit the codebase, locate and repair the offending logic, then optimise any queries or middleware that are slowing things down. I’m already set up with Git, so you’ll work in a separate branch, commit frequently, and open a pull request for review. Deliverables - Clear summary of each bug, its cause, and fix - Updated, well-commented PHP/Blade files or controllers - Database/query optimisations where relevant - Passing tests or a brief screencast proving the fixes in action - Final pull request merged without introducing new errors Acceptance criteria 1. No functionality breaks when running the documented user flows. 2. Page response times stay consistently under two seconds on my staging server. If you’re comfortable tracing compl...

...matters and flagging inconsistencies you discover. • Clean and re-format the data—remove duplicates, standardise dates, align text casing, and make sure numeric fields behave like numbers. • Once everything is pristine, create a simple summary tab that gives me quick counts or basic statistics I can build on later. I’m comfortable if you lean on functions such as VLOOKUP, IF, SUMIFS, or Power Query where helpful—whatever keeps the process reliable and repeatable. Deliverables I expect at hand-off: 1. A single, well-structured Excel file containing all entered data. 2. A “Clean Log” sheet briefly noting any major issues you corrected (e.g., duplicate IDs or unreadable values). 3. The summary/report tab described above. Accuracy matter...

I want to push a single website to attract measurably more visitors from Google, so every tactic and recommendation should be judged by its ability to lift organic sessions. The first priority is deep keyword research—primary, secondary, long-tail, competitor gaps—so we can align content and on-page elements with real query demand. From there, I’ll need a clear plan that covers technical clean-up, content optimisation, and link-building best practices, always keeping Google’s current guidelines in mind. Key deliverables I’d like handed over: • Comprehensive keyword research file (search volume, intent, difficulty, suggested page mapping) • Technical and on-page optimisation checklist tailored to the site • Actionable content brief...

...contributes to snow blocking a road. The key stories I need to see are: • Predominant wind direction, average wind speed, and peak gusts broken down month-by-month. These should be sliders on a model. • Daily snow-depth trends across the winter, with an overlay or clear link to the prevailing wind direction on each day or month. Focus is on Dec-March Please build whatever pivot tables, Power Query steps, or helper columns you feel are necessary and then surface the insights in a mix of 2D and 3D models—I’d like to be able to switch between the two for presentations. While winter is the primary focus, I still need the same wind metrics visible for the rest of the year so the workbook tells a complete story. Deliverables 1. Output will be a proposal (MS W...

Project Overview I will consolidate, clean, and structure your scattered dataset...providing quick statistics, counts, and basic analysis • Workbook optimized for pivot tables, filtering, sorting, and further analysis Action Plan Review and categorize all raw data sources (text files, emails, other formats) Import and consolidate records into a master Excel workbook Perform systematic data cleaning and validation using Excel tools and formulas Apply VLOOKUP, IF, SUMIFS, and Power Query where needed to ensure accuracy and automation Document corrections in the Clean Log sheet Build a summary dashboard tab for quick insights Requirements • Access to all raw data files and source materials • Clarification on column structure or critical fields • Any preferred dat...

...matters and flagging inconsistencies you discover. • Clean and re-format the data—remove duplicates, standardise dates, align text casing, and make sure numeric fields behave like numbers. • Once everything is pristine, create a simple summary tab that gives me quick counts or basic statistics I can build on later. I’m comfortable if you lean on functions such as VLOOKUP, IF, SUMIFS, or Power Query where helpful—whatever keeps the process reliable and repeatable. Deliverables I expect at hand-off: 1. A single, well-structured Excel file containing all entered data. 2. A “Clean Log” sheet briefly noting any major issues you corrected (e.g., duplicate IDs or unreadable values). 3. The summary/report tab described above. Accuracy matter...

...Record every sale, purchase, expense and bank movement each week and roll them into simple monthly management statements I can read at a glance. • GST Compliance – Keep my input-credit registers tidy, draft and file the regular GST returns on time, and store the acknowledgements neatly with the working files. • Advanced Excel – Build or refine spreadsheets with pivot tables, lookups, Power Query or light VBA so recurring reconciliations and variance analyses run at the click of a button. • MS Office Reporting – Package the numbers into a short Word or PowerPoint summary when I need to brief other stakeholders. Deliverables must reconcile to bank statements with zero variance, trigger no validation errors on the GST portal, and arrive i...