6131 Object courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

The objective of fast track Level 5 Diploma in Business Management qualification (accredited by OTHM) is to provide learners with an excellent foundation for a career in a range of organisations. It is designed to ensure that each learner is 'business ready': a confident, independent thinker with a detailed knowledge of business and management, and equipped with the skills to adapt rapidly to change.The content of the qualification is focused on people management, managing projects, marketing, finance for managers, business law, business ethics and social responsibility. The qualification is ideal for those who have started, or are planning to move into, a career in private or public sector business. Successful completion of the fast track Level 5 Diploma in Business Management qualification will provide learners with the opportunity to progress to further study or employment. Program Overview Key Highlights Program Duration: 6 Months (Regular duration mode available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn You will get knowledge and skills required by a middle manager who is involved in people management, managing projects, marketing, finance, business law, business ethics and social responsibility. Who is this course for? Working Professionals, A-Level / Level 4 / Year 1 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.

Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of this fast track Level 4 Diploma in Accounting and Business qualification is to provide learners with an understanding of accounting and business in the broader business context, and to provide them with the practical, industry-focused skills to manage business finances, budgets and cash flow effectively, and to play a key role in business growth. Top Skills You Will Learn You will have an understanding of accounting and business in the broader business context. The programme will provide you with the practical, industry-focused skills to manage business finances, budgets and cash flow effectively, and to play a key role in business growth. Opportunities You will have immense career opportunity in banking to manufacturing, from huge service industries to micro businesses. You will get the ability to manage, plan and account for money which is still the ultimate measure of business success and the key driver of growth. Who is this course for? Working Professionals, A-Level holders, Professionals working in range of industries looking for a career in finance and accountancy Requirements Open Entry. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. For others, the learners should have relevant NQF / QCF / RQF Level 3 Award / Diploma or at the level of GCE / GCSE or equivalent qualification. Career path Progress to: Year 2 of a Three-year UK Bachelor's degree Completion of your qualification will meet the University standard academic entry requirements to progress to Year 2 of a 3 Year UK Bachelor's Degree. In addition to Progression to the Universities, you also have an option to progress to the following Level 5 qualifications offered by LSBR, UK

Diploma in Business Studies - Level 3 (Fast-Track mode) The objective of the Diploma in Business Studies - Level 3 qualification (Accredited by OTHM) is to provide learners with an in depth understanding of the operations and structure of businesses. Successful completion of this qualification will equip learners with the underpinning knowledge and skills required to succeed in employment or further studies. Diploma in Business Studies Key Highlights Program Duration: 6 Months (Regular Mode available) Program Credits: 60 Credits Designed for working Professionals Course Delivery: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Understanding of operations and structure of businesses. Underpinning knowledge and skills required to succeed in employment or further studies. Successful completion of the Program enables learners' direct entry into Year 1 of a three-year UK Bachelor's degree or pursue Level 4 Diplomas Mandatory units (Total Credits: 40) The Level 3 Diploma in Business Studies qualification consists of 4 mandatory units plus 2 optional unit for a combined total of 60 credits, 600 Total Qualification Hours (TQT) and 360 Guided Learning Hours (GLH) for the completed qualification. Introduction to Research and Academic Skills (10 credits) Using IT for Business (10 credits) Introduction to Economics and Accounting (10 credits) Introduction to the Business Environment (10 credits) Optional Units (Total Credit: 20) Choose any two of the below Optional Units Introduction to Customer Service (10 credits) Managing Business Events (10 credits) Introduction to Marketing (10 credits) Introduction to People Management (10 credits) Who is this course for? Working Professionals O-Level holders, Sales Marketing Professionals Requirements Open Entry. No formal qualification is required Career path Completion of your Level 3 Diploma in Business Studies qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

Key Highlights of the fast track Level 7 Diploma in Human Resource Management programme are: Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option The objective of this fast track Level 7 Diploma in Human Resource Management qualification (accredited by OTHM, UK) is to provide learners with the skills and understanding in Human Resource Management (HRM) that align with good strategic decision making to maintain organisations' competitive advantage. You will acquire knowledge through an integrated approach of theory in Human Resource Management and practice using real-time activities. Successful completion of this fast track Level 7 Diploma in Human Resource Management qualification will develop learners' Strategic Human Resource Management and Leadership skills and their ability to focus on the requirements of implementing an organisation's strategy. This fast track Level 7 Diploma in Human Resource Management qualification enables learners to progress into or within employment and/or to work toward a relevant Master's programme with advanced standing. Who is this course for? Who is this Program For?Working Professionals, Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal Postgraduate qualification leading to award of degrees in future. Requirements Minimum EligibilityFor entry onto the fast track Level 7 Diploma in Human Resource Management qualification, learners must possess an honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counsellors for waiver information. Career path OpportunitiesUpon successful completion of the fast track level 7 Diploma in Human Resource Management programme, you will also become eligible to gain direct entry into relevant Master's and MBA degree programme.

Key Highlights of this fast track Diploma in Accounting and Finance - Level 7 qualification are: Program Duration: 6 Months (Regular mode also available)) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option The objective of this fast track Level 7 Diploma in Accounting and Finance (accredited by Othm) qualification is to provide learners with an understanding of: Contemporary and specialised approaches to accountancy and finance Key practical, theoretical and empirical issues, and academic research The complexity of the ever-changing legal framework in which the financial sector operates The latest developments in accountancy and reporting required by local, national and European government. This fast track Level 7 Diploma in Accounting and Finance qualification equips learners with the essential skills and knowledge needed to pursue high level careers in all types of organisations in the public and private sector and within industry and commerce, both in the UK and abroad. The Level 7 Diploma in Accounting and Finance qualification in fast track mode also provides learners with the opportunity to work toward a relevant Master's programme with advanced standing. This qualification is designed for learners who wish to pursue a career in the: Financial Services industry, Professional Accountancy, Banking and Finance or Management. Who is this course for? Who is this Program For?Working Professionals, Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal Postgraduate qualification leading to award of degrees in future. Requirements Minimum EligibilityFor entry onto the fast track Level 7 Diploma in Accounting and Finance qualification, learners must possess an honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counsellors for waiver information. Career path OpportunitiesYou may look forward to role in Financial Services industry, Professional Accountancy, Banking and Finance or Management. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's degree programme.

Key Highlights of fast track Diploma in Health and Social Care Management - Level 7 qualification are: Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option The objective of this fast track Level 7 Diploma in Health and Social Care Management qualification (accredited by OTHM) is to develop learners' understanding of policy, management theory and practice in health and social care. It provides you with an opportunity to engage with the challenges facing professionals, services users and policy makers in their own country. It will also provide you with the knowledge that underpins the ability to work as an effective manager in the hospitals/social care industry. It combines both theoretical and practical knowledge in the health and social care profession. This fast track Level 7 Diploma in Health and Social Care Management qualification will develop and enhance knowledge and skills in the areas of leading change, effective performance, planning and accountability, development and team leadership. Learners will be able to work in a variety of roles within health care administration and/or management. Successful completion of the Level 7 Diploma in Health and Social Care Management qualification in fast track mode enables learners to progress into or within employment and/or continue their study towards a relevant Master's programme with advanced standing. Who is this course for? Who is this Program For?Working Professionals, Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal Postgraduate qualification leading to award of degrees in future. Requirements Minimum EligibilityFor entry onto the fast track Level 7 Diploma in Health and Social Care Management qualification, learners must possess an honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counsellors for waiver information. Career path OpportunitiesYou will be able to work in a variety of roles within Health Care Administration and/or Management in the Hospitals / Social Care Industry. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's degree programme.

Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of the Level 5 Diploma in Accounting and Business (fast track) qualification accredited by OTHM is to provide learners with the knowledge and skills required by a middle manager in an organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. Level 5 Diploma in Accounting and Business (Fast track mode) Key Highlights of fast track Level 5 Diploma in Accounting and Business qualification are: Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme LSBR Alumni Status No Cost EMI Option This fast track Level 5 Diploma in Accounting and Business qualification will help you get knowledge and skills required by a middle manager in an organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. You can look forward to middle management role in organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. Upon successful completion of this fast track Level 5 Diploma in Accounting and Business programme, you will also become eligible to gain direct entry into Final Year of a three-year UK Bachelor's degree programme. Who is this course for? Working Professionals, A-Level / Level 4 / Year 1 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression. A formal undergraduate qualification leading to award of degrees in future. Requirements Open Entry. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. For others, the learners should have relevant NQF / QCF / RQF Level 4 Award / Diploma or at the level of GCE / GCSE or equivalent qualification. Please speak to the Admission Counsellors for waiver information. Career path After completion of your fast track Level 5 Diploma in Accounting and Business, you can progress to Year 3 of a Three-year UK Bachelor's degree Completion of your fast track Level 5 Diploma in Accounting and Business qualification will meet the University standard academic entry requirements.

The objective of the Level 6 Diploma in Logistics and Supply Chain Management (fast track mode) (accredited by OTHM) qualification is to provide learners with the knowledge and skills required by a middle or senior manager in an organisation, and who may be involved in managing organisational logistics and supply chain. Level 6 Diploma in Logistics and Supply Chain Management Key Highlights Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option The Level 6 Diploma in Logistics and Supply Chain Management (fast track mode) qualification will provide you with the knowledge and skills required by a Middle or Senior Manager in an organisation, and who may be involved in managing organisational Logistics and Supply Chain. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's and MBA degree programme. Mandatory units (Total Credits: 120) The OTHM Level 6 Diploma in Logistics and Supply Chain Management qualification consists of 6 mandatory units for a combined total of 120 credits Entrepreneurship Development (20 credits) Global Logistics and Supply Chain Management (20 credits) International Logistics Management (20 credits) Project Management (20 credits) Strategic Procurement (20 credits) Supply Chain Planning and Control (20 credits) Who is this course for? Working Professionals, or learners with relevant NQF/QCF/RQF Level 5 Diploma or equivalent recognised qualification or for learners who are interested in pursing an Undergraduate Qualification or who are looking for Career Progression and a formal qualification leading to award of degrees in future. Requirements For entry onto the Level 6 Diploma in Logistics and Supply Chain Management (fast track mode) qualification, learners must have relevant NQF/QCF/RQF Level 5 diploma or equivalent recognised qualification. You must also be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counsellors for waiver information. Career path University Progression after completion of your Level 6 Diploma in Logistics and Supply Chain Management (Fast Track mode) qualification Upon successful completion of your Level 6 Diploma in Logistics and Supply Chain Management (fast track), you will also become eligible to gain direct entry into relevant Master's degree programme

The objective of fast track Level 6 Diploma in Tourism and Hospitality Management qualification (accredited by Othm) is to develop learners' management knowledge and skills within the tourism and hospitality industry. Learners will critically evaluate contemporary knowledge and theories and use these to propose solutions to complex management problems. Successful completion of Level 6 Diploma in Tourism and Hospitality Management qualification in fast track mode will equip learners with the specialist skills and knowledge they need to plan and manage their work areas, to make effective decisions, and to adapt effectively to the needs of a range of tourism and hospitality organisations. Level 6 Diploma in Tourism and Hospitality Management Key Highlights Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option This fast track Level 6 Diploma in Tourism and Hospitality Management qualification will develop your management knowledge and skills within the tourism and hospitality industry. You will be able to critically evaluate contemporary knowledge and theories and use these to propose solutions to complex management problems. Upon successful completion of fast track Level 6 Diploma in Tourism and Hospitality Management programme, you will also become eligible to gain direct entry into relevant Master's degree programme. Mandatory units (Total Credits: 120) The OTHM Level 6 Diploma in Tourism and Hospitality Management consists of 6 mandatory units for a combined total of 120 credits Strategic Marketing (20 credits) Tourism Policy and Planning (20 credits) Organisational Behaviour and Performance (20 credits) Technology in the Tourism and Hospitality Industry (20 credits) Tourism and International Development (20 credits) Researching Tourism and Hospitality Management (20 credits) Who is this course for? Working Professionals, Level 5 / Year 2 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression A formal undergraduate qualification leading to award of degrees in future. Requirements Open Entry. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. For others, the learners should have relevant NQF / QCF / RQF Level 5 Diploma or equivalent recognised qualification. Please speak to the Admission Counsellors for waiver information. Career path Upon completion of your Level 6 Diploma in Tourism and Hospitality Management in fast track mode you become eligible to gain direct entry into relevant Master's degree programme Completion of your qualification will meet the University standard academic entry requirements.However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry