2470 Courses in Coventry delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

In this course, you will learn the fundamentals of data visualization in Python using the well-known Matplotlib and Seaborn data science libraries and perform exploratory data analysis (EDA) by visualizing a data set using a variety of charts.

Overview In the era where information is abundant and decisions are driven by data, have you ever pondered, 'what is machine learning?' or 'what is data science?' Dive into the realm of 'Data Science & Machine Learning with R from A-Z,' a comprehensive guide to unravel these complexities. This course effortlessly blends the foundational aspects of data science with the intricate depths of machine learning algorithms, all through the versatile medium of R. As the digital economy booms, the demand for machine learning jobs continues to surge. Equip yourself with the proficiency to navigate this dynamic field and transition from being an inquisitive mind to a sought-after professional in the space of data science and machine learning with R. Learning Outcomes: Understand the foundational concepts of data science and machine learning. Familiarise oneself with the R environment and its functionalities. Master data types, structures, and advanced techniques in R. Acquire proficiency in data manipulation and visual representation using R. Generate comprehensive reports using R Markdown and design web applications with R Shiny. Gain a thorough understanding of machine learning methodologies and their applications. Gain insights into initiating a successful career in the data science sector. Why buy this Data Science & Machine Learning with R from A-Z course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Data Science & Machine Learning with R from A-Z there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Data Science & Machine Learning with R from A-Z course for? This course is ideal for Individuals keen on exploring the intricacies of machine learning and data science. Aspiring data analysts and scientists looking to specialise in Machine Learning with R. IT professionals aiming to diversify their skill set in the emerging data-driven market. Researchers seeking to harness the power of R for data representation and analysis. Academics and students aiming to bolster their understanding of modern data practices with R. Prerequisites This Data Science & Machine Learning with R from A-Z does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Science & Machine Learning with R from A-Z was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Scientist - Average salary range: £35,000 - £70,000 Per Annum Machine Learning Engineer - Average salary range: £50,000 - £80,000 Per Annum Data Analyst - Average salary range: £28,000 - £55,000 Per Annum R Developer - Average salary range: £30,000 - £60,000 Per Annum R Shiny Web Developer - Average salary range: £32,000 - £65,000 Per Annum Machine Learning Researcher - Average salary range: £40,000 - £75,000 Per Annum Course Curriculum Data Science and Machine Learning Course Intro Data Science and Machine Learning Introduction 00:03:00 What is Data Science 00:10:00 Machine Learning Overview 00:05:00 Who is This Course for 00:03:00 Data Science and Machine Learning Marketplace 00:05:00 Data Science and Machine Learning Job Opportunities 00:03:00 Getting Started with R Getting Started 00:11:00 Basics 00:06:00 Files 00:11:00 RStudio 00:07:00 Tidyverse 00:05:00 Resources 00:04:00 Data Types and Structures in R Unit Introduction 00:30:00 Basic Type 00:09:00 Vector Part One 00:20:00 Vectors Part Two 00:25:00 Vectors - Missing Values 00:16:00 Vectors - Coercion 00:14:00 Vectors - Naming 00:10:00 Vectors - Misc 00:06:00 Creating Matrics 00:31:00 List 00:32:00 Introduction to Data Frames 00:19:00 Creating Data Frames 00:20:00 Data Frames: Helper Functions 00:31:00 Data Frames Tibbles 00:39:00 Intermediate R Intermediate Introduction 00:47:00 Relational Operations 00:11:00 Conditional Statements 00:11:00 Loops 00:08:00 Functions 00:14:00 Packages 00:11:00 Factors 00:28:00 Dates and Times 00:30:00 Functional Programming 00:37:00 Data Import or Export 00:22:00 Database 00:27:00 Data Manipulation in R Data Manipulation in R Introduction 00:36:00 Tidy Data 00:11:00 The Pipe Operator 00:15:00 The Filter Verb 00:22:00 The Select Verb 00:46:00 The Mutate Verb 00:32:00 The Arrange Verb 00:10:00 The Summarize Verb 00:23:00 Data Pivoting 00:43:00 JSON Parsing 00:11:00 String Manipulation 00:33:00 Web Scraping 00:59:00 Data Visualization in R Data Visualization in R Section Intro 00:17:00 Getting Started 00:16:00 Aesthetics Mappings 00:25:00 Single Variable Plots 00:37:00 Two Variable Plots 00:21:00 Facets, Layering, and Coordinate Systems 00:18:00 Styling and Saving 00:12:00 Creating Reports with R Markdown Creating with R Markdown 00:29:00 Building Webapps with R Shiny Introduction to R Shiny 00:26:00 A Basic R Shiny App 00:31:00 Other Examples with R Shiny 00:34:00 Introduction to Machine Learning Machine Learning Part 1 00:22:00 Machine Learning Part 2 00:47:00 Starting A Career in Data Science Starting a Data Science Career Section Overview 00:03:00 Data Science Resume 00:04:00 Getting Started with Freelancing 00:05:00 Top Freelance Websites 00:05:00 Personal Branding 00:05:00 Importance of Website and Blo 00:04:00 Networking Do's and Don'ts 00:04:00 Assignment Assignment - Data Science & Machine Learning with R 00:00:00

NLP Practitioner Diploma is one of our best selling and most popular course. The NLP Practitioner Diploma is organised into 02 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 4hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? NLP Practitioner Diploma is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

The App Development Mini Bundle is tailor-made for those curious about the technical artistry behind mobile games, code structures and user experience. Whether you're intrigued by Android gaming, fascinated by DevOps strategies or want to brush up on Python basics, this bundle offers the building blocks of app creation—minus the chaos of overloaded tech jargon. From retro joystick nostalgia to sleek UX design, each module adds a purposeful layer to your understanding of app development. It’s structured for those who appreciate logic, design thinking, and systems that do what they’re told—unless you’ve missed a semicolon, of course. Learning Outcomes: Understand game design principles and Android development techniques. Explore the evolution of computer gaming and its major milestones. Study Python syntax, logic, and essential programming structures. Examine DevOps principles for development and operational efficiency. Learn about UX structures and user-centred design strategies. Identify cross-functional approaches in app development planning. Who is this Course For: Learners interested in mobile app and game development theory. Aspiring developers with a flair for structured coding logic. Curious individuals exploring the history of digital games. Professionals seeking Python and DevOps theory refreshers. Students wanting to understand app design from multiple angles. Individuals keen on exploring UX fundamentals and structure. Hobbyists looking into Android development without extra fluff. Tech-minded learners who enjoy well-organised systems and code. Career Path: Android Developer – £42,000/year Game Designer (Mobile) – £38,500/year UX Designer – £43,000/year Python Developer – £45,000/year DevOps Analyst – £48,000/year App Development Consultant – £46,500/year

This course first equips you with the fundamentals of Python and then progresses to teach you how to use various libraries such as NumPy, Pandas, Seaborn, Bokeh, and so on. This course contains several mini projects so that, by the end of this course, you will be equipped with the essential tools you need to become a visualization expert.

The innovative Python from Scratch Level 3 has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector. This popular Python from Scratch Level 3 has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Python from Scratch Level 3 course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Python from Scratch Level 3 is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Python from Scratch Level 3 consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Python from Scratch Level 3 has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Python from Scratch Level 3 course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Python from Scratch Level 3 has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

Course Overview Learn how to manipulate huge amounts of online data and effectively transfer it for personal projects by taking this course on Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4. Using expert guidance and clear instructions, this intuitive coaching will allow you to create an end-to-end GIS (Geographic Information System) application for practical uses and impressive projects.  This comprehensive Python tutorial provides the ideal way to learn how to make the most of these data retrieval and utilisation functions. By making use of Django and ETL techniques, your ability to work with information systems will improve considerably and allow your projects to stand out in the crowd. On completion of the training, you will be able to perform complex data transfers with professional routines, regardless of the complexity of the task and the size of the records.  This best selling Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

The comprehensive Python Complete Crash Course has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Python Complete Crash  Course today, and learn from the very best the industry has to offer! This best selling Python Complete Crash Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Python Complete Crash Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Python Complete Crash Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Python Complete Crash Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Python Complete Crash Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Python Complete Crash Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the to be completed at your Python Complete Crash Course own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Certification After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).