4 Microsoft Power Platform courses in Edinburgh
Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
Power BI® - Business Data Analytics
By Asia Edge
ABOUT THIS TRAINING COURSE This 3 full-day training course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data. The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they've learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn't be able to do what they need to do. This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries. Training Objectives Upon completion of this training course, participants will be able to: * Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway * Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis * Combine data sources together and gain an introductory understanding of the M language * Write formulas using the DAX language for generating custom columns, measures and tables * Design reports and dashboards using a wide range of both built-in and custom visuals * Publish reports and dashboards to PowerBI®.com * Share reports and dashboards with others using PowerBI®.com * Customize reports and dashboards so that different user groups automatically see their own personalized views Target Audience This training course is intended for: * Financial Analysts * Accountants * Budgeting and planning specialists * Treasury * Risk Managers * Strategic Planners This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Course Level * Basic or Foundation Trainer Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years' experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings. He has trained delegates from a wide variety of Oil & Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions. Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm. He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. Highlights from his oil and gas experience include: * Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets. * Auditing and further development of life of project models for Chevron's Strategic Planning Division analysing their North West Shelf assets. * Development of business plan and budgeting models for multinational oil & gas assets. * Development of cash flow and taxation models for a variety of oil gas companies. * Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
Power BI - introduction (2 day) (In-House)
By The In House Training Company
There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 GETTING STARTED * The Power BI ecosystem * Opening Power BI Desktop * Power BI's four views * Introduction to Dashboards 2 IMPORTING FILES * Importing data sources * Importing an Excel file * Importing a CSV file * Importing a database * Connect to an SQL Server Database * Import vs. Direct Query * Importing from the web * Importing a folder of files * Managing file connections 3 SHAPE DATA IN THE QUERY EDITOR * The process of shaping data * Managing data types * Keeping and removing rows * Add a custom column * Appending tables together * Hiding queries in reports * Fixing error issues * Basic maths operations 4 THE DATA MODEL * Table relationships * Relationship properties 5 MERGE QUERIES * Table join kinds * Merging tables 6 INSERTING DASHBOARD VISUALS * Things to keep in mind * Inserting maps * Formatting Maps * Inserting charts * Formatting Charts * Inserting a tree map * Inserting a table, matrix, and card * Controlling number formats * About report themes * Highlighting key points * Filter reports with slicers * Sync slicers across dashboards * Custom web visuals 7 PUBLISH AND SHARE REPORTS * Publishing to Power BI service * Editing online reports * Pinning visuals to a dashboard * What is Q&A? * Sharing dashboards * Exporting reports to PowerPoint * Exporting reports as PDF files 8 THE POWER QUERY EDITOR * Fill data up and down * Split column by delimiter * Add a conditional column * More custom columns * Merging columns 9 THE M FUNCTIONS * Inserting text functions * Insert an IF function * Create a query group 10 PIVOTING TABLES * Pivot a table * Pivot and append tables * Pivot but don't aggregate * Unpivot tables * Append mismatched headers 11 DATA MODELLING EXPANDED * Understanding relationships * Mark a date table 12 DAX NEW COLUMNS * New columns and measures * New column calculations * Insert a SWITCH function 13 INTRODUCTION TO DAX MEASURES * Common measure functions * Insert a SUM function * Insert a COUNTROWS function * Insert a DISTINCTCOUNT function * Insert a DIVIDE function * DAX rules 14 THE CALCULATE MEASURE * The syntax of CALCULATE * Insert a CALCULATE function * Control field summarisation * Things of note 15 THE SUMX MEASURE * X iterator functions * Anatomy of SUMX * Insert a SUMX function * When to use X functions 16 TIME INTELLIGENCE MEASURES * Importance of a calendar table * Insert a TOTALYTD function * Change financial year end date * Comparing historical data * Insert a DATEADD function 17 HIERARCHIES AND GROUPS * Mine data using hierarchies * Compare data in groups
Power BI - intermediate (2 day) (In-House)
By The In House Training Company
This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 THE QUERY EDITOR * Grouping rows in a table * Split row by delimiter * Add days to determine deadlines * The query editor 2 FUZZY MATCHING JOINS * Matching inconsistencies by percentage * Matching with transformation table 3 THE QUERY EDITOR M FUNCTIONS * Adding custom columns * Creating an IF function * Nested AND logics in an IF function 4 DAX NEW COLUMNS FUNCTIONS * Including TRUE with SWITCH * Using multiple conditions * The FIND DAX function * The IF DAX function * Logical functions IF, AND, OR 5 EDITING DAX MEASURES * Making DAX easier to read * Add comments to a measure * Using quick measures 6 THE ANATOMY OF CALCULATE * Understanding CALCULATE filters * Add context to CALCULATE with FILTER * Using CALCULATE with a threshold 7 THE ALL MEASURE * Anatomy of ALL * Create an ALL measure * Using ALL as a filter * Use ALL for percentages 8 DAX ITERATORS * Anatomy of iterators * A closer look at SUMX * Using RELATED with SUMX * Create a RANKX * RANKX with ALL 9 DATE AND TIME FUNCTIONS * Overview of functions * Create a DATEDIFF function 10 TIME INTELLIGENT MEASURES * Compare historical monthly data * Create a DATEADD measure * Creating cumulative totals * Creating cumulative measures * Visualising cumulative totals 11 VISUALISATIONS IN-DEPTH * Utilising report themes * Applying static filters * Group data using lists * Group numbers using bins * Creating heatmaps * Comparing proportions * View trends with sparklines 12 COMPARING VARIABLES * Visualising trendlines as KPI * Forecasting with trendlines * Creating a scatter plot * Creating dynamic labels * Customised visualisation tooltips * Export reports to SharePoint
Power BI - advanced (1 day) (In-House)
By The In House Training Company
This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 THE QUERY EDITOR * Split by row delimiter * AddDays to determine deadlines * Advanced query editor 2 FUZZY MATCHING JOINS * Matching inconsistencies by percentage * Matching with transformation table 3 LOGICAL COLUMN FUNCTIONS * Logical functions IF, AND, OR * Using multiple conditions * Including FIND in functions 4 EDITING DAX MEASURES * Make DAX easier to read * Add comments to a measure * Using quick measures 5 THE ANATOMY OF CALCULATE * Understanding CALCULATE context filters * Adding context to CALCULATE with FILTER * Using CALCULATE with a threshold 6 THE ALL MEASURE * Anatomy of ALL * Create an ALL measure * Using ALL as a filter * Use ALL for percentage 7 DAX ITERATORS * Anatomy of iterators * A closer look at SUMX * Using RELATED in SUMX * Create a RANKX * RANKX with ALL 8 DATE AND TIME FUNCTIONS * Overview of functions * Create a DATEDIFF function 9 TIME INTELLIGENT MEASURES * Compare historical monthly data * Create a DATEADD measure * Creating cumulative totals * Creating cumulative measures * Visualising cumulative totals 10 VISUALISATIONS IN-DEPTH * Utilising report themes * Create a heatmap * Comparing proportions * View trends with sparklines * Group numbers using bins * Setting up a histogram 11 COMPARING VARIABLES * Visualising trendlines as KPI * Forecasting with trendlines * Creating a scatter plot * Creating dynamic labels * Customised visualisation tooltips * Export reports to SharePoint 12 USER LEVEL SECURITY * Setting up row level security * Testing user security
Online Options
Show all 267PL-300T00 Microsoft Power BI Data Analyst
By Nexus Human
Duration 3 Days 18 CPD hours This course is intended for 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. 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. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - DISCOVER DATA ANALYSIS * Overview of data analysis * Roles in data * Tasks of a data analyst 2 - GET STARTED BUILDING WITH POWER BI * Use Power BI * Building blocks of Power BI * Tour and use the Power BI service 3 - GET DATA IN POWER BI * Get data from files * Get data from relational data sources * Create dynamic reports with parameters * Get data from a NoSQL database * Get data from online services * Select a storage mode * Get data from Azure Analysis Services * Fix performance issues * Resolve data import errors 4 - CLEAN, TRANSFORM, AND LOAD DATA IN POWER BI * Shape the initial data * Simplify the data structure * Evaluate and change column data types * Combine multiple tables into a single table * Profile data in Power BI * Use Advanced Editor to modify M code 5 - DESIGN A SEMANTIC MODEL IN POWER BI * Work with tables * Create a date table * Work with dimensions * Define data granularity * Work with relationships and cardinality * Resolve modeling challenges 6 - ADD MEASURES TO POWER BI DESKTOP MODELS * Create simple measures * Create compound measures * Create quick measures * Compare calculated columns with measures 7 - ADD CALCULATED TABLES AND COLUMNS TO POWER BI DESKTOP MODELS * Create calculated columns * Learn about row context * Choose a technique to add a column 8 - USE DAX TIME INTELLIGENCE FUNCTIONS IN POWER BI DESKTOP MODELS * Use DAX time intelligence functions * Additional time intelligence calculations 9 - OPTIMIZE A MODEL FOR PERFORMANCE IN POWER BI * Review performance of measures, relationships, and visuals * Use variables to improve performance and troubleshooting * Reduce cardinality * Optimize DirectQuery models with table level storage * Create and manage aggregations 10 - DESIGN POWER BI REPORTS * Design the analytical report layout * Design visually appealing reports * Report objects * Select report visuals * Select report visuals to suit the report layout * Format and configure visualizations * Work with key performance indicators 11 - CONFIGURE POWER BI REPORT FILTERS * Apply filters to the report structure * Apply filters with slicers * Design reports with advanced filtering techniques * Consumption-time filtering * Select report filter techniques * Case study - Configure report filters based on feedback 12 - ENHANCE POWER BI REPORT DESIGNS FOR THE USER EXPERIENCE * Design reports to show details * Design reports to highlight values * Design reports that behave like apps * Work with bookmarks * Design reports for navigation * Work with visual headers * Design reports with built-in assistance * Tune report performance * Optimize reports for mobile use 13 - PERFORM ANALYTICS IN POWER BI * Explore statistical summary * Identify outliers with Power BI visuals * Group and bin data for analysis * Apply clustering techniques * Conduct time series analysis * Use the Analyze feature * Create what-if parameters * Use specialized visuals 14 - CREATE AND MANAGE WORKSPACES IN POWER BI * Distribute a report or dashboard * Monitor usage and performance * Recommend a development life cycle strategy * Troubleshoot data by viewing its lineage * Configure data protection 15 - MANAGE SEMANTIC MODELS IN POWER BI * Use a Power BI gateway to connect to on-premises data sources * Configure a semantic model scheduled refresh * Configure incremental refresh settings * Manage and promote semantic models * Troubleshoot service connectivity * Boost performance with query caching (Premium) 16 - CREATE DASHBOARDS IN POWER BI * Configure data alerts * Explore data by asking questions * Review Quick insights * Add a dashboard theme * Pin a live report page to a dashboard * Configure a real-time dashboard * Set mobile view 17 - IMPLEMENT ROW-LEVEL SECURITY * Configure row-level security with the static method * Configure row-level security with the dynamic method ADDITIONAL COURSE DETAILS: 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. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. 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. 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.
SharePoint - Site Basics (Modern Experience)
By Nexus Human
Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. LESSON 1: NAVIGATING SHAREPOINT SITES * Topic A: Launch SharePoint * Topic B: Gain Access to a Site You Didn't Create * Topic C: Navigate Within a SharePoint Site * Topic D: Access SharePoint from Your Mobile Device LESSON 2: USING LISTS TO TRACK INFORMATION * Topic A: Add and Populate Lists * Topic B: Change View Options * Topic C: Create a Custom View LESSON 3: USING DOCUMENT LIBRARIES TO SHARE AND ORGANIZE DOCUMENTS * Topic A: Store Files in a Document Library * Topic B: Create and Use Document Templates LESSON 4: FINDING, SHARING, AND ARCHIVING CONTENT * Topic A: Search for Items in Lists or Libraries * Topic B: Share Through Links * Topic C: Move Files Offline LESSON 5: AUTHORING DOCUMENTS AS A TEAM * Topic A: Work Together on Documents * Topic B: Manage File Versions and Document Recovery LESSON 6: AUTOMATING BUSINESS PROCESSES * Topic A: Use Rule-Based Automation * Topic B: Use Power Automate to Automate a Workflow
PL-400T00 Microsoft Power Platform Developer
By Nexus Human
Duration 5 Days 30 CPD hours This course is intended for 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. Overview After completing this course, students will be able to: Create a technical design Configure Common Data Service Create and configure Power Apps Configure business process automation Extend the user experience Extend the platform Develop Integrations 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. CREATE A MODEL-DRIVEN APPLICATION IN POWER APPS * This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service. GET STARTED USING COMMON DATA SERVICE * This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed. CREATE A CANVAS APP IN POWER APPS * 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. AUTOMATE A BUSINESS PROCESS USING POWER AUTOMATE * This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows. CREATE A BUSINESS PROCESS FLOW IN POWER AUTOMATE * This module introduces you to creating business process flows in Power Automate INTRODUCTION TO DEVELOPING WITH POWER PLATFORM * This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform EXTENDING THE POWER PLATFORM USER EXPERIENCE MODEL DRIVEN APPS * 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. CREATE COMPONENTS WITH POWER APPS COMPONENT FRAMEWORK * 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. EXTENDING THE POWER PLATFORM COMMON DATA SERVICE * 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. INTEGRATE WITH POWER PLATFORM AND COMMON DATA SERVICE * 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. EXTEND POWER APPS PORTALS * 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. ADDITIONAL COURSE DETAILS: 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. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. 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. 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.
PL-900T00 Microsoft Power Platform Fundamentals
By Nexus Human
Duration 1 Days 6 CPD hours This course is intended for Candidates for this exam are users who aspire to improve productivity by automating business processes, analyzing data to produce business insights, and acting more effectively by creating simple app experiences. Overview After completing this course, you will be able to: Describe Microsoft Power Platform components Describe Microsoft Dataverse and connectors Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services Identify benefits and capabilities of Microsoft Power Platform Identify the basic functionality and business value Microsoft Power Platform components Implement simple solutions with Power Apps, Power Automate, and Power BI Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate. MODULE 1: INTRODUCTION TO MICROSOFT POWER PLATFORM * Identify when to use each Microsoft Power Platform component application to create business solution * Learn the value of using Microsoft Power Platform to create business solutions * Learn the components and features of Microsoft Power Platform MODULE 2: INTRODUCTION TO MICROSOFT DATAVERSE * Microsoft Dataverse Overview MODULE 3: GET STARTED WITH POWER APPS * Introduction to Power Apps * How to build a canvas app * How to build a model-driven app MODULE 4: GET STARTED WITH POWER AUTOMATE * Power Automate Overview * How to Build an Automated Solution MODULE 5: GET STARTED WITH POWER BI * Power BI Overview * How to Build a Simple Dashboard MODULE 6: INTRODUCTION TO POWER VIRTUAL AGENTS * Power Virtual Agents overview ADDITIONAL COURSE DETAILS: Nexus Humans PL-900T00 Microsoft Power Platform Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the PL-900T00 Microsoft Power Platform Fundamentals 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. 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.
PL-200T00 Microsoft Power Platform Functional Consultant
By Nexus Human
Duration 5 Days 30 CPD hours This course is intended for A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows. Prerequisites * Experience as an IT professional or student * Working knowledge of Microsoft Power Platform and its key components * Knowledge of Microsoft Dataverse (or general data modeling) and security concepts 1 - DESCRIBE THE BUSINESS VALUE OF THE MICROSOFT POWER PLATFORM * Explore Microsoft Power Platform * Describe the business value of the Power Platform * Explore connectors and Microsoft Dataverse * Describe how Power Platform works with Microsoft 365 apps and services * Explore how Power Platform works with Microsoft Teams * Describe how Power Platform works with Microsoft Dynamics 365 apps * Describe how Power Platform solutions consume Microsoft Azure services * Explore how Microsoft Power Platform apps work together * Use Artificial Intelligence to increase productivity 2 - CORE COMPONENTS OF POWER PAGES * Get started with Power Pages * Core tools and components of Power Pages * Overview of Power Pages security * Overview of Power Pages extensibility 3 - EXPLORE POWER PAGES TEMPLATES * Site design templates * Scenario-based templates * Dynamics 365 Power Pages site templates 4 - EXPLORE POWER PAGES DESIGN STUDIO * Work with pages * Page components * Site styling and templates 5 - EXPLORE POWER PAGES DESIGN STUDIO DATA AND SECURITY FEATURES * Data workspace in Power Pages design studio * Power Pages security features 6 - INTRODUCTION TO POWER PAGES ADMINISTRATION * Power Pages administrative tools * Set up workspace in Power Pages design studio 7 - GET STARTED BUILDING WITH POWER BI * Use Power BI * Building blocks of Power BI * Tour and use the Power BI service 8 - GET DATA WITH POWER BI DESKTOP * Overview of Power BI Desktop * Explore Power BI Desktop * Connect to data sources * Get data from Excel * Transform data to include in a report * Combine data from multiple sources * Clean data to include in a report 9 - MODEL DATA IN POWER BI * How to manage your data relationships * Create calculated columns * Optimize data models * Create measures * Create calculated tables * Explore time-based data 10 - USE VISUALS IN POWER BI * Create and customize simple visualizations * Create slicers * Map visualizations * Matrices and tables * Create scatter, waterfall, and funnel charts * Modify colors in charts and visuals * Page layout and formatting 11 - EXPLORE DATA IN POWER BI * Quick insights in Power BI * Create and configure a dashboard * Ask questions of your data with natural language * Create custom Q&A suggestions * Share dashboards with your organization * Display visuals and tiles in full screen * Edit tile details and add widgets * Get more space on your dashboard 12 - PUBLISH AND SHARE IN POWER BI * Publish Power BI Desktop reports * Print and export dashboards and reports * Introducing Power BI Mobile * Create workspaces in Power BI * Build apps * Use apps * Integrate OneDrive for Business with Power BI * Publish to web 13 - CREATE AND MANAGE WORKSPACES IN POWER BI * Distribute a report or dashboard * Monitor usage and performance * Recommend a development life cycle strategy * Troubleshoot data by viewing its lineage * Configure data protection 14 - MANAGE SEMANTIC MODELS IN POWER BI * Use a Power BI gateway to connect to on-premises data sources * Configure a semantic model scheduled refresh * Configure incremental refresh settings * Manage and promote semantic models * Troubleshoot service connectivity * Boost performance with query caching (Premium) 15 - CREATE DASHBOARDS IN POWER BI * Configure data alerts * Explore data by asking questions * Review Quick insights * Add a dashboard theme * Pin a live report page to a dashboard * Configure a real-time dashboard * Set mobile view 16 - IMPLEMENT ROW-LEVEL SECURITY * Configure row-level security with the static method * Configure row-level security with the dynamic method 17 - CREATE TABLES IN DATAVERSE * Table characteristics * Table relationships * Dataverse logic and security * Dataverse auditing * Dual-write vs. virtual tables 18 - MANAGE TABLES IN DATAVERSE * Identify tables and table types in Dataverse * Create a custom table * Enable attachments within a table * Licensing requirements for each table type 19 - CREATE AND MANAGE COLUMNS WITHIN A TABLE IN DATAVERSE * Define columns in Microsoft Dataverse * Column types in Microsoft Dataverse * Add a column to a table * Create a primary name column * Restrictions that apply to columns in a table * Create an auto numbering column * Create an alternate key 20 - CREATE A RELATIONSHIP BETWEEN TABLES IN DATAVERSE * Relate one or more tables - Introduction * Relationship types that are available in Microsoft Dataverse * Create a one-to-many relationship between tables * Create a many-to-many relationship between tables * Edit or delete relationships 21 - WORKING WITH CHOICES IN DATAVERSE * Define choice column * Standard choices column 22 - GET STARTED WITH SECURITY ROLES IN DATAVERSE * Understand environment roles * Adding or disabling an environment user * Understand security concepts in Dataverse * Understand user security roles and security role defaults * Check the roles that a user belongs to * Configure Dataverse teams for security * Configure Dataverse group teams for security 23 - USE ADMINISTRATION OPTIONS FOR DATAVERSE * Use Microsoft Power Platform Admin Center portal * Tenant storage capacity * Advanced Customization options in Power Apps Portal * Enable and disable auditing 24 - MANAGE DYNAMICS 365 MODEL-DRIVEN APP SETTINGS AND SECURITY * Configure role-based security * Manage teams and business units * Explore settings and customizations 25 - INTRODUCTION TO MICROSOFT POWER PLATFORM SECURITY AND GOVERNANCE * Identify Microsoft Power Platform environments * Data Loss Prevention policies * Microsoft Power Platform Center of Excellence Starter Kit 26 - GET STARTED WITH MODEL-DRIVEN APPS IN POWER APPS * Introducing model-driven apps * Components of model-driven apps * Design model-driven apps * Incorporate business process flows 27 - CONFIGURE FORMS, CHARTS, AND DASHBOARDS IN MODEL-DRIVEN APPS * Forms overview * Form elements * Configure multiple forms * Use specialized form components * Configure views overview * Configure grids * Create and edit views * Configure charts overview * Dashboards overview * Use interactive streams and tiles 28 - GET STARTED WITH POWER APPS CANVAS APPS * Power Apps building blocks * Ways to build Power Apps * Power Apps related technologies * Additional Power Apps related technologies * Designing a Power Apps app 29 - CONNECT TO OTHER DATA IN A POWER APPS CANVAS APP * Overview of the different data sources * Work with action-based data sources * Power Automate is a companion to Power Apps 30 - HOW TO BUILD THE UI IN A CANVAS APP IN POWER APPS * Use themes to quickly change the appearance of your app * Branding a control * Icons * Images * Personalization * Using the tablet or phone form factors 31 - MANAGE APPS IN POWER APPS * Power Apps review 32 - BUILD YOUR FIRST APP WITH POWER APPS AND DATAVERSE FOR TEAMS * Create your first app with the hero template * Customize your app with Power Apps Studio * Publish your app * Install template apps 33 - ACCESS DATAVERSE IN POWER PAGES WEBSITES * Use lists to display multiple Dataverse records * Use forms to interact with Dataverse data 34 - AUTHENTICATION AND USER MANAGEMENT IN POWER PAGES * Power Pages authentication settings * User registration in Power Pages * Authentication management for Power Pages users * Power Pages authentication providers 35 - POWER PAGES MAINTENANCE AND TROUBLESHOOTING * Power Pages website maintenance * Power Pages website troubleshooting 36 - DEFINE AND CREATE BUSINESS RULES IN DATAVERSE * Define business rules - Introduction * Define the components of a business rule * Create a business rule 37 - GET STARTED WITH POWER AUTOMATE * Introducing Power Automate * Troubleshoot flows 38 - USE THE ADMIN CENTER TO MANAGE ENVIRONMENTS AND DATA POLICIES IN POWER AUTOMATE * Administer flows * Export and import flows * Learn how to distribute button flows 39 - USE DATAVERSE TRIGGERS AND ACTIONS IN POWER AUTOMATE * Dataverse triggers * Query data * Create, update, delete, and relate actions 40 - EXTEND DATAVERSE WITH POWER AUTOMATE * Set up a flow and configure its trigger * Email Dataverse record * Add to-do items * Test and run your flow 41 - INTRODUCTION TO EXPRESSIONS IN POWER AUTOMATE * Get started with expressions * Notes make things easier * Types of functions * Write complex expressions 42 - BUILD YOUR FIRST POWER AUTOMATE FOR DESKTOP FLOW * Set up the environment * Explore Power Automate for desktop * Create your first Power Automate for desktop flow * Record Power Automate for desktop actions * Edit and test recorded actions 43 - RUN A POWER AUTOMATE FOR DESKTOP FLOW IN UNATTENDED MODE * Set up an unattended desktop flow * Create a new cloud flow that calls an existing flow in unattended mode * Perform a test run * Best practices 44 - OPTIMIZE YOUR BUSINESS PROCESS WITH PROCESS ADVISOR * Get familiar with process advisor * Create your first recording * Edit recordings and group actions * Analyze recordings and interpret results * Automation recommendations 45 - GET STARTED WITH MICROSOFT COPILOT STUDIO BOTS * Get started working with environments * Create bots and work with the Microsoft Copilot Studio interface * Create topics * Test bots * Publish bots and analyze performance 46 - ENHANCE MICROSOFT COPILOT STUDIO BOTS * Use Power Automate to add actions * Transfer conversations to agents by using Omnichannel for Customer Service * Create topics for existing support content * Analyze bot performance 47 - MANAGE TOPICS IN MICROSOFT COPILOT STUDIO * Work with bot topics * Branch a topic * Create topics for existing support content * Work with system fallback topics * Manage topics 48 - MANAGE POWER VIRTUAL AGENTS * Environments in Microsoft Copilot Studio * Bot topics permissions * Bot entities and flow permissions * Monitor and diagnose * Administer and manage * Export and import bots * Authentication 49 - GET STARTED BUILDING WITH POWER BI * Use Power BI * Building blocks of Power BI * Tour and use the Power BI service 50 - GET DATA WITH POWER BI DESKTOP * Overview of Power BI Desktop * Explore Power BI Desktop * Connect to data sources * Get data from Excel * Transform data to include in a report * Combine data from multiple sources * Clean data to include in a report 51 - MODEL DATA IN POWER BI * How to manage your data relationships * Create calculated columns * Optimize data models * Create measures * Create calculated tables * Explore time-based data 52 - USE VISUALS IN POWER BI * Create and customize simple visualizations * Create slicers * Map visualizations * Matrices and tables * Create scatter, waterfall, and funnel charts * Modify colors in charts and visuals * Page layout and formatting 53 - EXPLORE DATA IN POWER BI * Quick insights in Power BI * Create and configure a dashboard * Ask questions of your data with natural language * Create custom Q&A suggestions * Share dashboards with your organization * Display visuals and tiles in full screen * Edit tile details and add widgets * Get more space on your dashboard 54 - PUBLISH AND SHARE IN POWER BI * Publish Power BI Desktop reports * Print and export dashboards and reports * Introducing Power BI Mobile * Create workspaces in Power BI * Build apps * Use apps * Integrate OneDrive for Business with Power BI * Publish to web 55 - MANAGE SOLUTIONS IN POWER APPS AND POWER AUTOMATE * Add and remove apps, flows, and entities in a solution * Edit a solution-aware app, flow, and table * Build and deploy a complex solution with flows, apps, and entities * Automate solution management 56 - LOAD/EXPORT DATA AND CREATE DATA VIEWS IN DATAVERSE * View data in a table * Create or edit views of data in a table * Load data into a table * Export data from a table * Add, update, or delete data in a table by using Excel * Import data using Power Query * Generate a new dataflow from an Excel Template * Dataflow and Azure integration 57 - GET STARTED WITH AI BUILDER * Choose an AI capability * Create your first model * Ways to use your models 58 - MANAGE MODELS IN AI BUILDER * Model lifecycle * Manage model versions * Share your models 59 - USE AI BUILDER IN POWER AUTOMATE * AI Builder in Power Automate saves time * Advanced usage of AI Builder in Power Automate 60 - FUNCTIONAL CONSULTANT SKILLS * Create entity relationship diagrams * Create and document mock-ups * Document functional requirements and artifacts * Complete fit-gap analysis * Discuss stakeholder management responsibilities * Understand industry accelerators * Define Application Lifecycle Management * Participate in testing * Evaluate options * Define connectors * Understand Power Apps component framework 61 - SOLUTION ARCHITECT SERIES: PLAN APPLICATION LIFECYCLE MANAGEMENT FOR POWER PLATFORM * Key considerations for ALM * Solutions * Configuration and reference data * Release process * ALM with Azure DevOps
55268 Microsoft Power Automate for End Users
By Nexus Human
Duration 1 Days 6 CPD hours This course is intended for The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones. Overview #NAME? This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates. 1 - AN INTRODUCTION TO POWER AUTOMATE * What is Microsoft Power Automate? * The benefits of automation * How to get to Power Automate * Lab 1: Setup your tenant * Setup Office 365 * Download Course Files * Customise your App Launcher * Create accounts for colleagues * After completing this module, students will be able to: * Know what Microsoft Power Automate is * The Benefits of using Power Automate to automate processes * How to access a Power Automate 2 - GETTING STARTED WITH POWER AUTOMATE * Using Power Automate templates * Navigating in Power Automate * Editing a Power Automate * Publish and trigger a Power Automate * Turn off or delete a Power Automate * Lab 1: Building processes in Office 365 * Create a Team with a channel * Build an absence business process * Testing the absence process * Optional: Create Feedback Form * Optional: Power Automate to Notify of Bad Ratings * Optional: Test your Form and Power Automate * After completing this module, students will be able to: * How to use Power Automate tempaltes * How to navigate around Power Automate * How to edit Power Automates * How to publish and trigger Power Automates * How to turn off or delete Power Automates 3 - POWER AUTOMATE LOGIC * Adding conditions * Designing switches * Using apply to each * Configuring do until logic * Adding a scope * Lab 1: Scheduling documentation reviews * Setup a policy library in SharePoint * Design a policy review schedule * Testing the policy review process * Optional: Notify if a file nears review * After completing this module, students will be able to: * How to add condtions in a Power Automate * How to design switches for a Power Automate * How to use apply to each * How to configure do until logic * How to add a scope 4 - INTEGRATION * Standard and premium connectors * Connecting to web services * Using Power Automate with on-premises data * Lab 1: Using Power Automate and SQL to Review Sales * Create a new orders list * Designing the price check process * Testing the price check process * Optional: Update with managers * After completing this module, students will be able to: * How to use Standard and Premium connectors * How to connect to web services * How to using Power Automate with on-premises data 5 - THE MOBILE APP * Downloading the mobile app * Signing in and account management * Building and managing Power Automates * Creating buttons * Feeds and approvals * Lab 1: Optional: Using the Power Automate mobile app * Setting up the Power Automate mobile app * Create a new Power Automate in the mobile app * Using Power Automate buttons in the app * Uninstall the Power Automate mobile app * After completing this module, students will be able to: * How to download the mobile app * How to sign into the mobile app * How to build and manage Power Automates in the mobile app * How to create buttons in the mobile app * How to feed and use approvals in the mobile app 6 - ADMINISTRATION AND MAINTENANCE * Maintaining a Power Automate * View history and analytics * Sharing a Power Automate * Export and import Power Automates * Office 365 administration for Power Automate * Environments * Data policies * Data integration * Lab 1: Maintaining your Power Automates * Share a Power Automate with a colleague * Disabling an active Power Automate * Deleting a Power Automate * After completing this module, students will be able to: * How to maintain a Power Automate * How to view history and analytics for a Power Automate * How to share a Power Automate * How to export and import Power Automates * How to administrate a Power Automate in Office 365 * How to use data policies in a Power Automate * How to use data integration in a Power Automate
PL-500T00 Microsoft Power Automate RPA Developer
By Nexus Human
Duration 4 Days 24 CPD hours This course is intended for If you're a developer with a keen interest in providing automated solutions for your organization, this certification could be a great fit for you. You automate time-consuming and repetitive tasks by using Microsoft Power Automate. You review solution requirements, create process documentation, and design, develop, deploy, integrate, troubleshoot, and evaluate solutions. Working with business stakeholders, you help to improve and automate business workflows. Overview After completing this course, students will be able to: Design RPA solutions Develop RPA solutions Deploy and manage RPA solutions Candidates for this course automate time-consuming and repetitive tasks by using Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Candidates work with business stakeholders to improve and automate business workflows. They collaborate with administrators to deploy solutions to production environments, and they support solutions. MODULE 1: GET STARTED WITH POWER AUTOMATE FOR DESKTOP * Get started with Power Automate for desktop by learning about flows, creating automated steps, and flow development essentials. MODULE 2: AUTOMATE PROCESSES WITH ROBOTIC PROCESS AUTOMATION AND POWER AUTOMATE FOR DESKTOP * Work with Power Automate for desktop to record Windows and Web applications, but also use out of box actions such as manipulating Excel documents as part of an end to end invoice processing solution. MODULE 3: WORK WITH POWER AUTOMATE FOR DESKTOP * Work with Power Automate for desktop options, flows, recording features, conditions, loops, variables, images, and error and exception handling. MODULE 4: WORK WITH DIFFERENT TECHNOLOGIES IN POWER AUTOMATE FOR DESKTOP * Learn how to automate email handling, Excel, user interface, and system services with Power Automate for desktop. MODULE 5: IMPLEMENT ADVANCED LOGIC IN POWER AUTOMATE FOR DESKTOP * Learn how to work with system flows, control flows, mimic mouse actions, as well as operations used to manipulate text, date, and time in Power Automate for desktop. MODULE 6: BUILD EXPERTISE WITH POWER AUTOMATE FOR DESKTOP * Learn how to use Power Automate for desktop to work with Power Automate, OCR technologies, and scripting. MODULE 7: BUILD CUSTOM CONNECTORS FOR POWER AUTOMATE * This Learning Path explores custom connectors and explains how to configure them and use them with Microsoft Power Automate MODULE 8: USE BEST PRACTICES TO SECURE AND GOVERN MICROSOFT POWER PLATFORM ENVIRONMENTS * This module focuses on introducing Microsoft Power Platform environments and their role in creating Data Loss Prevention (DLP) policies by using examples and use cases. A brief introduction and overview of tools will also be discussed, including Microsoft Power Platform and Power Automate Admin experiences and Microsoft Power Platform Center of Excellence (COE) toolkit. ADDITIONAL COURSE DETAILS: Nexus Humans PL-500T00 Microsoft Power Automate RPA Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. 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. While we feel this is the best course for the PL-500T00 Microsoft Power Automate RPA 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. 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.
PL-100T00 Microsoft Power Platform App Maker
By Nexus Human
Duration 4 Days 24 CPD hours This course is intended for The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth mindset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies. This course will teach you how to build apps with low-code techniques to simplify, automate, and transform business tasks and processes using Microsoft Power Platform. This course contains a 1-day Applied Workshop. This workshop will allow you to practice your App Maker skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows. 1 - GET STARTED WITH MICROSOFT POWER PLATFORM FOR APP MAKERS * Identify components * Create apps * Get started with Microsoft Dataverse * Work with Copilot in Microsoft Power Platform 2 - CREATE TABLES IN DATAVERSE * Table characteristics * Table relationships * Dataverse logic and security * Dataverse auditing * Dual-write vs. virtual tables 3 - CREATE AND MANAGE COLUMNS WITHIN A TABLE IN DATAVERSE * Define columns in Microsoft Dataverse * Column types in Microsoft Dataverse * Add a column to a table * Primary name column * Restrictions that apply to columns in a table * Create an auto numbering column * Create an alternate key 4 - LOAD/EXPORT DATA AND CREATE DATA VIEWS IN DATAVERSE * View data in a table * Create or edit views of data in a table * Dataverse data import options * Load data into a table * Dataverse data export options * Export * Add, update, or delete data in a table by using Excel * Import data using Power Query 5 - EXPORT DATA FROM DATAVERSE AND USE MICROSOFT EXCEL TO EDIT RECORDS * Export data to Excel * Edit and update data in Excel 6 - GET STARTED WITH MICROSOFT DATAVERSE FOR TEAMS * Dataverse for Teams vs Dataverse * Provision your first Dataverse environment * Create your first table to store data 7 - BUILD YOUR FIRST APP WITH POWER APPS AND DATAVERSE FOR TEAMS * Create your first app with the hero template * Customize your app with Power Apps Studio * Publish your app * Install template apps 8 - BUILD YOUR FIRST WORKFLOW WITH POWER AUTOMATE AND DATAVERSE FOR TEAMS * Types of workflows that Power Automate can build in Dataverse * Schedule a flow 9 - CREATE REPORTS WITH POWER BI AND DATAVERSE FOR TEAMS * Connect to and transform Dataverse for Teams data from Power BI * Create a Power BI report * Publish the report * Share the data 10 - GET STARTED BUILDING WITH POWER BI * Use Power BI * Building blocks of Power BI * Tour and use the Power BI service 11 - EXPLORE WHAT POWER BI CAN DO FOR YOU * What can I do with the Power BI service as a consumer? * View content in the Power BI service * Collaborate and share in Power BI * Find and view dashboards and reports 12 - CREATE AND MANAGE WORKSPACES IN POWER BI * Distribute a report or dashboard * Monitor usage and performance * Recommend a development life cycle strategy * Troubleshoot data by viewing its lineage * Configure data protection 13 - MANAGE SEMANTIC MODELS IN POWER BI * Use a Power BI gateway to connect to on-premises data sources * Configure a semantic model scheduled refresh * Configure incremental refresh settings * Manage and promote semantic models * Troubleshoot service connectivity * Boost performance with query caching (Premium) 14 - CREATE DASHBOARDS IN POWER BI * Configure data alerts * Explore data by asking questions * Review Quick insights * Add a dashboard theme * Pin a live report page to a dashboard * Configure a real-time dashboard * Set mobile view 15 - IMPLEMENT ROW-LEVEL SECURITY * Configure row-level security with the static method * Configure row-level security with the dynamic method 16 - CREATE DASHBOARDS IN POWER BI * Configure data alerts * Explore data by asking questions * Review Quick insights * Add a dashboard theme * Pin a live report page to a dashboard * Configure a real-time dashboard * Set mobile view 17 - SECURE, PUBLISH, AND SHARE DATA IN POWER BI * Share and use reports in Power BI * Row-level security * Publish a report to a Power BI workspace * Share reports and user experience * Protect data in Power BI * Data refresh and alerts 18 - EMBED POWER BI CONTENT * Embed Power BI reports * Embed other Power BI content types * Optimize the embedding experience 19 - HOW TO BUILD YOUR FIRST MODEL-DRIVEN APP WITH DATAVERSE * Model-driven apps, powered by Microsoft Dataverse * Explore sample apps 20 - GET STARTED WITH MODEL-DRIVEN APPS IN POWER APPS * Introducing model-driven apps * Components of model-driven apps * Design model-driven apps * Incorporate business process flows 21 - CONFIGURE FORMS, CHARTS, AND DASHBOARDS IN MODEL-DRIVEN APPS * Forms overview * Form elements * Configure multiple forms * Use specialized form components * Configure views overview * Configure grids * Create and edit views * Configure charts overview * Dashboards overview * Use interactive streams and tiles 22 - MANAGE DYNAMICS 365 MODEL-DRIVEN APP SETTINGS AND SECURITY * Configure role-based security * Manage teams and business units * Explore settings and customizations 23 - USE SPECIALIZED COMPONENTS IN A MODEL-DRIVEN FORM * Create business process flows * Embed a canvas app in a model-driven form * Add a timeline in a model-driven form * Create a report in a model-driven form 24 - GET STARTED WITH POWER APPS CANVAS APPS * Start Power Apps * Power Apps data sources * Use Power Apps with Power Automate and Power BI * Designing a Power Apps app 25 - CUSTOMIZE A CANVAS APP IN POWER APPS * Improve your app by making basic customizations * Explore controls and screens in canvas apps 26 - HOW TO BUILD THE USER INTERFACE IN A CANVAS APP IN POWER APPS * Use themes to quickly change the appearance of your app * Brand a control * Icons * Images * Personalization * Build for phones or tablets 27 - NAVIGATION IN A CANVAS APP IN POWER APPS * Understanding navigation * The Navigate and Back functions * More ways to use the Navigate function 28 - MANAGE APPS IN POWER APPS * Power Apps review 29 - BUILD A MOBILE-OPTIMIZED APP FROM POWER APPS * Learn about mobile-optimized apps * Identify components to make a canvas app mobile-optimized * Create a mobile-optimized app that uses responsive designs * Identify performance considerations for a mobile-optimized canvas app 30 - USE AND UNDERSTAND CONTROLS IN A CANVAS APP IN POWER APPS * Core properties of controls * Entering and displaying data with text controls * Additional controls for enhancing your app's usability * Media * Modern controls * Work with component libraries 31 - CREATE FORMULAS TO CHANGE PROPERTIES IN A POWER APPS CANVAS APP * Formulas overview * Use a formula to modify the format of controls * Use formulas to perform calculations * Use a control to modify the property of other controls * Conditional formatting * Functions for validating data 32 - USE IMPERATIVE DEVELOPMENT TECHNIQUES FOR CANVAS APPS IN POWER APPS * Imperative versus declarative development * The three types of variables in Power Apps * Global variables * Contextual variables * Collections * Additional variable concepts 33 - MANAGE APPS IN POWER APPS * Power Apps review 34 - CREATE FORMULAS TO CHANGE PROPERTIES IN A POWER APPS CANVAS APP * Formulas overview * Use a formula to modify the format of controls * Use formulas to perform calculations * Use a control to modify the property of other controls * Conditional formatting * Functions for validating data 35 - CREATE FORMULAS TO CHANGE BEHAVIORS IN A POWER APPS CANVAS APP * Formulas and functionality * Understanding true and false * Understanding control behaviors and actions * Performing multiple actions in a formula * Control the display mode through a formula * Use controls and functions to create a dynamic formula 36 - AUTHOR A BASIC FORMULA THAT USES TABLES AND RECORDS IN A POWER APPS CANVAS APP * Records and tables * Using the Table function * Store a table * Filter your table * Use the lookup function to return a record * Additional table functions 37 - BUILD A CANVAS APP FOR A REAL ESTATE SOLUTION WITH COPILOT IN POWER APPS 38 - GET STARTED WITH POWER AUTOMATE * Introducing Power Automate * Create your first flow * Troubleshoot flows 39 - BUILD APPROVAL FLOWS WITH POWER AUTOMATE * Provide solutions to real-world scenarios. 40 - BUILD FLOWS TO MANAGE USER INFORMATION 41 - POWER AUTOMATE'S DEEP INTEGRATION ACROSS MULTIPLE DATA SOURCES 42 - USE THE ADMIN CENTER TO MANAGE ENVIRONMENTS AND DATA POLICIES IN POWER AUTOMATE * Administer flows * Export and import flows * Learn how to distribute button flows 43 - USE AI BUILDER IN POWER AUTOMATE * AI Builder in Power Automate saves time * Advanced usage of AI Builder in Power Automate 44 - OPTIMIZE YOUR BUSINESS PROCESS WITH PROCESS ADVISOR * Get familiar with process advisor * Create your first recording * Edit recordings and group actions * Analyze recordings and interpret results * Automation recommendations 45 - OPTIMIZE YOUR BUSINESS PROCESS WITH PROCESS ADVISOR * Get familiar with process advisor * Create your first recording * Edit recordings and group actions * Analyze recordings and interpret results * Automation recommendations 46 - BUILD FLOWS FOR A REAL ESTATE SOLUTION USING COPILOT IN POWER AUTOMATE * When to use Copilot in Power Automate 47 - USE DATAVERSE TRIGGERS AND ACTIONS IN POWER AUTOMATE * Dataverse triggers * Query data * Create, update, delete, and relate actions 48 - CREATE TABLES IN DATAVERSE * Table characteristics * Table relationships * Dataverse logic and security * Dataverse auditing * Dual-write vs. virtual tables 49 - CREATE AND MANAGE COLUMNS WITHIN A TABLE IN DATAVERSE * Define columns in Microsoft Dataverse * Column types in Microsoft Dataverse * Add a column to a table * Primary name column * Restrictions that apply to columns in a table * Create an auto numbering column * Create an alternate key 50 - GET STARTED WITH POWER APPS CANVAS APPS * Start Power Apps * Power Apps data sources * Use Power Apps with Power Automate and Power BI * Designing a Power Apps app 51 - HOW TO BUILD THE USER INTERFACE IN A CANVAS APP IN POWER APPS * Use themes to quickly change the appearance of your app * Brand a control * Icons * Images * Personalization * Build for phones or tablets 52 - GET STARTED WITH POWER AUTOMATE * Introducing Power Automate * Create your first flow * Troubleshoot flows 53 - CHALLENGE PROJECT - BUILD A BOOKING REQUESTS APP WITH POWER APPS AND POWER AUTOMATE * Prepare
Power BI Data Analyst (PL300)
By Online Productivity Training
OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: * Learn how to clean, transform, and load data from many sources * Use database queries in Power Query to combine tables using append and merge * Create and manage a data model in Power BI consisting of multiple tables connected with relationships * Build Measures and other calculations in the DAX language to plot in reports * Manage advanced time calculations using date tables * Optimise report calculations using the Performance Analyzer * Manage and share report assets to the Power BI Service * Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? * Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence * Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions * Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system * Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps * Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics * Data analytics and Microsoft * Getting Started with Power BI Module 2 Get Data In Power BI * Get data from various data sources * Optimize performance * Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI * Data shaping * Data profiling * Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI * Introduction to data modelling * Working with Tables * Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI * Introduction to DAX * Real-time Dashboards * Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance * Optimize the data model for performance * Optimize DirectQuery models Module 7 Create Reports * Design a Report * Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards * Create a Dashboard * Real-time Dashboards * Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics * Advanced analytics * Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces * Creating Workspaces * Sharing and managing assets Module 11 Manage Datasets In Power BI * Parameters * Datasets Module 12 Row-Level Security * Security in Power BI Lab: Enforce Row-Level Security
55215 SharePoint Online Power User
By Nexus Human
Duration 4 Days 24 CPD hours This course is intended for This course is intended for both novice and experienced SharePoint users who wish to make full use of SharePoint Online. Overview #NAME? This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites in SharePoint Online. Your goal is to learn how to make SharePoint online relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class, you will also learn best practices and ?what not to do? as you watch live, interactive demonstrations and put theory into practice with hands on exercises in SharePoint Online. 1 - AN INTRODUCTION TO SHAREPOINT ONLINE * Introducing Office 365 and SharePoint * Getting started with Office 365 * The cloud revolution * Login to Office 365 * What is Office 365 * Using the app launcher * What is SharePoint * Office 365 settings * Introducing Office 365 Groups * Delve * Ownership and Access * OneDrive 2 - CREATING SITES * Planning your sites * Create new subsites * The Office 365 tenant * Site templates * Web addresses * Apply a them * Site collections * Building your navigation * Create a new site * Delete subsites * Team site navigation * User interface: classic vs modern * Site contents: classic vs modern * Where does classic come from? 3 - CREATING AND MANAGING WEB PAGES * The types of pages found in SharePoint * Classic SharePoint pages * Modern SharePoint pages * How to use classic team site pages * Create news and site pages * Review features of publishing sites * Web parts * Save, publish, share and delete pages * Communication sites 4 - WORKING WITH APPS * An introduction to apps * Co-authoring * Marketplace apps * Check In ? Out * Adding apps to a site * Edit and view file properties * Create and manage columns * Quick edit view * Public and personal views * File commands * Managing app settings * Copy link and Share * Content approval * Folders * Major and minor versioning * The recycle bin * Document sets * Alerts * Working with files in a library * OneDrive sync * Create, Upload and edit files * Working with classic lists 5 - BUILDING PROCESSES WITH FLOW AND POWERAPPS * What are business processes? * Design and publish a Flow * Classic tools for designing processes * Getting started with PowerApps in SharePoint * Design and test a classic workflow * Enhance data capture with PowerApps * Getting started with Flow in SharePoint * Test a Flow and PowerApps enriched list 6 - CUSTOMIZING SECURITY * Office 365 Group access * Share a file * Updating Office 365 Group Security * Remove a user * Managing access to SharePoint * Customizing SharePoint security * New sites private vs public * Create permission levels and groups * Setup access requests * Security inheritance * Share a site * Security best practices 7 - WORKING WITH SEARCH * Delve * Search tips * An introduction to SharePoint search * Accessing classic search * Search in folders, libraries and sites * Promoted results * Search results 8 - ENTERPRISE CONTENT MANAGEMENT * Managed metadata service * Information management policies * An introduction to content types * The records center * Create and manage content type * In-place records management * Deploy content types * The content organizer * Using content types in apps * Durable links * The content type hub