Write sql query in power bi jobs

... employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides for the system architecture, API interfaces, and operational procedures. Provide ongoing support and troubleshooting to ensure system stability and user satisfaction. Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Abili...

Hi, I hope everybuddy is doing well. I am looking for someone capable of writing high-quality niche articles without plagiarism and without using AI for my blogs. The topics can vary, ranging from news to technology. The work needs to be done directly in WordPress, on the domain I provide. It is necessary to upload relevant images and make the logo to match the niche, and ensure that the website complies with all AdSense program policies. I am seeking someone who can assist me long-term in this project, which I am undertaking with several partners. I need qualified manpower. Thank you! Best Regards,

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

I'm seeking a skilled PCB circuit designer to create a digital circuit f. The primary function of the circuit is PWM Motor Speed Control Key requirements: Input supply voltage: DC 2.5V-25V The maximum output power: 350W The maximum continuous output current :15A The overload and short circuit protecting current is 25A PWM frequency: 25-30kHz Duty Cycle adjustable: 0-100% The operation environment temperature:-20℃-40℃ Ideal freelancer would have: - Proven experience in digital PCB circuit design - Strong knowledge of signal amplification principles - Familiarity with radio technology and its requirements - Ability to optimize circuits for low gain

I'm seeking an expert to analyze a key aspect of my HR paper from journal with title Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Research context Methodology with results Discussion Overview Critique and significance of the paper the outcome is report and power point slides the due date is 22-5-2024

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the abilit...

I'm in need of an expert blockchain developer, specifically experienced in Solana, to work on a bot development project. The key functionalities of this bot will focus on trade execution. Key Project Details: - Primarily, you will be working on a bot that executes trades within the Solana ecosystem. - Familiarity with Jito Bundles, Raydium, and Jupiter DEX is a huge plus. - The bot should be developed using Node.js. Requirements: - Proficient in Solana blockchain development. - Strong expertise in Node.js. - Proven experience in developing trading bots. - Prior experience working with Jito Bundles, Raydium, and Jupiter DEX is highly desired. - A good understanding of trade execution strategies in the blockchain context. Please note: - The ...

...seeking an experienced software developer to create code for a power electronics control system. The project involves using an Arduino DUE and the IMC101T T038 motor controller. The software should control and regulate both the grid side and machine side using Space Vector PWM (SVPWM). Communication between the Arduino and other components will be handled via serial communication. Additionally, the system should include a quadrant display using 4 LEDs to indicate whether it is operating in motor or generator mode. All datasheets and circuit diagrams will be provided. Key Responsibilities: Control and Regulation: Implement SVPWM on both grid and machine sides. Grid-side control: Adjustable power factor (cos(φ)), current, and power. Machine-side control:...

...Microsoft Power Platform expert to help me package and publish a comprehensive PowerApps solution on AppSource. The primary goal for this project is to showcase innovation. Key Components: - Canvas app - Component library - Power Automate flows - Environment variables - Connection references Required Application Information: Freelancers interested in this project should provide a brief description of their relevant experience and knowledge. Ideal Skills and Experience: - Microsoft Power Platform and Dataverse Expertise - C# and .NET Development - Package Deployer Tool Proficiency - Power Apps CLI and Visual Studio Code - Experience with Dynamics 365 SDK - Previous experience in publishing PowerApps solutions on AppSource - Ability to work w...

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences fo...

I'm looking for someone to prepare KPI dashboard in Power BI.

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I'm in need of a desktop application that automates sperm analysis, leveraging the power of AI. This software will be used to create spermograms. Key Requirements: - Automation of Sperm Analysis: The software should be able to fully automate sperm analysis. This includes motility, morphology, and concentration analysis. - Utilization of AI: The software should harness the capabilities of Artificial Intelligence to improve the accuracy of the analysis. - Creation of Spermograms: The main purpose of the software is to create spermograms. This requires the software to be able to present the analysis in an organized and understandable way. Ideal Freelancer: - Proficient in AI and machine learning, particularly in the healthcare or biological fields. ...

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...

...excellence. It must be adaptable for use in various media formats, including print, digital, and social media platforms. The logo should also appeal to potential partners, investors, and industry professionals Target Audience: * Marketers * Agencies Brand Personality: * LinkLogic seeks to enlighten and empower clients through insightful data and cutting-edge technology to be the platform for marketers. Core Values: * Innovation: Continuously exploring and integrating the latest technologies and solutions. * Expertise: Leveraging deep industry knowledge and technical prowess to deliver exceptional results. * Trust: Building lasting relationships based on transparency, reliability, and trustworthiness. * Empowerment: Enabling clients to harness the power of data and cloud...

I'm in need of a professional who has extensive experience with SharePoint, Power Apps, Power Automate, and secondary Power BI . I need support for my consultant indian time 8:30 pm to 11:30 pm Monday to Friday. 12$/hourly.. payment every saturday vai peayplea. I already have other indian guys who are working with me since 2019 to present. This support will be on zoom meeting. Which we will provide u and u will connect with my consultant for support.

I urgently need a specialist in Ubiquiti UniFi to help me revive my system, which has gone down following a power outage. I've been left without any internet connection and I desperately need a professional to come in and provide effective solutions ASAP. If you have experience in: - Setting up UniFi network - Troubleshooting UniFi network issues - Configuring UniFi devices and you're comfortable with dealing with various types of internet connections, as I'm unsure which one is used in my setup, your skill set is what I'm looking for. Your prompt help will be highly appreciated.

I'm in need of a network engineer with expertise in the Local Area Network (LAN) infrastructure for troubleshooting and optimization. Key Tasks: - Install, rack, and stack a Cisco Catalyst 8300 series device. This includes unboxing, physical mounting, and initial power-on to ensure the device is operational. - Network Troubleshooting: The freelancer should be able to identify and rectify any issues affecting the LAN's performance. - Installation: If necessary, the engineer should help in the setup of new equipment or software for the network. Ideal Candidate: - Proven experience in LAN network design and architecture. - Strong troubleshooting skills and experience in network optimization. - Good knowledge of network security will be a...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

I need an experienced electrical designer with expertise in AutoCAD for an industrial project. The design needs to incorporate power distribution and include layouts for Solar and Wind OFC, WMS and CCTV. Ideal skills and experience: - Proficient in AutoCAD Electrical software - Previous experience with industrial projects - Deep understanding of power distribution - Capable of designing Solar and Wind OFC layouts, WMS and CCTV system Compliance: The design work must adhere to the following industry standards and regulations: - National Electrical Code (NEC) - International Electrotechnical Commission (IEC) Please, include actual experience and project samples that adhere to these standards in your bid.

...seeking a full stack PHP developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality appl...

I am in need of an experienced professional who can help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage s...

I'm in need of a network engineer with expertise in the Local Area Network (LAN) infrastructure for troubleshooting and optimization. Key Tasks: - Install, rack, and stack a Cisco Catalyst 8300 series device. This includes unboxing, physical mounting, and initial power-on to ensure the device is operational. - Network Troubleshooting: The freelancer should be able to identify and rectify any issues affecting the LAN's performance. - Installation: If necessary, the engineer should help in the setup of new equipment or software for the network. Ideal Candidate: - Proven experience in LAN network design and architecture. - Strong troubleshooting skills and experience in network optimization. - Good knowledge of network security will be a...

I need a technical expert skilled in Raspberry Pi integrations to create a display of GPS coordinates, IMU data, and set the frequency for a TBS satellite receiver on a 7inch LCD screen. The components for this project are: - GPS module - IMU module - TBS satellite receiver The LCD display should show GPS coordinates and IMU data in real-time. It also needs to set the frequency for the TBS satellite receiver. The Raspberry Pi setup will be powered by a battery, so considering power consumption in the build is important. Ideal skills for this job would include: - Experience with Raspberry Pi integrations - Familiarity with GPS modules and IMU modules - Knowledge of frequencies for TBS satellite receivers - Proficient in power management for co...

I am in need of an experienced professional who can help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage s...

I need an experienced electrician(s) for installation of 10 new standard 16 A plug points in indoor areas. - Purpose: The plugs would be used primarily for E-cycle charging. Hence, the capacity of points should be appropriate to handle such usage efficiently. - Included Tasks: The task also involves wiring from the main meter to these newly installed plugs. An estimate on the amount and type of cabling required would be appreciated. Racks and channels will be provided for chargers and need to be assembled. - Work Environment: To ensure safety, I prefer professionals who are well-versed in executing indoor projects while following all necessary precautions. Your understanding of power requirements for E-cycle charging, as well as your skill at ensuring wiring safe...

...designed for my fitness brand, Alea Alea. This logo should evoke a sense of power and strength, reflecting the core values of my brand. The ideal freelancer for this project: - Has experience in professional logo designing specifically symbolic types. - Understands how to depict power and strength in design. - Can suggest innovative ideas keeping brand connotation in mind. - Has an impressive portfolio demonstrating their expertise and creativity. Looking forward to finding someone passionate who can bring my vision to life. Remember, this logo will be the face of the Alea Alea brand, it must be unique, impactful, and clear. The logo is going on Gym clothes so I want it to be clean and slick not bulky preferably in black or white but open ...

...translating complex technical concepts into clear, concise writing? We're seeking a skilled freelancer to create informative papers on various aspects mentioned below The ideal candidate will possess the following qualifications: In-depth knowledge of leading HCI solutions: VMware vSAN, NSX, HCX, Azure Stack HCI, etc. Solid grasp of HCI architecture: Distributed storage, software-defined networking, and resource management. Experience deploying, configuring, and managing HCI clusters: Proven track record of hands-on experience.
 Cloud Platforms : Proficency in major cloud platform like Azure, AWS or GCP. 
Experience with cloud automation tools, and automating infrastructure provisioning. Containerization tools like Kubernetes or similar.

Each paper should consis...

I'm looking for a skilled professional to help me with advanced data processing tasks using Power BI and Macros. Key Responsibilities: - Data Cleansing: You will be responsible for ensuring that the data is clean and free of any inconsistencies or errors. Ideal Skills and Experience: - Proficiency in Power BI and Macros - Strong background in data processing - Ability to clean and transform data effectively Please note that the main objective of this project is advanced data processing. The tasks would primarily involve data cleansing and transformation. Feel free to reach out if you have any questions.

...installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm looking for a skille...

...mainly involve QA checks and regression Testing of certain software. All testing done are on confidential pre-release test builds so discretion of what you test IS IMPORTANT. Please acknowledge this in your proposal. An NDA will be signed in this regard. I require someone with excellent IT skills and a very good command and understanding of written English with the ability to fluently understand oral and written instructions in English. Also report writing is a major requirement. Typically, I would require someone with at least 1-year experience in the software testing field. Knowledge or experience in finance and business IT would be a plus. Knowledge of Google Sheets and GSuite overall is a huge plus. I would prefer someone with an ITQSB certificat...

I will need to go through your flow and also have the appropriate access to troubleshoot the issue

I am looking for someone with experience in Comsol simulation to help with piezoelectric energy harvester design at the earliest, ideally within a week. - Beyond the simulation work, I need someone with strong documentation skills. - Required: 1) Generated voltage and power for applied strain% (like in cantileve) 2) Device capacitance, resonance frequency & impedance 3) Piezo strain coefficients for device geometry 4) Displacement (actuation) for different voltage 5) Sensitivity (output) for different level of stimuli (added mass in grams and pressure)

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable websit...

I'm looking for an experienced design engineer who can assist me with designing single-phase generators in 10kW, 20kW, 30kW, and 40kW capacities for the Canadian market. This project involves a thorough review of the Cummins, Kohler, and Briggs and Stratton product offerings; seeing what makes them unique in their design and then coming up with our design. Key deliverables for this project include: - A detailed design proposal for a new brand of single-phase generator tailored for the residential market. - Recommendations for optimal capacity levels (10kW, 20kW, 30kW, and 40kW) based on market demand, competitor analysis, and technical feasibility. - A comprehensive comparative analysis of the existing Cummins, Kohler, and Briggs and Stratton products. - Auto Cad de...

I'm looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level o...

...engage players in a fight with a boss, while level 31 should feature an epic boss. Key Features: - 31 levels: The game should offer a total of 31 levels. Players should be able to progress through them in a logical and challenging manner. - Boss and Epic Boss Fights: The game should have a built-in system that triggers a boss fight every 5th level, as well as an epic boss fight on level 31. These fights should be challenging and engaging. - Coin Collection & Power-Ups: There should be coins scattered throughout the levels that players can collect. These coins can be used to purchase in-game power-ups. I envision the power-ups having a direct impact on gameplay by either enhancing the player's abilities or increasing their health...

I need a professional to create a WordPress site for me. I will give you the design and pages, need to have an event management plugin menu is: Events | Retreats | Power Medicine | The family | Reviews | Media

I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)

...stand out in the UK and Europe recruitment industry. Key information: - Industry: HR - Target roles: Recruitment Specialist, Human Resources Manager, HR Administrator - Essential certifications: SHRM-CP, CIPD, ATS I am looking for a collaborator who can help me secure interviews for these positions. The CV and cover letter will be the first impression employers will have of me, so they need to be outstanding. I prefer someone who is experienced in 1. UK and Europe recruitment 2. Environmental, water resources management, and sustainability field recruitment 3. using HR tools to increase the hiring rate, eg: Applicant Tracking Software ATS The ideal freelancer for this job should: - Have a strong understanding of the HR industry, specifically in the UK and Euro...

exactly similar to this f-system

...seeking a professional that can help me in my quest to create shareable content, I need a videographer and video editor with the following attributes: - Proficiency in the creation and editing of 3-minute videos. - A strong portfolio showcasing previous work in creating comedy, educational, and viral content. - The ability to produce a video bi-weekly. - Skilled in basic post-production editing such as simple cuts, transitions, and text overlays. Your primary responsibilities will include: - Filming and editing videos in a timely manner. - Ensuring the quality and consistency of the videos. - Suggesting and implementing creative ideas to help the content go viral. - Being a team player and collaborating with me to ensure our content sta...

...`11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game. ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Ideal skills for this project: - Strong experie...

...engaging and informative for our users. The ideal candidate will have experience in creating both static and animated graphics and a good understanding of energy management concepts. Requirements: Static Graphics: - Solar Panels - Electric Vehicles - Electric Vehicle Charging Stations - Energy Grid - Home Appliances: - Fridge - Kettle - TV - Toaster - Coffee Machine - Oven - Microwave - Dishwasher - Washing Machine - Clothes Dryer - Iron - Vacuum Cleaner - Air Conditioner - Geyser/Water Heater - Pool Pump - Smart Plug - Smart Thermostat - Bar Meters to show usage - Usage Dials - Usage Meters Animated Diagrams: - Electric Vehicle Chargers - Solar Panels - Energy Utilities/Power Lines/Power Grids - House with Rooms - Electricity Li...

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

I'm seeking a skilled individual to assist with a multi-machine power system dynamics analysis and control. The primary goal of this project is to optimize power flow efficiency. Key Requirements: - Proficiency in power systems dynamics and control analysis - Experience with multi-machine systems - Ability to optimize for voltage levels Your responsibilities will include: - Conducting power system dynamics analysis - Implementing control measures to optimize power flow efficiency - Focusing on voltage levels optimization Ideal candidates should have a strong background in power systems, and be able to work on a multi-machine system. This project will require a good understanding of power flow and voltage levels in...

I'm in need of an electronic circuit and PCB designer proficient in working with ESP32 based microcontrollers, particularly for IoT applications. The project involves creating an efficient, compact, and robust PCB design that supports Wi-Fi connectivity. Key Requirements: - Proficiency in ESP32 based microcontroller design - Prior experience with IoT applications - Familiarity with designing for low power consumption - Expertise in creating compact PCB layouts - Ability to design a PCB for a rugged environment Your expertise in these areas is crucial, as the final product should be both functional and durable. If you're confident in your ability to deliver a high-quality electronic circuit and PCB design for an ESP32 based micr...

...schematics, PCB and firmware for a compact NFC reader. The suggested RFID controller is PN7160. Microcontroller - STM32 0) Two boards - antenna and the main board. The antenna diameter is 15mm with a hole in the center 4-5mm. The main board is 14mm in width and length is 35mm or less. 1) The reader must read and write password-protected memory blocks in Mifare Classic cards. 2) The reader keeps the password for the RFID cards as a hard-coded constant. 3) The reader has an 4-byte reader ID stored in its EEPROM memory. 4) The RGB LED on the edge of the main board, whose location matches the hole in the antenna. RGB LEDs are connected to the PWM pins of the controller. 5) A waterproof (if possible) speaker must be on the opposite edge of the main ...