944 Data Analysis courses in Glasgow delivered On Demand

This beginner's level course on Pandas acquaints you to the data analysis fundamentals using Pandas library and working with Pandas primary data structures, Series and DataFrame. Learn all about data input using indexing and filtering, data preprocessing, and handle missing values and duplicate rows to transform your data more efficiently with the help of this hands-on course.

Unlock the power of data with our comprehensive course on Business and Data Analysis with SQL. Learn essential SQL skills to extract meaningful insights, make data-driven decisions, and drive business success. Whether you're a beginner or looking to enhance your expertise, our course empowers you with the tools and knowledge needed to excel in the dynamic world of data analysis. Enroll now to master SQL for business intelligence and elevate your analytical skills to new heights.

This video course gives you an insight into applied data science concepts using Python. With the help of interesting activities and hands-on coding exercises, you'll learn about data science, extended data analysis, linear and logistic regression, data visualization, k-means clustering, and decision trees.

Dive deep into the world of spreadsheet mastery with our 'Data Analysis, Automating and Visualisation in Excel' course. This comprehensive programme takes you on a transformative journey from the rudiments of worksheet modifications to the advanced arts of data forecasting. Within each module, you'll unveil the secrets behind efficient list management, compelling visualisations, and the magic of PivotTables, among many other features. Moreover, automation isn't left behind; it's the heart and soul, making your workbook a living entity that breathes efficiency. By the end, you'll not only be fluent in Excel's vast toolkit but also possess the flair to present data in engaging, insightful ways. Learning Outcomes: Master the art of efficient worksheet modification and effective list management. Harness the power of data analysis tools to make informed decisions. Craft compelling visuals using charts, Sparklines, and data mapping techniques. Implement PivotTables and PivotCharts to dissect complex data sets effortlessly. Automate workbook functionalities for optimised and streamlined processes.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/Data-Analysis-Automating-and-Visualisation-in-Excel.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why buy this Data Analysis, Automating and Visualisation in Excel? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis, Automating and Visualisation in Excel Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Analysis, Automating and Visualisation in Excel course for? Individuals looking to enhance their data visualisation and analysis prowess. Managers wanting a streamlined approach to handling large datasets. Academic researchers aiming to present their data in a more compelling format. Finance professionals seeking efficient ways to dissect and forecast financial data. Marketing strategists aiming to leverage data for improved decision-making. Career path Data Analyst: £30,000 - £50,000 per annum Financial Analyst: £35,000 - £55,000 per annum Market Research Analyst: £28,000 - £45,000 per annum Business Intelligence Analyst: £32,000 - £56,000 per annum Operations Analyst: £30,000 - £52,000 per annum Research Scientist (Data-oriented): £35,000 - £60,000 per annum Prerequisites This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis, Automating and Visualisation in Excel 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum 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 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:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07: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:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 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:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Assignment Assignment - Data Analysis, Automating and Visualisation in Excel 00:00:00

Business and Data Analysis with SQL is a comprehensive training in the theoretical and practical study of Data analysis and SQ language. This module is open to the people who want to elevate their business growth. Secure your position as an asset to the organization by learning SQL. Make your professional skill more productive by learning data analysis and SQL communication. The course exposes to you the details on computational and data investigational methods. It also highlights the basics of extracting data from the database storage. On completion of this online course, you will have an extensive understanding of how the database works and ways to function them properly, and thus be able to make critical decisions like a professional. What you'll learn At the end of this course, you will have the ability to run your own data projects, work with databases and manage large datasets and provide meaningful business intelligence reports to your team. Requirements Be familiar with reports and data-based projects. Who this course is for: This course is aimed at business professionals who work with data of all sizes. You will learn the fundamentals of business intelligence and basic data warehouse development. Introduction Business and Data Analysis with SQL FREE 00:06:00 Database and Datawarehouse Design Introduction to Databases- A History 00:04:00 SQL Statement Categories 00:02:00 Capture data requirements 00:09:00 Physical Vs Logical Data Representations 00:03:00 Normalise data 00:07:00 Fact Tables 00:04:00 Aggregate data 00:07:00 Entity Relationship Diagrams (ERD's) 00:07:00 Extract, Transform and Load (ETL) 00:13:00 Structured Query Language (SQL) - Fundamentals MySQL Server Setup 00:05:00 MySQL Server Start and stop Service 00:02:00 Connect to database 00:07:00 Comments in SQL 00:05:00 Select data from a table 00:16:00 Table Indexes 00:08:00 Table and Column Aliases 00:05:00 Inner Join Tables 00:02:00 Left and Right Outer Table Joins 00:04:00 Union (all) Results 00:04:00 Project Management Project Management (Agile Methodology) 00:11:00 Kanban boards 00:09:00 Prioritise Requirements using MoSCoW 00:04:00 Sales Project Sales Project - Introduction 00:05:00 Create and Drop Database 00:05:00 Query Workflow 00:09:00 Sales Project - Part 1 - Data Capture 00:15:00 Sales Project - Part 2 - Data Analysis 00:08:00 Sales Project - Part 3 - Data Summary 00:12:00 Sales Project - Part 4 - Send to production 00:09:00 MySQL Query Explain Plan 00:07:00 Common Table Expressions (WITH) 00:14:00 Data Control Language (DCL) User Administration 00:13:00 MySQL Programs MySQL Set Windows Environment Variable 00:05:00 MySQL Command Line 00:17:00 Visualising Data Export results to Excel 00:06:00 Setup MySQL ODBC (Open Database Connector) 00:11:00 Creating a report in Microsoft Excel 00:21:00 Course Certification

The Professional Certificate in Research Data Analysis Methods aims to provide extensive training on the nature, importance and expected results from qualitative and quantitative data analysis methods so that the learner can decide on the adoption of either or both methods after evaluation of the research objectives. Learning Outcomes After the successful completion of the certificate, the student will be able to learn: Data Analysis. Quantitative Data Analysis. Data Types of Quantitative Data Analysis. Designing Table and charts. Appreciating Data Analytics. Data-Analytic Methods. Analysing Quantitative Data. Qualitative Data analysis. Dimensions of Qualitative Analysis. Qualitative Data Analysis Methods. Analysing Qualitative Data. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Research Data Analysis Methods The course aims to provide extensive training on the nature, importance and expected results from both qualitative and quantitative data analysis methods. Research Data Analysis Methods Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Research student Business researcher Research supervisor Research Teacher Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Dive into the intricate world of data and uncover its mysteries with our 'Introduction to Data Analysis at QLS Level 3' course. As the adage goes, 'In God we trust, all others bring data'. This comprehensive course is tailored to make you fluent in the language of numbers and patterns. From understanding the voice of the process to exploring tools for data interpretation and mastering chart varieties like Pareto and Histogram, this curriculum is a bridge between raw data and actionable insights. Learning Outcomes Gain a foundational understanding of process management and its principles. Develop proficiency in using various analytical tools and charts. Understand and interpret data variations for actionable insights. Master techniques for presenting performance data efficiently. Learn strategies to address data variations and drive improvement. Why choose this Introduction to Data Analysis at QLS Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Introduction to Data Analysis at QLS Level 3 Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Introduction to Data Analysis at QLS Level 3 course for? Aspiring data analysts looking for a foundational course. Managers keen on using data to enhance business processes. Professionals aiming to integrate data-driven decision-making in their roles. Teams looking to streamline operations through data. Students considering a future in data analysis or related fields. Career path Data Analyst: £25,000 - £40,000 Business Intelligence Analyst: £30,000 - £50,000 Process Manager: £35,000 - £55,000 Performance Data Presenter: £28,000 - £45,000 Quality Control Specialist: £27,000 - £43,000 Operational Improvement Manager: £38,000 - £60,000 Prerequisites This Introduction to Data Analysis at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Introduction to Data Analysis at QLS Level 3 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Introduction to Data Analysis Module 01: Introduction 00:02:00 Module 02: Agenda and Principles of Process Management 00:06:00 Module 03: The Voice of the Process 00:05:00 Module 04: Working as One Team for Improvement 00:04:00 Module 05: Exercise: The Voice of the Customer 00:03:00 Module 06: Tools for Data Analysis 00:07:00 Module 07: The Pareto Chart 00:03:00 Module 08: The Histogram 00:03:00 Module 09: The Run Chart 00:04:00 Module 10: Exercise: Presenting Performance Data 00:05:00 Module 11: Understanding Variation 00:06:00 Module 12: The Control Chart 00:06:00 Module 13: Control Chart Example 00:04:00 Module 14: Control Chart Special Cases 00:06:00 Module 15: Interpreting the Control Chart 00:10:00 Module 16: Control Chart Exercise 00:07:00 Module 17: Strategies to Deal with Variation 00:06:00 Module 18: Using Data to Drive Improvement 00:14:00 Module 19: A Structure for Performance Measurement 00:06:00 Module 20: Data Analysis Exercise 00:06:00 Module 21: Course Project 00:03:00 Module 22: Test your Understanding 00:17:00 Additional Resources Resources - Introduction to Data Analysis 00:00:00 Mock Exam Mock Exam - Introduction to Data Analysis at QLS Level 3 00:20:00 Final Exam Final Exam - Introduction to Data Analysis at QLS Level 3 00:20:00 Assignment Assignment - Introduction to Data Analysis at QLS Level 3 00:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Feeling Stuck in Your Career? The Business Analysis, Business Finance with Data Analysis for Business & Data Analyst Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Business Analysis bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the Business Analysis, Business Finance with Data Analysis for Business & Data Analyst bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Business Analysis bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Business Analysis bundle on your job life and career growth! This Business Analysis, Business Finance with Data Analysis for Business & Data Analyst Bundle Comprises the Following CPD Accredited Courses: Course 01: Diploma in Business Analysis Course 02: Business Management Course 03: Business Intelligence Analyst Course Course 04: Financial Ratio Analysis for Business Decisions Course 05: Business Model Canvas for Business Plan Course 06: Financial Analysis Course 07: Data Analytics Course 08: Learn to Create Growth Projections for Your Business Course 09: PMI Agile Certified Practitioner (PMI-ACP) Exam Preparation Course Course 10: Business Law Course 11: Business Plan Course 12: Entrepreneurship Training Course 13: Investment Course 14: Business Performance Management Course 15: Developing Strategic Executive Management Course 16: GDPR Course 17: Compliance & Business Risk Management Course 18: Business Accounting Training Course 19: Cost Control & Project Scheduling Course 20: Dealing With Uncertainty: Make Budgets and Forecasts Course 21: Decision-Making and Critical Thinking Course 22: Effective Communication Skills Course 23: Career Development Plan Fundamentals Course 24: CV Writing and Job Searching Course 25: Learn to Level Up Your Leadership Course 26: Networking Skills for Personal Success Course 27: Ace Your Presentations: Public Speaking Masterclass Course 28: Learn to Make a Fresh Start in Your Life Course 29: Motivation - Motivating Yourself & Others Course 30: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! What will make you stand out? Upon completion of this online Business Analysis, Business Finance with Data Analysis for Business & Data Analystbundle, you will gain the following: CPD QS Accredited Proficiency with this Business Analysis bundle After successfully completing the Business Analysis bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Business Analysis bundle The online test with immediate results You can study and complete the Business Analysis bundle at your own pace. Study for the Business Analysis bundle using any internet-connected device, such as a computer, tablet, or mobile device. TheBusiness Analysis, Business Finance with Data Analysis for Business & Data Analyst bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Business Analysis bundle, a comprehensive complete collection of 30 courses. Each course in the Business Analysis bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Business Analysis bundle offers the flexibility and convenience to learn at your own pace. Make the Business Analysis package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Business Analysis, Business Finance with Data Analysis for Business & Data Analyst bundle is perfect for: Expand your knowledge and skillset for a fulfilling career with the Business Analysis bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Business Analysis bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Business Analysis bundle. Learn on your schedule, in the comfort of your home - the Business Analysis bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Business Analysis, Business Finance with Data Analysis for Business & Data Analystbundle. Certificates CPD Certificates Digital certificate - Included

Data Analysis In Excel for School Administrators is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Data Analysis In Excel for School Administrators and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 5 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. 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 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 PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 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 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:06:00

Level 5 QLS Diploma | Free QLS Endorsed Certificate | 11 FREE CPD Courses & PDF Certificates | Tutor Support