Simple queryงาน

Necesito alguien que puede dar un curso de power Bi en 10 sesiones en total 15 horas por sesion es de 1 hora y media, 2 sesiones por semana martes y jueves de 4 a 5:30 de la tarde hora Guatemala. Empezando 23 de abril y terminando 23 de mayo. Alrededor de 15 personas, las sesiones son por google meet. Temas a impartir. Editor de consultas de Power BI Extracción de datos: Extracción vs Direct Query Conectar datos alojados en diferentes orígenes Enlazar datos desde la consulta Entorno de trabajo para modelar con Power BI Introducción al modelado tabular con Power BI Tablas y relaciones Power BI – Modelos de datos Iniciación a DAX Fundamentos DAX 1. DAX en la práctica 2. Columnas calculadas y medidas 3. Tablas Calculadas ...

I need a 5-page website for my tile company based in Texas. It should be simple and easy-to-use for potential customers. Key Requirements: - Home Page: A welcoming, visually appealing landing page that effectively showcases the business. I have created the welcome page content with A.I. so you would simply need to plug in that content. - Products Page: Not needed for now. - Services Page: This page should include detailed descriptions of the services we offer along with the respective pricing. - Contact Us Page: A standard contact page with a contact form, email address, phone number, and a location map. - Must be familiar with !! The site should be built using WordPress, allowing me to update content myself in the future. The design should be clean, professional, and aligned

...Please bid only if you're willing to work with me live via zoom. *** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, par...

Create a simple logo for me. I need the logo in the picture redesigned into a vector image with the same design as in the picture but with nice new clean lines.

I'm in need of a skilled programmer experienced in C++ languages. The primary aim is to effortlessly convert simple Python code into its C++ equivalent. Ensuring to maintain specific functionalities such as: - Data Visualization: This functionality must be retained during the conversion process. The C++ code must facilitate the graphical representation of data as efficiently as the initial Pine script. - Algorithmic Operations: The output C++ code should continue to perform certain algorithmic operations, similar to the Pine script. Ideal candidates should have previous experience in similar projects and a strong understanding of both Pine and C++. Excellence in this task may lead to potential future collaborations. This is a great opportunity for candidates looking to bu...

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

...web-application we're developing. The logo should be a simple one with a single color: rgb(40, 199, 111). We want an owl to be a main part of the logo. The concept that the logo should utilize includes: team collaboration, communication, wise approach. As a basis for the logo an owl-icon can be considered: So, it should be a simple logo, might be something like "owl reading messages"

Are you an active LinkedIn user with a keen eye for detail? Do you enjoy sharing your feedback? If so, we have an exciting opportunity for you! We're seeking for the best to test our free SaaS tool designed specifically for LinkedIn users. Your task? Simply use our tool for 30-60 minutes and provide us with your most insightful and deep feedback on various aspects including: - User experience - Key features - Onboarding process - Issues - Any other insights you believe are crucial - Suggestions for improvements But to participate, you need to: - Have a LinkedIn profile and use the platform regularly. - Be an everyday LinkedIn user to ensure unbiased feedback. How to Participate: - Access the tool and additional details via this link: - Spend 30-60 minutes exploring the tool a...

I am looking for a C programmer to develop a simple keylogger detector specifically for Windows and Linux operating systems. The primary use of this tool will be on my personal computer. Key Features and Tasks: - The detector should be capable of detecting and alerting keyloggers' presence on the computer. - The detector can have minimal ui. - the detector can only have manula scanning. Ideal Candidate: - Knowledgable in C programming with significant experience in system security programming. - Familiarity with keylogger behaviors and effective detection methods. - Prior experience in developing security software for Windows and Linux operating systems. The end goal of this project is to ensure my personal computer is fairly safe from keyloggers. Looking forward to worki...

Input:- You will get an excel file as input. Step1- Sort the Excel file by site name and place data in sheet 1 Step2- Sort the Excel file by site address and place the data in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply the logic to find exact duplicate and high match. Example - means in sort by site name we will find exact duplicate and high match site(75%) match and print exact duplicate/ partial match. Then for exact duplicate and partially match we are going to compare all row and need to print what is matching like site city, site state, site country etc

I'm in need of a freelancer who can provide me with an accurate and simple industrial machine wiring diagram. It's crucial that you have an in-depth understanding of electrical circuits and wiring systems for industrial machines. Responsibilities: - Prepare a wiring diagram for a simple machine circuit. - Make sure the diagram is easy to understand without oversimplifying the essential elements. Required Skills and Experience: - A strong background in electrical engineering. - Extensive experience creating wiring diagrams, preferably for industrial machines. - Solid understanding of machine simplistic circuits. - Attention to detail, accuracy and consistency in diagram creation. - Excellent communication skills to clarify any ambiguous points.

I'm in dire need of a professional and experienced logo designer, specifically skilled in creating minimalist style designs. Your task will be to create a logo using a combination of purp...designer, specifically skilled in creating minimalist style designs. Your task will be to create a logo using a combination of purple and dark gray color. Having a good understanding of color pairing and past experience with modern, bold and unique design is crucial for this project. This needs to be completed ASAP, so proactive and efficient freelancers are highly preferred. Let's create something simple, yet powerful and engaging together. Create a logo for a pharmaceutical company named "BIOVERIC" it can have a full name "BIOVERIC Pharmaceuticals" Conceptual logo ...

I am looking for an experienced React Native developer who can develop a functional driver app for both iOS and Android platforms. I already have UI screens, however, are open to guidelines and suggestions. The Primary function of the app ...should have: - Proven experience in React Native Development - Proficiency in working with both iOS and Android platforms - Excellent understanding of GPS integration and real-time notifications - Ability to work with provided UI screens and enhance functionality - Expertise in payment processing integration. I'm excited to see how your skills and experience match this project. If you have any query or suggestion please let me know. Looking forward to collaborating with you. Note : There are 20 UI Screens and we put a 150 Rupees per s...

...integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and effectively solve problems. Excellent communication skills and ability to work in a team...

We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.

I need a Telegram Web App Simple menu with 4 buttons: Connect TON wallet, Info, Mint NFT, Refer a friend Design is ready Here’s example

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

Saya ingin dibuatkan lucky spin dengan ketentuan memasukan kode kupon atau tiket yang telah diinput pada panel admin valid untuk bisa menggunakan lucky spin, adapun contoh sebagai berikut :

we are in the need of a simple multi image ( 28 square images on one 16/9 fullscreen ) slideshow, should be windows based, can also be mac based. The app will be used once to playout multiple pictures ( 800 ) taken at an event. App setup settings should be : select folder ( will be dropbox folder which has to be researched for new photos while running ) select image presentation time ( images show for 5-15 sec and then should fade to next image ). after setting up the app should be executed in full screen, exit via 'escape`. as soon as there are more than the 28 images in the folder it should be avoided to have double images shown.

I'm seeking a knowledgeable specialist to perform benchmarks on my Pgvector Chroma Faiss database. The key objectives for this project are: - Analyzing speed and query performance. The ideal freelancer should have: - Proficiency with Pgvector, Chroma, and Faiss. - Experience in database benchmarking, with a focus on query performance metrics. - Ability to provide detailed reports on performance metrics. - Ability to offer performance tuning recommendations based on benchmark results. As this is for personal use, the project requires a specialist who can deliver thorough insights without the need for a business-oriented approach. Your technical database expertise will be crucial for this project.

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...

...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 displayed. - **3.2 Course Selection** - Users can select a course to view detailed information, including existing reviews. #### 4. Review Management - **4.1 Review Actions** - User...

...Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The completion timeframe is flexible, so I am looking for someone who is patient and good at explaining complex concepts in a simple and understandable manner...

I am in search of a logo for my physical therapy clinic, "Renewed Strength Physical Therapy, LLC." This logo should reflect a unique, feminine, vintage yet minimalist design. KEY REQUIREMENTS: - Color Palette: Mauve, Eucalyptus, and Sky or Opal room blue should be prominent. - Incorporation of Symbols: The logo should incorporate a Christian cross or a Christian fish. - Unique yet Vintage-Style: Although I'm aiming for a vintage minimalist style, the design should also be unique and not too simplistic. IDEAL SKILLS: - Logo design experience - Knowledge in vintage minimalist style - Past experience with healthcare or wellness industry is a plus - Understanding of Christian symbols in design Deliver a design that aligns with my brand's message and positioning: stre...

Looking to have my existing logo, which is currently in PNG format, converted to a vector image in Adobe Illustrator. Here's what I need from this project: - You will be working with a simple logo, predominantly composed of shapes and lines - Original color scheme must to be kept exactly as is. Consists of one color shape on transparent background - I need the final product in Illustrator format (.ai) and png format Ideal freelancer for this job is someone who is skilled and experienced in Adobe Illustrator, especially in recreating logos. It's important that you have a keen eye for detail to replicate the original logo accurately while maintaining its simplicity. The successful freelancer will be expected to deliver high quality work that reflects the professional ident...

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

Design: Need a simple clean website, with a few tabs, About Us, What we do, Contact us etc. Colours: Primarily White and blue with a black footer. Can give more details once we agree a price and timelines

...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 of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

Need developer who has knowledge of android apps to help me in a small android app related task

We're looking for someone to quickly test our simple software product.

I am ...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 criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...

I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.

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.

I'm looking for a skilled AutoCAD designer for a mechanical design project. You'll be responsible for creating a simple drawing with few parts. Key considerations for this project include: - Emphasising dimensions within the design - Including detailed material specifications - Clearly indicating connection details Ideal skills for this project: - Proficiency with AutoCAD, with a focus on mechanical design. - Strong attention to detail to clearly display all required elements. - Experience interpreting and applying design specifications. Please add samples of relevant work to your bid.

The icon should look exactly like this, but should say "Most Savings"

I'm seeking a talented web designer who can create a simple website for me. Key Requirements: - A clean, simple and professional design - Incorporation of text and images The site will be minimal, with only a few pages, so the project shouldn't be too complex. Ideal Skills: - Web Design - Graphic Design Please include a portfolio of your previous work in your proposal. I'm looking forward to reviewing it.

I'm seeking a reliable and competent coder, open to any programming language, be it JavaScript, Python or Java, etc. The complexity of the task is simple, shouldn't pose a challenge for an experienced developer. - Ideal Skills: Proficiency in any high-level programming language, with a track record of successfully completed projects. - Application Requirement: Your application should showcase your past works, preferably related to the project at hand. This will allow me to gauge your skill level and suitability for this project. Looking forward to your bid.

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...

We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.

I'm in need of a React application that will serve as a simple login system. The app will be using MongoDB to store user login information. Process will be: User logs in. Their login information persists in their state and they can create a user profile and access their user profile Log out and log back in

Homepage: Hero Section: Headline: "Delivering Peace of Mind: Reliable & Secure Courier Solutions" Subheading: "Specialized Same-Day Courier Services for Healthcare and Businesses" Call to Action: "Get a Quote" or "Contact Us Today" Background Image: [Image of a Quiet Craft Solutions INC delivery vehicle parked in front of a hospital or medical facility, showcasing professionalism and healthcare focus] About Us Section: Company Overview: "At Quiet Craft Solutions INC, our mission is to deliver peace of mind through dependable, secure, and timely courier services. We are committed to exceeding customer expectations by leveraging our expertise, technology, and dedication to excellence. As a Service-Disabled Veteran-Owned Small Business (SDVOSB)...

I'm seeking a skilled freelancer who has experience with creating Airtable Dashboards. I posted this previously but I wasn't very clear on specifically what I needed. Please do not respond with an auto-reply as those bids will be ignored. Here is specifically what I need help with: I currently have a database setup in Airtable. It has all the data that I need for my dashboard inside. But special formulas will be needed to calculate certain aspects of the dashboard. Example: I receive a total of 4 individual payments from a vendor. I initially receive 3 of the 4 payments a week after the sale, but I don't receive the 4th payment until ~a month later. Each payment is a separate row in Airtable, but the grouped payments all use the same SAN#. Therefore, I need Airtabl...

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

Hello See this short video of what I need done = !AnaknzarFP1X1kt2ispbIwh-z-Q2?e=2eBDNY Can you do it right now?

I have a very small dataset and need to do some statistical analysis using SPSS. Need the results in 2 days due to small dataset. Key Responsibilities: - Conducting hypothesis testing using SPSS - Descriptive statistical analysis - Interpretation of the analysis - etc. See the attached files. Ideal Skills and Experience: - Proficiency in SPSS - Strong background in hypothesis testing The answers should be clearly written in a word document. Should you choose to take on this project, please be prepared to start immediately.

...that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...