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

1478 Insights courses in Leicester delivered Live Online

Navigating The Modern Workforce - Diversity, Culture, Generations

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Team leaders, managers, executives and other business professionals who lead others will benefit from this course. Overview Learn to lead in a world of diversity Engage and empower our multi-generational workforce Leverage culture as the new strategic differentiator Develop your path to leadership success In this course, students will learn how to capitalize on the strengths of your diverse team while directing and guiding them to even greater achievements. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. A Complex World of Diversity Working in Fluid Dynamic Environments Understanding the New Transient Workforce Addressing the Need for a New Type of Leadership Leading with Authenticity Developing Required Skills and Competencies Decentralizing Power 2. Making Difference Your Strategic Advantage Engaging in the 21st Century Measuring Engagement and Taking Advantage of High Engagement Overcoming Challenges to Employee Engagement Embracing Difference and Bridging Boundaries Developing Cultural Intelligence and Responding Effectively to Cultural Differences Applying SCARF to Direct Behavior 3. Leveraging Change as the New Normal Understanding and Applying Emotional Intelligence Motivating Others Key Areas of Interest - Behavioral and Cognitive, Psychodynamic and Humanistic, and Personality Types Developing Your Leadership Psychological Toolkit Identifying Drivers - Desires and Expectations The Impact of an Environment of Trust Meeting the Needs of the Social Brain Promoting Involvement 4. Creating Leaders for the Future Facing the Challenges of a Modern Leader Avoiding Cultural Pitfalls Creating a Common Culture for All Leading Fluid Teams Seeking Diverse Perspectives Soliciting Feedback Utilizing Various Leadership Styles - Storytelling, Adaptive, and Connective Building a Sustainable Vision, Developing a Path, and Creating a Passion for Excellence Additional course details: Nexus Humans Navigating The Modern Workforce - Diversity, Culture, Generations 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 Navigating The Modern Workforce - Diversity, Culture, Generations 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.

Navigating The Modern Workforce - Diversity, Culture, Generations
Delivered OnlineFlexible Dates
£1,500

Communicating Across Your Organization

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Managers, directors, and other professionals responsible for planning and leading projects and programs will benefit from this course. Overview Describe common communication barriers Understand how to use effective interpersonal skills in their spoken and written communications Analyze the pillars of organizational awareness Apply principles of effective facilitation Understand how to adapt their approach to different learning and communication styles Effective communication is how employees and management interact to reach organizational goals. Getting this right results in a happier, more engaged workforce who get more done. Unfortunately, there are often significant barriers ? language, culture, distrust, distance ? to effective communication. The activities and discussions in this workshop will help you identify the essential elements of effective communications within your organization and develop communication strategies that harness both interpersonal and organizational awareness to build trust, strengthen collaboration, and increase productivity. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. A History of Organizational Communication A Historical Perspective Classic vs. Human Relations Communications Generational and Technological Change Digital Communication Effectiveness of Communication Channels 2. The Effectiveness of Interpersonal Skills Limitations of Self-Awareness Transactional Analysis Connecting with Powerful Communication Active Listening Non-Verbal Communication Written Communication The Power of Facilitation 3. The Pillars of Organizational Awareness Culture and Behavior Creating Psychological Safety Inclusion and Belonging Sweaty-Palmed Conversations Care and Challenge Each Other 4. The Adaptation of Communication Strategies Factors in Communication Communication Barriers Adapting to Different Learning and Communication Styles Communication Strategies Across Time Position and Posture Additional course details: Nexus Humans Communicating Across Your Organization (Second Edition) 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 Communicating Across Your Organization (Second Edition) 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.

Communicating Across Your Organization
Delivered OnlineFlexible Dates
£1,500

Writing for the Business Professional

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Professionals desiring to be able to communicate clearly and concisely in their writing will benefit from this course. Overview Awareness of common spelling and grammar issues in business writing. Basic concepts in sentence and paragraph construction. Basic structure of agendas, email messages, business letters, business proposals, and business reports. Collaborative writing techniques, tools and best practices Tips and techniques to use when deciding the most appropriate format to use for agendas, email messages, business letters, business proposals, and business reports In this course, you will learn the essential skills needed to organize your thoughts and select the best words and phrases to clearly convey them in writing. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Working With Words Monitoring Spelling, Grammar, and Verb Tense Creating a Reference Sheet 2. Constructing Sentences Recognizing Sentence Parts Classifying Sentence Type Increasing Readability with Punctuation 3. Creating Paragraphs The Three Basic Components Organization Methods 4. Finding Facts Identifying and Using Key Resources Fact-Finding and Information Gathering 5. Collaborative Writing Clarifying the Objective Collaborative Writing Strategies and Patterns 6. Types of Collaborative Business Writing Applying Different Construction Techniques Cut & Paste, Puzzle, Sequential Summative Integrating Construction 7. Collaborative Tools and Processes Planning and Revision Creating Outlines and Storyboards Building Team Cohesion 8. Writing Meeting Agendas Choosing an Agenda Format Structuring and Writing the Agenda 9. Writing E-Mails, Reports and Proposals Addressing Your Message Using Proper Grammar and Defining Acronyms Structuring, Formatting, and Writing Your Report Additional course details: Nexus Humans Writing for the Business Professional 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 Writing for the Business Professional 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.

Writing for the Business Professional
Delivered OnlineFlexible Dates
£1,500

Certified Data Centre Expert (CDCE)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional, who are involved in the design/build, renovation or relocation of a mission-critical data centre. Overview This 5-day course is designed to prepare participants to analyse a given business case and perform technical evaluation for a project plan and a set of designs for the implementation of a mission critical data centre. The course also engages participants in product evaluations and demonstrates how to select equipment and develop equipment test scripts (IET) and integrated performance and validation testing (IPVT). CDCE© builds upon knowledge gained in CDCP and CDCS courses. Participants who pass the exam will join the industry's elite data centre project design experts. CDCE© is the highest level training in the EPI Design and Build training track under the EPI Data Centre Training Framework. Participants must hold a valid CDCS certificate in order to be able to register for the CDCE class. CDCE© is the premier certification for data centre professionals in the data centre design/build and related fields. Data Centre Life Cycle Data centre lifecycle stages and phases Exercise: Stage/Phase/Milestone/Document mapping Design Preparation Creation of a SON ? Statement Of Need Technology review Conceptual sizing How to calculate for computer room space How to calculate facility space How to calculate incoming power Exercise: Conceptual sizing building and power Analysing capacity of existing facility Analysing investment options Site selection Permits and approvals Exercise: Site selection Conceptual design Budget and project timeline Business case preparation Project delivery structure Project management options Project manager and team Design Planning OSRA?Operational Systems Requirement Analysis TFRA?Technical Facilities Requirement Analysis Operations and maintenance review RFP?Request For Proposal process Vendor selection Design Development Project planning Design development PDR ? Preliminary Design Review Equipment selection FDR/V ? Final Design Review/Validation Exercise: Full design validation of power, cooling, floor plans, fire suppression Design freeze and LLTI Creation of construction documents BOM/BOQ ? Bill Of Material/Bill Of Quantity Exercise: Equipment selection Acquire Requirements of purchase orders Shipping terms FWT/FAT ? Factory Witness Test/Factory Acceptance Test Sequencing Incoming goods inspection and handling Asset management Construct Temporary essential services Erection of the building Permanent essential services Building inspection Snag list COF?Certificate Of Fitness Fit-Out Fit-Out Builders cleaning As-Built Drawings Test & Commissioning IET?Individual Equipment Test IPVT/IST?Integrated Performance Verification Test/Integrated Systems Test Common mistakes with IET/IPVT Deep cleaning Exercise: IET/IPVT scripting Hand-Over Facility hand-over requirements and documents PCC?Practical Completion Certificate DLP?Defect Liability Period Defect Management ICT Systems Installation ICT Systems Testing Hand-Over/DLP Expiry FCC?Final Completion Certificate Retirement Reasons and definitions of retirement Building the business case and project plan Sequencing Transfer of site Demolishing of site Legal matters FCC?Final Completion Certificate Exam: Certified Data Centre Expert (CDCE©) The CDCE© exam is in two parts: Part A is a 90-minute closed book exam, with 60 multiple-choice questions. For Part A, the candidate requires a minimum of 45 correct answers to pass the exam. Part B is a 90-minute closed book exam, with 25 open questions. For Part B the candidate needs to obtain a minimum of 75% to pass. Additional course details: Nexus Humans Certified Data Centre Expert (CDCE) 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 Centre Expert (CDCE) 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.

Certified Data Centre Expert (CDCE)
Delivered OnlineFlexible Dates
£3,500

Unlocking Our-Selves: The Seekers with Bárbara Godoy

By Therapy Harley Street

Experiential Group Process. A playground for therapists to nurture the imagination, release inhibitions and mobilise therapeutic insights. Unlocking Our-Selves: The Seekers Experiential Group and Process Work with Bárbara Godoy A playground for therapists to nurture the imagination, release inhibitions and mobilise therapeutic insights “Supportive, thought-provoking, emancipating, grounding” Inspired by the most prominent world seekers from antiquity to date. This year’s programme will take us on a profound personal journey of enquiry by cultivating presence and activating aliveness in the group environment OPTION 1: Tuesday Evenings Group 6 pm to 7.15 pm Term 3: Eastern Mystics 17and 24 September 1, 8, 15, 22 and 29 October 5, 12, and 19 November OPTION 2:  Friday Lunchtime Group 12.30 pm to 1.45 pm Latin American Writers 20 and 27 September 4, 11, 18 and 25 October 1, 8, 15 and 22 November Venue: Online – Zoom - Fee: £300 (term) Bárbara Godoy M.A., Adv. Dip. Exi. Psy. Existential Psychotherapist Group Leader, Counsellour, Lecturer and Supervisor, MBACP & UKCP accredited, SEA Professional Member, Director of Therapy Harley StreetBárbara’s academic contributions in London since 2008 include lecturing and researching on the theory and practice of Phenomenological Existential Therapy on Doctorate, MA and professional courses at the School of Psychotherapy and Counselling Psychology, Regent’s University and the New School of Psychotherapy and Counselling directed by Emmy van Deurzen. Bárbara has facilitated and designed therapeutic Group Work since 1997. She brought her earliest workshop: “Experiences” to large groups in The Netherlands, Italy, France, UK and Argentina. These awareness-intensive processes are a legacy of the human potential movement (HPM) of the 1960s, with techniques such as AUM Meditation Marathons, Psychodrama, Bioenergetics and Primal Feelings work.

Unlocking Our-Selves: The Seekers with Bárbara Godoy
Delivered OnlineFlexible Dates
£300

The Art of Effective Presentations

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Anyone desiring to improve their ability to speak self-assuredly, in front of both internal and external groups will benefit from this course. Overview Understand what separates an effective presentation from an ineffective presentation. Design a proficient presentation geared toward their audience. Create powerful slides that enhance the address. Enhance their public speaking skills with tips and techniques used by professional speakers. Prepare mentally for their best performance. Engage their audience more effectively and with greater passion. Whether speaking publicly or to a specific audience, your ability to build, develop and deliver a purposeful presentation is key to being able to convey your message and achieve your desired results. From open to close, it is crucial to learn the tools necessary to maintain engagement and to organize ideas to create coherent and convincing oral presentations. In this course, you will learn strategies to structure and develop presentation content focused on audience need and key points, identifying the areas in which you are most polished, as well as picking up hints and tips to address any gaps. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Foundation, Structure, and Organization Why a presentation The difference between effective and ineffective presentations Delivering passion and value Structure determines success 2. Creating the Basic Structure Building the backbone Capturing audience attention Understanding your audience 3. Organizing Your Program Planning analog Creating the topic outline Fact-Finding 4. Designing and Building Your Presentation Choosing proper content Building and writing Your presentation Slide design 5. Delivering Your Presentation Preparing mentally Appearing confident in front of the crowd 6. Engaging Your Audience from Start to Finish Understanding and matching learning styles Closing Your presentation and providing calls to action Additional course details: Nexus Humans The Art of Effective Presentations (Second Edition) 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 The Art of Effective Presentations (Second Edition) 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 Art of Effective Presentations
Delivered OnlineFlexible Dates
£1,495

Tableau Training On Tap - Fast Track

By Tableau Training Uk

Tableau is an intuitive and simple tool to learn. This Tableau training course is a jumpstart to getting report writers and analysts who are self-taught or have no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in three days. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment. At the end of this course, you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. Our Tableau Desktop Fast Track course combines all of our Foundation (Fundamentals) and Analyst (Intermediate) content into a 3 day live online course with added access to online bonus content of 3 additional modules. Gathering Requirements, Bring Your Own Data and Engaging Users. What do you get? This course is delivered live virtually and has all material provided through our online portal, together with email support and live coaching sessions. The full program includes all of the following elements: 3 days of live and interactive instructor-led sessions delivered by an expert Tableau Trainer 6 weeks access to our live coaching program delivered by expert Tableau coaches 50+ practical exercises to practice what you learn 12 months access to video’s that walk you through the theory and exercise solutions Practical advice, tools and resources for using Tableau in the real world The three additional online modules provide:Clarity on the approach to gathering dashboard requirements in a way that can be translated into dashboard designs.An agile and iterative development process that delivers products that meet user needs more quickly and effectively.An understanding of how end users will interact with dashboards to ensure that designers deliver actionable results. THE SYLLABUS PHASE 1: DESIGN MODULE 1: UNDERSTAND TABLEAU What is possible How does Tableau deal with data Know your way around Review of Type Conversions How do we format charts Dashboard basics – My first Dashboard MODULE 2: TRANSFORM DATA Connecting to and setting up data in Tableau Modifying data attributes How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates How do I create calculated fields and why? – Creating Calculated Fields, Types of calculated fields, Row Level v Aggregations, Aggregating dimensions in calculations, Changing the Level of Detail (LOD) of calculations – What, Why, How MODULE 3: GATHER REQUIREMENTS(ONLINE CONTENT ONLY) Brainstorm and assess possible priorities Pitfalls to avoid Gather requirements PHASE 2: DEVELOP MODULE 4: CREATE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing progress over time Creating Tables – Creating Tables, Highlight Tables, Heat Maps Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps Making things dynamic with parameters MODULE 5: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 6: ANALYSE INFORMATION Table Calculations Sets, Reference Lines, Trends and Forecasting Answering spatial questions – Mapping, Creating a choropleth (filled) map, Using your own images for spatial analysis, Mapping with spatial files Advanced charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Viz in Tooltips PHASE 3: DESIGN MODULE 7: BUILD DASHBOARDS Using the Dashboard Interface Device layouts Dashboard Actions – Set actions, Parameter actions Viz in Tooltips for Dashboards Dashboard containers – Horizontal & Vertical containers, Hidden containers Navigate between dashboards Telling data driven stories MODULE 8: BRING YOUR OWN DATA Design Best Practices & Resources Wireframe templates Questions Process Start building and testing MODULE 9: EMPOWER STAKEHOLDERS What is Tableau Server Publishing & permissions How can your users engage with content The Tableau ecosystem Review your progress Your next steps HOW MUCH OF YOUR TIME WILL THIS TAKE? Delegates are also provided 6 weeks access to our Tableau Coaching. We run Live Q&A sessions from 4pm-5pm on a Monday (Connecting to Data and Calculated Fields), 2pm-3pm Friday (Creating Charts) & 4pm-5pm Friday (Dashboard Design). The coaching helps delegates to transition from the theory of using Tableau to its practical use. We’d be expecting them to apply the exercises you’ll be doing during the course, onto your own data after the course. In our experience, this is the best way to increase both understanding and long term memory retention. The live coaching also acts as a troubleshooting platform for any practical issues that delegates need to overcome in the real world. Delegates also have 12 months access to all of the training material covered in the course in the form of an online portal (this includes theory videos, exercise solution videos, exercise materials and even quizzes). We have a growing LinkedIn community that delegates are encouraged to join and participate in. We regularly post useful blog posts and additional training that will enhance the Tableau journey and understanding. We help teams using Tableau to transform in the following ways : From a disjointed understanding of Tableau – To being familiar with Tableau terminology and capability From ad-hoc data uploads and error prone calculations – To reusable data connections and robust metrics From disjointed stakeholder questions – To clear and concise requirements that lead to decision making From being unsure how difficult Tableau will be to learn – To being able to develop standard charts and tables in Tableau with dynamic reporting capabilities From manually combining data for each analytical task – To dynamically combining data from multiple tables for analysis From being unsure how to answer analytical questions and what options there are – To being equipped with multiple actionable, dynamic, analytical use cases From not knowing Why, When and How to create Dashboards or Story’s – To being able to combine analysis to answer complex questions and tell data driven stories From using demo data theory – To Delivering value [Answering questions] on their own data From spending lots of time answering colleagues ad-hoc (data) questions – To empowering stakeholders in answering ad-hoc queries and reducing the time to analyse and steer the business

Tableau Training On Tap - Fast Track
Delivered OnlineFlexible Dates
£1,200

Recovering Troubled Projects: In-House Training

By IIL Europe Ltd

Recovering Troubled Projects: In-House Training Despite our best intentions, many of the projects that organizations undertake either don't achieve their intended business results or end in complete failure. Most seasoned project managers have had their share of experiences with difficult or troubled projects and unless they are careful, they will encounter more. This workshop does not focus on 'failed' projects but rather on those projects which without appropriate intervention would be headed for failure. Failed projects are those beyond help and which should be terminated. Here we focus on projects that are salvageable. It is an exercise-driven, no-nonsense, professional practice-focused workshop positioning the participant to immediately apply the tools and lessons learned in the classroom. The workshop employs the use of both illustrative and practical/working case studies. Illustrative case studies will examine insights from real-world troubled projects. Participants will be asked to bring descriptions of their own examples of troubled projects on which they're currently working or on which they have worked in the past. A number of these will be used as the basis for the practical/working case studies. The approach builds on and complements the disciplines addressed in Project Management Institute's PMBOK® Guide and also addresses issues that arise when managing projects in a complex environment. What You Will Learn You will learn to: Recognize the value of a structured project recovery process Explain the reasons most projects fail Analyze the causes of a project's troubles Construct a negotiation process to use with key stakeholders Apply an effective strategy to planning the recovery effort Manage, evaluate, and adjust the ongoing recovery effort Foundation Concepts Recognizing a troubled project Defining the project recovery process The Reasons Projects Fail Putting failure in perspective Reviewing management issues Analyzing planning issues Exploring complexity issues Assess the Project Stabilizing the project Determining preliminary Go / No-Go Conducting a detailed recovery assessment Negotiate the Recovery Reviewing the basics of negotiation Setting reasonable expectations Obtaining appropriate PM authority Securing key stakeholder support Plan the Recovery Planning for recoveries Rebuilding the project team Reshaping the project plan Managing parallel activities Planning for change management Implement and Adjust the Project Implementing project recoveries Facilitating change Enabling continuous learning Fostering the project team Sustaining stakeholder engagement

Recovering Troubled Projects: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,495

55321 SQL Server Integration Services

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Overview Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. Prerequisites Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design. 1 - SSIS Overview Import/Export Wizard Exporting Data with the Wizard Common Import Concerns Quality Checking Imported/Exported Data 2 - Working with Solutions and Projects Working with SQL Server Data Tools Understanding Solutions and Projects Working with the Visual Studio Interface 3 - Basic Control Flow Working with Tasks Understanding Precedence Constraints Annotating Packages Grouping Tasks Package and Task Properties Connection Managers Favorite Tasks 4 - Common Tasks Analysis Services Processing Data Profiling Task Execute Package Task Execute Process Task Expression Task File System Task FTP Task Hadoop Task Script Task Introduction Send Mail Task Web Service Task XML Task 5 - Data Flow Sources and Destinations The Data Flow Task The Data Flow SSIS Toolbox Working with Data Sources SSIS Data Sources Working with Data Destinations SSIS Data Destinations 6 - Data Flow Transformations Transformations Configuring Transformations 7 - Making Packages Dynamic Features for Making Packages Dynamic Package Parameters Project Parameters Variables SQL Parameters Expressions in Tasks Expressions in Connection Managers After Deployment How It All Fits Together 8 - Containers Sequence Containers For Loop Containers Foreach Loop Containers 9 - Troubleshooting and Package Reliability Understanding MaximumErrorCount Breakpoints Redirecting Error Rows Logging Event Handlers Using Checkpoints Transactions 10 - Deploying to the SSIS Catalog The SSIS Catalog Deploying Projects Working with Environments Executing Packages in SSMS Executing Packages from the Command Line Deployment Model Differences 11 - Installing and Administering SSIS Installing SSIS Upgrading SSIS Managing the SSIS Catalog Viewing Built-in SSIS Reports Managing SSIS Logging and Operation Histories Automating Package Execution 12 - Securing the SSIS Catalog Principals Securables Grantable Permissions Granting Permissions Configuring Proxy Accounts Additional course details: Nexus Humans 55321 SQL Server Integration Services 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 55321 SQL Server Integration Services 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.

55321 SQL Server Integration Services
Delivered OnlineFlexible Dates
£2,975

Introduction to Project Management (Virtual)

By IIL Europe Ltd

Introduction to Project Management (Virtual) This course provides practical insights into what is project management and how it is performed in a structured manner.You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially

Introduction to Project Management (Virtual)
Delivered OnlineFlexible Dates
£450