Sql server database connectivity pivot tableKazi
Site-uri web,IT si Softaware limbaje PHP, WEBSITE DESIGN, Graphic Design, HTML, C++, SQL
Mandatory Skills: • Java-J2EE, Hibernate JSF - JavaServer Faces, JDBC - Java Database Connectivity, XML, Java-J2EE, Web Services, Web 2.0 Desirable Skill • Spiring
Mandatory Skills: • Java-J2EE, Hibernate JSF - JavaServer Faces, JDBC - Java Database Connectivity, XML, Java-J2EE, Web Services, Web 2.0 Desirable Skill • Spiring
Web design, poznavanje softwara , Data base arhitecture za travel site
مطلوب تصيم تابل تنت ثلاثى بلون الكاافية واشكولاتة لعرض منتجات فرابيه ولاتيه لعرص 6 مشروبات مشروب ومكان للسعر يكتب يدويا 2 فى كل ناحيه لوج الشركة والويب سيت للشكة المصنعة فى الاسفل ولوجو الكافيه فى الاعلى *31*22 كل ناحيى 10 وواحد سنتى لللذق
Zdravei Radoslav, Tursq si web developer na Python sus slednite sposobnosti: *Legacy Django (<1.2) project needing brushing up to 1.4/1.5. Deep knowledge of Django/Python best practices. Skills: - Python (4 years) - Django (2 years) - SQL & Django-South (2 years) Dobro zaplashtane. Svurji se ako si zainteresovan. Inna Amesheva
...<image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category> <category> <name>category 2</name> <image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category> i will provide 2 tables sql file...
...website updates (Framer experience preferred). - In-depth understanding of US markets and marketing trends. - Strong English communication skills (written and spoken). - Availability during EST hours for meetings and collaboration. - US-based or experience working with the US market is a plus but not required. - Ability to maintain brand consistency across all platforms. - Flexibility to pivot strategies and tools as needed. Timeline & Budget: - Timeline: Must be completed in 60-85 days. - Budget:$450-$750 (strict adherence required). How to Apply: Submit a proposal including: 1. Your approach to building brand awareness and driving sign-ups. 2. Your experience with similar projects. 3. Tools you’ll use for this campaign. 4. Confirmation that you can...
...candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Ideal skills and experience: - Extensive experience with Microsoft Excel, particularly with VLOOKUP, charts, and pivot tables. - Previous experience in ...
...with eligibility and fees. - **Fees Structure:** Table format showing detailed fees. - **Placement Statistics:** Information on previous placement rates and top recruiters. - **Facilities:** Icons and descriptions for hostels, labs, libraries, and sports facilities. - **Reviews & Ratings:** User-generated reviews with a star rating system. - **Apply Now Button:** Large button at the top and bottom of the page, redirecting to the application form. --- #### **4. Course Information Page** **Sections:** - **Overview:** - Brief about the course, duration, eligibility, and career prospects. - **Top Colleges Offering the Course:** - List of colleges with course-specific details and "Apply Now" buttons. - **Fee Structure Comparison Table:** - Colum...
I'm in need of a detail-oriented freelancer for a data entry project. The task involves manually entering data from PDF files into a database. Ideal Skills and Experience: - Proficiency in manual data entry - Experience working with PDF files - Familiarity with database systems - High attention to detail - Ability to maintain confidentiality and handle sensitive data with care.
I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data retrieval tasks.
I need a Tableau project that visualizes an organizational hierarchy. Requirements: - Create a comprehensive 'top office' table that includes the Manager, Supervisor, and CIO roles, detailing their responsibilities. - Design a three-level structure where the top office can see under their Supervisor and Manager, while the Supervisor and Manager can see under their employee ID and Name. - Ensure that the Supervisor and Manager are also recognized as employees under the top office. - All employees should see who their direct boss is. Ideal Skills: - Proficient in Tableau with prior experience in creating hierarchical visualizations. - Strong attention to detail to ensure accurate representation of the organizational structure. - Ability to understand and represent complex...
Tafadhali Jisajili ama Ingia ili kuona maelezo.
I'm in need of a proficient freelancer or a professional agency capable of curating and delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're ...
...processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformations Execute SQL procedures and queries in RDS for additional analysis and derived insights. Store final results in the database for website access. RESTful API Development Build a secure RESTful API using AWS API Gateway and Lambda to provide real-time data to the website. Optimize database queries to minimize latency and maximize efficiency. Non-Funct...
I need help completing a Tableau project. The project includes: 1. Creating a top office table that features the big boss and all higher management, including supervisors and CIOs. 2. Implementing a three-level hierarchy where the top office can see everyone under their line of command, including managers and supervisors. 3. Allowing supervisors and managers to see their respective employees by ID and name. 4. Ensuring that supervisors and managers are also listed as employees under the top officer. 5. Developing a system where each employee can see who their immediate superior is. I am open to suggestions regarding the top office table's content, but ideally, it would include names, roles, and departments. Ideal skills for this project include: - Advanced proficiency in...
I need a seasoned Windows Server Administrator with robust Active Directory management experience. This ongoing project involves configuring group policy for security settings, software installation, and user configurations. Ideal candidates should: - Have in-depth knowledge of Windows Server and Active Directory - Windows OS Hardening - Demonstrable experience in Group Policy configuration - Ability to ensure compliance with security protocols - Proficient in managing software installation through group policies - Skilled in user configuration settings Your role will be pivotal in enhancing our server environment's operational efficiency and security.
...PROCEDURAL - I have done this already just tweak the amount of specular, texture, glass, e.t.c in hypershade. - I HAVE ALREADY DONE THE MODELING and the LIGHTING/COLOR. I will provide you the maya file to make IMPROVEMENTS of the original. -There are some elements I want you to change color/material on to make more realistic for e.g the crossiant, baguette, maple syrup on the pancake, fruits, the table you can change completely and add something simpler and finally the cupcake wrapping paper make more neutral. I must recieve: - MAYA file -5 FINAL renders in different angles. -Minimum FullHD 1080 or 2k Square, jpeg (I have put some example final renders I want you to render similarly like) If anything is unclear ask questions I will give you more details. Don't do s...
I need help with explore an Oracle database on my Windows 11 machine, this project will be conducted remotely for security purposes. Please note, this project will be conducted remotely for security purposes, so a reliable and secure remote connection is essential. Your understanding and expertise in these areas will ensure the successful completion of this project.
preciso de uma pessoa perfeita para entendimento de servidores
We are looking for a creative and professional logo and app icon for our platform, Cereale App, a marketplace for buying and selling cereals. The design should reflect the essence of our application: simplicity, connection, and agricultural innov...like "Cereale de vânzare". It should convey trust, professionalism, and relevance to the agricultural/cereal market. The app icon must be visually distinct and recognizable, working well in both small and large sizes. Deliverables must include vector formats (e.g., AI, EPS) and standard sizes for app icons. Notes for freelancers: Feel free to explore ideas related to grains, fields, or digital connectivity. Keep the design clean, modern, and professional. Avoid overly complicated details – the logo and icon should st...
I'm currently grappling with Many-to-Many relationships in Power Pivot, specifically dealing with sales and event data by SKU. My primary aim is to enhance the precision of my data analysis. However, I'm facing difficulties with incorrect data aggregation. I cannot build a relationship from the Proof and Unique Events table in the photo provided. Skills and Experience Needed: - Extensive experience with Power Pivot - Proficient in managing and interpreting sales data - Expert-level understanding of Many-to-Many relationships - Ability to troubleshoot data aggregation issues
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
I'm seeking a freelancer to run a Python script that scrapes the entire DataAxle database of 18 million companies. The end goal is a comprehensive spreadsheet that includes all available fields. Example fields include: - Company name and address - Industry and revenue - Number of employees and contact details - SIC Code - SIC Code Description The primary purpose of this data collection is for sales leads generation. Ideal Skills: - Proficiency in Python - Experience with web scraping - Familiarity with DataAxle or similar databases - Ability to generate clean and comprehensive spreadsheets - Understanding of sales lead criteria
I require a seasoned Network Administrator to assist with managing my Linux server. The primary task involves configuring the server to block and allow specific API calls. Ideal Skills: - Extensive experience with Linux servers - Proficient in network administration - Familiar with various API types (REST, SOAP, GraphQL) - Knowledge of server firewall tools (iptables, UFW, Firewalld) - Strong problem-solving skills
I'm seeking an Android app developer who can create a application for statistical analysis. This app should allow users to input data through a simple form and receive output ranging from basic summary statistics to various hypothesis tests. Key Features: - Data Input: Users should be able to input data in the form of a list or table via a simple form. - Statistical Output: The app should compute and display basic summary statistics (mean, median, mode, variance etc.) and the results of hypothesis tests (t tests, chi square tests, ANOVA etc.) as a text summary. Ideal Skills: - Proficiency in Android app development. - Experience with statistical analysis software/tools.
Website Revamp with New UI/UX Design I need a complete redesign of my current website with a new UI/UX but keeping all functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained
...programmer for native Android development. The task at hand is to create a client-server application for managing mobile clients. It's crucial that you have substantial experience working on such applications. Key Requirements: - Expertise in Java or Kotlin for Android development - Proven track record of developing client-server applications - Immediate availability for urgent project commencement In this long-term project, there's potential for permanent hiring. I will consider professionals who demonstrate commitment, deliver quality work, and have sufficient availability to dedicate to this project. Please note, the specifics of the application functionalities, the type of database to be used, and the method of server interaction have yet to...
I'm looking for a proficient Terraform developer to create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL) (a service running in GKE) 6. IAM Role Binding for Cluster Access
I have several Excel/CSV files containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data ...containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data accuracy. - Experience with data entry and database m...
I'm seeking a professional to assist with migrating my Laravel website to a dedicated server. The job includes transferring the database and pointing my existing domain to this new hosting server. Key Responsibilities: - Migrate Laravel website to a dedicated server - Transfer the database - Point existing domain to the new server - Update the Laravel framework during the migration - Implement specific server configurations as required Ideal Candidates Should Have: - Extensive experience with Laravel and server migrations - Proficiency in configuring dedicated servers - Capability to update the Laravel framework - Knowledge of required specific configurations - Excellent problem-solving skills to ensure a smooth transition
...creation, participation, and resolution of disputes, along with strict adherence to security measures. The backend should be robust, efficient, and secure, supporting APIs tailored for the roles. Frontend elements will ensure user-friendly interactions for Players, Admins, and Super Admins. Key Project Requirements: Roles and Access: 1. Players: ◦ OAuth-based login system (Google). ◦ Separate database table for Players for added security. 2. Admins: ◦ Email-password authentication. ◦ Manage player disputes and KYC processes. 3. Super Admins: ◦ Same login flow as Admins. ◦ Elevated permissions for dispute resolution and platform oversight. Features for Players: 1. Authentication: ◦ OAuth-based login (Google) (Already Implemented). ◦ Logout functionality (Already Implement...
We are seeking an experienced Excel expert to assist in developing a dynamic and user-friendly Excel dashboard or summary tab for our HR team. The project will involve leveraging pivot tables and other advanced Excel functionalities to create an interactive and automated reporting tool that provides clear insights into key HR metrics. The ideal candidate will have a strong background in data visualization, formula optimization, and dashboard design to ensure efficiency, accuracy, and ease of use. Our goal is to enhance data analysis and reporting capabilities, allowing the HR team to make informed decisions effectively. Delivery flexible but ideally within 2 or 3 weeks
I am in need of a skilled System Admin for my Linux and Ubuntu servers. Key Responsibilities: - Regular updates and patching: Ensuring the servers are up-to-date and secur...skilled System Admin for my Linux and Ubuntu servers. Key Responsibilities: - Regular updates and patching: Ensuring the servers are up-to-date and secure. - Performance monitoring: Keeping an eye on server performance and addressing any issues that arise. Ideal Skills and Experience: - Extensive experience with Linux and Ubuntu server maintenance. - Proficiency in performing regular updates and patching. - Strong skills in monitoring server performance. I'm looking for someone who can keep my servers running smoothly and securely. Your expertise will be crucial in maintaining the health...
I'm in urgent need of a cyber security specialist who can perform thorough penetration testing on my React web application. The primary goal is to identify any potential security vulnerabilities, particularly: - Cross-Site Scripting (XSS) - SQL Injection - Cross-Site Request Forgery (CSRF) Your expertise in assessing these specific types of vulnerabilities will be crucial. The ideal candidate would also have experience in Quality Assurance, particularly with automated testing tools such as Selenium and Cypress. Your role will not only involve identifying security vulnerabilities, but also ensuring the overall code quality through automated testing. Please include in your proposal your relevant experience and any examples of previous work that may be applicable. Thank you.
I need a freelancer to set up a daily backup of my Microsoft SQL Server database from a dedicated Windows server to S3 AWS Storage. The backup files need to be compressed. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server - Experience with AWS S3 - Knowledge of Windows Server - SQL database management - Data compression techniques
...Achievements: Document Creation and Formatting: Created and formatted professional documents, reports, and proposals using Microsoft Word. Implemented advanced formatting techniques and customized templates to ensure consistency and professionalism. Data Analysis and Visualization: Developed complex spreadsheets in Excel to analyze financial data, track budgets, and visualize trends. Utilized formulas, pivot tables, and charts to provide actionable insights and support decision-making. Presentation Design: Designed engaging and visually appealing presentations using PowerPoint. Incorporated multimedia elements and custom templates to effectively communicate key messages and captivate the audience. Email and Calendar Management: Managed email communications and organized calen...
I'm looking for a Typescript expert to write Typescript serverless functions to: OLD SYSTEM -> Webhook -> Serverless Function -> New Database and OLD SYSTEM <-> Crap API <-> Serverless Function <-> New Database Bidirectional sync Webhook includes the data that needs to be updated in a timely manner Crap API can sync other data (non-timely) and verify the webhook data was correct to update periodically Challenges include: - Inconsistent webhook formats - Unreliable API behavior of old system - Token management of old system API Technical Stack: - Serverless Functions - Database - Modern TypeScript Deliverables: 1. New Database configured with schema and operational 2. Working and fully tested serverless functions - Webhook Han...
I need an expert to update my iOS app Carplay improvement. Carplay works but there are some problems. i need standalone working support for carplay, when user dont open app on device, carplay cant fetch content(radio) and cant play. The project entails: - Improving carplay - Fixing issues - Updating deprecated AP...problems. i need standalone working support for carplay, when user dont open app on device, carplay cant fetch content(radio) and cant play. The project entails: - Improving carplay - Fixing issues - Updating deprecated APIs - Updating deprecated codes It is crucial that you have extensive experience with iOS development and Carplay integration. Familiarity with identifying and rectifying connectivity issues within Carplay is highly desirable. I look forward to your...
I'm looking for an expert who can help me visualize my 2D apartment layout in a modern 3D format. Key Tasks: - Suggest ways to enclose a specific area for a small, work-from-home office. - Provide a 3D representation of how the kitchen, kitchen island, dining table, and living room could look, focusing on modern design aesthetics. - Pay special attention to furniture placement, ensuring optimal space utilization. Ideal Skills: - Proficiency in 3D modeling software (like SketchUp, AutoCAD, etc.) - Strong understanding of modern design principles. - Excellent spatial awareness and visualization skills. This project will help me understand the potential of my apartment and make informed decisions about my space.
I'm in need of a detail-oriented freelancer for a data entry project. The task involves manually entering data from PDF files into a database. Ideal Skills and Experience: - Proficiency in manual data entry - Experience working with PDF files - Familiarity with database systems - High attention to detail - Ability to maintain confidentiality and handle sensitive data with care.
...metadata via a user-friendly web interface, and using OpenAI's embedding with a vector database and GPT APIs to retrieve and generate new content. This will be a new independent prorotype project to get the integrations and workflow set up and working correctly. Full-Stack Developer (Preferred One-Dev Solution) Responsibilities: Develop and maintain a backend pipeline to: - Scrape and preprocess data from client websites. - Chunk content into JSON packets and prepare it for tagging. - Integrate with Supabase for data storage. Build a simple web app for manual metadata tagging: - Design a clean UI for reviewing and tagging content. - Integrate pre-defined tag options for consistency. Set up a vector database for semantic search. Integrate OpenAI’s text-emb...
I'm looking for a skilled Snowflake developer with extensive experience in data warehousing. The project involves integrating various data sources, primarily AWS S3 and SQL databases, with Snowflake. Key Responsibilities: - Data Warehousing: You'll be primarily focusing on the data warehousing aspect of Snowflake. - Data Integration: Integrating AWS S3, SQL databases, DBT, and Snowpark with Snowflake. - Data Transformation: Your main use of dbt will be for data transformation. Ideal Skills: - Proficient in Snowflake, dbt, and AWS. - Experience with data warehousing and integration. - Hands-on experience with live projects using these technologies. - Strong understanding of data transformation processes. Successful candidates will have previous experience working...
I need a designer to help me visualize a modern kitchen with a black and stainless steel color scheme for a potential apartment purchase. The design should in...need a designer to help me visualize a modern kitchen with a black and stainless steel color scheme for a potential apartment purchase. The design should include a kitchen island with extra seating and storage, as well as a dining table and a small office area in the open space. Ideal Skills: - Interior Design - 3D Modelling - Space Planning - CAD Software Proficiency Requirements: - Create a modern style kitchen visualization - Use a black and stainless steel color scheme - Design a kitchen island with additional seating and extra storage - Incorporate a dining table - Propose a design for a small office space wit...
I need a Python Data Analyst skilled in processing data from an SQL database and conducting descriptive statistics.
16. Production Planning Objective The elaboration on this point should answer the following questions: How many machines and assembly places do you need from which kind? Please consider a r...necessary takt time Selection of suitable machines Estimation/Assumption about necessary production time per piece Assumption of a reasonable OEE Definition of Lotsizes (if necessary) Calculation of necessary machinary Assumption of assembly times and equipment Expected results Table with necessary manufacturing times per piece an the referring calcluation Table with the necessary number of machines and the referring calculation Flow chart for the assembly operations including necessary assembly times and workforce Table with the necessary workforce An exact floorplan / factory ...
...items. Testimonials Section: Placeholder for user feedback. Call-to-Action Section: Encourage users to sign up for free access, login, contact us. Comparison Page: A page that dynamically displays comparison results based on API data. Key features: List View: Display items matching the search query. Filters: Allow users to filter results by parameters like price, rating, or features. Comparison Table: Detailed comparison of attributes such as cost, features, and ratings. Action Buttons: "Learn More" or "Contact" buttons for each option. we can discuss this in detail after project allocation. Technical Requirements: Frontend Framework: React.js. API Integration: Fetch and display data from provided REST APIs. Responsive Design: Ensure optimal performance ac...
...web-based systems. -- Work on web development projects using Python and associated tools. -- Ensure code is scalable, maintainable, and efficient. Required Skills: -- Strong experience in Python (3-5 years). -- Proficient with Selenium WebDriver for web scraping and automation. -- Experience with BeautifulSoup, Requests, Scrapy, and other web scraping frameworks. -- Solid understanding of Databases (SQL/NoSQL) and integrating them with web applications. -- Experience in web development (preferably with frameworks like Django or Flask). -- Strong knowledge of Flutter for mobile development. -- Ability to work independently and deliver quality code within deadlines. Additional Requirements: -- Proven experience of 3-5 years in Python and web development. -- Strong problem-solving...