3083 Courses in Manchester delivered Online

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

Unleash your potential in the realm of literacy and numeracy mastery. Discover the art and science behind adult learning, delve into the intricacies of teaching and learning literacy, and unlock the secrets of imparting numeracy with finesse. Our comprehensive programme takes you on a journey through the fascinating landscapes of adult education, blending theory with practical insights. Elevate your teaching prowess and redefine your impact on learners with modules that explore inclusive learning, technology integration, and the nuances of policy and practice. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Immerse yourself in an engaging learning adventure that goes beyond conventional approaches, equipping you with the knowledge and skills to navigate the diverse challenges of adult education. Join us in reshaping the educational landscape, where your passion meets purpose, and your expertise becomes a beacon for adult learners seeking the keys to literacy and numeracy mastery. Course Curriculum Module 1: Overview of Adult Literacy and Numeracy Module 2: Understanding Adult Learning Theories Module 3: Teaching and Learning Literacy Module 4: Teaching and Learning Literacy Writing, Speaking and Listening Module 5: Planning and Assessment Literacy Module 6: Learning Numeracy Module 7: Learning Numeracy Percentage, Statistical Functions and Probabilities Module 8: Teaching Numeracy Module 9: Technology in Learning Module 10: Adult Learning Difficulties Module 11: Inclusive Learning Module 12: Policy and Practice Learning Outcomes: Grasp adult learning theories for effective teaching strategies. Hone literacy teaching skills in writing, speaking, and listening. Demonstrate proficiency in planning and assessing literacy education. Acquire a solid foundation in numeracy, including statistical functions. Develop advanced teaching techniques for imparting numeracy concepts. Cultivate inclusive practices and align teaching with educational policies. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Educators seeking advanced adult teaching expertise. Literacy and numeracy enthusiasts passionate about adult education. Professionals eager to enhance their teaching impact. Individuals committed to fostering inclusive learning environments. Aspiring educators ready to embrace the challenges of adult education. Career path Adult Education Coordinator Literacy Outreach Specialist Numeracy Instructor Inclusive Learning Advocate Educational Policy Analyst Technology Integration Facilitator Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The aim of the Introduction to Commercial Banks course is to provide students with a foundational understanding of commercial banking operations and their role in the economy. The course will equip students with the knowledge and skills to evaluate the risks and opportunities associated with banking, as well as the regulatory framework that governs banks. After the successful completion of the course, you will be able to learn about the following, Identify types of commercial banks and their roles. Analyze the evolution of commercial banks. Evaluate services provided by commercial banks. Assess the relationship between commercial banks and competitors. Evaluate the impact of key trends on banks. Explain the functions of central banks. Compare central banks and commercial banks. Analyze the concept of Central Bank Digital Currency (CBDC). Evaluate the role of commercial banks in CBDCs. Recognize the significance of commercial banks. The Introduction to Commercial Banks course provides an overview of the role of commercial banks in the economy, including their functions, products, and services. Students will learn about the regulatory environment that governs banks, as well as the risks and opportunities involved in banking operations. By the end of the course, students will have a comprehensive understanding of how commercial banks operate and their impact on the financial system. Introduction to Commercial Banks is a comprehensive course designed to provide an understanding of the role and function of commercial banks in the financial system. The course covers the basics of banking, including the types of commercial banks, their operations, and their regulatory framework. Students will gain practical knowledge of banking practices, such as loans, deposits, and investment management. 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. Introduction to Commercial Banks Self-paced pre-recorded learning content on this topic. Introduction to Commercial Banks 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. Bank Teller Personal Banker Loan Officer Credit Analyst Commercial Bank Manager Investment Banker Treasury Analyst Financial Consultant Risk Manager Compliance Officer. 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.

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

Overview This comprehensive course on Logistics Management Training: From Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Logistics Management Training: From Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Logistics Management Training: From Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our Logistics Management Training: From Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 17 sections • 75 lectures • 10:48:00 total length •Value Chain Model: 00:06:00 •Logistics Function In An Organisation: 00:09:00 •Logistics and Logistics Functions: 00:09:00 •General Information In Logistics: 00:12:00 •Logistics Functions Explanation: 00:09:00 •Logistic Functions Explanation Continues: 00:09:00 •General Introduction Of Logistics: 00:13:00 •How Logistics Can Be Applied To Business: 00:03:00 •Business EXCELLENCE Through Logistics Management: 00:08:00 •Role Of Outsourcing: 00:07:00 •Logistics Management For Business Excellence: 00:10:00 •Understanding Transportation Strategy: 00:12:00 •Objectives of Transportation: 00:02:00 •Transportation Functionality: 00:07:00 •Factors Influencing Transportation Cos: 00:11:00 •Containerization and Its Role: 00:06:00 •Understanding Role Of Inventory: 00:09:00 •Inventory Functions: 00:05:00 •Cost of Inventory: 00:06:00 •Other Types Of Inventory: 00:11:00 •Basics Of Inventory Management: 00:12:00 •Basics Of Inventory Management Continues: 00:08:00 •KANBAN: 00:02:00 •Inventory Policy Guidelines: 00:05:00 •Warehouse Management Introduction: 00:04:00 •Warehouse And Its Design: 00:05:00 •Warehouse And Its Design Continues: 00:08:00 •Warehouse Operating Principle: 00:05:00 •Strategic Decisions In Warehousing: 00:10:00 •Warehousing Strategies: 00:09:00 •Warehousing Performance Measures: 00:11:00 •Logistics Information System Introduction: 00:04:00 •Need For Logistics Information System: 00:03:00 •Information Functionality: 00:04:00 •Evaluating Logistics Information System: 00:06:00 •Application of Logistics Information System: 00:10:00 •Designing of Logistics Information System: 00:08:00 •Designing of Logistics Information System Continues: 00:07:00 •Benefits of Logistics Outsourcing: 00:18:00 •Types of Logistics Providers: 00:07:00 •Outsourcing Value Proposition: 00:07:00 •Outsourcing Management Selection Criteria: 00:07:00 •Contract Terms and Conditions: 00:04:00 •Material Handling Part 1: 00:07:00 •Material Handling Part 1 Continued: 00:08:00 •Material Handling Part 2: 00:09:00 •Material Handling Part 2 Continued: 00:05:00 •Material Storage Principles: 00:03:00 •Material Storage Methods: 00:10:00 •Material Storage System Unit Load Storage: 00:11:00 •Design of Storage system: 00:09:00 •Storage System Design Continued: 00:05:00 •Scope and Objectives Of Reverse Logistics: 00:15:00 •Design Considerations: 00:13:00 •Automatic Identification Technology: 00:15:00 •EDI standards Application and Benefits: 00:04:00 •Automated Material Handling System: 00:14:00 •Satellite Tracking ERPDRP and AITS: 00:15:00 •Objectives of E-commerce: 00:05:00 •Classes of E-commerce Applications: 00:10:00 •E-logistics In E-commerce: 00:11:00 •E-Logistics Structure and Operations: 00:04:00 •Logistics Performance Measures and Controls: 00:08:00 •Logistics Performance Measures and Controls Continued: 00:14:00 •Characteristics Of A Successful Logistical Organization: 00:14:00 •Evolution Of Logistics And Organization: 00:06:00 •Learning Approaches To Logistical Organization: 00:11:00 •Drivers Of Logistical Organization: 00:09:00 •Drivers Of Logistical Organization Continued: 00:09:00 •Scope and Scale of Global Logi: 00:10:00 •Operational Factors and Challenges in Global Logistics: 00:16:00 •CrossBorder Goods Movement: 00:12:00 •Logistics Competitive Framework: 00:16:00 •Logistics strategies Across The Product Life Cycle: 00:17:00 •Conclusion: 00:05:00

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

Prepare to immerse yourself in the thrilling realm of Unity game development and C# scripting! If you have already acquired the fundamentals of C# scripting with Unity and are eager to elevate your skills to the next tier, then you have found the ideal Intermediate C# Scripting Course. This course is custom-crafted for individuals seeking to master Unity and C# by working on practical, real-world projects.

Duration 2 Days 12 CPD hours This course is intended for This course is primarily for Application Consultants, Business Analysts, Business Process Owners/Team Leaders/Power Users, and Developer Consultants. Overview At course completion students will know- The basic functions and navigation options of BusinessObjects Analysis for Microsoft Office- The special functions and layout design options of BusinessObjects Analysis for Microsoft Office In this course, students learn the basic functions and navigation options of the Analysis edition for Microsoft Office. Students will also learn the special functions and layout design options of Analysis. Components and Data Sources for Analysis Using Analysis Components and Data Sources Customization for Workbook Data Analysis Using the Basic Components of Analysis Sorting and Filtering Workbook Members Filtering Selected Workbook Members by Measure for Enhanced Analysis Using Hierarchies for Data Analysis in Workbooks Using Inserted Components to Add Workbook Functionality Configuring Filter Components Using Formulas to Enhance the Workbook Layout Defining Conditional Formatting Options for Workbooks Using a Prompting Dialog in Workbook Queries Extending Workbook Display Options with Functions and Microsoft Excel VBA Using Styles to Customize Workbook Appearance Setting Preferences to Control Workbook Behavior Publishing Analysis Documents to the BI Platform Server Presentation of Workbook Analysis Data Presenting Analysis Data for Business Users Additional course details: Nexus Humans BOAN10 SAP BusinessObjects Analysis for Microsoft Office 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 BOAN10 SAP BusinessObjects Analysis for Microsoft Office 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 5 Days 30 CPD hours This course is intended for Experienced Programmers and Systems Administrators. Overview Throughout the course students will be led through a series of progressively advanced topics, where each topic consists of lecture, group discussion, comprehensive hands-on lab exercises, and lab review. This course is ?skills-centric?, designed to train attendees in core Python and web development skills beyond an intermediate level, coupling the most current, effective techniques with best practices. Working within in an engaging, hands-on learning environment, guided by our expert Python practitioner, students will learn to: ? Create working Python scripts following best practices ? Use python data types appropriately ? Read and write files with both text and binary data ? Search and replace text with regular expressions ? Get familiar with the standard library and its work-saving modules ? Use lesser-known but powerful Python data types ? Create 'real-world', professional Python applications ? Work with dates, times, and calendars ? Know when to use collections such as lists, dictionaries, and sets ? Understand Pythonic features such as comprehensions and iterators ? Write robust code using exception handling An introductory and beyond-level practical, hands-on Python training course that leads the student from the basics of writing and running Python scripts to more advanced features. An Overview of Python What is python? 1 -- An overview of Python What is python? Python Timeline Advantages/Disadvantages of Python Getting help with pydoc The Python Environment Starting Python Using the interpreter Running a Python script Python scripts on Unix/Windows Editors and IDEs Getting Started Using variables Built-in functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Sequences About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Generator Expressions Nested sequences Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Converting binary data with struct Dictionaries and Sets About dictionaries Creating dictionaries Iterating through a dictionary About sets Creating sets Working with sets Functions Defining functions Parameters Global and local scope Nested functions Returning values Sorting The sorted() function Alternate keys Lambda functions Sorting collections Using operator.itemgetter() Reverse sorting Errors and Exception Handling Syntax errors Exceptions Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages The import statement Module search path Creating Modules Using packages Function and Module aliases Classes About o-o programming Defining classes Constructors Methods Instance data Properties Class methods and data Regular Expressions RE syntax overview RE Objects Searching and matching Compilation flags Groups and special groups Replacing text Splitting strings The standard library The sys module Launching external programs Math functions Random numbers The string module Reading CSV data Dates and times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Working with the file system Paths, directories, and filenames Checking for existence Permissions and other file attributes Walking directory trees Creating filters with fileinput Using shutil for file operations 17 ? Advanced data handling Defaultdict and Counter Prettyprinting data structures Compressed archives (zip, gzip, tar, etc.) Persistent data Advanced data handling Defaultdict and Counter Prettyprinting data structures Compressed archives (zip, gzip, tar, etc.) Persistent data Network services Grabbing web content Sending email Using SSH for remote access Using FTP Writing real-life applications Parsing command-line options Detecting the current platform Trapping signals Implementing logging Python Timeline Advantages/Disadvantages of Python Getting help with pydoc