Sql query tree parentJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

...bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let&#...

...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL...

...proficient developer to undertake this project on a contractual basis. Project Overview: The project entails the development of an e-commerce website for TTArtisan, focusing on providing a seamless shopping experience for our customers in India. The website will serve as a dedicated platform for showcasing and selling TTArtisan products, including camera accessories and lenses. While we already have parent websites, we aim to build brand-specific sites to implement tailored strategies and enhance brand visibility. Scope of Work: The chosen developer will be responsible for various aspects of website development, including but not limited to: Theme suggestions and customization: Proposing and implementing visually appealing and user-friendly themes that align with the brand'...

... Key Requirements: - Style: The logo should exude calm and relaxation with a modern sophistication, reflecting a more high-end look and feel for the resort we want to become. - Design: A blend of text and icon elements may be desired to create a memorable and versatile logo but happy to see text only options as well. We are going with a more natural colour palate and our main pool and pandanus tree are 2 key icons of the resort. - Timing: Urgency is a priority, so the ability to deliver a top-notch design promptly is crucial. Ideal Skills and Experience: - Proven experience in creating elegant and sophisticated logos. - Proficiency in both text and icon-based logo design. - Ability to deliver quality work promptly, adhering to tight deadlines. - Strong understanding of branding...

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

I am currently ...currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this...

...for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies...

I need a skilled graphic designer to create a logo for my ...in two ways. Logo as one COMPLETE image (Name and Image together) Logo SEPARATED into two files (one file for the name “THE NORTH STORAGE” with all formats and a second file with only the image "TREE" with all the formats) -The Complete Logo (jpeg) -The Complete Logo (Png) -The Complete Logo (Pdf) -The Complete Logo (Vector) -The Separated Logo Name (jpeg) -The Separated Logo Name (PNG) -The Separated Logo Name (Pdf) -The Separated Logo Name (Vector) -The Separated Logo Tree (Jpeg) -The Separated Logo Tree (PNG) -The Separated Logo Tree (Pdf) -The Separated Logo Tree (Vector) -The Separated Logo Tree (Favicon) ********** ALL LOGO FILES MUST BE HIGH QUALITY RESOLUTI...

I'm in need of a professional Photoshop artist to create a realistic montage for a house project. I need 2 images. 1. I need an image of the existing house to be remove and replace by grass. You have the picture of the front of the house and the picture of the tree behind. It doesn't need to be perfect, just give a good idea of the spot without the house. 2. A picture of the new house (the outline only) on the spot where it will be constructed with a path leading to it. Again, just to give an idea. The new spot is behind the trampoline. Let me know if you need more images. I need it ASAP. Thanks !

I am looking for an experienced React Native developer who can develop a functional driver app for both iOS and Android platforms. I already have UI screens, however, are open to guidelines and suggestions. The Primary function of the app ...should have: - Proven experience in React Native Development - Proficiency in working with both iOS and Android platforms - Excellent understanding of GPS integration and real-time notifications - Ability to work with provided UI screens and enhance functionality - Expertise in payment processing integration. I'm excited to see how your skills and experience match this project. If you have any query or suggestion please let me know. Looking forward to collaborating with you. Note : There are 20 UI Screens and we put a 150 Rupees per s...

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...

I'm looking for a seasoned web developer to help me create a parent portal for a childcare booking system. This web-based application should effectively and efficiently allow parents to manage their bookings and communicate with the childcare staff. Key Features: - Online Booking: Parents should be able to make, alter, and cancel their bookings with ease. - Parent-Staff Communication: A communication portal that allows parents to directly liaise with the childcare staff. Skills and Experience: - Expertise in web-based application development. - A strong track record of creating user-friendly platforms. - Previous experience with booking systems or parent portal apps, a plus. --written in python

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...

I'm in need of a talented banner designer who can create a personalized and illustrative banner for my social media platforms, particularly YouTube and Twitch. Requirements: -I would like that background, with that tree behind me. and three of those E in the sky has a cloud. also, i want a Nintendo switch to be hanging from one of the branches. - Personalization: The banner should reflect my personality and brand. - Style: I'm particularly interested in an illustrative style for the design. - Colors/Themes: I have specific colors and themes in mind for the design. Ideal Skills & Experience: - Graphic Design: Proficiency in creating custom graphic designs, particularly banners for social media. - Illustration: Strong skills in creating illustrations, especially for d...

...- Install Business Child Theme on main WordPress theme - Ensure compatibility of the child theme with the main theme The entire child theme design (pictures, logos, texts, etc.) must be loaded correctly so that I can immediately begin editing the site blocks myself. The freelancer will need to be proficient in WordPress, theme installation, and troubleshooting. The ability to determine the parent WordPress theme through analysis of the website is necessary. Knowledge on customizing WordPress themes is also a plus, even though no major design changes will be happening at this stage. P.S. I nevertheless wrote detailed instructions on how to do this and I will forward these instructions to the freelancer I choose. However, I need an expert experienced in this field with whom...

...life. Compass or map: Signifying the journey of life and the importance of exploring and experiencing it. Heartbeat line or EKG rhythm: Reminds us of the vitality and pulse of life. Integration of Both Concepts: Dual-faced mask: One side represents life, the other death, showing the dual nature of existence. Combination of a blooming and withering tree: Illustrating the continuous cycle of life and death. I like the direction of these ideas. A tree in the middle with a Grim Reaper, Crow/Raven, and Veiled Skull of some sort on one side, and symbols of life on the other side. It should be memento mori vs memento vivere. Fading from one to the other across the image This would be stretching across my back so the separation of the two sides would be ideal. Start your prop...

I'm looking for a designer who can...life. Compass or map: Signifying the journey of life and the importance of exploring and experiencing it. Heartbeat line or EKG rhythm: Reminds us of the vitality and pulse of life. Integration of Both Concepts: Dual-faced mask: One side represents life, the other death, showing the dual nature of existence. Combination of a blooming and withering tree: Illustrating the continuous cycle of life and death. I like the direction of these ideas. A tree in the middle with a Grim Reaper, Crow/Raven, and Veiled Skull of some sort on one side, and symbols of life on the other side. It should be memento mori vs memento vivere. Fading from one to the other across the image This would be stretching across my back so the separation of the two...

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable exper...

I'm looking for an experienced developer who can take a code base and dataset I provide, construct an Abstract Syntax Tree (AST) based on them, and then create an Autoencoder using TensorFlow to compress the resulting AST for a classification problem. Key requirements for this project include: - Proficiency in Python: You will be working with a Python code base and dataset. Familiarity with Python is essential for this project. - Understanding of AST: You should be able to construct an AST tree based on the provided dataset and code base. - TensorFlow Experience: I would like the Autoencoder to be developed using TensorFlow, so prior experience with this framework is a must. - Output format: The desired output format for the Autoencoder is JSON, so you should be comfo...

...Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...

I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.

... Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with ...

I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...

...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....

As the final step to my graduation, I am seeking a frontend developer who is expert in using the react.js, and CSS Tailwind frameworks. The project is hosted on GitHub which you can find more details on the link...design and interactive UIs, especially within the educational domain. Please share your experience and any similar previous projects you've worked on. Your application will not just be assessed based on your experience level but also on how relevant your previous work is to my project. I look forward to your detailed project proposal. Here's the GitHub link: Here's a Figma design link for the project: 's

I'm seeking an experienced telemarketer who specializes in outbound calls to assist with marketing campaigns for our clients. Must be UK based as may have a need for meetings occasionally. Specifically, you will focus on: - Marketing a diverse range of products and services inclusive of attracting event visitors and promoting a client...Ideal Skills: - Strong spoken communication skills. - Consistent track record in sales & marketing although we are not hard sales, we don't do end sale, we are more marketing and promoting on behalf of our clients - lead generation, data cleansing - Familiarity with dealing with a diverse customer base. - Has own laptop and ability to work remotely from a quiet location - This could suit a working parent as work can be up and down de...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.

...Minimum of 10 years' practical experience in cybersecurity, preferably with recognized companies. Proficiency with various cybersecurity tools and programming languages. Expertise in identifying and mitigating risks, threats, and vulnerabilities. Technical Skills: Hands-on experience with Security Information and Event Management (SIEM) tools. Proficiency in Python, Linux, and SQL. Knowledge of CIA Triad, governance, risk analysis, compliance, and business continuity planning. Familiarity with Linux and Windows server configuration, Active Directory, network architecture, operations, and security. Experience in areas such as Wireshark, email security, wireless security, cryptography, port scanning, cloud security, and virtualization. ...

...symbols of wind, solar, and biomass energy in a cohesive design representing the variety of renewable resources. 6. Minimalist Initials: Design a minimalist logo using the initials "R" and "S" of REFOSYN creatively, with a scientific touch. 7. Transformation and Growth: Depict the concept of transformation and growth using dynamic and progressive shapes in the logo design. 8. Energy Tree: Create a stylized tree incorporating elements of renewable energy in its branches, symbolizing sustainable growth. 9. Energy Waves: Use wavy lines to represent energy waves in a modern and elegant design. 10. Sustainable Urban Landscape: Integrate elements of a sustainable urban landscape, such as eco-friendly buildings or solar parks, into the logo design. 11. Transfo...

I'm seeking a knowledgeable specialist to perform benchmarks on my Pgvector Chroma Faiss database. The key objectives for this project are: - Analyzing speed and query performance. The ideal freelancer should have: - Proficiency with Pgvector, Chroma, and Faiss. - Experience in database benchmarking, with a focus on query performance metrics. - Ability to provide detailed reports on performance metrics. - Ability to offer performance tuning recommendations based on benchmark results. As this is for personal use, the project requires a specialist who can deliver thorough insights without the need for a business-oriented approach. Your technical database expertise will be crucial for this project.

I am seeking an experienced software developer with expertise in creating robust web application...analysis for better decision making Needed Functionality: - Inventory management system: The application should keep accurate track of the inventory levels and alert the users when restocking is needed. - Payment management: The application should be capable of processing payments, invoices, and balancing accounts. Ideal Skills: - Proficiency in back-end and front-end development - Knowledge in SQL for database structure - Understanding of payment gateways The successful freelancer should exhibit strong understanding of cloud infrastructures and advanced data security measures. Experience in creating similar systems would be a significant advantage. The simpler the application UI, t...

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...

...activate the account. - **1.2 Login** - Users must log in using their registered school email address. - The system should provide password recovery options. #### 2. User Dashboard - **2.1 Access** - Upon successful login, users are directed to their dashboard. - **2.2 Features** - A search box to look up universities by name. - A list of universities should appear based on the search query. - Users can select a university to view more details. #### 3. University and Course Interaction - **3.1 University Selection** - After selecting a university, a list of available courses is displayed. - **3.2 Course Selection** - Users can select a course to view detailed information, including existing reviews. #### 4. Review Management - **4.1 Review Actions** - User...

FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The complet...

I need an experienced developer with proficiency in both Vue.js and .NET, capable of delivering the pro...applications. - **Project Details** - The developer is expected to create an enterprise application with an interactive UI. - I place a significant emphasis on an engaging, usable and intuitive interface. - **Timeline** - The project needs to be completed ASAP. So, I'm looking for someone who can dedicate sufficient time immediately. -** Vue.js 2 and 3 experience ** with .Net Web API and sql server required on expert level Ideal candidates can demonstrate previous experience working on similar projects and have a strong understanding of UI/UX principles. this a NDA Project and no code will be share and is a remote work, NO PHP folks needed or bid on this proje...

I require a professional landscaper capable of tree trimming and restoring a small yard (less than 500 square feet). My garden currently is overrun with weeds and needs topsoil removal to restore its health. The task includes: - Trimming trees and removing topsoil with weeds - Restoring the lawn to a healthy state There are no specific plants or trees to preserve during restoration. Preferred experience of the freelancer: - Knowing how to use landscaping tools efficiently - Hands-on experience with lawn restoration - Ability to dispose of removed debris responsibly.

... but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and custom graphics that reflect our brand and the services we offer. - Design a responsive and accessible website that adjusts smoothly to different screen sizes and devices. - Clear and intuitive navigation system

I'm urgently in need of a qualified developer or data engineer to create a pipeline utilizing D...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the ye...

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particula...in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, O...

...The hat should have a deep swamp green color, incorporating textures and elements that resemble a dense swamp environment, such as moss, wet leaves, and cypress tree stumps. The curved brim should appear slightly ragged, emulating wear from a swampy area. Text Embroidery: The text "Swamp Stank" should be featured prominently on the front of the hat. The embroidery should use a bold, raised, moss-like textured thread. The font should mimic irregular, organic shapes, similar to tangled roots or vines, to integrate seamlessly with the swamp theme. Additional Design Elements: Include detailed embroidery of swamp flora, cypress tree stumps, and other relevant features around the text. The design should have a 3D appearance, with a focus on texture and depth to enh...