1041 Microsoft 365 courses in Cardiff delivered Online

Learning Objectives Introduction , Getting Started with Access , Working with Data , Creating Databases and Objects , Working with Queries , Working with Reports , Working with Forms , Conclusion   Pre-Requisites Basic computer skills. Knowledge of basic database concepts is helpful but not required.   Description This course is an introduction to Microsoft Access 365. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 365 Intermediate course. Module 1: Getting Started with Access What is a Database 00:03:00 Database Terminology 00:05:00 The Access Interface 00:08:00 What is a Flat File Database 00:03:00 What is a Relational Database 00:10:00 Relating Tables 00:10:00 Reviewing The Access Ribbon 00:02:00 Module 2: Working with Data Working with Tables 00:07:00 Navigating Tables 00:04:00 Editing Data 00:03:00 Adding New Records 00:05:00 Using Subdatasheets 00:04:00 Module 3: Creating Databases and Objects Understanding Database and Table Design Principles 00:08:00 Using Table Data Sheet View 00:03:00 Working with Field Data Types 00:07:00 Using Table Design View 00:04:00 Calculating Numbers 00:05:00 Calculating Dates 00:02:00 Calculating Strings 00:03:00 Using The Lookup Wizard 00:12:00 Lookup Wizard Linking Tables 00:09:00 Using Indexes 00:04:00 Module 4: Working with Queries What are Queries? 00:08:00 Creating Simple Queries 00:05:00 Entering Criteria-Exact Match and Range Operators 00:05:00 Understanding And Versus Or 00:06:00 Using Wildcards 00:05:00 Using Key Words 00:04:00 Sorting and Hiding Fields 00:03:00 Creating Multi-Table Queries 00:03:00 Additional Tips C4 00:06:00 Module 5: Working with Reports What are Reports 00:05:00 Understanding Report Types 00:03:00 Building Good Reports 00:02:00 Using AutoReport 00:08:00 Understanding The Report Wizard 00:11:00 Using the Report Design View 00:08:00 Printing Reports 00:04:00 Creating labels 00:08:00 Additional Tips C5 00:10:00 Module 6: Working with Forms What are Forms 00:04:00 Understanding Form Types 00:03:00 Creating Forms 00:03:00 Navigating Forms 00:03:00 Editing Data in Forms 00:05:00 Understanding the Form Wizard 00:05:00 Using Form Design View 00:04:00 Working with Controls 00:10:00 Using Form Layout View 00:04:00 Additional Tips C6 00:07:00 Resource Resource - Access 365 Beginner 00:00:00 Final Exam Final Exam - Access 365 Beginner 00:20:00

The Office 365 - Outlook Web App course is intended for individuals who work with Office 365 and Outlook Online. Microsoft Outlook tool allows its users the privilege to work from anywhere. Master the Microsoft's Outlook Web App and learn how to perform all the functions that placed in the Desktop version of Microsoft Outlook. Study about reading and responding to emails, creating and formatting messages, managing the mailbox, use the address book, creating folders for organization, and printing emails. In addition to that, you'll explore Outlook Web App with rules, understand IM settings and action items. Managing the Calendar, creating appointments and meetings requests, working with contacts, groups and tasks also discussed in the course. Besides, learn how to navigate the Office 365 Mail setting and new features and differences of using Outlook in the cloud. What Will I Learn? Navigate Outlook Online Create email messages and attach files Read and reply to emails, and work with attachments Create and manage rules Organize with folders and use Clutter Create and manage Contacts Manage the Calendar, and create appointments and meetings Work with Tasks Requirements Basic understanding of computers and navigating the Internet Knowledge of email functions and programs is helpful but not required Introduction Introduction 00:02:00 Getting Started With Outlook Online Navigating the Outlook Views 00:08:00 Working with the My Day View 00:03:00 Creating a New Email Message 00:05:00 Attaching a File 00:03:00 Working with Email Replying to an Email 00:03:00 Liking an Email Message 00:02:00 Formatting Email Text 00:03:00 Working with Conversation View 00:02:00 Deleting Emails 00:04:00 Printing Emails 00:02:00 Using the Notes Feature 00:03:00 Managing the Outlook Mailbox Using Sweep 00:02:00 Flagging Emails 00:02:00 Creating a Rule 00:04:00 Editing a Rule 00:02:00 Working with Favorites 00:02:00 Organizing Mail Working with Folders 00:07:00 Working with Clutter 00:04:00 Pinning and Searching for Emails 00:03:00 Using the Focused Inbox 00:05:00 Using Groups 00:05:00 Customizing Outlook Customizing the Environment 00:07:00 Setting Out of Office 00:05:00 Showing BCC and Using Read Receipts 00:04:00 Working with Contacts 00:07:00 Exploring the Calendar Exploring the Calendar View 00:05:00 Working with Calendars 00:07:00 Working with Shared Calendars 00:06:00 Working with Tasks Viewing Tasks 00:02:00 Creating Tasks 00:03:00 Conclusion Course Recap 00:02:00 Course Certification

Delve helps you discover the information that's likely to be most interesting to you across Office 365. Find information about people - and through people - and help others find you. You don't have to remember the title of a document or where it's stored. Delve shows you documents no matter where they're stored in One Drive for Business or in Sites in Office 365. Discover how Delve is helping business users get the most out of their data and information related to Office 365. The Office 365 Delve will provide you with the basic understanding of the purpose, features, functionality, and navigation in Delve. Students will learn to work with Content Cards, explore and manage various views, learn to use Boards, work with searching for content, and lastly, work with collaboration and sharing documents. Learn how to make the most of OneDrive for Business. What Will I Learn? Understand Delve Work with Content Cards Use Boards Share Documents Requirements Basic computer and Internet navigation skills. Who is the target audience? Students interested in understanding and working with Office 365's Delve. Introduction Introduction FREE 00:03:00 Working with Delve Overview of Delve 00:05:00 Working with Content Cards 00:07:00 Exploring Views 00:05:00 Using Boards 00:06:00 Searching in Delve 00:05:00 Sharing Documents 00:05:00 Course Recap 00:02:00 Course Certification

Description: Are you not familiar with Office 2016 and want to learn every single detail of it? Then you are at the right place! Office 2016 Complete Course is designed for beginners to educate about Microsoft Office 2016. Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, create columns, rows and much more. Microsoft PowerPoint will help you in navigating the PowerPoint environment, create and save PowerPoint presentation, etc. Microsoft Outlook will help you to set up and use Outlook on Windows, also assist you in creating and sending messages, managing contacts, working with notes, etc. You will learn related information to access Microsoft Office 2016. Additionally, you will learn Project management basics, adding tasks and resources to a project and saving them. In the course, you will learn the essential features of the latest version of Microsoft Visio and the basic information about the diagramming software. Learning Outcomes: Word 2016 user interface, creating basic documents and utilizing help Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists Understanding the commands on the home tab and mini toolbar Paragraph layout tool, borders, shading, styles and formatting management techniques Maximizing your ability to utilize tables within Word 2016 Inserting symbols and special characters along with techniques for adding them Managing your page's appearance with colours, borders, watermarks, headers, footers and page setup dialog box Reviewing documents through spell check, research pane and thesaurus Document accessibility options Customizing the user interface, modifying save options and managing other file types Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Utilize the PowerPoint user interface, creating and saving presentations, and using help Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation Discover methods for formatting characters, paragraphs, and text boxes Adding images, screenshots, screen recordings, shapes and WordArt Modifying options for objects and animation features Creating and formatting a table and integrating data from other Microsoft Office applications Create format and manipulate a chart Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses Customize reading options, work with attachments and manage message responses Managing and organization of messages with the help of tags, flags, other commands and folders Using calendar options to manage appointments and meetings Using People workspace to create, update, view and organise contacts Managing tasks and notes Creating and managing Quick Steps, and customizing the interface according to needs Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and subqueries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format Project management basics, navigating and customizing the user interface, adding tasks and resources to a project and saving them Managing project time frames and changing working time Managing project tasks, adding summary tasks and milestones Managing project resources, allocating and levelling work resources Sharing and exporting projects, and adjusting project print views Navigation throughout Visio interface, creating basic drawing and using the help system Drawing components, modifying drawings and work with callouts and groups Organization charts creation, modifying their layouts, positioning and spacing Create and integrate organization chart copies and compare them Making a basic floor plan and custom room shapes, utilizing the program as a modelling tool and modelling room layouts Creating cross-functional flowcharts and related features like - swimlanes and separators Altering orientation and direction, changing margins and choosing styles for flowcharts Creating network diagrams, and utilizing shape data and layers Other network diagram relevant topics such as network shapes, shape data, adding layers, activating, colouring and more Working with shape, connector styles, themes, variants and containers Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Office 2016 Complete Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Office 2016 Complete Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Duration 3.5 Days 21 CPD hours This course is intended for This course is for AWS Cloud Architects with expertise in designing and implementing solutions running on AWS who now want to design for Microsoft Azure. Overview After completing this course, students will be able to: Secure identities with Azure Active Directory and users and groups. Implement identity solutions spanning on-premises and cloud-based capabilities Apply monitoring solutions for collecting, combining, and analyzing data from different sources. Manage subscriptions, accounts, Azure policies, and Role-Based Access Control. Administer Azure using the Resource Manager, Azure portal, Cloud Shell, and CLI. Configure intersite connectivity solutions like VNet Peering, and virtual network gateways. Administer Azure App Service, Azure Container Instances, and Kubernetes. This course teaches Solutions Architects who have previously designed for Amazon Web Services how to translate business requirements into secure, scalable, and reliable solutions for Azure. Introduction to Azure Subscriptions and accounts Resource groups and templates in Azure Resource Manager Azure global infrastructure Azure regions Azure Availability Zones Comparison with AWS Implement Azure Active Directory Introduction to Azure Active Directory Domains and custom domains Safety features Guest users in Azure Active Directory Manage multiple directories Comparison with AWS Implement and manage hybrid identities Introduction to Azure AD Connect Comparison with AWS Implement virtual networking Azure Virtual Network and VNet peering VPN and ExpressRoute connections Comparison with AWS Implement VMs for Windows and Linux Configure high availability Comparison with AWS Implement load balancing and network security Implement Azure Load Balancer Implement an Azure Application Gateway Implement Azure Firewall Implement network security groups and application security groups Comparison with AWS Implement container-based applications Configure Azure Kubernetes Service Publish a solution on an Azure Container Instance Comparison with AWS Implement an application infrastructure Create an App Service plan Create and configure Azure App Service Configure networking for an App Service Introduction to Logic Apps and Azure Functions Comparison with AWS Implement storage accounts Azure Storage core concepts Managing the Azure Blob storage lifecycle Working with Azure Blob storage Comparison with AWS Implement NoSQL databases Introduction to Azure Cosmos DB Consistency Select appropriate CosmosDB APIs Set up replicas in CosmosDB Comparison with AWS DynamoDB Implement Azure SQL databases Configure Azure SQL database settings Implement Azure SQL Database managed instances Configure high availability for an Azure SQL database Comparison with AWS Implement cloud infrastructure monitoring Monitor security Monitor cost Configure a Log Analytics workspace Comparison with AWS Implement and manage Azure governance solutions Assign RBAC roles Configure management access to Azure Implement and configure an Azure Policy Comparison with AWS Manage security for applications Implement Azure Key Vault Implement and configure Azure AD Managed Identities Register and manage applications in Azure AD Comparison with AWS Migration, backup, and disaster recovery management Migrate workloads Implement Azure Backup for VMs Implement disaster recovery Comparison with AWS

Duration 5 Days 30 CPD hours This course is intended for This course is recommended for administrators and engineers. Overview What you'll learn: Understand the differences between Citrix Virtual Apps and Desktops 2203 LTSR on-premises and the Citrix DaaS. Install, configure, and manage Citrix Cloud Connectors. Deploy and manage Virtual Delivery Agent machines to on-premises resource locations as well as in Microsoft Azure using MCS. Integrate Citrix Cloud and Citrix Virtual Apps and Desktops 2203 LTSR with Microsoft Azure Active Directory. Provide remote access with Citrix StoreFront and Citrix Gateway on Microsoft Azure. In this course you will learn how to create a new Citrix DaaS deployment on Citrix Cloud, with a resource location on Microsoft Azure. You will also learn how to migrate to Citrix DaaS from an on-premises Citrix Virtual Apps and Desktops Site. Get hands-on as the course guides you through the architecture, communications, management, installation, and configuration of Citrix DaaS on Citrix Cloud and a Microsoft Azure resource location that will host apps and desktops for your users. This course is a necessary step in enabling you with the right training and skills, to not only understand, manage, and deliver successfully, but also to make well-informed planning decisions along the way. Module 1: Introduction to Citrix DaaS New Citrix Workspace Packaging Citrix Virtual Apps and Desktops - On-Premises Site What is Citrix Cloud? Why Citrix DaaS? What is a Migration from Citrix Virtual Apps and Desktops to Citrix DaaS? Citrix Cloud Administration Module 2: Planning - Citrix DaaS Architecture, Security, and Operations Architecture and Deployment Options Citrix DaaS Security Citrix DaaS Operations Module 3: Planning - Citrix Cloud Connectors Cloud Connector Architecture Cloud Connector Services and Communications Overview Cloud Connector Operations in a Resource Location Cloud Connector Resiliency Installing, Updating, and Removing Cloud Connectors Supported Domain Scenarios for Cloud Connectors Securing Cloud Connector Communications Local Host Cache (LHC) Citrix Cloud Connector vs Delivery Controller Operations Module 4: Planning - Citrix DaaS Resource Locations Citrix DaaS Resource Locations Citrix DaaS Hosting Connections Zones Module 5: Active Directory, Authentication, and Authorization Active Directory Design Options Desktops from Non-Domain Joined VDAs Citrix Federated Authentication Service and Identity Provider Services Module 6: Planning - Provisioning VDA Workloads and Delivering Resources Master Images Machine Creation Services (MCS) in Citrix DaaS Citrix Provisioning in Citrix DaaS Machine Catalogs Delivery Groups Citrix Cloud Library Module 7: Planning - Provide Access in Citrix Cloud Selecting Between Citrix digital workspace experience and StoreFront Citrix StoreFront and Citrix digital workspace experience Communications Selecting Between Citrix Gateway Service and On-Premises Citrix Gateway Access Layer Communications User Authentication Module 8: Planning - Citrix DaaS Administration Citrix Cloud Manage and Monitor Delegated Administration Citrix DaaS Remote PowerShell Software Development Kit Manage Multiple Resource Locations Module 9: Planning - Public Cloud Considerations General Public Cloud Considerations Using Autoscale to Power Manage Machines in a Public Cloud Microsoft Azure as a Citrix DaaS Resource Location Amazon Web Services as a Citrix DaaS Resource Location Google Cloud as a Citrix DaaS Resource Location Module 10: Planning - Migrating to Citrix DaaS from Citrix Virtual Apps and Desktops Citrix Cloud Migration Options and Considerations Citrix Automated Configuration Tool Citrix Image Portability Service Module 11: Manage - Operations and Support in Citrix Cloud Citrix Cloud Connector Support Updating and Rolling Back Machine Catalogs VDA Restore Citrix Self-Help Strategy Monitor Your Environment Module 12: Introduction to Citrix DaaS on Microsoft Azure Partnering for Success Module 13: Planning - Citrix DaaS Resource Location on Microsoft Azure Overview of Citrix DaaS Components Creating a Citrix DaaS Deployment Overview Module 14: Planning - Microsoft Azure Overview Azure Virtual Network Structure Azure Virtual Network Connectivity Azure Virtual Resources Azure Active Directory Identity and Access Management Azure Active Directory Options and Considerations Module 15: Planning - Deploying Citrix DaaS on Microsoft Azure Citrix DaaS Resource Locations in Azure Citrix DaaS Components in Azure Creating and Managing Workloads in an Azure Resource Location Module 16: Planning - Provide Access to End Users Providing Access to Resources in Citrix Cloud Citrix Gateway Deployment Options Deploying Citrix Gateway or ADC in Azure GSLB and StoreFront Optimal Gateway in Hybrid Environments Module 17: Rollout - Citrix DaaS Deployment on Microsoft Azure Citrix Workspace App Rollout Preparing Migration of End-Users to Workspace Platform Module 18: Managing - Citrix DaaS Workloads on Microsoft Azure Maintaining Citrix Gateway Backup and Monitoring in Azure Maintaining Master Images in Azure Monitoring VDAs in Manage Console and Azure Module 19: Optimize - Citrix DaaS on Microsoft Azure Managing Azure Costs Using Azure Pricing Calculator - Instructor Demo Additional course details: Nexus Humans CWS-252 Citrix DaaS Deployment and Administration on Microsoft Azure 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 CWS-252 Citrix DaaS Deployment and Administration on Microsoft Azure 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.

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

Duration 1 Days 6 CPD hours This course is intended for This course is designed for existing Microsoft SharePoint site users who will create and manage SharePoint team or communication sites in SharePoint Online or SharePoint 2019. Overview In this course, you will create a SharePoint team site and a communication site, perform basic content management tasks on SharePoint sites, and configure workflows with Forms and Flow. You will: Create and configure new SharePoint sites. Create and configure document libraries. Create and configure lists. Assign permissions and access rights. Create and configure a communication site. Implement workflows with Forms and Flow. This course will empower you to use Microsoft© SharePoint© online to facilitate collaboration and allow you to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. Enable and configure SharePoint?s many distinct features and discover the many content structures that can be selected, added, and configured. Learn how to create, configure, and manage SharePoint sites so that your team or organization can share information and collaborate effectively.SharePoint content structures and configuration options are complex. As a site owner, it is critical that you understand what features, options, and content structures are available in SharePoint online, and how to properly configure them. With SharePoint sites, features, and content structures properly implemented, you will be able to securely share files, collaborate on documents, and access the information you need to work with your colleagues more effectively. Creating and Configuring a New Site Topic A: Create a Site in SharePoint Topic B: Configure Site Look and Layout Creating and Configuring Document Libraries Topic A: Create Document Libraries Topic B: Configure File Versioning and Checkout Topic C: Configure Content Approval Creating and Configuring Lists Topic A: Add List Apps to a Site Topic B: Create Custom Lists Topic C: Create Calculated and Validated Columns Assigning Permissions and Access Rights Topic A: Secure Sites with Permissions Topic B: Secure Apps, Documents, and Files Creating and Configuring a Communication Site Topic A: Create a Communication Site Topic B: Configure a Communication Site Implementing Workflows with Forms and Flow Topic A: Capture Data with Forms Topic B: Store Form Data in SharePoint with Flow Topic C: Automate Business Processes with Forms, Flow, and SharePoint

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

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