Can write queries sql envoriment needdela

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I need you to write some content for a website. Sem vrhunski pisec vsebin. Ker imam zelo siroko znanje iz razlicnih podrocij, lahko pisem zelo hitro in vsebinsko mocne tekste.

CRM WebApp Project: We need CRM with Wordpress can be elementor and theme, please see the links, read well, before you bide, make your best offer, I will choose the best offer price and deadline Functionalities: Client page: If we enter email or a phone that already exists it show immediately the number of CRM and the lead us to the CRM number CRMxxx We have many Tasks by numbers: T1 …….. To T35 For each task we can set up date, hour and the way to be done, in main page and by email we will receive alert for task that need to be done with number of task, number of CRM (client number) and the way that need to be done (W, Emai, SMS, Tel, Phone call, …). When we set up the task we can see it as the task is SET UP Some of the ...

I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. The goal is to process a multitude of json files housed in a particular folder. Please refer to the assignment document for detailed instructions Step 1. Initial Setup: ● Use DBT and SQLite to create a pipeline that processes files from a folder structure. You can access the folder here Step2: Adaptation for Continuous File Deliveries: ● Adjust the pipeline to handle continuous file deliveries, where new folders with JSON files are added over time. For example: Step 3: Data Quality Assurance: ● Create a suite of data checks to ensure the data is clean and add a DBT command to run these checks. ● Suggest additional information or metrics that could be used to further ensure da...

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

I need a social media expert with profound knowledge in stock market who could distribute information daily on Reddit, Facebook, and Twitter. Key tasks: - Distribute stock news, analysis, and recommendations on a daily basis on aforementioned platforms - Must be up-to-date with what’s happening in stock market and accordingly distribute relevant information - Promptly answer any comments or queries to maintain engagement Ideal freelancer: - Experience with social media management - Basic understanding of stock market terms - Excellent communication skills - Proactive, punctual, and reliable

I am looking for a skilled developer to c...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, 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 Se...

I want to get more followers on this account for business proposes at least should be done before three days

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

Project Title: Write the life of my father and his story. The evacuation in the war, the bombing of the two family homes and his move from poverty in London to a middle class career. I am seeking a talented freelancer to write a captivating biography about my father's life, focusing on his experiences during the war, including the evacuation, the bombing of our family homes, and his journey from poverty in London to a successful middle-class career. Specific Events and Anecdotes: - I will provide a list of specific events and anecdotes that I would like included in the biography. Style and Tone: - The biography should have a narrative and storytelling style, capturing the essence of my father's life and experiences. Perspective: - The biography should be written...

As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the 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 ov...

...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're excited to collaborate with a dedicated professional ...

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

...for a 250ml Energy Drink Can. Key Responsibilities: - Develop a unique, modern look that conveys energy and excitement. - Ensure design stands out on store shelves amongst competition. - Incorporating mandatory information into the design layout. Ideal Candidate: - Has experience in beverage packaging design, with a portfolio showcasing this. - Can work quickly and efficiently to meet a 'ASAP' deadline. - Able to effectively communicate throughout the project, providing updates and revisions as needed. If you think you're the right fit for this project, please include examples of your previous work in your proposal. Inspire yourself of our website Not too much colors please. The name of the DRINK is: "YAM ENERGY" Please write &q...

...Snipepay as a payment gateway in WooCommerce. Our hosting company currently sets up client accounts manually through a control panel that supports API integration. The successful development of this project requires extensive knowledge of this API to enable full automation of the account setup, hosting package ordering, and management processes directly from our WordPress site. The developer will need to ensure seamless communication between our WordPress interface and the control panel's API, enabling users to perform all actions in an automated, user-friendly manner without manual intervention. This includes the ability to manage domains, select hosting packages, and complete purchases with full integration of the payment systems we plan to use. Requirements for the...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

...owner, I'm in need of a diligent freelancer who can take on the critical roles of Email Handling and Data Processing within our Shopify platform. - **Email Response Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume...

...owner, I'm in need of a diligent freelancer who can take on the critical roles of Email Handling and Data Processing within our Shopify platform. - **Email Response Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume...

I'm seeking an expert for a data migration endeavor from Salesforce Classic to Lightening Starter. This project involves: - Moving over 12,000 Accounts and Opportunties - Several custom fields need to be replicated in Opportunties - Total of three users - Migrate Notes, Reports, and Attachments This process demands careful handling of data to ensure smooth transition with no data loss. The data currently exists in the Salesforce Classic version. Experience with Salesforce Classic and the newer Lightning Starter version is necessary. Perks for the job: - Salesforce certification or proven experience in Salesforce data migration - Familiarity with data sets (10,000+ records) - Ability to mitigate risks involved in data migration and ensure full data integrity - Good pr...

...namely (but not exclusively), data inconsistency and significant performance issues. • Data Inconsistency: There's a rampant issue of missing and incorrect data circulating within the system. This issue impacts the integrity of the entire project and lowers its efficiency. I am seeking a professional who can help identify the source of the inconsistency and implement a permanent fix. • Performance Issues: I am dealing with certain performance issues, specifically very long database queries. Additionally, the task reassignment isn't functioning as it should, and data entry is also compromised. Ideally, I'm looking to enlist the services of a professional who possesses a strong background in database management and Spring Boot. Proficiency in diag...

...namely (but not exclusively), data inconsistency and significant performance issues. • Data Inconsistency: There's a rampant issue of missing and incorrect data circulating within the system. This issue impacts the integrity of the entire project and lowers its efficiency. I am seeking a professional who can help identify the source of the inconsistency and implement a permanent fix. • Performance Issues: I am dealing with certain performance issues, specifically very long database queries. Additionally, the task reassignment isn't functioning as it should, and data entry is also compromised. Ideally, I'm looking to enlist the services of a professional who possesses a strong background in database management and Spring Boot. Proficiency in diag...

It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and 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 bdomain

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 require a talented photo document editor capable of editing files by adding names and altering dates. The specifics of the project are as follows: - Add specific names at the top of the document - Change the dates within the document Ideal candidates will exhibit the following skills and experience: - Proficiency in photo editing soft...candidates will exhibit the following skills and experience: - Proficiency in photo editing software, such as Adobe Photoshop - Attention to detail for precise text placement - Strong knowledge of fonts, alignment and character spacing - Adept at maintaining the authenticity of documents while making changes - Previous experience with similar editing projects Feel free to ask if you have any queries related to the project. Looking forward to ...

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'm in need of a skilled Python developer with a strong background in AI and ML. The project involves a full spectrum of responsibilities in these fields, and I'm looking for a professional who can hit the ground running. Key Responsibilities: - AI Development: You'll be tasked with creating, implementing and maintaining complex AI algorithms and systems. - ML Model Development: This role will require you to design, train, and optimize machine learning models. - Data Analysis: You'll need to collect, interpret, and present data in a meaningful way, to help inform our AI and ML projects. Required Skills and Experience: - Expertise in Python is a must. You should be comfortable with Python libraries and tools commonly used in AI and ML projects. - P...

I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.

...written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I will share my screen through team...

It’s Urgent! We need to write a shell script It’s too simple and not more than 2-3 hours job if candidate is good at shell script. It’s a small project but if we are satisfied we will give you more project in future . You thave to automate these task , Now i am doing this manually ---------------------------------------------------------------------------------------------------------- have to accept the subdomain as input and 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 bdomain

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

I'm 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 efficienc...

I'm 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 efficienc...

...programs in e-commerce systems - A good understanding of security features to ensure customers' data is protected - Excellent communication skills to understand and deliver on the specific requirements Please note that I'm open to any suggestions or proposals that you may have to enhance this project further. I look forward to seeing how your skills and expertise can bring these ideas to life. I have prepared a document I can send with work we require, as this is sensitive and confidential, I would appreciate making contact first with a developer before sending it. Below is some some information from the document i have prepared NB.. although I have selected a budget of £1500 - £3000 I am prepared to pay more for other recommendations you may hav...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...considered to calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for th...

I'm looking for someone to help me set up Zobot Zoho for my cus...chat: I want my customers to be able to easily chat with our agents. - Implement automated ticketing: I need the system to efficiently create and manage support tickets. - Set up FAQ self-service: I'd like to reduce the workload on my team by having a self-service option for common queries. The ideal freelancer will have: - Proven experience in setting up Zobot Zoho - Strong understanding of customer support systems - Familiarity with integrating live chat and ticketing systems - Ability to create a user-friendly FAQ self-service interface - Excellent communication skills to ensure a smooth handover to my team. Please note that my team consists of 5-10 agents, so the system will need to be ...

I need a focus-driven developer to build a web application for my travel agency. The purpose of the application is to implement a backoffice system for managing bookings. The functionalities I'm aiming are: - User needs to enter details like Agency name, pax name, mobile number, pick up location, pick up time, date of flight travel, flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in...

I'm looking for a skilled web developer to create a website that is tailored for a teenage audience. Key Features: - The website is primarily informational, hence the main focus should be on providing clear, engaging and relevant content for teenagers. - One of the key features I need is a Contact Form. This is to ensure that the teens visiting the site can easily reach out to me with any queries, comments or feedback they might have. Ideal Skills: - Proficient in Web Development with a good understanding of UI/UX especially for a teenage target audience. - Experience with integrating and customizing Contact Forms. I'm open to your suggestions on how to best cater to the teenage demographic. Please include any relevant experience you have in creating si...

...guest interactions. Key Responsibilities: - Schedule Management: The assistant should help me keep track of my appointments, deadlines, and important dates. This includes setting reminders and ensuring I'm always aware of my upcoming commitments. - Data Entry: There will be a need to input various types of information into spreadsheets or databases, ensuring accuracy and efficiency. - Guest Interactions: Good communication skills are essential. The assistant will be in charge of interacting with guests, handling queries, and providing assistance in a professional manner. Ideal Candidate: - Experience in virtual assistance or similar roles. - Proficient in the use of mobile apps, computer software, and web applications for virtual assistance tasks. - Excellent organi...

I need someone who can edit some text in a pdf file very easy work need little changes only people who can do it direct

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managin...

I am facing a recurring issue where PrivateGPT, which used to run smoothly on Ubuntu 22.04.4 LTS on Windows 11, is now crashing repeatedly. This problem began after a series of file ingestions and proves persistent as it happens every time I now attempt to start up the software. Specifically, a Runtime Error is delivered, preventing the program from carrying on. I am looking for a freelancer with: - Exceptional problem-solving skills - Extensive experience with Ubuntu and Windows 11 - Advanced understanding of PrivateGPT In your application, I am particularly interested in your past experiences related to diagnosing and repairing similar technical issues. Looking forward to your assistance in resolving this issue. Thank you.

i need someone who are good about create any projects with python especially checkers emails to use for marketing

I'm looking to hire a freelancer to develop a specialized bot that can scan and analyze various cryptocurrency projects to identify coins with at least 5 pre-approved investors ready for purchase before their official launch. Key Features Needed: 1. Pre-Approved Investor Tracking: Implement functionality within the bot to monitor and track pre-approved investors who are prepared to purchase specific coins before they are officially launched. 2. Coin Scanner: Develop tools to scan and analyze a wide range of cryptocurrency projects to identify coins that meet the criteria of having at least 5 pre-approved investors. 3. Integration with Telegram/Discord: Enable the bot to deliver real-time updates and reports through Telegram or Discord, showcasing coins that meet the pre-ap...

I'm looking for a professional who can help me scrape detailed product information from a website that I will share with you. This data should be filtered according to specific product details. Key Requirements: - Retrieving product information including SKU, Category, Sub-Category, Color, Gender, Age, Material, Sleeve Length - Implementing a filtering mechanism to sort and organize the scraped data - Attention to details for accurate data scraping The ideal freelancer for this job should have: - Experience in web scraping and data mining - Strong understanding of data sorting and filtering - Proficiency in managing and storing large sets of data - Excellent communication skills to understand and address any queries regarding the project Looking forward to working tog...