How to structure a mern app jobs

I'm in the market for a Shopify expert who can finish my 80% completed store's layout and overall structure. Key Requirements: - The primary task is to revamp the overall layout and structure of the store according to figma. Please Note: - I will be providing all the necessary assets for the redesign. - Only bid if you are an experienced Shopify designer who is also a freelancer actively seeking projects. Looking forward to seeing your proposals.

...for three companies. Each website needs to be designed with a unique blend of minimalist, colorful and vibrant, and clean and professional aesthetics to reflect the unique identity of each entity. Key Elements: - Design and develop three separate portfolio websites - Utilize a vibrant, minimalist, and professional design aesthetic - Include the following pages: Home, About, Services, Portfolio, Contact Ideal Skills and Experience: - Proven track record of designing portfolio websites - Strong understanding of minimalist and professional design principles - Capability to create visually appealing, vibrant designs - Well-versed in creating user friendly websites with a clear navigation structure - Excellent communication skills to...

We are creating a therapeutic domino game and want to optimize the entire scene. The attached image shows the current scene, and we would like to change it to the style of Monopoly GO models with a one-to-one replacement while keeping the room structure the same. Please make your offer

...need a proficient structural engineer who can deliver a General Arrangement (GA) drawing and design verification for a Reinforced Cement Concrete (RCC) beam. The task at hand involves a cantilever carporch of 3.5m x 6m dimensions, destined for vehicle parking. I'm picturing an industrial-style steel beam that will be supported over an existing 250x600 RCC beam, which itself sits atop an RC column. Importantly, the carporch won't be subjected to any extra weight besides the vehicle. Your experience and skills: - Mastery of industrial design style - Proven experience in RCC and steel structure design - Proficient in providing design verification - Knowledgeable in GA drawing - Able to optimize for weight and structural stabilit...

...currently facing a technical issue within my project, specifically with software bugs and errors. I'm looking for a professional who can provide me with expert advice and guidance in resolving this matter. Key tasks: - Identify the root cause of the software bugs or errors that are affecting my project - Provide clear recommendations on how to resolve these issues - Offer guidance on best practices to prevent similar issues in the future Ideal skills and experience: - Proven experience in software development, particularly in identifying and resolving software bugs and errors - Ability to understand and work with the existing codebase and project structure - Strong problem-solving and analytical skills - Excellent communication a...

I'm need of an expert in Excel, particularly with a strength in creating complex calculation systems, for the task of data keeping. Key Tasks: - Understand and implement a data structure for holding financial data - Build a system for complex calculations within the excel sheet Qualities Needed: - Proficiency in Excel - Experience dealing with financial data - Ability to design and incorporate complex formulas for calculations - Analytical thinking The Excel sheet will specifically monitor and report Budget versus Actuals, so experience in handling these aspects are an added advantage. The goal is to have a seamless, reliable system for my financial data.

...urgent need of a professional to revamp my resume from scratch. With special focus on my work experience, education and skill qualifications, you will be crafting a tailor-made resume suitable for technology and content creation and marketing roles. Key Responsibilities: - Analyzing and improving the structure of my current resume - Highlighting my work experience, education, and skills to demonstrate strengths clearly - Aligning my resume to target roles in the technology and content creation and marketing industries Skills & Experience: - Extensive experience in resume writing - Thorough understanding of technology and content creation / marketing roles - Proven record of creating resumes that stand out - Excellent writing and editing s...

I've written a systematic review academic paper that exceeds 5000 words. I'm in need of a professional proofreader and editor to help refine the text. The main goal of this project is to ensure that my paper is not only free of grammatical errors, but also that it reads smoothly and clearly. Key requirements include: - Proofreading for grammar, punctuation, and spelling. - Copy editing for sentence structure, clarity, and overall flow. - Ensuring the paper maintains a strong academic tone. - Providing constructive feedback where necessary. Ideal candidates should have: - A strong background in academic editing, particularly in the field of linguistics, education, and humanities and social sciences. - Excellent proofreading and ...

I am in need of a skilled illustrator to create a black and white comic in a cartoon style. This comic will serve as a promotional tool for a documentary. Key Requirements: - Art Style: The artwork must be cartoonish - Purpose: The main goal of this comic is to promote the documentary - Complexity: The storyline should be simple and straightforward, easy to grasp for viewers Ideal Skills and Experience: - Proven experience in cartoon illustration - Ability to convert a documentary into a captivating comic - Understanding of effective narrative structure - Portfolio demonstrating similar projects is a big plus I am looking for someone who can translate the essence of the documentary into an engagi...

...seeking a skilled freelancer to assist with outreach to roofing companies and contractors. This position offers a commission-based compensation structure. The successful candidate will be responsible for identifying potential leads, establishing contact, and promoting our services. Key responsibilities include: - Conducting market research to identify potential roofing companies and contractors - Developing and implementing outreach strategies to engage with prospects - Building and maintaining relationships with key industry influencers - Tracking and reporting on outreach efforts and results Requirements: - Strong communication and interpersonal skills - Proven experience in outreach and lead generation - Knowledge of th...

I am seeking a writer to craft a compelling and concise essay of less than 500 words. The topic was not specified but the style should be compliant with APA. Skills & Experience Required: - Anyone who has cleared writing creek test. - no AI-generated content - no grammar mistakes - no plagiarism - basic essay structure - word count is 275-300 words - APA style formatting is required if you use any sources.

I am looking for an experienced editor to provide a comprehensive content and structural edit on my manuscript which falls within the range of 50,000 to 100,000 words. I am a sixty-seven-year-old man with five published novels but this is different, it is a memoir, working title: Out Of Step. The story is the product of some recent revelations that shed an entirely new light on my adult life. Key Responsibilities: - Examine the manuscript’s structure and content for coherence, overall narrative flow, and logical order of arguments or events. - Suggest alterations to improve the manuscript, whilst maintaining and enhancing the narrative and descriptive writing style. Ideal Candidate: - Excellent knowledge of narrative and descripti...

...seeking a professional web designer to help improve the layout and structure of my web page. While I have some design ideas in mind, I find myself falling short in execution. Here's what I need in greater detail: • Redesign of page in corporate style • Overhaul of layout and structure for better navigation • Recommendations and implementation of design best practices • Focus on compatibility across multiple devices Ideal skills and experience: • Proven experience in corporate web design • Proficient in HTML, CSS, JavaScript and responsive design • Strong understanding of user-friendly layout structures • Good eye for aesthetics and detail • Excellent communication skills to interpret and negotiate ...

I'm seeking a proficient writer to develop a less than 500-word essay. Unfortunately, I haven't specified a particular topic for the essay; I will provide this later. The project needs to be delivered in the APA format. Key Requirements: Writing assignment - no AI-generated content - no grammar mistakes - no plagiarism - basic essay structure - word count is 275-300 words - APA style formatting is required if you use any sources. Ideal candidates may already have an academic writing background and should be comfortable writing across a variety of potential topics. You'll have the freedom to craft the essay creatively within the word limit. It's crucial that the document follows the guidelines of APA formatting....

As a mid-stage software development project in MS Access, I'm in need of an experienced professional to lend their expertise. Your role will involve helping to push the project to its finalization stage. Key Responsibilities: - Understanding the existing code structure. - Assisting in the ongoing development process. - Problem-solving and debugging as necessary. Ideal Skills and Experience: - Proficient in MS Access. - Previous experience in mid or final stage software development. - Superior problem-solving abilities. - Strong communication skills. Your role will be critical in successfully bringing this project to completion.

I am in need of a professional CV for my business-related experience. I'd like it to be structured functionally, focusing on my skills and achievements over a strict timeline. Key Points: - The CV should be tailored specifically for a business environment, highlighting how my skills and experiences align with corporate needs. - The structure should be functional, grouping my achievements and skills together rather than purely listing my job history. Ideal Freelancer: - Experience in crafting professional CVs, especially for business professionals. - Understanding of functional CV structures and how to effectively highlight skills over job history. - Ability to write in a professional and engaging tone that suits ...

I'm seeking a professional editor to perform both proofreading and in-depth editing on my paper. Here are the specifics: - Subject: The paper revolves around the role of motivation within the context of SLA (Second Language Acquisition). - Word Count: 24-page paper. The ideal candidate should have a background in: - Proven experience in academic writing. - Editing skills to refine the paper's structure and clarity. The scope will include: - Correcting errors in grammar, punctuation, and spelling. - Rewriting any awkward sentences for clarity and style. - Ensuring the logical flow of ideas throughout the paper. - Suggestions on content improvement. I'm aiming for a polished, concise, and coherent final product.

I'm seeking a savvy Squarespace designer to help me create a visually striking portfolio website. This project will be an important showcase for my work across various media, attracting both potential new clients and my existing clientele. Here's what you'll be tasked with: - Implementing a structure of between 6 to 10 pages. - Incorporating custom image galleries and video showcases on these pages. - Ensuring the layout is focused on visual work representation. Ideal candidates will have prior experience in designing portfolio websites, particularly involving media-rich elements. Strong skills in Squarespace are absolutely essential. If you know how to present video and image content in an engaging and professional m...

...Proposal: WordPress Website Development Project Overview: We are seeking a skilled web developer or a development team to create a new WordPress website that is like of the following URL: The website should match the design and aesthetic of the reference website and also its functionality and user experience. Project Scope: Website Development: - Take the design and structure of the reference website. - Ensure the website is fully responsive and optimized for all devices and screen sizes. - Implement an intuitive navigation system similar to the reference site. - WordPress Setup and Customization: - Install the latest version of WordPress on our hosting environment. - Customize the WordPress theme to match the reference website’...

I need a searchable website that tracks product prices from Indian e-commerce platforms, providing alerts when those prices drop. Here's what the ideal candidate should do: - Implement a feature to search for products - Integrate a system to track current prices - Create an alerts system for price drops SKILLS & EXPERIENCE: A successful freelancer should have prior experience in developing price tracking tools and working with Indian e-commerce APIs. Familiarity with popular Indian e-commerce platforms and their price structure is a must. Additionally, knowledge of how to integrate a compelling alert system is crucial. This candidate must demonstrate attention to detail and possess strong data ma...

...Development, your task will be to help me, as Creative Director, to improve the current online Wordpress E-course setup. Some of the old plugins have failed due to being a couple years old and not working with new updates so we want to streamline with the best current-up-to-date plugins while preserving our current savvy theme & style that fits our brand w/ the new best plugins. We want you to help us understand what the savviest, most creative new course plugins are capable of - so we can make a powerful Wordpress backend for our courses - and that these plugin companies will be perennially up-to-date and trustworthy so we don't have to deal with these breakdowns as it brings down our courses for our clients...

...need of a compelling, professional animated video to serve as an explainer. This video should have a How-to guide format, providing clear, concise and engaging directions on a particular topic. Key Details: - Purpose: The video will primarily serve as an explainer for a specific process or concept. - Message: The focus should be on delivering a step-by-step guide for the target audience to follow. - Audience: The video is designed for professionals, so the tone and content should be suited to this demographic. Your Skills: - Prior experience in creating explanatory animated videos is required. - A deep understanding of how-to guide formats and the ability to deliver complex informa...

I am seeking assistance from a professional with substantive knowledge in National Disability Insurance Scheme (NDIS) processes, specifically in the areas of Support Coordination and Plan Management, as well as Specialist Supports. Your role will require you to: - Understand and streamline the services we offer, which are aimed at assisting individuals with disabilities. - Enhance our company's approach towards supporting such individuals so that our mission -- delivering top-notch disability support -- is effectively fulfilled. Ideal candidates will have: - A strong background in disability support services, particularly within the NDIS structure. - Excellent understanding of the needs and challenges of individuals with disabilities. - Experience...

I am looking for expert who can perform Ansys modal analysis for a small mechanical structure. This is to identify resonant frequencies and extract mode shapes.

I am in need of a Python developer who is an expert in Django for a project that requires advanced customization of an existing Django project (DATING BACKEND). The ideal candidate should have experience in customizing and modifying existing Django projects to meet specific requirements. Skills and experience required for the job: - Expert knowledge in Python and Django framework - Good knowledge in GRAPHQL - Strong understanding of Django project structure and architecture - Proven experience in customizing and modifying existing Django projects - Ability to work with complex customization requirements - Familiarity with Django's templating system and ORM - Proficient in writing clean, maintainable, and efficient code - Strong problem-solving skill...

Are you a skilled freelancer with a knack for generating high-quality leads? We're a rapidly expanding freelancing platform in need of a proactive individual who can attract real employers seeking virtual assistants and customer care freelancers to join our platform. Responsibilities: Utilize various sources such as LinkedIn, email marketing, freelancing marketplaces, recruiting websites, and blog postings to generate leads. Engage potential clients and encourage them to register on our platform and opt for one of our subscription plans. Collaborate with our team to refine lead generation strategies and optimize conversion rates. Requirements: Proven experience in lead generation across multiple channels. Strong communication ...

I'm seeking a proficient professional for a full-time role in HR Management. Key Responsiblities: - Develop and implement HR strategies and initiatives aligned with the overall business strategy - Oversee the entire recruitment process, ensuring the sourcing and hiring of highly qualified employees - Promote a positive and open door environment among associates Ideal Skills: - Proven working experience as HR Manager - Thorough knowledge of HR best practices and legal compliance - Proficient in HRMS/HRIS systems Experience in performance management and appraisal systems, and knowledge of relevant HR metrics is a must. Always remember, your approach and attitude can shape the overall structure of our organization.

...color illustrations. The freelancer should be able to interpret written instructions into visual steps to make the manual easy to follow. Proficiency in Adobe Illustrator, or similar digital design tools is a must. The illustrations will convey how to use a snake trap in 4 steps. Unpackaging, placing outside, removing old tray, and placing new tray into box. I must receive the original files as well as the illustrations in PNG format. A description of each step: 1) Take closed trap out of packaging box (rectangular cardboard). Ni need to open lid on the trap, it is all set and ready to go out of the packaging box. 2) Place trap outside along house or any structure you want to use it around. Place ...

I'm in need of a React Native developer for a mobile app I'm working on. The app aims to provide a solid structure, making it easy for users to navigate and interact with the content. Key Requirements: - Mobile App Development Experience: You should have a strong portfolio demonstrating your ability to create engaging and user-friendly mobile applications. - React Native Expertise: Proficiency in React Native is a must. You should be able to handle both iOS and Android apps with ease. - Strong UI/UX Focus: I'm looking for someone who understands the importance of good design and can create a visually appealing and intuitive user interface. - Attention to Detail: The ...

Seeking an urgent Freelance Solutions Architect to craft the roadmap for a Migration project. SPOC: Defining a comprehensive proposed solution approach and architecture for both React JS and Next JS options. Outlining various sprints and phases, along with expected outcomes from each phase (Project Execution Plan). Establishing a progress reporting structure. Structuring the team. Providing time and effort estimates for all roles involved.

– Website Project to be completed in 3 to 5 days. Must be able to communicate in perfect english! I'm looking to build a website for my epoxy garage flooring business with the primary purpose of generating leads for potential customers. The website should be visually engaging, utilizing high-resolution photographs of our past and best works, will enhance the site's appeal and help draw potential customers in, making a strong visual case for our services. An important feature of the website should be a portfolio section where our completed projects can be showcased - this will act as practical examples of our offered services and helps to build trust among potential clients. The ideal candidate for thi...

I’m looking to refresh my website's look with a modern and sleek aesthetic. The main focus will be on updating the design while preserving the existing website layout. What I Need: - Improvement of the overall site design to reflect a more current, sleek and modern style - Retention of the current website layout during the design update Ideal Skills: - Proficiency in modern web design - Strong eye for aesthetic and detail - Proven experience in redesign projects - Ability to work with existing website layout This project is ideally suited for a creative-minded freelancer who has a knack for modern design and can apply it while maintaining the original website structure.

Looking for a React professional with experience in framework to transform my high complexity app with a substantial number of pages and complex featured for better performance. Experience in Server Side Rendering (SSR) is critical. Skills required: - Proficiency in both React and - Experience in converting React apps to - Understanding of and experience with Server-Side Rendering (SSR) - Familiarity with handling complex applications. Project Overview: - Transform existing React app with Server-side rendering (SSR) to to advance performance - App has high complexity including a large number of pages and multilayered features - Main aim is to deliver better app performance The exper...

I'm currently looking for an expert in hybrid machine learning models, specifically for the ARIMA, GCN, and LSTM components. Key improvements needed: - ARIMA: - Improved accuracy of predict...for the ARIMA, GCN, and LSTM components. Key improvements needed: - ARIMA: - Improved accuracy of predictions - Reduced computation time - Better handling of seasonality - GCN: - More effective integration of graph structure - Enhanced extraction of features Skills and Experience Required: - Extensive knowledge in ARIMA, GCN, and LSTM - Proven experience in improving hybrid machine learning models - Proficiency in handling seasonality in data - Ability to work efficiently and reduce computation time. - Skilled in incorporating graph structure and ...

...need of a skilled writer to rewrite a 3-page survey statistics result document as a part of research paper. The goal is to give the content a fresh perspective and engage readers with clear, professional writing. Key Aspects to Address: - Enhance Organization: The current report lacks a clear structure and needs to be reorganized for coherence. - Improve Flow: The flow of information should be revised for better readability and understanding. - Maintain Professionalism: The rewritten content must maintain a professional tone and style, suitable for a survey report. Ideal Freelancer: - Proficient in English: A strong command of English language is essential to effectively convey ...

I'm seeking assistance specifically in algorithm and data structure design in C++ for an academic project. Requirements: - Proficiency in C++: You should have a solid understanding of C++ syntax, language concepts and the ability to write clean, efficient code. - Understanding of basic sorting and searching: Your expertise should cover elementary algorithm design, including basic sorting and searching techniques. - Strong Communication Skills: You should be able to communicate effectively and explain complex ideas in a clear and concise manner. Ideal candidate: - Prior experience in academic projects. - Previous work on algorithm and data structure design. - Familiarity with C++ best practices and standards.

I'm looking for a skilled freelancer who can help me develop a custom GPS tracker using the Ai-Thinker A9G GPS/GPRS module. Key features: - Real-time tracking: The ability to track the device in real-time is crucial. - Speed tracking: I need the device to be able to measure and communicate its speed accurately. Compatibility: - The custom GPS tracker should be designed to work seamlessly with the Ai-Thinker A9G GPS/GPRS module. Requirements Details:- 1. Assign unique ID to module. 2. Switch button to enbale/disable tracking. 3. Fetch GPS coordinates 3.1 Store last 50 coordinates in memory. 3.2 Have customizable recording frequency (i.e. Rate at which module should capture GPS coordinates) 4. Push GPS coorinates to...

...require an all-encompassing research report of a country and its indicator. I do have some obiectives in mind for this report, a very good mark, thus your unique interpretation and direction is most valuable. Please let me know, I have everything, the structure and an example of a report from our teacher. Ideally, I'm seeking someone with: - Excellent business acumen and understanding of the industry - Enthusiasm for economic data analysis - Solid grasp on conducting both primary and secondary research - Strong report writing skills, with the ability to provide insightful analysis. This task has a vast scope so you'll need the ability to discern and extract the most relevant and impactful information. Taking this vague brief a...

...strategies. 4. Apply strategic models and tools to develop strategic options for an organisation. 5. Evaluate strategic options for an organisation. 6. Present a SWOT table (or equivalent) and critically evaluate the organisations current strategic position With Presentation speaker notes Word document Format Report 1. Critically evaluate the relationship between the organisation’s, corporate, business and operational strategies. 2. Apply strategic models and tools to recommend strategic options for the organisation. 3. Evaluate critical success factors/assumptions that underpin the strategic options you have developed. 4. Recommend and justify a strategic option and accompanying business objectives. 5. Identify change factors by completing a...

I'm looking for a skilled professional in lead generation to help me with my healthcare business. Here's what you need to know: - Industry: Health, Wellness, Mental Health, Addiction To achieve this, I'm interested in utilizing the following lead generation methods: - Email Marketing - Social Media Campaigns - Content Marketing I'm looking for someone who has a proven track record with lead generation, ideally within the healthcare industry. Experience with email marketing, social media campaigns, and content marketing will be highly advantageous. Also, experience hiring influencers who could support our campaign. This project will be on a commission-based structure, rewarding you for the quality and quantity of l...

I'm looking for a skilled SEO specialist to increase traffic to my website. Key Deliverables: - Implement On-page SEO strategies to optimize my website's content. - Develop Off-page SEO tactics for building high-quality backlinks. - Enhance the website's Technical SEO to improve its structure and performance. I have a broad target audience, including local, national, and international users. The ideal candidate should have a deep understanding of various SEO techniques and how to apply them effectively to reach a diverse audience. Proven experience in boosting website traffic and knowledge of SEO tools and software is a plus.

I am currently working on a project that involves designing a spar structure for an aerospace application. I require the expertise of a freelancer to perform a detailed stress analysis using ANSYS. Key Responsibilities: - Conduct a comprehensive stress analysis on the spar structure. - Ensure the analysis is geared towards aerospace standards and requirements. Ideal Skills & Experience: - Proficiency in ANSYS software, specifically in performing detailed stress analysis. - Prior experience in aerospace engineering, particularly in spar structure design. - Strong understanding of industry-specific requirements and standards.

I'm in need of a skilled content writer specializing in personal finance and investing. The target audience for this financial blog are beginners and intermediate level readers. Key requirements: - Avid personal finance and investing knowledge - Previous experience writing for financial blogs - Ability to develop engaging, informative content - Understanding of content marketing strategies - Excellent grammar and language structure - Consistent availability to produce two blog posts a week Please include samples of your previous work in your proposal. I look forward to seeing how you can help make this blog a valuable resource for its intended readers.

I'm in need of a professional who can help me create a concise executive report. The aim of this project report is to provide a high-level summary of key findings, conclusions, and recommendations. The report should be in PDF format for ease of distribution and review by stakeholders. Ideal candidates will be able to: - Understand complex data and distill it down to key points - Write clearly and concisely - Produce attractive and easy-to-read documents in PDF format - Understand how to structure an executive report for maximum impact This project is ideal for individuals with experience in business analysis, data interpretation, or executive summaries. If this sounds like a project you'd be interes...

...new material to keep the course content up-to-date and engaging. - Rewriting existing content: If the existing content needs to be rephrased or updated, you'll need to rewrite it without altering the core message and learning objectives. - Improving course structure: You'll also need to assess and potentially reorganize the course structure to enhance the learning experience for the target audience. Ideal Skills: - Experience in instructional design and e-learning development - Proficiency in writing educational content - Fluent in English - Interest in health, nutrition, gut and skin health - A understanding of anatomy and physiology - Capability to adapt content for intermediate learners - Understand...

I've built my ecomme...can't quite wrap it up on my own. Specifically, I'm facing issues with the structure of the site that include the following challenges: - Resolving Issues with Templates - Modifying Existing Structures The potential frelancer should have a robust understanding of WooCommerce and a knack for problem-solving, with experience in handling similar issues. The perfect fit would be someone who has: - In-depth proficiency with WooCommerce platform - An eye for debugging and problem-solving skills - Knowledge of best practices for ecommerce site structures I’m looking for a swift turnaround without compromising the quality of the work. If you've got the experience and skills mentioned, please get in touch. I can'...

I need a skilled 3D designer who can swiftly modify my existing project. The modifications I'm looking for include changes in design elements, addition of new features and improvement of the overall structure. The ultimate goal is to create a fully functional master plan. Key Tasks: - Changing design elements - Adding new features and functionality - Improving the overall structure Specific Changes Needed: - Interior material addition - Inclusion of various interior objects - Modification of the master plan Ideal Skills and Experience: - Proficiency in 3D design and modeling - Previous experience in creating master plans - Ability to swiftly deliver high-quality work - Strong attention to detail and aesthetics - Excellent communicat...

...experienced music producer to compose a custom song in Studio One for me. Key Requirements: - Genre: The genre is open-ended, and I'm open to suggestions. - Mood: I'm looking for a song that conveys a specific emotional tone. This could be happy, sad, energetic or any other emotion. - Instruments: I would like to incorporate piano, guitar, and drums in the song. Expand your song project by incorporating techniques from the previous projects: Make a recording and import the audio into Studio One Use editing techniques (splicing, fading, transposing, and reversing audio) and plugin effects to manipulate audio (either the recording you make or audio you find--as in a song or field recording) Develop your str...

...MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this ...

**Project Scope** Seeking skilled Data Analyst specializing in PUBG Mobile to elevate our team's performance using data insights. Project goals: * Performance Baseline: Deep understanding of our team's key metrics (individual players & team stats). * Competitive Benchmarking: Analyze opponents to uncover strengths, weaknesses, strategic tendencies. * Optimal Rotation Analysis: Decipher winning map rotation patterns from videos. Find areas we can improve. * Data-Driven Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * SQL queries designed for meaningful p...