<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Anyone who wants to learn how to create movies - from a home movie to professional looking films using iMovie.</p><p>This one-day hands-on course will teach the participant the full functionality of iMovie. The course will begin with how to import video and photographs into iMovie; how to review and organize the footage; how to shape a story using the editing and trimming tools; how to add music and sound and other video effects and overlays.  Lastly, the class will explore sharing your completed movies with your Mac computer, YouTube and other streaming outlets.</p></div><div id="course-pills-2"><h4>Introduction to iMovie</h4><ul><li>Adding Media from Photo Library</li><li>Other Ways to Import Media</li><li>From iPad, iPhone, or iPod Touch</li><li>Record Video Directly into iMovie</li><li>Importing Media from Mac</li><li>Playing or Skimming Video</li><li>Sorting and Searching for Clips</li><li>Marking Clips as Favorite or Rejected</li></ul><h4>Creating Movies</h4><ul><li>Creating a New Movie</li><li>Viewing and Managing Projects</li><li>Setting Movie Themes</li><li>Selecting Clips</li><li>Adding and Trimming Clips</li><li>Moving and Splitting Clips</li><li>Adding and Modifying Transitions</li><li>Adding and Editing Titles</li><li>Adding Music and Sound Clips</li></ul><h4>Working with Trailers (If required)</h4><ul><li>Creating Trailer</li><li>Adding Video</li><li>Adding Titles and Credits</li><li>Converting Trailer to Movie</li></ul><h4>Adding Video Effects</h4><ul><li>Enhancing Clip</li><li>Adjusting Clip?s Order</li><li>Cropping and Rotating Clips</li><li>Stabilizing Shaky Clips</li><li>Adding Video Effects</li><li>Adding Freeze Frame</li><li>Creating Effects with Multiple Clips</li><li>Slow Down and Speed Up Clips</li><li>Adding Instant Replay or Rewind Effect</li><li>Copy Effects and Adjustments</li></ul><h4>Sharing Video Clips and Projects</h4><ul><li>Email Movie, Trailer, and Clip</li><li>Exporting Quick Time File</li><li>Exporting an Image</li><li>Share Online</li></ul><h4>Customizing iMovie</h4><ul><li>iMovie Preferences</li><li>Customizing Project Settings</li><li>Changing iMovie Window Layout</li><li>Changing How Clips are Displayed</li></ul><h4>Organizing Media</h4><ul><li>Organizing Media and Events</li><li>Working with Multiple Libraries</li><li>Consolidating Projects and Events</li></ul><h4>Keyboard Shortcuts and Gestures</h4><ul><li>Overview of Keyboard Shortcuts</li><li>Keyboard Shortcuts</li><li>Multi-Touch Gestures</li><li>Force Touch Trackpad Gestures</li></ul></div>

Nexus Human

Film Editing

iMovie

Video Creation

Filmmaking

Video Production

Video Editing

iMovie Essentials

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>The audience for this course is either: a Dynamics 365 consultant who wants to learn Commerce, or a retail analyst with core Dynamics 365 experience who wants to apply their skills to the Dynamics product family.</p>Overview<p>After completing this course, students will be able to:<br />Configure Dynamics 365 Commerce Headquarters<br />Configure products, prices, discounts, loyalty, and affiliations<br />Manage Point of Sale (POS) in Dynamics 365 Commerce<br />Configure and Manage Dynamics 365 Commerce call centers<br />Manage e-commerce</p><p>Dynamics 365 Commerce functional consultants set up and use the application functionality in Dynamics 365 Commerce, and provide support for the application. The functional consultant typically has a strong understanding of unified commerce business operations, and experience configuring, deploying, maintaining, and using Microsoft Dynamics 365 Commerce. This four-day course covers the essentials for the role</p></div><div id="course-pills-2"><h4>Module 1: Get started with Dynamics 365 Commerce</h4><ul><li>Introduction to Unified Commerce platform</li><li>Dynamics 365 Commerce architecture</li><li>Deployment of Dynamics 365 Commerce</li><li>Hardware and peripherals</li></ul><h4>Module 2: Configure Commerce Headquarters</h4><ul><li>Configure prerequisites and Commerce parameters</li><li>Configure and maintain payment processing</li><li>Configure Commerce Data Exchange (CDX)</li><li>Configure delivery modes and charges</li><li>Configure and work with statements</li></ul><h4>Module 3: Products and Merchandising</h4><ul><li>Product information management</li><li>Merchandising in Dynamics 365 Commerce</li><li>Product recommendations and product discovery</li></ul><h4>Module 4: Retail Pricing</h4><ul><li>Manage Pricing</li><li>Manage discounts and promotions</li></ul><h4>Module 5: Loyalty and customer experience</h4><ul><li>Customer Management</li><li>Loyalty and affiliations</li></ul><h4>Module 6: Point of sale</h4><ul><li>Introduction to POS</li><li>Channel Setup</li><li>Configure Cash and Shift management</li><li>Worker Setup</li><li>Point of Sale Setup</li><li>Customer management at POS</li><li>Transaction processing</li><li>Inventory processing</li><li>End of day processing</li><li>Reporting</li><li>Configure and work with Task management</li><li>Test POS</li><li>Maintain registers and devices</li><li>Localization</li></ul><h4>Module 7: Configure and work with call centers in Dynamics 365 Commerce</h4><ul><li>Configure channel</li><li>Configure Product Catalogs</li><li>Configure Order Holds</li><li>Create call center orders</li><li>Configure call center directed selling</li><li>Configure Returns and Refunds</li><li>Configure continuity orders and installment billing</li></ul><h4>Module 8: Work with E-Commerce in Dynamics 365 Commerce</h4><ul><li>Describe e-commerce core capabilities</li><li>Configure an E-Commerce Channel in Dynamics 365 HQ</li><li>Configure an E-Commerce site</li><li>Configure and manage E-Commerce site content</li><li>Describe &amp; Demonstrate digital asset management</li><li>Configure business-to-business (B2B) site</li><li>Configure Ratings and reviews functionality</li><li>Demonstrate E-Commerce Order Processing</li></ul><h4>Module 9: Manage order fulfillment and inventory in Dynamics 365 Commerce</h4><ul><li>Configure and work with Stock replenishment</li><li>Configure and work with Order fulfillment</li></ul><h4>Module 10: Work with Dynamics 365 Fraud Protection</h4><ul><li>Overview of Dynamics Fraud Protection</li><li>Describe Dynamics Fraud Protection Services</li><li>Configure and work with Dynamics Fraud Protection with Dynamics 365 Commerce</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans MB-340T00: Microsoft Dynamics 365 Commerce Functional Consultant 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 MB-340T00: Microsoft Dynamics 365 Commerce Functional Consultant 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>

Online Course Marketing

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-303

Microsoft AZ-700

Microsoft Dynamics

MB-340T00: Microsoft Dynamics 365 Commerce Functional Consultant

<div id="course-pills-1">Duration<p>2.75 Days</p><p>16.5 CPD hours</p>This course is intended for<p>This course is designed for a person with an understanding of project management concepts, as well as general desktop computer skills, and who will be responsible for creating and maintaining project plans. This course will give you the fundamental understanding as well as acquiring the advanced knowledge and skills needed to update a project plan in Microsoft Project during the execution, monitoring, and controlling phases of a project.</p>Overview<p>Identify project management concepts and navigate Microsoft 2. 2. Project Professional.<br />Create a new project plan.<br />Add tasks to a project.<br />Manage task relationships within a project.<br />Manage project resources.<br />fnalize a project plan.<br />Update a project plan.<br />Generate project views to manage a project.<br />Create project reports to share a project's status.<br />Reuse project plan information.<br />Work with multiple projects.</p><p>This course will familiarize the user with the basic features and functions of MS Project so that it can be used effectively and efficiently in a real-world environment. MS project will give the ability to project managers to update a project plan in Project during the execution, monitoring, and controlling phases of a project</p></div><div id="course-pills-2"><h4>GETTING STARTED WITH MICROSOFT PROJECT</h4><ul><li>Topic A: Identify Project Management Concepts</li><li>Topic B: Navigate in the Microsoft Project Desktop environment</li></ul><h4>DEFINING A PROJECT</h4><ul><li>Topic A: Create a New Project Plan File</li><li>Topic B: Set Project Plan Options</li><li>Topic C: Assign a Project Calendar</li></ul><h4>ADDING PROJECT TASKS</h4><ul><li>Topic A: Add Tasks to a Project Plan</li><li>Topic B: Enter Task Duration Estimates</li></ul><h4>MANAGING TASKS</h4><ul><li>Topic A: Create a Work Breakdown Structure</li><li>Topic B: Define Task Relationships</li><li>Topic C: Schedule Tasks</li></ul><h4>MANAGING PROJECT RESOURCES</h4><ul><li>Topic A: Add Resources to a Project</li><li>Topic B: Create a Resource Calendar</li><li>Topic C: Enter Costs for Resources</li><li>Topic D: Assign Resources to Tasks</li><li>Topic E: Resolve Resource Conflicts</li></ul><h4>FINALIZING A PROJECT PLAN</h4><ul><li>Topic A: Optimize a Project Plan</li><li>Topic B: Set a Baseline</li><li>Topic C: Share a Project Plan</li></ul><h4>UPDATING A PROJECT PLAN</h4><ul><li>Topic A: Enter Task Progress</li><li>Topic B: Enter Overtime Work</li><li>Topic C: Edit Tasks</li><li>Topic D: Update Cost Rate Tables</li><li>Topic E: Update a Baseline</li></ul><h4>VIEWING PROJECT PROGRESS</h4><ul><li>Topic A: Use View Commands</li><li>Topic B: Add a Custom Field</li><li>Topic C: Create Custom Views</li><li>Topic D: Format and Share the Timeline View</li></ul><h4>REPORTING ON PROJECT PROGRESS</h4><ul><li>Topic A: View Built-in Reports</li><li>Topic B: Create Custom Reports</li><li>Topic C: Create a Visual Report</li></ul><h4>REUSING PROJECT PLAN INFORMATION</h4><ul><li>Topic A: Create a Project Plan Template</li><li>Topic B: Share Project Plan Elements with Other Plans</li></ul><h4>WORKING WITH MULTIPLE PROJECTS</h4><ul><li>Topic A: Share Resources</li><li>Topic B: Link Project Plans</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft Project 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 Microsoft Project 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 Project

Project Management Qualification (PMQ)

Project Management Professional (PMP)

Project Management

Google Project Management

Project Manager

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This is an introductory-level C++ programming course designed for developers with experience programming in C or other languages. Practical hands-on prior programming experience and knowledge is required.</p>Overview<p>This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in basic coding with C++, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn:<br />Writing procedural programs using C++<br />Using private, public and protected keywords to control access to class members<br />Defining a class in C++<br />Writing constructors and destructors<br />Writing classes with const and static class members<br />Overloading operators<br />Implementing polymorphic methods in programs<br />Writing programs using file I/O and string streams<br />Using manipulators and stream flags to format output<br />Using the keyword template to write generic functions and classes<br />Writing programs that use generic classes and functions<br />Writing programs that use algorithms and containers of the Standard Library<br />Apply object-oriented design techniques to real-world programming problems<br />Using algorithms and containers of the Standard Library to manipulate string data<br />Understand how C++ protects the programmer from implementation changes in other modules of an application<br />Using try() blocks to trap exceptions<br />Using catch() blocks to handle exceptions<br />Defining exceptions and using throw to trigger them</p><p>Introduction to C++ Programming / C++ Essentials is a skills-focused, hands-on C++ training course geared for experienced programmers who need to learn C++ coupled with sounds coding skills and best practices for OO development. Students will leave this course armed with the required skills to put foundation-level C++ programming skills right to work in a practical environment. The central concepts of C++ syntax and style are taught in the context of using object-oriented methods to achieve reusability, adaptability and reliability. Emphasis is placed on the features of C++ that support abstract data types, inheritance, and polymorphism. Students will learn to apply the process of data abstraction and class design. Practical aspects of C++ programming including efficiency, performance, testing, and reliability considerations are stressed throughout. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency</p></div><div id="course-pills-2"><h4>Moving from C to C++ (Optional)</h4><ul><li>New Compiler Directives</li><li>Stream Console I/O</li><li>Explicit Operators</li><li>Standard Libraries</li><li>Data Control Capabilities</li></ul><h4>Handling Data</h4><ul><li>New Declaration Features</li><li>Initialization and Assignment</li><li>Enumerated Types</li><li>The bool Type</li><li>Constant Storage</li><li>Pointers to Constant Storage</li><li>Constant Pointers</li><li>References</li><li>Constant Reference Arguments</li><li>Volatile Data</li><li>Global Data</li></ul><h4>Functions</h4><ul><li>Function Prototypes and Type Checking</li><li>Default Function Data Types</li><li>Function Overloading</li><li>Problems with Function Overloading</li><li>Name Resolution</li><li>Promotions and Conversions</li><li>Call by Value</li><li>Reference Declarations</li><li>Call-by-Reference and Reference Types</li><li>References in Function Return</li><li>Constant Argument Types</li><li>Conversion of Parameters Using Default Initializers</li><li>Providing Default Arguments</li><li>Inline Functions</li></ul><h4>Operator Overloading</h4><ul><li>Advantages and Pitfalls of Overloading</li><li>Member Operator Syntax and Examples</li><li>Class Assignment Operators</li><li>Class Equality Operators</li><li>Non-Member Operator Overloading</li><li>Member and Non-Member Operator Functions</li><li>Operator Precedence</li><li>This Pointer</li><li>Overloading the Assignment Operator</li><li>Overloading Caveats</li></ul><h4>Creating and Using Objects</h4><ul><li>Creating Automatic Objects</li><li>Creating Dynamic Objects</li><li>Calling Object Methods</li><li>Constructors</li><li>Initializing Member consts</li><li>Initializer List Syntax</li><li>Allocating Resources in Constructor</li><li>Destructors</li><li>Block and Function Scope</li><li>File and Global Scope</li><li>Class Scope</li><li>Scope Resolution Operator ::</li><li>Using Objects as Arguments</li><li>Objects as Function Return Values</li><li>Constant Methods</li><li>Containment Relationships</li></ul><h4>Dynamic Memory Management</h4><ul><li>Advantages of Dynamic Memory Allocation</li><li>Static, Automatic, and Heap Memory</li><li>Free Store Allocation with new and delete</li><li>Handling Memory Allocation Errors</li></ul><h4>Controlling Object Creation</h4><ul><li>Object Copying and Copy Constructor</li><li>Automatic Copy Constructor</li><li>Conversion Constructor</li></ul><h4>Streaming I/O</h4><ul><li>Streams and the iostream Library</li><li>Built-in Stream Objects</li><li>Stream Manipulators</li><li>Stream Methods</li><li>Input/Output Operators</li><li>Character Input</li><li>String Streams</li><li>Formatted I/O</li><li>File Stream I/O</li><li>Overloading Stream Operators</li><li>Persistent Objects</li><li></li></ul><h4>Introduction to Object Concepts</h4><ul><li>The Object Programming Paradigm</li><li>Object-Orientated Programming Definitions</li><li>Information Hiding and Encapsulation</li><li>Separating Interface and Implementation</li><li>Classes and Instances of Objects</li><li>Overloaded Objects and Polymorphism</li></ul><h4>Declaring and Defining Classes</h4><ul><li>Components of a Class</li><li>Class Structure</li><li>Class Declaration Syntax</li><li>Member Data</li><li>Built-in Operations</li><li>Constructors and Initialization</li><li>Initialization vs. Assignment</li><li>Class Type Members</li><li>Member Functions and Member Accessibility</li><li>Inline Member Functions</li><li>Friend Functions</li><li>Static Members</li><li>Modifying Access with a Friend Class</li></ul><h4>Templates</h4><ul><li>Purpose of Template Classes</li><li>Constants in Templates</li><li>Templates and Inheritance</li><li>Container Classes</li><li>Use of Libraries</li></ul><h4>Strings in C++</h4><ul><li>Character Strings</li><li>The String Class</li><li>Operators on Strings</li><li>Member Functions of the String Class</li></ul><h4>Inheritance</h4><ul><li>Inheritance and Reuse</li><li>Composition vs. Inheritance</li><li>Inheritance: Centralized Code</li><li>Inheritance: Maintenance and Revision</li><li>Public, Private and Protected Members</li><li>Redefining Behavior in Derived Classes</li><li>Designing Extensible Software Systems</li><li>Syntax for Public Inheritance</li><li>Use of Common Pointers</li><li>Constructors and Initialization</li><li>Inherited Copy Constructors</li><li>Destructors and Inheritance</li><li>Public, Protected, Private Inheritance</li><li></li></ul><h4>Exceptions</h4><ul><li>Types of Exceptions</li><li>Trapping and Handling Exceptions</li><li>Triggering Exceptions</li><li>Handling Memory Allocation Errors</li></ul><h4>C++ Program Structure</h4><ul><li>Organizing C++ Source Files</li><li>Integrating C and C++ Projects</li><li>Using C in C++</li></ul><h4>Reliability Considerations in C++ Projects</h4><ul><li>Function Prototypes</li><li>Strong Type Checking</li><li>Constant Types</li><li>C++ Access Control Techniques</li></ul><h4>Polymorphism in C++</h4><ul><li>Definition of Polymorphism</li><li>Calling Overridden Methods</li><li>Upcasting</li><li>Accessing Overridden Methods</li><li>Virtual Methods and Dynamic Binding</li><li>Virtual Destructors</li><li>Abstract Base Classes and Pure Virtual Methods</li></ul><h4>Multiple Inheritance</h4><ul><li>Derivation from Multiple Base Classes</li><li>Base Class Ambiguities Virtual Inheritance</li><li>Virtual Base Classes</li><li>Virtual Base Class Information</li></ul><h4>The Standard Template Library</h4><ul><li>STL Containers</li><li>Parameters Used in Container Classes</li><li>The Vector Class</li><li>STL Algorithms</li><li>Use of Libraries</li></ul></div>

Computing Skills

Programming Fundamentals

Computer Programming

Core Skills Training Framework (CSTF)

C (programming language)

Introduction to C Plus Plus Programming Essentials (TTCP2100)

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices. Targeted at: DBAs and Architects, and appropriate for Analysts, Support Engineers, and other IT professionals</p>Overview<p>Please refer to overview</p><p>This is an immersive 5-day class that offers hands-on labs and combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration into a one-week class, with significant savings over list price. Upon course completion, you will be prepared to manage mission critical PostgreSQL installations, and perform core administration tasks with confidence and skill.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>1 - POSTGRES SYSTEM ARCHITECTURE</li><li>2 - INSTALLATION AND GETTING STARTED</li><li>3 - CONFIGURATION, CREATING, MANAGING DATABASES</li><li>4 - USER TOOLS ? USING PSQL</li><li>5 - GUI TOOLS - USING PGADMIN 4</li><li>6 - SECURITY BASICS</li><li>7 - SQL PRIME BACKUP AND RECOVERY</li><li>8 - ROUTINE MAINTENANCE</li><li>9 - POSTGRES DATA DICTIONARY</li><li>10 - MOVING DATA</li><li>11 - SQL TUNING</li><li>12 - PERFORMANCE TUNING</li><li>13 - STREAMING REPLICATION</li><li>14 - TABLE PARTITIONING</li><li>15 - EXTENSION MODULES</li><li>16 - MONITORING</li><li>17 - UPGRADING BEST PRACTICES</li></ul></div>

PostgreSQL

Database Administration

PGDM

Comprehensive PostgreSQL Administration

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>Anyone whose role requires them to use existing Power BI Reports or Dashboards to consume the contents. Roles can include management at all levels, team leaders or anyone who needs to commission the production of reports or dashboards.<br />It is assumed that attendees on the course are familiar with charts.<br />Please note that this course is not suitable for new Excel users, delegates need<br />Ability to create charts<br />Ability to use filters in data</p>Overview<p>This course covers the use of Power BI Desktop and the Power BI service hosted in Office 365 to identify core features, terminology and processes applicable when using reports or dashboards.Delegates will learn how to:<br />Power BI Concepts and Main Features<br />How a report is created<br />Navigating reports and dashboards<br />How to apply filters and slicers<br />To use Insights, Analytics and Natural Language Queries</p><p>Power BI provides a variety of methods for using reports and dashboards within which data can be viewed and analyzed visually.</p></div><div id="course-pills-2"><h4>Getting Started with Power BI</h4><ul><li>Power BI Concepts and Versions</li><li>Introduction to Main Features:</li><li>Jargon buster</li><li>From Data to Reports and Dashboards</li><li>Visualizations Overview</li><li>Visualizations Available</li><li>Visualizations as Filter</li><li>Reports and Dashboards Similarities and differences</li></ul><h4>Understanding what you are looking at</h4><ul><li>Understanding what you are looking at</li></ul><h4>Using a Report in Power BI</h4><ul><li>Filters, sorting and using slicers</li><li>See the actual data</li><li>See Data and See Records</li><li>Drill visualizations</li><li>Off the shelf data analysis</li><li>Quick Conditional Formatting</li><li>Analytics lines</li><li>Use Insight for Increases and Decrease</li><li>Forecast Analytics</li><li>Changing calculations and Show As</li></ul><h4>Working with Dashboards</h4><ul><li>Dashboards in Power BI Defined</li><li>How is a dashboard different from a report?</li><li>Working in the Dashboard window</li><li></li></ul></div>

Powerbi

Microsoft Power Apps

Microsoft Power BI

Microsoft Power Platform

Microsoft BI

Business Intelligence (BI)

Microsoft Power BI Reports and Dashboards for Business Users

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.<br />This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification.</p>Overview<p>In this course, you will analyze data with Microsoft Power BI. You will:<br />Analyze data with self-service BI.<br />Connect to data sources.<br />Perform data cleaning, profiling, and shaping.<br />Visualize data with Power BI.<br />Enhance data analysis by adding and customizing visual elements.<br />Model data with calculations.<br />Create interactive visualizations.<br />Use advanced analysis techniques.<br />Enhance reports and dashboards.<br />Publish and share reports and dashboards.<br />Extend Power BI beyond the desktop.</p><p>As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages.<br />Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. MicrosoftÂ© Power BIÂ© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.<br /></p></div><div id="course-pills-2"><h4>Analyzing Data with Self-Service BI</h4><ul><li>Topic A: Data Analysis and Visualization for Business Intelligence</li><li>Topic B: Self-Service BI with Microsoft Power BI</li></ul><h4>Connecting to Data Sources</h4><ul><li>Topic A: Create Data Connections</li><li>Topic B: Configure and Manage Data Relationships</li><li>Topic C: Save Files in Power BI</li></ul><h4>Performing Data Cleaning, Profiling, and Shaping</h4><ul><li>Topic A: Clean, Transform, and Load Data with the Query Editor</li><li>Topic B: Profile Data with the Query Editor</li><li>Topic C: Shape Data with the Query Editor</li><li>Topic D: Combine and Manage Data Rows</li></ul><h4>Visualizing Data with Power BI</h4><ul><li>Topic A: Create Visualizations in Power BI</li><li>Topic B: Chart Data in Power BI</li></ul><h4>Enhancing Data Analysis</h4><ul><li>Topic A: Customize Visuals and Pages</li><li>Topic B: Incorporate Tooltips</li></ul><h4>Modeling Data with Calculations</h4><ul><li>Topic A: Create Calculations with Data Analysis Expressions (DAX)</li><li>Topic B: Create Calculated Measures and Conditional Columns</li></ul><h4>Creating Interactive Visualizations</h4><ul><li>Topic A: Create and Manage Data Hierarchies</li><li>Topic B: Filter and Slice Reports</li><li>Topic C: Create Dashboards</li></ul><h4>Using Advanced Analysis Techniques</h4><ul><li>Topic A: Create Calculated Tables, Variables, and Parameters</li><li>Topic B: Enhance Visuals with Statistical Analysis</li><li>Topic C: Perform Advanced Analysis</li></ul><h4>Enhancing Reports and Dashboards</h4><ul><li>Topic A: Enhance Reports</li><li>Topic B: Enhance Dashboards</li></ul><h4>Publishing and Sharing Reports and Dashboards</h4><ul><li>Topic A: Publish Reports</li><li>Topic B: Create and Manage Workspaces</li><li>Topic C: Share Reports and Dashboards</li></ul><h4>Extending Power BI Beyond the Desktop</h4><ul><li>Topic A: Use Power BI Mobile</li><li>Topic B: Extend Access with the Power BI API</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) 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 Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) 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>

Business Analytics & Intelligence

Business Data Analysis

Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3)

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.</p>Overview<p>In this course, you will analyze data with Microsoft Power BI. You will:<br />Analyze data with self-service BI.<br />Connect to data sources.<br />Perform data cleaning, profiling, and shaping.<br />Visualize data with Power BI.<br />Enhance data analysis by adding and customizing visual elements.<br />Model data with calculations.<br />Create interactive visualizations.</p><p>As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages.<br />Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. MicrosoftÂ© Power BIÂ© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.<br /></p></div><div id="course-pills-2"><h4>Analyzing Data with Self-Service BI</h4><ul><li>Topic A: Data Analysis and Visualization for Business Intelligence</li><li>Topic B: Self-Service BI with Microsoft Power BI</li></ul><h4>Connecting to Data Sources</h4><ul><li>Topic A: Create Data Connections</li><li>Topic B: Configure and Manage Data Relationships</li><li>Topic C: Save Files in Power BI</li></ul><h4>Performing Data Cleaning, Profiling, and Shaping</h4><ul><li>Topic A: Clean, Transform, and Load Data with the Query Editor</li><li>Topic B: Profile Data with the Query Editor</li><li>Topic C: Shape Data with the Query Editor</li><li>Topic D: Combine and Manage Data Rows</li></ul><h4>Visualizing Data with Power BI</h4><ul><li>Topic A: Create Visualizations in Power BI</li><li>Topic B: Chart Data in Power BI</li></ul><h4>Enhancing Data Analysis</h4><ul><li>Topic A: Customize Visuals and Pages</li><li>Topic B: Incorporate Tooltips</li></ul><h4>Modeling Data with Calculations</h4><ul><li>Topic A: Create Calculations with Data Analysis Expressions (DAX)</li><li>Topic B: Create Calculated Measures and Conditional Columns</li></ul><h4>Creating Interactive Visualizations</h4><ul><li>Topic A: Create and Manage Data Hierarchies</li><li>Topic B: Filter and Slice Reports</li><li>Topic C: Create Dashboards</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) 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 Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.  <p></p>Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.<p></p></div>

Data Skills

Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3)

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is designed for all levels of experience in using Microsoft Project, as well as all levels of experience in project management. In particular, this course is designed for persons who need to author Microsoft Project work schedules including Project Managers and Project Assistants, and for management personnel in charge of setting standards for baselining and tracking project data.</p>Overview<p>To gain an understanding of a proven mindset Microsoft Project users should possess each time they open and work Microsoft Project schedules. To gain an understanding of globally accepted project management principles. To be able to effectively apply Microsoft Project into the Execution phase of a normal project life cycle. To gain an understanding of Microsoft Project's baseline capabilities in preparation for analysis and reporting of project data.</p><p>MS Project: Project Validation, Baseline, and Tracking using Microsoft Project course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects.</p></div><div id="course-pills-2">MS Project: Project Validation, Baseline, and Tracking using Microsoft Project course provides proven tools and techniques for successfully using Microsoft Project to assist with managing projects.</div>

Project Management Institute (PMI)

MS Project (Part 2) - Project Validation, Baseline and Tracking using Microsoft Project

<div id="course-pills-1">Duration<p>3.25 Days</p><p>19.5 CPD hours</p>This course is intended for<p>This course is intended for IT administrators with a minimum 2-5 years of experiencing working with Microsoft Windows Server, Windows 10, and Office 365 licensing.</p><p>The course will utilize a pre-provisioned lab environment which includes Microsoft 365 E5 licenses and Enterprise Mobility and Security E5 licenses for each student. Powershell management topics will be discussed where applicable in the respective topics. This course will address Windows devices only enrolled in Intune.</p></div><div id="course-pills-2"><h4>Configuring and Licensing Intune</h4><ul><li>Endpoint Manager - quick discussion, portal access</li><li>Discuss which licenses include Intune</li><li>Discuss Microsoft Intune device-only subscription</li><li>Discuss Azure Active Directory basic, P1, P2 licensing</li></ul><h4>Intune setup and overview of capabilities</h4><ul><li>Supported configurations</li><li>Logging in and using Intune Admin portal via Azure Portal and via Endpoint manager site</li><li>Configure a domain name (needed to support labs though may be done already for E1B/district)</li><li>Add users and groups in Azure Portal</li><li>Configure Azure AD connect and discuss AAD Connect Health</li><li>Assigning licenses manually, via Powershell, and via AAD groups</li><li>Set the MDM authority and enable device enrollment</li><li>Add Apps to Intune - covered in detail in a later topic</li><li>Configuring device profiles - covered in detail in a later topic</li><li>Company Portal discussion - covered in detail in a later topic</li><li>Configure app policies - covered in detail in a later topic</li></ul><h4>Windows device management</h4><ul><li>What is co-management - brief discussion on Endpoint Manager with Configuration Manager</li><li>Registering, joining, hybrid join to Azure AD</li><li>Enrollment method capabilities</li><li>Azure AD joined</li><li>Azure AD joined with Autopilot (User driven mode)</li><li>Azure AD joined with Autopilot (Self deploying mode)</li><li>Autopilot pre-provisioned deployment (formally known as white-glove)</li><li>Device group tags for profile deployment</li><li>Troubleshooting Autopilot</li><li>Policy conflicts</li><li>Known issues</li><li>Using Powershell to connect to and manage Intune</li></ul><h4>Software deployment</h4><ul><li>Add apps to Intune</li><li>Windows Store apps</li><li>Microsoft Store for Business apps</li><li>LOB apps - Sideloading</li><li>Adding Win32 apps</li><li>Running Powershell Scripts on devices</li><li>Assigning Apps</li><li>Monitor Apps</li><li>Discovered Apps</li><li>Configure Apps</li><li>App Configuration Policies</li><li>Office app policys</li><li>Custom OMA-URI Policies</li><li>Troubleshooting</li></ul><h4>Managing devices</h4><ul><li>Windows 10 Feature Updates</li><li>Update rings to manage updates</li><li>Mapping drives to SMB shares</li><li>Discuss OneDrive for Business</li><li>Manage Enterprise Wireless - Windows Configuration Designer, provisioning packages</li><li>Implementing Conditional Access - device based, app based</li></ul><h4>Printer management</h4><ul><li>Universal Print</li><li>Deploying printer settings</li></ul><h4>Remote administration</h4><ul><li>Intune Device Management</li><li>Inventory</li><li>Fresh Start</li><li>Full Scan</li><li>Remote Lock</li><li>Restart</li><li>Sync devices</li><li>Bulk device actions</li><li>Teamviewer integration requirements</li></ul><h4>Intune Reporting</h4><ul><li>Accessing Reports</li><li>Exporting Reports using Graph</li></ul></div>

Microsoft 365

Microsoft AZ-104

Microsoft Intune Overview

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>This course is for Azure Security Engineers who are planning to take the associated certification exam, or who are performing security tasks in their day-to-day job. This course would also be helpful to an engineer that wants to specialize in providing security for Azure-based digital platforms and play an integral role in protecting an organization's data.</p><p></p><p></p><p>This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization?s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.</p><p></p>Prerequisites<p></p><li>AZ-104T00 - Microsoft Azure Administrator</li>  <li>Security best practices and industry security requirements such as defense in depth, least privileged access, role-based access control, multi-factor authentication, shared responsibility, and zero trust model.</li>  <li>Be familiar with security protocols such as Virtual Private Networks (VPN), Internet Security Protocol (IPSec), Secure Socket Layer (SSL), disk and data encryption methods.</li>  <li>Have some experience deploying Azure workloads. This course does not cover the basics of Azure administration, instead the course content builds on that knowledge by adding security specific information.</li>  <li>Have experience with Windows and Linux operating systems and scripting languages. Course labs may use PowerShell and the CLI.</li><p></p></div><div id="course-pills-2"><h3>1 - Manage identities in Microsoft Entra ID</h3> <ul> <li>Secure users in Microsoft Entra ID</li> <li>Secure groups in Microsoft Entra ID</li> <li>Recommend when to use external identities</li> <li>Secure external identities</li> <li>Implement Microsoft Entra Identity protection</li> </ul> <h3>2 - Manage authentication by using Microsoft Entra ID</h3> <ul> <li>Configure Microsoft Entra Verified ID</li> <li>Implement multifactor authentication (MFA)</li> <li>Implement passwordless authentication</li> <li>Implement password protection</li> <li>Implement single sign-on (SSO)</li> <li>Integrate single sign-on (SSO) and identity providers</li> <li>Recommend and enforce modern authentication protocols </li> </ul> <h3>3 - Manage authorization by using Microsoft Entra ID</h3> <ul> <li>Configure Azure role permissions for management groups, subscriptions, resource groups, and resources</li> <li>Assign built-in roles in Microsoft Entra ID</li> <li>Assign built-in roles in Azure</li> <li>Create and assign a custom role in Microsoft Entra ID</li> <li>Implement and manage Microsoft Entra Permissions Management</li> <li>Configure Microsoft Entra Privileged Identity Management </li> <li>Configure role management and access reviews by using Microsoft Entra Identity Governance</li> <li>Implement Conditional Access policies</li> </ul> <h3>4 - Manage application access in Microsoft Entra ID</h3> <ul> <li>Manage access to enterprise applications in Microsoft Entra ID, including OAuth permission grants</li> <li>Manage app registrations in Microsoft Entra ID</li> <li>Configure app registration permission scopes</li> <li>Manage app registration permission consent</li> <li>Manage and use service principals</li> <li>Manage managed identities for Azure resources</li> <li>Recommend when to use and configure a Microsoft Entra Application Proxy, including authentication</li> </ul> <h3>5 - Plan and implement security for virtual networks</h3> <ul> <li>Plan and implement Network Security Groups (NSGs) and Application Security Groups (ASGs)</li> <li>Plan and implement User-Defined Routes (UDRs)</li> <li>Plan and implement Virtual Network peering or gateway</li> <li>Plan and implement Virtual Wide Area Network, including secured virtual hub</li> <li>Secure VPN connectivity, including point-to-site and site-to-site</li> <li>Implement encryption over ExpressRoute</li> <li>Configure firewall settings on PaaS resources</li> <li>Monitor network security by using Network Watcher, including NSG flow logging</li> </ul> <h3>6 - Plan and implement security for private access to Azure resources</h3> <ul> <li>Plan and implement virtual network Service Endpoints</li> <li>Plan and implement Private Endpoints</li> <li>Plan and implement Private Link services</li> <li>Plan and implement network integration for Azure App Service and Azure Functions</li> <li>Plan and implement network security configurations for an App Service Environment (ASE)</li> <li>Plan and implement network security configurations for an Azure SQL Managed Instance</li> </ul> <h3>7 - Plan and implement security for public access to Azure resources</h3> <ul> <li>Plan and implement Transport Layer Security (TLS) to applications, including Azure App Service and API Management</li> <li>Plan, implement, and manage an Azure Firewall, Azure Firewall Manager and firewall policies</li> <li>Plan and implement an Azure Application Gateway</li> <li>Plan and implement an Azure Front Door, including Content Delivery Network (CDN)</li> <li>Plan and implement a Web Application Firewall (WAF)</li> <li>Recommend when to use Azure DDoS Protection Standard</li> </ul> <h3>8 - Plan and implement advanced security for compute</h3> <ul> <li>Plan and implement remote access to public endpoints, Azure Bastion and just-in-time (JIT) virtual machine (VM) access</li> <li>Configure network isolation for Azure Kubernetes Service (AKS)</li> <li>Secure and monitor AKS</li> <li>Configure authentication for AKS</li> <li>Configure security for Azure Container Instances (ACIs)</li> <li>Configure security for Azure Container Apps (ACAs)</li> <li>Manage access to Azure Container Registry (ACR)</li> <li>Configure disk encryption, Azure Disk Encryption (ADE), encryption as host, and confidential disk encryption</li> <li>Recommend security configurations for Azure API Management</li> </ul> <h3>9 - Plan and implement security for storage</h3> <ul> <li>Configure access control for storage accounts</li> <li>Manage life cycle for storage account access keys</li> <li>Select and configure an appropriate method for access to Azure Files</li> <li>Select and configure an appropriate method for access to Azure Blob Storage</li> <li>Select and configure an appropriate method for access to Azure Tables</li> <li>Select and configure an appropriate method for access to Azure Queues</li> <li>Select and configure appropriate methods for protecting against data security threats, including soft delete, backups, versioning, and immutable storage</li> <li>Configure Bring your own key (BYOK)</li> <li>Enable double encryption at the Azure Storage infrastructure level</li> </ul> <h3>10 - Plan and implement security for Azure SQL Database and Azure SQL Managed Instance</h3> <ul> <li>Enable database authentication by using Microsoft Entra ID</li> <li>Enable and monitor database audit</li> <li>Identify use cases for the Microsoft Purview governance portal</li> <li>Implement data classification of sensitive information by using the Microsoft Purview governance portal</li> <li>Plan and implement dynamic mask</li> <li>Implement transparent data encryption?</li> <li>Recommend when to use Azure SQL Database Always Encrypted</li> </ul> <h3>11 - Plan, implement, and manage governance for security</h3> <ul> <li>Create, assign, and interpret security policies and initiatives in Azure Policy</li> <li>Configure security settings by using Azure Blueprint</li> <li>Deploy secure infrastructures by using a landing zone</li> <li>Create and configure an Azure Key Vault</li> <li>Recommend when to use a dedicated Hardware Security Module (HSM)</li> <li>Configure access to Key Vault, including vault access policies and Azure Role Based Access Control</li> <li>Manage certificates, secrets, and keys</li> <li>Configure key rotation</li> <li>Configure backup and recovery of certificates, secrets, and keys</li> </ul> <h3>12 - Manage security posture by using Microsoft Defender for Cloud</h3> <ul> <li>Implement Microsoft Defender for Cloud</li> <li>Identify and remediate security risks by using the Microsoft Defender for Cloud Secure Score and Inventory</li> <li>Assess compliance against security frameworks and Microsoft Defender for Cloud</li> <li>Add industry and regulatory standards to Microsoft Defender for Cloud</li> <li>Add custom initiatives to Microsoft Defender for Cloud</li> <li>Connect hybrid cloud and multicloud environments to Microsoft Defender for Cloud</li> <li>Identify and monitor external assets by using Microsoft Defender External Attack Surface Management</li> </ul> <h3>13 - Configure and manage threat protection by using Microsoft Defender for Cloud</h3> <ul> <li>Enable workload protection services in Microsoft Defender for Cloud, including Microsoft Defender for Storage, Databases, Containers, App Service, Key Vault, Resource Manager, and DNS</li> <li>Configure Microsoft Defender for Servers</li> <li>Configure Microsoft Defender for Azure SQL Database</li> <li>Manage and respond to security alerts in Microsoft Defender for Cloud</li> <li>Configure workflow automation by using Microsoft Defender for Cloud</li> <li>Evaluate vulnerability scans from Microsoft Defender for Server</li> </ul> <h3>14 - Configure and manage security monitoring and automation solutions</h3> <ul> <li>Monitor security events by using Azure Monitor</li> <li>Configure data connectors in Microsoft Sentinel</li> <li>Create and customize analytics rules in Microsoft Sentinel</li> <li>Configure automation in Microsoft Sentinel</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans AZ-500T00 Microsoft Azure Security Technologies 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 AZ-500T00 Microsoft Azure Security Technologies 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 Azure

CompTIA Security+

AZ-500T00 Microsoft Azure Security Technologies

General Admission

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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-080T00 Querying Data with Microsoft Transact-SQL 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>

Learning & Development

Design & Technology Courses (DT)

Trainers Course

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p></p><p>The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.</p><p></p>Overview<p>Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure</p><p></p><p>In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.</p><p></p></div><div id="course-pills-2"><h3>1 - Explore core data concepts</h3> <ul> <li>Identify data formats</li> <li>Explore file storage</li> <li>Explore databases</li> <li>Explore transactional data processing</li> <li>Explore analytical data processing</li> </ul> <h3>2 - Explore data roles and services</h3> <ul> <li>Explore job roles in the world of data</li> <li>Identify data services</li> </ul> <h3>3 - Explore fundamental relational data concepts</h3> <ul> <li>Understand relational data</li> <li>Understand normalization</li> <li>Explore SQL</li> <li>Describe database objects</li> </ul> <h3>4 - Explore relational database services in Azure</h3> <ul> <li>Describe Azure SQL services and capabilities</li> <li>Describe Azure services for open-source databases</li> </ul> <h3>5 - Explore Azure Storage for non-relational data</h3> <ul> <li>Explore Azure blob storage</li> <li>Explore Azure DataLake Storage Gen2</li> <li>Explore Azure Files</li> <li>Explore Azure Tables</li> </ul> <h3>6 - Explore fundamentals of Azure Cosmos DB</h3> <ul> <li>Describe Azure Cosmos DB</li> <li>Identify Azure Cosmos DB APIs</li> </ul> <h3>7 - Explore fundamentals of large-scale data warehousing</h3> <ul> <li>Describe data warehousing architecture</li> <li>Explore data ingestion pipelines</li> <li>Explore analytical data stores</li> </ul> <h3>8 - Explore fundamentals of real-time analytics</h3> <ul> <li>Understand batch and stream processing</li> <li>Explore common elements of stream processing architecture</li> <li>Explore Azure Stream Analytics</li> <li>Explore Apache Spark on Microsoft Azure</li> </ul> <h3>9 - Explore fundamentals of data visualization</h3> <ul> <li>Describe Power BI tools and workflow</li> <li>Describe core concepts of data modeling</li> <li>Describe considerations for data visualization</li> </ul></div>

Azure SQL Database

DP-900T00 Microsoft Azure Data Fundamentals

<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>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for Enterprise network staff responsible for help desk support, system administration, and network design.</p>Overview<p>At Course Completion: - Features and functions of Group Policy - Use Group Policy management tools to manage security policies - Design a Group Policy infrastructure - Group Policy processing architecture - Back up, restore, import, and copy Group Policy Objects through the Group Policy - Management Console - Use Windows PowerShell to manage Group Policy - Implement security using Group Policy - Configure the desktop environment with Group Policy - Configure roaming profiles and Folder Redirection - Assign and publish software packages - Implement AppLocker and software restriction policies - Create and deploy Administrative Templates - Configure Group Policy preferences</p><p>In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server 2016 and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks, implement administrative and security templates, and determine best practices when deploying software packages.</p></div><div id="course-pills-2"><h3>1 - Introduction to Configuration Management</h3> <ul> <li>Configuration Management Overview</li> <li>Configuration Management Using Group Policy</li> <li>Group Policy Features Introduced with Later Versions of Windows</li> <li>Using Windows PowerShell in the Configuration Management Process</li> </ul> <h3>2 - Using Group Policy Management Tools</h3> <ul> <li>Local and Domain Policies</li> <li>Using Group Policy Management Console</li> <li>Understanding Group Policy Refresh</li> </ul> <h3>3 - Designing a Group Policy Infrastructure</h3> <ul> <li>Design Stages for a Group Policy Infrastructure</li> <li>Planning your Group Policy Design</li> <li>Designing Your Group Policy Solution</li> <li>Deploying Your Group Policy Solution</li> <li>Managing Your Group Policy Solution</li> </ul> <h3>4 - Understanding the Architecture of Group Policy Processing</h3> <ul> <li>Group Policy Components in AD DS</li> <li>Understanding the Group Policy Deployment Order</li> <li>Modifying Group Policy Processing</li> </ul> <h3>5 - Troubleshooting and Backing Up GPOs</h3> <ul> <li>Using Group Policy Troubleshooting Tools</li> <li>Integration of RSoP Functionality</li> <li>Group Policy Logging Options</li> <li>Backing Up, Restoring, Importing, and Copying GPOs</li> <li>Building Migration Tables</li> </ul> <h3>6 - Securing Windows Using Group Policy</h3> <ul> <li>Exploring the Windows Security Architecture</li> <li>Securing User Accounts</li> <li>Exploring Security Policies</li> <li>Windows Firewall with Advanced Security</li> <li>Implementing Domain Security</li> <li>Security Policy Options for Window Client and Windows Server</li> </ul> <h3>7 - Implementing Application Security Using Group Policy</h3> <ul> <li>Managing UAC Settings</li> <li>Defending Against Malware</li> <li>Using AppLocker to Restrict Software</li> <li>Implementing Windows App Security Settings</li> </ul> <h3>8 - Configuring the Desktop Environment with Group Policy</h3> <ul> <li>Exploring Script Types and Controlling Script Execution</li> <li>Defining the Desktop, Start Menu, and Taskbar Settings</li> <li>Defining the Control Panel Settings</li> <li>Defining the Windows Components Settings</li> <li>Configuring the Printer Management and Pruning Settings</li> <li>Defining the Network Settings</li> <li>Discovering the new Group Policy Settings</li> </ul> <h3>9 - Implementing User State Virtualization</h3> <ul> <li>Configuring Folder Redirection</li> <li>Managing Offline Files</li> <li>Implementing User Experience Virtualization</li> <li>OneDrive for Business</li> </ul> <h3>10 - Assigning and Publishing Software Packages</h3> <ul> <li>Using MSI Packages to Distribute Software</li> <li>Using Group Policy as a Software Deployment Method</li> <li>Deploying Software</li> <li>Setting Up Distribution Points</li> <li>Using the Systems Center Configuration Manager to Distribute Software</li> </ul> <h3>11 - Configuration Management with Windows PowerShell</h3> <ul> <li>Introducing Windows PowerShell</li> <li>Using Windows PowerShell</li> <li>Writing PowerShell Scripts</li> <li>Windows PowerShell Library for Group Policy</li> <li>Windows PowerShell-Based Logon Scripts</li> </ul> <h3>12 - Implementing PowerShell Desired State Configuration</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configure Preference Settings</li> </ul> <h3>13 - Configuring Group Policy Preferences</h3> <ul> <li>Introducing Group Policy Preferences</li> <li>Comparing Preferences and Policy Settings</li> <li>Options for Applying Preferences</li> <li>Configuring Preferences Settings</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 50255 Managing Windows Environments with Group Policy 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 50255 Managing Windows Environments with Group Policy 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>

Professional Skills Course (PSC)

50255 Managing Windows Environments with Group Policy

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

Power Apps

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

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

Data Analyst

PL-300T00 Microsoft Power BI Data Analyst

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.</p><p></p><p></p><p>This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.</p><p></p>Prerequisites<p>To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.</p></div><div id="course-pills-2"><h3>1 - Explore Azure App Service</h3> <ul> <li>Examine Azure App Service</li> <li>Examine Azure App Service plans</li> <li>Deploy to App Service</li> <li>Explore authentication and authorization in App Service</li> <li>Discover App Service networking features</li> </ul> <h3>2 - Configure web app settings</h3> <ul> <li>Configure application settings</li> <li>Configure general settings</li> <li>Configure path mappings</li> <li>Enable diagnostic logging</li> <li>Configure security certificates</li> </ul> <h3>3 - Scale apps in Azure App Service</h3> <ul> <li>Examine autoscale factors</li> <li>Identify autoscale factors</li> <li>Enable autoscale in App Service</li> <li>Explore autoscale best practices</li> </ul> <h3>4 - Explore Azure App Service deployment slots</h3> <ul> <li>Explore staging environments</li> <li>Examine slot swapping</li> <li>Swap deployment slots</li> <li>Route traffic in App Service</li> </ul> <h3>5 - Explore Azure Functions</h3> <ul> <li>Discover Azure Functions</li> <li>Compare Azure Functions hosting options</li> <li>Scale Azure Functions</li> </ul> <h3>6 - Develop Azure Functions</h3> <ul> <li>Explore Azure Functions development</li> <li>Create triggers and bindings</li> <li>Connect functions to Azure services</li> </ul> <h3>7 - Explore Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage</li> <li>Discover Azure Blob storage resource types</li> <li>Explore Azure Storage security features</li> <li>Discover static website hosting in Azure Storage</li> </ul> <h3>8 - Manage the Azure Blob storage lifecycle</h3> <ul> <li>Explore the Azure Blob storage lifecycle</li> <li>Discover Blob storage lifecycle policies</li> <li>Implement Blob storage lifecycle policies</li> <li>Rehydrate blob data from the archive tier</li> </ul> <h3>9 - Work with Azure Blob storage</h3> <ul> <li>Explore Azure Blob storage client library</li> <li>Create a client object</li> <li>Manage container properties and metadata by using .NET</li> <li>Set and retrieve properties and metadata for blob resources by using REST</li> </ul> <h3>10 - Explore Azure Cosmos DB</h3> <ul> <li>Identify key benefits of Azure Cosmos DB</li> <li>Explore the resource hierarchy</li> <li>Explore consistency levels</li> <li>Choose the right consistency level</li> <li>Explore supported APIs</li> <li>Discover request units</li> </ul> <h3>11 - Work with Azure Cosmos DB</h3> <ul> <li>Explore Microsoft .NET SDK v3 for Azure Cosmos DB</li> <li>Create stored procedures</li> <li>Create triggers and user-defined functions</li> <li>Explore change feed in Azure Cosmos DB</li> </ul> <h3>12 - Manage container images in Azure Container Registry</h3> <ul> <li>Discover the Azure Container Registry</li> <li>Explore storage capabilities</li> <li>Build and manage containers with tasks</li> <li>Explore elements of a Dockerfile</li> </ul> <h3>13 - Run container images in Azure Container Instances</h3> <ul> <li>Explore Azure Container Instances</li> <li>Run containerized tasks with restart policies</li> <li>Set environment variables in container instances</li> <li>Mount an Azure file share in Azure Container Instances</li> </ul> <h3>14 - Implement Azure Container Apps</h3> <ul> <li>Explore Azure Container Apps</li> <li>Explore containers in Azure Container Apps</li> <li>Implement authentication and authorization in Azure Container Apps</li> <li>Manage revisions and secrets in Azure Container Apps</li> <li>Explore Dapr integration with Azure Container Apps</li> </ul> <h3>15 - Explore the Microsoft identity platform</h3> <ul> <li>Explore the Microsoft identity platform</li> <li>Explore service principals</li> <li>Discover permissions and consent</li> <li>Discover conditional access</li> </ul> <h3>16 - Implement authentication by using the Microsoft Authentication Library</h3> <ul> <li>Explore the Microsoft Authentication Library</li> <li>Initialize client applications</li> </ul> <h3>17 - Implement shared access signatures</h3> <ul> <li>Discover shared access signatures</li> <li>Choose when to use shared access signatures</li> <li>Explore stored access policies</li> </ul> <h3>18 - Explore Microsoft Graph</h3> <ul> <li>Discover Microsoft Graph</li> <li>Query Microsoft Graph by using REST</li> <li>Query Microsoft Graph by using SDKs</li> <li>Apply best practices to Microsoft Graph</li> </ul> <h3>19 - Implement Azure Key Vault</h3> <ul> <li>Explore Azure Key Vault</li> <li>Discover Azure Key Vault best practices</li> <li>Authenticate to Azure Key Vault</li> </ul> <h3>20 - Implement managed identities</h3> <ul> <li>Explore managed identities</li> <li>Discover the managed identities authentication flow</li> <li>Configure managed identities</li> <li>Acquire an access token</li> </ul> <h3>21 - Implement Azure App Configuration</h3> <ul> <li>Explore the Azure App Configuration service</li> <li>Create paired keys and values</li> <li>Manage application features</li> <li>Secure app configuration data</li> </ul> <h3>22 - Explore API Management</h3> <ul> <li>Discover the API Management service</li> <li>Explore API gateways</li> <li>Explore API Management policies</li> <li>Create advanced policies</li> <li>Secure APIs by using subscriptions</li> <li>Secure APIs by using certificates</li> </ul> <h3>23 - Explore Azure Event Grid</h3> <ul> <li>Explore Azure Event Grid</li> <li>Discover event schemas</li> <li>Explore event delivery durability</li> <li>Control access to events</li> <li>Receive events by using webhooks</li> <li>Filter events</li> </ul> <h3>24 - Explore Azure Event Hubs</h3> <ul> <li>Discover Azure Event Hubs</li> <li>Explore Event Hubs Capture</li> <li>Scale your processing application</li> <li>Control access to events</li> <li>Perform common operations with the Event Hubs client library</li> </ul> <h3>25 - Discover Azure message queues</h3> <ul> <li>Choose a message queue solution</li> <li>Explore Azure Service Bus</li> <li>Discover Service Bus queues, topics, and subscriptions</li> <li>Explore Service Bus message payloads and serialization</li> <li>Explore Azure Queue Storage</li> <li>Create and manage Azure Queue Storage and messages by using .NET</li> </ul> <h3>26 - Monitor app performance</h3> <ul> <li>Explore Application Insights</li> <li>Discover log-based metrics</li> <li>Instrument an app for monitoring</li> <li>Select an availability test</li> <li>Troubleshoot app performance by using Application Map</li> </ul> <h3>27 - Develop for Azure Cache for Redis</h3> <ul> <li>Explore Azure Cache for Redis</li> <li>Configure Azure Cache for Redis</li> <li>Interact with Azure Cache for Redis by using .NET</li> </ul> <h3>28 - Develop for storage on CDNs</h3> <ul> <li>Explore Azure Content Delivery Networks</li> <li>Control cache behavior on Azure Content Delivery Networks</li> <li>Interact with Azure Content Delivery Networks by using .NET</li> </ul></div>

AWS Certified Solutions Architect

AZ-204T00 Developing Solutions for Microsoft Azure

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p><p>This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and Windows Autopilot as well as Azure Active Directory Conditional Access and Identity Protection. The delegates will learn how to enroll devices, deploy applications and manage them to maximize user productivity and device security.</p></div><div id="course-pills-2"><h3>1: Introduction to Microsoft Intune</h3> <ul> <li> Mobile Device Management</li> <li>Microsoft Intune</li> <li> Azure Active Directory</li> <li>AAD Identity Protection</li> <li> AAD Conditional Access</li></ul>  <h3>2: Microsoft Intune Device Management</h3><ul> <li>Enrolling Devices</li> <li> Device Compliance</li> <li> Device Profiles</li> <li>Device Updates</li></ul>  <h3>3: Microsoft Intune Application Management</h3><ul> <li> Application Management</li> <li> Deploying Applications</li> <li> Application Configuration</li> <li> Managing Applications</li> <li> Policy Sets and Guided Scenarios</li></ul>  <h3>4: Microsoft Intune Endpoint Security</h3><ul> <li> Security Baselines and tasks</li> <li> Antivirus</li> <li>Disk Encryption</li> <li>Firewall</li> <li>Atack Surface reduction</li> <li> Endpoint detection and response</li> <li> Account Protection</li></ul>  <h3>5: Deploying Windows with Windows Autopilot</h3><ul> <li> Windows Autopilot overview</li> <li> Preparing for Windows Autopilot deployment</li> <li>Deploying Windows 11 using Windows Autopilot</li></ul>  <h3>6: Microsoft Intune Additional and Premium Features</h3><ul> <li> Remote Help</li> <li> Tunnel for Mobile Application Management</li> <li>Endpoint Privilege Management</li> <li> Advanced Endpoint Analytics</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55399 Implementing and Managing Microsoft Intune 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 55399 Implementing and Managing Microsoft Intune 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>

3376 Courses delivered Online

iMovie Essentials

By Nexus Human

MB-340T00: Microsoft Dynamics 365 Commerce Functional Consultant

By Nexus Human

Microsoft Project

By Nexus Human

Introduction to C Plus Plus Programming Essentials (TTCP2100)

By Nexus Human

Comprehensive PostgreSQL Administration

By Nexus Human

Microsoft Power BI Reports and Dashboards for Business Users

By Nexus Human

Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3)

By Nexus Human

Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3)

By Nexus Human

MS Project (Part 2) - Project Validation, Baseline and Tracking using Microsoft Project

By Nexus Human

Microsoft Intune Overview

By Nexus Human