145 Courses in Sheffield

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

Generating new leads and new business can be both time-consuming and frustrating. It's not easy - it takes skill, careful preparation and the creation of effective models and methods, even perhaps using formal approaches and scripts. Once generated, a new lead or enquiry must also be carefully managed to maximise the potential revenue it can generate. But it's crucial to get it right. If your company can afford not to worry about getting new business - congratulations! If your company is completely confident that it is performing at peak potential in generating new leads - again, congratulations! But if your company is working in the real world, couldn't your team do with some help, to become even just that little bit more effective, to make the process just that little less painful? This highly practical, intensive workshop gives sales teams the proven strategies and tactics they need to build a sustainable new business pipeline. This course will help participants: Develop a clear and consistent process for new business development and lead-generation Master the secret of effective new business development and lead-generation - 'only sell the appointment or next stage of the sales process, not your product or service' Set and achieve the right level of new business development and lead-generation activity to achieve your personal and organisational sales goals Apply the key principles of effective prospecting and pipeline management using a proven toolkit and approach Overcome the most common 'put-offs' when conducting telephone or face-to-face business-development and lead-generation activities Develop an engaging telephone voice and manner - and a 'networking personality' Qualify potential opportunities with more accuracy on a consistent basis Prioritise opportunities and manage their time when sourcing new business Discover online sources of leads, contacts and referrals Overcome psychological blocks to cold or warm calling - theirs and the client's Identify potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Make outbound sales or appointment calls with improved confidence, control and results Improve the conversion of calls to appointments by using more effective questions and sales messages Get past gatekeepers and assistants more effectively Make the most of your CRM software and systems 1 Online marketing - what works! Workshop overview and learning objectives Choosing your social media channels LinkedIn for sales and marketing Designing and implementing an effective new business email campaign online Creating a lead-generation strategy online - with case studies Avoiding common mistakes in social media marketing Case study: 'Best practice in social media sales and marketing' Using blogs and video-based marketing (eg, YouTube) New trends and how to keep your finger on the 'social media' pulse Twenty essential websites and online marketing tools 2 Making appointments by telephone Planning the call, telephone techniques, integrating with email and online marketing Developing a clear and consistent process to appointment-making Setting and achieving the right level of telephone activity to achieve your appointment goals Applying the key principles of effective prospecting and pipeline management generation, using a proven toolkit and approach Overcoming the most common 'put-offs' to seeing or engaging with you Overcoming psychological blocks to cold or warm calling - yours and the client's Identifying potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Making outbound sales or appointment calls with improved confidence, control and results Improving conversion of calls to appointments by using more effective questions and sales messages The five keys to developing an engaging telephone voice and approaching manner 3 Power networking Strategies for networking and B2B referral-based marketing The importance, and different types, of networking How to work a room - preparation and strategy Communication dynamics in networking - the power of the listening networker Assumptions when networking Business networking etiquette Making connections, asking for cards, contact details and referrals, gaining follow-up commitments Building relationships - follow-up and follow-through 4 Developing new leads Strategies for first-time sales calls Gaining rapport and opening first-time and new business sales calls effectively Advanced consultative selling - questioning techniques to quickly and efficiently uncover opportunities, need areas and preferences Presenting your solution to a new or first-time customer - creating an enthusiastic and compelling personalised and persuasive summary of your proposal Value message - differentiate your solutions clearly and accurately, with tailored value statements Presenting the right initial USPs, features and benefits and making them relevant and real to the customer Smart ways to position price, emphasise value and be a strong player without being the cheapest or leading on price Learn and use advanced techniques to determine customer needs, value and decision-making criteria in depth on a first-time call 5 Organised persistence - CRM and prospect-tracking Organised persistence - sales tracking, following up on 'sleeping' customers, gaining referrals, time and territory management Maintaining a good database for maximising new business ROI Developing a contact strategy with different types and levels of contact Analysing your contact base using state-of-the-art software and tools Making the most of your CRM systems and solutions Understanding that your attitude makes a difference when sourcing new business Setting SMART objectives for new business development and lead-generation Practical exercise - setting personal development and business goals Time management tips to improve daily productivity New business pipeline management strategies for peak sales performance 6 Workshop summary and close Practical exercise - developing your new business action plan Review and feedback

We explore digital assets to identify business requirements, thoroughly understand business needs, and implement appropriate strategies accordingly. Through thorough market research and competitor analysis, we will craft a customized strategy to elevate your business’s marketing performance on search engines.

Course Overview Outstanding customer service doesn’t happen by accident- it’s the result of clear communication, empathy, consistency, and a strong customer-focused mindset. This practical one-day course helps participants develop the mindset, skills and strategies needed to provide exceptional service and handle difficult situations with confidence and professionalism. Through real-world scenarios, role plays and interactive discussions, participants will learn how to build rapport, respond to customer needs, and create positive experiences that leave a lasting impression—whether communicating face-to-face, by phone, email, or online. Who Should Attend This course is ideal for: Frontline staff in retail, hospitality, healthcare, call centres, or public service Administration or reception staff Technical support or helpdesk officers Any team member who interacts with customers, clients or stakeholders No previous training in customer service is required. Learning Outcomes By the end of the course, participants will be able to: Understand what excellent customer service looks like and why it matters Communicate clearly, professionally and confidently in different situations Build rapport with a wide range of customers Show empathy and listen actively to understand customer needs Handle complaints, concerns and difficult conversations calmly and constructively Maintain a positive attitude, even under pressure Represent their organisation in a consistent and professional way Course Content 1. Foundations of Customer Service Excellence What is excellent customer service? First impressions and the customer journey Attitude, tone and mindset 2. Communicating with Confidence The power of words, tone and body language Active listening and questioning skills Managing expectations and saying "no" professionally 3. Creating Positive Connections Building rapport and trust quickly Adapting your style for different customers Service recovery: turning complaints into opportunities 4. Handling Difficult Situations Staying calm under pressure Responding to frustration, complaints or anger The LEAPS model for difficult conversations (Listen, Empathise, Apologise, Provide solution, Summarise) 5. Service Across Channels Delivering service via phone, email and online Professional email and message tone Tips for consistency across different platforms 6. Practical Application and Action Planning Real-life scenarios and role plays Personal action planning for immediate workplace impact Sharing service tips and best practices Delivery Method The course is delivered in an engaging, interactive format and includes: Short trainer-led discussions Scenario-based activities Role plays with coaching Group discussions and shared insights Available as a face-to-face or live virtual workshop. Inclusions Participant workbook and tools Practical checklists and communication templates Certificate of completion Access to optional post-course coaching support

Course Overview Outstanding customer service doesn’t happen by accident- it’s the result of clear communication, empathy, consistency, and a strong customer-focused mindset. This practical one-day course helps participants develop the mindset, skills and strategies needed to provide exceptional service and handle difficult situations with confidence and professionalism. Through real-world scenarios, role plays and interactive discussions, participants will learn how to build rapport, respond to customer needs, and create positive experiences that leave a lasting impression—whether communicating face-to-face, by phone, email, or online. Who Should Attend This course is ideal for: Frontline staff in retail, hospitality, healthcare, call centres, or public service Administration or reception staff Technical support or helpdesk officers Any team member who interacts with customers, clients or stakeholders No previous training in customer service is required. Learning Outcomes By the end of the course, participants will be able to: Understand what excellent customer service looks like and why it matters Communicate clearly, professionally and confidently in different situations Build rapport with a wide range of customers Show empathy and listen actively to understand customer needs Handle complaints, concerns and difficult conversations calmly and constructively Maintain a positive attitude, even under pressure Represent their organisation in a consistent and professional way Course Content 1. Foundations of Customer Service Excellence What is excellent customer service? First impressions and the customer journey Attitude, tone and mindset 2. Communicating with Confidence The power of words, tone and body language Active listening and questioning skills Managing expectations and saying "no" professionally 3. Creating Positive Connections Building rapport and trust quickly Adapting your style for different customers Service recovery: turning complaints into opportunities 4. Handling Difficult Situations Staying calm under pressure Responding to frustration, complaints or anger The LEAPS model for difficult conversations (Listen, Empathise, Apologise, Provide solution, Summarise) 5. Service Across Channels Delivering service via phone, email and online Professional email and message tone Tips for consistency across different platforms 6. Practical Application and Action Planning Real-life scenarios and role plays Personal action planning for immediate workplace impact Sharing service tips and best practices Delivery Method The course is delivered in an engaging, interactive format and includes: Short trainer-led discussions Scenario-based activities Role plays with coaching Group discussions and shared insights Available as a face-to-face or live virtual workshop. Inclusions Participant workbook and tools Practical checklists and communication templates Certificate of completion Access to optional post-course coaching support