185 Cat courses in Edinburgh

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

The aim of this course is to expose the commercial context within which technical work is carried out. It is to allow technical staff to understand how they fit into a larger picture, why they may be asked to undertake tasks that may not appear to be technical and the impact their interactions have within the commercial context. The scope of the programme includes: The course emphasises the collaborative nature of delivery and the need to offer value to customers. The principal training objectives for this programme are to help participants: Understand why technical roles are broader than we might assume Appreciate the importance of, and the need to support, sales Value the idea of 'Good Enough' Recognise what can affect profitability Realise the future needs protecting 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 That's not my job! How we see our own role in work How other people see our role Stakeholders: who are they and why do they matter? The organisational backdrop What is my role really? 3 Sales and marketing Where does the money come from? Where do we find customers? The sales process One-off sales versus repeat business Customer/supplier relationships What something costs versus what the customer will pay The value chain 4 Estimating Purpose of estimates The problem with precision Five estimating techniques 5 Change control Can you just do this for me? When being helpful leads to bankruptcy How to deal with change requests 6 Risk management Risk in projects Risk in operations Categories of risk 7 The value of intellectual property Issues with sharing information Commercial in confidence Non-disclosure agreements 8 Course review and action planning (Course sponsor present) Identify actions to be implemented individually What actions should be implemented to improve working with non-technical people? Conclusion

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

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.

Our telephone training takes place in your normal working situation, using the actual telephones and software, and the programming software clients that trainees will use when fully trained. Our trainers will travel anywhere in the world to train you face to face, or if you prefer, we can offer our whole training catalogue remotely using Teams or Zoom. On-site and live remote telecoms training sessions have a general reputation as most effective for trainees to continue to efficiently carry out their telecoms usage, programming and own in-house training of future new employees. On-site training involves employees training at their place of work while they are doing their actual job, or in pre-organised classroom training sessions, based around hands-on interaction, trainer Q&A and all carried out using your own site telephone system. Our telephone trainers also offer consultations on your new or current telephone systems: looking into how you currently use your system, making suggestions on how programming could be tweaked and changed to improve your current usage, how to improve on call handling methods, and informing you of additional products which may be available on your system that you may not be aware of. This could help improve the level of communication across your company and interactions with your customers. We believe telephone handset and voicemail training sessions are essential to the smooth and efficient running of your company, making sure your staff are aware of all the features and benefits that the telephone handsets can offer, and ensuring calls are dealt with quickly and effectively. System administration training is available to teach new administrators how to manage and control a variety of system features. This type of training is especially important when new administrators have little or no previous telecom knowledge or experience, but it is equally important at all levels to ensure the new system is utilised to its maximum capability. Administration days or Call Centre Software training days take one full day to complete. Full Day Example: 9:30 - 16:00 Day Structure  09:30 - 10:45 Handset & VM session for up to 8 people 10:45 - 12:00 Handset & VM session for up to 8 people 12:00 - 12:45 Lunch  12:45 - 14:00 Handset & VM session for up to 8 people 14:00 - 15:15 Handset & VM session for up to 8 people 15:15 - 16:30 Handset & VM session for up to 8 people Half Day Example: 9:30 - 13:00 Switchboard training takes half a day (3-4 hours for up to 3 people). If you want to train more than 3 people, you may need to extend the day to a full day, to ensure everyone gets to have hands-on training on the switchboard. Super Users and Train the Trainer Sessions Super User sessions can also be organised to show advanced system features in order to provide an ongoing training service to their colleagues, once the trainers have left the site.

REFERENCE CODE 600/6511/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in plastering activities in the workplace. It is not expected that candidates working in this industry all do the same activities so the qualification has been developed to allow opportunities for those carrying out work in any one of the following broad categories: solid basic plastering, solid full plastering, basic fibrous plastering and full fibrous plastering. Those taking the qualification must also prove knowledge and competence in working at heights, calculating quantities and wastage and the use of powered and hand tools and equipment. All work completed must be done in accordance with building regulations and industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the core skills above, candidates will also be able to select optional units recognising skills including, working with direct bond dry linings, laying sand and cement screeds, installing mechanically fixed plasterboard and carrying out repair work. The standards cover the most important aspects of the job. 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 routine assignments. Candidates should require minimum supervision in undertaking the job

Excavator training for all levels from experienced operators to complete novice excavator training

This course will provide the key to successful inventory management, by combining practical inventory control techniques with sound procurement practice, to produce a solid foundation to enable your supply chain to meet customer expectations at the lowest possible cost. PARTICIPANTS WILL LEARN HOW TO: • Understand the role of inventory in an effective supply chain. • Understand categories of stock and how to tailor stockholdings. • Learn how to utilize key concepts, variables and metrics that allow for effective management of inventory. • Understand how product demand and product lifecycle are connected to inventory management. COURSE TOPICS INCLUDE: • Demand Characteristics and the Product Life Cycle • Push and pull systems • Demand forecasting • Categorisation of stock • ABC Analysis • Economic order quantity and minimum order quantity • Safety stock and stock cover • Materials requirements planning (MRP) • Stock replenishment systems • The cost of managing stock

The course helps participants understand the role of demand and inventory planning in the wider context of supply chain management. It aims to demonstrate how to improve the alignment between supply and demand to maintain good levels of customer service and on-shelf availability whilst eliminating excess stock and reducing inventory investment. PARTICIPANTS WILL LEARN HOW TO: • Understand the role of demand management and its benefits • Identify the key demand characteristics and patterns; learn how to use them to improve forecast accuracy • Develop an understanding of key qualitative and quantitative forecasting methods • Learn how to conduct fundamental inventory analyses with a view to achieving the appropriate trade-off between stock and service level COURSE TOPICS INCLUDE: The role of Demand Management • The end-to-end view of Supply Chain Management • Demand Characteristics and the Product Life Cycle • Demand patterns • Push and pull systems Background to forecasting • The forecasting Process • Time-series methods of forecasting • Calculating forecast errors Inventory Analysis • Categorisation of stock • ABC Analysis • Economic order quantity and minimum order quantity • Safety stock and stock cover Inventory Management • Materials requirements planning (MRP) • Stock replenishment systems • Practical inventory management • The cost of managing stock