271 Builder courses

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. Overview Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. Prerequisites ?Familiarity with Windows. ?Creating and navigating folders. ?Opening programs. ?Manipulating windows. ?Copying and pasting objects. ?Formatting text. ?Saving files. 1 - EXPLORING THE REPORT BUILDER ENVIRONMENT * Introducing the Report Builder Environment * Working with Existing Reports * Lab 1: Exploring the Report Builder Application 2 - ADDING DATA TO TABLE REPORTS * Create Report Data Sources * Create Report Datasets * Work with the Tablix Data Region * Create a Table Report * Lab 1: Creating Table Reports 3 - FORMATTING DATA AND CREATING EXPRESSIONS IN REPORTS * Formatting Reports * Sorting and Filtering Report Data * Adding Data to a Dataset * Creating Simple Expressions * Creating Complex Expressions * Lab 1: Formatting Reports 4 - GROUPING REPORT DATA * Group Data in Reports * Group Data Using an Expression * Creating Subgroups and Group Aggregates * Lab 1: Creating Reports with Groups and Aggregates 5 - MATRIX REPORTS * Creating and Modifying Matrix Data Regions * Creating and Modifying Column Groups * Lab 1: Creating Matrix Reports 6 - CHARTS * Create and Modify Chart Wizard Reports * Add Charts to Existing Reports * Modify Charts in Reports * Lab 1: Creating Charts and Chart Reports 7 - PRINTING AND EXPORTING REPORTS * Print Features and Print Options * Export Reports * Lab 1: Printing and Exporting Reports

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - PARAMETER REPORTS * Parameterized Reporting * Create Report Parameters * Modify Report Parameters * Provide Default Parameter Values * Provide Available Values for Parameters * Lab: Creating Parameterized Reports 2 - LIST DATA REGIONS * Introducing the List Data Region * Create Reports Using List Data Regions * Modify Reports Which Use List Data Regions * Lab: Creating List Reports 3 - ENHANCING REPORTS WITH COMPLEX EXPRESSIONS * Formatting Reports * Top N Reports * Running Values * Lab: Enhancing Reports with Complex Expressions 4 - ENHANCE REPORTS WITH IMAGES AND SUBREPORTS * Add Images to Reports * Retrieve Images from a Database * Introducing SSRS (SQL Server Reporting Services) Report Server * Add Subreports to Reports * Lab: Working With Images and Subreports 5 - DRILLDOWN AND DRILLTHROUGH REPORTS * Add and Configure Drilldown Reporting * Add and Configure Drillthrough Reporting * Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - SPARKLINES, DATA BARS, AND INDICATORS * Sparklines * Data Bars * Indicators * Lab: Adding Sparklines, Data Bars, and Indicators to Reports ADDITIONAL COURSE DETAILS: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 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.

Kickstart your career with this Salesforce Platform App Builder Certification program. Salesforce skills are in high demand, and you can learn the core concepts of online application development using Salesforce App Builder and Force.com Platform Fundamentals.

This course is designed for beginners who want to learn how to use Tableau Prep Builder for data preparation and data cleaning. We will start from scratch; no specific knowledge is required; you should only be familiar with Tableau.

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

With our CV builder, you can make a professional CV for job and university applications in minutes. Low cost and fast delivery.

Bayfield Training and the University of Cambridge Department of Land Economy This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise. If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you. This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.  Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment. ON THIS COURSE YOU WILL: * Become a competent model builder, building Real Estate Financial Models from scratch * Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia * Learn how to use Real Estate Financial Models to make informed investment decisions * Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill THIS COURSE IS SUITABLE FOR: * Chartered Surveyors * Asset Managers * Financial Controllers * Financial Analysts * Investment Managers * Property Managers * Real Estate Students/Recent Graduates Course Outline: Module 1 - Economic Context Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. * Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. * Why Real Estate Asset Modelling is important * Understanding the occupier, asset and development markets and the relevant modelling approaches for each * Real Estate Sub-Sector Key Performance Indicators * Introduction to conventional valuations and financial mathematics * Understanding and minimising errors in Financial Models Module 2 - Cash Flow Fundamentals Constructing a financial model from first principles. * Understanding all the components of a basic cash flow model * Understand why Corporate Finance Models and Real Estate Models are different * Financial Model Design * Making the link between valuations, income mathematics and discounted cash flows * Internal Rate of Return, Net Present Value,Worth and other metrics * Features and techniques to aid fast model building Module 3 - Developing the Cash Flow Adapting financial models for different periodicities and building rent functions for different rent behaviour. * Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc. * Developing the concept of a Rent Function in Excel * Logic mathematics and Logic functions * Projecting rent to adapt to different lease contracts and growth patterns * Alternative solutions to Logic functions * Comparative analysis of lease structures in different jurisdictions and adapting financial models Module 4 - Real Estate Data Understanding the different sources of data, constructing basic time series models and recognising basic patterns. * Key Property market indicators * Characteristics and application of key input metrics for Real Estate Appraisals * Understanding the eight components of Real Estate Price Dynamics * Awareness of the different sources of data * Reading and using general property market reports * Constructing basic time series models and recognising basic patterns Module 5 - Development Appraisals Constructing a development appraisal from first principles and understanding development return metrics. * Understanding the key components of a development project * Understanding the difference between development and investment appraisals * Residual Appraisals and Profit Calculations * Cost orientated cash flows and phased sales * Cumulative construction cost patterns: incidental, fixed, loaded and S-curve * Development return metrics and Modified IRRs Module 6 - Multi-let Cash Flows Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions. * Multi-let and portfolio model design principles * Building complex date functions and date series * The three multi-let rent projection techniques * Perpendicular Rent Functions * Incorporate advanced rent adjustments into the Rent Function * Incorporate sector and period varying rental growth rates * Simplifying OPEX and CAPEX projections * Discounting techniques on complex and volatile cash flows Module 7 - Project Finance Constructing a flexible Real Estate Debt Finance model. * Revision of the Mathematics of amortisation and debt finance * Basic senior debt models and geared net cash flow * LTV, IRR and Interest Rate Dynamics * Flexible term, repayment options and deferred interest * Loan covenant tests * Understanding different tranches of debt * Understanding how complex debt structures impact the returns to different parties Module 8 - Model Interpretation and Risk Analysis Learn how to read, analyse and report on real estate financial models. * Understand how to read models and develop an investment narrative * Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards * Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins * Learn how to construct varied project scenarios in a systematic way * Introduction to Monte Carlo Analysis and VBA * Optimising sale dates and other parameters * Create well written, attractive and persuasive reports Included in the Course * Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge * 64 CPD Hours * 1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee * Course Files * Q&A Webinars and Guest Speaker Webinars * Further Learning Resources (Reading, Files and Videos) * Post Course Support - Two Months of Questions & Answers 2024 Cohort Dates Include: * 3rd June to 29th July * 5th August to 25th September 2024 * 30th September to 25th November For more information, please contact Sam on the Bayfield Training Sales team: E - s.musgrave@bayfieldtraining.com T - 01223 517851 W - www.bayfieldtraining.com [https://www.bayfieldtraining.com/]

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

Need help writing a Personal Statement? Try the uni4u software suite: affordable, multiple-use, instant delivery, and plagiarism-free.

Duration 1 Days 6 CPD hours This course is intended for Certification Preparation for Platform App Builder is ideal for administrators, system integrators, and independent software vendors (ISVs) with an interest in sharpening the development, deployment, and administrative skills required to succeed in becoming a Salesforce Certified Platform App Builder Overview Architect and manage the correct data model based on business requirements. Configure application security. Define business logic and process automation declaratively. Design user interfaces. Customize applications for mobile use and Lightning. Deploy applications. Are you ready to take the next step in your career by becoming a Salesforce Certified Platform App Builder? By covering the details around the exam objectives, this course will help hone your knowledge of Salesforce application lifecycle management and the declarative and programmatic solutions available to you through guided scenarios, lecture, and discussion. SALESFORCE FUNDAMENTALS * Capabilities of core CRM objects * Boundaries of declarative customizations * Use cases for programmatic customizations SECURITY * Restricting and extending object, record, and field access * Determining appropriate sharing solutions DATA MODELING AND MANAGEMENT * Determining an appropriate data model * Relationship types and impact on record access, user interface, and reporting * Considerations for changing field types * Considerations of the schema builder * Considerations for importing and exporting data * Use cases of external objects REPORTING * Creating reports * Report types * Dashboards USER INTERFACE * Customization options * Custom buttons, links, and actions * Declarative options for incorporating Lightning Components MOBILE * Declarative customizations available for the Salesforce1 user interface BUSINESS LOGIC AND PROCESS AUTOMATION * Record types * Formula fields * Roll-up summary fields * Validation rules * Approval processes * Workflow * Visual workflow * Process builder * Automating business processes * Ramifications of field updates and potential for recursion APP DEPLOYMENT * Application lifecycle * Sandboxes * Change sets * Unmanaged and managed packages * Determining an appropriate deployment plan WRAPPING UP * Test preparation * Practice exam