Name: Online NLP Practitioner Certification Training (starting 7 Dec '23)
Price: 1250 GBP
Availability: InStock

<p><strong>Level 4 Diploma in Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</strong></p><p>Turn your skills into a competitive advantage recognised globally and endorsed for quality by QLS, the UK's most reputable high-quality course auditor.</p><p>Master Microsoft Excel to increase your work opportunities and earning possibilities. Utilise MS Excel's limitless capability by automating everyday chores and producing dynamic reports. Learn the ins and outs of MS Excel, such as data analysis and mapping, editing and formatting spreadsheets, doing computations, and much more. Enrol now to learn MS Excel from the ground up!</p><p>This premium QLS-endorsed Advanced Excel Course (Formula, VLOOKUP &amp; Power Query) course has intensive study modules, dedicated tutor assistance, customer support, flexible learning opportunities and a globally recognised certification. Thus, completing our Advanced Excel Course (Formula, VLOOKUP &amp; Power Query) course will give you limitless possibilities anywhere and everywhere since the value of QLS-endorsed courses is pretty high!!</p><p>What's more, the quality of our first-class course is uncompromising for both you and us. You will be taught the richest materials from this exquisite Advanced Excel Course (Formula, VLOOKUP &amp; Power Query) course, enabling you to open up a vast world of opportunities to grasp and gain success. For the price point, this course is an absolute steal! It's an investment you do not want to miss out on!</p><p>So, why delay any longer? Benefit your career progression by joining us today and distinguish yourself as unquestionably the most skilled in your workplace!</p><p><strong>Learning Outcome of Level 4 Diploma in Advanced Excel Course:</strong></p><ul><li>Master the top 50 Microsoft Excel formulas and their applications.</li><li>Develop a deep understanding of the VLOOKUP function and its various uses.</li><li>Gain expertise in using Power Query to manipulate and analyse data in Excel.</li><li>Acquire knowledge of essential keyboard shortcuts to enhance productivity and efficiency in Excel.</li><li>Apply advanced Excel techniques to solve complex data analysis problems.</li><li>Develop the skills to perform data transformations efficiently and cleanly using Power Query.</li></ul><p><strong>Why Learn with us: </strong></p><p>As one of the leading e-learning service providers globally, we strive to provide all our learners with the best e-learning experience possible that can make a real difference in their career progression.</p><p><strong>Our Service for the </strong><strong>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</strong><strong> Includes:</strong></p><ul><li>Intensive Study Notes</li><li>Tutor Support</li><li>Customer Support</li><li>Assignment Help</li><li>QLS Endorsed Certificate</li><li>24/7 Learning Portal Access</li><li>Widely Compatible Study Materials</li></ul><p><strong>Course Curriculum of </strong><strong>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query)</strong></p><ul><li><strong>Module 01:</strong> Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!</li><li><strong>Module 02:</strong> VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes!</li><li><strong>Module 03:</strong> Microsoft Excel: Master Power Query in 120 Minutes!</li><li><strong>Module 04:</strong> Microsoft Excel Keyboard Shortcuts</li></ul><p><strong>Assessment &amp; Certification</strong></p><p>Learners must submit a comprehensive summarised assignment on all the units that our expert tutor will assess if all the learning outcomes are met as per the standard set by QLS. After the quality check, the learner will receive the Advanced Excel Course (Formula, VLOOKUP &amp; Power Query) certificate.</p><p><strong>Endorsed Certificate of Achievement from the Quality Licence Scheme</strong></p><p>An endorsed certificate will be issued to learners at the course's end to recognise course completion. Provided that the learner completes all course assessments can claim a certificate.</p><p><strong>Endorsement:</strong></p><p>QLS endorsed this certified course as a highly qualified, non-regulated provision and training programme. There will be a trainer to answer all your questions, including your progression routes into further higher education.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Our course is open to everyone. This Advanced Excel Course (Formula, VLOOKUP &amp; Power Query) is ideal for those who aspire to gain in-depth knowledge &amp; efficient skills to embark into the relevant sector with promising potential.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No formal requirements are needed for this Advanced Excel Course (Formula, VLOOKUP &amp; Power Query) course. So, learners do not require prior qualifications to enrol in this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p><strong>Advanced Excel Course (Formula, VLOOKUP &amp; Power Query) will assist you perform in careers like:</strong></p><ol><li>Data Analyst - Average Salary: £35,000 per year</li><li>Financial Analyst - Average Salary: £40,000 per year</li><li>Business Intelligence Analyst - Average Salary: £45,000 per year</li><li>Reporting Analyst - Average Salary: £35,000 per year</li><li>Operations Manager - Average Salary: £50,000 per year</li></ol>
                        </div>

Kingston Open College

NVQ Assessor

Managed Learning Programme (MLP)

Certificate in Further Education & Training (Cert Ed)

European Computer Driving Licence (ECDL)

FA Level 1

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Level 4 Diploma in Advanced Excel Course (Formula, VLOOKUP & Power Query) - QLS Endorsed

General Admission

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who are experienced in general Windows Server and Windows Client administration. Students should have a foundational knowledge of Windows PowerShell, which they can obtain by taking course 10961C: Automating Administration with Windows PowerShell. In addition, this course provides scripting guidance for Microsoft Azure administrators and developers who support development environments and deployment processes.</p>Overview<p>After completing this course, you will be able to:<br />Create advanced functions.<br />Use Microsoft .NET Framework and REST API in Windows PowerShell.<br />Handle script errors.<br />Use XML, JSON, and custom formatted data.<br />Manage Microsoft Azure resources<br />Analyze and debug scripts<br />Understand Windows PowerShell workflow.</p><p>This course teaches students how to automate administrative tasks using PowerShell. Students will learn crucial scripting skills such as creating advanced functions, writing controller scripts, and handling script errors. Candidates will learn how to use PowerShell when working with Microsoft Azure, SQL Server, Active Directory, IIS, Windows PowerShell Workflow, .NET resources, the REST API and XML, CSV &amp; JSON formatted data files.This course replaces retired Microsoft course 10962.</p></div><div id="course-pills-2"><h4>Module 1: Creating advanced functions</h4><ul><li>Lesson 1: Converting a command into an advanced function</li><li>Lesson 2: Creating a script module</li><li>Lesson 3: Defining parameter attributes and input validation</li><li>Lesson 4: Writing functions that accept pipeline input</li><li>Lesson 5: Producing complex pipeline output</li><li>Lesson 6: Using comment-based Help</li><li>Lesson 7: Using Whatif and Confirm parameters</li></ul><h4>Module 2: Using Microsoft .NET Framework and REST API in Windows PowerShell</h4><ul><li>Lesson 1: Using .NET Framework in PowerShell</li><li>Lesson 2: Using REST API in PowerShell</li></ul><h4>Module 3: Writing controller scripts</h4><ul><li>Lesson 1: Understanding controller scripts</li><li>Lesson 2: Writing controller scripts with a user interface</li><li>Lesson 3: Writing controller scripts that create reports</li></ul><h4>Module 4: Handling script errors</h4><ul><li>Lesson 1: Understanding error handling</li><li>Lesson 2: Handling errors in a script</li></ul><h4>Module 5: Using XML, JSON, and custom-formatted data</h4><ul><li>Lesson 1: Working with XML formatted data</li><li>Lesson 2: Working with JSON formatted data</li><li>Lesson 3: Working with custom-formatted data</li></ul><h4>Module 6: Enhancing server management with Desired State Configuration and Just Enough Administration</h4><ul><li>Lesson 1: Implementing Desired State Configuration</li><li>Lesson 2: Implementing Just Enough Administration</li></ul><h4>Module 7: Analyzing and debugging scripts</h4><ul><li>Lesson 1: Debugging in Windows PowerShell</li><li>Lesson 2: Analyzing and debugging an existing script</li></ul><h4>Module 8: Understanding Windows PowerShell Workflow</h4><ul><li>Lesson 1: Understanding Windows PowerShell Workflows</li><li>Lesson 2: Running Windows PowerShell Workflows</li></ul></div>

Nexus Human

Microsoft Certification

Azure PowerShell

Microsoft AZ-900

Microsoft AZ-104

Microsoft AZ-303

Microsoft AZ-700

55318: Advanced Automated Administration with Windows PowerShell

<section data-id="2f89108" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="8492d0b" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-id="b9a3017" data-element_type="section" fr-original-style="" style="box-sizing: border-box;"><div data-id="7611372" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="84fa810" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><section data-id="2f89108" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="8492d0b" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-id="b9a3017" data-element_type="section" fr-original-style="" style="box-sizing: border-box;"><div data-id="7611372" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="84fa810" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">OVERVIEW</h3></div><div data-id="f4d9ac0" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service.</p></div><div data-id="3268c88" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE BENEFITS:</h3></div><div data-id="7a033b7" data-element_type="widget" data-widget_type="icon-list.default" 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;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Learn how to clean, transform, and load data from many sources</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Use database queries in Power Query to combine tables using append and merge</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Create and manage a data model in Power BI consisting of multiple tables connected with relationships</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Build Measures and other calculations in the DAX language to plot in reports</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Manage advanced time calculations using date tables</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Optimise report calculations using the Performance Analyzer</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Manage and share report assets to the Power BI Service</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware</span></li></ul></div><div data-id="402ee41" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">WHO IS THE COURSE FOR?</h3></div><div data-id="1e62ca4" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence</li><li fr-original-style="" style="box-sizing: border-box;">Management Consultants who need to conduct rapid analysis of their clients&rsquo; data to answer specific business questions</li><li fr-original-style="" style="box-sizing: border-box;">Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system</li><li fr-original-style="" style="box-sizing: border-box;">Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps</li><li fr-original-style="" style="box-sizing: border-box;">Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use</li></ul></div></div></section></div></section><section data-id="a8e6ba7" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="a4bbb0a" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-id="4ed22ae" data-element_type="section" fr-original-style="" style="box-sizing: border-box;"><div data-id="16c8bf1" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="326f24d" data-element_type="widget" data-widget_type="menu-anchor.default" fr-original-style="" style="box-sizing: border-box;"></div><div data-id="9bc97d7" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE OUTLINE</h3></div><div data-id="ce8a9cc" data-element_type="widget" data-widget_type="toggle.default" fr-original-style="" style="box-sizing: border-box;"><div data-tab="1" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 1 Getting Started With Microsoft Data Analytics</div><div data-tab="1" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Data analytics and Microsoft</li><li fr-original-style="" style="box-sizing: border-box;">Getting Started with Power BI</li></ul></div><div data-tab="2" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 2 Get Data In Power BI</div><div data-tab="2" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Get data from various data sources</li><li fr-original-style="" style="box-sizing: border-box;">Optimize performance</li><li fr-original-style="" style="box-sizing: border-box;">Resolve data errors</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab: Prepare Data in Power BI Desktop</p></div><div data-tab="3" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 3 Clean, Transform And Load Data In Power BI</div><div data-tab="3" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Data shaping</li><li fr-original-style="" style="box-sizing: border-box;">Data profiling</li><li fr-original-style="" style="box-sizing: border-box;">Enhance the data structure</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab: Load Data in Power BI Desktop</p></div><div data-tab="4" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 4 Design A Data Model In Power BI</div><div data-tab="4" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to data modelling</li><li fr-original-style="" style="box-sizing: border-box;">Working with Tables</li><li fr-original-style="" style="box-sizing: border-box;">Dimensions and Hierarchies</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab: Model Data in Power BI Desktop</p></div><div data-tab="5" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 5 Create Model Calculations Using DAX In Power BI</div><div data-tab="5" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to DAX</li><li fr-original-style="" style="box-sizing: border-box;">Real-time Dashboards</li><li fr-original-style="" style="box-sizing: border-box;">Advanced DAX</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab 1: Create DAX Calculations in Power BI Desktop, Part 1</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab 2: Create DAX Calculations in Power BI Desktop, Part 2</p></div><div data-tab="6" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 6 Optimize Model Performance</div><div data-tab="6" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Optimize the data model for performance</li><li fr-original-style="" style="box-sizing: border-box;">Optimize DirectQuery models</li></ul></div><div data-tab="7" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 7 Create Reports</div><div data-tab="7" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Design a Report</li><li fr-original-style="" style="box-sizing: border-box;">Enhance the Report</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab 1: Design a Report in Power BI Desktop, Part 1</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab 2: Design a Report in Power BI Desktop, Part 2</p></div><div data-tab="8" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 8 Create Dashboards</div><div data-tab="8" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Create a Dashboard</li><li fr-original-style="" style="box-sizing: border-box;">Real-time Dashboards</li><li fr-original-style="" style="box-sizing: border-box;">Enhance a Dashboard</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab: Create a Power BI Dashboard</p></div><div data-tab="9" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 9 Perform Advanced Analytics</div><div data-tab="9" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Advanced analytics</li><li fr-original-style="" style="box-sizing: border-box;">Data Insights through AI Visuals</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab: Perform Data Analysis in Power BI Desktop</p></div><div data-tab="10" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 10 Create And Manage Workspaces</div><div data-tab="10" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creating Workspaces</li><li fr-original-style="" style="box-sizing: border-box;">Sharing and managing assets</li></ul></div><div data-tab="11" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 11 Manage Datasets In Power BI</div><div data-tab="11" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Parameters</li><li fr-original-style="" style="box-sizing: border-box;">Datasets</li></ul></div><div data-tab="12" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 12 Row-Level Security</div><div data-tab="12" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Security in Power BI</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Lab: Enforce Row-Level Security</p></div></div></div></section></div></section></div></div></section></div></section>

Online Productivity Training

Power BI Data Analyst (PL300)

<p>Mechanical engineering skills are essential across a wide range of industries including automotive, aerospace, energy, manufacturing, and construction. As these sectors continue to evolve and innovate, the need for skilled mechanical engineers remains high.</p><p>The UK's commitment to innovation and technology adoption ensures a sustained demand for mechanical engineering as well.</p><p>According to <strong>Reed </strong>the average salary of a Mechanical Engineer is around <strong>£42,000 to £48,000 </strong><strong>per annum</strong>. Although. the salary of a Mechanical Engineer can vary depending on location, experience and many more</p><p>From understanding electrical systems to harnessing the power of tools, our curriculum leaves no nut unturned, equipping you with the knowledge to conquer any challenge that rolls your way.</p><p>So, if you're ready to ignite your passion for mechanics and engineering, join us in shaping the future of innovation, one cog at a time</p><p><strong>Key Features:</strong></p><ul><li>CPD Accredited</li><li>Instant 2 PDF certificate</li><li>Fully online, interactive Course with audio voiceover</li><li>Self-paced learning and laptop, tablet, smartphone-friendly</li><li>24/7 Learning Assistance</li><li>Discounts on bulk purchases</li></ul><p><strong>Course bundle:</strong></p><ul><li><strong>Course 01: </strong>Mechanical Engineering</li><li><strong>Course 02:</strong> HGV Training</li><li><strong>Course 03:</strong> Car Mechanic</li><li><strong>Course 04:</strong> Motorbike Mechanic Course</li><li><strong>Course 05:</strong> PUWER</li><li><strong>Course 06:</strong> RIDDOR Training</li><li><strong>Course 07:</strong> Car Restoration</li><li><strong>Course 08:</strong> MET Technician</li><li><strong>Course 09:</strong> PAT</li><li><strong>Course 10:</strong> Power Tools and How to Use Them</li><li><strong>Course 11:</strong> MATLAB Simulink for Electrical Power Engineering</li><li><strong>Course 12:</strong> Car Mechanic &amp; Car Maintenance Level 3 Diploma</li><li><strong>Course 13:</strong> Advanced Electrical Safety</li><li><strong>Course 14:</strong> Electrical Machines for Electrical Engineering</li><li><strong>Course 15:</strong> Electrical and Fire Safety Training</li><li><strong>Course 16:</strong> Electrical Units &amp; Components</li><li><strong>Course 17:</strong> Light Current Systems for Electrical Engineering</li><li><strong>Course 18:</strong> Preventing Electric Shock Online Training</li><li><strong>Course 19:</strong> Electrical Maintenance</li><li><strong>Course 20:</strong> Power Electronics for Electrical Engineering</li><li><strong>Course 21:</strong> High Voltage Generation for Electrical Engineering</li><li><strong>Course 22:</strong> Electric Circuits for Electrical Engineering</li><li><strong>Course 23:</strong> Electric Power Metering for Single and Three Phase Systems</li><li><strong>Course 24: </strong>Diploma in Sustainable Energy</li><li><strong>Course 25:</strong> Large Goods Vehicle (LGV)</li><li><strong>Course 26: </strong>Solar &amp; Thermal Energy Systems</li><li><strong>Course 27: </strong>Rotating Machines</li><li><strong>Course 28:</strong> Data Analytics</li><li><strong>Course 29: </strong>Ladder Safety</li></ul><p><strong>Learning Outcomes:</strong></p><ul><li>Understand fundamentals of mechanical engineering principles and applications.</li><li>Gain expertise in vehicle maintenance and repair techniques for automobiles.</li><li>Acquire knowledge of electrical safety regulations and procedures in engineering.</li><li>Develop proficiency in using power tools for mechanical and electrical tasks.</li><li>Apply MATLAB Simulink for analysis and design in electrical power engineering.</li><li>Comprehend principles of sustainable energy and its applications in engineering.</li></ul><p><strong>Accreditation</strong></p><p>All of our courses are fully accredited, including this Mechanical Engineering Basics Course, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in Mechanical Engineering.</p><p><strong>Certification</strong></p><p>Once you've successfully completed your Mechanical Engineering Basics Course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our Mechanical Engineering Basics Course certification has no expiry dates, although we do recommend that you renew them every 12 months.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        300 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <ul><li>Individuals interested in mechanical and electrical engineering basics.</li><li>Students seeking foundational knowledge in vehicle maintenance and repair.</li><li>Engineers aiming to enhance their understanding of electrical safety regulations.</li><li>Enthusiasts willing to learn the usage of power tools in engineering.</li><li>Professionals seeking to expand their skills in sustainable energy applications.</li></ul>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>Electrical Engineer - £30K to 45K/year.</li><li>Automotive Technician - £20K to 35K/year.</li><li>Data Analyst - £25K to 50K/year.</li><li>Solar Energy Engineer - £25K to 40K/year.</li><li>Maintenance Technician - £22K to 35K/year.</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p>Once you've successfully completed your course, you will immediately be sent a FREE digital certificate.</p></div>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK).<br />For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.<br />Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.</p></div>

                        </div>

Training Express

Mechanical Engineering Basics Course

<section data-id="2f89108" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="8492d0b" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-id="b9a3017" data-element_type="section" fr-original-style="" style="box-sizing: border-box;"><div data-id="7611372" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="84fa810" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">OVERVIEW</h3></div><div data-id="f4d9ac0" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Prerequisites&mdash;DIAD training or equivalent working experience</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This one-day course will cover using Power&nbsp;BI Desktop to import and shape data from a variety of sources. It will also walk through Power&nbsp;BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power&nbsp;BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power&nbsp;BI model.</p></div><div data-id="3268c88" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE BENEFITS:</h3></div><div data-id="7a033b7" data-element_type="widget" data-widget_type="icon-list.default" 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;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the Power BI Desktop data model, its components and most effective schemas</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Describe concepts of calculated columns and measures</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Create queries using M</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Create calculations with DAX</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the use of functions</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Create and optimize a data model</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the consequences of data model design decisions</span></li></ul></div><div data-id="402ee41" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">WHO IS THE COURSE FOR?</h3></div><div data-id="1e62ca4" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Power BI report developers who wish to improve the structure of their data models</li><li fr-original-style="" style="box-sizing: border-box;">Power BI report developers who wish to use advanced features like parameters and M coding in Power Query</li><li fr-original-style="" style="box-sizing: border-box;">Power BI practitioners who wish to optimise their models more effectively</li><li fr-original-style="" style="box-sizing: border-box;">Attendees wishing to prepare thoroughly for the DAX In A Day course</li></ul></div></div></section></div></section><section data-id="a8e6ba7" data-element_type="section" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-id="a4bbb0a" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-id="4ed22ae" data-element_type="section" fr-original-style="" style="box-sizing: border-box;"><div data-id="16c8bf1" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="326f24d" data-element_type="widget" data-widget_type="menu-anchor.default" fr-original-style="" style="box-sizing: border-box;"></div><div data-id="9bc97d7" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE OUTLINE</h3></div><div data-id="ce8a9cc" data-element_type="widget" data-widget_type="toggle.default" fr-original-style="" style="box-sizing: border-box;"><div data-tab="1" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 1 Getting And Shaping The Data</div><div data-tab="1" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand what is meant by&nbsp;<i fr-original-style="" style="box-sizing: border-box;">data model</i>&nbsp;in the context of Power BI</li><li fr-original-style="" style="box-sizing: border-box;">Understand the consequences of data model design decisions</li><li fr-original-style="" style="box-sizing: border-box;">Understand consequences of Power BI&rsquo;s data type handling</li><li fr-original-style="" style="box-sizing: border-box;">Understand data connection options</li></ul></div><div data-tab="2" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 2 Basic Data Modelling</div><div data-tab="2" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand basic data modelling</li><li fr-original-style="" style="box-sizing: border-box;">Understand basic data model types</li><li fr-original-style="" style="box-sizing: border-box;">Explore dimension tables and fact tables</li><li fr-original-style="" style="box-sizing: border-box;">Explore data connections</li></ul></div><div data-tab="3" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 3 Getting Started With M (Power Query Language)</div><div data-tab="3" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Get introduced to M</li><li fr-original-style="" style="box-sizing: border-box;">Understand key components and syntax</li></ul></div><div data-tab="4" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 4 Understanding Logic Operators</div><div data-tab="4" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand Transformations</li><li fr-original-style="" style="box-sizing: border-box;">Understand Join operation</li></ul></div><div data-tab="5" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 5 Introduction To DAX</div><div data-tab="5" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Get introduced to DAX and how can it be used</li><li fr-original-style="" style="box-sizing: border-box;">Understand working with parameters and DAX (lab combining the previous module)</li></ul></div><div data-tab="6" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 6 Working With Functions - DAX CALCULATE And More</div><div data-tab="6" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand working with functions</li><li fr-original-style="" style="box-sizing: border-box;">Understand the basics of the CALCULATE formula</li></ul></div><div data-tab="7" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 7 Modelling With Power BI &amp; DAX Best Practice</div><div data-tab="7" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Gain familiarity with basic data modelling for business scenarios</li><li fr-original-style="" style="box-sizing: border-box;">Learn some best practices for working with Power BI</li></ul></div></div></div></section></div></section>

Advanced Data Modelling and Shaping (MSIAD)

<strong>A comprehensive and detailed course containing premium beginner, intermediate, and advanced level content. Start with the fundamentals and build a strong foundation before gradually studying Excel 2021's advanced features, formulae, and functions that will help you become a master.</strong>
        <p>Microsoft has released its latest stand-alone Excel version, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.

In the first section, we study some basics about how to use Excel 2021 and become familiar with what's new in it. We will first navigate the Excel 2021 interface and create our first Excel spreadsheet. You will learn some useful keyboard shortcuts to increase productivity, learn how to effectively apply formatting to cells and use conditional formatting, learn how to use basic and intermediate Excel formulas and functions, and more.

Then, in the second section, you will learn how to create intermediate-level formulas, prepare data for analysis using PivotTables and Pivot Charts, make use of WhatIf analysis tools, learn how to use validation rules to control data input, and explore the fundamentals of spreadsheet design.

In the final section, we will build on the skills learned in the beginner and intermediate sections and fast-track our way to being an Excel power user. This section covers the latest updates from Microsoft, including the LET and LAMBDA functions, which allow us to create our own variables and even Excel functions.

By the end of this course, you will be able to use Excel skills confidently.

All the course demo files, and exercise files are available at: https://github.com/PacktPublishing/Microsoft-Excel-2021-365---Beginner-to-Advanced</p>
        <h2>What You Will Learn</h2><p>Become familiar with what's new in Excel 2021<br>Use Excel lists and master sorting and filtering<br>Represent data visually with Pivot Charts<br>Use WhatIf analysis tools to see how changing inputs affect outcomes<br>Analyze data with advanced PivotTable and PivotChart hacks<br>Import and clean data using Power Query</p>
        <h2>Audience</h2><p>If you are an absolute beginner who has never used Excel before, this course can give you a great foundation. You might have some basic Excel skills and want to improve your proficiency, or you are using an older version of Excel and want to check out what's new. Well, this course can help you get the ball rolling.</p>
        <h2>Approach</h2><p>This is a complete hands-on course where we will start with the basics and move toward an advanced level. You will also get course demo files and exercise files to download so you can follow along with the lessons and practice what you have learned in each section.</p>
        <h2>Key Features</h2><p>Utilize useful keyboard shortcuts to increase productivity * Learn how to use logical functions to make better business decisions * Learn how to combine functions together to create practical formulas to complete specific tasks</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Microsoft-Excel-2021-365---Beginner-to-Advanced</p>
        <h2>About the Author</h2><h3>Simon Sez IT</h3><p>Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.

Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.</p>
        <h2>Course Outline</h2><h4>1. Excel 2021 for Beginner Level</h4><p></p><br><h4>2. Excel 2021 for Intermediate level</h4><p></p><br><h4>3. Excel 2021 for Advanced Level</h4><p></p>

Packt

Power Query

A comprehensive and detailed course containing premium beginner, intermediate, and advanced level content. Start with the fundamentals and build a strong foundation before gradually studying Excel 2021's advanced features, formulae, and functions that will help you become a master.

Microsoft Excel 2021/365 - Beginner to Advanced

<strong>This compact crash course teaches learners to optimize their Microsoft Power BI use, gain insights into circular dependency errors and the new DAX functions, and use Power BI template files to enhance data modeling/analysis. The course provides guidance and real-world examples to streamline Power BI projects and achieve data visualization goals effectively.</strong>
        <p>Power BI is a powerful data visualization and analytics tool that enables users to create interactive dashboards and reports. To make the most out of your Power BI projects, ChatGPT can provide expert advice and guidance on how to effectively use Power BI, offering insights and recommendations for optimizing your Power BI projects. ChatGPT can assist in creating visually appealing visualizations, optimizing data models, and exploring advanced analytics capabilities.

This course begins with a description and introduction of ChatGPT with Power BI Desktop, its advantages and features, and the use cases in detail. You will learn about dealing with changing Excel sheet names, handling file location changes, creating and using template files, and understanding the different file structure issues. We will then explore circular dependency errors and how to fix them using Power BI. We will advance to understand multiple folder data extraction and finally explore and clearly understand the new DAX functions (Offset, Index, and Window).

Upon completing the course, you will learn to solve various problems using Excel files and Power BI Data sources and best practices; solve circular dependencies in Power BI, the M Language, and DAX functions; and use Power BI template files to enhance data modeling/analysis.

All resources are available at: https://github.com/PacktPublishing/Power-BI-Best-Project-Tips-and-Tricks-Including-Time-Saving-Tips-Using-Chat-GPT</p>
        <h2>What You Will Learn</h2><p>Learn to deal with file location changes in Power BI<br>Handle Power BI by combining Excel files with different structures<br>Efficiently extract data from multiple folders in Power BI<br>Deep dive and explore the new DAX functionality<br>Learn to handle Excel sheet renaming issues in bulk<br>Understand circular dependency errors and how to fix them</p>
        <h2>Audience</h2><p>This course is aimed at individuals wanting to become better Power BI developers or solve data issues with Excel files in Power BI. Data analysts, those wishing to follow this career path, and business users who work with Power BI and need to create DAX calculations will immensely benefit from this course. The prerequisites include having basic Power BI knowledge and attending the author's Power BI Masterclass for beginners to advanced first as an advantage. This course focuses strongly on Excel data sources and solving data issues and does not cover visualizations in Power BI Desktop.</p>
        <h2>Approach</h2><p>The course is designed to deliver classroom-style on-screen presentations and demonstrations of the various concepts to be covered during the course. This course focuses strongly on Excel data sources and solving data issues with explanations and presentations with Power BI Desktop live to understand better.</p>
        <h2>Key Features</h2><p>The course provides an in-depth conceptualization of the Power BI best tips and tricks for projects * Clearly understand circular dependency errors in relationships between tables and how to fix them * Gain mastery over Power BI multiple Excel files with different file structures and modifications</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Power-BI-Best-Project-Tips-and-Tricks-Including-Time-Saving-Tips-Using-Chat-GPT</p>
        <h2>About the Author</h2><h3>Daniel Weikert</h3><p>Daniel Weikert is a 33-year-old entrepreneur, data enthusiast, consultant, and trainer. He is a master's degree holder certified in Power BI, Tableau, Alteryx (Core and Advanced), and KNIME (L1-L3).

He is currently working in the business intelligence field and helps companies and individuals obtain vital insights from their data to deliver long-term strategic growth and outpace their competitors.

He possesses a fervent dedication to both learning and teaching. His unwavering commitment extends to providing educational services and assisting individuals in achieving their objectives, mastering their fields, and embarking on new career journeys.</p>
        <h2>Course Outline</h2><h4>1. Einf</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Power BI Best Project Tips and Tricks Introduction</p><p style='margin: 0'>This video introduces the course and offers valuable tips and tricks for data modeling in Power BI. The video sets the stage for the rest of the course, providing an overview of the topics covered and the benefits learners can expect.</p></td></tr><tr><td style='padding: 15px;'><p>2. No Issues with Changing Sheet Excel Names Anymore</p><p style='margin: 0'>This lesson offers a solution to a common problem faced by Power BI users, the need to change Excel sheet names. Following the steps outlined in the video, users can easily update sheet names without causing issues in their Power BI reports.</p></td></tr><tr><td style='padding: 15px;'><p>3. How to Handle Excel Sheet Renaming Issues in Bulk</p><p style='margin: 0'>In this video, we will discover how to manage Excel sheet renaming issues while simultaneously working with multiple files. The video provides a step-by-step guide to bulk renaming Excel sheets and demonstrates how Power BI can do this efficiently.</p></td></tr><tr><td style='padding: 15px;'><p>4. Dealing with File Location Changes in Power BI</p><p style='margin: 0'>This lecture addresses another common issue Power BI users face: file location changes. The video explains how to manage file location changes in Power BI and maintain data connections to ensure that reports continue functioning as intended.</p></td></tr><tr><td style='padding: 15px;'><p>5. Best Practice Tip Use Power BI Template Files</p><p style='margin: 0'>In this lesson, we will explore the benefits of using Power BI template files to streamline their projects. The video explains how to create and use template files effectively and provides examples of how templates can be customized to suit different needs.</p></td></tr><tr><td style='padding: 15px;'><p>6. Power BI Trouble with Combining Excel Files with a Different Structure</p><p style='margin: 0'>This video addresses a common challenge faced by Power BI users, combining Excel files with different structures. The video provides solutions for handling this issue and offers tips on structuring data effectively to avoid problems when combining files.</p></td></tr><tr><td style='padding: 15px;'><p>7. Power BI Multiple Excel Files with Different File Structures and Modification</p><p style='margin: 0'>This lecture expands on the previous video by exploring the challenges of working with multiple Excel files with different file structures and modifications. We will gain insights into managing these issues effectively in Power BI.</p></td></tr><tr><td style='padding: 15px;'><p>8. Circular Dependency Errors and How to Fix Them</p><p style='margin: 0'>This video addresses circular dependency errors in Power BI, occurring with interdependent table relationships. The video provides a step-by-step guide to identifying and resolving circular dependency errors to maintain the integrity of Power BI reports.</p></td></tr><tr><td style='padding: 15px;'><p>9. Circular Dependency Errors, Another Way to Fix It</p><p style='margin: 0'>In this video, we will discover an alternative method for resolving circular dependency errors in Power BI. The video demonstrates calculating columns to break the dependency cycle and maintain data integrity.</p></td></tr><tr><td style='padding: 15px;'><p>10. Circular Dependency Errors in Relationships Between Tables and How to Fix Them</p><p style='margin: 0'>This video delves deeper into circular dependency errors in Power BI and guides on identifying and fixing errors in the context of table relationships. We will gain valuable insights into best practices for structuring tables and relationships to avoid such errors.</p></td></tr><tr><td style='padding: 15px;'><p>11. Efficiently Extract Data from Multiple Folders in Power BI</p><p style='margin: 0'>This lesson explores the challenge of extracting data from multiple folders in Power BI and provides solutions for doing so efficiently. The video offers a step-by-step guide to identifying and connecting to data from multiple folders, helping to streamline Power BI projects.</p></td></tr><tr><td style='padding: 15px;'><p>12. Deep Dive into the New DAX Functions</p><p style='margin: 0'>This video will take a deep dive into the new DAX functions in Power BI. The video provides a comprehensive overview of the latest DAX functions and demonstrates how these can be used to enhance data modeling and analysis in Power BI.</p></td></tr></tbody></table><br><h4>2. Bonus</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. ChatGPT for Power BI Desktop</p><p style='margin: 0'>ChatGPT chatbot technology with Power BI Desktop integration allows users to interact with data and reports through NLP queries. The video provides step-by-step guidance on setting up the integration and use of ChatGPT to enhance functionality.</p></td></tr></tbody></table>

Web Development

This compact crash course teaches learners to optimize their Microsoft Power BI use, gain insights into circular dependency errors and the new DAX functions, and use Power BI template files to enhance data modeling/analysis. The course provides guidance and real-world examples to streamline Power BI projects and achieve data visualization goals effectively.

Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts)

<div data-id="84fa810" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">OVERVIEW</h3></div><div data-id="f4d9ac0" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Prerequisites&mdash;DIAD training or equivalent working experience</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This one-day course will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports, as well as best practices for authoring great reports and dashboards for business users.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course.</p></div><div data-id="3268c88" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE BENEFITS:</h3></div><div data-id="7a033b7" data-element_type="widget" data-widget_type="icon-list.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the need for storytelling with data</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the agile process to creating Power BI data visualizations</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand the art behind visualizations</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Gain familiarity with Power BI report layouts and structure</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Understand implications behind choosing the right charts</span></li><li fr-original-style="" style="box-sizing: border-box;"><i style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"></i><span style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);">Gain familiarity with using Power BI custom visuals</span></li></ul></div><div data-id="402ee41" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">WHO IS THE COURSE FOR?</h3></div><div data-id="1e62ca4" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Power BI report developers who wish to improve the aesthetic quality of their reports</li><li fr-original-style="" style="box-sizing: border-box;">Power BI and other BI practitioners who would like to understand more about the theory of data visualization</li><li fr-original-style="" style="box-sizing: border-box;">BI practitioners who wish to create reports that communicate the meaning behind the data more clearly</li><li fr-original-style="" style="box-sizing: border-box;">Power BI users who would like to explore the types of chart and visual available that answer different types of business question</li></ul><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-id="9bc97d7" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(51, 51, 51);"><h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">COURSE OUTLINE</h3></div><div data-id="ce8a9cc" data-element_type="widget" data-widget_type="toggle.default" style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><div data-tab="1" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 1 What Is Storytelling With Data?</div><div data-tab="1" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Volume, Velocity and Variety</li><li fr-original-style="" style="box-sizing: border-box;">The importance of business questions</li><li fr-original-style="" style="box-sizing: border-box;">What is a story in this context?</li></ul></div><div data-tab="2" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 2 The Science Behind Data Visualization</div><div data-tab="2" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Basic problems to avoid</li><li fr-original-style="" style="box-sizing: border-box;">Memory and visualization</li><li fr-original-style="" style="box-sizing: border-box;">Ways to spark iconic, short-term and long-term memory</li></ul></div><div data-tab="3" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 3 The Process Behind Data Visualization</div><div data-tab="3" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Using an agile approach to report development</li><li fr-original-style="" style="box-sizing: border-box;">Data structure and data grain</li><li fr-original-style="" style="box-sizing: border-box;">Converting the story to a data model</li></ul></div><div data-tab="4" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 4 Dashboards And Reports</div><div data-tab="4" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Terminology and definitions</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard layout and structure</li><li fr-original-style="" style="box-sizing: border-box;">Report layout and structure</li><li fr-original-style="" style="box-sizing: border-box;">Storyboarding</li><li fr-original-style="" style="box-sizing: border-box;">Drill-through, bookmarks, toggles and tooltips</li></ul></div><div data-tab="5" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 5 Chart Selection</div><div data-tab="5" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Charts for comparison</li><li fr-original-style="" style="box-sizing: border-box;">Time series</li><li fr-original-style="" style="box-sizing: border-box;">Proportions</li><li fr-original-style="" style="box-sizing: border-box;">Constructing effective tables, cards and slicers</li><li fr-original-style="" style="box-sizing: border-box;">Scatterplots</li></ul></div><div data-tab="6" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 6 Accessibility And Custom Visuals</div><div data-tab="6" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Report accessibility checklists</li><li fr-original-style="" style="box-sizing: border-box;">Custom visuals</li><li fr-original-style="" style="box-sizing: border-box;">Creating a custom R visual</li><li fr-original-style="" style="box-sizing: border-box;">Charticulator</li></ul></div><div data-tab="7" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 7 Publishing And Formatting</div><div data-tab="7" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Colour schemes</li><li fr-original-style="" style="box-sizing: border-box;">Making a Power BI theme</li><li fr-original-style="" style="box-sizing: border-box;">Use of fonts, icons and symbols</li><li fr-original-style="" style="box-sizing: border-box;">Sizing dashboard and report tiles</li><li fr-original-style="" style="box-sizing: border-box;">Sparklines, hyperlinks and images</li></ul></div><div data-tab="8" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 8 Report Authoring - Best Practices</div><div data-tab="8" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Design thought process</li><li fr-original-style="" style="box-sizing: border-box;">The audience</li><li fr-original-style="" style="box-sizing: border-box;">Defining the platform environment</li><li fr-original-style="" style="box-sizing: border-box;">The user experience</li><li fr-original-style="" style="box-sizing: border-box;">Visualization</li><li fr-original-style="" style="box-sizing: border-box;">Implementation and testing</li><li fr-original-style="" style="box-sizing: border-box;">Optimization</li></ul></div><div data-tab="9" tabindex="0" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(99, 93, 255); box-sizing: border-box;" fr-original-style=" color: rgb(99, 93, 255);"><i fr-original-style="" style="box-sizing: border-box;"></i></span>Module 9 Dashboard And Goals Design</div><div data-tab="9" style="color: rgb(61, 78, 96); box-sizing: border-box;" fr-original-style=" color: rgb(61, 78, 96);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Tips and tricks</li><li fr-original-style="" style="box-sizing: border-box;">Best practices for dashboard design</li><li fr-original-style="" style="box-sizing: border-box;">Tracking business metrics with goals</li></ul></div></div></div>

Advanced Visualization with Power BI (AVIAD)

<div id="isPasted" style="color: rgb(28, 34, 38); box-sizing: border-box;" fr-original-style=" color: rgb(28, 34, 38);"><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">1st- 4th Feb 2024 - <span style="color: rgb(226, 80, 65); box-sizing: border-box;" fr-original-style="color: rgb(226, 80, 65);">Module 1</span></h2><h2 fr-original-style="" style="box-sizing: border-box;">8th - 11th Feb 2024 - <span style="color: rgb(226, 80, 65); box-sizing: border-box;" fr-original-style="color: rgb(226, 80, 65);">Module 2</span></h2><h2 fr-original-style="" style="box-sizing: border-box;">&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">An uplifting training designed to bring out the best in you&hellip;</strong></h2></div><div style="color: rgb(28, 34, 38); box-sizing: border-box;" fr-original-style=" color: rgb(28, 34, 38);"><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Every once in a while, an opportunity comes along that is irresistible. &nbsp;</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">It&rsquo;s life-changing potential is so great that it makes sense to grasp it both physically and mentally.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">What would you do if you could&nbsp;spend a short amount of time&nbsp;on yourself &ndash; a matter of days &ndash; to&nbsp;create complete and total buzz in your life?</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">The kind of buzz that goes on&hellip;and on, not just while you&rsquo;re on a wave of emotion following a seminar perhaps, or a motivational talk.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Learning NLP can do exactly that for you. &nbsp;It allows you to be in charge of your mind, body and life and shows you how you can achieve anything you want.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why You Should Start on This Path</strong></h2><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Andrew Carnegie, who was one of the most successful men in the world and the mentor to Napoleon Hill, knew three things about all successful people:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Successful people&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">make&nbsp;lots&nbsp;of decisions</strong>. Because it is in our moments of decision that we transform our destiny.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Successful people&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">make decisions quickly</strong>. Too many average people spend all their time taking aim and never getting around to &ldquo;pulling the trigger.&rdquo; Highly successful people, on the other hand, take this approach to life: &ldquo;Ready! Fire! Aim!&rdquo;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Once they start on a path, successful people&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">never give up until they&rsquo;ve reached their destination</strong>.&nbsp;They always&nbsp;complete the entire journey, no matter what the obstacles.</li></ul><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">When you look at the most successful people, you will see they have&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">all three&nbsp;of these traits</strong>, while people who have yet to&nbsp;create success&nbsp;will be lacking one or more&hellip; maybe even all of them.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">And, no &ndash; it&rsquo;s not that they were &ldquo;born with it.&rdquo; This&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">attitude of success</strong>&nbsp;is one you can adopt right now, simply by making the decision to be successful and following these three simple rules.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Because when a rare opportunity like this presents itself to a success minded individual, they&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">take action&nbsp;first</strong>, and then&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">adjust for the results</strong>&nbsp;and&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">reap the rewards</strong>.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">And now that you&rsquo;re aware of this,&nbsp;opportunity is knocking&nbsp;on your door,&nbsp;desperately&nbsp;hoping that you&rsquo;ll&nbsp;pay attention.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">And our NLP trainings are the perfect avenue to foster the attitude, gain the tools and create that success.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Using these tools, you can:</strong></h2><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Be in charge of your own state&nbsp;so you&rsquo;re never again an emotional slave to anyone else, or to &ldquo;which side of the bed you got out of in the morning.&rdquo;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Take control of your unconscious patterns&nbsp;to eliminate bad habits and install alternative, better behaviours.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Change the way you feel about things using your mind&nbsp;so you can eliminate limiting beliefs, motivate yourself to do something you don&rsquo;t want to but must, or dislike tempting foods &mdash; all&nbsp;instantly.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Become more influential and persuasive&nbsp;by using the conversational hypnotic language skills modelled from the famous Hypnotherapist Dr Milton H. Erickson who could hypnotise people just by telling them stories.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Improve your quality of life&nbsp;by removing inner conflict and incongruence.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Eliminate bad feelings from the past&nbsp;like anger, sadness, fear, hurt, guilt and more &mdash; even if you don&rsquo;t remember the source. It&rsquo;s like wiping the slate clean for the first time since you were born.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn to discover people&rsquo;s body language, thought patterns and personality traits,&nbsp;so that in a matter of minutes, you could tell them more than they know about themselves, motivate them and predict their choices and behavior with eerie accuracy.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn to change people&rsquo;s minds conversationally&nbsp;using techniques such as reframing, Quantum Linguistics, Decision Destroyer, Sleight of Mouth Patterns, and more.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">And so much more&hellip;&nbsp;This is just the tip of the iceberg!</li></ul><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">These are the same exact tools that motivational speakers like Richard Bandler, Tony Robbins, and Paul McKenna have been using for years to help millions of people &mdash; and become multi-millionaires while doing it! And you can learn them, too!</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Once you&rsquo;ve taken these trainings, you&rsquo;ll know how to do all this for yourself,&nbsp;and&nbsp;for others, both casually and professionally.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is NLP?</strong></h2><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">NLP is the study of excellence, and how to&nbsp;reproduce it in yourself&nbsp;and others.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">NLP comes in four levels, and the two starting levels are:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Practitioner, where you learn to work with yourself and others to eliminate the obstacles in life and create happiness, success and prosperity using powerful techniques to change emotions, beliefs, habits and behaviours. </li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Master Practitioner, where you master all the skills of NLP for working with yourself and others on the deepest issues affecting the core of your being, like your beliefs, values and identity. </li></ul><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">&nbsp;Even if you never plan to work with others, NLP will give you the life skills you need to achieve nearly anything imaginable in your own life.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why You Should Start on This Path</strong></h2><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Each level is more transformational than the previous, and at each level of achievement, you&rsquo;ll evolve into a more complete, more satisfied, more &ldquo;in control&rdquo; person.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Even if you have no intention of ever working with or training others, when you&nbsp;enrol in these up-coming trainings&nbsp;you will transform your life and take you beyond the next level of joy, love, achievement and success.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why you should stop&nbsp;everything&nbsp;you&rsquo;re doing and do whatever it takes to begin this journey right now</strong></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">These trainings change lives. While NLP has always been taught as a tool to help others, using all of these principles in your own life will create the prosperity, health and love that you&rsquo;ve always wanted.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">I know this for a fact, because it did for me, and has for many people I&rsquo;ve taught over the last few years.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">If you know you want more out of life, you must take action and&nbsp;do this&nbsp;now. Who knows where you&rsquo;ll be next year if you don&rsquo;t&nbsp;invest in yourself today?</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">We can work with you on a payment plan that you can afford, no matter what your budget. Call me today, and I know I can help you&nbsp;overcome any obstacles&nbsp;that seem to be in your way, whatever they are.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">I can use my skills to focus you on the result and help you overcome any obstacle, be it money, time, or those who unintentionally hold you back, like your family or your boss. I will help you come up with a solution, because sharing this with you is my passion.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Our courses are simply the best NLP trainings out there. But that&rsquo;s not even the reason you&rsquo;ll want to sign up right now. As you begin to comprehend the massive impact the training will make in and to your life, you&rsquo;ll agree that it is completely irresistible and you&#39;ll just want to quickly sign-up.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">See you in the course.</p></div>

Abu Yusra

Health & Wellbeing

Depression

Personal Development

Mindfulness

Emotional Intelligence (EQ)

Health

Soft Skills

Emotional Freedom Techniques (EFT)

Anxiety Management

Growth Mindset

NLP Practitioner

Hypnosis

Public Speaking

Presentation Skills

NLP is the study of excellence, and how to reproduce it in yourself and others.

The starting level is Practitioner, where you learn to work with yourself and others to eliminate the obstacles in life and create happiness, success and prosperity using powerful techniques to change emotions, beliefs, habits and behaviours. 

Online NLP Practitioner Certification Training (starting 1 Feb '24)

Full pay

3 instalments of £600 each - pay first instalment now, and a further 2 instalments 14 days and 30 days from now confirmed by an instalment agreement which we will send to you 

Instalment option

<div id="isPasted" style="color: rgb(28, 34, 38); box-sizing: border-box;" fr-original-style=" color: rgb(28, 34, 38);"><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">7th - 10th Dec 2023 - <span style="color: rgb(226, 80, 65); box-sizing: border-box;" fr-original-style="color: rgb(226, 80, 65);">Module 1</span></h2><h2 fr-original-style="" style="box-sizing: border-box;">14th - 17th Dec 2023 - <span style="color: rgb(226, 80, 65); box-sizing: border-box;" fr-original-style="color: rgb(226, 80, 65);">Module 2</span></h2><h2 fr-original-style="" style="box-sizing: border-box;"> <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">An uplifting training designed to bring out the best in you&hellip;</strong></h2></div><div style="color: rgb(28, 34, 38); box-sizing: border-box;" fr-original-style=" color: rgb(28, 34, 38);"><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Every once in a while, an opportunity comes along that is irresistible. &nbsp;</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">It&rsquo;s life-changing potential is so great that it makes sense to grasp it both physically and mentally.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">What would you do if you could&nbsp;spend a short amount of time&nbsp;on yourself &ndash; a matter of days &ndash; to&nbsp;create complete and total buzz in your life?</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">The kind of buzz that goes on&hellip;and on, not just while you&rsquo;re on a wave of emotion following a seminar perhaps, or a motivational talk.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Learning NLP can do exactly that for you. &nbsp;It allows you to be in charge of your mind, body and life and shows you how you can achieve anything you want.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why You Should Start on This Path</strong></h2><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Andrew Carnegie, who was one of the most successful men in the world and the mentor to Napoleon Hill, knew three things about all successful people:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Successful people&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">make&nbsp;lots&nbsp;of decisions</strong>. Because it is in our moments of decision that we transform our destiny.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Successful people&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">make decisions quickly</strong>. Too many average people spend all their time taking aim and never getting around to &ldquo;pulling the trigger.&rdquo; Highly successful people, on the other hand, take this approach to life: &ldquo;Ready! Fire! Aim!&rdquo;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Once they start on a path, successful people&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">never give up until they&rsquo;ve reached their destination</strong>.&nbsp;They always&nbsp;complete the entire journey, no matter what the obstacles.</li></ul><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">When you look at the most successful people, you will see they have&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">all three&nbsp;of these traits</strong>, while people who have yet to&nbsp;create success&nbsp;will be lacking one or more&hellip; maybe even all of them.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">And, no &ndash; it&rsquo;s not that they were &ldquo;born with it.&rdquo; This&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">attitude of success</strong>&nbsp;is one you can adopt right now, simply by making the decision to be successful and following these three simple rules.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Because when a rare opportunity like this presents itself to a success minded individual, they&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">take action&nbsp;first</strong>, and then&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">adjust for the results</strong>&nbsp;and&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">reap the rewards</strong>.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">And now that you&rsquo;re aware of this,&nbsp;opportunity is knocking&nbsp;on your door,&nbsp;desperately&nbsp;hoping that you&rsquo;ll&nbsp;pay attention.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">And our NLP trainings are the perfect avenue to foster the attitude, gain the tools and create that success.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Using these tools, you can:</strong></h2><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Be in charge of your own state&nbsp;so you&rsquo;re never again an emotional slave to anyone else, or to &ldquo;which side of the bed you got out of in the morning.&rdquo;</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Take control of your unconscious patterns&nbsp;to eliminate bad habits and install alternative, better behaviours.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Change the way you feel about things using your mind&nbsp;so you can eliminate limiting beliefs, motivate yourself to do something you don&rsquo;t want to but must, or dislike tempting foods &mdash; all&nbsp;instantly.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Become more influential and persuasive&nbsp;by using the conversational hypnotic language skills modelled from the famous Hypnotherapist Dr Milton H. Erickson who could hypnotise people just by telling them stories.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Improve your quality of life&nbsp;by removing inner conflict and incongruence.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Eliminate bad feelings from the past&nbsp;like anger, sadness, fear, hurt, guilt and more &mdash; even if you don&rsquo;t remember the source. It&rsquo;s like wiping the slate clean for the first time since you were born.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn to discover people&rsquo;s body language, thought patterns and personality traits,&nbsp;so that in a matter of minutes, you could tell them more than they know about themselves, motivate them and predict their choices and behavior with eerie accuracy.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Learn to change people&rsquo;s minds conversationally&nbsp;using techniques such as reframing, Quantum Linguistics, Decision Destroyer, Sleight of Mouth Patterns, and more.</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">And so much more&hellip;&nbsp;This is just the tip of the iceberg!</li></ul><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">These are the same exact tools that motivational speakers like Richard Bandler, Tony Robbins, and Paul McKenna have been using for years to help millions of people &mdash; and become multi-millionaires while doing it! And you can learn them, too!</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Once you&rsquo;ve taken these trainings, you&rsquo;ll know how to do all this for yourself,&nbsp;and&nbsp;for others, both casually and professionally.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is NLP?</strong></h2><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">NLP is the study of excellence, and how to&nbsp;reproduce it in yourself&nbsp;and others.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">NLP comes in four levels, and the two starting levels are:</p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Practitioner, where you learn to work with yourself and others to eliminate the obstacles in life and create happiness, success and prosperity using powerful techniques to change emotions, beliefs, habits and behaviours. </li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Master Practitioner, where you master all the skills of NLP for working with yourself and others on the deepest issues affecting the core of your being, like your beliefs, values and identity. </li></ul><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">&nbsp;Even if you never plan to work with others, NLP will give you the life skills you need to achieve nearly anything imaginable in your own life.</p><h2 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why You Should Start on This Path</strong></h2><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Each level is more transformational than the previous, and at each level of achievement, you&rsquo;ll evolve into a more complete, more satisfied, more &ldquo;in control&rdquo; person.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Even if you have no intention of ever working with or training others, when you&nbsp;enrol in these up-coming trainings&nbsp;you will transform your life and take you beyond the next level of joy, love, achievement and success.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why you should stop&nbsp;everything&nbsp;you&rsquo;re doing and do whatever it takes to begin this journey right now</strong></p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">These trainings change lives. While NLP has always been taught as a tool to help others, using all of these principles in your own life will create the prosperity, health and love that you&rsquo;ve always wanted.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">I know this for a fact, because it did for me, and has for many people I&rsquo;ve taught over the last few years.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">If you know you want more out of life, you must take action and&nbsp;do this&nbsp;now. Who knows where you&rsquo;ll be next year if you don&rsquo;t&nbsp;invest in yourself today?</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">We can work with you on a payment plan that you can afford, no matter what your budget. Call me today, and I know I can help you&nbsp;overcome any obstacles&nbsp;that seem to be in your way, whatever they are.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">I can use my skills to focus you on the result and help you overcome any obstacle, be it money, time, or those who unintentionally hold you back, like your family or your boss. I will help you come up with a solution, because sharing this with you is my passion.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">Our courses are simply the best NLP trainings out there. But that&rsquo;s not even the reason you&rsquo;ll want to sign up right now. As you begin to comprehend the massive impact the training will make in and to your life, you&rsquo;ll agree that it is completely irresistible and you&#39;ll just want to quickly sign-up.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: var(--text);">See you in the course.</p></div>

Online NLP Practitioner Certification Training (starting 7 Dec '23)

3 equal instalments of £500 each. You agree to pay £500 now and the balance of £1000, split over 2 further instalments of £500 each, which will be confirmed by an instalment agreement form sent to you in due course.

In course pay

Quick pay

<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>

Powershell

Power Automate

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 Azure

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

Microsoft Power Platform

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>

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Microsoft BI

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

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>

Excel Analytics

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

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

146 Courses delivered Online

Level 4 Diploma in Advanced Excel Course (Formula, VLOOKUP & Power Query) - QLS Endorsed

By Kingston Open College

55318: Advanced Automated Administration with Windows PowerShell

By Nexus Human

Power BI Data Analyst (PL300)

By Online Productivity Training

Mechanical Engineering Basics Course

By Training Express

Advanced Data Modelling and Shaping (MSIAD)

By Online Productivity Training

Microsoft Excel 2021/365 - Beginner to Advanced

By Packt

Power BI Tips and Tricks (Includes Time-Saving ChatGPT Prompts)

By Packt

Advanced Visualization with Power BI (AVIAD)

By Online Productivity Training

Online NLP Practitioner Certification Training (starting 1 Feb '24)

By Abu Yusra

Online NLP Practitioner Certification Training (starting 7 Dec '23)

By Abu Yusra