Sql statement parent child tables jobs

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

...the following areas: - Internal Controls Review: The freelancer will be responsible for evaluating and testing our internal controls to ensure they are effective and in compliance with industry standards. Experience with COSO framework would be highly beneficial. - Financial Statement Audit: The selected professional will be tasked with auditing our financial statements to provide an independent and objective assessment of our financial health. An in-depth knowledge of GAAP and experience with financial statement audits is a must. - SOX Compliance Review: The freelancer will need to review our processes and procedures to ensure compliance with the Sarbanes-Oxley Act. A thorough understanding of SOX requirements and experience with compliance reviews is essential. The...

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

This project was created for the participants of my contest here: https://www.freelancer.com/contest/AIGenerated-images-of-wood-Epoxy-Dining-Tables-2386675?frm=paramedic78&sb=t Because there are so many great ideas in the contest, I wanna give each designer to have the ability to earn money with his work. So I need results according theese requirements: I need image of the whole surface of the table recorded by viewing from the top to the bottom. No spotlights and reflections are allowed on the surface. I need the images in a 8K high resolutions with most photorealistic effect that is possible and looking great). Please add your bid here with the price for 5 or 10 images created by you. Ideal candidates will have a strong familiarity with AI image generation technology and a...

This project was created for the participants of my contest here: https://www.freelancer.com/contest/AIGenerated-images-of-wood-Epoxy-Dining-Tables-2386675?frm=paramedic78&sb=t Because there are so many great ideas in the contest, I wanna give each designer to have the ability to earn money with his work. So I need results according theese requirements: I need image of the whole surface of the table recorded by viewing from the top to the bottom. No spotlights and reflections are allowed on the surface. I need the images in a 8K high resolutions with most photorealistic effect that is possible and looking great). Please add your bid here with the price for 5 or 10 images created by you. Ideal candidates will have a strong familiarity with AI image generation technology and a...

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

We need a highly skilled individual with extensive experience in document and presentation design. You will be tasked with: - Modernizing our statement of work, proposals, contracts, and PowerPoint presentations. - Updating layout and formatting. Bring outdated formats into the modern age with a refreshing touch that reflects our brand. - Revising content and language. Our output needs to resonate with the audience, so a quality copywriting ability is crucial. - Adding visual elements and graphics. You'd pepper appropriate visuals throughout our documents and slides, enhancing understanding and engagement with our messages. The style we envision for this task is clean, modern, and professional. If you have an understanding and feel for our described style, we want to work wit...

...an expert WordPress developer who can correctly install a Business Child Theme I've chosen on an undetermined (the freelancer must figure out which one) main WordPress theme. The ideal freelancer has to have experience dealing with WordPress themes and should be capable of figuring out the main theme on their own. Key Tasks: - 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 thro...

...the principles and strategies taught in SMC and ICT schools, while also incorporating classic trading approaches. Ideal skills for this project: - Proficiency in Tradingview script development - Understanding of SMC and ICT trading methodologies - Knowledge of classic trading indicators and strategies - Ability to create clear and user-friendly script documentation Experience with liquidity tables and Vortex editing would be an advantage. Please only apply if you are confident in your ability to meet these requirements. For clear information Smc and ict also automatic fibonacci +trend channel + trend lines with SR liens + stock and crypto and forex liquidity table+ dashboard table with major information from rsi and Vortex also macd and Ema 50 also Ema 200 + trend status wi...

...Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communication skills to understand the specific requirements for the instruction manual. Looking for a freelancer who can deliver accurate, visually appealing Excel tables and a well-structured Word document. The ability...

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

I'm in need of a skilled freelancer who can deliver a well-rounded Google sheet to capture important aspects of monthly personal finance, it's crucial that the created sheet can be adaptable to handle text, numerical, and date/time data. Key features: - Data validation - Pivot tables - Conditional Formatting - charts/graphs To be a right fit for this task, you should have a strong grasp on creating and optimizing Google Sheets, with these particular functions. Showcasing your past work in similar projects will strengthen your application. I'm looking forward to collaborating with you on this project to create a solid and functional Google sheet.

...will have experience tailoring ads specifically to reach individuals aged between 25-44, women with a long awaited wish for a child. The German ads have to be going to a 1) German speaking audience mainly located in Germany, Switzerland and Austria. In addition, another target group for the English Ads is located in the Dubai and Saudi Arabia. Looking for an experienced Media Buyer who specializes in strategic ad campaigns across Meta. - Strategizing and implementing ad campaigns across multiple platforms, namely Facebook, Instagram - Targeting specific audience groups based on age, gender and geographical location (women having a long lasted wish to conceive a child. 1) German speaking located mainly in Germany, Switzerland and Austria and 2) English speaking locals in...

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

...marketing channels are presently undecided, offering you a chance to recommend what you consider most effective. We believe utilizing social media, reddit, and email marketing our the most effective channels. Our platform, called GraceBlocks, () allows the general user to create robust, collaborative solutions. Think of it as spreadsheets on steroids. Quickly define your data tables, link them up, and then use built in services like web forms to capture data and use our integrated bi-directional email and text solution to communicate with your audience/users. Your role: - Create and implement a robust marketing strategy - Suggest and utilize effective marketing channels - Reach our target audience successfully Ideal Skills: - SaaS marketing experience - Ability to create

YOU MUST ACKNOWLEDGE THAT THIS IS A GAY ADULT WEBSI...I need an experienced web developer who will work periodically on my gay adult website. An adept knowledge of handling PHP, MySQL, and server-side issues is crucial, as this is the job. Key tasks will primarily involve: - Dating website structure - Regular bug fixes - Working on necessary layout adjustments - Server-side management - Repairing and managing RSS feeds - Creating efficient data tables I'm seeking someone flexible, detail-oriented, and reliable for an ongoing relationship. Let's work together to keep the website running smoothly and efficiently. About the pay. It’s $15.00/hr. I do pay this lower fee because the work is easier, and I will give you work periodically. Usually, a worker will work wi...

I need a child model for a commercial TV ad. Deliverables: - The main requirement is to appear in a video that may be broadcast on television. Details: - The selected model must be within a specific age range, which will be communicated upon shortlisting. Ideal Candidate: - Previous experience in commercial modeling will be highly appreciated. - Adaptability to various shooting conditions is a key requirement. - Having a vibrant and engaging presence on-camera is essential. - Those with TV experience will be given preference. This could be an excellent opportunity for those trying to make a mark in the industry. Your commitment to this project must match your talent. I look forward to partnering on this exciting journey.

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.

... - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financial Modeling Experience: Prior experience in financial modeling is a major advantage, especially with adapting existing models to reflect strategic changes. - Analytical Thinking: The ability to understand complex business strategies and translate them into functional model adjustments is key. - Attention to Detail: The existing models are intricate, ...

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

...month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. ...

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

...month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. ...

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

I am in need of a skilled accountant who can prepare a Profit and Loss statement, Balance Sheet, and Trial Balance. As a retail business owner, understanding our financial position is essential. Key responsibilities include: - Creating P&L statements - Drafting balance sheets - Concocting trial balances The ideal candidate would have experience in retail accounting, giving them the ability to understand the specific needs of my business quickly. Please note the frequency of this task is undetermined at this time, to be discussed after engagment. Your flexibility and willingness to adapt to change is important. I look forward to a productive partnership.

...for children aged 2-5 years. The primary purpose of this project is to: - Improve user experience - Include static card design - Craft interactive contents design The ideal freelancer would need experience with UX design for young users and would be responsible for creating playful, functional, and aesthetically-pleasing designs. The designer should have a proficiency in creating child-centred illustrations and be well-versed in making these illustrations interactive and easy to navigate for small children. Their past work should demonstrate the ability to blend functionality with fun design elements. Their skills should include designing animations that can maintain the interest of small children, and innovation in incorporating these animations into the game ca...

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.

I need a talented fashion designer to help create a trendy and bold collection of casual wear for girls aged 3 to 5 years old. - The Designer: You have a...offering a break from the usual bright colors. - The Style: Despite using soft colors, the clothes should carry a trendy and bold feel to them. We want our little customers to feel fashionable and empowered. - Final Product: A complete collection including sketches, and detailed design specs suitable for handing over to a manufacturer. Skills required are illustration, fashion designing, and child psychology understanding. Previous experience in children's fashion is necessary. This project may become ongoing if the initial collection is successful. Seeing previous work or a portfolio of designs would ease our decision-...

I'm in need of a talented illustrator specializing in realistic styles for a children's book. The project is specifically aimed at children aged 0-4 years. Key Requirements: - Proficiency in creating realistic illustrations - Prior experience in illustrating for children's books - Understanding of child psychology and what appeals to very young children It's important that the illustrations are engaging, vibrant and most importantly, appeal to a very young audience. The illustrator should be able to bring the story to life through their illustrations in a way that captivates and entertains young children.

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

I am in need of a proficient excel w...formatting is key, for which I don't have a specific preference, however, creating simple tables, color coding cells, or using pivot tables and charts are all strong possibilities for this recurring project. Since no specific criteria was given, please do include your past work, experience, and a detailed project proposal when you apply. Skills and experience preferred: - Familiarity with advanced Excel functions and formulas. - Experience with data analysis and visualization. - Strong attention to detail, particularly with data entry. - Ability to propose efficient solutions and quick at troubleshooting. - The ability to present data in a user-friendly format (simple table format, color-coded cells, pivot tables and charts,...

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

I'm looking for a talented designer with advanced graphic design skills. I need a professional and corporate style capability statement created for the health arm of our business. The project involves: - Inserting images into the document. - Ensuring the statement looks highly professional and corporate. You'd be working with the existing content that I have ready. It's important to design the document in a way that effectively conveys our capabilities and experiences in the health sector. Ideal Skills: - Proven experience in graphic design. - Expertise building professional documents. - Capability to work with an existing content and enhance it with visuals and design elements. Looking forward to working with you.

...illustrations and text into a cohesive video - Incorporate the music video file into the story. use a small frame within the video where possible to also show the man who is singing the song. It's good to acknowledge him - although he is not the focus of the video. File here for download: - Ensure the video appeals to a child audience Ideal Skills: - Proficient in video editing - Experience with creating children's content - Storytelling skills Please note: I have both the illustrations and the text, so the main task is to bring them to life through engaging video editing. Some examples of how other storybooks by other authors have been created into videos: https://youtu

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'm looking for a skilled graphic designer to create attention-grabbing materials for our fitness programs targeted towards children. The design should be bold and vibrant, appealing to a younger audience. Key requirements: - The design should be child-friendly, engaging, and fun - It should effectively communicate the essence and benefits of the fitness programs - Clear, concise, and visually appealing design - The design must be both for an A5 flyer (to be distributed) and an A3 poster (to be displayed) - We are open to having a double-sided design as well if you are willing to do two sides. Please include one or some of the photos attached below. We're open to options for colours and photo combinations. Info for the design: Title: North Balwyn Fitness Program! Fit...

I'm in need of a talented graphic designer to create a minimalist poster for me. The color scheme should be primarily cool tones, namely, shades of blue, green, and violet. Key Requirements: - Strong aesthetic sense and experience in minimalist design - Experience in color theory, specifically cool colors - Proficiency with design softwa...cool tones, namely, shades of blue, green, and violet. Key Requirements: - Strong aesthetic sense and experience in minimalist design - Experience in color theory, specifically cool colors - Proficiency with design software like Adobe Illustrator or Canva Your portfolio of previous poster design work will be highly appreciated. While the design should be minimalist, it also needs to make a statement. I'm excited to collaborate and m...

...with a focus on clean lines and a sleek look. Ideal Skills and Experience: - Graphic Design: Experience with creating branding materials is essential. - Understanding of Branding: An understanding of how to effectively promote a brand through design. - Modern Aesthetic: Experience with modern and minimalist design choices. I'm looking for a design that will catch the eye and make a strong statement about our company. If you have a solid background in graphic design and branding, and are adept at creating modern, minimalist designs, I'd love to hear from you. The two key factors are - our office runs two businesses - So one business logo on top and one below - This will be printed on a one way vinyl print - the attached logos HAVE to be used - A sleek Eye ca...

I need someone to develop the following: (1) company logo for a company called Snowy Owl, (2) product logo for a product called Hoot, plus (3) variations of these logos for other branding assets such as icons as set out in the enclosed brief. It is critical that you read and fully understand the brief. It provides information about our software company, its positioning statement, product suite overview, target audience, design objectives, potential color schemes, and previous company and product logo designs. I will not repeat that information here. Your work will be crucial in establishing our brand identity and creating a consistent visual language across our digital platforms. The logos and icons must be original and not copies of other images found online. I am looking for...

I'm looking to hire a packaging designer to create a product packaging design exclusively for a metal-based packaging for sampling. Key Requirements: - Skilled in creating pr...packaging designs, particularly for metal materials. - Able to understand the branding and the target market of the product to create a design that resonates with them. 1 design for chewing gum, 1 design for chewable candy. Please review this - Optional Skills: - Knowledge in sustainability and child-proofing features would be preferred, although it's not mandatory for this project. Please provide examples of metal-based product packaging designs you've worked on in the past. Please give accurate timeline and budget.

... 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 DBT and SQLITE. The goal is to ...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 d...

...skills in APA 7th edition format for configuring research tables. Even though proficiency in APA 7th edition standards is paramount in this project, having an insightful understanding of data organization and presentation will be appreciated. In this project, efforts will be channeled towards changing 7 existing SPSS tables to match APA 7th edition requirements, including double-spacing, 12 point-font, Times New Roman font style, and, if needed, notes under the table or necessary italicization or bolding of headers/keywords. Manual entry of descriptive text and data values to form each independent table is needed. In other words, raw data cannot be provided to manipulate or recompute in SPSS or any other program! The SPSS tables currently display: Table 1. 4 colu...

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 sk...-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 yellow column in Excel.

I am in need of a skilled Wordpress developer who can create a custom business website for me using Elementor Pro. This project includes: - **Design and Layout:** You will need to design a visually appealing business website that conveys professionalism and trustworthiness. It should have a responsive design that adapts well to different screen sizes. - **Colo...the menu i want to work as follow: Overlay on the Video with light gray until i start scrolling down and THEN background should change to white. (and color of menu Items invert) As here () Rest is fine and we will then costumize the content add forms etc. All must be done in elementor Pro. Page must work on regular screens / Phones and tables. Should use all screen width.

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

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.