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
As technology continues to develop and increasingly interact with our daily lives, so must our sales techniques to ensure we're leveraging advances in how people do business to our advantage. It is essential for all salespeople to understand how to navigate the various tools at our disposal and grow their skills and confidence to put them into action in order to build a solid business pipeline. We have developed this programme to be practical, fun and interactive, whilst ensuring that participants will learn how to utilise new technology to their advantage, self-generate new business leads and opportunities, gain additional business and referrals from existing contacts, and save time and effort using proven business development skills. This course will help participants: Understand the 'organized persistence' model of sales prospecting Develop skills in using video, online and social media to generate interest Understand how to write effective sales and outreach emails and using online tools Develop techniques for effectively managing telephone appointments Learn ways to use LinkedIn for connecting with customers and prospects Develop networking skills and learn how to source and develop referrals and professional introductions 1 Key principles of smart sales prospecting Set your sales prospecting goals and objectives Elevator pitch, core messages and your value proposition Targeting and segmenting your market 'Organised persistence' using your CRM effectively 2 Setting appointments by telephone - planning and preparation Why calling still works and the best times to call Creating a call prompt sheet: Opening a call and taking control Giving a reason to meet Key questions to ask Overcoming the cold calling blues 3 Setting appointments by telephone - advanced skills Giving a reason to meet and 'selling the appointment' Key questions to ask that will create interest and motivation to meet Voice tone, power words, phrasing, pausing, responding Getting past gatekeepers and getting through 4 Using LinkedIn for research and follow-up Why LinkedIn matters and how to use it Finding new contacts, connecting and Inmailing Short-cuts and advanced skills 5 Email strategies that work Using AIDA and other templates for sales emails Using personalized video emails to create interest Vertical targeting emails, with examples Building awareness with an email chain
Why Join Digital Marketing Training Course at Osborne Training Osborne Training is well Recognised for quality Regular Lectures led by Industry Expert Tutors Unlimited Access to the State of the Art Virtual Learning Campus Exclusive Access to High quality study materials Flexible payment option available Join Digital Marketing Training course as Pure Online or Blended with Classroom Delivery Access to Digital Marketing Internship for 3 months at the end of the training Unlimited Tutorial Support from expert tutors Get a Student Discount Card from NUS* Get a Free Tablet PC for limited period* Practical Hands-on Projects, Practical focused Assignments and Group-work for greater skills enhancement and understanding real life issues for real life problems Once you complete the bookkeeping course, you will get a certificate from Osborne Training confirming your professional Digital Marketing Qualifications. What jobs could I qualify for? Senior Digital Marketing Manager Digital Marketing Coordinator Executive Digital Marketing Strategist Digital Marketing Consultant In these roles, you could earn on average more than £40,000 annually (source: Reed Salary Checker, UK). Moreover, many go on to become successful (Millionaire sometime) entrepreneur by offering Digital Marketing services or formulating successful Digital Marketing Strategy for their own business. Digital Marketing Qualifications Digital Marketing Qualifications at Osborne Training are developed in Association with Google. Osborne Training offers Total Digital Marketing Course which combines all major skills required to be a successful Digital Marketeer and you also have option to join a complementary Internship at the end of your course. In joining the Total Digital Marketing Course at Osborne Training, you will make one of the greatest decision of your career and can look forward to a successful career in digital marketing. Digital Marketing Course Overview Total Digital Marketing Course covers major areas of Digital Marketing to make you completely ready for the digital era. The Digital Marketing course comes with optional Internship at the end of the training making you highly employable. Practical focused and hands-on approach of the training method helps you to be ready to offer real life solutions for real life problems. Digital Marketing Training Course Content Basics of marketing Marketing In Digital Era All About Web Search Engine Optimization Search Engine Marketing Affiliate Marketing Social Media Marketing Email marketing and nurturing (inbound) Mobile app marketing Content marketing Web, mobile and app analytics Growth Hacking Creating robust digital marketing strategy
REFERENCE CODE 603/7248/5 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The aim of this qualification is to confirm that the candidate has the skills and knowledge to install Curtain Wall systems on site. It is not expected that all curtain wall installers will carry out identical tasks as there are many variations in system types and installation environments, so the qualification had been developed to allow as wide an uptake as possible. All of the work needs to be completed in accordance with relevant legislation, regulations and health and safety guidelines
REFERENCE CODE 610/0075/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at individuals wishing to prove they have the level and range of knowledge and skills required to install Interior Systems in the Construction working environment. It is not expected that all workers will complete the same tasks, there are 3 mandatory units common to all pathways. The Pathways will allow employees with specific skills and from companies of all sizes equal opportunity to complete. All work must be completed following Industry recognised Safe Working Practices and in accordance with relevant legislation. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with a range of tasks and situations. There is also a Level 2 Certificate and a Level 3 Diploma in Interior Systems available.
Course description Sage 50 Accounting / Bookkeeping Training - Fast Track Overview Want to open the door to working in Finance and Accountancy Industry? Starting Sage Line 50 Accounting Fast Track Training course will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Get a new direction for your career in Accountancy, according to statistics, the average salary for Accountants is £50,000 (Source: Reed), it is the sector where the employability rate is higher than any other sector. With the right skills and practical experience, you would be able to fast track your career in Accountancy and exactly that's where Osborne Training can fill the gap. The intensive programmes include all the skills required to fast track your career in professional Accountancy. Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime or Weekend sessions for Sage 50 Bookkeeping Training Course from London Campus. Online Live - Osborne Training offers online Evening sessions for Sage 50 Bookkeeping Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the exams. What qualification will I gain? You could Gain the following IAB qualifications provided that you book and register for IAB exams and pass the exams successfully: IAB Level 1 Award in Computerised Bookkeeping (QCF) 500/9405/1 IAB Level 2 Award in Computerised Bookkeeping (QCF) 500/9261/3 IAB Level 3 Award in Computerised Bookkeeping (QCF) 500/9407/5 Awarding body International Association of Book-Keepers Sage 50 accounts Course Syllabus Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Stock Valuation, Stock Control, Work in Progress and Finished Goods Prepare and Produce Final Accounts Extended Trial Balance Exporting Data including Linking to Other Systems Management Information Reports Making Decisions with Reports Using Sage Prepare and Process Year End Accounts and Archive Data Final Accounts for Partnerships including Appropriation Accounts The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control
Are you an EDI Officer, HR Specialist, Leader or Manager? Or the nominated EDI champion for your team? Maybe you've been given the EDI portfolio on behalf of your Board or department? Or if you're aiming to make a difference via your diverse staff network or union, all change-makers are welcome!
Our self-leadership and executive development programme can be fully ITA SDS funded supporting leaders and business owners and creating a growth plan. SDS INDIVIDUAL TRAINING ACCOUNTS (ITA) Rely On Our Team for Your Executive Development The Power Within Training offers unrivalled executive development training for go-getters and self-starters throughout England and Scotland. Did you know that approximately 55% of people making their living in sales don’t have the right skills to be successful? Good sales skills are some of the rarest and most sought-after skills in the workforce. Whether you’re running a business, looking to progress further in your career or want to sharpen your skills before returning to work, our self-leadership training will help you develop the skills you need to succeed. After completing our executive development training, you’ll have a sales mindset and the skills to secure your ideal role, perform better, and utilise high-payoff action-planning techniques. Don’t hesitate to contact us to learn more information. OUR TRAINING SOLUTIONS What is Self-Leadership Executive Training? Self-Leadership Development Our self-leadership development course was designed to give you total control of your career, business, and professional life. Most professionals will spend more than 80% of their time at work or in business. We’ve structured our executive training to help those looking to enhance their career prospects or business success by taking advantage of our unique Motivational Intelligence seven steps to success framework. The seven-step success system will take you through a journey of self-discovery, self-awareness, and self-development, which enables you to understand the barriers and self-limiting obstacles that have been holding you back. The Power Within’s self-leadership training will guide you through overcoming these barriers and eliminating them from your life. If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. Benefits of Self-Leadership Development The self-leadership training has been designed from the ground up to inspire, guide, and develop you into not only achieving your goals but being able to measure success in your career, help you find your dream job, and help make an immediate impact in everything you do. Completing our executive leadership development course will allow you to utilise emotional intelligence to get the best of your team while focusing on clear values and principles that increase your overall success and profitability. Working on your self-leadership skills will grant you greater insight into the factors hindering or impacting your success while giving you the tools to make decisions and get into action. Here are some additional benefits of our self-leadership training: Build Awareness – When you’re a leader, you must inspire and motivate people to achieve and go after the bigger picture for your organisation. You’ll need an effective and flexible leadership style to ensure your team succeeds. We’ll help you discover your leadership style and how you can use it effectively to the advantage of your business. Increase Team Engagement, Motivation, and Accountability – How can you expect your team to behave if you’re no longer motivated to succeed? The Power Within will give you the tools to keep striving toward success while ensuring your business is focused and motivated. Cultivating a High-Performance Culture – The right high-performance culture installs peak performance into every team member. Through our executive development, you’ll be able to help each reach their targets while they look for ways to improve constantly. Develop Strategic Skills – We’ll help you develop leadership skills and self-improvement goals, allowing you to introduce changes to your business based on your guiding visions while encouraging others to share the same vision. If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. What Are the Key Skills Learned from Executive Development Training One of the first sets of vital skills for self-leadership you’ll learn is the ability to stop, step back, and reflect on the things that trigger us to react. When we react, we’re being controlled by the trigger. Another skill we’ll help instill is to consider intention. Intention is important to us, such as our values and what we’re trying to achieve. When you become intentional, you start to live a life of choice. Self-leadership and executive development are a journey. The more self-leadership we attain, the more successful we’ll become. The more successful we become, the more self-leadership we need. Here are some additional critical skills you’ll learn from our self-leadership training: Self-Awareness – It’s vital to hone your ability to see yourself as clearly as you are. This skill takes dedication, introspection, and mindfulness. Also, a dose of self-awareness helps with self-control, self-confidence, and feelings of validation. Overall, you should be open to critique and accountability. Goal Setting – A good self-leader must be proactive in not only identifying their goals but how to reach those goals in a manageable manner. Our executive development training will teach you how to break down a larger goal into more attainable steps to avoid burnout while helping you celebrate smaller milestones. Self-Motivation – A classic way to handle self-motivation is to divide long-term goals into smaller, more attainable ones. This optimization means recognising what about the goal that appeals to you, then forming a strategy that aligns with your strengths and values toward that goal. Constructive Thought Patterns – Through our leadership skills and self-improvement course, you’ll be able to review your performance and assess your intentions and effectiveness while providing an opportunity to ensure your strategies are geared towards success. This is done by focusing on improving strengths and the mental imagery of yourself that recognizes your capacity to grow, develop, and change. Self-leadership training teaches you to see yourself as having the ability to create, improvise, innovate, and adapt. OUR LIVE WORKSHOPS ARE BACK What’s Covered in Our Executive Development? Self-Leadership "It's a mindset thing" When you undergo our self-leadership training, you’ll experience several modules designed to allow your conscious and subconscious belief systems to work together for a predetermined goal or set of outcomes. Self-leadership is one skill that will significantly impact your career, team, and even your life’s happiness. Our executive leadership development course promotes bold and powerful decisions to get you back into the driver’s seat of your life and make the best of each day by setting goals, shifting your mindset, and finding your purpose. During each module, we’ll work with you and help you design and deliver your team leadership programmes catered to your team and your business dynamic. Our goal is to allow you to evolve into a bigger and better leader. Here are some of the modules in our self-leadership training: Unleash Your True Potential Create Your Personalised 7-Step Success Framework Peak Performance and Self-Mastery Growth Mindset and Mindset Performance The Power of Feedback Taking Back Control of Your Personal & Professional Journey Goal Setting & Defining If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. Discover Who’s Leading Our Self-Leadership Training James Fleming, the co-creator of The Power Within, will lead your self-leadership training. James founded The Power Within with his wife, Enas Fleming. They wanted to inspire people around the world to think better, be better and achieve more. James believes that everyone can be whatever they set their minds to. Founding The Power Within allowed James to turn that deep knowledge into a business that helps others think bigger, better, and achieve more daily. He strives to give leaders the tools and knowledge to achieve their full potential while increasing their self-confidence and self-belief through Motivational Intelligence Revolution. James wants to support today’s businesses to become tomorrow’s leaders. Course Overview Our self-leadership development course is a quick-paced training that is between eight and twelve hours in length. After you attend the face-to-face workshops, you’ll be given access to our online self-leadership training portal. This allows you to continue your journey of self-development by ensuring you’ll always have a system and process to fall back on when you need it. One of the best parts of our executive development course is that you receive this information fully funded. Even if you aren’t eligible for funding, you can still invest in this course and begin a new chapter of professional development for yourself. Elevate yourself if any of our eligibility requirements apply and you early less than 22,000 a year.
In a world focused on digital media, 24-hour news channels and social channels, it’s really important to communicate with your audience – there are lots of opportunities to do this if you are interviewed by journalists. There’s the chance to deliver expert comments or take part in in-depth features or give a quote about your business or organisation. The media wants to stay relevant and engaged with its audience and you can play a part in that and talk to your audience. In our Broadcast Media Training Courses, we will teach you the best ways to share your story, how to answer those difficult questions and present yourself with confidence and style. This means you will capitalise on every opportunity. Our broadcast media and media interview training courses include: Crisis Media Training Benefits There are many reasons why businesses and organisations suddenly find themselves trending on social media or being talked about in the broadcast media. When something goes wrong, your every move is watched and then commented on online, putting you and your teams under even more pressure. So if the worst should happen and you find yourself or your company or business suddenly in the public eye, you need to be prepared. We’ll help you learn how to manage your response ensuring clarity and confidence. It’s vital you don’t leave a vacuum for others to fill so let us help you respond effectively. Why would I ever need Crisis Training? Brand reputation is the most important asset we have in the digital media age. Audiences want to engage with organisations which have credibility and authenticity. A crisis – not always of your making – can quickly undermine that if it’s handled badly. Communication is at the heart of crisis media training and we can show you how to deal with a wide range of situations, address concerns and criticism and ensure your message reaches audiences under the most pressured circumstances. Who needs to attend the training? Crisis Media Training isn’t just for the most senior CEO’s or Managing Directors. In order to support the authenticity of your response it’s important the people on the ground can talk to the public. And in the age of social media, if you’re talking to the public, you’re talking to the media. So the people dealing with the crisis are the people who should know how to communicate in a crisis. There are times when the top bosses must talk as they are accountable and are happy to demonstrate that level of responsibility. But the media will also ask to talk to the people handling the problem and we can show them how. How do I book Crisis Media Training? We can help you create the perfect training to stress test your messaging and make sure you’re ready to deliver your message if you find yourselves unexpectedly in the news. We’ll help you deal with challenging questions and diffuse the most tense of interviews. But our main criteria is that we design the training you want so we’ll work with you to create the perfect course. All you have to do is give one of our friendly team a ring on 0754 533 4269 or email us.
This very practical one-day programme provides participants with the skills and knowledge required to be an effective member of the procurement team and to enable them to procure a wide range of resources for the organisation, in a compliant and cost-effective manner. It also empowers them to be able to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the basic concepts of good procurement practice Apply a range of tools and techniques for developing scopes of work and specifications Apply various methods to select and evaluate suppliers Develop robust contract award strategies Appreciate the commercial importance of effective procurement and opportunities to reduce cost and add value Develop appropriate procurement strategies depending on risk and value Appreciate the legal aspects of procurement 1 Welcome Introductions Aims and objectives Plan for the day 2 The basics of procurement The concept of total cost of ownership v price The procurement cycle The roles of the customer and the contractor Impact upon profit 3 Specification process Importance of effective specifications Specification development process Types of specification Team approach Use of performance specifications Early supplier involvement (ESI) / early contractor involvement (ECI) 4 Quality Concepts and practices Defining 'fit for purpose' Conformance to requirements Compliance to standards Role of the supplier Quality assurance tools and techniques 5 Procurement methods RFP RFQ ITT Negotiated procurement Strategic partnerships Outsourcing 6 Tendering How to undertake a formal tendering process Business case to award Critical stages in the process Risks and benefits 7 Tender evaluation How to undertake a quotation analysis Tools of analysis Use of VFM models Role of the customer Comparisons around cost, quality, and delivery 8 Supplier selection and evaluation Developing critical selection criteria Using the 10Cs model Importance of effective selection process Weighting systems Importance of validity and evidence 9 Capital equipment procurement Life cycle cost issues Payback calculations Compatibility issues Maintenance and training issues After-sales support 10 Supplier relationships Corporate social responsibility issues Communication 360 feed-back Open and ethical Initial understanding Clear and fair terms and conditions 11 Close Review of key learning points Personal action planning