Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App
Understand what diversity and inclusion is and how to manage it affectively in the workplace. Course overview Duration: 1 day (6.5 hours) Diversity and Inclusion in the workplace will help you develop an understanding of why diversity and inclusion is important to a business, what it is and how individuals and teams can work effectively together and harness the power that comes from valuing diversity and promoting inclusion. Objectives By the end of the course you will be able to: Describe why diversity and inclusion is important in teams and organisations Explain and overcome unconscious bias and other beliefs that cause exclusion and impact the workplace Recognise your own diversity and understand the value of diversity and inclusion in teams Develop an Action Plan to create an inclusive work climate Content Understand Diversity and Inclusion What the Equality Act 2010 says about diversity Understanding protected characteristics Learn how to create an optimum climate to unlock the power of a diverse teams Understanding Yourself and Unconscious Bias Identify your own unique characteristics and how these could impact your performance Examine self-limiting beliefs and how these can impact personal performance Experience how unconscious bias impacts our information gathering, problem solving, judgement and decision making Creating a Diverse and Inclusive Team Climate Understand the importance of respect, the role of trust and what valuing diversity really means Apply the ABC Model to the creation of a diverse climate:Awareness – be alert, self-aware and aware of othersBoundaries – understand how things can go wrong when working with others: boundaries, banter and bullyingCoaching – learn listening and coaching skills to promote inclusion Create an achievable, personal action plan that can be applied immediately in the workplace to improve diversity, promote teaming and create an inclusive work climate
Learn effective strategies and leadership skills to thrive in today's remote work landscape. Elevate your team's performance, no matter where they are located. Course overview Duration: 1 day (6.5 hours) Remote teams present a specific set of challenges to their managers. Such challenges include communication, task allocation and performance management. This workshop is designed for managers who run teams that spread over more than one location, nationally or internationally, and who wish to find ways to enhance teamworking in these conditions. Objectives By the end of the course you will be able to: Identify key actions to take to manage team performance remotely Implement a communications plan for use within the team Allocate tasks to team members to build a culture of teamworking across the different locations Involve your team members in planning team activities Use visits to each location to maximum effect Content Communication to ensure inclusivity How do team members find out the latest news? Identifying what needs to be known by all A team communication plan Effective virtual meetings Manage performance from a distance Principles of Smart Working Involving the team in planning activities Allocating tasks and objectives across the team Identifying areas of expertise Deciding key areas of responsibility per location Identifying, and dealing with, the different levels of performance Maximising time in each location Setting the tone of a visit – from ‘inspection’ to ‘social call’ Considering what team members expect and need from your presence Identifying what needs to be prepared by the team for your visit Making contact with your team members while you are there Action planning Identifying and planning next steps
Learn the skills and mindset to become a business partner, align your expertise with the organisational goals, drive growth, and shape the future of your company. Course overview Duration: 1 day (6.5 hours) This is a highly interactive and practical course which will help you to understand the role of Business Partnering and the key skills needed to be successful in the role. The course is designed specifically to give you an opportunity to explore the role and test a range of techniques to improve your strategic working as well as your influencing and relationship building skills. This course is aimed at individuals who work cross-functionally and with other people to achieve business results and is particularly helpful for those who engage frequently with senior managers and executives. Objectives By the end of the course you will be able to: Describe the role of Business Partner and the benefit to the business Develop stronger engagement with all internal and external stakeholders Influence without authority Build positive relationships Handle robust conversations Be forward thinking, not reactive Act as a change agent Communicate with confidence and credibility Content Understanding the role of the Business Partner What is Business Partnering from an individual, departmental and business view Using a psychometric test to look at where your strengths are and how you can use them effectively in the role Developing Relationships Creating a powerful first impression. Communication skills Understanding different communication styles Being more proactive in developing key relationships Stakeholder engagement Presenting ideas in a confident and articulate way Understanding and developing trust Connecting with people Networking Influencing and Negotiating Influencing and persuading others Dealing with conflict and difficult conversations Becoming a trusted advisor/Business Partner Advanced questioning skills and techniques to get to the root of a problem Strategic Thinking Develop the mind-set and strategic capability to play a more proactive leading role in the business
Develop the commercial awareness, financial knowledge and strategic thinking capabilities, to influence the direction of the business Course overview Duration: 2 days (13 hours) This course is aimed at managers who want to develop their commercial awareness, financial knowledge and strategic thinking capabilities, so that they can influence the direction of their business and deliver to their full potential. Day one of the course provides the skills and insights to make sense of your company’s financial position and performance. Day two helps delegates to consider the strategic thinking tools required to plot the forward course needed to maximise the potential of the business. As well as looking at how to make effective business decisions, this course gives a good grounding in finance and profitability. As a two day programme, day one provides the skills and insights to make sense of the company’s financial position and performance. Day two then considers the strategic thinking tools needed to plot the forward course needed to maximise the potential of the business. Objectives By the end of the course you will be able to: An understanding of the balance sheet, profit and loss account, cash flow and statutory and management accounts Learnt to correctly employment key financial ratios to analyse your business A practical definition of strategy analysis tools to examine the current environment and capabilities Steps to devise a mission and vision statement Recognition of the skills and resources needed to achieve the vision Generation of appropriate strategic and tactical commercial objectives Content What is Strategy Defining Strategy Strategic thinking Strategic models Commercial thinking – what is money? Where are we now STEEPLE analysis SWOT Analysis P&E forces at work Political distortions in capitalist markets Where are we trying to get to Setting the mission and vision Creating a BHAG Strategies for deflation and inflation The role of banks Commercial and investment banking Fractional reserving Securitisation How to get there Skill gap analysis Business Process Re engineering The role of creativity How to get there Getting the team on board Individual and team motivation The power of the brand Overcoming challenges Debt and deleveraging Change management Creating value Discounted Cash Flows Building the business case Asset Valuation techniques Making it happen Turning Strategic Thinking into Strategic Plans Scenario planning for an uncertain future Creating commitments and lock in Discussion and review Time will be set aside during the course for review sessions with time for questions, answers and action learning.
DATE: Thursday 19th December TIME: 6:30pm LOCATION: Studio A Frank Capra's masterpiece about love, family, the festive season and faith in yourself is coming to the big screen at Central Film School, and we want to invite you to see it! Come experience the magic of a true timeless classic, as we follow George Bailey's trials and tribulations through life, culminating in a fantastical Christmas Eve where he dares to ask; what if I'd never been born at all? Book your tickets in advance to secure your seat at this holiday classic!
DATE: 31st October 2024 TIME: 4pm LOCATION: Studio A Horror fans rejoice, this year you're getting not one but two big screen scares! That's right, on Halloween night we'll be kicking things off with a modern classic of the genre, Robert Eggers' twisted, Lovecraftian story of two lighthouse keepers fighting the elements, insanity and each other. Then after we'll be screening a mystery film that will be announced that night. Don't miss out, book your tickets to this unique double-screener now! We are very grateful to Arrow Films for sponsoring this event.
DATE: 16th October TIME: 4pm LOCATION: Studio A Facilitated by Alice Coyle, Student Counsellor. This is a practical workshop to help you understand more about how anxiety, perfectionism and procrastination can get in the way of getting stuff done. Whether you are a starter or into your final year after, It is timed to help you prepare for your first written assignment and set you up for the year ahead, without all the angst that can really hold you back from enjoying your college studies and life. You may feel that no one else struggles as much as you do over getting work submitted. By sharing ideas and tips together in small groups of 2 or 3, you may be surprised by how much you have in common with your fellow students and how much you can learn from each other.
Changing seasons impact our hair in unique ways, from winter dryness to summer humidity. By adjusting your hair care routine with each season, you can keep your hair healthy, strong, and vibrant. Here’s a look at practical tips for maintaining beautiful hair all year round. Winter hair care tips In winter, cold air and indoor heating can strip moisture from hair, leaving it dry and prone to breakage. Protecting your hair from these harsh conditions is essential. Moisturize regularly Dry winter air can make hair feel rough and brittle. Use a moisturizing shampoo and conditioner to keep your hair hydrated, and consider using a leave-in conditioner for extra protection. This helps seal in moisture, making hair less prone to frizz and breakage. Limit heat styling Winter weather already dries out hair, so limit heat styling tools like blow dryers and straighteners, which can further strip moisture. If you need to use them, apply a heat protectant spray to help reduce damage. Cover your hair Cold weather can make hair more vulnerable to damage. When outside, consider wearing a hat or scarf to shield your hair from the cold, dry air. Opt for a silk or satin-lined hat to avoid friction that can lead to frizz. Spring hair care tips Spring is a time of renewal, and as humidity levels increase, you may notice changes in your hair’s texture and manageability. Here’s how to keep your hair looking fresh. Exfoliate your scalp Over winter, dead skin and product buildup can accumulate on the scalp. Use a gentle scalp scrub or exfoliating shampoo to refresh your scalp. This helps improve hair growth and keeps your scalp healthy. Adjust your conditioner As temperatures rise, you may not need as heavy a conditioner. Switching to a lighter conditioner can prevent hair from feeling weighed down, giving you more volume and bounce. Embrace natural styles Spring’s humidity can make it difficult to keep styles smooth and sleek. Embrace natural textures and styles that work with the humidity instead of fighting it. This helps reduce the need for heat styling, keeping your hair healthier. Summer hair care tips In summer, sun exposure and chlorine from swimming pools can damage hair, making it dry and prone to breakage. Protecting your hair from these elements is key to maintaining its health. Use UV protection The sun’s UV rays can weaken hair, making it more likely to break. Look for hair products that offer UV protection to shield your strands from sun damage. Wearing a hat also provides good protection and keeps your scalp safe from sunburn. Rinse after swimming If you swim in pools or the ocean, chlorine and salt can leave hair feeling dry and brittle. Rinse your hair with fresh water after swimming to remove these drying elements, and consider applying a leave-in conditioner afterward for extra moisture. Deep conditioning Summer heat can strip moisture from hair, making it look dull and feel rough. Use a deep conditioning treatment once a week to restore moisture and keep your hair soft and shiny. Consider a Mulberry silk pillowcase Summer heat can make hair more prone to frizz, especially when sleeping on traditional pillowcases. Switching to a Mulberry silk pillowcase can help reduce friction, prevent hair breakage, and keep hair smoother, especially in humid conditions. Silk pillowcases are gentle on hair and help keep it manageable throughout the summer months. Fall hair care tips Fall brings cooler temperatures and lower humidity, making hair feel dry. Preparing your hair for the cooler season helps prevent issues like split ends and dryness. Trim split ends After summer, hair may be damaged from sun exposure, chlorine, and saltwater. Trimming split ends at the start of fall helps keep your hair looking healthy and prevents further breakage as the air gets drier. Rehydrate your hair With cooler air, your hair may start to lose moisture again. Switch back to a more hydrating shampoo and conditioner, and consider using a hair mask once a week to lock in moisture. Avoid over-washing In fall, as temperatures drop, hair does not get as oily. Avoid over-washing your hair, as it can strip away natural oils that help protect it. Washing your hair two to three times a week is usually enough to keep it clean without causing dryness. Protect from static Cooler weather often brings static electricity, which can make hair frizzy and hard to manage. Using a leave-in conditioner or a few drops of hair oil can help reduce static, leaving hair smooth and manageable. Final thoughts Taking care of your hair throughout the year requires small adjustments to your routine to match the season. Following these tips, and using silk products, you can protect your hair from the elements, maintain its health, and enjoy beautiful hair every season. Incorporating products like a Mulberry silk pillowcase can also add extra benefits by reducing frizz and protecting your hair while you sleep. With these simple steps, you’ll keep your hair looking its best, no matter the time of year.
Discover how disposable vapes like the Flavour Beast DCP 20K can assist you in quitting smoking. Explore benefits such as controlled nicotine intake, reduced harmful chemicals, and the convenience of shopping at a Canadian vape shop online.