307 Microsoft Power Platform courses

In today's fast-paced business world, legal secretaries are in high demand. They're the backbone of a successful legal office, responsible for supporting lawyers and ensuring the smooth running of the office. With our Legal Secretary and Office Skills bundle, you'll learn everything you need to know to become an indispensable part of any legal team. Our comprehensive Diploma course covers legal office procedures, Microsoft Office essentials, and key skills like typing, note-taking, and proofreading. You'll also gain a deep understanding of employment and criminal law, document control, and data protection, making you an asset to any law firm. With the Contract Manager Diploma, you'll learn how to create and manage legal contracts, while our GDPR Data Protection course will ensure you're up to date on the latest regulations around data privacy. And, with 50 Tips to Upgrade Your Excel Skill, you'll be able to streamline your work and impress your colleagues with your proficiency in one of the most widely used office tools. By completing this bundle, you'll have the skills and knowledge to chase your dream to take on a role as a legal secretary, contract manager, compliance officer, or document controller. The legal sector is a rewarding field, and our Legal Secretary and Office Skills bundle is the perfect way to get started on the path to success. This Bundle Consists of the following Premium courses: Course 01: Legal Secretary and Office Skills Diploma Course 02: Employment Law Level 3 Course 03: Criminal Law Course 04: Compliance Training Level 2 Course 05: Contract Manager Diploma Course 06: Document Control Course 07: Workplace Confidentiality Course 08: GDPR Data Protection Level 5 Course 09: Security Management Advanced Diploma Course 10: Conflict Management Course 11: 50 Tips to Upgrade your Excel Skill Learning Outcome At the end of this bundle, learners will be able to - Gain knowledge and skills of a legal secretary. Learn essential software skills such as Microsoft Word, PowerPoint, Outlook, and Excel. Develop effective office skills required for a successful career as a legal secretary. Understand the principles and regulations of employment and criminal law. Gain knowledge and skills in compliance, contract management and document control. Develop an understanding of workplace confidentiality and data protection. Enhance conflict management and security management skills. Improve Excel proficiency with 50 tips for upgrading skills. How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Legal Secretary and Office Skills expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum: Course 01: Legal Secretary and Office Skills Diploma Legal Secretary Microsoft Word Essentials Microsoft PowerPoint Essentials Microsoft Outlook Essentials Microsoft Excel - Top 50 Keyboard Shortcuts CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is suitable for individuals who aspire to work as legal secretaries or administrative professionals in a legal setting. It is also useful for those who want to improve their knowledge of office software and become proficient in Microsoft Word, PowerPoint, Excel, and Outlook. Additionally, this course can benefit individuals who want to pursue a career in compliance, security management, or contract management. Requirements This and Office Skills course has been designed to be fully compatible with tablets and smartphones. Career path Legal Secretary: £18,000 - £30,000 per year Compliance Officer: £22,000 - £45,000 per year Contract Manager: £28,000 - £58,000 per year Document Controller: £20,000 - £40,000 per year Security Manager: £25,000 - £60,000 per year Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Legal Secretary and Office Skills Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Supercharge your career with our comprehensive RPA UiPath developer course and dive into real projects to master UiPath, gain unwavering confidence, and pave your way to success. Elevate your career prospects with access to an extensive resource of 100+ RPA UiPath interview questions and become a highly proficient RPA expert today.

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now! Why is Microsoft important in the workplace? From project management to office coordination, having a stronger command of Microsoft Word, Excel, PowerPoint, Teams, Power BI, OneDrive, and other programmes will benefit your organisation and your work. Also, Microsoft skills can make your work life so much easier that you can complete your tasks in minutes that would take others hours. So enhance your skills and become that go-to guy everyone envies. Industry experts have developed this bundle, which has already helped many learners like you. So, If you want to learn how to use the most popular Microsoft tools, you don't need to look any further than this bundle. This bundle is the only thing you need to go from a complete novice to a skilled Microsoft user. So, enrol in this all-in-one bundle and start learning today. Along with this course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Microsoft SQL Server Development for Everyone Course 02: MS Word Diploma Course 03: Advanced Diploma in MS Excel Course 04: PowerPoint Diploma Course 05: The Complete Microsoft OneDrive Course Course 06: The Complete Microsoft Outlook Masterclass Course 07: New Functions in Microsoft Excel 2021 Course 08: Complete Microsoft Power BI 2021 Course 09: Microsoft Teams Course 10: Outlook Tips and tricks Course 11: Touch Typing Essentials How will I get my Certificate? After successfully completing the Course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Our course is suitable for all. Requirements This course has no prior requirements. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Office Administrator PA Secretary Office Worker Manager And much more... Certificates Certificate of completion Digital certificate - Included

Give a compliment to your career and take it to the next level. This Big Data will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this bundle will help you stay ahead of the pack. Throughout the Big Data programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Big Data course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Big Data Bundle Consists of the following Premium courses: Course 01: SQL NoSQL Big Data and Hadoop Course 02: Complete Microsoft Power BI 2021 Course 03: Introduction to Data Analysis Course 04: Python for Data Analysis Course 05: Statistical Analysis Course 06: Data Analytics with Tableau Course 07: Basic Google Data Studio Course 08: Fundamentals of Business Analysis Course 09: Complete Introduction to Business Data Analysis Level 3 Course 10: Business Intelligence and Data Mining Masterclass Course 11: Research Methods in Business Enrol now in Big Data to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Big Data expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. CPD 135 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Big Data bundle. Requirements This Big Data course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Title Course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

The 'Microsoft PowerPoint for Beginners' course is designed to introduce learners to the fundamentals of creating and delivering compelling presentations using PowerPoint. It covers navigation, presentation development, advanced text editing, adding graphical elements, modifying objects, incorporating tables and charts, and preparing for a successful presentation delivery. Learning Outcomes: Navigate the PowerPoint environment and efficiently view and navigate through presentations. Create, edit, and save PowerPoint presentations, utilizing PowerPoint's help and support resources. Develop a presentation, select presentation types, and effectively build slides with text and graphical elements. Perform advanced text editing, including formatting characters, paragraphs, and text boxes. Add images, shapes, and other graphical elements to enhance the visual appeal of the presentation. Modify and format objects, group them, arrange their positions, and apply animations for dynamic effects. Incorporate tables and charts into presentations, create, format, and import data from other Microsoft Office applications. Review, apply transitions, print, and prepare to deliver the presentation confidently and professionally. Why buy this Microsoft PowerPoint for Beginners? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft PowerPoint for Beginners there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft PowerPoint for Beginners course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Microsoft PowerPoint for Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft PowerPoint for Beginners was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft PowerPoint for Beginners is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Getting Started with PowerPoint Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Developing a PowerPoint Presentation Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Performing Advanced Text Editing Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Adding Graphical Elements to Your Presentation Insert Images 00:10:00 Insert Shapes 00:15:00 Modifying Objects in Your Presentation Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Adding Tables to Your Presentation Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Adding Charts to Your Presentation Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Preparing to Deliver Your Presentation Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Assignment Assignment - Microsoft PowerPoint for Beginners 00:00:00

Give a compliment to your career and take it to the next level. This Master Microsoft Office Beginner to Advanced will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Master Microsoft Office Beginner to Advancedbundle will help you stay ahead of the pack. Throughout the Master Microsoft Office Beginner to Advanced programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Master Microsoft Office Beginner to Advanced course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Master Microsoft Office Beginner to Advanced Bundle Consists of the following Premium courses: Course 01: Level 2 Microsoft Office Essentials Course 02: MS Word Diploma Course 03: Advanced Diploma in MS Excel Course 04: 50 Tips to Upgrade your Excel Skill Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Data Analysis in Microsoft Excel Complete Training Course 09: The Complete Microsoft Outlook Masterclass Course 10: Complete Microsoft Power BI 2021 Course 11: Microsoft Teams Enrol now in Master Microsoft Office Beginner to Advanced bundle to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Master Microsoft Office Beginner to Advanced expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Master Microsoft Office Beginner to Advanced bundle. Requirements This Master Microsoft Office Beginner to Advanced course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 2 Microsoft Office Essentials) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Master the Basics of Microsoft Power Automate is a comprehensive course designed to provide learners with a foundational understanding of Power Automate, Microsoft's automation platform. The course covers essential concepts and practical applications to streamline processes and automate tasks effectively. Learning Outcomes: Understand the fundamentals of Microsoft Power Automate and how to access the platform. Create and test template flows to automate basic tasks efficiently. Gain knowledge of various connectors and flow types to customize automation solutions. Implement automation for specific scenarios, such as the Book Order Tracker Automation. Why buy this Master the Basics of Microsoft Power Automate? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Master the Basics of Microsoft Power Automate there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Master the Basics of Microsoft Power Automate course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Master the Basics of Microsoft Power Automate does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Master the Basics of Microsoft Power Automate was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Master the Basics of Microsoft Power Automate is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Lesson 01: Learn Microsoft Power Automate Now Lesson 01: Learn Microsoft Power Automate Now 00:01:00 Lesson 02: Accessing Power Automate Lesson 02: Accessing Power Automate 00:02:00 Lesson 03: First Template Flow Lesson 03: First Template Flow 00:06:00 Lesson 04: Test run your first flow Lesson 04: Test run your first flow 00:03:00 Lesson 05: My Flows Lesson 05: My Flows 00:03:00 Lesson 06: Templates Overview Lesson 06: Templates Overview 00:04:00 Lesson 07: Connectors Overview Lesson 07: Connectors Overview 00:04:00 Lesson 08: Different Flow Types Lesson 08: Different Flow Types 00:05:00 Lesson 09: Test run your new flow Lesson 09: Test run your new flow 00:01:00 Lesson 10: Book Order Tracker Automation - Introduction Lesson 10: Book Order Tracker Automation - Introduction 00:03:00 Lesson 11: Book Order Tracker Automation Lesson 11: Book Order Tracker Automation 00:11:00

Are you embarking on the journey of mastering data analytics and visualisation in the UK? The 'Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7' is your beacon. Positioned to illuminate the intricate realm of Power BI, this course offers a comprehensive look into the foundational aspects and the advanced features that make Microsoft's tool a standout. With sections meticulously designed ranging from the fundamentals, like data transformation, to advanced concepts, such as integrating Power BI with Python and storytelling with data, this course ensures learners grasp the complete spectrum. With the rising emphasis on data analytics in today's business world, this course acquaints you with Power BI's prowess. It prepares you for the sought-after Microsoft Power BI certification in the UK. Learning Outcomes Comprehend the fundamental aspects of Power BI, from initiating a project to understanding the user interface. Develop proficiency in advanced data transformation techniques and data model creation. Integrate Python with Power BI and harness the benefits of both for enhanced data analytics. Master the art of 'Storytelling with Data' to deliver impactful presentations and reports. Understand and implement Row-Level Security and harness Power BI Cloud services efficiently. Why choose this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are 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. Who is this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 for? Individuals keen on obtaining the Microsoft power bi certification UK. Analysts and data professionals aspiring to enhance their data visualisation skills. Business professionals wanting to leverage Power BI for insightful business decision-making. Tech enthusiasts aiming to amalgamate programming (Python) with data analytics. Those seeking to stay updated with the latest trends in Power BI and its evolving capabilities. Career path Data Analyst: Average Salary £30,000 - £40,000 Annually Business Intelligence Developer: Average Salary £35,000 - £45,000 Annually Power BI Developer: Average Salary £40,000 - £50,000 Annually Data Visualisation Specialist: Average Salary £32,000 - £42,000 Annually Business Intelligence Manager: Average Salary £45,000 - £55,000 Annually Data Strategy Consultant: Average Salary £50,000 - £60,000 Annually Prerequisites This Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:03:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 00:00:00 Assignment Assignment - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00