• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1151 Data Analysis courses in Leicester delivered Online

Microsoft Power BI - Master Power BI in 90 Minutes!

By NextGen Learning

Course Overview This "Microsoft Power BI - Master Power BI in 90 Minutes!" course offers a concise yet comprehensive introduction to Power BI, empowering learners to quickly create and manage data dashboards. The course is designed for both newcomers and those looking to enhance their skills, covering essential topics to help users understand and utilise Power BI for data analysis and reporting. Upon completion, learners will gain the ability to design dynamic dashboards, manipulate data, and visualise trends, providing valuable insights for decision-making in various business environments. Course Description This course takes learners through Power BI’s core functionalities, starting with an introduction to the platform before advancing to building basic and sophisticated dashboards. Learners will explore key aspects such as data import, filtering, and the creation of interactive visuals. By working with live data, participants will develop an understanding of how to generate real-time reports, enhancing their ability to analyse data and derive insights. The course offers both beginner and advanced concepts, ensuring that all participants can apply what they’ve learned to real-world data scenarios. Upon completing the course, learners will feel confident in their ability to utilise Power BI to its full potential in any business context. Course Modules Module 01: Power BI - Introduction Module 02: Your First Power BI Dashboard Module 03: Your Advanced Power BI Dashboard with Real Live Data Module 04: Course Bonuses (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to improve data visualisation and reporting capabilities. Beginners with an interest in business intelligence or data management. Anyone looking to gain insights into data-driven decision-making. Career Path Business Intelligence Analyst Data Analyst Data Visualisation Specialist Marketing Data Analyst Financial Analyst

Microsoft Power BI - Master Power BI in 90 Minutes!
Delivered OnlineFlexible Dates
£7.99

Counselling, Psychology and Cognitive Development

4.7(160)

By Janets

Follow your dreams by enrolling on the Counselling, Psychology and Cognitive Development course today and develop the experience, skills and knowledge you need to enhance your professional development. Counselling, Psychology and Cognitive Development will help you arm yourself with the qualities you need to work towards your dream job. Study the Counselling, Psychology and Cognitive Development training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Counselling, Psychology and Cognitive Development course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Counselling, Psychology and Cognitive Development course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Counselling, Psychology and Cognitive Development course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Counselling, Psychology and Cognitive Development course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Counselling, Psychology and Cognitive Development course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Counselling, Psychology and Cognitive Development course. The Counselling, Psychology and Cognitive Development course is designed by industry experts and is tailored to help you learn new skills with ease.  The Counselling, Psychology and Cognitive Development is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Counselling, Psychology and Cognitive Development when it suits you. Access the Counselling, Psychology and Cognitive Development course modules from any internet-enabled device, including computers, tablets, and smartphones. The Counselling, Psychology and Cognitive Development course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Counselling, Psychology and Cognitive Development now and start learning instantly! Please note that this course does not entitle you to join the HCPC register or recognised as psychologist. Through this course you will come across all the basic guidelines of psychology to boost and shine your knowledge in this particular field of Psychology and it will add your CPD points. What You Get Out Of Studying Counselling, Psychology and Cognitive Development With Janets: Receive a digital Certificate upon successful completion of the Counselling, Psychology and Cognitive Development course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Counselling, Psychology and Cognitive Development training course is delivered through Janets' online learning platform. Access the Counselling, Psychology and Cognitive Development content from any internet-enabled device whenever or wherever you want to. The Counselling, Psychology and Cognitive Development course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Counselling, Psychology and Cognitive Development course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Counselling, Psychology and Cognitive Development course. After successfully passing the Counselling, Psychology and Cognitive Development course exam, you will be able to apply for a CPD-accredited certificate as proof of your Counselling, Psychology and Cognitive Development qualification. Certification All students who successfully complete the Counselling, Psychology and Cognitive Development course can instantly download their digital certificate. You can also purchase a hard copy of the Counselling, Psychology and Cognitive Development course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Counselling, Psychology and Cognitive Development is ideal for those who already work in this sector or are an aspiring professional. This Counselling, Psychology and Cognitive Development course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Counselling, Psychology and Cognitive Development is open to all students and has no formal entry requirements. To study the Counselling, Psychology and Cognitive Development course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Counselling, Psychology and Cognitive Development is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Counselling, Psychology and Cognitive Development and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Perspectives in Psychology What is Psychology 00:08:00 The Biological Approach 00:10:00 Behaviourist and Cognitive Approaches 00:10:00 Person-Centred Approaches 00:09:00 Research Methods in Psychology 00:12:00 Debates in Psychology 00:13:00 Social Psychology Social Influence: Compliance, Obedience and Conformity 00:10:00 Social Cognition 00:09:00 Applied Social Psychology 00:10:00 Cognitive Psychology and Its Applications Perception 00:10:00 Attention 00:07:00 Remembering (Memory) 00:10:00 Forgetting (Memory) 00:07:00 Language 00:10:00 Thinking (Cognition) 00:07:00 Attitudes 00:10:00 Problem-Solving and Artificial Intelligence 00:09:00 Child Development Issues in Child Development 00:05:00 Cognitive Development 00:07:00 The Development of Language and Communication 00:06:00 Social Perception (Interpersonal Perception) 00:06:00 Moral Development 00:09:00 The Psychology of Atypical (Abnormal) Behaviour The definition and Diagnosis of Atypical (Abnormal) Behaviour 00:07:00 Treatments of atypical (abnormal) behaviour 00:07:00 Emotional disorders 00:05:00 Research Methods Research Methods 00:06:00 Research Issues 00:06:00 Data Analysis 00:07:00 Thank You and Good Bye! 00:02:00 Resources Resources - Psychology Diploma 00:00:00 Mock Exam Mock Exam- Counselling, Psychology and Cognitive Development 00:20:00 Final Exam Final Exam- Counselling, Psychology and Cognitive Development 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Counselling, Psychology and Cognitive Development
Delivered Online On Demand4 hours 34 minutes
£25

Introduction to R Programming

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Business Analysts, Technical Managers, and Programmers Overview This intensive training course helps students learn the practical aspects of the R programming language. The course is supplemented by many hands-on labs which allow attendees to immediately apply their theoretical knowledge in practice. Over the past few years, R has been steadily gaining popularity with business analysts, statisticians and data scientists as a tool of choice for conducting statistical analysis of data as well as supervised and unsupervised machine learning. What is R ? What is R? ? Positioning of R in the Data Science Space ? The Legal Aspects ? Microsoft R Open ? R Integrated Development Environments ? Running R ? Running RStudio ? Getting Help ? General Notes on R Commands and Statements ? Assignment Operators ? R Core Data Structures ? Assignment Example ? R Objects and Workspace ? Printing Objects ? Arithmetic Operators ? Logical Operators ? System Date and Time ? Operations ? User-defined Functions ? Control Statements ? Conditional Execution ? Repetitive Execution ? Repetitive execution ? Built-in Functions ? Summary Introduction to Functional Programming with R ? What is Functional Programming (FP)? ? Terminology: Higher-Order Functions ? A Short List of Languages that Support FP ? Functional Programming in R ? Vector and Matrix Arithmetic ? Vector Arithmetic Example ? More Examples of FP in R ? Summary Managing Your Environment ? Getting and Setting the Working Directory ? Getting the List of Files in a Directory ? The R Home Directory ? Executing External R commands ? Loading External Scripts in RStudio ? Listing Objects in Workspace ? Removing Objects in Workspace ? Saving Your Workspace in R ? Saving Your Workspace in RStudio ? Saving Your Workspace in R GUI ? Loading Your Workspace ? Diverting Output to a File ? Batch (Unattended) Processing ? Controlling Global Options ? Summary R Type System and Structures ? The R Data Types ? System Date and Time ? Formatting Date and Time ? Using the mode() Function ? R Data Structures ? What is the Type of My Data Structure? ? Creating Vectors ? Logical Vectors ? Character Vectors ? Factorization ? Multi-Mode Vectors ? The Length of the Vector ? Getting Vector Elements ? Lists ? A List with Element Names ? Extracting List Elements ? Adding to a List ? Matrix Data Structure ? Creating Matrices ? Creating Matrices with cbind() and rbind() ? Working with Data Frames ? Matrices vs Data Frames ? A Data Frame Sample ? Creating a Data Frame ? Accessing Data Cells ? Getting Info About a Data Frame ? Selecting Columns in Data Frames ? Selecting Rows in Data Frames ? Getting a Subset of a Data Frame ? Sorting (ordering) Data in Data Frames by Attribute(s) ? Editing Data Frames ? The str() Function ? Type Conversion (Coercion) ? The summary() Function ? Checking an Object's Type ? Summary Extending R ? The Base R Packages ? Loading Packages ? What is the Difference between Package and Library? ? Extending R ? The CRAN Web Site ? Extending R in R GUI ? Extending R in RStudio ? Installing and Removing Packages from Command-Line ? Summary Read-Write and Import-Export Operations in R ? Reading Data from a File into a Vector ? Example of Reading Data from a File into A Vector ? Writing Data to a File ? Example of Writing Data to a File ? Reading Data into A Data Frame ? Writing CSV Files ? Importing Data into R ? Exporting Data from R ? Summary Statistical Computing Features in R ? Statistical Computing Features ? Descriptive Statistics ? Basic Statistical Functions ? Examples of Using Basic Statistical Functions ? Non-uniformity of a Probability Distribution ? Writing Your Own skew and kurtosis Functions ? Generating Normally Distributed Random Numbers ? Generating Uniformly Distributed Random Numbers ? Using the summary() Function ? Math Functions Used in Data Analysis ? Examples of Using Math Functions ? Correlations ? Correlation Example ? Testing Correlation Coefficient for Significance ? The cor.test() Function ? The cor.test() Example ? Regression Analysis ? Types of Regression ? Simple Linear Regression Model ? Least-Squares Method (LSM) ? LSM Assumptions ? Fitting Linear Regression Models in R ? Example of Using lm() ? Confidence Intervals for Model Parameters ? Example of Using lm() with a Data Frame ? Regression Models in Excel ? Multiple Regression Analysis ? Summary Data Manipulation and Transformation in R ? Applying Functions to Matrices and Data Frames ? The apply() Function ? Using apply() ? Using apply() with a User-Defined Function ? apply() Variants ? Using tapply() ? Adding a Column to a Data Frame ? Dropping A Column in a Data Frame ? The attach() and detach() Functions ? Sampling ? Using sample() for Generating Labels ? Set Operations ? Example of Using Set Operations ? The dplyr Package ? Object Masking (Shadowing) Considerations ? Getting More Information on dplyr in RStudio ? The search() or searchpaths() Functions ? Handling Large Data Sets in R with the data.table Package ? The fread() and fwrite() functions from the data.table Package ? Using the Data Table Structure ? Summary Data Visualization in R ? Data Visualization ? Data Visualization in R ? The ggplot2 Data Visualization Package ? Creating Bar Plots in R ? Creating Horizontal Bar Plots ? Using barplot() with Matrices ? Using barplot() with Matrices Example ? Customizing Plots ? Histograms in R ? Building Histograms with hist() ? Example of using hist() ? Pie Charts in R ? Examples of using pie() ? Generic X-Y Plotting ? Examples of the plot() function ? Dot Plots in R ? Saving Your Work ? Supported Export Options ? Plots in RStudio ? Saving a Plot as an Image ? Summary Using R Efficiently ? Object Memory Allocation Considerations ? Garbage Collection ? Finding Out About Loaded Packages ? Using the conflicts() Function ? Getting Information About the Object Source Package with the pryr Package ? Using the where() Function from the pryr Package ? Timing Your Code ? Timing Your Code with system.time() ? Timing Your Code with System.time() ? Sleeping a Program ? Handling Large Data Sets in R with the data.table Package ? Passing System-Level Parameters to R ? Summary Lab Exercises Lab 1 - Getting Started with R Lab 2 - Learning the R Type System and Structures Lab 3 - Read and Write Operations in R Lab 4 - Data Import and Export in R Lab 5 - k-Nearest Neighbors Algorithm Lab 6 - Creating Your Own Statistical Functions Lab 7 - Simple Linear Regression Lab 8 - Monte-Carlo Simulation (Method) Lab 9 - Data Processing with R Lab 10 - Using R Graphics Package Lab 11 - Using R Efficiently

Introduction to R Programming
Delivered OnlineFlexible Dates
Price on Enquiry

UK Self Assessment Tax Return: 8-in-1 Premium Online Courses Bundle

By Compete High

Make taxes your superpower. The UK Self Assessment Tax Return: 8-in-1 Premium Online Courses Bundle is perfect for anyone seeking roles in tax, finance, freelancing, or accounting support. 💼📊 🧾 Description Featuring high-demand topics like Sage, Xero, Power BI, Excel, data analysis, and tax, this bundle is tailored for work in accountancy, tax return filing, self-employed finance, and data entry. 🧾 Job tracks include: Self-Assessment Assistant Freelancer Finance Support Bookkeeping Clerk Tax Return Specialist Accounting Assistant 🚨 Filing season waits for no one. Equip yourself today. ⭐ Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot ❓ FAQ Q: Can this help with freelance tax filing? A: Absolutely! It’s designed for both self-employed professionals and admin staff. Q: Do I need experience with Excel or Sage? A: Not at all—you’ll get started from scratch.

UK Self Assessment Tax Return: 8-in-1 Premium Online Courses Bundle
Delivered Online On Demand16 hours
£28.99

Managing & Influencing Stakeholders – 20-in-1 Premium Online Courses Bundle

By Compete High

Effective stakeholder management isn't just about communication—it's about influence, trust, and decision-making. This 20-in-1 bundle gives you the tools to manage people, processes, and projects with clarity and authority. Get trained. Get noticed. Before someone else gets the role. 🔍 Description Influencing stakeholders across departments or clients requires a hybrid of soft skills and operational know-how. This 20-in-1 training collection builds exactly that. With certificates covering leadership, negotiation, disaster response, data analysis, and legal compliance, you’ll come across as a well-rounded professional who understands how to deliver under pressure. Whether you're in operations, admin, legal support, or HR—this bundle adds value to your CV and strengthens your position for management-track roles. And since every course comes with its own certificate, you're not just learning—you’re building a verifiable skillset employers will notice. ❓ FAQ Q: Is this training bundle practical for managers? A: Yes—it’s excellent for aspiring and current managers across industries. Q: What roles does it align with? A: Stakeholder Engagement Officer, Project Support, HR Assistant, Operations Coordinator, Risk Consultant. Q: Is it beginner-friendly? A: Definitely—it suits early professionals and those brushing up their credentials. Q: How long will I have access? A: You’ll get lifetime access to all 20 courses. Q: Will I get certificates? A: Yes—one per completed course.

Managing & Influencing Stakeholders – 20-in-1 Premium Online Courses Bundle
Delivered Online On Demand1 hour
£49.99

Excel Vlookup, Xlookup, Match and Index

By NextGen Learning

Excel Vlookup, Xlookup, Match and Index Course Overview: This comprehensive course covers essential Excel functions such as VLOOKUP, XLOOKUP, MATCH, and INDEX, which are integral for efficient data management and analysis. Learners will gain a clear understanding of how to use these functions to simplify complex data tasks, enhance productivity, and improve decision-making. Throughout the course, students will master how to search, match, and retrieve data from large datasets, preparing them for real-world scenarios in finance, marketing, HR, and more. The course is designed to equip learners with the necessary skills to perform advanced Excel functions with confidence, contributing to their professional growth and data analysis expertise. Course Description: In this course, learners will explore the powerful functions of Excel, including VLOOKUP, XLOOKUP, MATCH, and INDEX, enabling them to perform efficient data searches, cross-referencing, and information retrieval. The course includes step-by-step lessons on how to apply these functions to real-world datasets, making it highly relevant for anyone working with large volumes of data. Learners will become proficient in building dynamic spreadsheets that streamline decision-making processes and improve data accuracy. Additionally, this course emphasises problem-solving techniques, empowering individuals to handle complex data-related tasks with ease. By the end of the course, learners will have a strong command of these Excel functions, boosting their data management and analytical capabilities. Excel Vlookup, Xlookup, Match and Index Curriculum: Module 01: Excel VLOOKUP Module 02: Excel XLOOKUP Module 03: Excel MATCH Module 04: Excel INDEX Module 05: Advanced VLOOKUP Techniques Module 06: Combining VLOOKUP, MATCH, and INDEX Module 07: Practical Applications of XLOOKUP (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel skills for data analysis. Professionals aiming to improve their data management capabilities. Beginners with an interest in learning advanced Excel functions. Anyone looking to improve their problem-solving abilities in data-heavy tasks. Career Path: Data Analyst Financial Analyst Marketing Analyst HR Specialist Business Intelligence Specialist Excel Expert for Administrative or Management Roles

Excel Vlookup, Xlookup, Match and Index
Delivered OnlineFlexible Dates
£7.99

Microsoft Excel Complete Course - Beginner Intermediate & Advanced

By iStudy UK

Microsoft Excel Complete Course - Beginner Intermediate & Advanced To make learning Microsoft Excel easier for you, we have thoughtfully bundled our three greatest courses: Microsoft Excel Beginners, Intermediate, and Advanced. At this price, you won't find a better deal anywhere else. One of the most popular applications for visualizing and analyzing data that has been created to date is Microsoft Excel. These days, practically every industry and household use this helpful program for personal purposes. Excel is used by business owners for a plethora of tasks, including data analysis, visualizing data, tracking hours worked, money, and statements. This Microsoft Excel Complete Course can be very helpful to you whether you are a newbie, have some training and experience with the program, or haven't used Excel in a long time and need a thorough refresher to develop your skills. After completing this course, you will be a proficient Excel user. In a short period of time, our simple lessons will impart the knowledge in a very easy way. There won't be a rush because you can study whenever you want and at your own speed. After completing the course, your confidence in using Excel will increase. Course Highlights Microsoft Excel Complete Course - Beginner Intermediate & Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel Complete Course - Beginner Intermediate & Advanced into 73 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel Complete Course - Beginner Intermediate & Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Excel Complete Course - Beginner Intermediate & Advanced is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Excel Complete Course - Beginner Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel Complete Course - Beginner Intermediate & Advanced Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started With Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying A Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting A Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working With Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working With Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data With Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables And Pivot Charts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with Pivot Charts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working With Multiple Worksheets And Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions And Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Sharing And Protecting Workbooks Collaborate on a Workbook 00:20:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines And Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel Templates Excel Templates 00:00:00 Resources Microsoft Excel 2019 00:00:00 Assignment Assignment - Microsoft Excel Complete Course - Beginner Intermediate & Advanced 00:00:00

Microsoft Excel Complete Course - Beginner Intermediate & Advanced
Delivered Online On Demand11 hours 6 minutes
£25

Data Engineering on Google Cloud

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This class is intended for experienced developers who are responsible for managing big data transformations including: Extracting, loading, transforming, cleaning, and validating data. Designing pipelines and architectures for data processing. Creating and maintaining machine learning and statistical models. Querying datasets, visualizing query results and creating reports Overview Design and build data processing systems on Google Cloud Platform. Leverage unstructured data using Spark and ML APIs on Cloud Dataproc. Process batch and streaming data by implementing autoscaling data pipelines on Cloud Dataflow. Derive business insights from extremely large datasets using Google BigQuery. Train, evaluate and predict using machine learning models using TensorFlow and Cloud ML. Enable instant insights from streaming data Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hand-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data. Introduction to Data Engineering Explore the role of a data engineer. Analyze data engineering challenges. Intro to BigQuery. Data Lakes and Data Warehouses. Demo: Federated Queries with BigQuery. Transactional Databases vs Data Warehouses. Website Demo: Finding PII in your dataset with DLP API. Partner effectively with other data teams. Manage data access and governance. Build production-ready pipelines. Review GCP customer case study. Lab: Analyzing Data with BigQuery. Building a Data Lake Introduction to Data Lakes. Data Storage and ETL options on GCP. Building a Data Lake using Cloud Storage. Optional Demo: Optimizing cost with Google Cloud Storage classes and Cloud Functions. Securing Cloud Storage. Storing All Sorts of Data Types. Video Demo: Running federated queries on Parquet and ORC files in BigQuery. Cloud SQL as a relational Data Lake. Lab: Loading Taxi Data into Cloud SQL. Building a Data Warehouse The modern data warehouse. Intro to BigQuery. Demo: Query TB+ of data in seconds. Getting Started. Loading Data. Video Demo: Querying Cloud SQL from BigQuery. Lab: Loading Data into BigQuery. Exploring Schemas. Demo: Exploring BigQuery Public Datasets with SQL using INFORMATION_SCHEMA. Schema Design. Nested and Repeated Fields. Demo: Nested and repeated fields in BigQuery. Lab: Working with JSON and Array data in BigQuery. Optimizing with Partitioning and Clustering. Demo: Partitioned and Clustered Tables in BigQuery. Preview: Transforming Batch and Streaming Data. Introduction to Building Batch Data Pipelines EL, ELT, ETL. Quality considerations. How to carry out operations in BigQuery. Demo: ELT to improve data quality in BigQuery. Shortcomings. ETL to solve data quality issues. Executing Spark on Cloud Dataproc The Hadoop ecosystem. Running Hadoop on Cloud Dataproc. GCS instead of HDFS. Optimizing Dataproc. Lab: Running Apache Spark jobs on Cloud Dataproc. Serverless Data Processing with Cloud Dataflow Cloud Dataflow. Why customers value Dataflow. Dataflow Pipelines. Lab: A Simple Dataflow Pipeline (Python/Java). Lab: MapReduce in Dataflow (Python/Java). Lab: Side Inputs (Python/Java). Dataflow Templates. Dataflow SQL. Manage Data Pipelines with Cloud Data Fusion and Cloud Composer Building Batch Data Pipelines visually with Cloud Data Fusion. Components. UI Overview. Building a Pipeline. Exploring Data using Wrangler. Lab: Building and executing a pipeline graph in Cloud Data Fusion. Orchestrating work between GCP services with Cloud Composer. Apache Airflow Environment. DAGs and Operators. Workflow Scheduling. Optional Long Demo: Event-triggered Loading of data with Cloud Composer, Cloud Functions, Cloud Storage, and BigQuery. Monitoring and Logging. Lab: An Introduction to Cloud Composer. Introduction to Processing Streaming Data Processing Streaming Data. Serverless Messaging with Cloud Pub/Sub Cloud Pub/Sub. Lab: Publish Streaming Data into Pub/Sub. Cloud Dataflow Streaming Features Cloud Dataflow Streaming Features. Lab: Streaming Data Pipelines. High-Throughput BigQuery and Bigtable Streaming Features BigQuery Streaming Features. Lab: Streaming Analytics and Dashboards. Cloud Bigtable. Lab: Streaming Data Pipelines into Bigtable. Advanced BigQuery Functionality and Performance Analytic Window Functions. Using With Clauses. GIS Functions. Demo: Mapping Fastest Growing Zip Codes with BigQuery GeoViz. Performance Considerations. Lab: Optimizing your BigQuery Queries for Performance. Optional Lab: Creating Date-Partitioned Tables in BigQuery. Introduction to Analytics and AI What is AI?. From Ad-hoc Data Analysis to Data Driven Decisions. Options for ML models on GCP. Prebuilt ML model APIs for Unstructured Data Unstructured Data is Hard. ML APIs for Enriching Data. Lab: Using the Natural Language API to Classify Unstructured Text. Big Data Analytics with Cloud AI Platform Notebooks What's a Notebook. BigQuery Magic and Ties to Pandas. Lab: BigQuery in Jupyter Labs on AI Platform. Production ML Pipelines with Kubeflow Ways to do ML on GCP. Kubeflow. AI Hub. Lab: Running AI models on Kubeflow. Custom Model building with SQL in BigQuery ML BigQuery ML for Quick Model Building. Demo: Train a model with BigQuery ML to predict NYC taxi fares. Supported Models. Lab Option 1: Predict Bike Trip Duration with a Regression Model in BQML. Lab Option 2: Movie Recommendations in BigQuery ML. Custom Model building with Cloud AutoML Why Auto ML? Auto ML Vision. Auto ML NLP. Auto ML Tables.

Data Engineering on Google Cloud
Delivered OnlineFlexible Dates
Price on Enquiry

Library and Information Science: 8-in-1 Premium Online Courses Bundle

By Compete High

Step into a knowledge-driven career with the Library and Information Science: 8-in-1 Premium Online Courses Bundle—built for those seeking roles in data, research, records, and library systems. 📖💼 🧾 Description Ideal for work in public libraries, academic archives, corporate information centres, or data entry and analysis, this bundle blends library management, GDPR, IT, Word, Excel, data analysis, and documents control. It’s the shortcut to employability in information-driven professions. 🔎 Roles this bundle supports: Records Officer Library Assistant Information Manager Administrative Support Data Entry Clerk 🎯 The future of information science is digital. Don’t fall behind. ⭐ Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot ❓ FAQ Q: Will this help with admin or records jobs? A: Yes! It’s perfect for document control, data entry, and digital library systems. Q: Do I need to know Excel or Word beforehand? A: Not at all—you’ll get the foundation built in.

Library and Information Science: 8-in-1 Premium Online Courses Bundle
Delivered Online On Demand16 hours
£28.99

Complete Mechanical Engineering - CPD Certified

5.0(3)

By School Of Health Care

Mechanical Engineering: Mechanical Engineering Would you like to work in the field of mechanical engineering? Our mechanical engineering course will help you understand engineering mathematics, fundamental physics, and an introduction to mechanical engineering. This mechanical engineering course explains heat transport, thermodynamics, and materials science. This mechanical engineering course discusses aerodynamics and fluid mechanics. Moreover, the mechanical engineering course covers kinematics, structural analysis, machine design, and the mechanics of solids. Through the mechanical engineering course, you will comprehend dynamics, control systems, and capstone design projects. Additionally, the mechanical engineering course describes technology, sustainability, and renewable energy techniques. If you are interested in learning about experimental techniques, appropriate data analysis, professional growth, and engineering ethics, enrol our mechanical engineering course soon! Special Offers of this Mechanical Engineering: Mechanical Engineering Course: This Mechanical Engineering: Mechanical Engineering Course includes a FREE PDF Certificate. Lifetime access to this Mechanical Engineering: Mechanical Engineering Course Instant access to this Mechanical Engineering: Mechanical Engineering Course 24/7 Support Available to this Mechanical Engineering: Mechanical Engineering Course Mechanical Engineering: Mechanical Engineering Elevate your career with our in-depth Mechanical Engineering Course! This program covers essential engineering mathematics, fundamental physics, and an introduction to core mechanical engineering concepts. You will delve into heat transport, thermodynamics, and materials science. Advanced topics include aerodynamics, fluid mechanics, kinematics, structural analysis, and machine design. Our curriculum also includes the mechanics of solids, dynamics, control systems, and engaging capstone design projects. Additionally, you'll learn about cutting-edge technology, sustainability, and renewable energy techniques. Develop practical skills with hands-on experimental methods, accurate data analysis, and a strong emphasis on professional growth and engineering ethics. Enroll today to become a proficient and innovative mechanical engineer! Who is this course for? Mechanical Engineering: Mechanical Engineering Anyone interested in mechanical engineering should pursue the mechanical engineering course. Requirements Mechanical Engineering: Mechanical Engineering To enrol in this Mechanical Engineering: Mechanical Engineering Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Mechanical Engineering: Mechanical Engineering Course Be energetic and self-motivated to complete our Mechanical Engineering: Mechanical Engineering Course Basic computer Skill is required to complete our Mechanical Engineering: Mechanical Engineering Course If you want to enrol in our Mechanical Engineering: Mechanical Engineering Course, you must be at least 15 years old. Career path Mechanical Engineering: Mechanical Engineering Successful completion of the mechanical engineering course can lead to a variety of rewarding career options in mechanical engineering-related industries.

Complete Mechanical Engineering - CPD Certified
Delivered Online On Demand2 hours 6 minutes
£12