4824 Courses in Sheffield delivered Live Online

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service 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 Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

A standalone 10-week quilling course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! All materials and equipment needed will be supplied and are yours to keep. This course is helpful for those for whom English is not their native tongue as there is a lot of repetition of basic terms including numbers, colours and directions.

A standalone 10-week quilling course - 2 hours per week online with daytime and evening options - that will introduce you to the materials, tools, and techniques used in quilling and to Craft4Smiles C.I.C and our tutors. At the end of each session you will have a lovely quilled item to show family and friends or to display on your shelf! All materials and equipment needed will be supplied and are yours to keep. This course is helpful for those for whom English is not their native tongue as there is a lot of repetition of basic terms including numbers, colours and directions.

If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on the core values of customer service.

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

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

Duration 1 Days 6 CPD hours This course is intended for This course is designed for candidates looking to demonstrate foundational-level knowledge of cloud-based solutions to facilitate productivity and collaboration on-site, at home, or a combination of both.ÿCandidates may have knowledge of cloud-based solutions or may be new to Microsoft 365. Overview After completing this course, students will be able to: Describe cloud concepts Describe core Microsoft 365 services and concepts Describe security, compliance, privacy, and trust in Microsoft 365 Describe Microsoft 365 pricing and support This course introduces Microsoft 365, an integrated cloud platform that delivers industry-leading productivity apps along with intelligent cloud services, and world-class security. You?ll learn foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings. You will begin by learning about cloud fundamentals, including an overview of cloud computing. You will be introduced to Microsoft 365 and learn how Microsoft 365 solutions improve productivity, facilitate collaboration, and optimize communications. The course then analyzes how security, compliance, privacy, and trust are handled in Microsoft 365, and it concludes with a review of Microsoft 365 subscriptions, licenses, billing, and support. 1 - Describe cloud computing What is cloud computing Describe the shared responsibility model Define cloud models Describe the consumption-based model 2 - Describe the benefits of using cloud services Describe the benefits of high availability and scalability in the cloud Describe the benefits of reliability and predictability in the cloud Describe the benefits of security and governance in the cloud Describe the benefits of manageability in the cloud 3 - Describe cloud service types Describe Infrastructure as a Service Describe Platform as a Service Describe Software as a Service 4 - What is Microsoft 365? Describe the differences between Office 365 and Microsoft 365 Describe Windows 365 Describe how Microsoft 365 empowers workers in this hybrid world of work Explore Microsoft 365 tenant 5 - Describe productivity solutions of Microsoft 365 Describe the productivity capabilities and benefits of Microsoft 365 Describe Microsoft 365 Apps Describe work management tools in Microsoft 365 Describe additional Microsoft 365 productivity apps 6 - Describe collaboration solutions of Microsoft 365 Describe the collaboration capabilities and benefits of Microsoft 365 Describe how Microsoft Teams promotes collaboration and enhances teamwork Describe the Microsoft Viva apps Describe how Yammer helps communities connect and grow 7 - Describe endpoint modernization, management concepts, and deployment options in Microsoft 365 Describe the endpoint management capabilities of Microsoft 365 Compare the differences of Windows 365 and Azure Virtual Desktop Describe the deployment and release models for Windows-as-a-Service (WaaS) Identify deployment methods and update channels for Microsoft 365 Apps 8 - Describe analytics capabilities of Microsoft 365 Describe the capabilities of Viva Insights Describe the capabilities of the Microsoft 365 admin center and Microsoft 365 user portal Describe the reports available in the Microsoft 365 admin center and other admin centers 9 - Describe the services and identity types of Azure AD Describe Azure Active Directory Describe the available Azure AD editions Describe Azure AD identity types Describe the types of external identities Describe the concept of hybrid identity 10 - Describe the access management capabilities of Azure AD Describe Conditional Access in Azure AD Describe the benefits of Azure AD roles and role-based access control 11 - Describe threat protection with Microsoft 365 Defender Describe Microsoft 365 Defender services Describe Microsoft Defender for Office 365 Describe Microsoft Defender for Endpoint Describe Microsoft Defender for Cloud Apps Describe Microsoft Defender for Identity Describe the Microsoft 365 Defender portal 12 - Describe security capabilities of Microsoft Sentinel Describe how Microsoft Sentinel provides integrated threat management Understand Sentinel costs 13 - Describe the compliance management capabilities in Microsoft Purview Describe the Microsoft Purview compliance portal Describe Compliance Manager Describe use and benefits of compliance score 14 - Describe the Service Trust Portal and privacy at Microsoft Describe the Service Trust Portal Describe Microsoft's privacy principles Describe Microsoft Priva 15 - Describe Microsoft 365 pricing, licensing, and billing options Explore pricing models for Microsoft cloud services Explore the billing and bill management options Explore the available licensing and management options 16 - Describe support offerings for Microsoft 365 services Explore support options for Microsoft 365 services Explain service level agreement (SLAs) concepts Identify how to track the service health status Explore how organizations can share feedback on Microsoft 365 services

E-Learning courses are self study courses which students can join from anywhere in the world.

Sketchup face to face training customised and bespoke.

Driver CPC - 1 Day Periodic 7 Hour Course Dangerous Awareness Course: - Identify the regulations governing safe transport of dangerous goods - Understand your role and responsibilities within the logistics supply chain - Master the principles of packing and transporting dangerous goods - Manage training requirements within your organisation - Comply with legal obligations - Demonstrate a strong commitment to safety and compliance 2. Working at Height Training: Gain knowledge on how to work safely at height, understand the risks involved, and learn how to use the appropriate safety equipment to prevent accidents. Driver CPC Periodic Training: Complete 7 hours of mandatory training to count towards your Driver Certificate of Professional Competence (CPC) periodic requirement, helping you stay compliant and up to date with industry standards. Register now for this valuable training! Please review our Terms and Conditions for more information.