Sql dashboard jobs
... 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 ...
...functionalities. Theme Selection: Choose a free WordPress theme optimized for eLearning platforms. Popular options include Astra or OceanWP. These themes are customizable and integrate well with LMS plugins. Stage 2: Development and Integration (2-4 weeks) Course Creation: Develop your course content (video lectures, quizzes, downloadable resources) and structure it using your LMS plugin. User Dashboard & Profiles: Utilize the built-in user management features of WordPress to create user dashboards where learners can track their progress, access course materials, and update profiles. AI Application Integration: Explore cost-effective AI chatbots or virtual assistants (VAs) to integrate basic functionalities like answering FAQs or offering course recommendations. Conside...
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 ...
I am in need of a highly experienced Laravel developer who will work on the backend of my Android application, which is a Reward earning/Bidding app. I'm looking for developers skilled in managing APIs and databases within an admin panel. Specific requirements include: -User management -Content management -Analytics dashboard -Payment API -Email marketing API Database expertise must include: -MySQL These elements are integral for the functionality and efficiency of the application. I am looking forward to collaborating with someone who can deliver these specifications.
...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....
I have a wordpress website, it has a plugin I use, but when people go to the website to use from mobile, it is clunky. What I want is an IOS and Android App that will allow a user to login and use only the pages of the plugin, i.e view and edit projects, tasks etc, everything functions, but I want to remove the framework around it, so the app will just run the plugi...framework around it, so the app will just run the plugin component to it and maybe allow them to edit their wordpress user profile, i.e update their details. The plugin I am using is called Taskbuilder The app should; 1. Provide a login screen (which is the wordpress login credentials) 2. Go straight to the plugin page but dont show the wordpress dashboard and frames etc.
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.
... incorporating the capabilities of the Perfect AI Software Template. This MVP will validate the concept by offering essential functionalities such as AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project encompasses the following key tasks: Template Customization: Adapting the AI SaaS Dashboard template to fit the unique branding and functional requirements. Database Integration: Configuring and linking an external Airtable database to import and regularly update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT A...
...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 looking for an experienced Power BI expert to create a detailed dashboard for my project. The task revolves around performing sentiment analysis on comments made on Nike's YouTube channel. The dashboard will display any relevant metrics or insights that help grasp the overall sentiment. While it's not clearly specified, a sentiment breakdown by video could provide valuable insights, just like the employment of trending keywords in the comments. The ideal candidate has proven experience in Power BI, a knack for data interpretation, and an understanding of sentiment analysis. Time is of the essence in this project, as I need it to be completed ASAP.
Covid vaccation 1 and 2 dose Covid 19 vaccation dose by country dose by 100 hundred People
...data from excel files into a Power BI dashboard. Key Project Details: - The primary data source is excel files. It's crucial that the freelancer is proficient in Excel for extracting, cleaning, and transforming the data. - Dataset is farmers data including demographics and crop details. - The main focus of this project is on data visualization. I need the dashboard to present the data in a clear, visually engaging way. - The dashboard will be updated quarterly. Ideally, the freelancer should set up a process for this to be done efficiently and accurately. The task involves: - Understanding the data and the requirements for visualization - Cleaning the data to make it suitable for the dashboard - Identifying and creating KPIs to be included in dashb...
I am seeking a proficient developer who has expert experience with .NET MAUI 8 and Firebase. My iOS application, developed in .NET MAUI...Firebase. My iOS application, developed in .NET MAUI 8, has been integrated with Firebase Crashlytics, but it is not reflecting crashes on the Firebase dashboard. The unusual part is that the crashes occur, but without any indicative error messages. The type of crashes has not been identified as the related data was not captured properly. I am testing it in the DEV environment with a RealDevice (iPhone). Ideal skills and experience for this job: • Thorough understanding and expertise in Firebase Crashlytics on iOS Your primary objective will be to troubleshoot the issue and ensure crashes are accurately reflected on the Firebase Crashlyti...
I'm looking for a seasoned UI/UX designer to create intuitive and functional admin and supplier dashboards for my e-commerce application. Admin Dashboard: - Sales Analytics: I need visually appealing and insightful integration that can facilitate the comprehension of sales trends. - Inventory Management: Permit easy tracking of in-stock products, ones to be restocked, and comprehend current trade flows. - User Management: The dashboard should provide mechanisms for managing customer and employee accounts seamlessly. Supplier Dashboard: - Product Management: Suppliers should be capable of adding, editing, or removing their products effortlessly. - Order Management: An efficient way for managing orders, cancellations, returns, and exchanges. - Payment Tracking: ...
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...
... - Users must register using their school email address. - Registration form includes fields for Name, Email Address, and Phone Number. - Email verification is required to 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 dis...
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...
...will integrate maintenance request tracking and accounts tracking into a single dashboard, providing property owners and maintenance staff with a consolidated view of all aspects of property management. Key Features: Maintenance Request Tracking: The app should allow users to submit, track, and manage maintenance requests. This feature will streamline the handling of various maintenance issues and improve efficiency. Accounts Tracking: The app should have an intuitive accounting system for financial tracking and record keeping. It should provide easy access to financial data. Implementation: The maintenance request tracking and accounts tracking functions should be seamlessly integrated into a single dashboard. This will provide users with a consolidated view of all p...
... 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 to create a pipeline utilizing DBT and SQLLITE. T...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 am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
...search results. I want to do something similar, and also include the option to subscribe to more frequent monthly postings for a better price-per-post. This would mean I need 2 paths to purchase - one where anyone can post for $5/each and another where a user can create an account with a recurring subscription based on the number of posts they want per month. In this case they will need a simple dashboard for creating/editing listings and managing their subscription. I will also need your help customizing some of the theme design, such as page layout & UI, header, footer, and branding. I'll need some better functionality such as an improved search bar and updated filters. Will also need you to deploy to my domain with SSL. Ideal freelancers should have experience in de...
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 includin...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 yellow column in Excel.
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 a seasoned app developer to design and construct a dashboard screen for my pre-existing app. This screen should focus on a minimalist aesthetic, enabling a clear, clutter-free user interface. Key Tasks: - Develop a dashboard screen within an existing app. - Ensure it displays user statistics and notifications. Required Skills: - Background in app development, mainly in dashboard functionality. - Extensive understanding of minimalist design principles. - Proven experience in creating user-friendly interfaces for displaying statistics and notifications. Please showcase any similar past projects and also familiarize yourself with the existing app before making a bid. An eye for simplicity and functional design is a must.
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...
...Image (4:5 ratio) Size: 960 x 1200 pixels Quantity: 1 Format: PNG Notes: suitable for vertical website banners. Total number of graphics: 6 Visual Style: Maintain ™’s brand colors and typography to ensure consistency and brand recognition. Utilize clean, modern design elements that reflect the sophisticated nature of the software. The design should prominently feature the dashboard interface or iconography representing the various tools and functionalities offered (CRM, analytics, social media, etc.). Asset Types and Specifications: Facebook Cover Banner: The design should be visually compelling but not too cluttered, as it needs to communicate effectively within the constraints of Facebook’s layout. LinkedIn Cover Banner: This should be a more profession...
...Form 7 plugin - Should support multipage logic for better user experience - Collect and store user-provided data including: - Name and contact information - User input and preferences - Additional comments and feedback - Implement a method to save all incomplete form data. This data should be: - Sent to a designated email address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomplete data, specifically in a CSV format. This CSV should: - Have separate columns for each field to ensure easy data processing - Include timestamps for each form submission for traceability and analysis. The ideal candidate should be proficient in WordPress development, especially with Co...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...
...securely, and ensuring a seamless user experience throughout the website. Currency Converter: Implementation of a reliable currency conversion mechanism to allow users to view product prices in their local currency. Automated Sales Tracker: Integration of automated sales tracking functionality to monitor sales performance, manage orders, and analyze customer data. Dashboard for Distributors: Creation of a dedicated dashboard for distributors to track their sales, manage orders, chat or communicate privately with their respective customers without passing through an admin and access relevant information securely. Inventory Management: Implementation of robust inventory management capabilities to track product availability, manage stock levels, and streamline order fulfi...
As a data enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We...
I am looking for an experienced Power BI expert to create a project dashboard for me. This dashboard will be the central hub for monitoring the progress and success of our projects. Key Requirements: - Connect the dashboard to Microsoft Power BI. - Visualize data related to our projects, including but not limited to sales, finance, and marketing. - Include all key metrics and KPIs, such as revenue, customer acquisition cost, and conversion rate. The ideal candidate should have: - Proven experience in developing Power BI dashboards. - A solid understanding of project management principles. - Excellent data visualization and analytic skills. - A proactive attitude and great communication skills. This is a critical tool for our project management team, and we are look...
Tasks: W...is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Description Page Simple Dashboard (employer only) page with My Jobs Results Page for job seeker and for employer. Deliverable is the Website. I will provide the algorithms coded in python on 18th morning. You must integrate everything and a fully functional web application by 19th evening. DO NOT WASTE YOUR BID IF YOU CANNOT DELIVER. THIS IS A DEMO WEBSITE FOR A PROJECT but you HAVE TO BE ABLE TO HOST A...
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 t...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 yellow column in Excel.
...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
I'm seeking a proficient mobile app designer to develop an all-inclusive grocery delivery application. This application will cater to both iOS and Android platforms, emphasizing a seamless user-experience across all devices. Key Features: - For the admin dashboard, it should facilitate detailed inventory management, effective order tracking, comprehensive sales reports, and a seamless payment/checkout integration. - The app should incorporate a third-party payment gateway for a smooth, secure transaction process. Ideal Skills and Experience: - Proficiency in iOS and Android app design and development. - Comprehensive knowledge of inventory management, sales reporting, and order tracking integration. - Specific experience in designing apps within the grocery sector would be a...
I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...
I need assistance to perfect the login and dashboard functionalities of my nearly complete store inventory management system website. I require a polished user registration and login process, including: - Email verification for new users - Password recovery mechanism for existing users - High-security two-factor authentication protocol These implementations are crucial for maintaining a secure and user-friendly environment for me to release the website to end-users. I'm seeking professionals experienced in user interface creation and user experience enhancement. The project needs to be executed and completed ASAP, so timely delivery is important. Experience with similar projects would be advantageous.
I'm looking to develop...experience. Key Features: - Personalized Recommendations: The website should utilize AI to analyze user's browsing behavior, purchase history, demographic info, and other relevant data to suggest tailored products. - Whatsapp Business Integration: A key part of the project is integrating with WhatsApp Business to provide seamless customer support and order processing. - Merchant Dashboard: The platform will incorporate a dashboard for merchants to track sales, manage stock, and oversee their online store. The ideal candidate for this project is a developer with experience in e-commerce and AI integration. Proficiency with WhatsApp Business API and merchant platforms would be highly valued. A strong understanding of fabric clothing market w...
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart v... 4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs. NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal 6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export featur...
I have three separate ... and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic dashboards - A competent hand at data visualization techniques utilizing charts. Your job will be to deliver a user-friendly Excel sheet and a visually appealing, functional dashboard. Through this, we hope to improve our project tracking and analysis. ...