3360 Management courses in Bootle delivered Live Online

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Duration 4 Days 24 CPD hours This course is intended for The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications. This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Prerequisites In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses: AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Prepare to maintain SQL databases on Azure Describe Microsoft Intelligent Data Platform roles Understand SQL Server in an Azure virtual machine Design Azure SQL Database for cloud-native applications Explore Azure SQL Database Managed Instance 2 - Deploy IaaS solutions with Azure SQL Explain IaaS options to deploy SQL Server in Azure Understand hybrid scenarios Explore performance and security Explain high availability and disaster recovery options 3 - Deploy PaaS solutions with Azure SQL Explain PaaS options for deploying SQL Server in Azure Explore single SQL database Deploy SQL database elastic pool Understand SQL database hyperscale Examine SQL managed instance Describe SQL Edge 4 - Evaluate strategies for migrating to Azure SQL Understand compatibility level Understand Azure preview features Describe Azure database migration options 5 - Migrate SQL workloads to Azure SQL databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL Database offline Migrate SQL Server to Azure SQL Database online Load and move data to Azure SQL Database 6 - Migrate SQL workloads to Azure Managed Instances Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed Instance Load and Move data to SQL Database Managed Instance 7 - Configure database authentication and authorization Describe Active Directory and Azure Active Directory Describe authentication and identities Describe Security Principals Describe database and object permissions Identify authentication and authorization failures 8 - Protect data in-transit and at rest Explore Transparent Data Encryption Configure server and database firewall rules Explain object encryption and secure enclaves Enable encrypted connections Describe SQL injection Understand Azure Key Vault 9 - Implement compliance controls for sensitive data Explore data classification Explore server and database audit Implement Dynamic Data Masking Implement Row Level security Understand Microsoft Defender for SQL Explore Azure SQL Database Ledger Implement Azure Purview 10 - Describe performance monitoring Describe performance monitoring tools Describe critical performance metrics Establish baseline metrics Explore extended events Describe Azure SQL Insights Explore Query Performance Insight 11 - Configure SQL Server resources for optimal performance Explain how to optimize Azure storage for SQL Server virtual machines Describe virtual machine resizing Optimize database storage Control SQL Server resources 12 - Configure databases for optimal performance Explore database maintenance checks Describe database scoped configuration options Describe automatic tuning Describe intelligent query processing 13 - Explore query performance optimization Understand query plans Explain estimated and actual query plans Describe dynamic management views and functions Explore Query Store Identify problematic query plans Describe blocking and locking 14 - Evaluate performance improvements Describe wait statistics Tune and maintain indexes Understand query hints 15 - Explore performance-based design Describe normalization Choose appropriate data types Design indexes 16 - Automate deployment of database resources Describe deployment models in Azure Automate deployment by using Azure Resource Manager templates and Bicep Automate deployment by using PowerShell Automate deployment by using Azure CLI 17 - Create and manage SQL Agent jobs Create a SQL Server maintenance plan Describe task status notifications 18 - Manage Azure PaaS tasks using automation Explore Elastic jobs Understand Azure Automation Build an automation runbook Automate database workflows by using Logic Apps Monitor automated tasks 19 - Describe high availability and disaster recovery strategies Describe recovery time objective and recovery point objective Explore high availability and disaster recovery options Describe Azure high availability and disaster recovery features for Azure Virtual Machines Describe high availability and disaster recovery options for PaaS deployments Explore an IaaS high availability and disaster recovery solution Describe hybrid solutions 20 - Explore IaaS and PaaS solutions for high availability and disaster recovery Describe failover clusters in Windows Server Configure Always-on availability groups Describe temporal tables in Azure SQL Database Describe active geo-replication for Azure SQL Database Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance 21 - Back up and restore databases Back up and restore SQL Server running on Azure virtual machines Back up a SQL Server virtual machine Back up and restore a database using Azure SQL Database Additional course details: Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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 DP-300T00: Administering Microsoft Azure SQL Solutions 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.

Today, every individual and organisation is a publisher. You want everyone in your organisation to be a potential ambassador. And every employee has something to gain from raising their profile and showcasing their expertise. An effective content strategy allows you to deliver compelling stories to your audience in the most seamless way possible to make an emotional connection. This requires a mix of passion for the subject matter, a deep relationship with your audience, robust production processes, and the right tools.  With a background in journalism and technology, we’ve worked on many projects that combine the two – including overseeing the iPad edition launches for Condé Nast in the UK, product ownership of a Digital Asset Manager for Condé Nast International, and developing and delivering content training for telco VEON.  Publishers and brands we’ve worked with include WIRED, Time Out, GQ, Vanity Fair and Vogue – as well as solo entrepreneurs and startups who are trying to cut through the noise and get their message heard.  In this course we'll cover the key elements of an effective content strategy: how to plan across multiple platforms, and how to implement your blueprint without exhausting yourself or your team. Sample learning content  Session 1: Planning a content strategy Mapping and understanding your audiences. Defining your content objectives, for you or your organisation. Common pitfalls with poorly targeted content. Session 2: A content creation framework Finding ideas to generate a consistent stream of content. Idenitfying angles that will help you stand out from the crowd. Using different formats across multiple channels. Session 3: Keeping it going Simple processes to help hit deadlines and publish regularly. Balancing content creation and content creation. Creating a mix of evergreen and timely content. Session 4: Measurement and iteration Useful (and useless) metrics for content producers. Handling comments and joining the conversation. Iterating your content strategy based on feedback. 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 “The EMpower Network commissioned the content creation workshop to understand how to communicate effectively with a wide range of stakeholders. In light of covid-19, it’s more important than ever to communicate clearly especially as we’ve moved to remote meetings. The workshop was very insightful and Alan was a very engaging speaker making sure all attendees contributed and worked through real-life examples. Attendees praised the usefulness of the workshop and especially liked the content generation framework with one saying 'It has changed the way I think about communicating and given me a toolkit that I will use in both my work and personal projects'.” Shade Nathaniel-Ayodele | EMpower Network, Southwark Council 

The COLP role goes beyond just ensuring your firm follows the rules in the SRA Standards and Regulations, it also comes with a personal accountability factor that demands your attention. Fear not! This 3 hour course will usher you through the intricacies of being a COLP, ensuring you not only meet but excel in your regulatory obligations.  The course will cover: Navigating the Regulatory Landscape: Understanding the Framework for COLPs Dive into the intricate regulatory framework that Compliance Officers for Legal Practice (COLPs) operate under. Shouldering the Responsibility: Unpacking the Duties of a COLP Explore the multifaceted responsibilities that come with the role of a COLP. Choosing the Right Leader: Identifying the Ideal COLP Candidate Learn the criteria for selecting the most suitable individual to take on the crucial role of COLP. Cracking the Codes: Key Elements of Codes and SRA Principles Delve into the essential components of the Codes and SRA Principles that form the backbone of legal compliance. Building a Robust Foundation: Understanding Compliance Systems for All Firms Explore the concept of compliance systems, what they entail, and why every firm should have one in place. Reporting Matters: Recognising 'Serious' Issues, SRA Enforcement Strategy, and Reporting Protocols Uncover the definition of 'serious' matters, grasp the SRA Enforcement Strategy, and gain practical insights on making effective reports to the SRA. Paper Trails Matter: Effective Record Keeping, Including Non-material Breaches Master the art of comprehensive record-keeping, including strategies for recording non-material breaches, and understand why it's integral to compliance. Personal Liability: Understanding and Mitigating Risks Navigate the landscape of personal liability for COLPs and develop strategies to mitigate associated risks. Staying Ahead: Keeping Abreast of Regulatory Changes and Guidance Develop effective strategies for staying up to date with dynamic regulatory changes and evolving guidance. Planning for Compliance: Crafting a Robust Strategy, Assessing Risk, and File Reviewing Formulate a comprehensive plan for tackling compliance, including risk assessment, maintaining risk registers, and implementing effective file reviewing. Across the Board: Legal and Regulatory Compliance Areas Every COLP Must Master Gain a high-level overview of crucial legal and regulatory compliance areas, including AML, transparency rules, and other pivotal aspects that demand the attention of all COLPs. Target Audience This online course is suitable for those new to the COLP role, or those supporting the COLP and for those that would like a refresher of the role and their responsibilities. Resources Comprehensive and up to date course notes will be provided to all delegates which may be useful for ongoing reference or cascade training. Please note a recording of the course will not be made available. Speaker Helen Torresi, Consultant, DG Legal Helen is a qualified solicitor with a diverse professional background spanning leadership roles in both the legal and tech/corporate sectors. Throughout her career, she has held key positions such as COLP, HOLP, MLCO, MLRO and DPO for law firms and various regulated businesses and services. Helen’s specialised areas encompass AML, complaint and firm negligence handling, DPA compliance, file review and auditing, law management, and operational effectiveness in law firms, particularly in conveyancing (CQS).

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on managing expectations successfully.

Understand the management of commonly presenting medical conditions and the significance of recording accurate diagnostic investigations.

Overview There are many companies that have designed a creative environment for their employees to help them relax and spark creative thinking to enhance the performance of the people working in the organisation. The creative way help boost the mind of the employees and thereby generate a positive attitude. This course will help organizations to do regular brainstorming sessions when working on a project to allow employees to contribute and build on a project. This will create an immense engagement as their team members are involved in the creative process.

Overview This course is for PR Professionals and for those looking to make a career in PR. Through this course, you will be able to enhance your Communication skills and will learn new Public Relations techniques. Have Effective communication skills is very important if you want to achieve success in PR. PR is all about making relationships within the corporate sector or with the consumers and maintaining them with effective communication skills and techniques. 

Coping mechanisms for dealing with narcissistic trauma NLP and CBT Therapy Free daily calls with your coach/therapist 15mins Relationship analysis Improve boundaries and emotional management Detachment training Trauma coping mechanisms Weekly homework Self esteem building Introspection Eliminate cognitive distortions Weekly 1 hour sessions x6 https://relationshipsmdd.com/product/narcissist-recovery-package/

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on generating long-standing customer loyalty.