2345 Courses delivered Online

This online course introduces a model for determining and analysing market value vs fair value of an individual art work. LEVEL 3: Fair Value Analysis This is the third online course in our 'Pathway to become an art market analyst'. This course is a building block on both Big Data and the Art Market (Level 1) and Artist Market Analysis (Level 2), and takes the participant on an analytical journey to establish the market value and the fair value of an individual art object. The analysis is based on the Damien Hirst data provided in Level 2: Artist Market Analysis, and it is important that you finish this course before going on to Level 3. The course introduces participants to the difference between market value and fair value, and provides a practical guide for using market trends to analyse and adjust comparable transactions, and to use this to help establish market value. The ArtTactic Market Metrics from Level 2: Artist Market Analysis, is brought into the analysis to establish the 'Fair Value' of the art work. In addition to this, we will provide a 15 minute online Excel workshop on how to analyse comparable transactions using a subset of the data provided in the Level 2 online course. The course includes: Videos: You will have access to 1h 10m of online video content. The content of this course is building on ArtTactic's own framework for fair analysis and what Anders Petterson is regularly teaching for Art Business programmes at Sotheby's Institute in London. The course also include a 15 minutes Excel workshop. Slides: The students can download pdf copies of the slides used in the presentations. Excel spreadsheet: The student will have access to a subset of data (auction data for Damien Hirst) and a spreadsheet with both tables and graphical tools. Certificate of Completion [NEW]: The student will be issued with a certificate of completion when all the online videos have been completed. CPD Accredited: Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. Certification: Continuing Professional Development (CPD) Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. This means our courses comply with universally accepted principles of Continual Professional Development (CPD) and have been structured to meet the criteria of personal development plans. Join one of the online courses below and get an ArtTactic Certificate of Completion with the Continuing Professional Development (CPD) certification stamp. Your Instructor Anders Petterson, Founder of ArtTactic Anders Petterson is a leading authority on the art market, with particular focus on art market research and analysis. He is the Founder and Managing Director of ArtTactic, a London-based art market research and data intelligence company he set up in 2001. All the online courses are based on his own experience in collecting, analysing and presenting data on the global art market, and the courses will give an insight into how ArtTactic conceptualizes, designs and executes research projects linked to art market and introduces analytical models to better understand the value of art. Anders is regularly lecturing on MA and Executive courses at Sotheby's Institute, Christie's Education and ESA Business School (Beirut) covering topic such as Art Market Analysis, Art & Technology and NFTs as well as Art as an Asset Class. He is also a regular speaker on these topics at international conferences and seminars. ArtTactic is also well-known for its industry research on the art market and its intersection with other industries, such as the Deloitte | ArtTactic Art & Finance Report, TEFAF Art Dealer Finance Report 2018, and the TEFAF Art Patronage Report 2020. ArtTactic has also produced the Hiscox Online Art Trade Report annually since 2013. Anders Petterson is a founding Board Member of Professional Advisors to the International Art Market (PAIAM), a role he had between 2011 and 2021. PAIAM was founded in London in 2011 bringing together professionals who provide specialist services to the art market.such as lawyers, accountants, tax advisors, insurance specialists and logistics experts, amongst others. Connect on LinkedIn Course Curriculum Introduction Introduction to Fair Value Analysis (1:39) Fair Value Analysis Market Value vs Fair Value (4:24) Artwork Analysis - Object Qualities (9:40) Market Trend Analysis & Value Adjustments (7:10) Comparable Transaction Analysis (9:30) Market Value Analysis (6:45) Fair Value Analysis (11:03) Excel Workshop - Comparable transaction analysis + Sample Analysis Excel Workshop - Comparable Transactions (12:31) SAMPLE: Damien Hirst - Fair Value Analysis Summary  Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own. It's important to note that this is a SINGLE-user only subscription (see T&Cs). Contact us if you are looking for a team discount on info@arttactic.com.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.Is this course for me?We have a broad and diverse set of students taking these courses in terms of geography, age and professional backgrounds. Based on our experience so far, the courses have attracted non-art market professionals that are looking to explore opportunities in the art market or the broader art industry - and are looking for tools to help them navigate and better understand where these opportunities might exist, and how their own interest and professional background could fit in. At the other end, we also have seen a strong interest from the art trade who are looking at exploring more quantitative and data-driven methods for their own business and to meet the demand for an increasingly data-hungry client base. However, if you have any questions, please contact us and we can set up a call to discuss what course option might be the best for you.

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 After completing this course, students will be able to: - 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 course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 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 Lab 1: Introduction to TSQL for Business Intelligence 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 Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 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 Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 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 Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 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 55232 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.

Introduction to Design Thinking: On-Demand Innovation is the cornerstone of highly successful companies, especially those that continue to be successful over the years and decades. Design thinking practices fuel this continual innovation, as they are the critical links from inspiration to delivery, concept to showroom floor, and start-up to global business. Design thinking is a structured approach to promoting innovation and creative problem-solving. It is not a new approach. It has been around for centuries, as the art, architecture, and inventions of mankind illustrate. By examining the steps to achieving great design and maximum utility of product, design thinking approaches provide a framework in which to develop new solutions to problems and new products to sell. This highly interactive course is designed to help participants think like designers to generate innovation, and to help teams to produce more innovation and creativity. Since design thinking is based on doing rather than thinking, we participants are challenged to apply the techniques, in the classroom, to create new ideas and solutions to a case study project. What you will Learn At the end of this program, you will be able to: Explain the underlying principles and value of using Design Thinking for innovation Describe the basic concepts of the Stanford Model for Design Thinking Evaluate a set of basic Design Thinking techniques for application to your projects Apply tools, techniques, and skills aligned with the 5 stages of the Stanford Model Drive innovation through Design Thinking at some level in your work environment Foundation Concepts Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks Stages of Design Thinking Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks General Practices Team formation Visualization Improvisation Personalization Empathize Practices Overview of Empathize techniques Observation Engagement Interviews Define Practices Overview of Define practices Unpacking techniques Defining the customer techniques Integrating the Define experience Ideate Practices Overview of Ideate practices Reusable techniques for the Ideate stage New Ideate techniques to explore Prototype & Test Practices Overview of Prototype practices Examples of prototypes Overview of Testing practices Forms of testing techniques Adopt and Adapt Design Thinking Overview of Design Thinking implementation Design Thinking implementation challenges Success in implementing Design Thinking Summary and Next Steps Workshop summary Next steps: Personal Action Plans

We are excited to announce the Online version of the Step by Step Course. It will include live demonstrations of the process that you will then follow. Unique opportunity to be guided step by step and experience meditative practice of icon painting.

🚀 Elevate Your Marketing Game with 'Crafting Clear Marketing Goals: A Strategic Approach' Online Course! 🚀   Are you tired of feeling overwhelmed by vague marketing strategies that lead nowhere? Do you find it challenging to set and achieve concrete marketing goals? It's time to transform your approach and take charge of your marketing success with our exclusive online course!   🌟 Introducing: Crafting Clear Marketing Goals: A Strategic Approach   🎓 What You'll Learn: Module 1: Introduction 🚀 Dive into the fundamentals of effective marketing goal setting. 🔍 Explore the impact of clear goals on your overall business strategy. 🎯 Identify common pitfalls and misconceptions hindering goal achievement. Module 2: Marketing Plan Objectives 📈 Develop a comprehensive understanding of crafting SMART marketing goals. 💡 Learn how to align marketing objectives with overall business objectives. 🔧 Discover strategies for adapting and refining goals as market conditions evolve. Module 3: Workshop 🛠️ Apply your newfound knowledge through hands-on exercises and case studies. 💬 Engage in live discussions and Q&A sessions with industry experts. 🏆 Walk away with a personalized marketing plan tailored to your business.   🔥 Why Enroll: Expert Guidance: Learn from seasoned professionals with a proven track record in marketing strategy. Practical Skills: Gain practical skills through real-world examples and interactive workshops. Community Support: Connect with a vibrant community of like-minded professionals for networking and collaboration. Lifetime Access: Enjoy lifetime access to course materials, updates, and future resources.   📈 Transform Your Marketing Future! Don't let unclear marketing goals hold you back. Unlock the secrets to strategic marketing success and propel your business to new heights. Whether you're a seasoned marketer or just starting, this course is designed to empower you with the knowledge and skills needed to craft and achieve clear marketing goals.   🌐 Enroll Today and Secure Your Spot in the Future of Marketing Excellence!   Course Curriculum Module 1- Introduction Marketing Plan Objectives Explained 00:00 Module 2- Marketing Plan Objectives Aligning Your Marketing Objectives 00:00 Guidelines for Creating Marketing Objectives 00:00 Types of Objectives 00:00 Module 3- Workshop Workshop - Create Your Marketing Objectives 00:00

Kunst is een vorm van communicatie. Het is niet altijd een neerschrijfbare boodschap, maar wel iets dat werd gecreëerd om iemand te raken. Kunst kan daarom moeilijk bestaan zonder een publiek. Hoe kan je dat publiek bereiken, wat kan je gebruiken om dat publiek te overtuigen om naar jouw werk te komen kijken en vooral welke hulpmiddelen biedt de hogeschool om je daarbij te ondersteunen. Dat zijn de aspecten die aan bod komen in deze workshop. Deze workshop staat open voor studenten, alumni en docenten van LUCA School of Arts.

In line with OFSTED expectations make sure NQTs are up to speed on effective behaviour management and relationship building in the classroom. Course Category Behaviour and Relationships Meeting emotional needs Inclusion Description This is our lead workshop/training day on behaviour and relationship work aimed at NQTs. Recent OFSTED changes make Behaviour and Classroom management of NQTs a particular focus for inspections. Are your NQTs teaching the behaviours children need to succeed? Can they articulate these behaviours? This training provides a values primer and a practical guide to successful innovative strategies for improving behaviour and strengthening relationships for challenging children and young people of all ages. Not just another day on ‘Behaviour Management’ – our day goes well beyond a rewards and sanctions approach to ‘behaviour’. We will be focused on those young people for whom rewards and punishments do not always work and who confuse the adults who work with them. We aim to take a relationships based approach and to give those attending an opportunity to think more deeply about why young people do the things they do and what our part as adults is in creating, sustaining and changing these behaviours. The day gives those present opportunities to reflect on their attitudes and practice in relation to children’s behaviour and relationship building. If your usual approaches to managing behaviour aren’t working with particular individuals then take a tour through this range of cutting edge strategies for bringing about positive behaviour change, and for meeting challenging emotional needs. Learning Objectives Reinforce and affirm good practice Re-energise, stimulate and challenge thinking about inclusion of challenging young people and children Increased understanding about behaviour and emotions Increased confidence in managing challenging pupils in childcare settings mainstream schools Access to a wider range of practical strategies to impact on behaviour problems Opportunity to reflect on professional attitudes and behaviour towards families and children and young people Learn new skills and processes to make inclusion successful Who Is It For? Primary and secondary NQTs Course Content The course answers the questions: Are there any new ways to include our most challenging young people? Should we focus on behaviour or relationships? How do we go about including high profile children or young people? Can we find an alternative to exclusion? – What would a relationship policy look like? The following are some of the key themes and tools we are likely to explore during the day Getting the welcome right for the most challenging Encouraging Getting the best from the most challenging Circle of Courage Belonging Achievement Generosity Independence Active listeningV Listening to the person underneath the behaviour Compass of Shame – which directions do children and young people head when they feel shame? And what helps children work through these feelings in more healthy ways? Involving other children and young people in solutions and interventions Circles of friends:Peer supportCounselling and mediationTeam Problem Solving Solution Circles:A 30 minute group problem solving process to get Teams ‘unstuck’ and to generate positive first action steps

A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. Course Category Problem Solving Description A Solution Circle is a 30 minute creative Problem Solving Process for getting unstuck…Ideal for busy people! lt was designed by Marsha Forest & Jack Pearpoint. This is a short and powerful tool. It is effective in getting “unstuck” from a problem in life or work. Solution Circles are tools of “community capacity”. It assumes and demonstrates that nearby people – in any community or work place have the capacity to help – if asked. It requires a person to ASK – not an easy thing in our culture of privacy and “do it alone”. This tool puts all the values we espouse into practice and demonstrates that TOGETHER WE’RE BETTER. In this training you will learn how to set up and facilitate Solution Circles  Learning Objectives For participants to learn how to facilitate a Solution Circle For participants to understand the underlying rationale and ethos of this way of working For participants to learn the power of team work and problem solving when including challenging individuals Who Is It For? Team Around the Child agencies Parents and Professional working together Families Multi Agency Teams Social workers CAMHS teams Year Managers Primary and secondary staff teams Early Years and School based Practitioners Heads and Deputies SENDCOs Advanced Skills Teachers Primary and secondary teachers Local Authority Support Services Course Content This can be introduced in a twilight, half day or even a full day workshop with individualised coaching. We will provide background context for this approach and will directly model the process with real live issues facing participants. So bring your most challenging concerns to this training. The course answers the questions: What to when you are stuck Can we find an alternative to permanent exclusion or special unit or school placement? Struggling with a child for whom praise is ineffective? Feeling isolated in your responses to a child’s needs? Worried about where your instinctive reactions are leading you? Cannot seem to get any consensus view of a young person’s behaviour/needs amongst all the family and professionals involved – is everyone pulling in different directions? We will cover: Setting the tone Background and detailed teaching of process Inclusion values underpinning this work Graphic and process facilitation skills Processes modelled and opportunities to try process out with coaching Practical setting up of insights and solutions circles Lessons learned

Project Leadership Skills (Virtual) To be effective within an organization, project managers need to have a wide variety of skills and abilities. Included among these are: creating and executing on a vision; motivating others; influencing without authority; networking; communicating up, down and laterally; negotiating; managing stakeholders; and managing conflict. This highly interactive workshop focuses on building the soft skills that are critical to leading a team and creating sustainable business change. Participants will gain insight into the social science as well as the brain science behind motivating and empowering others. They will learn and experiment with a variety of influencing strategies and tactics. Working in pairs as well as small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to everyday challenges. Participants will also discover their personal communication preferences, strengths, and blind spots and will gain insight into how best to communicate with others they find 'difficult.' They will gain insight into managing the people side of change, learning strategies for dealing with each step in the process. Hands-on negotiation and conflict management activities enhance the theoretical learning, grounding it in real life and making it actionable. Interweaving role play with experiential learning and group activities, this course will help participants refine a skill set that is invaluable to their organization, and one that transfers easily across their professional and personal lives. What you will Learn At the end of this course, you will be able to: Explain the importance of vision in driving motivation and engagement Apply science-based research to better motivate those around you Strategically leverage both personal and positional power to achieve positive project results Determine influencing and networking strategies needed for personal growth Identify ways to problem solve communication challenges when others have different personality styles Connect stakeholder expectations to project success criteria Assess key stakeholders across various dimensions of complexity Apply the four rules of principled negotiation to a real-life conflict situation Recognize key aspects of a physiological response to conflict Utilize selected tools and techniques to 'defuse' an emotional situation Leverage various strategies and tactics to successfully deal with ambiguity at work Getting Started / Foundation Concepts Introductions Course structure, goals, and objectives Beginning a personal action plan Managing Vision and Purpose / Motivating Others Communicating and aligning around vision Tying the present to the future The importance of purpose The art and science of motivation Networking and Influencing Positive politics and project success Types of power within organizations Power and influence Networking best practices Communication The medium and the message Personality and communication styles Communication challenges Stakeholder Management and Negotiation Identifying stakeholders Analyzing stakeholders Negotiation basics Principled negotiation Conflict Management Dynamics of conflict The anatomy of conflict Conflict management approaches and tools Dealing with ambiguity

Learn Clinical Coding! Master Inpatient DRG development in our comprehensive training. Understand ICD-10, CPT, and HCPCS principles for accurate reimbursement. Boost your career in healthcare with expert-led sessions. Join now & unlock new opportunities!