2312 Intelligence courses in Cardiff delivered On Demand

Join this course to learn how to build a dynamic and engaging Tic Tac Toe game for iOS using SwiftUI and Firebase integration. Gain practical skills in game development, SwiftUI, and Firebase integration as you create a fully functional Tic Tac Toe game ready to be deployed to the App Store. Basic knowledge of Swift and SwiftUI is essential.

In this video course, you'll explore the field of web and digital analytics. You'll learn about the various roles in digital analytics and discover the skills and education you need to get into these roles.

This course offers an immersive experience in data analysis, guiding you from initial setup with Python and Pandas, through series and DataFrame manipulation, to advanced data visualization techniques. Perfect for enhancing your data handling and analysis skills.

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Data Analysis (Beginner): Data Analysis Course Online Are you trying to get the knowledge and abilities required to excel in data analysis at the beginner level? Our Data Analysis Course (Beginner) could be your perfect option for this. The Data Analysis Course (Beginner) offers comprehensive training in data analysis methodologies and tools. The Data Analysis Course (Beginner) covers topics such as data cleaning, visualisation, and statistical analysis. Also, the Data Analysis Course (Beginner) teaches programming in Python or R. Moreover, the Data Analysis Course (Beginner) equips students with essential skills for deriving insights from data. This Data Analysis Course (Beginner) explains data manipulation and interpretation. Enrol in our Data Analysis Course (Beginner) to prepare them for careers in data analysis across various industries. Main Course: Data Analytics Course (Beginner) [ Note: Free PDF certificate as soon as completing the Data Analysis (Beginner): Data Analysis Course] Data Analysis (Beginner): Data Analysis Course This Data Analysis (Beginner): Data Analysis Training Course consists of 12 modules. Who is this course for? Data Analysis (Beginner): Data Analysis Course This Data Analysis (Beginner): Data Analysis Course is recommended for anyone looking to advance in their data analysis career. Requirements Data Analysis (Beginner): Data Analysis Course To enrol in this Data Analysis (Beginner): Data Analysis Course, students must fulfil the following requirements: Data Analysis: Good Command over English language is mandatory to enrol in our Data Analysis Course. Data Analysis: Be energetic and self-motivated to complete our Data Analysis Course. Data Analysis: Basic computer Skill is required to complete our Data Analysis Course. Data Analysis: If you want to enrol in our Data Analysis Course, you must be at least 15 years old. Career path Data Analysis (Beginner): Data Analysis Course The Data Analysis (Beginner): Data Analysis Course opens up a wide range of work prospects, especially in the UK labour market.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. 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 course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

This ultimate course to kickstart your Python journey from scratch. This comprehensive course covers all the essential concepts of Python, providing explanations, examples, and practical implementations. Designed with beginners in mind, our goal is to help you learn and master Python by building a variety of projects.

Are you interested in sharing knowledge with others and gaining insightful conclusions from data? This online Power BI course is your comprehensive and in-depth introduction to this powerful software if you've ever been curious about the fascinating, artistic field of data analysis and visualisation. Microsoft Power BI has the potential to be your most effective tool. It comes with all of the features found in MS Excel, as well as many more. Power BI has a wide range of features and functionalities. By obtaining this Power BI training, you'll learn to make the most of all of Microsoft Power BI's features and produce insightful tables, graphs, and reports. Along with this Power BI course, you also receive a number of additional practical and supplemental courses in a package that will assist you in becoming an expert in the field of business and IT. With the supplementary business management course, you will acquire the technical abilities and business knowledge needed to put your skills to use in the industry. Working with various platform data, algorithms, and data structures all are part of the job description of a data analyst. As the course includes Data Structure and Graph theory algorithm courses, this package will aid in your skill improvement as a data analyst. These courses in this bundle will advance your Power BI proficiency and allow you to perform more reasonable experimentation with this Power BI tool. Along with this Power BI course, you will get 10 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Power BI Bundle Consists of the following Premium courses: Course 01: Complete Microsoft Power BI 2021 Course 02: Data Structures Complete Course Course 03: Computer Science: Graph Theory Algorithms Course 04: Introduction to Data Analysis Course 05: Business Analysis Level 3 Course 06: Strategic Business Management Course 07: Enterprise Risk: Identification and Mitigation Level 2 Course 08: GDPR Data Protection Level 5 Course 09: Functional Skills IT Course 10: Decision Making and Critical Thinking Course 11: Time Management With the help of this excellent package, you can develop a professional career in the IT sector while also increasing your own personal growth. To summarise your learning objectives of this bundle: you will be able to, Identify the Power BI components and workflows you need to know Create a data model in Power BI Translate data into graphics using Power BI features Understand different types of data structures and algorithms Perform data analysis and measure the performance of your model Acquire business knowledge about the IT industry Gain time management skills for working as a professional in the corporate sector Your new data visualisation abilities can be used in almost any field of study or employment, including data science, finance, and even graphic design. This can lead to a wide range of professional prospects. So enrol in this course right away to jumpstart your career. Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 11 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of course designed by expert instructors Learn about course at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum: Course 01: Complete Microsoft Power BI 2021 Introduction Preparing our Project Data Transformation - The Query Editor Data Transformation - Advanced Creating a Data Model Data Visualization Power BI & Python Storytelling with Data DAX - The Essentials DAX - The CALCULATE function Power BI Service - Power BI Cloud Row-Level Security More data sources Next steps to improve & stay up to date How will I get my Certificate? After successfully completing the Power BI course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There are no strict requirements, and any experienced computer user is expected to be able to finish the project. This bundle will also be beneficial for, Students from all academic disciplines Students interested in powerful data analysis techniques Anyone in business who wants to transform data into information Users of Excel who want to advance their reporting and analysis Requirements This Power BI course has been designed to be fully compatible with tablets and smartphones. Career path These different credentials will add value to your resume and give you access to a wide range of industries, including, but not limited to, Data analysis IT industry Business and management Freelance worker Entrepreneur Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Complete Microsoft Power BI) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.