Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is someone who works, or has ambition to work, in a leadership role in data center operations such as a data center facilities manager, data center operations manager, who has the responsibility to achieve and improve the high-availability and manageability of the data center operations. Overview After completion of the course the participant will be able to: Perform the needs analysis translating business requirements to data center services Set-up and manage the data center operations team Implement and monitor safety- and security practices Identify a suitable maintenance program for the data center facility and its equipment Select the appropriate policies and procedures required for data center operations Monitor the data center availability, capacity and capability Manage and implement basic data center projects Set-up and implement an environmental sustainability program Select an appropriate back-up site to support organizational resilience Identify and respond to risk in the data center Manage and support the document life cycle Create a basic budget proposal Select and manage vendors and measure their performance Manage data center assets Managing the facilities of today?s high-end and high-availability data centers is an extremely demanding and complex task which is often underestimated. There is often very little appreciation and understanding of the complexities of managing today's mission-critical data centers where downtime is not an option, especially since many of the data centers are operating at, or near, their design limits. Operations management at the facilities layer makes all the difference. Even a data center designed to the highest redundancy level as per the ANSI/TIA-942 standard could still experience many unscheduled downtime events due to poor planning, operations, maintenance and management processes. Service Level Management Service Level Management Needs analysis Capability assessment Service portfolio Service catalogue Service Level Agreements (SLAs) Availability measurement Data points in SLA Service reporting Complaint procedure Customer satisfaction measurement Service Improvement Process (SIP) SLA content The Data Center Organization Operational issues Organization chart Roles and responsibilities Skills matrix Contingency / backup roles Shift management Performance management Career development Training and assessment Job rotation Succession planning Disciplinary program Managing Safety & Statutory Requirements Safety policies and regulations Occupational Health and Safety (OH&S) Safety awareness training Permit to Work (PTW) Lock-out / Tag-out Personal Protective Equipment (PPE) Testing and tagging of equipment Emergency preparedness and response Reporting of safety issues Reviews / internal audit / external audit Managing Physical Security Security policies and procedures Security standards and guidelines Security staff Security awareness Security incident management Disciplinary program Reviews, internal and external audits Facilities Management Maintenance policies and procedures Various maintenance programs Outsourcing of maintenance activities Maintenance contract options Warranty Maintenance schedule Service situations Spart part management Contamination control Data Center Operations Policies and procedures for data center operations Service operations and the daily data center operations Monitoring / Reporting / Control Monitoring requirements Escalation procedures Reporting Trend analysis Reviews Project Management Project management Project organization Project manager Project phases Environment Sustainability The importance of sustainability Sustainability policies Environmental management Power efficiency indicators - Waste management - Water management ICT utilisation management Environmental performance measurements Renewable energy factor (REF) Organizational Resilience Business continuity Data center facility options Business Impact Analysis Type of facility Human resources Facility, equipment and consumables Governance, Risk and Compliance Management commitment Coordination, collaboration and integration Compliance Risk management Document management Financial management Vendor management Asset management Additional course details: Nexus Humans Certified Data Center Facilities Operations Manager (CDFOM) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Certified Data Center Facilities Operations Manager (CDFOM) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
The three-day IOSH Managing Safely course is the most popular training of its type in the world.
With ESI’s Professional Diploma, you will: Master the art of productivity by taking a results-focused approach to everything you do; Develop the mindset and attitude to succeed – all the time; Learn how to sell more and sell faster; Develop the core skills that underpin high-performance selling today.
Groundbreaking, globally recognized, certified and accredited course, that offers intensive and interactive executive level training to EAs around the world.
Overview The eight 1/2 day Support Manager course is uniquely created to provide training on the fundamentals of management relative to the support environment, and to enhance the inherent skills and knowledge of the support manager. This course focuses specifically on the most common management elements that occur in the technical support centre including, managing customer satisfaction, operations and team performance management and facilitating a team while managing a dynamic service product. This course offers support managers the opportunity to develop and refine their technology support leadership skills enabling them to effectively manage the challenges of the most complex support centres. Who Should Attend The Support Manager course is for managers who have at least six months management experience and have received some basic management training. Requirements The course begins with a review and quiz on a set of pre-class reading materials. These materials are sent to each participant two weeks prior to the class start date. Participants are strongly encouraged to register at least two weeks in advance to allow time to complete these pre-class assignments. Each participant is required to bring the pre-class reading materials as well as a notebook computer with a USB port and with Microsoft Excel, Word and PowerPoint installed. These will be used as tools during the course. All other materials and tools will be provided. Homework is assigned for most evenings of the course. Please plan for study time outside of class. Some of the training objectives… Manage dynamics of change within the support centre Enhance leadership skills Effective staff utilisation Increase support centre morale and retention
Data dashboards provide key information to stakeholders so that they can make informed decisions. While there are plenty of software solutions for building these essential data products, there is much less guidance on how to design dashboards to meet the diverse needs of users. This course is for anyone who is building or implementing dashboards, and wants to know more about design principles and best practice. You could be using business intelligence software (such as Power BI or Tableau), or implementing bespoke solutions. The course will give your team the ability to evaluate user needs and levels of understanding, make informed decisions about chart selections, and make effective use of interactivity dynamic data. We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: Data with a purpose Understanding the different types of dashboard. Information overload and other common dashboard pitfalls. Assessing user needs and levels of data fluency. Session 2: Planning a dashboard Assessing diverse user needs and levels of data fluency. Taking a User Experience (UX) approach to design and navigation. Applying an interative and collaborative approach to onboarding. Session 3: Graphs, charts and dials Understanding how graphical perception informs chart choices. Making intelligent design choices to help users explore. Design principles for layout and navigation. Session 4: Using interactivity Making effective use of filters to slice and dice data sets. Using layers of information to enable drilldown data exploration. Complenting dashboards with automated alerts and queries. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people. Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “Alan was great to work with, he took us through the concepts behind data visualisation which means our team is now equipped for the future. He has a wide range of experience across the topic that is delivered in a clear, concise and friendly manner. We look forward to working with Alan again in the future.” John Masterson | Chief Product Officer | ImproveWell
Are you looking to create the perfect business strategy to put you higher than your competitors? Are you tired of not hitting your strategic objectives? If your answers to above questions are 'yes', this course helps you a lot. What you will learn: To build your own ‘blue ocean strategy’ to avoid fierce competition & price wars. To understand strategy process and strategy mapping. To appropriately position your company in the marketplace. To make the competition irrelevant. How you will benefit from this workshop: You will gain key insights into the strategy articulation process. We help you develop your leadership skills with some practice. You will learn how to use the Balanced scorecard to map your strategy. You will learn how effective your current differentiation is and how to improve that.
Diploma in Education and Training (DET) qualification is a recognised teaching qualification leads to QTLS status. This is a PGCE equivalent qualification which is full 120 QCF Credit value. Formerly this course used to called Level 5 Diploma in Teaching in the Life Long Learning (DTLLS) course. This course is suitable for trainers, teachers, and tutors who intend to work or already working in further education, university, training centre, college, adult and community learning or work-based training within public, private, community organisations or voluntary sectors. ABOUT THIS QUALIFICATION: Level 5 Diploma in Education and Training DET/DTLLS Course is suitable for teachers, trainers and tutors who wish to work or already working in further education, Colleges, adult and community learning or work-based training within public, private, voluntary or community organisations. It prepares trainee teachers to teach in a wide range of contexts and requires observation and assessment of practice. All candidates, whether pre-service (Currently not working) or in-service (Currently working) must have access to the teaching (volunteer teaching, paid / unpaid teaching, part time / full time teaching). This qualification is suitable for those delivering education and training in any learning environment. COURSE OUTLINE: Chapter 1: Developing teaching, learning and assessment in Education and Training. Chapter 2: Teaching, learning and assessment in education and training. Chapter 3: Theories, Principles and models in education and Training. Chapter 4: Wider professional practice and development in Education and Training. Chapter 5: Action Research. Chapter 6: Developing, using and organising resources in a specialist area. Chapter 7: Managing behaviours in an earning environment. Chapter 8: Understanding inclusive practice. LEARNING OUTCOMES: • Teaching, learning and assessment in education and training • Theories, principles and models of education and training • Developing teaching learning and assessment in education and training • Wider professional practice and development in education and training WHO ARE THE QUALIFICATIONS FOR: For candidates who work or who want to work as teachers/trainers in the further education and skills sector. For candidates who have just started a teaching/training role. For teachers/trainers who are seeking career progression in their area of work. For candidates who work with learners on a one-to- one basis. For candidates who teach in industry. For candidates who have already achieved some Learning and Development units that can be carried forward into this qualification. For candidates who are assessors and wish to achieve a teaching/training qualification. For candidates with a CET who wish to top this up to a full level 5 teaching qualification applicable to the qualified teaching pay scales across FE institutes and apply for QTLS through the Society for Education and Training. STUDY METHOD: You can complete this course either through Distance Learning / Online or Classroom based. Level 5 DET distance learning course is done at your own pace with a Tutor’s support & guidance. All necessary materials will be sent to you by royal mail special delivery once you book the course. Once you book this course, you will be given up to 12 months to complete the assignments. COURSE ASSESSMENT: There is no formal examination is required, but at the end of the course you need to submit a portfolio assignment. WHY YOU CHOOSE US: • Qualified and long experienced trainers. • Recognised Training Provider. • Tutors support available. • 99% pass rate. • Very reasonable course fees. • No hidden cost/fees. • Quick result and certificates . • We have dedicated team to support you. • Career advise available if needed. HOW MUCH THIS COURSE COST? Level 5 DTLLS/DET course will cost for Online Distance Learning £1499.99, for Webinar Classroom based Course £1549.99. There is no any hidden fess/cost.
Level 5 Diploma in Education and Training is regulated by Ofqual and prepares trainee teachers to teach in a wide range of contexts, adult qualifications. Level 5: Diploma in Education and Training DET or DTLLS course is a QCF qualification which is full 120 QCF Credit value. Formerly this course used to called Level 5 Diploma in Teaching in the Life Long Learning (DTLLS) course. ABOUT THIS QUALIFICATION: Level 5 Diploma in Education and Training DET/DTLLS Course is suitable for teachers, trainers and tutors who wish to work or already working in further education, Colleges, adult and community learning or work-based training within public, private, voluntary or community organisations. It prepares trainee teachers to teach in a wide range of contexts and requires observation and assessment of practice. All candidates, whether pre-service (Currently not working) or in-service (Currently working) must have access to the teaching (volunteer teaching, paid / unpaid teaching, part time / full time teaching). This qualification is suitable for those delivering education and training in any learning environment. COURSE OUTLINE: Chapter 1: Developing teaching, learning and assessment in Education and Training. Chapter 2: Teaching, learning and assessment in education and training. Chapter 3: Theories, Principles and models in education and Training. Chapter 4: Wider professional practice and development in Education and Training. Chapter 5: Action Research. Chapter 6: Developing, using and organising resources in a specialist area. Chapter 7: Managing behaviours in an earning environment. Chapter 8: Understanding inclusive practice. LEARNING OUTCOMES: • Teaching, learning and assessment in education and training • Theories, principles and models of education and training • Developing teaching learning and assessment in education and training • Wider professional practice and development in education and training WHO ARE THE QUALIFICATIONS FOR: For candidates who work or who want to work as teachers/trainers in the further education and skills sector. For candidates who have just started a teaching/training role. For teachers/trainers who are seeking career progression in their area of work. For candidates who work with learners on a one-to- one basis. For candidates who teach in industry. For candidates who have already achieved some Learning and Development units that can be carried forward into this qualification. For candidates who are assessors and wish to achieve a teaching/training qualification. For candidates with a CET who wish to top this up to a full level 5 teaching qualification applicable to the qualified teaching pay scales across FE institutes and apply for QTLS through the Society for Education and Training. STUDY METHOD: You can complete this course either through Distance Learning / Online or Classroom based. Level 5 DET distance learning course is done at your own pace with a Tutor’s support & guidance. All necessary materials will be sent to you by royal mail special delivery once you book the course. Once you book this course, you will be given up to 12 months to complete the assignments. COURSE ASSESSMENT: There is no formal examination is required, but at the end of the course you need to submit a portfolio assignment. HOW MUCH THIS COURSE COST? Level 5 DTLLS/DET course will cost for Online Distance Learning £1499.99, for Webinar Classroom based Course £1549.99. There is no any hidden fess/cost.
Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.