• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

50 Educators providing Power courses in Manchester

Streetgames UK

streetgames uk

Manchester

StreetGames harnesses the power of sport to create positive change in the lives of disadvantaged young people right across the UK. StreetGames' work helps to make young people and their communities healthier, safer and more successful. WHY SPORT? Sport is energetic, inclusive and enjoyable, but StreetGames' goal isn’t just about having fun. StreetGames believes in the power of sport to transform lives and to broaden ambitions. Sport teaches key skills such as teamwork, understanding and self-discipline, brings people together, creates pride in a community, breaks down social boundaries, and inspires people to make a difference in their own lives and for others. Through sport, StreetGames can empower young people to kick-start a cycle of positive change that echoes throughout their entire community. StreetGames' central programme: 'Doorstep Sport' encapsulates many of these important qualities, offering fun and informal sports clubs that work to meet the needs of today's disadvantaged young people - a staggering 70% of whom are not involved in structured activity elsewhere. They do this by operating according to the 'Five Rights of StreetGames': being carried out at the right time, in the right place, with the right people, for the right price and in the right style to suit the needs of these LSEG youth. TEAMWORK StreetGames' work is delivered in partnership with the StreetGames Alliance of around 1,000 Locally Trusted Organisations, working in disadvantaged communities across the UK. The collective power and reach of this alliance enables unparalleled access to young people growing up in over 4,000 poverty-hit localities. These organisations are the lifeblood of their neighbourhoods. They have earned their spurs, built trust and won the right to make a difference in their community. They understand what will work and what’s needed on their patch. They reach those that others find ‘hard to reach’ and are able to collaborate with StreetGames to replicate what works at scale and at pace. The organisations that make up the StreetGames Alliance maintain industry standards for safeguarding, insurance, health and safety, and equalities and diversity. Each is a self-determining organisation that is independently managed and funded. Most are charities, legally constituted community groups or Community Interest Companies. All are embedded in their ‘hard to reach’ neighbourhood. LEVELLING THE PLAYING FIELD 3.5 million UK children currently live in poverty. Fewer than 1/4 meet national guidelines for recommended daily activity. Young people from the lowest economic bracket are 3 times more likely to suffer with mental illness than a counterpart from the highest-earning group. The UK’s poorest children live an average of 3.6 to 5 years fewer than their more affluent peers These same children also spend an additional 16.5 years in poor health. Screenshot 2020-08-06 at 13.01.07.png "StreetGames has turned my life around. If it wasn't for them I don't know where I'd be right now" LYNDSEY DAWN - STREETGAMES PARTICIPANT. StreetGames believes in fair play, both in sport and in life. With only £3.21 to spend on sports activities per week – compared to the national average of £12.11 – struggling families just can’t afford to keep pace. That’s why StreetGames has made it its mission to level the playing field. Here’s how. StreetGames is committed to making communities healthier, safer and more successful. StreetGames' programmes are conducted in the ‘Right Way’ - offering projects at the right time, in the right place, and for the right price to suit the needs of young participants. Through StreetGames' pioneering Doorstep Sport approach, the organisation improves young lives through sport, giving access to positive role models, volunteering opportunities and diversionary activities. Through Fit and Fed, StreetGames tackles the hidden issue of holiday hunger and inactivity, through nutritious meals and fun, healthy activities. Through Us Girls, StreetGames work to empower young women within a holistic and supportive environment - tackling the everyday sexism that presents a barrier to participation in sport.

Whitehall Media

whitehall media

0.0(3)

Manchester

Founded in 2006, Whitehall Media delivers high quality, content-focused conference programmes that address high level strategic issues within the market places in which we operate. Our leading-edge events impart practical and technical information through visionary keynotes, interactive seminars and lively one-to-ones. We specialise in high value, difficult-to-engage markets and create events that merge buy-side and sell-side professionals in an innovative and strategic business exchange. We are leaders in the specialisms we cover and our conference led exhibitions are held in the UK, Europe and the UAE showcasing the latest ground-breaking trends, tools and technologies for both government and industry. The environment we develop enables best practice to be shared among peers and deals to be closed on the day. We meticulously market to decision-maker delegates to ensure that we attract buyers with spending and decision-making power who will give their valuable business or leisure time to every one of our events. If you decide to participate in a Whitehall Media event you can be sure you will be in the very best of hands. Our events are professionally managed and marketed strategically. We work tirelessly with our clients to evaluate their needs, offer them the best possible service and ensure our conferences deliver real value to all participating individuals and organisations. Ensuring a successful outcome for our customers is our utmost priority.

Outside The Lines - Art Workshops

outside the lines - art workshops

Poynton

An independent art studio where artists of all ages can develop their creativity and gain self-confidence through visual art. Join our email list > "My daughter is enjoying art class very much and thus I am happy and satisfied. :) She actually said it helped her calm down on a day where she had gotten angry with her brother - now that's some good stuff! Thank you for inspiring them, and for all that you do!" Kyrie Shomaker, MD When she was a little girl, Melanie Cramer wanted to be an artist/ballerina/teacher/mommy. Apparently "ballerina" was code for business owner because now she teaches art in her own studio. Her path included earning an art degree from High Point College (now university), many years spent as an art director for print media, and many more teaching preschool locally. She founded Outside the Lines Art Studio in 2011 to share her belief in the transformative power of visual art with her community. Meet the Owner: Melanie Cramer IMG_2835.jpg At Outside the Lines Art Studio, we believe the process of creating is far more valuable that the resulting creation. An artist who has spent time exploring an art medium thoroughly may or may not produce a masterpiece worthy of professional framing and prominent display, but they will certainly produce something they are proud of, independent of others’ opinions. They will have expressed themselves to their own satisfaction. They will have experienced something new and learned from it. They will feel more self-assured and confident. Those are products you can’t hang on the wall, or even the fridge.

Voyage MCR

voyage mcr

Salford

Hi, I'm Bec and welcome to Voyage MCR. A place where we can work together to provide you with the tools and confidence to take on life's journey. Since I can remember, I have always had a passion for helping and supporting others. This passion, along with my strong interest in both the conscious and subconscious mind, mental health, and psychology, have led to my journey as a mindset and wellbeing coach. I was once told, 'find passion, find purpose' so that is what I have done. I was an eager psychology student with a dream of becoming a clinical psychologist. I completed a Bachelor's degree in Applied Psychology and went on to complete a Master's degree in Clinical and Health Psychology. In between both degree's, I completed a mental health placement in Sri Lanka, went travelling around parts of Asia, Australia, and New Zealand, and worked and lived abroad. However, as time went on and as my mind opened due to all of these experiences, I realised the 'dream' of becoming a clinical psychologist, was in fact never my dream at all. Although I gained valuable experience within clinical, my true passion has always been positive psychology, which teaches us the power of shifting one's perspective. This realisation led me to complete a practitioner and master practitioner course in NLP and hypnotherapy and find my purpose as a coach. My goal now is to help others let go of their limiting beliefs, transform their mindset, build confidence and resilience, improve mental wellbeing and give people the tools to lead a happier and more fulfilling life. Remember, your thoughts create your reality, so together let's make your mind a safe and positive place to be.

Bernadette Willems

bernadette willems

Manchester

The Power of Mediation in Business and Relationships by Bernadette Willems “I’ve had enough….” “How do I leave my husband….” “They are just not listening….” “How can we stop this from getting ugly….” “It’ll be lonely this Christmas….” “We’ve tried everything, and nothing is working….” “I’ve had enough of life….”  These are just some comments I hear daily in my role as The Business Peacemaker and The Post-Divorce Specialist at Greater Manchester Mediation Limited.  With more than 25 years of experience as a Family Solicitor, Mediator, Trainer and Coach in the field of conflict resolution, I help people lead a better life and a brighter future free from debilitating disputes – thereby helping to create a better world for all of us. The key to this is ‘Mediation’. But what is it, and how does it work? As founder of Greater Manchester Mediation Limited, and as ‘The Business Peacemaker’ and ‘The Post-Divorce Specialist’, I show my clients primarily how to communicate with each other. This is vital, as it ensures that vulnerable or emotionally fragile clients feel heard and empowered, and it rebuilds bridges between estranged parties.  I am also there to support my clients in navigating the legal process, helping them understand the requirements of law and to find the best route to resolve their disputes. In addition, I ensure that they are not overwhelmed by all the information available and help them determine their best course of action.  Many disputes or problems between individuals, in personal or work relationships or within teams, are compounded or aggravated because clients do not understand each other’s way of thinking, together with the legal (and other) options available to them.  Crucially, with the benefit of this legal knowledge, together with the life and personal development tools and resources I share with my clients, they can identify ways of building or maintaining trust, despite the past. Mediated solutions work better, last longer and cost far less than solutions imposed by a tribunal or a court, and everyone involved buys into them. Moreover, they are less adversarial, and Mediation fosters mutual respect through improved communication. Mediation can mend and preserve frayed relationships, even when the parties are extremely angry.

Clair Anderson

clair anderson

Warrington

Hi 😊😊 I’m Clair. Founder of be your own kind of beautiful - community local well-being hub fb page of inspiration reiki training academy Also.. A human being - or rather a spiritual Being having a human experience 😊 A mum - of 3 beautiful ones A nannie- of 2 gorgeous little ones A wife of the less conventional kind… we don’t live together but we do life together as a team❤️ ( Dave lives above be your own kind of beautiful😊) A cat owner that is in fact totally owned by her cat🤪🤪 A daughter who’s parents have supported me so much through the years I am totally Blessed 🙏🏻🙏🏻🙏🏻 A woman, with a mission to be my own kind of beautiful regardless of what society says I ‘should be’ Or should do. On a mission to inspire you to be your own kind of beautiful too. I’m Obsessed with self help self development self healing and reiki 😊🙏🏻 I have been an avid implementer of ‘do what you can with where you are at and with what you got’ I have many chronic physical health Conditions that slow me Down, but never hold Me Back. I’ve endured & overcome- Crippling anxiety & depression, PTSD x4!!! Agoraphobia A Mega negative mindset!! An emotionally abusive soul destroying marriage Thyroid cancer Chronic illness A decade of undiagnosed illness The Food banks & Pinch loo roll kinda poverty I could be an agony aunt lol !! I’m not. I’m a Reiki & Meditation Teacher. NLP Life Coach and my full time job is Uber ing my kids about 🤪 But all of this is what drives me to help others take their power back and help themselves to help themselves. Reiki allows me to live well despite my health issues. Infact being on a constant self healing and rising back mission - my health issues are the driving force behind everything I do! I am dedicated to my Path, I’m here to serve, so much so I actually Married the universe at crosby beach a couple Of years ago 😊🙏🏻 with my little people and a statue As my witnesses 😊😊 Be your own kind of beautiful, was a dream I had of ‘passionate about your well-being’ teachers and therapists all available In one place so that you can explore and experiment and find the well-being magic that works for you. Right on your doorstep. But also as a platform for new passionate teachers and therapists to find their feet. And get their magic out to the world. Supporting with a space to work from. advertising, marketing, and any advice I can help with in getting started in business. I teach Reiki in the studio- group classes and one2one training. This year imy first ever online Reiki Training adventure 😍 I’m in the therapy room Tuesdays for Reiki & Relaxation sessions and one2one training. You can join me for all things Reiki in my free fb group 👇👇👇 Be Reiki

Lenticular Futures

lenticular futures

Manchester

We're transforming psychotherapy and counselling in three ways: We are re-thinking all therapeutic theory to situate the individual in wider contexts and systems. We ask how everything is connected, by whom and with what consequences! Join us in decolonising, depathologising and ecologising practice, theory and research We can help therapists and training institutes develop future oriented technological competence for more accessible practice. Why is that important? There is a need to decolonise and depathologise the theory and practice of psychotherapy and counselling. We need to understand the problems of the individual as situated in a world which is socially, culturally and economically unbalanced. And we need to have ways of recognising and working with people's complex intersectional community memberships, experiences and talents in therapy. Why now? We are living in a panmorphic crisis (Simon 2021). It's a good time to read the writing on the wall and take action. We can do this by making decolonising and depathologising theory and practice, by responding with EcoSystemic ways of working, by critically engaging with accessible and future oriented technological possibilities. What work do we do? The key areas of our work are Training - Research - Consultancy. We run workshops and seminars to create and support decolonised, depathologised and ecosystemic ways of working. We host conferences on social issues affecting psychotherapy and counselling practice and training. We introduce psychotherapists and their training organisations to new technologies and intramediality to help make learning and assessment more accessible and culturally relevant. We produce research reports on future technology for therapy; neurodiverse therapy; therapeutic space; ecosystemic therapy; indigenous knowing and practice in therapy; new ways of training and assessing counselling and psychotherapy trainees; more... We consult to training organisations and professional membership bodies to help them improve the experience and success of trainees from diverse communities We run leadership and organisational development groups for leaders and managers who are developing inclusive therapeutic services What kind of organisation is Lenticular Futures? We are becoming a Community Interest Company. That means we are a Not For Profit and all proceeds from work support free or low cost projects and research within the organisation. How do we fund this work? We charge for workshops, conferences and seminars we host. We apply for funding. We welcome donations for specific projects or in general What does Lenticular mean? Lenticular Futures is a term borrowed from a paper by Professor Wanda Pillow (link). It's a prompt to hold in mind past, present and future when you meet people or see something. It's an invitation to notice the neurotypical, heteronormative, eurocentric lenses we have been taught to look through and check who-what we are including and who-what we are excluding. It comes from noticing what Wanda calls a "whiteout" in academic and professional literature of Global Majority contributors. This is an era for new curricula and making new theory and practice. Our professions can easily lead changes in the balance of power and develop more user friendly ways of working. What are our philosophical objectives? To theorise and interrogate fundamental taken for granteds in the cultural bias of theory and practice. To develop a lenticular ideology of psychotherapy and counselling which integrates and is led by decolonising, depathologising, ecosystemic, contextual influences of planet and co-inhabitants. To redress the exclusion of knowledge from oppressed population groups. To support therapeutic practices which are generated from within communities. To understand and address systemic influences of capitalism on wellbeing. To critically work with the socio-techno world in which we live. To get that systemic understanding of the world is an overarching metatheory for all our modalities. To decolonise means not having a disordered attachment to theories of disorder. Who are we? The co-founders are experienced psychotherapists and organisational consultants. We bring a vast amount of experience in systemic thinking about organisations, culture, therapy and counselling training, research and management. We also know how to create initiatives from within the margins. The co-founders are Dr Julia Jude, Dr Gail Simon, Rukiya Jemmott, Dr Leah Salter, Kiri Summers, Dr Liz Day, Dr Birgitte Pedersen, Anne Bennett, Naz Nizami, Dr Francisco Urbistondo Cano and Amanda Middleton. Forthcoming events Lenticular Futures: Crafting Practices beyond this Unravelled World FLIP@Brathay 2nd & 3rd May 2022 https://lf2022.eventbrite.co.uk Indigenous and Decolonising Knowledge and Practice Decolonising Therapeutic Practice read-watch-listen-make groups Future Tech to improve experiences for people doing therapy and in therapy training EcoSystemic Return Reading Seminars Professional Wellbeing events Walking and Outdoors Therapy Creating Decolonised Participatory Groups Systemic Practice and Autism Conference Writing Performance as Research Film, podcast, documentary making with people doing training and therapy Watch this page and our Eventbrite page - : - : - : - : - : - : - : - : - : - : - : - : - : - : - Therapy in a Panmorphic World This era of panmorphic crisis requires urgent, creative, ethics-led responses. Most of the professional theories we live by came into being without their ideological foundations being questioned. We cannot take a step further in this world without a commitment to developing awareness of parallel, criss-crossing, multidimensional, transtemporal, transcultural, transmaterial elements of living – and how they interact. No Meaning Without Context The key systemic value of understanding context is paramount to inquiry, to understanding what is happening and how to move as a relational, situated participant-player. But the contexts in play are often hidden, erased, elusive or remote, and it can be plain hard to see-feel-understand the knowledges and experiences specific to other places, people or disciplines. The Individual Is Not The Problem The psych professions confuse this further through the decontextualising practices of individualising and pathologising explanation of why some people see some things one way and not another. Furthermore, the social construction of truth is a debate that transcends academia and has been put to work by political agendas to foster an era of mistrust of truth. People are now aware that “truth” can be put to work for objectives other than the common good. This undermines social justice issues and what counts as information. Voices from within a community, from within lived experience are undermined by voices from without of those contexts often without a critique of power relations. A Fresh Look at Training Counsellors and "Psycho"therapists We cannot train relational practitioners in aboutness-withoutness ways of thinking. It separates people from place and history, and it creates colonisers and pathologisers whose practices become policy and influence the majority’s “common sense”. Opportunities for other kinds of learning are lost. The first language of the psycho professions of “talking therapy”, whatever its modality, is excluding of other ways of moving on safely and creatively together. The psychotherapies are playing catch-up in how people use technology to communicate in their everyday lives. A Paradigm Shift for Therapy and Counselling The Black Lives Matter movement offers a choice. It can be treated as a passing protest or a cultural shift. This organisation chooses to take the position that no-one should choose to be unchanged by Black Lives Matter. The question is how to be changed in ways that will contribute to a better world? This is more than a matter of equal rights. It is about safety now, it is about heritage, rich, stolen, re-interpreted, it is about past, present and future being held in mind, all the time. Professional practice needs to scrutinise its theoretical heritage with its hidden ideological assumptions to study and guide our ways forward into a new era, to meet change with culturally appropriate language, local knowledges, and ways of being and imagining.

1...345

Courses matching "Power"

Show all 315

Presentation Skills 1 Day Workshop in Bolton

5.0(1)

By Mangates

Presentation Skills 1 Day Workshop in Bolton

Presentation Skills 1 Day Workshop in Bolton
Delivered In-Person + more
£595 to £795

CSI: Crime Scene Investigator for the Day

4.6(39)

By Geopace Training

Learn the skills of a Crime Scene Investigator ... Explore the exciting world of the Forensic Investigator in this unforgettable interactive experience day. You will spend the day using real forensic methods and techniques to perform a range of established crime scene investigations. All investigations that you perform are "hands-on", giving you the opportunity to learn how these procedures work in real life. Your day will include: DRUG TESTING: Perform a drugs test! The suspect was carrying a small plastic bag of a white substance when arrested. He was known to police as a cocaine dealer. Was he carrying cocaine? Carry out chemical tests to establish if the white powder was cocaine? FINGERPRINTING: Learn how to lift and record fingerprints using the conventional dusting process to detect and preserve fingerprints. MICROSCOPY: Use a light microscope to forensically examine crime scene samples. Discover how to use different magnifying powers to optimise the results. FABRIC SAMPLE ANALYSIS: Compare samples collected at the crime scene and on the suspect to identify human hairs. SOIL ANALYSIS: Analyse soil samples collected from the crime scene and compare against soil recovered from the suspect's shoes. Identify which soil sample is common between both crime scene and suspect. Use chemical tests to confirm your results. TOOL MARK IDENTIFICATION: You have a known tool impression from the crime scene. Use forensic casting techniques to create clay impressions and compare with a range of tools recovered from the suspect's tool shed. Which tool did he use? BLOOD DETECTION: Blood-like stains were found at the crime scene. Before sending samples to the forensic lab we need to establish if they are blood samples. Use established forensic tests and procedures to identify blood spots and stains that may not be visible to the naked eye. DNA EXTRACTION: Perform an extraction procedure to extract DNA from samples provided. You will be able to see (and feel) actual DNA once you have completed the process! Awards a Certificate of Completion OPEN TO ALL APPLICANTS LOCATIONS THROUGHOUT THE U.K. AFTER THE COURSE … Understand the breadth of career opportunities available to you in nearly 100 specific disciplines of forensic science, including: Forensic Art Forensic Photography Wildlife Forensics Forensic Statistics Entomology Cypercrime and Cyper-IT Forensic Meteorology DNA analysis Counterfeiting & Forgery Casts & Impressions incl. tyres & shoes and many more! Appreciate the difference in roles between Forensic Scientist posts and Crime Scene Investigator posts. Understand that there are many forensic posts in niche areas that may benefit from existing transferrable skills (such as IT). Apply qualifications and skills acquired to parallel fields such as teaching. For a more detailed overview please see our "Opportunities in Forensic Science" guide. 

CSI: Crime Scene Investigator for the Day
Delivered In-Person in Birmingham + 7 more + more
£99

Time Management 1 Day Training in Bolton

By Mangates

Time Management 1 Day Training in Bolton

Time Management 1 Day Training in Bolton
Delivered In-Person + more
£595 to £795

Master Business Networking in Just 1 Day - Join our Workshop in Bolton

By Mangates

Business Networking 1 Day Training in Bolton

Master Business Networking in Just 1 Day - Join our Workshop in Bolton
Delivered In-Person + more
£595 to £795

Presentation Skills 1 Day Workshop in Manchester

5.0(1)

By Mangates

Presentation Skills 1 Day Workshop in Manchester

Presentation Skills 1 Day Workshop in Manchester
Delivered In-Person + more
£595 to £795

Emotional intelligence 1 Day Training in Bolton

By Mangates

Emotional Intelligence 1 Day Training in Bolton

Emotional intelligence 1 Day Training in Bolton
Delivered In-Person + more
£595 to £795

Power BI Training

By FourSquare Innovations Ltd

FourSquare Training specialise in private, corporate Power BI courses delivered at your premises and tailored to your needs.

Power BI Training
Delivered In-Person in Merseyside, or UK WideFlexible Dates
£800 to £1,000

Microsoft Power BI Desktop In-company (now with live online classes)

By Microsoft Office Training

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Microsoft Power BI Desktop In-company (now with live online classes)
Delivered in London or UK Wide or OnlineFlexible Dates
£550

Power BI - dashboards (1 day) (In-House)

By The In House Training Company

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

Power BI - dashboards (1 day) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Power BI - introduction (2 day) (In-House)

By The In House Training Company

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

Power BI - introduction (2 day) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry