Navigating the responsibilities of adult care requires more than just good intentions—it demands structure, sharp decision-making, and a clear understanding of the systems in place. This course is designed for those looking to confidently manage adult care settings with knowledge that actually makes sense in the day-to-day operations, whether you're overseeing a team or managing care provision remotely. It offers a focused journey through the critical areas of adult care management, from policy understanding to team coordination and effective planning. There’s no fluff here—just straight-to-the-point learning that respects your time and your goals. Whether you're new to the sector or bringing years of experience, the course delivers a well-rounded base that helps you take the reins with clarity. Designed for remote learning, it fits around your life while still delivering content that sticks. If you're serious about making adult care make more sense—this course is ready when you are. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Adult Care Module 02: Creating a Service Development Plan Module 03: Importance of Communication Module 04: Partnership Working Module 05: Supporting and Encouraging the Team Module 06: Supporting Education in Adult Care Module 07: Safeguarding in Adult Care Module 08: Managing Stress and Maintaining Well-Being Module 09: Overcoming Barriers in Adult Care Settings Learning Outcomes: Enhance adult care skills for optimal service provision. Foster productive teamwork and communication in care settings. Develop a robust service development plan tailored to individual needs. Safeguard and protect adults, ensuring their well-being. Overcome common barriers encountered in adult care settings. Maintain personal well-being and manage stress effectively. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring adult care professionals Individuals seeking to upskill in the care industry Caregivers and support workers Healthcare assistants and volunteers Social workers and case managers Anyone passionate about enhancing adult care skills Career path Adult Care Coordinator Care Support Worker Social Care Assistant Community Support Worker Care Team Leader Safeguarding Officer Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.
Understanding Marginal Costing Course is designed to help individuals grasp the vital concept of marginal costing, an essential tool in financial decision-making. In today’s competitive business landscape, understanding how to calculate and apply marginal costs allows businesses to optimise operations and increase profitability. This course simplifies complex financial theories and makes them accessible for anyone looking to gain a solid foundation in cost management, whether for career progression or enhancing business performance. By the end of the course, you’ll gain a clear understanding of how marginal costing contributes to pricing decisions, cost control, and profitability analysis. It offers a clear distinction between fixed and variable costs, enabling students to make more informed decisions when analysing profit margins. With flexible online access, this course allows you to learn at your own pace, diving deep into the techniques and formulas used by financial professionals to improve business strategies. Whether you’re aiming to advance in your career or strengthen your financial acumen, Understanding Marginal Costing provides the knowledge to confidently analyse and apply costing methods effectively. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Costing Methods Module 02: Understanding Marginal Costing Module 03: Cost Classification Module 4: Cost-Volume-Profit (CVP) Analysis Module 05: Decision-Making Using Marginal Costing Module 06: Contribution Margin Ratio and Profit Planning Module 07: Limitations and Criticisms of Marginal Costing Learning Outcomes Analyze costs effectively for informed decision-making. Utilize Marginal Costing strategically for financial planning. Classify costs adeptly to enhance decision-making capabilities. Implement Contribution Margin Ratio for profitable strategies. Grasp the limitations and criticisms of Marginal Costing. Enhance financial acumen for various professional pursuits. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Entrepreneurs seeking financial mastery. Finance enthusiasts eager to deepen their knowledge. Professionals aiming to enhance decision-making skills. Students pursuing a career in finance. Business managers seeking strategic financial insights. Aspiring analysts and consultants. Individuals preparing for financial roles. Anyone interested in mastering Marginal Costing principles. Career path Financial Analyst Management Accountant Business Consultant Cost Accountant Budget Analyst Entrepreneurial Ventures in Finance Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.
Health and Safety: Health and Safety at Work Online Unlock the Power of Health and Safety: Health and Safety at Work Course: Enrol Now! Every year, workplace accidents and injuries cost businesses millions of dollars and thousands of hours. They also have a significant and often lifelong impact on workers. Introducing a safety culture into your organisation, where safety is valued as an integral part of business operations, saves time and money and builds a committed, loyal, and healthy workforce. Our Health and Safety at Work: Health and Safety at Work course will lay the foundation for you to start building a safety culture. The Health and Safety at Work: Health and Safety at Work course covers a broad introduction to workplace health and safety, along with the value of establishing a safe working culture. Students will also learn to ensure their respective businesses and workplaces comply with all relevant laws and legislation. The Health and Safety: Health and Safety at Work provides lessons, modules, and quizzes to gain knowledge, and at the end, a Professional Certificate that assists in career development in professional life. Main Course: Level 5 Health and Safety at Work Courses are included with the Health and Safety at Work: Health and Safety at Work Course Course 01: Workplace First Aid Training Course 02: Working at Height Training Course Course 03: Level 2 Health and Safety in the Workplace Training [Note: Free PDF certificate as soon as completing the Health and Safety at Work: Health and Safety at Work course] Health and Safety: Health and Safety at Work Online This Level 5 Health and Safety at Work course consists of 12 modules. Course Curriculum of Level 5 Health and Safety at Work course Module 01: Foundations of Health and Safety at Work Module 02: Managing Health and Safety Module 03: Organising for Health and Safety Module 04: Health and Safety Culture Module 05: Health and Safety Policy Module 06: Risk Assessment Module 07: Workplace Hazards and Risk Control Module 08: Accidents and Emergencies Module 09: Vehicle Hazards and Risk Control Module 10: Fire Prevention and Protection Module 11: Electrical Safety Module 12: Managing the Safety Function Assessment Method of Health and Safety: Health and Safety at Work After completing Health and Safety: Health and Safety at Work Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Health and Safety: Health and Safety at Work After completing the Health and Safety: Health and Safety at Work course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Health and Safety: Health and Safety at Work Online This Health and Safety: Health and Safety at Work could be extremely beneficial to employees at all levels. From entry-level recruits to supervisors, managers, and business owners. Requirements Health and Safety: Health and Safety at Work Online To enroll in this Health and Safety: Health and Safety at Work Course, students must fulfill the following requirements: Good Command over English language is mandatory to enrol in our Health and Safety: Health and Safety at Work Course. Be energetic and self-motivated to complete our Health and Safety: Health and Safety at Work Course. Basic computer Skill is required to complete our Health and Safety: Health and Safety at Work Course. If you want to enrol in our Health and Safety: Health and Safety at Work Course, you must be at least 15 years old.
Team Leader: Team Leader Course Online Introducing Team Leader: Team Leader Course "Empowering the Next Generation" Online course! Leadership is not a skill that can be learned overnight; it takes effort, commitment, and time. However, our Team Leader: Team Leader Course can assist you in developing the qualities and skills required to be a successful, effective, and charismatic leader. If you want to learn Leadership and Management skills and advance your career, this advanced Team Leader: Team Leader Course is the best option for you. This Team Leader: Team Leader Course is ideal for you if you are already employed and managing as few as two employees or supervising a team of many employees, or if you want to start a promising career as a manager, or if you want to improve your readiness for a new business venture. The Team Leader: Team Leader Course also includes several teamwork modules. So, do not miss this opportunity to be an inspiring leader and visionary manager and take your career to new heights by enrolling in this Team Leader: Team Leader Course. Main Course: Level 7 Diploma in Leadership & Management Course Free Courses included with Team Leader: Team Leader Course: Course 01: Level 5 Diploma in Risk Management Course 02: Equality and Diversity Course 03: Level 7 Project Management Course 04: Level 7 Operations Management Course 05: Level 4 Time Management Special Offers of this Team Leader: Team Leader Course: This Team Leader: Team Leader Course includes a FREE PDF Certificate. Lifetime access to this Team Leader: Team Leader Course Instant access to this Team Leader: Team Leader Course 24/7 Support Available to this Team Leader: Team Leader Course [ Note: Free PDF certificate as soon as completing Team Leader: Team Leader Course] Team Leader: Team Leader Course Online This Team Leader: Team Leader Course consists of 10 modules. Course Curriculum of Team Leader: Team Leader Course Module 01: Understanding Management and Leadership Module 02: Leadership over Yourself Module 03: Creativity and Innovation Module 04: Leadership and Teambuilding Module 05: Motivation and People Management Module 06: Communication and Leadership Module 07: Presentation, One-to-one Interview and Meeting Management Module 08: Talent Management Module 09: Strategic Leadership Module 10: Stress Management Assessment Method of Team Leader: Team Leader Course After completing Team Leader: Team Leader Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Team Leader: Team Leader Course After completing the Team Leader: Team Leader Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Team Leader: Team Leader Course Online This Team Leader: Team Leader Course is for anyone serious about their professional development. This Team Leader: Team Leader Course is designed primarily for group leaders, managers at all levels, and business professionals. However, students and recent graduates who want to improve their resumes and gain experience are also welcome to enrol in this Team Leader: Team Leader Course. Requirements Team Leader: Team Leader Course Online To enrol in this Team Leader: Team Leader Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Team Leader: Team Leader Course. Be energetic and self-motivated to complete our Team Leader: Team Leader Course. Basic computer Skill is required to complete our Team Leader: Team Leader Course. If you want to enrol in our Team Leader: Team Leader Course, you must be at least 15 years old.
Restaurant Management: Restaurant Management Course Online Introducing the Ultimate Restaurant Management: Restaurant Management Online Course! Are you ready to take your passion for food and hospitality to new heights? Do you dream of owning and managing your own successful restaurant? Look no further! Our comprehensive Restaurant Management: Restaurant Management Course is here to equip you with the knowledge and skills you need to excel in the exciting world of restaurant management. This Restaurant Management: Restaurant Management Course is designed for aspiring restaurant owners, managers, and industry professionals who are ready to elevate their careers and make their mark in the competitive culinary landscape. Whether you're starting from scratch or looking to enhance your existing expertise, our Restaurant Management: Restaurant Management Course has something to offer everyone. Don't miss out on this golden opportunity to take this exclusive Restaurant Management: Restaurant Management Course and unlock your potential and become a successful restaurant manager or owner. Enroll in our Restaurant Management: Restaurant Management Course today and embark on an exciting journey towards a thriving culinary career! Why choose this Restaurant Management: Restaurant Management Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Restaurant Management: Restaurant Management Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Restaurant Management: Restaurant Management Course Main Course: Restaurant Management Course Free Course included with Restaurant Management: Restaurant Management Course Course 01: Level 5 Interior Design Course 02: Level 5 Professional Chef Course 03: British Cleaning Diploma Course 04: HACCP Course Course 05: Food Hygiene and Safety [ Note: Free PDF certificate as soon as completing Restaurant Management: Restaurant Management Course] Restaurant Management: Restaurant Management Course Online This Restaurant Management: Restaurant Management Course consists of 16 modules. Course Curriculum of Restaurant Management: Restaurant Management Course Module 01: Introduction to the Restaurant Industry Module 02: Concept Development and Planning Module 03: Restaurant Design and Ambiance Module 04: Menu Development and Management Module 05: Food and Beverage Service Module 06: Food Poisoning and Control Measures Module 07: Operations Management Module 08: Marketing and Promotion Module 09: Financial Management Module 10: Legal and Regulatory Compliance Module 11: Technology and Innovation Module 12: Global and Cultural Perspectives Module 13: Entrepreneurship and Leadership Module 14: Staff Development Module 15: Industry Trends and Future Directions Module 16: Developing a Career in Restaurant Management Assessment Method of Restaurant Management: Restaurant Management Course After completing Restaurant Management: Restaurant Management Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Restaurant Management: Restaurant Management Course After completing the Restaurant Management: Restaurant Management Course, you can instantly download your certificate for FREE. Who is this course for? Restaurant Management: Restaurant Management Course Online This Restaurant Management: Restaurant Management Course is open to everyone. Requirements Restaurant Management: Restaurant Management Course Online To enrol in this Restaurant Management: Restaurant Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Restaurant Management: Restaurant Management Course. Be energetic and self-motivated to complete our Restaurant Management: Restaurant Management Course. Basic computer Skill is required to complete our Restaurant Management: Restaurant Management Course. If you want to enrol in our Restaurant Management: Restaurant Management Course you must be at least 15 years old. Career path Restaurant Management: Restaurant Management Course Online Restaurant manager: £30,000 - £35,000 per annum
Chef: Chef Training Online Are you passionate about culinary arts and dream of becoming a Professional Chef? Look no further! Introducing our comprehensive and highly acclaimed course Chef: Chef Training. The School of Healthcare understands that the journey to becoming a renowned chef begins with a strong foundation in culinary skills. Our Professional Chef: Chef Training course is specifically designed to equip aspiring chefs like you with the knowledge and expertise needed to excel in the dynamic world of gastronomy. Benefits of taking our Chef: Chef Training Course Comprehensive Curriculum: Our Chef: Chef Training course covers all aspects of culinary arts, providing you with a well-rounded education. From fundamental cooking techniques to advanced culinary concepts, we leave no stone unturned. Flexibility and Convenience: With our online platform, you can access the Chef: Chef Training course materials at your own pace and convenience. Whether you are a full-time working professional or a busy parent, our flexible schedule of this Chef: Chef Training course allows you to pursue your culinary dreams without compromising your other commitments. Upon completion of the Chef: Chef Training course, you will possess a diverse skill set that prepares you for a successful career in the culinary industry. Whether you aspire to work in a fine dining establishment, open your own restaurant, or become a private chef, our Chef: Chef Training course will provide you with the necessary tools to thrive. Don't let your culinary dreams simmer on the back burner. Enrol in our Chef: Chef Training online course today and take the first step towards a fulfilling career in the world of gastronomy! [ Note: Free PDF certificate as soon as completing Chef: Chef Training Course] Chef: Chef Training Online This Chef: Chef Training course consists of 15 modules. Course Curriculum of Chef: Chef Training Course Module 01: Introduction to Culinary Arts Module 02: Knife Skills and Basic Techniques Module 03: Stocks, Sauces, and Soups Module 04: Culinary Foundations: Vegetables and Fruits Module 05: Culinary Foundations: Meat, Poultry, and Seafood Module 06: Culinary Foundations: Grains, Legumes, and Pasta Module 07: Culinary Techniques: Sautéing, Roasting, and Grilling Module 08: Culinary Techniques: Braising, Stewing, and Steaming Module 09: Baking and Pastry Fundamentals Module 10: International Cuisine Module 11: Menu Planning and Recipe Development Module 12: Food Safety and Sanitation Module 13: Operations Management Chef Module 14: Plating and Presentation Techniques Module 15: Culinary Entrepreneurship and Career Development Assessment Method of Chef: Chef Training After completing Professional Chef: Chef Training Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Chef: Chef Training After completing the Chef: Chef Training course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Chef: Chef Training Online This Chef: Chef Training Course is Open to Everyone. Requirements Chef: Chef Training Online To enrol in this Chef: Chef Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Chef: Chef Training Course. Be energetic and self-motivated to complete our Chef: Chef Training Course. Basic computer Skill is required to complete our Chef: Chef Training Course. If you want to enrol in our Chef: Chef Training Course, you must be at least 15 years old. Career path Chef: Chef Training Online After completing this Chef: Chef Training course, you may able to pursue a variety of promising career opportunities, such as: Culinary education, apprenticeship, executive chef, restaurant owner, private chef, culinary instructor, food consultant, cookbook author, TV personality.
Level 5 Professional Chef Are you passionate about culinary arts and dream of becoming a Professional Chef? Look no further! Introducing our comprehensive and highly acclaimed course Professional Chef. The School of Healthcare understands that the journey to becoming a renowned chef begins with a strong foundation in culinary skills. Our Professional Chef course is specifically designed to equip aspiring chefs like you with the knowledge and expertise needed to excel in the dynamic world of gastronomy. Benefits of taking our Professional Chef Course Comprehensive Curriculum: Our Professional Chef course covers all aspects of culinary arts, providing you with a well-rounded education. From fundamental cooking techniques to advanced culinary concepts, we leave no stone unturned. Expert Instructors: Learn about Professional Chef from seasoned industry professionals who have honed their craft in renowned restaurants and culinary institutions. Our instructors bring a wealth of knowledge and practical experience to the virtual classroom, ensuring you receive top-notch guidance. Flexibility and Convenience: With our online platform, you can access the Professional Chef course materials at your own pace and convenience. Whether you are a full-time working professional or a busy parent, our flexible schedule of this Professional Chef course allows you to pursue your culinary dreams without compromising your other commitments. Upon completion of the Professional Chef course, you will possess a diverse skill set that prepares you for a successful career in the culinary industry. Whether you aspire to work in a fine dining establishment, open your own restaurant, or become a private chef, our Professional Chef course will provide you with the necessary tools to thrive. Don't let your culinary dreams simmer on the back burner. Enrol in our Professional Chef online course today and take the first step towards a fulfilling career in the world of gastronomy! [ Note: Free PDF certificate as soon as completing the Level 5 Professional Chef Course] Level 5 Professional Chef Course Curriculum of Level 5 Professional Chef Course Module 1: Introduction to Culinary Arts Module 2: Knife Skills and Basic Techniques Module 3: Stocks, Sauces, and Soups Module 4: Culinary Foundations: Vegetables and Fruits Module 5: Culinary Foundations: Meat, Poultry, and Seafood Module 6: Culinary Foundations: Grains, Legumes, and Pasta Module 7: Culinary Techniques: Sautéing, Roasting, and Grilling Module 8: Culinary Techniques: Braising, Stewing, and Steaming Module 9: Baking and Pastry Fundamentals Module 10: International Cuisine Module 11: Menu Planning and Recipe Development Module 12: Food Safety and Sanitation Module 13: Operations Management Module 14: Plating and Presentation Techniques Module 15: Culinary Entrepreneurship and Career Development Assessment Method of Level 5 Professional Chef Course After completing Level 5 Professional Chef Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Level 5 Professional Chef Course After completing the Level 5 Professional Chef Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Level 5 Professional Chef This Professional Chef Course is open to everyone. Requirements Level 5 Professional Chef To enrol in this Level 5 Professional Chef Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Level 5 Professional Chef Course. Be energetic and self-motivated to complete our Level 5 Professional Chef Course. Basic computer Skill is required to complete our Level 5 Professional Chef Course. If you want to enrol in our Level 5 Professional Chef Course, you must be at least 15 years old. Career path Level 5 Professional Chef This Level 5 Professional Chef course can open exciting career opportunities in various fields related such as: Chef Sous Chef Line Cook Pastry Chef Catering Manager
Get the best management assignment help and management course guide online by Uk management experts.
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Microsoft Power BI Masterclass 2021 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Microsoft Power BI Masterclass 2021 Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Power BI Masterclass 2021 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Microsoft Power BI Masterclass 2021 Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Microsoft Power BI Masterclass 2021? 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 Power BI Masterclass 2021 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 Power BI Masterclass 2021 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 Power BI Masterclass 2021 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Power BI Masterclass 2021 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 Power BI Masterclass 2021 is a great way for you to gain multiple skills from the comfort of your home. 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:02: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 - Microsoft Power BI Masterclass 2021 00:00:00 Assignment Assignment - Microsoft Power BI 00:00:00