10275 Office courses

This professional course covers everything you need to know about holidays, sick pay, maternity and paternity leave, and employment discrimination. You'll learn about the legal requirements and best practices for these important areas, as well as the rights of employees and responsibilities of employers. Additionally, we'll explore employment discrimination and its impact on the workplace, including the different types of discrimination and the legal protections in place for employees. This course is ideal for anyone seeking to deepen their understanding of salary and benefits in the workplace and gain the knowledge needed to navigate this complex area of employment law. After the successful completion of the course, you will be able to learn about the following, Salary and benefits. Holidays, Sick Pay. Maternity and Paternity Leave. Employment Discrimination. This professional course covers everything you need to know about holidays, sick pay, maternity and paternity leave, and employment discrimination. You'll learn about the legal requirements and best practices for these important areas, as well as the rights of employees and responsibilities of employers. Additionally, we'll explore employment discrimination and its impact on the workplace, including the different types of discrimination and the legal protections in place for employees. This course is ideal for anyone seeking to deepen their understanding of salary and benefits in the workplace and gain the knowledge needed to navigate this complex area of employment law. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Employee Rights under the Employment and Labour Law Self-paced pre-recorded learning content on this topic. Employee Rights in Labour Law Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Human resource managers and professionals Compensation and benefits specialists Payroll administrators and analysts Business owners and managers Legal professionals Law students Compliance officers Trade union representatives Government officials and policymakers Social workers and advocates for employee rights Employment law practitioners Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

The aim of this course is to provide learners with a comprehensive understanding of variable costing analysis and its applications in managerial accounting. The course will equip you with the necessary knowledge and skills to perform variable costing analysis and make informed decisions about pricing, product mix, and production volume.After the successful completion of the course, you will be able to learn about the following, Analysis of units manufactured. Analysis of variable and absorption costing. Contribution margin analysis. This course is designed to provide learners with a comprehensive understanding of variable costing analysis and its applications in managerial accounting. The course covers key topics such as variable and fixed costs, direct and indirect costs, contribution margin, and absorption costing. You will learn how to calculate and analyze variable and fixed costs, determine contribution margins, and use this information to make informed decisions about pricing, product mix, and production volume. This course is designed to provide learners with a thorough understanding of the principles and applications of variable costing in managerial accounting. The course will cover topics such as variable and fixed costs, direct and indirect costs, contribution margins, and absorption costing. Students will learn how to calculate and analyze variable and fixed costs, determine contribution margins, and use this information to make informed decisions about pricing, product mix, and production volume. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding Variable Costing Analysis Self-paced pre-recorded learning content on this topic. Understanding Variable Costing Analysis Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Financial Analyst Business Manager Operations Manager Management Accountant Financial Controller Cost Accountant Strategic Planner Chief Financial Officer (CFO) Budget Analyst Sales Manager. Investment Advisor Financial Planner Wealth Management Specialist Mutual Fund Manager Investment Analyst Portfolio Manager Financial Consultant Retirement Planning Specialist Investment Operations Specialist Securities Trader Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

CSR Ethics in Risk Management equips professionals with the tools to navigate the complex landscape of ethical considerations and risk mitigation strategies in business. From understanding risk management fundamentals to evaluating the impact of ethical conduct, this course empowers individuals to foster a culture of responsibility and sustainability within their organizations. After the successful completion of this course, you will be able to: Explore the core elements of effective risk management systems and their practical application. Gain insights into Corporate Social Responsibility and its evolving role in contemporary business practices. Recognize the pivotal role of ethics in organizational culture and its impact on workplace behavior. Learn to apply STEP analysis as a tool to assess external factors influencing business environments. Comprehend the stages involved in managing CSR-related risks within an organizational context. Identify and understand the benefits stemming from ethical business practices and their broader impact. Develop skills to evaluate and mitigate the negative repercussions of a lack of ethical conduct in business settings. This course provides a holistic perspective on integrating CSR, ethics, and risk management. Participants will engage in practical exercises, case studies, and discussions to reinforce theoretical concepts. By the end of the course, individuals will possess the knowledge and skills necessary to navigate ethical dilemmas, contribute to effective risk management, and champion CSR initiatives within their organizations. Uncover the synergy between Corporate Social Responsibility (CSR) and Ethics in Risk Management. This course provides practical insights, linking ethical considerations to effective risk mitigation. Explore real-world applications and enhance your ability to integrate CSR principles into risk strategies for responsible business practices. Elevate your expertise in socially conscious risk management. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. CSR Ethics in Risk Management Self-paced pre-recorded learning content on this topic. CSR Ethics in Risk Management Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CSR Risk Manager Ethical Compliance Officer Corporate Sustainability Analyst Business Ethics Consultant Risk Assessment Specialist CSR Strategist Workplace Ethics Coordinator Corporate Responsibility Advisor Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

The aim of a course on "the dynamics of variance and differential analysis" is to provide learners with an in-depth understanding of the concept of variance analysis, its importance in decision-making, and how to apply it in different scenarios. Through the course, learners will gain knowledge and skills to identify and analyze variances, interpret their results, and use them to make informed decisions.After the successful completion of the course, you will be able to learn about the following, Standard Costs: Setting the Stage. Standard Costs: Managerial Implications Variance Analysis. Direct materials cost variance. Direct Labor cost variance. Factory overhead variances. Differential Analysis. Project selection: A general view. Capital investment analysis. This course aims to provide learners with an in-depth understanding of variance analysis and how it can be applied in decision-making. Learners will gain knowledge and skills to identify and analyze variances, interpret their results, and use them to make informed decisions. The course may cover topics such as cost analysis, revenue analysis, and the application of variance analysis in scenarios such as budgeting, cost control, and performance evaluation. Differential analysis, which involves comparing different options and selecting the most profitable one, may also be covered. This course aims to provide learners with an in-depth understanding of variance analysis and how it can be applied in decision-making. Learners will gain knowledge and skills to identify and analyze variances, interpret their results, and use them to make informed decisions. The course may cover topics such as cost analysis, revenue analysis, and the application of variance analysis in scenarios such as budgeting, cost control, and performance evaluation. Differential analysis, which involves comparing different options and selecting the most profitable one, may also be covered. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. The Dynamics of Variance and Differential Analysis Self-paced pre-recorded learning content on this topic. Understanding the Dynamics of Variance and Differential Analysis Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Financial Analyst Cost Accountant Management Accountant Financial Controller Budget Manager Operations Manager Chief Financial Officer (CFO) Business Analyst Consultant Project Manager Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

The aim of "Master Budgeting" course is to provide learners with a comprehensive understanding of the budgeting process and its role in financial management. Through the course, learners will gain knowledge and skills to create, implement, and monitor master budgets effectively.After the successful completion of the course, you will be able to learn about the following, Static Budget. Flexible Budget. Master Budget. Operating Budget. Sales Budget. Cost of Goods Sold Budget. Selling and Administrative Cost Budget. Cash Budget. A Master Budgeting course provides learners with a comprehensive understanding of the budgeting process and its role in financial management. The course covers topics such as budgeting fundamentals, creating a master budget, budget implementation and monitoring, budget analysis and reporting, and strategic budgeting. Learners will gain knowledge and skills to create, implement, and monitor master budgets effectively, including the preparation of financial statements such as the income statement, balance sheet, and cash flow statement. They will also learn how to analyze budget variances, create budget reports, and use them to inform decision-making. Overall, mastering the art of budgeting is essential for organizations seeking to maximize their financial performance and achieve their strategic objectives. This course provides learners with a comprehensive understanding of the budgeting process and its role in financial management. The course covers topics such as budgeting fundamentals, creating a master budget, budget implementation and monitoring, budget analysis and reporting, and strategic budgeting. Learners will gain knowledge and skills to create, implement, and monitor master budgets effectively, including the preparation of financial statements such as the income statement, balance sheet, and cash flow statement. They will also learn how to analyze budget variances, create budget reports, and use them to inform decision-making. Overall, mastering the art of budgeting is essential for organizations seeking to maximize their financial performance and achieve their strategic objectives. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding Master Budgeting Self-paced pre-recorded learning content on this topic. Understanding Master Budgeting Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Financial Analyst Budget Manager Accounting Manager Financial Controller Director of Finance CFO (Chief Financial Officer) Business Manager Operations Manager Sales Manager Project Manager. Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) 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 Introduction to MongoDB for DBAs (TTDB4680) 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.

Embarking on a journey through the intricacies of UK Traffic Law, learners are poised to uncover the complexities of a system integral to the safety of over 32 million registered vehicles in the UK. This course delves into the vast landscape of regulations and legal standards that govern the nation's roads, offering an in-depth exploration of laws that impact daily commutes and long-distance travel. With a focus on real-world applications, the programme equips participants with the knowledge essential for navigating and upholding the legal frameworks that ensure road safety and compliance in the United Kingdom. Learning Outcomes Understand key principles of UK Traffic Law. Analyse legal implications of traffic violations. Interpret UK road safety regulations. Assess legal responsibilities of UK drivers. Evaluate case studies in traffic law compliance. Identify changes and trends in UK traffic legislation. Develop strategies for legal road use in the UK. Explore enforcement mechanisms of traffic laws. Who Is This Course For? Individuals aspiring to work in traffic law enforcement. Legal professionals seeking specialization in traffic law. Road safety campaigners and policy advisors. Driving instructors aiming for deeper legal understanding. Transport sector employees requiring legal compliance knowledge. Why Choose Us? Lifetime access to course materials Full tutor support is available Monday through Friday for all courses Learn essentials skills at your own pace from the comfort of your home Gain a thorough understanding of the course Access informative video modules taught by expert instructors 24/7 assistance and advice available through email and live chat Study the course on your computer, tablet, or mobile device Improve your chances of gaining professional skills and earning potential by completing the course. Why should you study this course? The course offers a comprehensive introduction to the subject matter and provides a solid foundation for further study. It will also help students to gain knowledge and skills that can be applied in their professional or personal life. Assessment The course includes a series of quizzes that will test your understanding and retention of the material covered in the course. The quizzes will help you to identify areas where you may need further practice, and you will have the opportunity to review the course materials as needed. Upon successfully passing the final quiz, you will be able to order your certificate of achievement. Career Path Traffic Law Solicitor: £40,000 - £60,000 Road Safety Officer: £25,000 - £35,000 Transport Compliance Officer: £30,000 - £45,000 Driving Instructor (with law specialisation): £28,000 - £40,000 Legal Policy Advisor (Transport): £35,000 - £50,000 Traffic Law Enforcement Officer: £30,000 - £45,000 Course Features Lectures 9 Quizzes 0 Duration Lifetime access Skill level All levels Language English Students 17 Assessments Yes UK Traffic Law Level 3 Diploma Lecture1.1 Module 1: Introduction to Traffic Law Lecture1.2 Module 2: Understanding UK's Road Traffic Act Lecture1.3 Module 3: Offences Under the Traffic Law Lecture1.4 Module 4: Penalty Points, Fines and Disqualifications Lecture1.5 Module 5: Traffic Law Enforcement and Administration Lecture1.6 Module 6: Road Safety Regulations and Laws Lecture1.7 Module 7: Commercial Vehicle Regulations Lecture1.8 Module 8: Motoring Law and Personal Injury Claims Lecture1.9 Module 9: Legal Proceedings and Representation

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online