Sql queries for data analystmunkák

Mobil applikáció és webalkalmazás fejlesztéséhez keresünk fejlesztőket/programozókat. Az alkalmazás egy folyamatosan bővülő adatbázis adatai alapján végezne különböző összehasonlításokat, elemzéseket. A termékekről különböző ismérvek alapján rangsorokat, ajánlásokat tenne. Szükséges képességek lehetnek: felhő szolgáltatások ismerete, BigData, Android és iOS webapp fejlesztés, webfejlsztés (PHP, SQL, JS, HTML5, Python) adatvizualizáció, UX/UI dizájn, AI, verziókezelés. Az alkalmazásokhoz később fej...

Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi

Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi

Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi

Szia, MY SQL és PHP- webes programozásban tudnál segíteni? Lenne egy projectem. Köszi, Tomi

Szia! Hosdzú távra keresünk programozót/fejlesztőt, meglévő GTA V szerepjáték szerverünkre, ami a FiveM kliensen fut. - ESX keretrendszer - Linux VDS-en fut a szerverünk Mit ajánlunk? - Hosszú távú partnerség - Havi fix fejlesztési díj (50.000Ft) Mit várunk? - Aktivitás: nagyobb bugok, hibák feltárása...őt, meglévő GTA V szerepjáték szerverünkre, ami a FiveM kliensen fut. - ESX keretrendszer - Linux VDS-en fut a szerverünk Mit ajánlunk? - Hosszú távú partnerség - Havi fix fejlesztési díj (50.000Ft) Mit várunk? - Aktivitás: nagyobb bugok, hibá...

Közismert márkanévvel fémjelzett, piacvezető, nemzetközi cég Senior Backend PHP Fejlesztő munkatársat keres meglévő és új projektekhez debreceni munkavégzéssel. Fő feladatok:  Meglévő rendszerek backend fejlesztése PHP5-ben és SQL optimalizálása  Új funkciók tervezése, dokumentálása és implementálása  Új online üzleti megoldások tervezésében és fejlesztésében való részvétel Elvárások:  PHP 5.3+ és jQuery magabiztos ismerete  MySQL ismerete  Adatmodellek és adatbázistervek implementálása,...

Szolgáltató váltás miatt kell átmozgatni egy oldalt. Web tartalom már lementve gzip-ként, adatbázis lementve sql-ként, csak össze kéne fésülni.

Python, C++, SQL

Egy ipari berendezéseket gyártó vállalat meglévő VB.NET tervező és ajánlatadó alkalmazását kell kiegészíteni ...alkalmazását kell kiegészíteni a teljes értékesítés, megrendelés, anyagbeszerzés, gyártás és implementáslás folyamatát lefedő folyamatkezeléssel. A folyamatot a könnyen megtanulható és alkalmazható ProcessMaker eszköz segítségével kell elkészíteni, amely grafikus vizuális felülettel támogatja mindezt. A folyamat kialakításához rendelkezésre áll a jelenleg kb. 60...

Keresünk Backend és frontend fejlesztőt Backend elvárások Több éves programozói tapasztalat Python 2 és 3 nyelven Több éves programozói tapasztalat főleg objektum orientált/kliens-szerver felépítésű program/rendszer fejlesztésben A Django framework alapos ismerete Django REST framework alapos ismerete Tesztelési technológiák ismerete (unit és browser tesztelés) SQL adabázisok alapos ismerete Linux alapszintű ismerete Frontend elvárások HTML5, CSS3, Javascript tapasztalat Angular framework ismerete Jasmine, Karma tapasztalat Előny az Angular Material Design ism...

Sziasztok! Egy most induló vállalkozáshoz keresnék programozókat. Akiket keresek a következő technológiák közül legalább kettőt kellene ismernie: - PHP - Relációs adatbáziskezelő rendszerek (kifejezetten MySQL/PostgreSQL) - HTML - CSS - JavaScript (lehetőleg ES2015 ismerete) Ezeken felül előnyt jelent, ha rendelkezel az agilis szoftverfejlesztési tapasztalatokkal is. Elsősorban PHP + SQL, illetve a HTML + CSS + JS együttes ismeretével rendelkező kollégákat keresek, de ha más „kombinációkban” ismered a fenti technológiákat, akkor is jelentkezz. Amennyiben felkeltette érdeklődé...

...programozó kollégákat. Akit keresek, a következő technológiák közül legalább kettőt kellene ismernie: - PHP - Relációs adatbáziskezelő rendszerek (kifejezetten MySQL/PostgreSQL) - HTML - CSS - JavaScript (lehetőleg ES2015 ismerete) Ezeken felül előnyt jelent, ha rendelkezel az agilis szoftverfejlesztési tapasztalatokkal is, illetve ha Budapesten vagy Debrecenben élsz. Elsősorban PHP + SQL, illetve a HTML + CSS + JS együttes ismeretével rendelkező kollégákat keresek, de ha más „kombinációkban” ismered a fenti technológiákat, akkor is jelentkezz. Amennyiben felkeltette érdeklődésed a ...

Incident management software Django frontend-del, MS SQL Server adatbázissal, .NET vékonykliens ticketing üzenetek előnézetéhez, REST API

Van egy működő WP oldal, amibe szeretnénk importálni a régi (egyedi cms-t használó) oldalon publikált cikkeket...legtöbb esetben egy folyóirat cikkei. Az importáláskor nem számít a publikálási idő, hanem az eredeti megjelenés (évfolyam, lapszám) szerint vannak kategorizálva. A régi adatbázis cikkekhez rendelve tartalmazza ezeket a tulajdonságokat. Az új WP-s oldal tudja kezelni az eredeti szerzőt és az megjelenést is, tehát csak az importálás kell, új funkciók a WP-be nem. A régi oldal fejlesztője készített sql queryket az importáláshoz, de nem...

Van egy működő WP oldal, amibe szeretnénk importálni a régi (egyedi cms-t használó) oldalon publikált cikkeket, s...legtöbb esetben egy folyóirat cikkei. Az importáláskor nem számít a publikálási idő, hanem az eredeti megjelenés (évfolyam, lapszám) szerint vannak kategorizálva. A régi adatbázis cikkekhez rendelve tartalmazza ezeket a tulajdonságokat. Az új WP-s oldal tudja kezelni az eredeti szerzőt és az megjelenést is, tehát csak az importálás kell, új funkciók a WP-be nem. A régi oldal fejlesztője készített sql queryket az importáláshoz, de ne...

Mobilfejlesztő iOS / Android / Windows8 Feladatok: • együttműködés a fejlesztésben résztvevő kollégákkal • programterv elkészítése • automatikus teszt rutinok megírása • együttműködés az árajánlathoz szükséges feladatbecslésben Elvárások: • Java, vagy .NET programozói ismeretek • mobile SDK felépítésének és kezelésének ismerete • SQL, SQL Lite ismerete • kliens-szerver hálózati kommunikáció programozás tapasztalat • 0-2 éves fejlesztői tapasztalat • gyors tanulási ...

...illetve mennyi idot toltott el mindevvel. (Testek, jatekok kesobbiekben.)rnrnMinta megjelenites honlap vazlat letoltesevel tekintheto meg. (Kezdo oldal )rnrnrnrnErdeklodesem ket feladatra vonatkozik: rn1. MS Access/ SQL programozasra vonatkozo feladat rnrnAlabb belinkelt PHP-ban irott script-er at tudja-e inri MS Access-be, vagy SQL-be.rnFuncioja nagyjabol a kovetkezo: megnezi, hogy adatbazisban adott nyelven talalhato szohoz van-e letoltve kiejtes, es ha nincs, akkor GoogleTranslate-bol letolti hangfajl formatumban egy adott konyvtarba.rnMennyi idobe kerulne egy ilyen program megirasa? rn(Egyelore az elvi lehetosege es a kapcsolodo dijazasa erdekel. Pontos specifikalasara

...in both data analysis and financial modeling. The main task is to assist in analyzing market data. The outcomes of this analysis needs to be presented as interactive visualizations. Key responsibilities: - Utilize Python for data analysis: Your solid experience in Python should allow you to clean, manipulate, and analyze financial data effectively. - Implement financial modelling: Your understanding of financial modelling is important for you to interpret the data correctly in a financial context. - Analyze market data: The core objective of the project is to carry out analysis on market data. Strong attention to detail and good research skills are crucial here. - Present results: The final deliverable should be interactiv...

...answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and page doesn...

I'm looking for a talented data analyst to help me leverage MIRO for a deep dive into our various types of data and generate actionable insights. I need the work done quickly, so please be prepared to jump right in. Key skills and experience required: - Previous experience in data analytics, particularly using MIRO and analyzing a range of data sources. - Ability to identify trends and patterns, discover correlations between variables, and make data-driven recommendations. - Excellent communication skills and the ability to present complex findings in a clear, understandable manner. - A proactive and fast-paced work ethic- the ability to deliver quality work quickly, without compromising on accuracy.

As a small business owner seeking to enhance my Go High-Level (GHL) membership courses and sales pages with an AI chatbot, I'm looking for a specialist who can achieve the following: - Answer Customer Queries: The AI chatbot should be able to address queries from potential customers about the courses and sales offerings. - Provide Course Recommendations: It should be able to suggest relevant courses based on users' needs and interests. - Collect User Feedback: I'd like the chatbot to gather feedback from users, which can be valuable for improving the offerings. I'm particularly interested in integrating the AI chatbot in a text-based format. Key Skills: - Proficiency in AI Chatbot Development: Extensive experience in developing, implement...

I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.

I am in need of a proficient data analyst who can handle multilingual data analysis in English, Spanish, and French. The project aims to provide insights into the logistics and business operations of several industries including Healthcare, Retail, Manufacturing, and Education. Key Tasks: - Data Cleaning and Preprocessing: Efficiently handle large datasets in multiple languages for optimal data quality. - Descriptive Analytics and Reporting: Create insightful reports on the logistics and business data in a clear, concise and actionable manner. - Predictive Modeling and Forecasting: Utilize predictive analytics to forecast future trends and make informed strategic decisions. Ideal Candidate: The ideal candidate should possess: - Proven expe...

...comprehensive dashboard for our POS (Point of Sale) system involves several key components and technologies. Here’s a detailed outline of the project requirements and the ideal skills needed to build the solution: Project Overview The goal is to develop a dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphica...

I'm seeking a professional who can effectively handle inferential statistics and is proficient in R programming. This role involves working with statistical data, and particularly focuses on: - **Data Cleaning and Preparation:** You will be responsible for ensuring the data is clean and ready for analysis. - **Data Visualization:** Your tasks will include creating visual representations of the data to make complex ideas more intuitive to others. - **Diagnostic Accuracy, ROC, AUC:** You should be able to analyse diagnostic accuracy and create Receiver Operating Characteristic (ROC) curves, as well as calculate Area Under the Curve (AUC). Ideal candidates will be able to seamlessly blend statistical expertise with hands-on programming i...

I'm in need of a WordPress expert with advanced knowledge in both plugin and theme development. The perfect candidate for this project should have a good grasp of PHP, JavaScript and databases. Key Responsibilities: - Develop and customize WordPress plugins - Develop and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solv...

Hi, How are you? I know you have several tempting proposals here, but I guarantee you to be impressed by my work. I have various skills in design, illustration, Illustrator, Illustration, Graphic Design, Logo Design and Photoshop. If you give me this chance you will be impressed, because I guarantee that I will meet yo...have various skills in design, illustration, Illustrator, Illustration, Graphic Design, Logo Design and Photoshop. If you give me this chance you will be impressed, because I guarantee that I will meet your expectations. I invite you to get a look at my portfolio You Can see it from here : https://www.freelancer.com/u/cri8ive007 If you have any questions or queries, do not hesitate to contact me. I hope to start working with you. Thank you!

I'm seeking a skilled C# .net developer to improve the performance of my application. - Scope: The project involves fine-tuning the existing codebase, optimizing database queries, and enhancing the overall performance of the application. - Skills: The ideal candidate should have a profound understanding of C# .net development, experience in performance optimization, and a strong grasp of database management. If you're proficient in identifying bottlenecks and implementing solutions to boost system speed and efficiency, I'd like to hear from you. Please share your past relevant experience.

We are in need of a skilled software contractor to provide a comprehensive...Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in software development and code assessment. - Strong understanding of code efficiency, performance, and quality. - Previous work on developing completion ...

Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto

I'm looking for a talented and experienced analyst to help me evaluate a public company in the energy sector. The insights gathered will be essential for strategic decision making. Your primary task will be to conduct a comprehensive analysis of the company's financial performance, market position, sustainability practices, enterprises value, and strategy. Your analysis should provide thorough insights into these areas, helping us understand the company's strengths, weaknesses, opportunities, and threats. Key requirements: - Evaluating Financial Performance: I need a detailed analysis of the company's revenue, profitability, cash flow, and debt levels. Your insights here will be crucial in understanding the company's financial health and stab...

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL dat...

THIS IS NOT A BUSINESS ANALYSIS FROM THE PERSPECTIVE OF BUSINESS VALUATION OR FINANCE. THIS IS A REQUIREMENT GATHERING AND FINALIZATION FOR LEAD CAPTURE PAGES. It is a small proejct. I have a few lead capture pages to be designed and I need your expertise in developing the requirements, process mapping, wireframing, and possible test cases. It is not a large project but it does have a few variants of lead capture processes.

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

I'm looking for an experienced developer to create an AI customer service chatbot for my business. You will be using OpenAi api. You will need to extract all email from our gmail account to train the model. The model should be able to create response to customer queries using the training data. This will be a chrome extensions. The primary functionality I need is for it to be able to effectively respond to frequently asked questions (FAQs). Key Project Details: - Platform: The chatbot should be developed specifically for my business - Functionality: The primary function of the chatbot should be to accurately answer customer's FAQs. - Language Support: I am not sure if multiple languages will be required at this stage, but the abil...

We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.

The purpose of this report is to propose the system analysis for the client, with the intention of ensuring all stakeholders involved agree to the planned solution. Throughout the project the analysis, development, implementation and testing phases will be conducted using the industry standard, agile development life cycle. This specifies that changes can be made if required and appropriate. The system analysis report is intended for all the project’s major stakeholders: the client, the trainers, the costumers ,if they can be involved, and the development team.

We as an Agency are in need of an experienced community moderator for our client's Discord, Telegram, and Reddit platforms. This role will include a range of tasks such as: Discord: - Deleting inappropriate messages. - Managing user conflicts. - Enforcing server rules. - Building and maintaining an engaging server environment. Telegram: - Monitoring chat activity and ensuring user's compliance with community guidelines. - Identifying and removing spammers. - Managing user bans efficiently without disrupting the positive community vibe. - Providing guidance to users, addressing their queries, and enhancing their platform experience. Ideal candidates should have prior experience managing these platforms and have great conflict resolution and community management sk...

I'm seeking an experienced data scientist with expertise in Python and R for a project that involves time series data visualization and statistical analysis. Key Responsibilities: - Conducting data visualization to present insights in a clear and compelling manner - Performing statistical analysis to extract meaningful patterns and support decision-making I will provide you with a working file that retrieves data from our Python/R library. Your responsibility would be to process and analyze this data. We use Python/R with Jupyter notebooks. Ideal Skills: - Strong proficiency in Python - Experience with data visualization tools such as Matplotlib, pyplot and of course Pandas - Proficiency in statistical analysis methods and to...

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will...

I have a video of a vehicle involved in an accident, and I need a professional with video manipulation experience to slow down the video and read the license plate. This is required for a police report. Key Responsibilities: - Analyze the video to find the specific frame where the license plate is visible. - Slow down the video effectively for detailed examination. - Accurately decode and transcribe the license plate information. Ideal Candidate: - Proficient in video editing software. - Previous experience in video analysis and enhancement. - Attention to detail and ability to work on a sensitive matter. Need the details of the white pickup that pulls out on the left suddenly.

I'm looking for an experienced Ecommerce Analyst to help me enhance the visibility of my products and drive sales on Amazon, Shopify, and Etsy. The main focus will be on the Business to Consumer (B2C) audience. Key Responsibilities: - Analyzing sales performance and identifying areas for improvement on Amazon, Shopify, and Etsy. - Conducting a deep dive into customer behavior on these platforms. - Carrying out competitor analysis to get a better understanding of the market. Ideal Skills and Experience: - Proven track record in Ecommerce analysis and optimization. - Extensive experience with Amazon, Shopify, and Etsy. - Strong data analysis skills. - Ability to understand and cater to a B2C audience. Your insights and strategies will drive the success of ...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine

As the owner of an optics-focused product line, I'm looking for an experienced freelancer who can generate a comprehensive wholesale pricelist for binoculars and rifle scopes. 1. Product Knowledge: Knowledge in various optics brands and models is a must as this project requires research on specific models that I will be providing. 2. Scope: The task includes the creation of a structured and detailed pricelist including the information about various models and their wholesale prices, all pricing and hi res images will be supplied. 3. Skills: Having data entry and data analyst skills, would be ideal to accomplish this job. Timeline: To be completed before June 10th This project would be a perfect match for individuals who have strong rese...

I'm on a pursuit for a skilled freelancer who can methodically add physical products to my Shopify store. All necessary details and images for each product will be provided by me. Ideally, you have a handle on working with products that offer more than three variants. An understanding of this niche can be significantly advantageous. Skills and experience ideal for this job: • Proficiency in Shopify inventory management • Eye for detail • Experience working with products with more than 3 variations Given your expertise and my guidance, this could swiftly surmount to a successful project. If you have any queries, feel free to ask. Let's launch an irresistible product range together!

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.

I'm looking for an expert to set up and manage my Amazon, eBay, and Spotify stores. Key Responsibilities: - **Setup and Automation**: Your primary task will be to set up my Amazon, eBay, and Spotify stores. You should be able to automate the listing process to save time and optimize efficiency. - **Inventory Management**: I plan to run a centralized inventory management system. Your role will include keeping track of inventory, ensuring that each platform has accurate stock levels, and that the product information is up-to-date. - **Sales and Traffic Generation**: Your focus will be on eBay. You should have a proven track record of driving traffic and generating sales on eBay. Experience in leveraging the platform's promoted listings and other advertising tools is a plu...

...on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills: • Proficient in API development and integration • Practical experience with both Silverstripe and REX Software •...

...user's data is mistakenly being displayed to the first user. This isn't the intended functionality, and I need an experienced developer to solve this issue promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and abl...