238 Courses

Introducing the Dating Profile Helper Package: Crafting an Authentic and Irresistible Online Dating Presence Are you looking to enhance your online dating experience and attract meaningful connections? Miss Date Doctor’s Dating Profile Helper Package offers you expert guidance and support to create a captivating and genuine dating profile that reflects your true self and increases your chances of finding a compatible partner. In today’s digital age, your online dating profile serves as your first impression. Our experienced dating experts are dedicated to helping you stand out in a positive way, guiding you through the process of crafting a profile that effectively showcases your personality, interests, and aspirations. Here’s how the Dating Profile Helper Package can support you: Personalized Consultation: Our dating experts will conduct a personalized consultation to understand your personality, values, and dating goals. Profile Optimization: We’ll assist you in optimizing your profile text, ensuring it effectively communicates who you are and what you’re looking for. Photo Selection: We’ll provide guidance on selecting photos that capture your authentic self and present you in the best light. Creating a Compelling Bio: We’ll help you write a compelling and engaging bio that intrigues potential matches and sparks conversations. Highlighting Your Unique Qualities: Our experts will assist in showcasing your unique qualities, hobbies, and interests that make you stand out. Navigating Online Etiquette: We’ll provide guidance on how to interact with matches, initiate conversations, and maintain engaging communication. Building Confidence: The Dating Profile Helper Package can boost your confidence by providing expert support in creating a profile that accurately represents you. Attracting Compatible Matches: We’ll work towards attracting matches who resonate with your values and are looking for a genuine connection. The Dating Profile Helper Package at Miss Date Doctor is designed to empower you to present your authentic self in the online dating world. Our experienced dating experts provide personalized guidance and practical tips to enhance your online presence and increase your chances of finding meaningful connections. Invest in your dating success and take the first step towards crafting an appealing online dating profile with the Dating Profile Helper Package. Embrace the opportunity to authentically showcase who you are and attract matches that align with your values and aspirations. Let our experts guide you towards a more rewarding and fulfilling online dating experience. Get 6 new photos as a bonus 3 sessions x 1 hour https://relationshipsmdd.com/product/dating-profile-helper/

Working bone is a skill that was fundamental in our journey towards making evermore effective and reliable tools. Not only that, but making bone tools allowed our hunter gatherer ancestors to share a deeper connection with, and understanding of, the animals that they were so dependent upon. Bone is a versatile material that can be used to make all manner of tools and craft items ranging from simple designs to very intricate. The use of bone allowed us to create more effective clothing utilising tools such as needles and pins. In a recent find, 500,000 year old bone tools were found in Britain, highlighting just how far back in time they stretch. During this one day course you will learn techniques on how to work bone using other natural materials such as flint and abrasive stones, as well as selecting specific bones to create different tools. The day will start by discussing some of the points above and looking at a selection of bone tools such as: Needles, Awls, Harpoons, Spear tips and Arrow heads. After that it will be time for you to warm up those fingers and start shaping some bone! About us and the venue: Jack Raven Bushcraft was founded in 2011 and we've been delivering bushcraft, craft and foraging courses since then from our 30 acre private ancient woodland on the Kent Downs in an area of outstanding natural beauty. Courses in the summer are held outdoors in our woodland camp complete with covered work areas, an outdoor kitchen and a composting loo. Courses in the winter are held in our workshop in a converted barn. What's included in the price? We include all tools, equipment and materials. The kettle is always on for tea and coffee. Cancellation policy Strict - Cancellation and a full refund can be obtained up to 8 weeks before the course starts

Inclusion Facilitation (IF) is an approach to enhancing the inclusion, in a mainstream community of any child or young person who is experiencing difficulties in the world because of disability, personal crisis or because of their challenging behaviour towards others. The IF approach works by mobilising the young person’s natural supports to provide support and engage with the person in difficulty. Inclusion Facilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Uniquely, the work is carried out under the close clinical supervision of a practicing psychologist. What is Inclusion Facilitation Work? ‘We do whatever it takes!’ Usually a Person Centred Planning event would be carried out using the PATHor MAP process – majoring on dreams and goal setting leading to precise action planning.  An experienced psychologist alongside the inclusion facilitator would carry out a PATH. A large graphic will be one of the outcomes of the meetings this is a great visual record and a shared memory of the event. This will also inform the priorities for the inclusion facilitation work Optionally following the PATH event a ‘scoping report’ is created outlining what Inclusion Facilitation could offer and highlighting what dreams and goals the individual has. The PATH is also provides a good opportunity for the Facilitator to meet the focus person in a comfortable positive environment. 12 weekly visits from the Inclusion Facilitator followed by 5 monthly visits is our preferred model but we can be flexible with the delivery of this input. This is just a guideline, however we have received good results using this time frame. After this intensive input the Inclusion Facilitator will hand over to the existing family, carers and PA team to carry on where he or she has left off. This transition time is planned from the outset. An experienced psychologist is there to support the facilitator at all times and will guide all work done by the inclusion facilitator.  Is this just Support work? No! This is proactive engagement – doing whatever is required. We are not just passively or reactively providing what is asked for – we are actively pursuing a good life for the individual. Our work is built on careful research around a person’s interests and what opportunities exist locally. We carry out community mapping.  We actively work to tackle an individual’s own resistance and reluctance to engage more socially. We actively engage with people in social settings that the individual attends to build bridges and connections – we are bridge builders. We build circles around a person. We create the conditions in which friendships can flourish. We have direct psychological supervision and support throughout. This work is short term and intense. Enjoy participating in a multimedia workshop that will challenge, entertain and reach for your emotions. Learning Objectives 1.To be able to understand the values and wider context of inclusion. 2.To be able to set up and run an ‘Inclusion Facilitation project to improve the life chances and connections of a child or young person. 3.To understand and be able to maximise the power of the peer group in supporting relationships, achievement and behaviour. Course Content The course answers the questions: What do you do with the child who is isolated by their aggression and anger, through being different, disabled or new to the school or community? Practically how do we go about including high profile children or young people? How can we help some children be friends? We will cover:  Inclusion values underpinning this work The Intentional Building of Relationships –‘Inclusion Facilitation’ work as an example Not doing it alone – The Importance of Teams in developing inclusive practice Practical setting up and running of IF work Lessons learned Stories of IF work

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!

Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. Course Category Inclusion Person Centred Planning Visioning and Problem Solving Peer Support Description Person Centred Rehabilitation Person centred rehabilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Usually, the work is carried out under the close clinical supervision of a practicing psychologist. PERSON CENTRED PLANNING A Person Centred Planning event would be carried out using the PATH or MAP process – majoring on dreams and goal setting leading to precise action planning. Facilitators would carry out the PATH or other person centred process. A large graphic will be one of the outcomes of the meetings this is a great visual record and a shared memory of the event. This will also inform the priorities for the later follow up inclusion facilitation work. Following the PATH event a ‘scoping report’ is created outlining what Inclusion Facilitation could offer and highlighting what dreams and goals the individual has. INCLUSION FACILITATION The PATH is also provides a good opportunity for the Facilitator to meet the focus person in a comfortable positive environment. Agreed visits from the Inclusion Facilitator are then carried out over a 3 month period. After this intensive input the Inclusion Facilitator will hand over to the existing family, carers and PA team to carry on where he or she has left off. This transition time is planned from the outset. An experienced psychologist needs to be there to support the facilitator at all times and will guide all work done by the inclusion facilitator. Is this just Support work? No! This is proactive engagement – doing whatever is required. This is not passively or reactively providing what is asked for – we are actively pursuing a good life for the individual. The work is built on careful research around a person’s interests and what opportunities exist locally There is community mapping There is work to tackle an individual’s own resistance and reluctance to engage more socially There is a need to engage with people in social settings that the individual attends to build bridges and connections – we are bridge builders You will need to build circles around a person There is a need to create the conditions in which friendships can flourish There is a need for direct psychological supervision and support throughout This work is short term and intense. The facilitator’s main aims will vary depending on the dreams and goals of the focus person. The basic aim of the inclusion facilitator is to better the focus person’s quality of life. Learning Objectives 1 To create a better life for the Individual. 2 Give Individual and family a clear vision of a good life and to support first steps towards this 3 To maximise individuals inclusion and connection with the wider community. 4 To help with friendship, social connection and education 5 To increase confidence, social skills and presence in their local community and to pursue goals and dreams. Who Is It For? Anyone who is involved in the rehabilitation of children or adults who have become disabled through accident or trauma and who is committed to helping them get their life back on track. Course Content Understanding ordinary needs – the dimensions of social inclusion Pursuing the dreams and goals of the individual Improving social skills Community Mapping Being comfortable in social environments Developing conversational skills Having a positive mindset Staying physically active Building relationships Help in meeting new people Create natural circles of support Creating a community circle Having positive body language Employment of support staff Pursuing personal interests   If you like this you will almost certainly enjoy: Person Centred Planning using PATH and MAPs

Having difficulty implementing '5S'? This workshop focuses on how to make '5S' meaningful to people, and how to link it with company goals. “5S, that’s just all about keeping things organized and tidy, isn’t it? Or maybe you have heard someone say: “Why make a big deal out of cleaning up?” But 5S is not really about the aesthetics of the work place, or even about the efficiency gains you will achieve (typically, 10% to 30% can be easily achieved). The real benefit of 5S is the introduction of standardised operational practices to ensure efficient, ergonomic, repeatable, safe ways of working. This brings many benefits: higher quality, lower costs, reliable deliveries, increased morale, and improved safety … to name but a few. It will also result in a highly visual workplace which contributes to achieving one of the most important results of 5S : making problems immediately obvious. 5S works by helping the team eliminate the seven wastes of lean manufacturing: Waste in Transport, Inventory, Motion, Waiting, Over-processing, Overproduction, and Defects.It is therefore one of the most powerful Lean Tools, and provides a stable foundation upon which to build all of your other improvement programs, Lean Tools and Practices. It is also one of the simplest to implement, and can be applied within your manufacturing environment, office processes or even within a service industry. 5S is a team approach and requires the participation of everyone within the area in which it is applied to be effective. Structure of the Course This one day course will provide you with a comprehensive overview of the 5S Process and how you can implement it to your organization. It's approach is based on the experienced gained by implementing '5S' in many organizations. It focuses on highlighting what makes '5S' programmes fail, how to engage your personnel in defining and deploying your '5S' strategy, and how to sustain it over time. This workshop looks at '5S' as an integral part of your day to day operational management system, rather than an activity to be managed as a stand alone project. Who Would Benefit from this 8D Approach? Owner-managers, managers at all levels in the organisation, especially team leaders, supervisors and middle managers. Delivery The workshop is delivered through virtual tutor-led live classes. Cost £200 + VAT Booking terms and conditions If you are unable to attend, please let us know 2 weeks in advance of start date. Refunds will be considered on an individual basis. Failure to attend will still require full payment. Ticket fee provides online access for one person only connected from one device. In-House Option This workshop can also be delivered in-house as a stand-alone training workshop or integrated into wider improvement activities. In-house training also provides the opportunity to tailor training to the specific needs of your organization and use an actual problem to demonstrate the methodology. Contact us for bespoke pricing at compete@cforc.org We will be happy to discuss Problem Solving in the context of your own business needs. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Why Learn Sketchup and Stable Diffusion Rendering Course? Course Link SketchUp and Stable Diffusion Rendering Course. An AI image creation course designed to explore AI image creation techniques and master the use of advanced AI technology. You'll learn Ai 3D modeling, advanced rendering, and lighting techniques. Duration: 16 hrs. Method: 1-on-1 Online Over Zoom is also available. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. The Sketchup and Stable Diffusion Rendering Course equips students with comprehensive skills for visually stunning Ai (Artificial intelligence) 3D models and renderings. Master Sketchup's user-friendly interface, advanced rendering techniques, and stable diffusion rendering. Hands-on exercises and real-world projects enhance learning. Ideal for architecture, interior design, product development, and visualization careers. The Sketchup and Stable Diffusion Rendering Course equips students with comprehensive skills for visually stunning Ai (Artificial intelligence) 3D models and renderings. Master Sketchup's user-friendly interface, advanced rendering techniques, and stable diffusion rendering. Hands-on exercises and real-world projects enhance learning. Ideal for architecture, interior design, product development, and visualization careers. Sketchup and Stable Diffusion Rendering Course (16 hours) Module 1: Introduction to Sketchup (2 hours) Overview of Sketchup software and interface navigation Basic drawing tools and geometry creation techniques Module 2: Texturing and Materials (2 hours) Applying textures and customizing materials Exploring texture mapping and material libraries Module 3: Lighting and Shadows (2 hours) Understanding lighting principles and light placement Creating realistic shadows and reflections Module 4: Advanced Modeling Techniques (3 hours) Creating complex shapes and utilizing advanced tools Working with groups, components, and modifiers Module 5: Stable Diffusion Rendering (2 hours) Introduction to stable diffusion rendering Configuring rendering settings for optimal results Module 6: Scene Composition and Camera Setup (2 hours) Exploring composition principles and camera perspectives Managing scenes and creating walkthrough animations Module 7: Rendering Optimization (2 hours) Optimizing models for faster rendering Using render passes and post-processing techniques Module 8: Project Work and Portfolio Development (1 hour) Applying skills to complete a real-world project Showcasing work in a professional portfolio Optional: Installing Stable Diffusion and Python (Additional 10 hours) Module 1: Introduction to Stable Diffusion and Python Overview of Stable Diffusion and Python's significance Module 2: System Requirements Hardware and software prerequisites for installation Module 3: Installing Python Step-by-step installation process for different OS Module 4: Configuring Python Environment Setting up environment variables and package managers Module 5: Installing Stable Diffusion Downloading and installing the Stable Diffusion package Module 6: Setting Up Development Environment Configuring IDEs for Python and Stable Diffusion Module 7: Troubleshooting and Common Issues Identifying and resolving common installation errors Module 8: Best Practices and Recommendations Managing Python and Stable Diffusion installations Module 9: Practical Examples and Projects Hands-on exercises demonstrating usage of Stable Diffusion and Python Module 10: Advanced Topics (Optional) Exploring advanced features and techniques Stable Diffusion UI v2 | A simple 1-click way to install and use https://stable-diffusion-ui.github.io A simple 1-click way to install and use Stable Diffusion on your own computer. ... Get started by downloading the software and running the simple installer. Learning Outcomes: Upon completing the Sketchup and Stable Diffusion Rendering Course, with a focus on AI image rendering, participants will: Master AI Image Rendering: Gain expertise in using AI-powered rendering techniques to create realistic and high-quality visualizations. Utilize Sketchup for 3D Modeling: Navigate the software, proficiently use drawing tools, and create detailed 3D models. Optimize Renderings: Apply AI-based rendering to optimize model visuals, achieving faster rendering times and superior image quality. Implement AI-driven Lighting and Shadows: Utilize AI algorithms for lighting placement, shadows, and reflections, enhancing realism in renderings. Create Professional Portfolio: Showcase AI-rendered projects in a professional portfolio, highlighting advanced image rendering skills. Note: The course focuses on AI image rendering using Sketchup and Stable Diffusion techniques, empowering participants with cutting-edge skills for creating exceptional visual representations.

Who is this course for? Sketchup Artificial Intelligence Training Course. Mastering SketchUp Artificial Intelligence (AI) is essential for designers, offering automation, efficiency, and innovative solutions. It saves time, enhances visualizations, fosters collaboration, and future-proofs skills, ensuring a competitive edge in the design industry. Click here for more info: Website How to Book? 1-on-1 training. Customize your schedule from Mon to Sat from 9 am to 7 pm Call to book  Duration: 16 hours. Method: In-person or Live Online Sketchup and (Artificial Intelligence) Stable Diffusion Rendering Course (16 hours) Module 1: Sketchup Fundamentals (2 hours) Sketchup software overview and interface navigation Introduction to basic drawing tools and fundamental geometry creation techniques Module 2: Texturing and Material Mastery (2 hours) Application of textures and customization of materials Exploration of texture mapping and comprehensive material libraries Module 3: Illumination and Shadows (2 hours) Comprehending lighting principles and strategic light placement Crafting realistic shadows and reflections Module 4: Advanced Modeling Techniques (3 hours) Creating intricate shapes and harnessing advanced modeling tools Efficiently managing groups, components, and modifiers Module 5: Stable Diffusion Rendering (2 hours) Initiating stable diffusion rendering Optimizing rendering settings for superior outcomes Module 6: Scene Composition and Camera Configuration (2 hours) Exploring composition principles and camera perspectives Scene management and creation of captivating walkthrough animations Module 7: Rendering Optimization Strategies (2 hours) Techniques for optimizing models to expedite rendering Application of render passes and post-processing methods Module 8: Real-World Projects and Portfolio Building (1 hour) Application of acquired skills in completing authentic projects Professional portfolio presentation techniques Optional: Stable Diffusion and Python Installation (Additional 10 hours) Module 1: Introduction to Stable Diffusion and Python Comprehensive understanding of Stable Diffusion and Python's significance Module 2: System Prerequisites Hardware and software requirements for successful installation Module 3: Python Installation Guide Step-by-step installation process for various operating systems Module 4: Configuring Python Environment Configuration of environment variables and package managers Module 5: Stable Diffusion Installation Downloading and installing the Stable Diffusion package Module 6: Setting Up the Development Environment Configuration of integrated development environments (IDEs) for Python and Stable Diffusion Module 7: Troubleshooting and Common Issues Identification and resolution of common installation errors Module 8: Best Practices and Recommendations Effective management of Python and Stable Diffusion installations Module 9: Practical Applications and Projects Hands-on exercises exemplifying the practical usage of Stable Diffusion and Python Module 10: Advanced Topics (Optional) Exploration of advanced features and techniques Stable Diffusion https://stablediffusionweb.com https://stable-diffusion-ui.github.io https://stability.ai/stable-diffusion Upon successful completion of the Sketchup and Stable Diffusion Rendering Course with a focus on AI image rendering, participants will achieve the following: 1. Mastery of AI Image Rendering: Attain expertise in employing AI-powered rendering techniques to produce realistic and top-quality visualizations. 2. Proficiency in Sketchup for 3D Modeling: Navigate the software adeptly, utilize drawing tools with proficiency, and craft intricate 3D models. 3. Enhanced Rendering Optimization: Implement AI-based rendering to enhance model visuals, resulting in faster rendering times and superior image quality. 4. Application of AI-driven Lighting and Shadows: Employ AI algorithms for precise lighting placement, shadows, and reflections, elevating the realism of renderings. 5. Development of a Professional Portfolio: Present AI-rendered projects within a polished professional portfolio, highlighting advanced image rendering capabilities. 1. Mastering Sketchup: Attain proficiency in Sketchup, a renowned and user-friendly 3D modeling software, equipping you with the skills needed to adeptly create and manipulate 3D models. 2. Advanced Rendering Expertise: Explore stable diffusion rendering, an avant-garde technique that simplifies the creation of realistic and high-quality renderings. Broaden your rendering capabilities, producing visually stunning representations of your designs. 3. Practical Industry Applications: Cultivate practical skills relevant to diverse industries, encompassing architecture, interior design, product development, and visualization. Elevate your professional portfolio with captivating renderings that showcase your design prowess. 4. Interactive Learning: Participate in hands-on exercises and projects that promote active learning and the practical application of concepts. Benefit from personalized feedback and expert guidance, ensuring your continuous progress throughout the course. 5. Career Advancement: Elevate your career prospects by adding valuable skills to your toolkit. Proficiency in crafting detailed 3D models and impressive renderings through stable diffusion techniques opens doors to diverse job opportunities within the design and visualization sector. 6. Flexibility and Convenience: Access course materials online and learn at your own pace. Enjoy the flexibility of tailoring the coursework to your schedule, allowing you to harmonize your learning journey with other commitments. Course Advantages: Tailored Learning: Enjoy personalized 1-on-1 sessions, accommodating your schedule from Monday to Saturday, 9 am to 7 pm. Mastery of Sketchup: Develop proficiency in the widely-used and user-friendly 3D modeling software, enabling efficient creation and manipulation of 3D models. Advanced Rendering Proficiency: Acquire expertise in stable diffusion rendering for producing realistic, high-quality renderings that enhance the visual appeal of your designs. Practical Applicability: Develop practical skills applicable across diverse domains, including architecture, interior design, product development, and visualization, enriching your professional portfolio. Interactive Practical Experience: Engage in hands-on exercises with personalized guidance from seasoned instructors, ensuring consistent progress in your skillset. Career Progression: Boost your career opportunities by gaining valuable skills in 3D modeling and generating impressive renderings through stable diffusion techniques. Comprehensive Support: Benefit from free portfolio reviews, mock interviews, and career advice, providing additional resources to enhance your professional journey.

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

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