Sql for data analysis coursera työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

in attached ....................................................

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

...the current trends within the AI landscape. This report should be tailored for an audience of industry professionals. Key Points: - The report should provide an in-depth analysis of the current trends within the field of artificial intelligence - The language and content should be suitable for an audience of industry professionals, meaning that a certain level of technical understanding can be assumed - The report should be well-structured, engaging, and present complex information in a clear and concise manner Ideal Skills and Experience: - Proven experience in technical research and report writing - A deep understanding of artificial intelligence and related concepts - Experience in tailoring technical content for industry professionals - Strong analytica...

...professional to help me debug and rectify the problems at hand. My company's WINDOWS SERVER 2016 OR HIGHER BASED system, , is designed for data analysis and reporting. The system was set up less than a month ago and was functioning as expected. However, 10 days ago, it suddenly stopped loading properly, without any changes being made to it or its environment. I have working copies of the site and desktop versions that I can upload. The application must work at least for a month. The primary issue to be resolved is the system not loading. It's crucial that this is fixed promptly to restore our ability to analyze and report data effectively. Furthermore, you must connect the online version to the desktop version residing in server. In othe...

I am seeking a Machine Learning engineer with proficiency in Python. You should be able to apply your skills to solve a classificat...apply your skills to solve a classification problem with a text dataset. Key Responsibilities: - Develop and implement a suitable ML model for the text classification problem - Conduct detailed data analysis and preprocessing Ideal Skills & Experience: - Extensive Python programming experience - Wide understanding and experience in Machine Learning, specifically in classification problems - Experience in working with text datasets - Familiarity with popular Python libraries used in ML such as scikit-learn, pandas, and numpy If you have a strong grasp of Machine Learning techniques, particularly in text classification using P...

I'm in need of an expert to analyze our Joomla website's recent spike in traffic. I'm concerned whether this is genuine or bot-generated. This is a high-priority task for me, and I need immediate action. Key Tasks: - Verify if the current traffic is genuine or bot-generated - Implement necessary security measures to prevent future bot traffic - Restore the website online and ensure it can handle an increased traffic load Ideal Freelancer: - Proficient in Joomla and its security features - Experienced in analyzing web traffic and differentiating bot-generated traffic from genuine - Familiar with implementing security measures to protect websites from bot attacks - Available to tackle this issue urgently If you're confident in your abilities to address these req...

...Identify new treatment methods, answer the common question why the old treatment stopped being effective, and design and test novel solutions for individualized care - Improve current diagnostic techniques used for these conditions We have access to a variety of data types, including patient medical history, host genetics and microbiome data, clinical trial data and previous studies. Your task would be to creatively analyze these various data sets in order to design and implement an experimental study that makes significant strides in the treatment and diagnostics of patients with dermatological conditions. Skills and experience that would be ideal for this job include: - Proficiency in designing experimental research studies using nove...

I'm looking for a skilled professional who can help me retrieve information from various sources. The ideal freelancer should be well-versed in web scraping, especially from websites, social media platforms such as LinkedIn, publications, and news sites. This will help in gathering relevant data for building a recommendation system. Key requirements include: - Proficiency in data scraping from multiple sources - Ability to effectively scrape data from websites, social media platforms like LinkedIn, and news sites - Experience with handling and storing data in a database - Understanding of how to structure and manage data for machine learning purposes Your task will be to gather the data and store it in a databas...

I am looking for a expert statistician experienced in JASP software and predictive modeling. My project requires: - Comprehensive data analysis - Development of statistical models Your key tasks will be data interpretation, model creation, and generation of reports based on your findings. Ideal freelancers would have extensive experience in JASP, a clear understanding of statistical modeling and data analysis, and prior exposure to projects involving predictive modeling. My primary goal is to effectively utilize predictive modeling to drive strategic decisions. Your expertise will contribute substantially toward this goal.

...performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have proficient experience with Excel, Word, and PDF with a flair for professional design layouts. This is a critical task and I need som...

I'm seeking a proficient statistician to help me with a data analysis project. Specifically, I have a set of sales data that I need to be analyzed for the purpose of identifying trends. The main goal of this project is to discover any patterns or trends present within the sales data, which could potentially inform our future strategies and decision-making.

I'm granting the opportunity to conduct an educational market research in UAE for my school directory platform. Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: • Collect up-to-date statistics on the UAE education s...

...of a meticulous freelancer to assist with data entry and the organization of several Excel spreadsheets. Your primary task will involve entering data from various not-specified sources into Excel, as well as categorizing and structuring this data in a logical and efficient manner. Desirable Skills & Experience Required: - Mastery of Excel functions and formatting features - Strong attention to detail and accuracy - Proven experience in data entry - Ability to work with limited supervision - Data analysis and detection of irregularities is considered a plus. The task doesn't necessarily require prior relevant experience but being familiar with Excel and data structuring principles would be advantageous. Due to the nature of...

I'm granting the opportunity to conduct an educational market research in UAE for my school directory platform. Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: • Collect up-to-date statistics on the UAE education s...

...user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right fit with the necessary expertise.

I'm in need of a skilled mathematician with a ...mathematician with a specialization in statistics to assist me in data analysis. Essential Points: - Specialization: Your main focus should be on advanced statistics, specifically at a graduate level. - Experience: Proven experience handling complex statistical data analysis is a must. - Communication: You should be able to translate your findings into actionable insights. - Tools: Proficiency in statistical software like R, Python, or SPSS is essential. This role is crucial in helping me make sense of large datasets, so it's important that you are comfortable with the analytical side of data interpretation. Your findings will help me make informed decisions based on the data. Please rea...

...seeking a skilled developer to create a comprehensive trading application for my company. This app needs to be compatible with both Android and iOS. Key Functions: - Real-time Market Data: The application should provide up-to-the-second market data to users. - Trading Orders: Users must be able to place buy and sell orders directly from the app. - Portfolio Management: A feature for tracking and managing their investment portfolios. - Research and Analysis Tools: The app should include tools that allow users to conduct in-depth research and analysis. - Watchlist: Users should be able to create and manage watchlists of stocks or other financial instruments. - Position Calculator: A tool for calculating the position size for a given...

...experienced mechanical engineer specializing in thermal analysis and simulation to work on a project related to Li-ion batteries. I have already done some work. I don't know about battery modeling on ANSYS Fluent. I am trying to mimic TR using a thermal model. The geometry and the parameters are taken from the research paper (the research paper is attached). I propagated TR using a user-defined function (UDF) on ANSYS Fluent, but I couldn't get a higher cell temperature than the one mentioned in the paper. The UDF contains the data points and Time extrapolated from the research paper (Fig. 5). The heat generation is calculated using q''' = rho*Cp*dT/dt. (The work should be done on ANSYS Fluent). Key Tasks: - Conduct detailed thermal analysi...

Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and compr...

I'm in search of a professional in geopolitics who can assist me in developing strategies to navigate geopolitical challenges. The ideal professional will be responsible for: - Research and analysis on geopolitical issues - Report writing on geopolitical events and trends - Consulting and advisory services on geopolitics The main goal of this project is to develop strategies that will help in navigating through various geopolitical challenges. The intended audience for this project's outcomes includes governmental bodies. Ideal candidates should have a strong background in geopolitics, with experience in research, analysis, report writing, and consulting on geopolitical matters. They should have a solid understanding of international relations and ...

I'm looking for a developer who can update the Godiva viewer to be compatible with the Copernicus WTMS service. Your objectives are: - Updating the viewer to access and display data from the Copernicus WTMS service - Enhancing its functionality to better display Copernicus data Key Features Needed: - Interactive time-series analysis, for better data interpretation - Dynamic layer ordering, to enrich data visualization The ideal freelancer for this project is one who is proficient in the WTMS system, has a good grasp of Godiva viewer operation, and can provide these specific updates. An understanding of the functions and usage of a geospatial portal viewer is a plus. You should also be a creative thinker, with an eye f...

...summaries for the tasks: **Extracting data from images (Task 1a):** * You'll need to add a new function to existing code that can grab specific values from images stored on Google Earth Engine (GEE). * These values, representing features of the land, will be used to train a machine learning model later. **Creating a new feature (Task 1b):** * You'll write some new code to define a new feature based on existing data (called NDVI). * This involves creating a new class that inherits from existing ones to handle this specific feature extraction. **Training machine learning models (Task 2a):** * Using all the features you extracted in Task 1, you'll train different machine learning models for a client. * The client has collected soil samples, ...

...intermediate level big data engineers who can tackle essential tasks within the domain. The ideal candidate for this project should be able to: - Perform data analysis: This includes understanding, interpreting, and presenting data to inform decision-making. - Manage data integration: The candidate should be capable of combining data from various sources to create a cohesive dataset. - Develop data visualization: The engineers will need to create meaningful and understandable visual representations of the analyzed data. The necessary skills for this role are: - Proficient in Python: The candidate should be well-versed in Python programming language to work with our system. - Knowledge of Hadoop: Experience with Had...

I'm seeking a deep learning expert to develop an AI model for accurate bone fracture detection from X-ray images. Additionally, you'll be responsible for creating a user-friendly UI using HTML/CSS/JS. The model should run in the backend to facilitate real-time analysis. Key Project Requirements: - **AI Model Development**: An accurate bone fracture detection model should be developed using Python and TensorFlow. The primary goal of the model is to ensure precision in diagnosing fractures from X-ray images. You can use any datasets available online for free. Model should be able to predict the fracture, body part, highlight the fracture part, - **User Interface**: The UI should be designed to offer an intermediate level of interactivity. This includ...

I'm looking to hire a freelancer to provide a political analysis on former Secretary of State, John Kerry. This project requires the ability to conduct research and have a strong understanding of political discourse. The analysis should be pro-Kerry, and of sufficient length to allow for an in-depth examination of John Kerry's political career. Specifically, I would like the analysis to be more than 2000 words in length. As a client, I need assurance that the analysis will be professionally done and adhere to standards of academic integrity.

I have designed a model...operation. The primary fuels I am interested in are JetA and biodiesel. Understanding the performance of these fuels in relation to thrust, efficiency, fuel consumption, and emissions is of the utmost importance. This will be used for personal reasons. Ideal candidates for this project should have: - Proficient experience with ANSYS software - Understanding of jet engine operations - Knowledge of jet fuels (particularly JetA and biodiesel) The deliverable for this project will be a comprehensive report detailing the simulation results with comparison and analysis on the primary parameters: thrust, efficiency, fuel consumption, and emissions. Please note, while I have basic knowledge of jet fuels, I am relying on your expertise to exe...

I'm on the lookout for an expert who can create a comprehensive quotation format for consultation services. The sole purpose of this project is to provide precise price estimates to my clientele. Hence, your proficiency in understanding and drafting cost estimates is key here. The quotation format I need should include two specific sections: - Service Description: A well-structured outline underlining the services offered. - Terms of Payment: Details on the payment structure and timeline. The perfect candidate would have excellent financial analysis skills to provide an accurate price estimate and outstanding attention to detail to compose the aforementioned sections. Additionally, prior experience in creating quotations for consultation-centric indust...

I'm...on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewi...

I need a professional who's capable of modifying an existing Lua code. The successful candidate should be able to: - Understand and work with existing codes - Add an unincorporated parameter...modifying an existing Lua code. The successful candidate should be able to: - Understand and work with existing codes - Add an unincorporated parameter, specifically the 'tool tip radius coefficient,' into the current Lua code - Develop a method for analyzing gear size data to determine the aforementioned parameter Demonstrable experience in working with Lua language and proficiency in data analysis, specifically in gear size data, would be extremely beneficial in executing this task successfully. Strong understanding of gear parameters and a knack...

...sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis....

I'm seeking a skilled PowerPoint creator for a marketing-focused presentation. The key topics crucial for discussion include an in-depth Company Overview, highlighting our unique selling points; comprehensive Product Specifics, demonstrating the key features and benefits of our products; and a detail-oriented Market Analysis. A deep understanding of marketing strategy and visual storytelling is necessary for enhancing the appeal and impact of this presentation. Time is of the essence, and I need this project completed ASAP. Referral : Need to create PPT for Starwalk from ISON Presentation

...Memorandum (CIM). Key project requirements: - Basic assumptions and financial projections: Your model should include detailed financial projections based on the provided assumptions. - Operating model and capital structure: You will need to build a comprehensive operating model, and structure the capital in line with the LBO requirements. - Sensitivity and scenario analysis: I expect you to provide a detailed sensitivity and scenario analysis that is easy to interpret. - I have a CIM and a template excel sheet that you can use to create the model. I have other instructions as well in which I will provide after you bid. Time is of the essence, and I need this completed within 24 hours. Please only bid if you are confident in your ability to deliver accurate results in thi...

I'm seeking a proficient data scientist with a specialization in unstructured data (e.g., text, images) for a project focused on data analysis. Key Responsibilities: - The primary goal of this project is to perform in-depth data analysis on unstructured data. - You will be required to identify patterns, trends, and insights within this data set. - The data analysis should be thorough and aim to provide actionable results. Ideal Candidate: - Strong background in data science and particularly, in working with unstructured data. - Experience in data analysis, with the ability to find and interpret patterns. - Proficient in using relevant tools and software to analyze unstructured ...

I need a skilled professional to analyze a given trajectory in .xyz format and specifically extract the non-Gaussian parameter. i will help you to understand the work. Ideal Skills: - Experience in scientific data analysis and trajectory interpretation - Ability to extract non-Gaussian parameters - Proficiency in using tools for data analysis The task involves: - Analyzing the trajectory in .xyz format - Extracting the non-Gaussian parameter (specifically, the kurtosis, skewness, or other higher moments)

...and experienced electrical engineer to design an analog audio circuit for mixing multi-channel signals sourced from line level feeds. This will require expertise in designing robust and low-noise analog audio circuits capable of dealing effectively with multiple audio inputs. Ideal Skills and Experience: • Proficiency in electronic circuit design, specifically analog audio circuits. • Experience with handling multi-channel signals. • Familiarity with line level audio signal processing and mixing. We need an engineer with deep experience in high-end analog circuit design using low noise operational amplifiers. We will provide basic diagrams and objectives. The project involves high quality op amps and line drivers for an audio routing project. We will be u...

I am looking for an expert who can seamlessly integrate Facebook meta pixel into Google Tag Manager to accurately track the value of product purchases on my platform. Specifically, the project requirements are: - Integration of FB meta pixel with Google Tag Manager - Configuring the pixel to track product purchase values - Ensuring the delivery of purchase value data in numerical format Skills required: - Proficiency in using Google Tag Manager and Facebook meta pixel - Experience with website tracking and data analysis - Basic understanding of e-commerce platforms The freelancer should be demonstrating a deep understanding of the nuances of tracking purchase values and ensuring data accuracy. Above all, the freelancer must have prior experience in ...

Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. ...

I need assistance with hypothesis testing, specifically for dichotomous data. Key Points: - Our null hypothesis presumes that there's no relationship between the variables involved. - Your task is to perform meticulous testing to either prove or disprove this null hypothesis based on the data provided. Ideal Skills: - Statistics education or relevant experience - Proficiency in statistical software or language - Background in dichotomous data analysis - Understanding and knowledge of hypothesis testing methods - Ability to explain results in a clear and comprehensible manner. By undertaking this project, you'll help us understand the relationship, if any, between our variables. It's critical that you offer accurate results and guide ...

I'm looking to build a...to build a custom scraper for DeFi exchanges. The main features I'm interested in are: - Historical data analysis: This is crucial for me to make well-informed decisions about the market trends. - Real-time data updates: Although not explicitly stated in the questions, the bot will need to be able to update data in real-time. This will help me stay ahead of the market. I currently prefer the output in CSV format, as it is easy and widely used. Given the nature of the DeFi space, experience in cryptocurrency scraping bots is a must. It would be ideal to have experience with DeFi exchanges particularly. This project will require strong skills in programming languages such as Python, R, or JavaScrip...