215 Courses in Cardiff delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature

In the age of digitalisation, the art of storing goods efficiently is more crucial than ever. Dive deep into the world of 'Fundamentals of Warehousing and Storage: Optimising Inventory Control' to unlock the secrets of efficient storage and inventory control. Through this course, learners will embark on a transformative journey, uncovering the nuances of warehouse design, understanding the intricacies of processes, and staying ahead with the future trends in warehousing. Learning Outcomes Understand the core principles of warehousing and its significance. Gain insights into effective warehouse design and layout for maximum efficiency. Master the techniques of inventory control and management to reduce wastage. Learn about the essentials of warehouse safety, security, and risk management. Analyse and utilise key performance metrics for warehouse optimisation. Why buy this Fundamentals of Warehousing and Storage: Optimising Inventory Control? 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 Fundamentals of Warehousing and Storage: Optimising Inventory Control 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 Fundamentals of Warehousing and Storage: Optimising Inventory Control for? Individuals keen on pursuing a career in warehouse management and operations. Business owners aiming to improve their inventory control and storage solutions. Logistics professionals seeking to update their knowledge in warehousing. Students of business and supply chain management aiming for specialisation. Consultants and advisors focusing on industrial storage and distribution. Prerequisites This Fundamentals of Warehousing and Storage: Optimising Inventory Control does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Fundamentals of Warehousing and Storage: Optimising Inventory Control 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 Warehouse Manager - Average Salary: £32,000 - £45,000 Inventory Control Specialist - Average Salary: £25,000 - £37,000 Logistics Coordinator - Average Salary: £23,000 - £30,000 Supply Chain Analyst - Average Salary: £28,000 - £42,000 Warehouse Health & Safety Officer - Average Salary: £24,000 - £36,000 Warehouse Operations Analyst - Average Salary: £27,000 - £40,000. Course Curriculum Module 01: Fundamentals of Warehousing Fundamentals of Warehousing 00:14:00 Module 02: Warehouse Design and Layout Warehouse Design and Layout 00:13:00 Module 03: Warehouse Processes and Operations Warehouse Processes and Operations 00:14:00 Module 04: Inventory Control and Management Inventory Control and Management 00:09:00 Module 05: Warehouse Safety and Security Warehouse Safety and Security 00:16:00 Module 06: Warehouse Performance Metrics and Optimisation Warehouse Performance Metrics and Optimisation 00:14:00 Module 07: Emerging Trends and Future of Warehousing Emerging Trends and Future of Warehousing 00:18:00

Elevate your expertise in warehousing and storage with our comprehensive course for inventory managers. Explore fundamental principles, efficient warehouse design, streamlined operations, inventory control strategies, safety protocols, performance metrics, and emerging trends. Gain the knowledge to optimize your warehouse for success in the ever-evolving world of logistics and supply chain management.

The Professional Certificate in Business Intelligence and Data Warehousing aims to introduce the learner to the concepts of business intelligence gathering, interpreting and disseminating using the management of stored data available with the organization. Learning Outcomes After the successful completion of the certificate, the student will be able to: Outline the major characteristics of business intelligence Describe the components of business intelligence Describe the concept of data warehousing The Professional Certificate in Business Intelligence and Data Warehousing aims to introduce the learner to the concepts of business intelligence gathering, interpreting and disseminating using the management of stored data available with the organization. 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. Introduction to Business Intelligence and Data Warehousing Objectives of the lecture: Outline the major characteristics of business intelligence. Describe the components of business intelligence. Describe the concept of data warehousing. BUSINESS INTELLIGENCE AND DATA WAREHOUSING 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 knowledge of the learner in the field. This certificate is for very one eager to know more and gets updated on current ideas in the respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Data warehousing Manager Marketing Intelligent Manager Research Manager Average Completion Time 2 Weeks Accreditation 1 CPD Hour 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.

This module aims to develop knowledge and understanding of the role of logistics including an understanding of air, sea, road and rail freight and courier services. It will explore the advantages and disadvantages of using the different modes of transport the world of international trade.

This Warehousing, Manual Handling, Procurement, Supply Chain & Inventory Management course is designed for Warehouse Operatives, where you will explore the function of a warehouse, different types of warehouses and warehouse operations, and various storage systems like Palletised Storage systems, Warehouse Temperature-Controlled Storage, Automated Storage, and Retrieval Systems, and more. This 4-in-1 Specialisation Bundle Includes: Course 01: Warehouse Management Course 02: Manual Handling for Warehouse Management Course 03: Procurement & Supply Chain Course 04: Inventory Management Key Features CPD Certified Course Instant 4 FREE PDF Certificates Hardcopy Certificates are included Fully online, interactive course Developed by qualified professionals The training materials of this Warehousing, Manual Handling, Procurement, Supply Chain & Inventory Management course are available online for you to learn at your own pace and fast-track your career with ease. Course Curriculum Course 01: Warehouse Management Course 01: Warehouse Module 01: The Role of Warehouse Module 02: Introduction to Warehouse Safety Module 03: Health and Safety Management in Warehouses Module 04 General Warehouse Hazards Module 05: Manual and Mechanical Handling Module 06: Site Safety Course 02: Manual Handling for Warehouse Management Module 01 Manual Handling and Work-related Accidents Module 02: Identifying the Manual Handling Risks Module 03: Manual Handling Risk Assessments Module 04: Controlling and reducing the risks of manual handling Module 05: Manual handling techniques Course 03: Procurement & Supply Chain Module 01: Supply Chain Basics Module 02: Role of Procurement in an Organisation Module 03: The Purchasing Cycle Module 04: Purchasing Toolkits Module 05: Managing Competitive Bids Module 06: Quality Management Module 07: Supplier Relationship Management Module 08: Analysing and Reducing Risk in the Supply Chain Module 09: Improving Efficiency and Accuracy Module 10: Category Management Module 11: Inventory Management Module 12: E-procurement Course 04: Inventory Management Module 01 What Is Inventory? Module 02 Types Of Inventory Module 03 Key Players Module 04 Setting Up The Warehouse Module 05 Identifying Demand Module 06 Maintaining Inventory Accuracy Module 07 The Outbound Process Accreditation All of our courses, including this course, are fully CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This comprehensive course is ideal for anyone who genuinely wishes to learn about Warehouses and individuals associated with the sector and the following areas such as: Operative Assistant Administrator Supervisor Employee Maintenance Manager Maintenance Supervisor NB: This is not a regulated course. To get a professional qualification, you may choose: Level 2 Award in Warehousing Level 3 Award in Warehousing (VRQ) Level 2 Certificate in Warehousing and Storage Principles (RQF) Requirements No prior knowledge required for This course. Career path This course will open doors to many different career opportunities: Manager: £20,000 - £38,000 per annum Supervisor: £18,000 - £28,000 per annum Assistant: £20,000 - £22,000 per annum Administrator: £18,000 - £20,000 per annum Certificates Certificate of completion (Hardcopy) Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each. Certificate of completion (PDF) Digital certificate - Included

This course provides an introduction to the role of logistics within the supply chain The course explains the roles freight transportation and warehousing play in logistics and supply chain operations. The course takes you through the different modes of freight transport, the evolution of logistics, its effect on the environment, the technologies used and the different types of warehouse operation.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Program/Project Managers, Technology Consultants, and Users. In this course, students will gain SAP Netweaver Business Warehouse knowledge necessary for successful implementation and administration within a heterogeneous SAP NetWeaver BW system landscape. Data Warehousing Describing Data Warehouse Systems Describing Data Warehouse Architecture Using the Data Warehousing Workbench Master Data Modeling in SAP BW Describing InfoObjects Creating Characteristic InfoObjects The Loading of Master Data from SAP Data Sources Describing Data Flow Modeling a Master Data Flow Loading a Master Data Flow Modeling with the Graphical Data Flow Tool Loading of Transaction Data from SAP DataSources Describing the Core InfoProviders Creating a Key Figure InfoObject Creating a DataStore Object (DSO) Loading Transaction Data into a Data Store Object Describing the Extended Star Schema of an InfoCube Creating InfoCubes Loading Transaction Data into an InfoCube Master Data Loading from Flat File Data Sources Loading Data From a Flat File Describing the Data Flow in Detail Describing the Data Loading Process in Detail InfoProviders in SAP BW Explaining the InfoProviders Used in SAP BW ? Introduction Creating MultiProviders Usage of SAP BI Content Using BI Content Query Performance Optimization Optimizing Query Performance Monitoring Performance Creating and Filling Aggregates The SAP BW Administration Describing Administrative Tasks and Tools Administrating the InfoCubes Administrating the DataStore Objects Creating Process Chains

Advance your career with our comprehensive Warehouse Associate course. From mastering warehouse operations to understanding cutting-edge technology and automation, this course is your roadmap to success in the logistics and warehousing sector.

Duration 1 Days 6 CPD hours This course is intended for The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Overview Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization. 1 - Explore core data concepts Identify data formats Explore file storage Explore databases Explore transactional data processing Explore analytical data processing 2 - Explore data roles and services Explore job roles in the world of data Identify data services 3 - Explore fundamental relational data concepts Understand relational data Understand normalization Explore SQL Describe database objects 4 - Explore relational database services in Azure Describe Azure SQL services and capabilities Describe Azure services for open-source databases 5 - Explore Azure Storage for non-relational data Explore Azure blob storage Explore Azure DataLake Storage Gen2 Explore Azure Files Explore Azure Tables 6 - Explore fundamentals of Azure Cosmos DB Describe Azure Cosmos DB Identify Azure Cosmos DB APIs 7 - Explore fundamentals of large-scale data warehousing Describe data warehousing architecture Explore data ingestion pipelines Explore analytical data stores 8 - Explore fundamentals of real-time analytics Understand batch and stream processing Explore common elements of stream processing architecture Explore Azure Stream Analytics Explore Apache Spark on Microsoft Azure 9 - Explore fundamentals of data visualization Describe Power BI tools and workflow Describe core concepts of data modeling Describe considerations for data visualization