306 Microsoft Power Apps courses

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.

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! 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 paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Strong leaders are the foundation of any successful business. A Leader can make or break a team, so enhancing or solidifying your leadership skills is crucial to being the best leader you can be. Around 49% of all employees in the UK at some point quit their jobs because of their lack of Leadership and management. With step-by-step instructions from our Leadership & Management Level 7 Advance Diploma, you will avoid all the mistakes that most managers/ leaders make and become an ideal leader who inspires, motivates & achieves goals by properly managing employees. This Advanced Diploma in Leadership & Management at QLS Level 7 course is endorsed by The Quality Licence Scheme & Accredited by CPD (with 250 CPD points) to make your skill development & career progression more accessible than ever! The Leadership & Management Level 7 Advanced Diploma Offers the Following Courses with Free Certificate: Course 01: Strategic Business Management Course 02: Financial Management Course 03: Diploma in Performance Analysis Course 04: Unconscious Bias Training Course 05: Decision-Making in High-Stress Situations In this Leadership Management & Team Leader Level 7 Advanced Diploma Training Programme, you learn about different Leadership Management styles & which one will suit you best. You find out how to create a high-performance team that can always get things done, along with detailed lessons on managing office politics, negotiating, communicating, succession planning & much more. Learning Outcomes of This Leadership Management & Team Leader Level 7 Advanced Diploma Course: The learning objectives for this Leadership Management & Team Leader Level 7 Advanced Diploma Training course are broken down in detail below. After finishing the course, you will: Understand the fundamental concepts and significance of leadership management. Explore key leadership theories and their applicability in organizational settings. Enhance leadership performance through evaluation and actionable strategies. Build, nurture, and sustain high-performing team dynamics. Master strategies to motivate employees and boost morale. Develop organizational skills crucial for effective leadership management. Learn to identify, acquire, and integrate top talent effectively. Design and implement strategic succession planning initiatives. Optimize business processes for efficiency and productivity. Enhance communication skills tailored for leadership roles. Acquire effective negotiation techniques for leadership scenarios. Utilize Microsoft Office tools for effective leadership management tasks. Optimize time management for leadership effectiveness and efficiency. Navigate office politics while maintaining professional integrity and much more Why Prefer Our Leadership Management & Team Leader Level 7 Advanced Diploma Course? Level 7 Quality Licence Scheme Endorsed 30 DAYS UNCONDITIONAL MONEY BACK GUARANTEE CPD Certified Course Free e-Certificates and Student ID Card Innovative and engaging content Free Assessments 24/7 Exper Tutor Support Student Testimonials - What Our Students Say! ''An excellent and insightful course on Leadership and Management. The course is well-structured and engaging. Two thumbs up :)'' Reviewed by LOUIS BOBB ''Lots of good in-depth knowledge, easily accessible, well structured and clearly set out. A joy to work with.'' Reviewed by Kevin Reid ''Great contents. I will highly recommend it.'' Reviewed by Stephen Oparah So enrol now in this Leadership Management & Team Leader course today to Advance your career! Leadership Management & Team Leader Level 7 Advanced Diploma Course Curriculum of Leadership Management & Team Leader Level 7 Advanced Diploma Leadership Management Module 01: Introduction to Leadership Management Leadership Management Module 02: Leadership Management Theories Leadership Management Module 03: Improving Leadership Performance Leadership Management Module 04: High-Performance Teams Leadership Management Module 05: Motivating Employees Leadership Management Module 06: Organisational Skills Leadership Management Module 07: Talent Acquisation Leadership Management Module 08: Succession Planning Leadership Management Module 09: Business Process Optimisation Leadership Management Module 10: Communication Skills Leadership Management Module 11: Negotiation Techniques Leadership Management Module 12: Managing Meetings and Giving Feedback Leadership Management Module 13: Managing Change Leadership Management Module 14: Time Management Leadership Management Module 15: Dealing with Stress Situations Leadership Management Module 16: Emotional Intelligence Leadership Management Module 17: Managing Conflict Leadership Management Module 18: Dealing with Office Politics Leadership Management Module 19: Risk Assessment Leadership Management Module 20: Corporate Responsibility and Ethics Leadership Management Module 21: Microsoft Word, Excel, PowerPoint CPD 320 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Leadership Management & Team Leader Level 7 Advanced Diploma For leaders and high potential managers to upgrade their capacity to deal with competence and lead for individual and organisational achievement. Entrepreneurs. Business owners. Anyone who wants to be a great leader. Requirements Our Leadership Management & Team Leader Level 7 Advanced Diploma course is open to all. Career path Our Leadership Management & Team Leader Level 7 Advanced Diploma course will open the door to opportunities. General Manager Director Human Resources Managers Operation Manager Supervisor Administrative Services Manager

Duration 1 Days 6 CPD hours This course is intended for The student should be familiar with Excel and the concepts of datasets and basic reporting. Overview Understand and utilize Power BI Online. Understand and examine the differences between Power BI Desktop and Power BI Online. Understand and explore the Power BI Online interface. Understand and perform importing Excel worksheets, CSV, TXT, PBIX. Understand connecting to databases. Understand other forms of data. Understand data refresh. Understand and perform creating a new Power BI report. Understand and perform adding filters to a report. Understand and perform adding KPI's to a report. Understand and perform creating a Power BI dashboard. Understand and perform pinning tiles. Understand sharing reports and dashboards. Understand Power BI Mobile. This Logical Operations courseware is no longer available on the LO Store, but can be purchased by phone orderThis one-day course familiarizes the student with Power BI Online, which allows the student to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources. COURSE OVERVIEW Introduction Course Materials Facilities Prerequisites What We'll Be Discussing INTRODUCTION TO POWER BI ONLINE What is Power BI Online Examining the Differences Between Power BI Desktop and Power BI Online Exploring the Power BI Online Interface IMPORTING DATA Utilizing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files Connecting to Databases Examining Other Forms of Data Understanding Data Refresh CREATING REPORTS Creating a New Power BI Report Adding Filters to a Power BI Report Adding KPI?s to a Report CONFIGURING DASHBOARDS Creating a Power BI Dashboard Pinning Tiles SHARING REPORTS AND DASHBOARDS Sharing Reports and Dashboards Exploring Power BI Mobile

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

Microsoft Power BI training courses at Introduction and Intermediate levels. Click on the link below to view full details: Power BI courses

Duration 2 Days 12 CPD hours This course is intended for This course is designed for individuals willing to learn about Microsoft Cloud for Sustainability. It is targeting and will be most beneficial to the following two roles: cloud specialist and sustainability industry technologist.ÿ As a result of attending this course, the learner should be able to understand the sustainability concepts and how the business thinks of tracking and reporting emissions, describe Microsoft Cloud for Sustainability customer scenarios, and configure the features of Microsoft Sustainability Manage. Prerequisites AZ-900T00 Microsoft Azure Fundamentals and PL-900T00 Microsoft Power Platform Fundamentals PL-900T00 Microsoft Power Platform Fundamentals 1 - Set up your training environmentPL-900T00 Microsoft Power Platform Fundamentals 2 - Microsoft Cloud for Sustainability overview Key concepts in sustainability Microsoft?s sustainability journey About Microsoft Cloud for Sustainability 3 - Microsoft Sustainability Manager concepts Organization setup Data ingestion Reference data for Sustainability Manager Emissions calculations Calculation profiles Libraries and factor mappings Factor mappings Analytical reports Sustainability scorecards and goals PL-900T00 Microsoft Power Platform Fundamentals Additional course details:PL-900T00 Microsoft Power Platform Fundamentals Nexus Humans IC-002T00: Microsoft Cloud for Sustainability 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 IC-002T00: Microsoft Cloud for Sustainability 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 4 Days 24 CPD hours This course is intended for Candidates should be familiar with Dynamics 365 Customer Insights and have firsthand experience with one or more additional Dynamics 365 apps, Power Query, Microsoft Dataverse, Common Data Model, and Microsoft Power Platform. They should also have working knowledge of practices related to privacy, compliance, consent, security, responsible AI, and data retention policy. Overview After completing this course, you will be able to: Clean, transform, and ingest data into Dynamics 365 Customer Insights Create a unified customer profile Work with Dynamics 365 Audience insights Enrich data and predictions Set up and manage external connections Administer and monitor Customer Insights Customer Data Platform specialists implement solutions that provide insight into customer profiles and that track engagement activities to help improve customer experiences and increase customer retention. In this course, students will learn about the Dynamics 365 Customer Insights solution, including how to unify customer data with prebuilt connectors, predict customer intent with rich segmentation, and maintain control of customer data. This specialty course starts with creating a unified profile and then working with customer data. Module 1: Get started with Dynamics 365 Customer Insights Introduction to the customer data platform Administer Dynamics 365 Customer Insights Explore user permissions in Dynamics 365 Customer Insights Module 2: Ingest data into Dynamics 365 Customer Insights Import and transform data Connect to data sources Work with data Module 3: Create a unified customer profile in Dynamics 365 Customer Insights Map data Match data Merge data Find customers Module 4: Work with Dynamics 365 Customer Insights Explore Audience insights Define relationships and activities Work with measures Work with segments Module 5: Enrich data and predictions with Audience insights Enrich data Use predictions Use machine learning models Module 6: Manage external connections with Customer Data Platform Export Customer Insights data Use Customer Insights with Microsoft Power Platform Display Customer Insights data in Dynamics 365 apps More ways to extend Customer Insights

MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.

Duration 2 Days 12 CPD hours This course is intended for This is an Intermediate PowerBI course geared for experienced users who wish to leverage the tool's more advanced capabilities Overview This course is about 50% hands-on lab and 50% lecture, designed to train attendees in essential PowerBI data handling functions and reporting skills, coupling the most current, effective techniques with the soundest practices. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses. Working in a hands-on learning environment led by our expert facilitator, students will learn how to: Create Advanced Power BI Reports Advanced understanding of the data schemas and extracting data Perform advanced transformations of data or any data schema Utilize time-phased data in the creation of complex analyses Create new measures using DAX Filter data using row-level security Create and deploy content packs Use Power BI to integrate with line-of-business applications Next Level Power BI for Experienced Users is a two day, course that provides attendees already experienced with Microsoft Power BI basics with a hands-on exploration of intermediate and beyond level features. This course is geared for attendees ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise?s other line-of-business tools. Get Project Online Data Select and mine relevant tables with ODATA Advanced ODATA data mining Importing other data formats Advanced Editing of data queries Advanced Data Transformations Managing table relationships Creating & using data hierarchies Creating custom columns and measures and metrics for filtering and reporting Creating Power BI Reports Using advanced visualizations Configuring drill-down Modifying visual interactions Importing and creating custom visuals Configure Power BI Security Creating Dashboard and row-level security Utilizing Filtering using row-level security Publishing Reports and Dashboards Building Mobile Reporting Creating and deploying content packs Configuring natural language query