London

<p>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<br />.</p> <p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Connect to data from different sources.</li><li>Use the Query Editor</li><li>Perform Power BI desktop data Shaping and Transformation.</li><li>Create Power BI desktop Modelling.</li><li>Create Power BI desktop Visualizations and Reports.</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke course</strong></p> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>in in company training, 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.</p> <p>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.</p><p><strong>Introduction to Power BI</strong></p> <ul> <li>Power BI Jargon explained</li><li>A quick look at Power BI Desktop</li><li>A quick look at the Power BI service</li><li>Helpful resources</li></ul> <p><strong>Power BI and Excel</strong></p> <ul> <li>Introduction to using Excel data in Power BI</li><li>Upload Excel data to Power BI</li><li>Import Power View and Power Pivot to Power BI</li></ul> <p><strong>Getting started with Power BI Desktop</strong></p> <ul> <li>Overview of Power BI Desktop</li><li>Accessing Help and Helpful resources</li><li>Connect to data sources in Power BI Desktop</li></ul> <p><strong>Shaping and Transforming Data with Query Editor</strong></p> <ul> <li>Introduction to the Query Editor</li><li>Data Sources Power BI Desktop can Connect to</li><li>Introduction to Steps and M code</li><li>Combining Data Using Merge and Append Queries</li><li>Data Type Properties</li><li>Working with Delimiters</li><li>Clean and transform your data with the Query Editor</li><li>Text Specific Transformation Tools</li><li>Number Specific Transformation Tools</li><li>Date Specific Transformation Tools</li><li>Split and Merge columns</li><li>Creating an Index Column</li><li>Adding Conditional Columns</li><li>Columns From Examples</li><li>Grouping and Aggregating data</li><li>Pivoting and Unpivoting</li><li>Using filters</li></ul> <p><strong>Modeling the data</strong></p> <ul> <li>Introduction to modeling your data</li><li>How to manage your data relationships</li><li>Create calculated columns</li><li>Optimizing data models</li><li>Create calculated measures</li><li>Show Values As and Quick Measures</li><li>Create calculated tables</li><li>Explore your time-based data</li><li>Introduction to DAX</li><li>DAX calculation types</li><li>DAX functions</li></ul> <p><strong>Visualizations</strong></p> <ul> <li>Introduction to visuals in Power BI</li><li>Create and customize simple visualizations</li><li>Modify colors in charts and visuals</li><li>Shapes, text boxes, and images</li><li>Page layout and formatting</li><li>Group interactions among visualizations</li><li>Visual hierarchies and drill-down</li><li>Using custom visualizations</li><li>Create a KPI Visualization</li><li>Geo-Data and Maps</li></ul> <p><strong>Reports, Publishing and Sharing</strong></p> <ul> <li>Introduction to the Power BI service</li><li>Quick insights in Power BI</li><li>Create and configure a dashboard</li><li>Ask questions of your data with natural language</li><li>Create custom Q&amp;A suggestions</li><li>Share dashboards with your organization</li><li>Introduction to content packs, security, and groups</li><li>Publish Power BI Desktop reports</li><li>Print and export dashboards and reports</li><li>Create groups in Power BI</li><li>Use content packs</li><li>Update content packs</li><li>Publish to web</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>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 Visualisations, and publish Reports to different platforms.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Before attending this course, delegates should have:<br />- A general knowledge of database concepts (fields, records and relationships)<br />- Familiarity with Excel.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Business Intelligence<br /><br />Data Analysis<br /><br />ETL &amp; Data Warehousing</p> 
                        </div>

Microsoft Office Training

Microsoft Power BI Desktop (now with live online classes)

General Admission

<p>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<br />.</p> <p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Connect to data from different sources.</li><li>Use the Query Editor</li><li>Perform Power BI desktop data Shaping and Transformation.</li><li>Create Power BI desktop Modelling.</li><li>Create Power BI desktop Visualizations and Reports.</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>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.</p> <p>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.</p><p><strong>Introduction to Power BI</strong></p> <ul> <li>Power BI Jargon explained</li><li>A quick look at Power BI Desktop</li><li>A quick look at the Power BI service</li><li>Helpful resources</li></ul> <p><strong>Power BI and Excel</strong></p> <ul> <li>Introduction to using Excel data in Power BI</li><li>Upload Excel data to Power BI</li><li>Import Power View and Power Pivot to Power BI</li></ul> <p><strong>Getting started with Power BI Desktop</strong></p> <ul> <li>Overview of Power BI Desktop</li><li>Accessing Help and Helpful resources</li><li>Connect to data sources in Power BI Desktop</li></ul> <p><strong>Shaping and Transforming Data with Query Editor</strong></p> <ul> <li>Introduction to the Query Editor</li><li>Data Sources Power BI Desktop can Connect to</li><li>Introduction to Steps and M code</li><li>Combining Data Using Merge and Append Queries</li><li>Data Type Properties</li><li>Working with Delimiters</li><li>Clean and transform your data with the Query Editor</li><li>Text Specific Transformation Tools</li><li>Number Specific Transformation Tools</li><li>Date Specific Transformation Tools</li><li>Split and Merge columns</li><li>Creating an Index Column</li><li>Adding Conditional Columns</li><li>Columns From Examples</li><li>Grouping and Aggregating data</li><li>Pivoting and Unpivoting</li><li>Using filters</li></ul> <p><strong>Modeling the data</strong></p> <ul> <li>Introduction to modeling your data</li><li>How to manage your data relationships</li><li>Create calculated columns</li><li>Optimizing data models</li><li>Create calculated measures</li><li>Show Values As and Quick Measures</li><li>Create calculated tables</li><li>Explore your time-based data</li><li>Introduction to DAX</li><li>DAX calculation types</li><li>DAX functions</li></ul> <p><strong>Visualizations</strong></p> <ul> <li>Introduction to visuals in Power BI</li><li>Create and customize simple visualizations</li><li>Modify colors in charts and visuals</li><li>Shapes, text boxes, and images</li><li>Page layout and formatting</li><li>Group interactions among visualizations</li><li>Visual hierarchies and drill-down</li><li>Using custom visualizations</li><li>Create a KPI Visualization</li><li>Geo-Data and Maps</li></ul> <p><strong>Reports, Publishing and Sharing</strong></p> <ul> <li>Introduction to the Power BI service</li><li>Quick insights in Power BI</li><li>Create and configure a dashboard</li><li>Ask questions of your data with natural language</li><li>Create custom Q&amp;A suggestions</li><li>Share dashboards with your organization</li><li>Introduction to content packs, security, and groups</li><li>Publish Power BI Desktop reports</li><li>Print and export dashboards and reports</li><li>Create groups in Power BI</li><li>Use content packs</li><li>Update content packs</li><li>Publish to web</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>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.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Before attending this course, delegates should have:<br />- A general knowledge of database concepts (fields, records and relationships)<br />- Familiarity with Excel.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Business Intelligence<br /><br />Data Analysis<br /><br />ETL &amp; Data Warehousing</p> 
                        </div>

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

<div fr-original-style="" style="box-sizing: border-box;">
</div>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Training Course</strong><em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em></h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 3 full-day training course will introduce participants to the Microsoft Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The first two days focus on learning the key concepts and practising these using clean, simple datasets.&nbsp;The third day provides participants with the opportunity to apply what they&#39;ve learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn&#39;t be able to do what they need to do.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Microsoft&reg;&nbsp;PowerBI&reg; is a&nbsp;trademark&nbsp;of Microsoft Corporation in the United States and/or other countries.</em></strong></p>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div id="accordion" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Training Objectives 

</div>
<div id="collapseOne" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Upon completion of this training course, participants will be able to:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Confidently use the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;solution, including Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Desktop, PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com and the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Gateway</li>
<li fr-original-style="" style="box-sizing: border-box;">Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis</li>
<li fr-original-style="" style="box-sizing: border-box;">Combine data sources together and gain an introductory understanding of the M language</li>
<li fr-original-style="" style="box-sizing: border-box;">Write formulas using the DAX language for generating custom columns, measures and tables</li>
<li fr-original-style="" style="box-sizing: border-box;">Design reports and dashboards using a wide range of both built-in and custom visuals</li>
<li fr-original-style="" style="box-sizing: border-box;">Publish reports and dashboards to PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Share reports and dashboards with others using PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Customize reports and dashboards so that different user groups automatically see their own personalized views</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Target Audience 

</div>
<div id="collapseTwo" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training course is intended for:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Financial Analysts</li>
<li fr-original-style="" style="box-sizing: border-box;">Accountants</li>
<li fr-original-style="" style="box-sizing: border-box;">Budgeting and planning specialists</li>
<li fr-original-style="" style="box-sizing: border-box;">Treasury</li>
<li fr-original-style="" style="box-sizing: border-box;">Risk Managers</li>
<li fr-original-style="" style="box-sizing: border-box;">Strategic Planners</li>
</ul>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Course Level 

</div>
<div id="collapsecl" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Trainer

</div>
<div id="collapseFive" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Your expert course leader has a Masters (Applied Finance &amp; Investment), B.Comm (Accounting &amp; Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years&#39; experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He has trained delegates from a wide variety of Oil &amp; Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Highlights from his oil and gas experience include:</strong></p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Auditing and further development of life of project models for Chevron&#39;s Strategic Planning Division analysing their North West Shelf assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of business plan and budgeting models for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of cash flow and taxation models for a variety of oil gas companies.</li>
<li fr-original-style="" style="box-sizing: border-box;">Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment.</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &#39;One to One&#39; coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br fr-original-style="" style="box-sizing: border-box;">
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Accreditions And Affliations

</div>
<div id="collapseSeven" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Power BI® - Business Data Analytics

Team of 10, pp

Normal Fee, pp

Harpenden

<h2>Negotiation Skills in a Day</h2><p>Anybody that has achieved success in business will tell you that you never get the deal you deserve - you only get the deal you can negotiate!</p><p>This one-day workshop is based on research findings and effective techniques from the Harvard Business School Negotiation Project; it provides a unique opportunity to learn and practice these skills in a safe environment using up to date materials and life-like practice negotiation case studies.</p><p>Our expert one day skills workshop helps participants learn the skills and behaviours of good negotiation, and how to select the most appropriate negotiation strategy and tactics to achieve the best outcome possible. Each participant will leave the day armed with the confidence and practical negotiation skills to successfully apply in any situation.</p><h3>Learning objectives</h3><p>After completing this course participants will be able to:</p><ul><li>Understand the main types and style of negotiation and use the most appropriate strategy and tactics for each of them to achieve the best agreement</li><li>Apply the four most important concepts to put themselves in the strongest possible position in any negotiation</li><li>Use a systematic approach to preparing, presenting and concluding negotiated agreements</li><li>Analyse the power dynamics in a negotiation and apply tried and tested methods for communicating with, influencing and persuading the other side in a negotiation</li><li>Anticipate common barriers to agreement and use a tested approach to successfully concluding the deal they deserve!</li></ul><section>
                    <h3>What is negotiation?</h3><ul><li>Types of negotiation</li><li>Win-lose negotiations versus win-win negotiations</li><li>Wise agreements and principled negotiation</li><li>Key skills needed for negotiation</li></ul><h3>The four key negotiating concepts</h3><ul><li>BATNA - Best Alternative To Negotiated Agreement</li><li>Setting your reservation price</li><li>ZOPA - Zone Of Possible Agreement</li><li>Creating and trading value</li></ul><h3>Using a four phase model for negotiation</h3><ul><li>Nine steps to successful planning</li><li>Discussing a deal - creating and claiming value</li><li>Making and framing proposals</li><li>Bargaining for the winning deal</li></ul><h3>Communicating, influencing and persuading</h3><ul><li>Effective questioning and listening skills</li><li>Understanding and interpreting body-language</li><li>Barriers to effective communication</li><li>Understanding and using power</li><li>Proven ways to influence people</li><li>Six universal methods of persuasion</li></ul><h3>Negotiating tactics</h3><ul><li>Understanding what matters - what the numbers mean</li><li>Tactics for win-lose negotiations</li><li>Tactics for win-win negotiations</li><li>Effective team negotiating</li></ul><h3>Barriers to agreement</h3><ul><li>Common barriers to agreement</li><li>Dealing with die-hard negotiators</li><li>Dealing with lack of trust</li></ul><h3>Closing the deal</h3><ul><li>Four steps to closing the winning deal</li><li>How to know when to walk away from a deal</li></ul>


                </section>

Maximum Performance

Negotiation Skills in a Day

<h2>Negotiation Skills in a Day: In-House</h2><p>Anybody that has achieved success in business will tell you that you never get the deal you deserve - you only get the deal you can negotiate!</p><p>This one-day workshop is based on research findings and effective techniques from the Harvard Business School Negotiation Project; it provides a unique opportunity to learn and practice these skills in a safe environment using up to date materials and life-like practice negotiation case studies.</p><p>Our expert one day skills workshop helps participants learn the skills and behaviours of good negotiation, and how to select the most appropriate negotiation strategy and tactics to achieve the best outcome possible. Each participant will leave the day armed with the confidence and practical negotiation skills to successfully apply in any situation.</p><h3>Learning objectives</h3><p>After completing this course participants will be able to:</p><ul><li>Understand the main types and style of negotiation and use the most appropriate strategy and tactics for each of them to achieve the best agreement</li><li>Apply the four most important concepts to put themselves in the strongest possible position in any negotiation</li><li>Use a systematic approach to preparing, presenting and concluding negotiated agreements</li><li>Analyse the power dynamics in a negotiation and apply tried and tested methods for communicating with, influencing and persuading the other side in a negotiation</li><li>Anticipate common barriers to agreement and use a tested approach to successfully concluding the deal they deserve!</li></ul><section>
                    <h3>What is negotiation?</h3><ul><li>Types of negotiation</li><li>Win-lose negotiations versus win-win negotiations</li><li>Wise agreements and principled negotiation</li><li>Key skills needed for negotiation</li></ul><h3>The four key negotiating concepts</h3><ul><li>BATNA - Best Alternative To Negotiated Agreement</li><li>Setting your reservation price</li><li>ZOPA - Zone Of Possible Agreement</li><li>Creating and trading value</li></ul><h3>Using a four phase model for negotiation</h3><ul><li>Nine steps to successful planning</li><li>Discussing a deal - creating and claiming value</li><li>Making and framing proposals</li><li>Bargaining for the winning deal</li></ul><h3>Communicating, influencing and persuading</h3><ul><li>Effective questioning and listening skills</li><li>Understanding and interpreting body-language</li><li>Barriers to effective communication</li><li>Understanding and using power</li><li>Proven ways to influence people</li><li>Six universal methods of persuasion</li></ul><h3>Negotiating tactics</h3><ul><li>Understanding what matters - what the numbers mean</li><li>Tactics for win-lose negotiations</li><li>Tactics for win-win negotiations</li><li>Effective team negotiating</li></ul><h3>Barriers to agreement</h3><ul><li>Common barriers to agreement</li><li>Dealing with die-hard negotiators</li><li>Dealing with lack of trust</li></ul><h3>Closing the deal</h3><ul><li>Four steps to closing the winning deal</li><li>How to know when to walk away from a deal</li></ul>


                </section>

Negotiation Skills in a Day: In-House

<p>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.</p>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.<section>
                    <h3>1 The Query Editor</h3><ul><li>Grouping rows in a table</li><li>Split row by delimiter</li><li>Add days to determine deadlines</li><li>The query editor</li></ul> <h3>2 Fuzzy Matching Joins</h3><ul><li>Matching inconsistencies by percentage</li><li>Matching with transformation table</li></ul> <h3>3 The Query Editor M Functions</h3><ul><li>Adding custom columns</li><li>Creating an IF function</li><li>Nested AND logics in an IF function</li></ul> <h3>4 DAX New Columns Functions</h3><ul><li>Including TRUE with SWITCH</li><li>Using multiple conditions</li><li>The FIND DAX function</li><li>The IF DAX function</li><li>Logical functions IF, AND, OR</li></ul> <h3>5 Editing DAX Measures</h3><ul><li>Making DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>6 The Anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE filters</li><li>Add context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>7 The ALL Measure</h3><ul><li>Anatomy of ALL</li><li>Create an ALL measure</li><li>Using ALL as a filter</li><li>Use ALL for percentages</li></ul> <h3>8 DAX Iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED with SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>9 Date and Time Functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>10 Time Intelligent Measures</h3><ul><li>Compare historical monthly data</li><li>Create a DATEADD measure</li><li>Creating cumulative totals</li><li>Creating cumulative measures</li><li>Visualising cumulative totals</li></ul> <h3>11 Visualisations In-Depth</h3><ul><li>Utilising report themes</li><li>Applying static filters</li><li>Group data using lists</li><li>Group numbers using bins</li><li>Creating heatmaps</li><li>Comparing proportions</li><li>View trends with sparklines</li></ul> <h3>12 Comparing Variables</h3><ul><li>Visualising trendlines as KPI</li><li>Forecasting with trendlines</li><li>Creating a scatter plot</li><li>Creating dynamic labels</li><li>Customised visualisation tooltips</li><li>Export reports to SharePoint</li></ul> 


                </section>

The In House Training Company

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

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

Purley

Photography For Parents

Photography For Parents - Editing In Lightroom

SUTTON

<div style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Do you suffer from general anxiety? Is fear getting in the way of living your life the way you want? Tired of constantly worrying and feeling stressed?&nbsp;</span><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">This powerful coaching system will help you defeat general anxiety and build overall courage. Freedom In Courage is brought to you by the same experts who run Creature Courage, the UK&#39;s Leading animal phobia specialists. We get our clients over their extreme fears of animals in just one day! So we are expanding our expertise to help a wider range of anxiety problems.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Our expertise for anxiety treatment comes from the experience of treating people whilst actively facing their fears. This is unlike most therapists who are only treating their client&rsquo;s past fears or future anxieties. &nbsp; We can prove our methods work as we are literally putting it to the test during our actual therapy.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Years of this unique anxiety treatment has allowed Creature Courage to become experts in our field. <span style="color: rgb(14, 60, 84); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(14, 60, 84);">&nbsp;We have fine-tuned very powerful and effective strategies to tackle all anxiety triggers.&nbsp;</span>So we have created a new service, &#39;Freedom In Courage.&#39;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(255, 102, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 102, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Anxiety Treatment Based On The Science Of Change</strong></span></p></div><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Our more in-depth anxiety coaching course will give you time to build up your courage muscles. You can think of it as a personal trainer for the mind. It&rsquo;s scientifically proven that we work harder for others than ourselves, so our coaching will help you stay accountable for your self-growth.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Our new service can help anyone suffering from general anxiety by using a combination&nbsp;</span><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">of education,&nbsp;</span><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">various proven therapy techniques, and a transformational coaching approach to build lasting better habits to improve mental health.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">All the techniques are based on neuroscience of how the survival part of our brain copes with stress and pe</span><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">rceived threats. Also, we apply the science of</span><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">&nbsp;habit-breaking because anxiety is a conditioned negative behaviour.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">We will take you on an easy to follow step by step journey to start radically changing your life. &nbsp;If you have an animal phobia it will also better prepare you by</span><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">&nbsp;practicing on lower-level anxiety triggers.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">This course will take you on a powerful journey of self-discovery, enlightening your mind on how to take back control of your thoughts and find freedom from constant worrying and self-doubt. You will also learn to have more compassion, love, and patience for yourself. By the end of the course, you will have the skills and knowledge to better manage whatever life might throw at you. Now is the time to finally live your life in freedom, courage and peace! Try our new lifechanging anxiety treatment today.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(255, 102, 0); box-sizing: border-box;" fr-original-style=" color: rgb(255, 102, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Prices:</strong></span></p></div><div style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Freedom in Courage In-depth anxiety coaching without animal phobia treatment: &nbsp;&pound;450 which includes:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">&nbsp;&ndash; Half-day training session</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">&ndash; Four 50 minute coaching sessions for the initial package</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Additional coaching packages, the more you buy, the cheaper the price!</span></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Three sessions &pound;185</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Four sessions: &pound;240</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Five sessions: &pound;290</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">Please&nbsp;<a href="https://creaturecourage.com/contact-us/" style="color: rgb(46, 163, 242); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(46, 163, 242);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CONTACT US&nbsp;</strong></a></span><span style="color: rgb(14, 60, 84); box-sizing: border-box;" fr-original-style=" color: rgb(14, 60, 84);">or call us on <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">0800 970 4417&nbsp;</strong>for more info and to book</span>.</p></div>

Creature Courage

Health & Wellbeing

Hypnotherapy

Holistic Therapy

Art Therapy

Emotional Wellbeing

Mental Health

Neuro-Linguistic Programming (NLP)

Anxiety Management

Cognitive Behavioural Therapy (CBT)

Coaching

Children's Mental Health

Creative Therapy

Freedom In Courage is a specialised anxiety coaching service using powerful neuro science to radically liberate the mind from fear and worry. 

General Anxiety and Phobia Specialist Coaching

<p>All good managers use coaching to a certain extent. Some do it better than others. But then, some have had more training than others!</p>
<p>This two-day workshop will help you to take your coaching skills to the next level, making you an even more effective manager in the process.</p><ul><li>INCREASED SELF-AWARENESS OF YOUR OWN 'COACHING STYLE'</li><li>A CLEARER UNDERSTANDING OF WHAT COACHING IS AND WHEN TO USE A COACHING APPROACH</li><li>ENHANCED SKILLS IN DEVELOPING RAPPORT, LISTENING, QUESTIONING, GOAL-SETTING AND GIVING FEEDBACK</li></ul><section>
                    <h3>DAY ONE</h3><h4>1. Welcome and introduction</h4><ul><li>What will make the workshop worthwhile for you?</li></ul><h4>2. A coaching approach</h4><ul><li>What do we mean by a coaching approach? Myths and reality</li><li>Line manager as coach</li><li>Experiencing a coaching approach</li></ul><h4>3. An introduction to the four key coaching skills</h4><ul><li>Building trust and rapport</li><li>Active listening and powerful questions</li><li>Application: Skills practice - using powerful questions</li><li>Direct communication and giving feedback</li><li>Planning and goal-setting</li><li>Application: Skills practice - using the 'Time to Think' framework</li></ul><h4>4. The OSCAR coaching framework</h4><ul><li>The OSCAR model</li><li>Application: Skills practice - using the OSCAR model as a framework for a coaching conversation</li></ul><h4>5. Review and next steps</h4><ul><li>Reflections and action planning</li></ul><h3>DAY TWO</h3><h4>1. Learning review</h4><ul><li>Sparkling moments</li><li>What underpins a good coaching approach - core competencies</li><li>Coaching and Business Partnering competence</li></ul><h4>2. Exploring possibilities and challenging with integrity</h4><ul><li>Heron's Framework for 'coaching styles'</li><li>Your coaching / communication style</li><li>Application: Skills practice - 'popcorn' coaching activity</li><li>The support / challenge matrix</li><li>'Stretching' our clients - exploring possibilities to realise potential</li><li>Application: Skills practice - flexing our style to offer constructive challenge</li></ul><h4>3. What we are learning from neuroscience</h4><ul><li>Implications for a coaching approach</li><li>Solution-focused coaching</li><li>Application: Skills practice - OSCAR through the solution focus lens</li></ul><h4>4. Planning and goal-setting</h4><ul><li>GOT / WANT matrix - reflections on coaching strengths and areas for development</li><li>Application: Coaching conversations - personal development plan</li></ul><h4>5. Review and next steps</h4><ul><li>Reflections on learning</li><li>Commitments to action</li><li>Key learnings and take-aways</li></ul><h4>Optional Â½ day follow-up</h4><ul><li>Review learning, address issues arising and have the opportunity for skills practice and feedback.</li></ul>


                </section>

Coaching Skills for Line Managers

<p>This very practical workshop has a simple objective: to help you prepare, design and deliver memorable and high-quality presentations.</p>This programme will help you:<ul><li>Use a proven, structured tool-kit when designing and developing presentations</li><li>Benefit from short cuts and best practice when designing and using Powerpoint presentations</li><li>Select the right information, examples, exercises and activities - and use them well</li><li>Prepare and structure a presentation or session appropriate to the audience, and to best achieve your objectives</li><li>Maintain audience or group interest</li><li>Develop and practise presentation skills to improve your voice tone, speech power and body language</li><li>Use practical methods to control nerves and anxiety - develop higher levels of confidence and credibility</li><li>Command a room, hold attention and create a high impact</li></ul><section>
                    <h3>1 Introduction</h3><ul><li>Personal objectives</li><li>Key messages and learning objectives of the workshop</li></ul> <h3>2 Presentation skills</h3><ul><li>What does good look like?</li><li>Exercise: Characteristics of high/low impact presentations</li><li>Presenting yourself as a 'winner'</li><li>The energy / attitude model</li><li>Exercise: Being a winner</li></ul> <h3>3 Preparation skills - eight steps to preparing a great presentation, plus Powerpoint tips</h3>•The magic circle<br />• How to 'assume the role' when presenting<br />• The eight steps<br />• Step 1 - develop your objectives<br />- The five questions that you must answer before preparing your presentation<br />- Defining your objectives and outcomes<br />- Creating a first draft<br />- Step 1 exercise<br />• Step 2 - analyse your audience<br />- Doing your homework: audience, event, venue<br />- Developing a pre-event check-list<br />- Methods and means for researching your audience<br />- Step 2 exercise<br />• Steps 3 and 4 - structure the main body of your presentation and state the main ideas<br />- Ways to structure your presentation for maximum impact<br />- Balancing and managing content and topics<br />- Organising your information: 6 options and methods<br />- Your 'one main point' and creating a 30-second summary<br />- Steps 3 and 4 exercises<br />• Step 5 - decide on supporting information, using the toolkit<br />- Making your case convincing: ways to support your claims<br />- Selecting and using relevant and interesting examples<br />- Quotes, case studies and printed material<br />- Presenting statistics, tables and graphs<br />- Ways of maintaining visual interest<br />- Transitions and links, creating a 'golden thread'<br />- Step 5 exercise: Creating compelling stories and anecdotes<br />4<br />• Step 6 - create an effective 'opening'<br />- Claiming the stage and creating a good first impression<br />- The three most powerful ways of opening a presentation<br />- The five elements of a strong opening<br />- Step 6 exercise: Participants work individually to prepare an opening, focusing on<br />personal introduction, and then deliver to the group, with structured feedback<br />• Step 7 - develop transitions<br />- Step 7 exercise / examples<br />• Step 8 - create an effective close<br />- Signalling and sign-posting; the importance of, and how to do it effectively<br />- Five ways to close a presentation successfully<br />- Step 8 exercise / examples<br />• Presentation design and Powerpoint<br />- An interactive review of participants' own real-life past presentations and advanced tips<br />and techniques on using Powerpoint effectively <h3>4 Facilitation skills</h3><ul><li>The three main types of group activity - triads, teams and main group</li><li>How to select the right activity, define the objectives, set it up and run the debrief</li><li>Using energisers - with examples</li><li>Exercise: Dealing with 'difficult' behaviours</li><li>Exercise: Working in triads, design and deliver</li></ul> <h3>5 Tips and tricks: presentation and facilitation</h3><ul><li>10 reasons why facilitation fails</li><li>Five golden rules for success</li><li>Defining the session goals and the facilitation plan</li><li>Open and closed questions - why and when to use</li><li>Using a 'car park' to manage unresolved issues</li><li>Using AV aids - tips and tricks</li><li>Exercises: Including participants working in pairs to prepare a short section form of one of their own presentations</li></ul> <h3>6 Putting it all together</h3><ul><li>Summary of key learning points</li><li>Action plan</li></ul> 


                </section>

Executive Presentation

Coaching Skills

Meeting Skills

Facilitation Skills

Counselling Skills

Presentation Skills

Powerful presentation skills (In-House)

Power Plate

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Nexus Human

Azure PowerShell

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.</p><p></p><p></p><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p><p></p>Prerequisites<p>In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:   </p><li>AZ-900T00 Microsoft Azure Fundamentals  </li><li>DP-900T00 Microsoft Azure Data Fundamentals<p></p></li></div><div id="course-pills-2"><h3>1 - Prepare to maintain SQL databases on Azure</h3> <ul> <li>Describe Microsoft Intelligent Data Platform roles</li> <li>Understand SQL Server in an Azure virtual machine</li> <li>Design Azure SQL Database for cloud-native applications</li> <li>Explore Azure SQL Database Managed Instance</li> </ul> <h3>2 - Deploy IaaS solutions with Azure SQL</h3> <ul> <li>Explain IaaS options to deploy SQL Server in Azure</li> <li>Understand hybrid scenarios</li> <li>Explore performance and security</li> <li>Explain high availability and disaster recovery options</li> </ul> <h3>3 - Deploy PaaS solutions with Azure SQL</h3> <ul> <li>Explain PaaS options for deploying SQL Server in Azure</li> <li>Explore single SQL database</li> <li>Deploy SQL database elastic pool</li> <li>Understand SQL database hyperscale</li> <li>Examine SQL managed instance</li> <li>Describe SQL Edge</li> </ul> <h3>4 - Evaluate strategies for migrating to Azure SQL</h3> <ul> <li>Understand compatibility level</li> <li>Understand Azure preview features</li> <li>Describe Azure database migration options</li> </ul> <h3>5 - Migrate SQL workloads to Azure SQL databases</h3> <ul> <li>Choose the right SQL Server Instance option in Azure</li> <li>Migrate SQL Server to Azure SQL Database offline</li> <li>Migrate SQL Server to Azure SQL Database online</li> <li>Load and move data to Azure SQL Database</li> </ul> <h3>6 - Migrate SQL workloads to Azure Managed Instances</h3> <ul> <li>Evaluate migration scenarios to SQL Database Managed Instance</li> <li>Migrate to SQL Database Managed Instance</li> <li>Load and Move data to SQL Database Managed Instance</li> </ul> <h3>7 - Configure database authentication and authorization</h3> <ul> <li>Describe Active Directory and Azure Active Directory</li> <li>Describe authentication and identities</li> <li>Describe Security Principals</li> <li>Describe database and object permissions</li> <li>Identify authentication and authorization failures</li> </ul> <h3>8 - Protect data in-transit and at rest</h3> <ul> <li>Explore Transparent Data Encryption</li> <li>Configure server and database firewall rules</li> <li>Explain object encryption and secure enclaves</li> <li>Enable encrypted connections</li> <li>Describe SQL injection</li> <li>Understand Azure Key Vault</li> </ul> <h3>9 - Implement compliance controls for sensitive data</h3> <ul> <li>Explore data classification</li> <li>Explore server and database audit</li> <li>Implement Dynamic Data Masking</li> <li>Implement Row Level security</li> <li>Understand Microsoft Defender for SQL</li> <li>Explore Azure SQL Database Ledger</li> <li>Implement Azure Purview</li> </ul> <h3>10 - Describe performance monitoring</h3> <ul> <li>Describe performance monitoring tools</li> <li>Describe critical performance metrics</li> <li>Establish baseline metrics</li> <li>Explore extended events</li> <li>Describe Azure SQL Insights</li> <li>Explore Query Performance Insight</li> </ul> <h3>11 - Configure SQL Server resources for optimal performance</h3> <ul> <li>Explain how to optimize Azure storage for SQL Server virtual machines</li> <li>Describe virtual machine resizing</li> <li>Optimize database storage</li> <li>Control SQL Server resources</li> </ul> <h3>12 - Configure databases for optimal performance</h3> <ul> <li>Explore database maintenance checks</li> <li>Describe database scoped configuration options</li> <li>Describe automatic tuning</li> <li>Describe intelligent query processing</li> </ul> <h3>13 - Explore query performance optimization</h3> <ul> <li>Understand query plans</li> <li>Explain estimated and actual query plans</li> <li>Describe dynamic management views and functions</li> <li>Explore Query Store</li> <li>Identify problematic query plans</li> <li>Describe blocking and locking</li> </ul> <h3>14 - Evaluate performance improvements</h3> <ul> <li>Describe wait statistics</li> <li>Tune and maintain indexes</li> <li>Understand query hints</li> </ul> <h3>15 - Explore performance-based design</h3> <ul> <li>Describe normalization</li> <li>Choose appropriate data types</li> <li>Design indexes</li> </ul> <h3>16 - Automate deployment of database resources</h3> <ul> <li>Describe deployment models in Azure</li> <li>Automate deployment by using Azure Resource Manager templates and Bicep</li> <li>Automate deployment by using PowerShell</li> <li>Automate deployment by using Azure CLI</li> </ul> <h3>17 - Create and manage SQL Agent jobs</h3> <ul> <li>Create a SQL Server maintenance plan</li> <li>Describe task status notifications</li> </ul> <h3>18 - Manage Azure PaaS tasks using automation</h3> <ul> <li>Explore Elastic jobs</li> <li>Understand Azure Automation</li> <li>Build an automation runbook</li> <li>Automate database workflows by using Logic Apps</li> <li>Monitor automated tasks</li> </ul> <h3>19 - Describe high availability and disaster recovery strategies</h3> <ul> <li>Describe recovery time objective and recovery point objective</li> <li>Explore high availability and disaster recovery options</li> <li>Describe Azure high availability and disaster recovery  features for Azure Virtual Machines</li> <li>Describe high availability and disaster recovery options for PaaS deployments</li> <li>Explore an IaaS high availability and disaster recovery solution</li> <li>Describe hybrid solutions</li> </ul> <h3>20 - Explore IaaS and PaaS solutions for high availability and disaster recovery</h3> <ul> <li>Describe failover clusters in Windows Server</li> <li>Configure Always-on availability groups</li> <li>Describe temporal tables in Azure SQL Database</li> <li>Describe active geo-replication for Azure SQL Database</li> <li>Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance</li> </ul> <h3>21 - Back up and restore databases</h3> <ul> <li>Back up and restore SQL Server running on Azure virtual machines</li> <li>Back up a SQL Server virtual machine</li> <li>Back up and restore a database using Azure SQL Database</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the DP-300T00: Administering Microsoft Azure SQL Solutions course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Azure SQL Database

Microsoft AZ-900

Microsoft Azure

Microsoft AZ-700

DP-300T00 Administering Microsoft Azure SQL Solutions

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This four-day course is intended for Windows Server Hybrid Administrators who have experience working with Windows Server and want to extend the capabilities of their on-premises environments by combining on-premises and hybrid technologies. Windows Server Hybrid Administrators implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.</p><p></p><p></p><p>This course teaches IT Professionals how to manage core Windows Server workloads and services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.</p><p></p>Prerequisites<p></p><li>Experience with managing Windows Server operating system and Windows Server workloads in on-premises scenarios, including AD DS, DNS, DFS, Hyper-V, and File and Storage Services  </li><li>Experience with common Windows Server management tools (implied in the first prerequisite).  </li><li>Basic knowledge of core Microsoft compute, storage, networking, and virtualization technologies (implied in the first prerequisite).  </li><li>Experience and an understanding of core networking technologies such as IP addressing, name resolution, and Dynamic Host Configuration Protocol (DHCP)  </li><li>Experience working with and an understanding of Microsoft Hyper-V and basic server virtualization concepts  </li><li>Basic experience with implementing and managing IaaS services in Microsoft Azure  </li><li>Basic knowledge of Azure Active Directory  </li><li>Experience working hands-on with Windows client operating systems such as Windows 10 or Windows 11  </li><li>Basic experience with Windows PowerShell<p></p></li></div><div id="course-pills-2"><h3>1 - Introduction to AD DS</h3> <ul> <li>Define AD DS</li> <li>Define users, groups, and computers</li> <li>Define AD DS forests and domains</li> <li>Define OUs</li> <li>Manage objects and their properties in AD DS</li> </ul> <h3>2 - Manage AD DS domain controllers and FSMO roles</h3> <ul> <li>Deploy AD DS domain controllers</li> <li>Maintain AD DS domain controllers</li> <li>Manage the AD DS Global Catalog role</li> <li>Manage AD DS operations masters</li> <li>Manage AD DS schema</li> </ul> <h3>3 - Implement Group Policy Objects</h3> <ul> <li>Define GPOs</li> <li>Implement GPO scope and inheritance</li> <li>Define domain-based GPOs</li> <li>Create and configure a domain-based GPO</li> <li>Define GPO storage</li> <li>Define administrative templates</li> </ul> <h3>4 - Manage advanced features of AD DS</h3> <ul> <li>Create trust relationships</li> <li>Implement ESAE forests</li> <li>Monitor and troubleshoot AD DS</li> <li>Create custom AD DS partitions</li> </ul> <h3>5 - Implement hybrid identity with Windows Server</h3> <ul> <li>Select a Microsoft Entra integration model</li> <li>Plan for Microsoft Entra integration</li> <li>Prepare on-premises Active Directory for directory synchronization</li> <li>Install and configure directory synchronization with Microsoft Entra Connect</li> <li>Implement Seamless Single Sign-On</li> <li>Enable Microsoft Entra login in for Windows VM in Azure</li> <li>Describe Microsoft Entra Domain Services</li> <li>Implement and configure Microsoft Entra Domain Services</li> <li>Manage Windows Server 2019 in a Microsoft Entra Domain Services environment</li> <li>Create and configure a Microsoft Entra Domain Services instance</li> <li>Join a Windows Server VM to a managed domain</li> </ul> <h3>6 - Deploy and manage Azure IaaS Active Directory domain controllers in Azure</h3> <ul> <li>Select an option to implement directory and identity services using Active Directory Domain Services in Azure</li> <li>Deploy and configure Active Directory Domain Services domain controllers in Azure VMs</li> <li>Install a replica Active Directory domain controller in an Azure VM</li> <li>Install a new Active Directory forest on an Azure VNet</li> </ul> <h3>7 - Perform Windows Server secure administration</h3> <ul> <li>Define least privilege administration</li> <li>Implement delegated privileges</li> <li>Use privileged access workstations</li> <li>Use jump servers</li> </ul> <h3>8 - Describe Windows Server administration tools</h3> <ul> <li>Explore Windows Admin Center</li> <li>Use Server Manager</li> <li>List Remote Server Administration Tools</li> <li>Use Windows PowerShell</li> <li>Use Windows PowerShell to remotely administer a server</li> </ul> <h3>9 - Perform post-installation configuration of Windows Server</h3> <ul> <li>List the available post-installation configuration tools</li> <li>Configure Server Core using Sconfig</li> <li>Use DSC to configure Windows Server</li> <li>Perform post-installation configuration with Windows Admin Center</li> <li>Configure a server with answer files</li> </ul> <h3>10 - Just Enough Administration in Windows Server</h3> <ul> <li>Explain the concept of Just Enough Administration (JEA)</li> <li>Define role capabilities for a JEA endpoint</li> <li>Create a session configuration file to register a JEA endpoint</li> <li>Describe how JEA endpoints work to limit access to a PowerShell session</li> <li>Create and connect to a JEA endpoint</li> <li>Demonstration: Connect to a JEA endpoint</li> </ul> <h3>11 - Administer and manage Windows Server IaaS Virtual Machine remotely</h3> <ul> <li>Select the appropriate remote administration tool</li> <li>Manage Windows Virtual Machines with Azure Bastion</li> <li>Create an Azure Bastion host</li> <li>Configure just-in-time administration</li> </ul> <h3>12 - Manage hybrid workloads with Azure Arc</h3> <ul> <li>Describe Azure Arc</li> <li>Onboard Windows Server instances</li> <li>Connect hybrid machines to Azure from the Azure portal</li> <li>Use Azure Arc to manage Windows Server instances</li> <li>Restrict access with RBAC</li> </ul> <h3>13 - Configure and manage Hyper-V</h3> <ul> <li>Define Hyper-V</li> <li>Define Hyper-V Manager</li> <li>Configure Hyper-V hosts using best practices</li> <li>Configure Hyper-V networking</li> <li>Assess advanced Hyper-V networking features</li> <li>Define nested virtualization</li> </ul> <h3>14 - Configure and manage Hyper-V virtual machines</h3> <ul> <li>List the virtual machine configuration versions</li> <li>List the virtual machine generation versions</li> <li>List available VHD formats and types</li> <li>Create and configure VMs</li> <li>Determine storage options for VMs</li> <li>Define shared VHDs and VHD Sets</li> <li>Implement guest clusters using shared VHDX</li> </ul> <h3>15 - Secure Hyper-V workloads</h3> <ul> <li>Define guarded fabric</li> <li>Define the Host Guardian Service</li> <li>Explore TPM-trusted attestation</li> <li>Define KPS</li> <li>Determine key features of shielded VMs</li> <li>Compare encryption-supported and shielded VMs in a guarded fabric</li> <li>Implement a shielded VM</li> </ul> <h3>16 - Run containers on Windows Server</h3> <ul> <li>Define containers</li> <li>List the differences between containers and VMs</li> <li>Define Windows Server and Hyper-V containers and isolation modes</li> <li>Explore Docker</li> <li>Prepare a Windows Server 2019 host for container deployment</li> <li>Security, Storage, and Networking with Windows containers</li> </ul> <h3>17 - Orchestrate containers on Windows Server using Kubernetes</h3> <ul> <li>Define orchestration</li> <li>Define Kubernetes</li> <li>Deploy Kubernetes resources</li> <li>Create a Kubernetes cluster on Windows</li> <li>Define Azure Arc</li> <li>Connect an Azure Arc-enabled Kubernetes cluster to Azure Arc</li> </ul> <h3>18 - Plan and deploy Windows Server IaaS Virtual Machines</h3> <ul> <li>Describe Azure compute</li> <li>Describe Virtual Machine storage</li> <li>Deploy Azure Virtual Machines</li> <li>Create a windows Virtual Machine using the portal</li> <li>Create a windows Virtual Machine using Azure CLI</li> <li>Deploy Azure Virtual Machines using templates</li> <li>Describe additional management optimization options</li> </ul> <h3>19 - Customize Windows Server IaaS Virtual Machine images</h3> <ul> <li>Create a generalized image</li> <li>Create a new Virtual Machine from a managed image</li> <li>Create a managed image of a generalized virtual machine in Azure</li> <li>Create a Virtual Machine from a managed image</li> <li>Implement Azure Image Builder</li> <li>Create a windows Virtual Machine using Azure Image Builder template</li> <li>Create a Windows Virtual Machine with Azure Image Builder using PowerShell</li> </ul> <h3>20 - Automate the configuration of Windows Server IaaS Virtual Machines</h3> <ul> <li>Describe Azure Automation</li> <li>Implement Azure Automation with DSC</li> <li>Remediate noncompliant servers</li> <li>Describe Custom Script Extensions</li> <li>Configure a Virtual Machine by using DSC</li> </ul> <h3>21 - Deploy and manage DHCP</h3> <ul> <li>Use DHCP to simplify IP configuration</li> <li>Install and configure the DHCP role</li> <li>Configure DHCP options</li> <li>Configure DHCP scopes</li> <li>Select DHCP high availability options</li> <li>Implement DHCP Failover</li> </ul> <h3>22 - Implement Windows Server DNS</h3> <ul> <li>Explore the DNS architecture</li> <li>Work with DNS zones and records</li> <li>Install and configure the DNS role</li> <li>Implement DNS forwarding</li> </ul> <h3>23 - Implement IP Address Management</h3> <ul> <li>Define IP Address Management</li> <li>Deploy IP Address Management</li> <li>Administer IP Address Management</li> <li>Configure IP Address Management options</li> <li>Manage DNS zones with IP Address Management</li> <li>Manage DHCP servers with IP Address Management</li> <li>Use IP Address Management to manage IP addressing</li> </ul> <h3>24 - Implement remote access</h3> <ul> <li>Examine the remote access options in Windows Server</li> <li>Select and set up VPNs</li> <li>Use NPS to create and enforce network access policies</li> <li>Plan and implement NPS</li> <li>Deploy a PKI for remote access</li> <li>Use WAP as a reverse web proxy</li> </ul> <h3>25 - Implement hybrid network infrastructure</h3> <ul> <li>Describe Azure network topologies</li> <li>Implement Azure VPN options</li> <li>Create a route-based VPN gateway using the Azure portal</li> <li>Implement Azure ExpressRoute</li> <li>Configure Azure Virtual WAN</li> <li>Implement DNS in hybrid environments</li> </ul> <h3>26 - Implement DNS for Windows Server IaaS VMs</h3> <ul> <li>Understand Azure DNS</li> <li>Implement Azure DNS</li> <li>Create an Azure DNS zone and record using the Azure portal</li> <li>Implement DNS with Azure IaaS virtual machines</li> <li>Implement split-horizon DNS in Azure</li> <li>Troubleshoot DNS</li> </ul> <h3>27 - Implement Windows Server IaaS VM IP addressing and routing</h3> <ul> <li>Implement a virtual network</li> <li>Implement IaaS VM IP addressing</li> <li>Assign and manage IP addresses</li> <li>Configure a private IP address for a virtual machine using the Azure portal</li> <li>Create a virtual machine with a static public IP address using the Azure portal</li> <li>Implement IaaS virtual machine IP routing</li> <li>Implement IPv6 for Windows Server IaaS virtual machines</li> </ul> <h3>28 - Manage Windows Server file servers</h3> <ul> <li>Define the Windows Server file system</li> <li>List the benefits and uses of File Server Resource Manager</li> <li>Define SMB and its security considerations</li> <li>Configure SMB protocol</li> <li>Define Volume Shadow Copy Service</li> </ul> <h3>29 - Implement Storage Spaces and Storage Spaces Direct</h3> <ul> <li>Define the Storage Spaces architecture and its components</li> <li>List the functionalities, benefits, and use cases of Storage Spaces</li> <li>Implement Storage Spaces</li> <li>List the functionalities, components, benefits, and use cases of Storage Spaces Direct</li> <li>Implement Storage Spaces Direct</li> </ul> <h3>30 - Implement Windows Server Data Deduplication</h3> <ul> <li>Define the architecture, components, and functionality of Data Deduplication</li> <li>Define the use cases and interoperability of Data Deduplication</li> <li>Implement Data Deduplication</li> <li>Manage and maintain Data Deduplication</li> </ul> <h3>31 - Implement Windows Server iSCSI</h3> <ul> <li>List the functionalities, components, and use cases of iSCSI</li> <li>List the considerations for implementing iSCSI</li> <li>Implement iSCSI</li> <li>Configure high availability for iSCSI</li> </ul> <h3>32 - Implement Windows Server Storage Replica</h3> <ul> <li>List the functionalities and components of Storage Replica</li> <li>Examine the prerequisites for implementing Storage Replica</li> <li>Implement Storage Replica by using Windows Admin Center</li> <li>Implement Storage Replica by using Windows PowerShell</li> </ul> <h3>33 - Implement a hybrid file server infrastructure</h3> <ul> <li>Describe Azure File services</li> <li>Configure Azure Files</li> <li>Configure connectivity to Azure Files</li> <li>Describe Azure File Sync</li> <li>Implement Azure File Sync</li> <li>Deploy Azure File Sync</li> <li>Deploy Azure File Sync 2</li> <li>Manage cloud tiering</li> <li>Migrate from DFSR to Azure File Sync</li> </ul></div>

Microsoft Certified Solutions Associate (MCSA)

Windows Server

AZ-800T00 Administering Windows Server Hybrid Core Infrastructure

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-400T00 Microsoft Power Platform Developer course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Microsoft PL-900

Microsoft Power Apps

Power Apps

PL-400T00 Microsoft Power Platform Developer

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p></p><p>The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.</p><p></p><p></p><p>This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.</p><p></p>Prerequisites<p></p><li>Understanding core data concepts.</li>  <li>Knowledge of working with relational data in the cloud.</li>  <li>Knowledge of working with non-relational data in the cloud.</li>   <li>Knowledge of data analysis and visualization concepts.</li>   <li>DP-900T00 Microsoft Azure Data Fundamentals is recommended<p></p></li></div><div id="course-pills-2"><h3>1 - Discover data analysis</h3> <ul> <li>Overview of data analysis</li> <li>Roles in data</li> <li>Tasks of a data analyst</li> </ul> <h3>2 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>3 - Get data in Power BI</h3> <ul> <li>Get data from files</li> <li>Get data from relational data sources</li> <li>Create dynamic reports with parameters</li> <li>Get data from a NoSQL database</li> <li>Get data from online services</li> <li>Select a storage mode</li> <li>Get data from Azure Analysis Services</li> <li>Fix performance issues</li> <li>Resolve data import errors</li> </ul> <h3>4 - Clean, transform, and load data in Power BI</h3> <ul> <li>Shape the initial data</li> <li>Simplify the data structure</li> <li>Evaluate and change column data types</li> <li>Combine multiple tables into a single table</li> <li>Profile data in Power BI</li> <li>Use Advanced Editor to modify M code</li> </ul> <h3>5 - Design a semantic model in Power BI</h3> <ul> <li>Work with tables</li> <li>Create a date table</li> <li>Work with dimensions</li> <li>Define data granularity</li> <li>Work with relationships and cardinality</li> <li>Resolve modeling challenges</li> </ul> <h3>6 - Add measures to Power BI Desktop models</h3> <ul> <li>Create simple measures</li> <li>Create compound measures</li> <li>Create quick measures</li> <li>Compare calculated columns with measures</li> </ul> <h3>7 - Add calculated tables and columns to Power BI Desktop models</h3> <ul> <li>Create calculated columns</li> <li>Learn about row context</li> <li>Choose a technique to add a column</li> </ul> <h3>8 - Use DAX time intelligence functions in Power BI Desktop models</h3> <ul> <li>Use DAX time intelligence functions</li> <li>Additional time intelligence calculations</li> </ul> <h3>9 - Optimize a model for performance in Power BI</h3> <ul> <li>Review performance of measures, relationships, and visuals</li> <li>Use variables to improve performance and troubleshooting</li> <li>Reduce cardinality</li> <li>Optimize DirectQuery models with table level storage</li> <li>Create and manage aggregations</li> </ul> <h3>10 - Design Power BI reports</h3> <ul> <li>Design the analytical report layout</li> <li>Design visually appealing reports</li> <li>Report objects</li> <li>Select report visuals</li> <li>Select report visuals to suit the report layout</li> <li>Format and configure visualizations</li> <li>Work with key performance indicators</li> </ul> <h3>11 - Configure Power BI report filters</h3> <ul> <li>Apply filters to the report structure</li> <li>Apply filters with slicers</li> <li>Design reports with advanced filtering techniques</li> <li>Consumption-time filtering</li> <li>Select report filter techniques</li> <li>Case study - Configure report filters based on feedback</li> </ul> <h3>12 - Enhance Power BI report designs for the user experience</h3> <ul> <li>Design reports to show details</li> <li>Design reports to highlight values</li> <li>Design reports that behave like apps</li> <li>Work with bookmarks</li> <li>Design reports for navigation</li> <li>Work with visual headers</li> <li>Design reports with built-in assistance</li> <li>Tune report performance</li> <li>Optimize reports for mobile use</li> </ul> <h3>13 - Perform analytics in Power BI</h3> <ul> <li>Explore statistical summary</li> <li>Identify outliers with Power BI visuals</li> <li>Group and bin data for analysis</li> <li>Apply clustering techniques</li> <li>Conduct time series analysis</li> <li>Use the Analyze feature</li> <li>Create what-if parameters</li> <li>Use specialized visuals</li> </ul> <h3>14 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>15 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>16 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>17 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-300T00: Microsoft Power BI Data Analyst training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.  <p></p>While we feel this is the best course for the PL-300T00: Microsoft Power BI Data Analyst course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

Microsoft Certification

Microsoft 365

MS-102T00 Microsoft 365 Administrator Essentials

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint.</p>Overview<p>Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365</p><p>This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. <br /><br /> Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans.</p></div><div id="course-pills-2"><h3>1 - Planning and Provisioning Office 365</h3> <ul> <li>Overview of Office 365</li> <li>Core Services of Office 365</li> <li>Requirements for an Office 365 Tenant</li> <li>Planning a Pilot and Deployment</li> <li>Creating an Office 365 Tenant</li> <li>Adding Custom Domains and Managing DNS Settings</li> <li>Lab: Provisioning Office 365</li> </ul> <h3>2 - Managing Users and Groups in Office 365</h3> <ul> <li>Managing User Accounts and Licences</li> <li>Managing Passwords and Authentication</li> <li>Create and Managing the Different Types of Groups in Office 365</li> <li>Managing Users and Groups with PowerShell</li> <li>Managing Users and Groups in the Azure AD Admin Center</li> <li>Role Based Access and Administrative Roles</li> <li>Planning and Configuring Directory Synchronization</li> <li>Lab: Managing Users and Groups in Office 365</li> <li>Lab: Planning and Configuring Directory Synchronisation</li> </ul> <h3>3 - Deploying and Configuring Tools and Applications for Office 365</h3> <ul> <li>Planning Network Configuration for Office 365 Tools and Applications</li> <li>Using the Office Configuration Tool</li> <li>Click to Run Installation Use and Control</li> <li>Managing Centralized Deployment of Tools, Applications and Add-ins</li> <li>Reporting</li> <li>Lab: Deploying and Configuring Tools and Applications for Office 365</li> </ul> <h3>4 - Planning and Managing Exchange Online</h3> <ul> <li>What is Exchange Online</li> <li>Managing Exchange Online Mailboxes</li> <li>Managing Office 365 Groups in Exchange Online</li> <li>Configuring Exchange Online Permissions</li> <li>Managing Exchange Online using PowerShell</li> <li>Plan and Configure Mail Flow</li> <li>Plan and Configure Email Protection</li> <li>Lab: Planning and Managing Exchange Online</li> </ul> <h3>5 - Planning and Managing SharePoint Online</h3> <ul> <li>What is SharePoint Online</li> <li>Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups</li> <li>SharePoint Online Architecture</li> <li>Configure SharePoint Online</li> <li>Configure and Control External Sharing</li> <li>Managing SharePoint Online Site Collections</li> <li>Managing SharePoint Online using PowerShell</li> <li>Lab: Planning and Managing SharePoint Online</li> </ul> <h3>6 - Planning and Managing Microsoft Teams</h3> <ul> <li>What is Microsoft Teams</li> <li>How Microsoft Teams integrates with other Office 365 Services</li> <li>Create and Manage Organization Wide Settings</li> <li>Create, Manage and Assign Microsoft Teams Policies</li> <li>Plan and Configure External and Guest Access</li> <li>Managing Microsoft Teams using PowerShell</li> <li>Lab: Planning and Managing Microsoft Teams</li> </ul> <h3>7 - Planning and Managing Other Office 365 Services</h3> <ul> <li>Yammer</li> <li>Planner</li> <li>Visio</li> <li>Bookings</li> <li>Delve</li> <li>Forms</li> <li>Power Platform</li> <li>Stream</li> <li>Sway</li> <li>Viva</li> <li>Scheduler</li> <li>Add-ins, including Find Time and Junk Reporter</li> <li>Lab: Planning and Managing Office 365 Services</li> </ul> <h3>8 - Security and Compliance in Office 365</h3> <ul> <li>Overview of Security and Compliance Features in Office 365</li> <li>Extending Security and compliance Features with Additional Licences</li> <li>Using the Microsoft Defender Portal and Secure Score</li> <li>Using the Office 365 Compliance Portal and Compliance Score</li> <li>Plan and Configure Retention Labels and Policies</li> <li>Plan and Configure Data Loss Prevention Policies</li> <li>Create and Assign Sensitivity Labels</li> <li>Configure Safe Attachments and Safe Links Policies</li> <li>Plan and Configure Multi Factor Authentication</li> <li>Lab: Configure Security and Compliance in Office 365</li> </ul> <h3>9 - Reporting, Monitoring and Troubleshooting Office 365</h3> <ul> <li>Monitoring Office 365 Service Health</li> <li>Troubleshooting Administrative Access in Office 365</li> <li>Troubleshoot Directory Synchronization</li> <li>Troubleshooting Exchange Online</li> <li>Troubleshooting SharePoint Online</li> <li>Troubleshooting Microsoft Teams</li> <li>Troubleshooting Office 365 Security and Compliance</li> <li>Lab: Reporting, Monitoring and Troubleshooting in Office 365</li> </ul></div>

55354 Administering Office 365

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users.</p>Overview<p>At course completion, you should be able to<br />describe DAX syntax, data types, and errors<br />use DAX to create calculated columns, measures, and tables<br />explain how DAX calculations are evaluated, along with the differences between row context and filter context<br />configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.<br />create calculated columns and measures that use data from multiple tables in the data model<br />write measures that handle error conditions gracefully<br />use DAX to enhance the Power BI user experience<br />use DAX Studio to connect to a Power BI data model and execute simple queries</p><p>Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code.</p></div><div id="course-pills-2"><h4>MODULE 1: GETTING STARTED WITH DAX </h4><ul><li>INTRODUCTION TODAX </li><li>CREATING OBJECTS WITHDAX </li><li>CONTEXT AND RULES OF EVALUATION</li><li>VARIABLES,COMMENTS,AND TESTING</li></ul><h4>MODULE 2: PERFORMING BASIC CALCULATIONS</h4><ul><li>GETTING STARTED</li><li>IMPLICIT MEASURES </li><li>ADDING QUICK MEASURES </li><li>WORKING WITH DAX DATA TYPES .</li><li>DOING BASIC MATH </li><li>USING LOGIC IN YOUR CALCULATIONS </li><li>USING THE IF() FUNCTION </li><li>NESTED IF()</li><li>USING THE SWITCH() FUNCTION </li><li>ADVANCED SWITCH()</li><li>LOGICAL OPERATORS &amp; FUNCTIONS: ||, OR(), &amp;&amp;, AND(), NOT()</li><li>AGGREGATING AND SUMMARIZING DATA </li><li>THE SUM() FUNCTION</li></ul><h4>MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL </h4><ul><li>CONTEXT DEFINED </li><li>DATA MODELING BASICS </li><li>INTRODUCTION TO DIMENSIONAL MODELING </li><li>RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT </li><li>GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE</li><li>LOOKING UP DATA WITHOUT USING RELATIONSHIPS </li><li>MODIFYING THE CONTEXT USING CALCULATE()</li></ul><h4>MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS </h4><ul><li>THE DAX ITERATOR FUNCTIONS </li><li>USING TABLE MANIPULATION FUNCTIONS</li></ul><h4>MODULE 5: WORKING WITH TIME</h4><ul><li>PERFORMING DATE CALCULATIONS </li><li>WORKING WITH DATE TABLES </li><li>GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION </li><li>DEFINING CUSTOM OPERATING PERIODS </li><li>YTD, QTD, AND MTD CALCULATIONS </li><li>CUSTOM TO-DATE CALCULATIONS </li><li>FINDING YEAR-OVER-YEAR CHANGE </li><li>FINDING MOVING AVERAGES </li></ul><h4>MODULE 6: ENHANCING THE USER EXPERIENCE</h4><ul><li>CONTROLLING VISIBILITYOF YOUR MEASURES</li><li>USING WHAT-IF PARAMETERS </li><li>ADDING BANDING </li><li>USING DAX TO PROVIDE ROW-LEVEL SECURITY </li></ul></div>

Data Analysis Expressions

Data Skills

Introduction to DAX for Power BI

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones.</p>Overview<p>#NAME?</p><p>This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates.</p></div><div id="course-pills-2"><h3>1 - An Introduction to Power Automate</h3> <ul> <li>What is Microsoft Power Automate?</li> <li>The benefits of automation</li> <li>How to get to Power Automate</li> <li>Lab 1: Setup your tenant</li> <li>Setup Office 365</li> <li>Download Course Files</li> <li>Customise your App Launcher</li> <li>Create accounts for colleagues</li> <li>After completing this module, students will be able to:</li> <li>Know what Microsoft Power Automate is</li> <li>The Benefits of using Power Automate to automate processes</li> <li>How to access a Power Automate</li> </ul> <h3>2 - Getting Started with Power Automate</h3> <ul> <li>Using Power Automate templates</li> <li>Navigating in Power Automate</li> <li>Editing a Power Automate</li> <li>Publish and trigger a Power Automate</li> <li>Turn off or delete a Power Automate</li> <li>Lab 1: Building processes in Office 365</li> <li>Create a Team with a channel</li> <li>Build an absence business process</li> <li>Testing the absence process</li> <li>Optional: Create Feedback Form</li> <li>Optional: Power Automate to Notify of Bad Ratings</li> <li>Optional: Test your Form and Power Automate</li> <li>After completing this module, students will be able to:</li> <li>How to use Power Automate tempaltes</li> <li>How to navigate around Power Automate</li> <li>How to edit Power Automates</li> <li>How to publish and trigger Power Automates</li> <li>How to turn off or delete Power Automates</li> </ul> <h3>3 - Power Automate Logic</h3> <ul> <li>Adding conditions</li> <li>Designing switches</li> <li>Using apply to each</li> <li>Configuring do until logic</li> <li>Adding a scope</li> <li>Lab 1: Scheduling documentation reviews</li> <li>Setup a policy library in SharePoint</li> <li>Design a policy review schedule</li> <li>Testing the policy review process</li> <li>Optional: Notify if a file nears review</li> <li>After completing this module, students will be able to:</li> <li>How to add condtions in a Power Automate</li> <li>How to design switches for a Power Automate</li> <li>How to use apply to each</li> <li>How to configure do until logic</li> <li>How to add a scope</li> </ul> <h3>4 - Integration</h3> <ul> <li>Standard and premium connectors</li> <li>Connecting to web services</li> <li>Using Power Automate with on-premises data</li> <li>Lab 1: Using Power Automate and SQL to Review Sales</li> <li>Create a new orders list</li> <li>Designing the price check process</li> <li>Testing the price check process</li> <li>Optional: Update with managers</li> <li>After completing this module, students will be able to:</li> <li>How to use Standard and Premium connectors</li> <li>How to connect to web services</li> <li>How to using Power Automate with on-premises data</li> </ul> <h3>5 - The Mobile App</h3> <ul> <li>Downloading the mobile app</li> <li>Signing in and account management</li> <li>Building and managing Power Automates</li> <li>Creating buttons</li> <li>Feeds and approvals</li> <li>Lab 1: Optional: Using the Power Automate mobile app</li> <li>Setting up the Power Automate mobile app</li> <li>Create a new Power Automate in the mobile app</li> <li>Using Power Automate buttons in the app</li> <li>Uninstall the Power Automate mobile app</li> <li>After completing this module, students will be able to:</li> <li>How to download the mobile app</li> <li>How to sign into the mobile app</li> <li>How to build and manage Power Automates in the mobile app</li> <li>How to create buttons in the mobile app</li> <li>How to feed and use approvals in the mobile app</li> </ul> <h3>6 - Administration and Maintenance</h3> <ul> <li>Maintaining a Power Automate</li> <li>View history and analytics</li> <li>Sharing a Power Automate</li> <li>Export and import Power Automates</li> <li>Office 365 administration for Power Automate</li> <li>Environments</li> <li>Data policies</li> <li>Data integration</li> <li>Lab 1: Maintaining your Power Automates</li> <li>Share a Power Automate with a colleague</li> <li>Disabling an active Power Automate</li> <li>Deleting a Power Automate</li> <li>After completing this module, students will be able to:</li> <li>How to maintain a Power Automate</li> <li>How to view history and analytics for a Power Automate</li> <li>How to share a Power Automate</li> <li>How to export and import Power Automates</li> <li>How to administrate a Power Automate in Office 365</li> <li>How to use data policies in a Power Automate</li> <li>How to use data integration in a Power Automate</li> </ul></div>

55268 Microsoft Power Automate for End Users

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Managers and leaders use power every day, many feel reluctant to use it or even to admit that it is part of their job. However, using power effectively is an important skill and by developing influencing techniques can lead to increased effectiveness in a team. This course describes the sources of power and strategies and assesses your abilities in line with these. Power should contribute to organisational goals, respect human rights and conform to standards of equality and justice.&nbsp;</strong></p>

Managers and leaders use power every day, many feel reluctant to use it or even to admit that it is part of their job. However, using power effectively is an important skill and by developing influencing techniques can lead to increased effectiveness in a team. This course describes the sources of power and strategies and assesses your abilities in line with these. Power should contribute to organisational goals, respect human rights and conform to standards of equality and justice. 

Skillogy International

Soft Skills

Influencing Skills

Managers and leaders use power every day, many feel reluctant to use it or even to admit that it is part of their job. However, using power effectively is an important skill and by developing influencing techniques can lead to increased effectiveness in a team. This course describes the sources of power and strategies and assesses your abilities in line with these. Power should contribute to organisational goals, respect human rights and conform to standards of equality and justice. 

Power and Influence

Course

Complete 5 courses to gain a Certificate from the Chartered Management Institute

11 Courses in London

Microsoft Power BI Desktop (now with live online classes)

By Microsoft Office Training

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

By Microsoft Office Training

Power BI® - Business Data Analytics

By EnergyEdge - Training for a Sustainable Energy Future

Negotiation Skills in a Day

By Maximum Performance

Negotiation Skills in a Day: In-House

By Maximum Performance

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

By The In House Training Company

Photography For Parents - Editing In Lightroom

By Photography For Parents

General Anxiety and Phobia Specialist Coaching

By Creature Courage

Coaching Skills for Line Managers

By Maximum Performance

Powerful presentation skills (In-House)

By The In House Training Company

Educators matching "using power"

power plate

London

Search By Location