22294 Courses

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Get ready for an exceptional online learning experience with the Marketing & Sales Training for Business bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Marketing & Sales Training for Business is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Marketing & Sales package has something for everyone. As part of the Marketing & Sales Training for Business package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Marketing & Sales bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Marketing Lead Generation with Attraction Marketing for Business Sales Skills Creating Highly Profitable Sales Funnels How To Build Sales Funnels With ClickFunnels Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Marketing & Sales Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Marketing & Sales Bundle. Build a strong knowledge base in your chosen course via the Marketing & Sales Bundle. Benefit from the flexibility and convenience of online learning. With the Marketing & Sales package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Marketing & Sales Training for Business, a rich anthology of 15 diverse courses. Each course in the Marketing & Sales bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisMarketing & Sales Training for Business bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Marketing & Sales Training for Business bundle offers you the flexibility and convenience to learn at your own pace. Make the Marketing & Sales package your trusted companion in your lifelong learning journey. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Marketing & Sales Training for Business bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Marketing & Sales Training for Business bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Marketing & Sales Training for Business bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

PRINCE2 Agile® Practitioner: Virtual In-House Training PRINCE2 Agile® Practitioner is a solution combining the flexibility and responsiveness of Agile with the clearly defined framework of PRINCE2®. PRINCE2 Agile® framework covers a wide range of agile concepts, including SCRUM, Kanban, and Lean Startup. The PRINCE2 Agile® Practitioner certification teaches you to blend structure, governance, and control with agile methods, techniques, and approaches. The strength of PRINCE2® lies in the areas of project direction and project management, whereas Agile has a very strong focus on product delivery. When PRINCE2® and agile are combined, project direction, project management, and project delivery are optimized to create a complete project management solution. PRINCE2 Agile® is an extension module tailored for forward-thinking organizations and individuals already benefiting from PRINCE2®. It provides further guidance on how to apply agile methods to the world's most recognized project management method. The purpose of the Practitioner qualification is to demonstrate that you can apply and tailor PRINCE2 Agile® in a scenario situation. What you will Learn Understand the basic concepts of common agile ways of working Understand the purpose and context for combining PRINCE2® and the agile way of working Able to apply and evaluate the focus areas to a project in an agile context Able to fix and flex the aspects of a project in an agile context Apply the PRINCE2® principles and tailor the themes, processes, and management products to a project in an agile context To learn through the use of theory and practical exercises Prepare for the PRINCE2 Agile® Practitioner exam Benefits Agile methods allow organizations to realize the benefits of products and potentially an earlier return on investment while products are being developed and improved Improved communication through the use of common terminology across PRINCE2® and agile disciplines Develop a clear definition of how agile can govern a project's delivery, while PRINCE2® governs projects as a whole Seamless integration: PRINCE2 Agile® will complementPMBOK® GuideandAPM Body of Knowledge® just as PRINCE2® does currently. It will also be of interest for Program Managers with MSP® who need to understand how projects relate to the delivery mechanism. The most up-to-date and relevant view of Agile project management methodologies, PRINCE2 Agile® references the 'flow-based' working featured in Kanban in addition to other agile concepts not covered in other qualifications Agile Overview & Blending PRINCE2 and Agile Agile overview Blending PRINCE2 and Agile Fix and Flex, Agile and PRINCE2 Processes & Starting a Project Fix and Flex Agile and the PRINCE2 Processes; Starting up a project and Initiating a project Business case theme Change and Organization Themes& Principles Change theme Organization theme Agile and PRINCE2 Principles and the Agilometer Managing Product Delivery and Scrum & Plans and Progress Themes Managing product delivery and Scrum Plans Theme and Progress Theme Quality, Controlling & Managing a Stage and Directing Projects and Contracts Quality Theme Controlling a stage and Frequent Releases Managing a stage boundary Directing a project and contracts Closing a project Tailoring PRINCE2 Productsand Other Practices Tailoring PRINCE2 products and other practices

Course Overview Calendly is a leading automated scheduling platform for small and large work teams, entrepreneurs and business leaders. It connects people across time zones, with a variety of enterprise features. In the Using Calendly for Business course, you will be guided through how to set up and manage your account, schedule appointments, calls and interviews, master its recruitment tools, and much more. This course will also show you how to integrate Calendly with other apps like Zoom, and manage your account settings for enhanced productivity. By the end of the course, you will be able to use Calendly to schedule important meetings and interviews, track and report, set your availability, and simplify recruitment tasks. Enrol as a part-time or full-time learner, and start scheduling like a pro. This best selling Using Calendly for Business has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Using Calendly for Business is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Using Calendly for Business is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Using Calendly for Business is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Using Calendly for Business, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Using Calendly for Business will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Using Calendly for Business to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

24 Hour Flash Deal **25-in-1 Sales Support Coordinator Diploma Mega Bundle** Sales Support Coordinator Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Sales Support Coordinator Diploma package online with Studyhub through our online learning platform. The Sales Support Coordinator Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Sales Support Coordinator Diploma course provides complete 360-degree training on Sales Support Coordinator Diploma. You'll get not one, not two, not three, but twenty-five Sales Support Coordinator Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Sales Support Coordinator Diploma courses are yours for as long as you want them once you enrol in this course This Sales Support Coordinator Diploma Bundle consists the following career oriented courses: Course 01: Sales Training: Practical Sales Techniques Course 02: Sales Development Representative Diploma Course 03: B2B Sales & Marketing Strategies: Winning in Business-to-Business Sales Course 04: Learn to Create A Selling Strategy that Drives Sales Course 05: NLP For Sales, Persuasion & Influence Course 06: Increase Your Sales Through a Profitable Pricing Strategy Course 07: Product Management for Maximum Sales: Boosting Business Success Course 08: Sales and Marketing Course 09: B2B Business Development Course 10: Sales Analysis in Excel Course 11: Residential Property Sales Course 12: Retail Management Course 13: Retail Associate Certificate Course 14: Telemarketing Course 15: Diploma in Sales and Strategic Marketing Certificate Course 16: ETSY Marketing and Business Course 17: Affiliate Marketing Course 18: Content Writing & Copywriting For SEO and Sales Course 19: Marketing Strategies for Business Course 20: Learn to Drive Traffic into Sales through Digital Marketing Course 21: Telesales Executive Training Course 22: Step-by-Step Guide to Defining and Sizing Your Market Course 23: Corporate Relationship Goals for Success Course 24: Get a Job in Sales: Your Fast Track to Career Success Course 25: Business Networking Skills The Sales Support Coordinator Diploma course has been prepared by focusing largely on Sales Support Coordinator Diploma career readiness. It has been designed by our Sales Support Coordinator Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Sales Support Coordinator Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Sales Support Coordinator Diploma bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Sales Support Coordinator Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Sales Support Coordinator Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Sales Support Coordinator Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Sales Support Coordinator Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Sales Support Coordinator Diploma lessons One to one assistance from Sales Support Coordinator Diplomaprofessionals if you need it Innovative exams to test your knowledge after the Sales Support Coordinator Diplomacourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Sales Support Coordinator Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Sales Support Coordinator Diploma certificate and transcript on the next working day Easily learn the Sales Support Coordinator Diploma skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Sales Support Coordinator Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Sales Support Coordinator Diploma Requirements To participate in this Sales Support Coordinator Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Sales Support Coordinator Diploma Career path You will be able to kickstart your Sales Support Coordinator Diploma career because this course includes various courses as a bonus. This Sales Support Coordinator Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Sales Support Coordinator Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

The NEBOSH National General Certificate in Occupational Safety and Health is an examined core qualification for people who have part of their role at work involved in health and safety.

Do you love baking and decorate beautiful cakes, but cannot get them done properly? Or do you want to start your career as professional baker with outstanding cake decorating skills. Despite of the cases, you will eventually require a diploma if you are looking for a way to start your cake decorating business. Being a business owner is not easy and when it comes to creativity like decorating cakes, it becomes more harder. Thus, having enough knowledge and professional guideline can help to successfully launch the business and perform good in the future. With our Cake Decorating Business Skills Training. You will learn different techniques both decorating and marketing so that you can make a good profit from your business. You will also learn about different types of business cards, selecting the right words, using professional tools, food safety and finally different types of management skills. Moreover, you will get a complete guide on how to successfully run a cake decorating business just by yourself with our extensive Cake Decorating Business Skills Training course. Course Highlights Cake Decorating Business Skills Training is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Cake Decorating Business Skills Training into 22 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 25 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Cake Decorating Business Skills Training Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Cake Decorating Business Skills Training is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Cake Decorating Business Skills Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Cake Decorating Business Skills Training Introduction To Cake Decorating Business Skills Training 00:30:00 Getting Started 00:30:00 Marketing Your Cake Decorating Business 00:45:00 Business Cards & Stationery 00:30:00 Selecting The Word Tactfully 00:30:00 Case Study: Promoting On A ShoeString Budget 01:00:00 Tools of The Trade 00:30:00 Lowering Your Business Costs 00:30:00 How To Accept Payment 00:15:00 Home Based Business Taxes 00:30:00 Organizing Your Business For Success 00:30:00 Baking Secrets Revealed 00:30:00 Down To Baking Business 00:30:00 Insider Tips From A Professional Baker 00:30:00 Food Safety Tips 00:15:00 Wedding Cake Consultations 00:30:00 Time Management Secrets 00:30:00 It`s a Piece Of Cake 00:15:00 Cake Assembly Instruction 00:30:00 Cake Delivery & Packaging 00:30:00 Action Plan: Checklist 00:30:00 Conclusion: Final Words 00:15:00 Mock Exam Mock Exam-Cake Decorating Business Skills Training 00:20:00 Final Exam Final Exam-Cake Decorating Business Skills Training 00:20:00

Compass for Agility - Leveraging Agility for Business Problem-Solving Join Leila Rao as she introduces the Compass for Agility. This 90-day iterative approach is a pragmatic and personalized method, enabling organizations to build the capacity and culture for responding to challenges and opportunities. This provides a structure for organizations to explore what'ss working and what isnTt in their ecosystem to successfully and sustainably build the capability for continuous learning and improvement. The Compass helps with addressing "wicked" business problems set apart by one key variation: agile is the how, not the "why". Enhancing business agility is a fortunate by-product of directly resolving pain points because agile serves as the means, not the end. Empower your organization to orient itself by its unique needs and values so that you can continually create customized maps as you chart your own journey in volatile and uncertain terrains.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Product Owner Advanced™ training (PSPO Advanced) to master the role of a Product Owner. Learn how to advance your training of Product Ownership and apply it to deliver even more value. Course Description Agile techniques and the Scrum framework revolutionise project and product delivery, enabling teams to work faster and align closely with business needs. A product owner's role within this delivery is critical. Unlike traditional team managers, Product Owners focus on maximising product value rather than individual elements of project delivery. To excel in this role, product owners must combine business strategy with product vision and delivery roadmaps. The ability to operate within complex environments highlights the need for specific training and qualifications. Product Owner Advanced training is specifically designed to empower experienced Product Owners to deliver greater value. An exceptional Product Owner requires skillsets beyond core Agility and Scrum. These include clear decision-making, vision, communication, and influence. Practical experience is highly valued, and the PSPO 2 course emphasises interactive workshops, discussions, and exercises to provide a comprehensive understanding of the multifaceted Product Owner role. This course elevates existing Product Owners' capabilities, providing a clear path for your professional growth and delivering increased value to product stakeholders. Through collaborative and exploratory training, Product Owners' knowledge and experience will reach new heights, improving various aspects of your role. Key areas covered include: Deepening understanding of the Product Owner role, including product understanding, customer identification, and effective communication of product vision and strategy. Leveraging product vision and strategy to gain a competitive edge. Embracing diverse roles and stances essential for Product Owners. Enhancing stakeholder communication and management skills with a focus on different stakeholder groups. Navigating Agile governance, budgeting, and contracting within the Scrum framework. Scaling the Product Owner role for larger projects and products. By the end of this product owner advanced training, participants will be equipped to excel as Product Owners, driving success and value across their product journey. Why Train With Us? Develop advanced product owner skillsets that build on your existing knowledge of the Scrum framework and product owner accountabilities with our immersive two-day online PSPO Advanced course. Led by experienced industry professionals and support Professional Scrum Trainers & Product Owners, the course values team-based exercises and a hands-on learning experience. We help you grow within your Product Owner role through this advanced training, enabling you to better communicate product vision and strategy to teams, ultimately delivering higher value through projects and products with larger scopes. Who Should Attend This Course? The Professional Product Owner – Advanced course is designed for: Experienced Product Owners, ideally with at least one year of experience in the role Scrum Masters and stakeholders collaborating with Product Owners Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials