This Tableau Desktop Training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course is split into 3 phases and 9 modules: Phase 1: AMPLIFY MODULE 1: CHECK ABILITIES Revision – What I Should Know What is possibleHow does Tableau deal with dataKnow your way aroundHow do we format chartsHow Tableau deals with datesCharts that compare multiple measuresCreating Tables MODULE 2: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 3: ADVANCED CALCULATIONS Row Level v Aggregations Aggregating dimensions in calculations Changing the Level of Detail (LOD) of calculations – What, Why, How Adding Table Calculations Phase 2: ANALYSE MODULE 4: EXPAND APPLICATION Making things dynamic with parameters Sets Trend Lines How do we format charts Forecasting MODULE 5: ADVANCED MAPPING Using your own images for spatial analysis Mapping with Spatial files MODULE 6: DATA COMPARISONS Advanced Charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Phase 3: ACT MODULE 7: ADVANCED DASHBOARDS Using the dashboard interface and Device layout Dashboard Actions and Viz In tooltips Horizontal & Vertical containers Navigate between dashboards MODULE 8: PRESENT STORIES Telling data driven stories MODULE 9: ENABLE DECISIONS What is Tableau Server Publishing & Permissions How can your users engage with content This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must bring their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium “Steve not only provided a comprehensive explanation of the content of the course, but also allowed time for discussing particular business issues that participants may be facing. That was really useful as part of my learning process.”Juan C., Financial Conduct Authority “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium
This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group
It is important for Officers to understand the roles and responsibilities, processes and procedures involved when working with Elected Members. They also need to appreciate the significance of Elected Members as the decision-makers in local government. Officers have a responsibility to work and communicate with Elected Members effectively. This very successful course is designed to help Officers with this. Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. To provide managers with the knowledge and understanding they need to have productive working relationships with Elected Members and provide appropriate support. By the end of the course participants will: Understand the roles, responsibilities, processes and procedures in place for working with Elected Members Be able to identify the best way to approach potentially sensitive issues Understand the skills and behaviours required for working effectively with Members Be able to deploy their influencing skills more successfully Review their learning and have an action plan to take back and implement at work Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. 1 Introduction Welcome and introductions Objectives and programme overview 2 Working in a political environment What is political awareness? Contact and experience with Members Importance of the role of Members 3 Why be an Elected Member? Perceptions of what Elected Members are and do Values of Members and their motivations for doing what they do 4 Political decision-making in local government Current challenges and drivers affecting the organisation / the council Roles and responsibilities of Officers and Members Centrality of Members' strategic role 5 (Option) A day in the life of an Elected Member An Elected Member gives a talk about what they do 6 Having a beneficial relationship between Officers and Members 7 Member / Officer communication Discussion of the formal processes, service procedures, etc (whether enshrined in a protocol, Memorandum of Understanding, etc) Response times and requirements Procedures required by Heads of Service [if appropriate] 8 Influencing styles and strategies Different forms of power and how they impact Developing an appropriate 'influencing style' Exploring strategies for improving communication and influencing at work 9 Review and evaluation Review and evaluation of learning Personal action plans
This is an incredibly practical programme which has been developed to enable participants to improve their memory skills. The session focuses on specific techniques that can be used to improve retention of information. It also introduces the principles of mind-mapping By the end of this programme participants will be able to: Explain how our brain processes and stores information Describe the difference between short-term and long-term memory Use specific techniques to improve retention Explain the principles of mind mapping Be able to use mind maps to plan and order information Each participant, no matter how poor they believe their memory to be, will by the close of the session have learnt techniques that enable them to memorise 53 items in a prescriptive order - a massive boost to their confidence in their memory skills. 1 An introduction to the brain's functions Introductory brain-training How the brain works Left / right brain function Short-term and long-term memory Barriers to a good memory 2 Memory techniques Tips and techniques for improving memory Basic word association Chaining and linking Touchstone techniques Use of mnemonics Memory hooks Remembering names 3 Maximising memory Minimising barriers The importance of sleep and diet Supplements which may affect memory 4 Mind-mapping Purpose and principles Creating a mind map Use of colour to delight the eye and tickle the brain How to use the output from a map
This one-day programme explores the role of intellectual property (IP) in relation to innovation and creativity. It examines the different forms as well as the key processes, together with some of the oddities and idiosyncrasies of the legal regime that protects IP. It delves into the various IP models you should be aware of as well as key IP facts and figures and current IP trends across the global economy. This session is designed to give you a deeper understanding of: The main forms of intellectual property The importance of IP - both to your organisation and to the wider economy The key processes in the creation, commercial exploitation, and legal protection of IP The different models for the use of IP Some more advanced concepts for reviewing, valuing and managing IP 1 Main forms of intellectual property (IP) Patents Trademarks Copyright Design Trade secrets 2 Global IP business context Global IP facts and figures Figures for key jurisdictions Analysis of a company using IP data IP trends Overview of the key entities in the IP sector 3 Key IP processes IP creation IP portfolio management IP enforcement IP exploitation IP risk management 4 IP models IP models explained IP licensing IP litigation 5 IP concepts The IP maturity ladder Relative IP value and risk Axis of control 6 IP as an asset class Costs Valuation Financial perspective
Is your lifestyle too sedentary? Do you feel sluggish by the end of the day? Wrecked by the end of the week? You need to vary your regime at work. You need to work with, rather than against, your physicality in order to boost your energy levels in a sustainable way - without recourse to coffee, sugar or other stimulants. Take away: Four quick and easy ways to make you feel good and re-energised. You will have the opportunity to: Explore how even just small amounts of physical activity can impact your mental and general health and wellbeing, creativity and productivity. Learn what to do about a sedentary lifestyle Get some tips on what to do about your posture Deskercise - try out some easy stretches and exercises you can do at your desk
This very practical and focused one-day workshop enables end-users, technical experts, proponents, internal customers and other key stakeholders to work with procurement and contracting to develop effective specifications and scopes of work, to ensure fit-for-purpose outcomes. The programme empowers participants to collaborate with all key stakeholders. This workshop will help participants: Understand the importance and value of clear and effective specifications Differentiate between the different methods of creating specifications and when to apply them Develop robust specification templates to ensure consistency Understand the use of appropriate language (critical to creating effective specifications) Appreciate the need to develop specifications in cooperation with stakeholders Make use of techniques such as value analysis and value engineering to define 'fit for purpose' in the context of creating effective specifications Embed key KPIs into the specification to ensure delivery Manage and mitigate legal and contractual risks in the specification 1 Introduction Learning outcomes Learning styles Plan for the day 2 The importance of effective specifications Scopes of work Impact of poor scopes of work Examples of costly errors 3 The critical role of language Terminology in creating effective specifications and scopes of work Problems of communication Lack of detail or too prescriptive 4 Encouraging cooperation Technical and commercial experts with responsibility for developing robust effective specifications and scopes of work Managing stakeholders' expectations Working with contractors 5 Types of specification Exploring and using the various approaches to the development of appropriate specifications and scopes of work Output Performance Technical Functional Solutions-based 6 The role of value analysis Value engineering in the process of developing scopes of work and specifications 7 Specifications and contracts The legal and contractual impact of poor specifications and scopes of work How to embed scopes of work and specification outputs into tender and quotation documents 8 Specifications as a management tool Developing KPIs and SLAs framed around robust effective specifications and scopes of work Negotiating with contractors Negotiating with stakeholders
Harness the energy is an explorative workshop introducing the notion of utilising and intuitively listening to the energy shared between a group of people. Whether we realise it or not, we all give off certain energies at any time. These energies can affect change, sometimes positively, sometimes negatively. This workshop enhances understanding of the power of our own energy transmissions through the use of compliciteÌ-based theatre techniques and exercises. This workshop will help participants become active and aware listeners, able to work better collaboratively to produce strong results. It will demonstrate the power of our own individual energy and the positive impact we can have when we learn to utilise the energy beneficially in different situations.
ChatGPT, along with other AI tools, aims not to replace the human touch in management, but to enhance it. By addressing repetitive, daily tasks, these tools free up managers to concentrate on core responsibilities like strategic decision-making, team development, and innovation. As we move further into the digital age, integrating tools such as ChatGPT isn't a luxury; it's the future of proactive leadership. In this guide, we'll delve into 10 practical ways through which AI can elevate your efficiency and refine the quality of your work. Gain familiarity with prominent AI tools in the market Efficiently compose and respond to emails Generate concise summaries of complex reports and data. Obtain quick insights, data, and research across varied topics Streamline the writing of articles, training notes, and posts Craft interview tests, form relevant questions, and design checklists for the hiring process 1 Streamlining emails An inbox can be a goldmine of information but also a significant time drain for managers. Here's how to optimise it: Drafting responses: Give the AI a brief, and watch it craft a well-structured response. Sorting and prioritising: By employing user-defined rules and keywords, ChatGPT can flag important emails, ensuring no vital communication slips through the cracks. 2 Efficient report writing Reports, especially routine ones, can be time-intensive. Here's a smarter approach: Automate content: Supply key data points to the AI, and let it weave them into an insightful report. Proofreading: Lean on ChatGPT for grammar checks and consistency, ensuring each report remains crisp and error-free. 3 Rapid research From competitor insights to market trends, research is a pivotal part of management. Data synthesis: Feed raw data to the AI and receive succinct summaries in return. Question-answering: Pose specific questions about a dataset to ChatGPT and extract swift insights without diving deep into the entire content. 4 Reinventing recruitment Hiring can be a lengthy process. Here's how to make it more efficient: Resume screening: Equip the AI to spot keywords and qualifications, ensuring that only the most fitting candidates are shortlisted. Preliminary interviews: Leverage ChatGPT for the initial rounds of interviews by framing critical questions and evaluating the responses. 5 Enhancing training Especially for extensive teams, training can be a monumental task. Here's how ChatGPT can assist: Customised content: Inform the AI of your training goals, and it will draft tailored content suitable for various roles. PowerPoint design: Create visually appealing slide presentations on any topic in minimal time.
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