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

4574 Security courses in Middlesbrough delivered Online

Librarian and Library Assistant Diploma

4.9(27)

By Apex Learning

Boost Your Career with Apex Learning and Get Noticed By Recruiters in the Hiring Race! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol in the Librarian and Library Assistant Diploma Now!

Librarian and Library Assistant Diploma
Delivered Online On Demand24 hours
£49

Building Microservices API in Go

By Packt

Master Go programming with an in-depth course covering advanced topics such as authentication, authorization, JWT tokens, and refresh tokens. Learn how to write reliable code with effective unit testing techniques, while exploring concepts such as logging, error handling, and modularization. Build secure and scalable web applications with Go to take your coding expertise to the next level.

Building Microservices API in Go
Delivered Online On Demand6 hours 44 minutes
£82.99

Legionnaires' Disease Awareness

By OnlineCoursesLearning.com

Legionnaires' Disease Awareness Certification More than 300 instances of Legionnaires' illness are accounted for consistently in England and Wales. Most of these cases happen in the work environment. It is a genuine sickness that demonstrates deadly in up to 12% of cases. Legionnaires' illness is brought about by Legionella microscopic organisms, which may fill in water frameworks. Luckily, it is moderately easy to distinguish expected locales of Legionella development. In this course, you will figure out how to distinguish and oversee Legionella and meet your commitments under wellbeing and security law concerning hazard the executives at work. You Will Learn What causes Legionnaires' sickness, how individuals get it, side effects and who is especially helpless against Legionella microorganisms. The frameworks well on the way to work with the development of Legionella, including the sort of water put away in a framework and its temperature. The most effective method to direct a danger evaluation to recognize expected wellsprings of Legionella development and the commitments of an entrepreneur under the law. How and when you should test for Legionella and the principle sorts of tests utilized in research facilities. Advantages of Taking This Course On the off chance that you are answerable for controlling work premises, you will profit by realizing how you should deal with forestall and handle Legionella development. Any individual who may come into contact with Legionella at work will profit by finding out about the indications and impacts of Legionnaires' infection, as brief intercession saves lives. In the event that you are liable for leading danger evaluations at work, this course will assist you with determining whether there is a sensible predictable danger that somebody may get tainted with Legionnaires' illness and set up preventive measures. In the event that you are keen on word related wellbeing or work in a HR job, this course will widen your insight into word related sickness.

Legionnaires' Disease Awareness
Delivered Online On Demand
£50

Data Center Training Essentials: General Introduction

4.5(3)

By Studyhub UK

The 'Data Center Training Essentials: General Introduction' course provides a comprehensive overview of data centers, covering mechanical aspects, reliability, equipment, white space, support spaces, and essential considerations such as security, safety, networks, and IT infrastructure. Learning Outcomes: Understand the fundamental concepts and components of data centers. Gain knowledge about data center reliability and the importance of maintaining a secure and safe environment. Learn about the critical roles of various support spaces and the integration of networks and IT infrastructure within data centers. Why buy this Data Center Training Essentials: General Introduction? 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 Data Center Training Essentials: General Introduction 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 course for? This Data Center Training Essentials: General Introduction course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Data Center Training Essentials: General Introduction does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Center Training Essentials: General Introduction 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Data Center Training Essentials: General Introduction is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Data Center Training Essentials: General Introduction Module 01:Data Center Mechanical Introduction 01:01:00 Module 02: Data Center Reliability 00:23:00 Module 03: Data Center Equipment 00:24:00 Module 04: Data Center White Space 00:24:00 Module 05: Data Center Support Spaces 00:27:00 Module 06: Data Center Security, Safety, Networks and IT 00:26:00 Assignment Assignment - Data Center Training Essentials: General Introduction 00:00:00

Data Center Training Essentials: General Introduction
Delivered Online On Demand3 hours 5 minutes
£10.99

GDPR Data Protection Officer

By Nexus Human

Duration 4.125 Days 24.75 CPD hours This course is intended for Managers or consultants seeking to prepare and support an organization in planning, implementing, and maintaining a compliance program based on the GDPR DPOs and individuals responsible for maintaining conformance with the GDPR requirements Members of information security, incident management, and/or business continuity teams Technical and compliance experts seeking to prepare for a data protection officer role Expert advisors involved in the security of personal data Overview Understand the concepts of the GDPR and interpret its requirements Understand the content and the correlation between the General Data Protection Regulation and other regulatory frameworks and applicable standards, such as ISO/IEC 27701 and ISO/IEC 29134 Develop the ability to inform, advise, and monitor compliance with the GDPR and cooperate with the supervisory authority Acquire the competence to perform the role and daily tasks of the data protection officer in an organizationit Considering that data breaches have become highly sophisticated in the recent years, the need for data protection has increased as well.Information Security is crucial to the success of any organization since it deals with the protection of sensitive data from unauthorized access, use, replication and destruction. As such, organizations should put in place measures and controls to manage and diminish Information Security risks and comply with GDPR requirements. In case organizations fail to comply with the GDPR requirements, the penalties can reach up to 2% of an organization?s annual turnover. Also, in case of more serious infringements, the penalties can amount to 4% of an organization?s annual revenue. The implementation of a Privacy Framework, on the other hand, will allow professionals to develop and implement reliable controls that are generally accepted.Becoming a Certified Data Protection Officer will enable you to acquire the necessary expertise to understand the risks that could have a negative impact on your organization and implement the required strategic responses based on the GDPR best practices, requirements and principles. Introduction to the GDPR concepts and principles Training course objectives and structure General Data Protection Regulation (GDPR) Core considerations for the GDPR Designation of the DPO and analysis of the GDPR compliance program Designation of the DPO Analysis of the GDPR compliance program Relationship with the top management Data protection policy Register of processing activities Risk management process DPO operations Data protection impact assessment Documentation management Evaluation of the data protection controls Data protection and technology Awareness, training, and communication Monitoring and continual improvement of GDPR compliance Incident management and personal data breaches Monitoring and measuring compliance Data protection internal audit Treatment of nonconformities Continual improvement Closing the training course

GDPR Data Protection Officer
Delivered OnlineFlexible Dates
Price on Enquiry

ICCC-CT-Installing and Configuring Cisco Cube/Gateways

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is as follows: Network Video Engineer Voice/UC/Collaboration/Communications Engineer Collaboration Tools Engineer Collaboration Sales/Systems Engineer In this 3 Day Cisco Course, students will learn how to deploy Voice Gateways/CUBE and setup Cisco Unified Communication Manager (CUCM) to deploy SIP Trunking. The course starts out with an overview of Cisco gateways and their uses. Next, students learn about MGCP and SIP and how to implement each protocol. Students will then learn how to use Cisco CUBE to connect CUCM, Gateways and Service Providers together. This course details how to connect a Cisco environment to a Service Provider using a Cisco CUBE. Introduction to Voice Gateways Cisco UC Networks and the Role of Gateways Gateway Call Routing and Call Legs Configuring Gateway Voice Ports DSP Functionality, Codecs, and Codec Complexity Router Requirements for CUBE SIP Protocol Overview Gateway Dial Plans VoIP Call Legs Dial Plan Implementation Configuring (CUCM) Cisco Unified Communication Manager 12.5 Cisco UCM Audio Codec Preference List Cisco UCM Region Configuration Device Pool Configuration Annunciator Configuration Conference Bridge Configuration Media Termination Point Configuration Music on Hold Server Configuration Music on Hold Service (IP Voice Media Streaming App) Parameter Settings Music on Hold Service (Duplex Streaming) Parameter Settings Media Resource Group Configuration Media Resource Group List Configuration UC Service Configuration Service Profile Configuration End User Configuration SIP Trunk Security Profile Configuration used by SIP trunk to Cisco UBE SIP Profile Configuration used by SIP trunk to Cisco UBE SIP Trunk to Cisco UBE Configuration Route Pattern Configuration Configuring Cisco Unified Border Element (CUBE) Deploying Cisco VCUBE CUCM to CUBE Integration Configuration Steps to connecting to a SIP Trunk Provider Interworking Security and Call Admission Control Media Manipulation, Enhancement & Optimization SIP UA Translation Rules VoIP Dial Peer SIP Registration SIP attributes of CUBE Transcoding services Creating and configuring Sip Trunks CUBE Configuration CUBE Call Flow CUBE Dial-Peers Call Routing CUBE Advanced Call Routing Media Manipulation External/PSTN Call Recording Call Admission Control Multiple Non-Authenticated SIP Trunks on a CUBE Multiple Authenticated/Registered SIP Trunks on a CUBE Configuring High Availability High availability on ISR G2 High availability on ISR 4k High availability on ASR Cisco Unified Border Element (CUBE) Security Five Layers of Security in CUBE SIP TLS Support with SRTP Monitoring and Troubleshooting Cisco CUBE Dialed Number Analyzer (DNA) for CUBE SIP Profile Test Tool Troubleshooting Serviceability

ICCC-CT-Installing and Configuring Cisco Cube/Gateways
Delivered OnlineFlexible Dates
Price on Enquiry

Cisco CCNP Implementing Cisco IP Switched Networks (Switch) v2.0 Training

4.3(43)

By John Academy

Description The Implementing Cisco IP Routing is a qualifying exam for the Cisco Certified Network Professional CCNP, Cisco Certified Internetwork Professional CCIP, and Cisco Certified Design Professional CCDP certifications. This Cisco CCNP Implementing Cisco IP Switched Networks (Switch) v2.0 Training will help you to be certified successfully with all the important knowledge and skills necessary to use advanced IP addressing and routing in implementing scalable and secure Cisco ISR routers connected to LANs and WANs. The exam also covers configuration of secure routing solutions to support branch offices and mobile workers. This is an advanced course on Cisco routing configuration for both IPv4 and IPv6. In this course you will gain the knowledge to configure and optimize a routing domain using OSPF, EIGRP, BGP, PBR, IP SLA and configure redistribution when needed. It also includes the configuration of highly secure routing solutions to support branch offices and mobile workers. Assessment & Certification To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our Cisco CCNP Implementing Cisco IP Switched Networks (Switch) v2.0 Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Network Design Network Design FREE 00:27:00 Collapsed Core Option 00:30:00 Switching Methods 00:31:00 CAN CAN 00:12:00 Basics of VLANs 00:19:00 Trunking 00:17:00 Creating a Trunk 00:12:00 Voice VLANs 00:21:00 Configuring a Voice VLAN 00:09:00 VTP Versions 00:17:00 Examining VTP 00:11:00 Other DHCP Configurations 00:15:00 Configuring DHCP 00:11:00 DHCP Use 00:11:00 Configure Stateless DHCP 00:20:00 What Must Match 00:06:00 Configure EtherChannel 00:05:00 Load Balancing EtherChannel 00:02:00 Spanning Tree Spanning Tree 00:31:00 Root Bridge (eNotes) 00:23:00 Verify PVST 00:16:00 Influencing the Root Bridge Election 00:28:00 STP Path Manipulation 00:04:00 UplinkFast 00:28:00 PortFast and BPDU Guard 00:06:00 Inter-VLAN Routing Inter VLAN Routing 00:08:00 Router on a Stick 00:19:00 Pros and Cons of an External Router 00:12:00 SVI 00:20:00 L3 Switch Interface (eNotes) 00:07:00 Advanced Switch Configuration Options Advanced Switch Configuration Options 00:16:00 Setting the Clock Manually 00:02:00 Configure NTP 00:07:00 Securing NTP 00:05:00 Overview of SNMP 00:18:00 Configure SNMPv3 00:10:00 What is Cisco IP SLA 00:21:00 SLA Configuration 00:08:00 Configuring SLA Responder 00:07:00 Introducing SPAN 00:18:00 L3 FHRP L3 FHRP 00:15:00 Configuring HSRP 00:17:00 What is HSRP Pre empt 00:23:00 Configuring Tracking 00:05:00 What is VRRP 00:15:00 Configuring VRRP 00:08:00 Security Security 00:25:00 Port Security 00:11:00 Port Errorst 00:21:00 Storm Control 00:02:00 Configuring TACACSRADIUS 00:08:00 Limitations of Both 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Cisco CCNP Implementing Cisco IP Switched Networks (Switch) v2.0 Training
Delivered Online On Demand12 hours 50 minutes
£11.99

Microsoft Excel 2016 and VBA

4.3(43)

By John Academy

Description: Microsoft Excel 2016 and VBA continues Velsoft's in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Excel 2016 and VBA is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Excel 2016 and VBA is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Developing Macros Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Formatting Worksheets Using Macros Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 and VBA 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 and VBA 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2016 and VBA
Delivered Online On Demand12 hours 10 minutes
£25

Diploma in Onpage SEO

4.3(43)

By John Academy

Description The practice of optimizing individual web pages known as On-page SEO that helps to rank higher and earn more consistent traffic in search engines. The focus of this innovative Diploma in Onpage SEO course is to teach you on-page SEO techniques and provide a detailed overview of how to build a WordPress site that perfectly optimized for the Google search engine. Each step by step arranged modules will help you to understand how to research and create laser-targeted keywords for your posts, following with finding and combine Latent Semantic Indexing search terms into your posts or pages. You will also learn to install WordPress, including bullet-proof WordPress site security and the right WP plugins for security, SEO, page load speed and more. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Diploma in Onpage SEO is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Diploma in Onpage SEO is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 On-Page SEO vs Off-Page SEO 00:07:00 Keyword Research Keyword Planner 00:08:00 Free Keyword Research Tool 00:06:00 Paid Keyword Research Tool 00:07:00 Website On-Page Optimization Website Ranking Factors 00:06:00 WordPress Permalink Settings 00:01:00 WordPress Fastest Cache Settings 00:05:00 WordPress Cache Speed Test 00:01:00 Article On-Page Optimization Optimize an Article 00:20:00 Optimize Readability 00:08:00 WordPress Yoast SEO Optimization Setup 00:03:00 Yoast Real-Time Analysis for Any Site 00:02:00 Real-Time Ranking Case Study 00:08:00 All In One SEO Plugin 00:03:00 Image On-Page Optimization Image File Size Optimization 00:11:00 Name and ALT SEO 00:05:00 JPG vs PNG 00:02:00 GIF Images 00:02:00 What is EXIF Data and How to Remove It 00:08:00 Captions for Conversion Optimization 00:06:00 Adding ALT Tags to Images 00:01:00 Create a Sitemap for Images 00:04:00 Audio & Video On-Page Optimization Audio SEO 00:04:00 Video SEO 00:05:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Onpage SEO
Delivered Online On Demand2 hours 14 minutes
£25

Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7

4.5(3)

By Studyhub UK

Are you embarking on the journey of mastering data analytics and visualisation in the UK? The 'Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7' is your beacon. Positioned to illuminate the intricate realm of Power BI, this course offers a comprehensive look into the foundational aspects and the advanced features that make Microsoft's tool a standout. With sections meticulously designed ranging from the fundamentals, like data transformation, to advanced concepts, such as integrating Power BI with Python and storytelling with data, this course ensures learners grasp the complete spectrum. With the rising emphasis on data analytics in today's business world, this course acquaints you with Power BI's prowess. It prepares you for the sought-after Microsoft Power BI certification in the UK. Learning Outcomes Comprehend the fundamental aspects of Power BI, from initiating a project to understanding the user interface. Develop proficiency in advanced data transformation techniques and data model creation. Integrate Python with Power BI and harness the benefits of both for enhanced data analytics. Master the art of 'Storytelling with Data' to deliver impactful presentations and reports. Understand and implement Row-Level Security and harness Power BI Cloud services efficiently. Why choose this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 for? Individuals keen on obtaining the Microsoft power bi certification UK. Analysts and data professionals aspiring to enhance their data visualisation skills. Business professionals wanting to leverage Power BI for insightful business decision-making. Tech enthusiasts aiming to amalgamate programming (Python) with data analytics. Those seeking to stay updated with the latest trends in Power BI and its evolving capabilities. Career path Data Analyst: Average Salary £30,000 - £40,000 Annually Business Intelligence Developer: Average Salary £35,000 - £45,000 Annually Power BI Developer: Average Salary £40,000 - £50,000 Annually Data Visualisation Specialist: Average Salary £32,000 - £42,000 Annually Business Intelligence Manager: Average Salary £45,000 - £55,000 Annually Data Strategy Consultant: Average Salary £50,000 - £60,000 Annually Prerequisites This Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:03:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 00:00:00 Assignment Assignment - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7
Delivered Online On Demand18 hours 26 minutes
£10.99