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

273 Power courses in Edinburgh

Shamanic session: healing / ikigai / divination

4.9(30)

By Invisible Caims

Sessions can happen ONLINE or IN PERSON.  Please read below to choose the session that is more appropriate for you (you'll be asked to select one in the booking process)  If you have questions please drop me an email info@schoolofshamanism.co.uk Don't worry if you do not know what to select, just come and I'll be happy to help you:-) Shamanism is probably the oldest way to see through our hearts and not our eyes to connect with the nature of our creation. It allows us to go behind and beyond the surface of things, to understand why and how certain situations occur in our lives. Shamanism is a spiritual practice that goes beyond every beliefs and culture and is about trying to reach our full potential as we walk on planet earth, so connecting ourselves to the whole. Shamans were described as the first physicians, magicians, artists, storytellers, spiritual beings. But shamans are healers that make changes in invisible realms to help healing in the ordinary reality of the community. Shamans see in the darkness (which is the meaning of the Siberian word “Shaman”) while connecting with the divine outside the time in an altered state of consciousness. We can work together using different methods: A) Shamanic healing  We can work together to solve one of these imbalances in your life, where you feel:  lost and without life purpose, unhappy and unsatisfied, anxious and worried, overwhelmed and stressed, without energy and hope, uncertain about your future, stuck in repetitive dynamics, unable to manifest abundance, incapable of making decisions,not aligned with your heart, disconnected from the universe,impatient and impulsive, not focused and balanced, with low esteem and more? B) Ikigai coaching to find your soul mission through shamanic work   Ikigai is the manifestation, the realization of who you are. It has always been with you, it is your reason for being. Some people are lucky to find a job that corresponds to their true passion. They earn a living doing what they love. But there are a lot of people that do not have such a privilege or can’t find the courage for such a big change.The Japanese people from the island of Okinawa have a word for you: Ikigai. It’s your “reason for being”, where you combine what you love with what you are good.  Ikigai is 'what makes you happy to get out of bed in the morning' and is formed by the union of two words: iki which means 'life' and gai  that  is 'what is worthwhile' which the ancients called “happiness”, your soul mission.  Our session together will be a deep inner journey, suitable for those who already know their life mission and those who have no clue at all about it or just are not aware how to combine their gifts and skills. You will reconnect with your inner voice and true skills to realize your true life mission. C) 1-1 Shamanic Divination and find your 9 power animals  Everyone has nine power or totem animals that emulate each person’s abilities, talents and challenges.  For example if a person is connected to Wolf as a power animal, that person is a born teacher, pathfinder, innovator. This does not mean that the person has acknowledged the gifts. The 9 animals are one for each of Direction (4 plus above, below, within) and two animals that walk aside you each time and that maybe have come to you in dreams for years or that you are simply drawn to. Through the use of cards, while connecting to my Spirit Allies, I will find out which animals are your main guides into your life.  Afterwards you will have the opportunity, while tuning with the 9 animals,  A) to ask a burning question. Divination does not mean to foresee future, but to tune your own wisdom to be guided about how to read your inner light simply using a stone.  You will need 3 medium/big stones with some marks on them and we will then choose 1 and I will guide you through the full process, both online or in person.  B) or to receive your full essence and symbol from me though "soul remembrance : I will undertake a shamanic journey for you to retrieve the essence of your gifts and talents and a symbol to be blown into your solar plexus. This can be done online or in person GIADA'S JOURNEY Creative and Spiritual Explorer of the human well-being running events for 20 years worldwide Shamanic Teacher *Toltec tradition: three years formal training with Two Birds at Anam Cara, Scotland *Japanese Yamabushi tradition with Selene Calloni Williams Shamanic and Integral Yoga Teacher Ikigai Coach and Forest Therapy Guide qualified with Selene Calloni Williams at the Imaginal Academy Professional Esoteric Numerologist graduated at The Connaissance School of Numerology, England Cacao Alchemist Practitioner obtained with Firetree Alchemy, Scotland Corporate Mental Health Coach achieved with WeFocus, Denmark and twenty years working in corporate Practitioner of Buddhist teachings, meditation and the Five Tibetan Rites Yoga Founder of Drink In Art exhibitions of local artists in private flats Founder of School of Shamanism (formerly Invisible Caims) workshops, classes, therapies, retreats Founder of Art and Spirituality centre for creativity and well-being Co-author of a non-profit book with 33 Italian women about our stories in different countries By attending to our classes, workshops, 1to 1 sessions and retreats you agree to our TERMS AND CONDITIONS Payment  Bookings are non-refundable.  Disclaimer  By booking any event or 1-1 session -online or  any other venues – with us, you release Giada Gaslini, Invisible Caims/School of Shamanism, Art and Spirituality and any business partners working with for the event  from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results,  theft in the venue or damages that may happen to people and objects while attending. We recommend that you consult your GP regarding the suitability of undertaking an exercise programme, if the class you are booking includes it like with yoga or similar, and following all the safety instructions required before beginning to exercise.  When participating in an exercise, there is the possibility of sustaining a physical injury. If you engage in this exercise programme, you agree that you do so at your own risk, are voluntarily participating in these activities and assume all risk of injury to yourself. You acknowledge that coaching, shamanic healing and counselling are not to be used as a substitute for psychotherapy, psychoanalysis, mental health care, or other professional advice by legal, medical or other professionals. Our sessions are aimed at inner research, problem solving and personal growth, they do not replace the work of doctors and psychotherapists because they do not consider, treat or aim to solve pathologies and symptoms that are strictly medical. All contracts subject to and governed by the law according to my current insurance.   Added element of the disclaimer If the class happens  in any venue and you are causing any damage to the property, you are taking responsibility of your actions. It is down to the individual to take personal responsibility when participating in physical activity and when entering a space that is used and shared by other parties. Giada Gaslini and Art and Spirituality do not take any responsibility about possible risks that may arise but can only advise and enforce guidelines and legal requirements as defined by the Scottish Government and local authorities.   

Shamanic session: healing / ikigai / divination
Delivered Online & In-Person in Edinburgh2 hours, Jun 14th, 11:00 + 11 more
£55 to £350

Yoga Classes

5.0(3)

By Niroshini

ROOTS In the whirlwind of daily life, we often miss the present. But what if we paused? By cultivating awareness of our thoughts, feelings, and the world around us, we unlock a path to greater well-being. This practice, known as mindfulness, allows us to savour life's experiences and gain a deeper understanding of ourselves. Have you ever noticed yourself multitasking on autopilot? Working from home with the TV on, scrolling through your phone while eating, or rushing through your day without truly being present? In today's digital age, it's easy to become scattered and disconnected.  That's where "Roots" comes in. The name has a reason just like our life. Our roots, both physical and metaphorical, connect us to the earth's energy. Yoga mimic these roots, anchoring us in the present moment. Mindfulness becomes the fertile ground where inner wisdom and true self can flourish.  I am NIROSHINI, and I've been practising yoga since the age of 6. With a background rooted in yoga and naturopathy studies in India, I'm passionate about sharing the transformative power of yoga and mindfulness. Drawing from the wisdom of Hatha and Ashtanga Yoga traditions, we have a tapestry of mindful movement, breathwork, postures, (asanas), meditation, and relaxation techniques. This holistic approach cultivates peace, strength, and awareness on both on and off the mat. At Roots, we believe yoga is a transformative tool for a happier, healthier you. Discover your roots and embark on this journey of mindful well-being.  This will be your path to reconnect with yourself. Through gentle yoga practices and mindfulness techniques, you'll learn to cultivate present-moment awareness and a sense of calm amidst the everyday chaos. Imagine truly savouring your meals, quieting your mind during work, increased productivity and finding peace in the simple moments. Through “Roots” you'll experience a dramatic shift in your well-being and the way you look at the journey of your life. Join me on this journey to find your roots and discover the joy of mindful living. Contact us : +447395275754 Instagram: therootsedinburgh

Yoga Classes
Delivered In-Person in Edinburgh1 hour, Jun 18th, 17:00 + 1 more
£7.99

C30M01 - Evacuation Alert systems - BS 8629 (classroom)

By Ember Compliance

Learners will be introduced to EAS as part of the fire safety solution for tall residential properties. This CPD course provides learners with an understanding of the requirements of BS 5839-1 in relation to, design, installation, commissioning, and maintenance of EAS.

C30M01 - Evacuation Alert systems - BS 8629 (classroom)
Delivered In-Person in BroxburnFull day, Jun 19th, 08:00
£199

ONE YEAR SHAMANIC PRACTITIONER TRAINING 2024-25

4.9(30)

By Invisible Caims

Who is this course for: This course is for Spiritual Explorers that: *are already open to energy and to the spiritual vision of the world, *are not living blindly following the rules of the matrix, but try to follow their hearts and intuition *want to go beyond the barriers of the ordinary world and access the wisdom and energy healing powers of the spirits to help themselves and others; *want to realise themselves in the totality of their potential,  in order to live a genuine life mission and become evolved human beings; *want to go through a deep inner transformation and inner work for the evolution of their souls. What you will learn: This intense one year course has been designed combining together the Toltec and the Japanese tradition of shamanism and no experience is required to attend. It will allow you to qualify as a Professional Shamanic Practitioner.  Shamanism has survived for millennia because of its effectiveness and adaptability. In some cultures it is still a reference spiritual practice, in our modern culture it is increasingly an alternative practice for healing the soul and for all health issues that cannot be solved by official science. In these times of great change, spiritual practice, done humbly but also with purpose, can transform our society.  The vision is to educate you to become a shamanic practitioner experiencing this vast and diverse healing heritage, applying it with courage and commitment in your own environment.  The term "professional" means someone who has solid experience working with other people safely and effectively. You will follow a very deep path of healing, transformation and personal empowerment necessary to work ethically and professionally in the field of shamanic healing. Through deep initiations you can open ever wider doors to the spiritual world necessary to become true channels of healing and inexhaustible sources of spiritual wisdom WHEN penultimate week-end of the month per 13months  (different dates in  December due to Christmas and April due to Easter;  break in July and August)  10am-5pm GMT time each day 20th-21st April 2024 18th-19th May 2024 22nd-23rd June 2024 21st-22nd September 2024 19th-20th October 2024 16th-17th November 2024 7th-8th December 2024 18th-19th January 2025 15th-16th February 2025 22nd-23rd March 2025 12th-13th April 2025 17th-18th May 2025 21st-22nd June 2025 You have time till the 15th May 2024 to sign up. If you miss the first week-end, the recording will be sent to you. After this date, no more applications will be taken.  You are ideally required to attend all the week-ends, online or in person but I understand sudden circumstances may occur. You will be allowed to miss maximum two week-ends, for which you will get the recordings and you will be required to do home-works, in order to get your certificate.  If your absence is over this, we'll need to speak and consider your personal circumstances. PROGRAMME ECSTASY: SHAMANIC JOURNEYS AND OTHER METHODS POWER ANIMALS , SPIRIT GUIDES AND SPIRIT NAMES (find your own one) POWER DANCE SHAMANIC TOOLS THE ART OF STORYTELLING: HACKING THE MIND PILGRIMAGES SHAMANIC HEALING: SOUL RETRIEVAL AND EXTRACTIONS SOUL REMEMBRANCE THE ART OF DIVINATION RITUALS AND CEREMONIES THE ANCESTRAL REALMS: PAST LIVES PSYCHOPOMP AND DEATH AS AN ALLY FOREST THERAPY : JAPANESE SHAMANIC RITUALS  BEING A SPIRITUAL WARRIOR IN THE YAMABUSHI TRADITION CREATIVITY AS AN HEALING TOOL  THE MEDICINE WHEEL  THE ARCHETYPES AND CHAOS CYCLES SHAMANIC COUNSELLING AND THE GARDEN OF SOULS HEALING CIRCLES INTRODUCTION TO CACAO CEREMONIES HOW TO WORK WITH CLIENTS FINAL CEREMONY COST OF THE FULL COURSE FULL COURSE £250 non-refundable deposit, followed by 12 monthly instalments according to your income: Early bird offer by 16th February 2024 High £195/month     Medium £185/month     Low £156/month Full price from 17th February High £216/month   Medium £205/month     Low £173/month CANCELLATION AND PAYMENTS A booking is accepted following receipt of a non refundable deposit payment,  followed by monthly instalments. Any cancellation occurring after the start of the course will still be subject to the payment in full of the remaining instalments.  Disclaimer  By booking any event or 1-1 session -online or  any other venues – with us, you release Giada Gaslini, Invisible Caims/School of Shamanism, Art and Spirituality and any business partners working with for the event  from any liability arising out of any personal injuries, emotional or physical release, death, expectations of results,  theft in the venue or damages that may happen to people and objects while attending. We recommend that you consult your GP regarding the suitability of undertaking an exercise programme, if the class you are booking includes it like with yoga or similar, and following all the safety instructions required before beginning to exercise.  When participating in an exercise, there is the possibility of sustaining a physical injury. If you engage in this exercise programme, you agree that you do so at your own risk, are voluntarily participating in these activities and assume all risk of injury to yourself. You acknowledge that coaching, shamanic healing and counselling are not to be used as a substitute for psychotherapy, psychoanalysis, mental health care, or other professional advice by legal, medical or other professionals. Our sessions are aimed at inner research, problem solving and personal growth, they do not replace the work of doctors and psychotherapists because they do not consider, treat or aim to solve pathologies and symptoms that are strictly medical. All contracts subject to and governed by the law according to my current insurance.   Added element of the disclaimer If the class happens  in any venue and you are causing any damage to the property, you are taking responsibility of your actions. It is down to the individual to take personal responsibility when participating in physical activity and when entering a space that is used and shared by other parties.  Invisible Caims does not take any responsibility about possible risks that may arise but can only advise and enforce guidelines and legal requirements as defined by the Scottish Government and local authorities.  Giada's Journey Creative explorer of the human well-being with twenty years’ experience running events, workshops and retreats. Co-author of a non-profit book with other 33 Italian women about their stories in different countries. She has been learning to heal herself supportinga Holistic connection between mind, body and spirit. She has been studying and practicing Buddhist teachings, meditation and the Five Tibetan Rites Yoga in Nepal, India and Italy. Approached the imaginal world and dreams with the psychologist Elio Occhipinti and a regressive hypnosis journey with the vision of the psychiatrist Brian Weiss.  Her studies and practice have helped her become: Shamanic Practitioner and Teacher with the two years formal training at Anam Cara and one year in Wales Shamanic and Integral Yoga Teacher, Ikigai Coach,Forest Therapy Guide qualified with Selene Calloni Williams at the Imaginal Academy and part of the Italian-Swiss Association for Counselling and Coaching, Aiscon.  Professional Esoteric Numerologist graduated at The Connaissance School of Numerology Corporate Mental Health Coach achieved with WeFocus Founder of Drink In Art exhibitions of local artists in private flats Founder of Invisible Caims creative and spiritual workshops, classes and therapies Founder of the Art and Spirituality Centre centre for creativity and well-being in Edinburgh

ONE YEAR SHAMANIC PRACTITIONER TRAINING 2024-25
Delivered Online & In-Person in EdinburghFull day, Jun 22nd, 09:00 + 21 more
£250

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, on-requestDelivered In-Person in Merseyside,
£800 to £1000

Power Automate Training

By FourSquare Innovations Ltd

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

Power Automate Training
Delivered in-person, on-requestDelivered In-Person in Merseyside,
£1600 to £2000

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-person, on-request, onlineDelivered Online & In-Person in Harpenden
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-person, on-request, onlineDelivered Online & In-Person in Harpenden
Price on Enquiry

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

By The In House Training Company

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 THE QUERY EDITOR * Grouping rows in a table * Split row by delimiter * Add days to determine deadlines * The query editor 2 FUZZY MATCHING JOINS * Matching inconsistencies by percentage * Matching with transformation table 3 THE QUERY EDITOR M FUNCTIONS * Adding custom columns * Creating an IF function * Nested AND logics in an IF function 4 DAX NEW COLUMNS FUNCTIONS * Including TRUE with SWITCH * Using multiple conditions * The FIND DAX function * The IF DAX function * Logical functions IF, AND, OR 5 EDITING DAX MEASURES * Making DAX easier to read * Add comments to a measure * Using quick measures 6 THE ANATOMY OF CALCULATE * Understanding CALCULATE filters * Add context to CALCULATE with FILTER * Using CALCULATE with a threshold 7 THE ALL MEASURE * Anatomy of ALL * Create an ALL measure * Using ALL as a filter * Use ALL for percentages 8 DAX ITERATORS * Anatomy of iterators * A closer look at SUMX * Using RELATED with SUMX * Create a RANKX * RANKX with ALL 9 DATE AND TIME FUNCTIONS * Overview of functions * Create a DATEDIFF function 10 TIME INTELLIGENT MEASURES * Compare historical monthly data * Create a DATEADD measure * Creating cumulative totals * Creating cumulative measures * Visualising cumulative totals 11 VISUALISATIONS IN-DEPTH * Utilising report themes * Applying static filters * Group data using lists * Group numbers using bins * Creating heatmaps * Comparing proportions * View trends with sparklines 12 COMPARING VARIABLES * Visualising trendlines as KPI * Forecasting with trendlines * Creating a scatter plot * Creating dynamic labels * Customised visualisation tooltips * Export reports to SharePoint

Power BI - intermediate (2 day) (In-House)
Delivered in-person, on-request, onlineDelivered Online & In-Person in Harpenden
Price on Enquiry

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 GETTING STARTED * The Power BI process * Launching Power BI Desktop * The four views of Power BI * Dashboard visuals 2 CONNECTING TO FILES * Connect to data sources * Connect to an Excel file * Connect to a CSV file * Connect to a database * Import vs. DirectQuery * Connect to a web source * Create a data table 3 TRANSFORMING DATA * The process of cleaning data * Column data types * Remove rows with filters * Add a custom column * Append data to a table * Fix error issues * Basic maths operations 4 BUILD A DATA MODEL * Table relationships * Manage table relationships 5 MERGE QUERIES * Table join kinds * Merging tables 6 CREATE REPORT VISUALISATIONS * Creating map visuals * Formatting maps * Creating chart visuals * Formatting chart * Tables, matrixes, and cards * Control formatting with themes * Filter reports with slicers * Reports for mobile devices * Custom online visuals * Export report data to Excel 7 THE POWER QUERY EDITOR * Fill data up and down * Split columns by delimiter * Add conditional columns * Merging columns 8 THE M FORMULA * Creating M functions * Create an IF function * Create a query group 9 PIVOT AND UNPIVOT TABLES * Pivot tables in the query editor * Pivot and append tables * Pivot but don't summarise * Unpivot tables * Append mismatched headers 10 DATA MODELLING REVISITED * Data model relationships * Mark a calendar as a date table 11 INTRODUCTION TO CALCULATED COLUMNS * New columns vs. measures * Creating a new column calculation * The SWITCH function 12 INTRODUCTION TO DAX MEASURES * Common measure categories * The SUM measure * Adding measures to visuals * COUNTROWS and DISINCTCOUNT functions * DAX rules 13 THE CALCULATE MEASURE * The syntax of CALCULATE * Things of note about CALCULATE 14 THE SUMX MEASURE * The SUMX measure * X iterator functions * Anatomy of SUMX 15 INTRODUCTION TO TIME INTELLIGENCE * Importance of a calendar table * A special lookup table * The TOTALYTD measure * Change year end in TOTALYTD 16 HIERARCHY, GROUPS AND FORMATTING * Create a hierarchy to drill data * Compare data in groups * Add conditional formatting 17 SHARE REPORTS ON THE WEB * Publish to the BI online service * Get quick insights * Upload reports from BI service * Exporting report data * What is Q&A? * Sharing your reports 18 APPLY YOUR LEARNING * Post training recap lesson

Power BI - introduction to intermediate (2 days) (In-House)
Delivered in-person, on-request, onlineDelivered Online & In-Person in Harpenden
Price on Enquiry

Educators matching "Power"

Show all 21