Learn about Receptionist Diploma from industry experts and boost your professional skill. This Receptionist Diploma course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of Receptionist Diploma. You'll also gain the skills of Receptionist Diploma to excel in your job and tips to master professional skills in no time. You'll be connected with the community of Receptionist Diploma professionals and gain first-hand experience of Receptionist Diploma problem-solving. The Receptionist Diploma is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the Receptionist Diploma, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job. This Receptionist Diploma will provide you with the latest information and updates of Receptionist Diploma. It will keep you one step ahead of others and increase your chances of growth. Why buy this Receptionist Diploma? 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 Receptionist Diploma you will be able to take the MCQ test that will assess your knowledge. 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 Receptionist Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Receptionist Diploma 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 Receptionist Diploma is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Introduction to Reception and Receptionist Introduction to Reception and Receptionist 00:29:00 Module 02: Business Telephone Skills Business Telephone Skills 00:21:00 Module 03: Representing Your Boss and Company Representing Your Boss and Company 00:25:00 Module 04: Mail Services and Shipping Mail Services and Shipping 00:26:00 Module 05: Travel Arrangements Travel Arrangements 00:22:00 Module 06: Organising Meeting and Conferences Organising Meeting and Conferences 00:19:00 Module 07: Time Management Time Management 00:25:00 Module 08: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:24:00 Module 09: Business Writing Skills Business Writing Skills 00:25:00 Module 10: Communication Skills Communication Skills 00:19:00 Module 11: Customer Service Customer Service 00:22:00 Module 12: Effective Planning and Scheduling Effective Planning and Scheduling 00:39:00 Module 13: Invoicing/Petty Cash Invoicing/Petty Cash 00:20:00
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 Transcription (Audio Typing) Training 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 Transcription (Audio Typing) Training Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Transcription (Audio Typing) Training 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 Transcription (Audio Typing) Training 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 Transcription (Audio Typing) Training? 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 Transcription (Audio Typing) Training 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 Transcription (Audio Typing) Training 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 Transcription (Audio Typing) Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Transcription (Audio Typing) Training 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 Transcription (Audio Typing) Training is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Transcription Training Module 01: Introduction 00:05:00 Module 02: Transcription Comprehension 00:04:00 Module 03: A Comprehension Example 00:07:00 Module 04: Transcription Accuracy 00:05:00 Module 05: Accuracy Examples 00:08:00 Module 06: Common Homophones 00:05:00 Module 07: Transcription Formatting 00:07:00 Module 08: Speaker Labeling 00:04:00 Module 09: Spelling 00:03:00 Module 10: Advanced Module 00:20:00 Module 11: Useful Transcription Tools 00:03:00 Module 12: Where & How to Find Transcription Opportunities 00:08:00
The Payroll Manager and HR Management course offers comprehensive training in using Sage 50 Payroll software for beginners and intermediate users. Covering payroll basics, company settings, pension schemes, employee records, statutory payments, and year-end procedures, participants will gain proficiency in payroll processing and HR management using Sage 50 Payroll. Learning Outcomes: Understand payroll fundamentals, company settings, and legislative requirements. Master pension scheme basics, pay elements, and processing employee payments. Learn to handle employee records, generate reports, and navigate year-end procedures. Gain proficiency in handling timesheets, department analysis, and holiday schemes. Manage statutory sick pay, maternity pay, student loans, and workplace pensions. Explore managing company cars, holiday funds, and roll-back procedures. Understand password management, access rights, and linking payroll to accounts. Develop intermediate-level skills in Sage 50 Payroll, including global changes and advanced features. Why buy this Payroll Manager and HR Management? 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 Payroll Manager and HR Management you will be able to take the MCQ test that will assess your knowledge. 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? Aspiring payroll managers and administrators looking to gain Sage 50 Payroll skills. Human resource professionals aiming to enhance their payroll and HR management skills. Small business owners and managers responsible for payroll and employee management. Individuals seeking to enter the field of payroll processing and HR administration. Prerequisites This Payroll Manager and HR Management 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 Payroll Manager: Oversee payroll processing, employee records, and statutory payments. HR Manager: Manage HR operations, employee benefits, and compliance with payroll regulations. Payroll Administrator: Handle day-to-day payroll tasks, including processing payments and reports. Small Business Owner: Efficiently manage payroll and HR functions in a small business setting. HR Coordinator: Assist in HR tasks, employee records, and payroll administration. Course Curriculum Sage 50 Payroll for Beginners Module 1: Payroll Basics Payroll Basics 00:10:00 Module 2: Company Settings Company Settings 00:08:00 Module 3: Legislation Settings Legislation Settings 00:07:00 Module 4: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 5: Pay Elements Pay Elements 00:14:00 Module 6: The Processing Date The Processing Date 00:07:00 Module 7: Adding Existing Employees Adding Existing Employees 00:08:00 Module 8: Adding New Employees Adding New Employees 00:12:00 Module 9: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 10: Entering Payments Entering Payments 00:12:00 Module 11: Pre-Update Reports Pre-Update Reports 00:09:00 Module 12: Updating Records Updating Records 00:09:00 Module 13: e-Submissions Basics e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) Process Payroll (November) 00:16:00 Module 15: Employee Records and Reports Employee Records and Reports 00:13:00 Module 16: Editing Employee Records Editing Employee Records 00:07:00 Module 17: Process Payroll (December) Process Payroll (December) 00:12:00 Module 18: Resetting Payments Resetting Payments 00:05:00 Module 19: Quick SSP Quick SSP 00:09:00 Module 20: An Employee Leaves An Employee Leaves 00:13:00 Module 21: Final Payroll Run Final Payroll Run 00:07:00 Module 22: Reports and Historical Data Reports and Historical Data 00:08:00 Module 23: Year-End Procedures Year-End Procedures 00:09:00 Sage 50 Payroll Intermediate Level Module 1: The Outline View and Criteria Module 01: The Outline View and Criteria 00:11:00 Module 2: Global Changes Module 02: Global Changes 00:07:00 Module 3: Timesheets Module 03: Timesheets 00:12:00 Module 4: Departments and Analysis Module 04: Departments and Analysis 00:11:00 Module 5: Holiday Schemes Module 05: Holiday Schemes 00:10:00 Module 6: Recording Holidays Module 06: Recording Holidays 00:12:00 Module 7: Absence Reasons Module 07: Absence Reasons 00:13:00 Module 8: Statutory Sick Pay Module 08: Statutory Sick Pay 00:16:00 Module 9: Statutory Maternity Pay Module 09: Statutory Maternity Pay 00:17:00 Module 10: Student Loans Module 10: Student Loans 00:09:00 Module 11: Company Cars Module 11: Company Cars 00:13:00 Module 12: Workplace Pensions Module 12: Workplace Pensions 00:21:00 Module 13: Holiday Funds Module 13: Holiday Funds 00:13:00 Module 14: Roll Back Module 14: Process Payroll (November) 00:11:00 Module 15: Passwords and Access Rights Module 15: Passwords and Access Rights 00:08:00 Module 16: Options and Links Module 16: Options and Links 00:10:00 Module 17: Linking Payroll to Accounts Module 17: Linking Payroll to Accounts 00:08:00 Mock Exam Mock Exam - Payroll Manager and HR Management 00:20:00 Final Exam Final Exam - Payroll Manager and HR Management 00:20:00
Overview This comprehensive course on Microsoft Project: Learn the Fundamentals of Project Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Project: Learn the Fundamentals of Project Management comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Project: Learn the Fundamentals of Project Management. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Project: Learn the Fundamentals of Project Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 19 lectures • 01:10:00 total length •Lesson 01: What is Microsoft Project: 00:03:00 •Lesson 02: The Project Interface: 00:02:00 •Lesson 03: Project Management Phases: 00:02:00 •Lesson 04: Create a new Project Plan: 00:01:00 •Lesson 05: Create a Project Calendar: 00:06:00 •Lesson 06: Creating Project Tasks: 00:05:00 •Lesson 07: Placeholder Text and Task Types: 00:06:00 •Lesson 08: Create Work Breakdown Structure: 00:06:00 •Lesson 09: Define Task Relationships: 00:08:00 •Lesson 10: Tying Up Loose Ends: 00:02:00 •Lesson 11: Add Resources to Project Plan: 00:04:00 •Lesson 12: Creating a Resource Calendar: 00:03:00 •Lesson 13: Assign Resources to Tasks: 00:05:00 •Lesson 14: Resolve Resource Conflicts: 00:05:00 •Lesson 15: Optimise the Project Plan: 00:07:00 •Lesson 16: Adding Additional Resources: 00:02:00 •Lesson 17: Cost of the Project: 00:01:00 •Lesson 18: Setting a Baseline: 00:02:00 •Resource - Microsoft Project: Learn the Fundamentals of Project Management: 00:00:00
Overview This comprehensive course on Microsoft PowerBI - 25 Must-Know Tips and Tricks will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft PowerBI - 25 Must-Know Tips and Tricks comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft PowerBI - 25 Must-Know Tips and Tricks. It is available to all students, of all academic backgrounds. Requirements Our Microsoft PowerBI - 25 Must-Know Tips and Tricks is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 2 lectures • 01:34:00 total length •Must-Know Tips and Tricks of Microsoft PowerBI: 01:34:00 •Resource - Microsoft PowerBI - 25 Must-Know Tips and Tricks: 00:00:00
Overview This comprehensive course on PowerBI Formulas will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This PowerBI Formulas comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this PowerBI Formulas. It is available to all students, of all academic backgrounds. Requirements Our PowerBI Formulas is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 18 lectures • 01:25:00 total length •power pivot power query - 1: 00:01:00 •power pivot power query - 2: 00:02:00 •power pivot power query - 3: 00:06:00 •power pivot power query - 4: 00:07:00 •power pivot power query - 5: 00:02:00 •power pivot power query - 6: 00:05:00 •power pivot power query - 7: 00:05:00 •power pivot power query - 8: 00:04:00 •power pivot power query - 9: 00:03:00 •power pivot power query - 10: 00:02:00 •power pivot power query - 11: 00:04:00 •power pivot power query - 12: 00:08:00 •power pivot power query - 13: 00:04:00 •power pivot power query - 14: 00:03:00 •power pivot power query - 15: 00:13:00 •power pivot power query - 16: 00:03:00 •power pivot power query - 17: 00:13:00 •Assignment - PowerBI Formulas: 00:00:00
Overview This comprehensive course on Master Microsoft Power BI in 90 Minutes! will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Master Microsoft Power BI in 90 Minutes! comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Master Microsoft Power BI in 90 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Master Microsoft Power BI in 90 Minutes! is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 5 sections • 25 lectures • 01:35:00 total length •Overview of Power BI Course: 00:02:00 •Power BI Intro: 00:03:00 •Power BI High Level Flow: 00:02:00 •Install and Sign Up: 00:03:00 •Power Query Intro: 00:05:00 •Power Pivot Intro: 00:01:00 •Power View Intro: 00:02:00 •Big Picture: 00:02:00 •Get Data: 00:07:00 •How to Get More Data: 00:01:00 •Modelling Data: 00:03:00 •Adding Relationships Manually: 00:02:00 •Visualization: 00:05:00 •Visualization Customization: 00:01:00 •More Visualizations: 00:02:00 •Visualization Format and Analytics: 00:03:00 •Ask a Question: 00:02:00 •Real World Example: 00:06:00 •Get Data: 00:13:00 •Modelling Data: 00:05:00 •Visualization with multiple charts: 00:11:00 •Publishing: 00:05:00 •Power BI Website: 00:08:00 •FINAL: 00:01:00 •Resources - Master Microsoft Power BI in 90 Minutes!: 00:00:00
Overview This comprehensive course on Enterprise Resource Planning will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Enterprise Resource Planning comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Enterprise Resource Planning. It is available to all students, of all academic backgrounds. Requirements Our Enterprise Resource Planning is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 42 lectures • 01:55:00 total length •Operations of an Economic Entity: Enterprise Resource Planning: 00:03:00 •The Hierarchical Perspective: 00:02:00 •Enterprise Resource Planning ERP: 00:01:00 •Technology's Role in Business: 00:03:00 •Types of Information Systems: 00:03:00 •Interrelations between Systems: 00:01:00 •Functional IT Systems: 00:01:00 •Enterprise Resource Planning: External Priorities: 00:02:00 •Why ERP?: 00:02:00 •Overall Implementation Requisites for ERP: 00:02:00 •Challenges of ERP Implementation in Business: 00:02:00 •Senior and Project Management: 00:03:00 •Critical Factors for Successful ERP Implementation: 00:07:00 •Implementation Steps: 00:03:00 •ERP: Integration and Supply Chain Support: 00:02:00 •Web Services Integration Options: 00:02:00 •Market Information and Sales Orders: 00:02:00 •Benefits of the Marketing Information System: 00:02:00 •Customer Relationship Management: 00:02:00 •Customer Relationship Management Functions: 00:02:00 •ERP: HR Planning and Utilization: 00:03:00 •What is an HRIS?: 00:05:00 •ERP: Electronic Commerce - Accounting System Interface: 00:04:00 •E-Commerce Supply Chain Management Solutions: 00:04:00 •Problems in ERP and E-Commerce Integration: 00:01:00 •Operational Indicator, KPI's and Metrics: 00:03:00 •What is Metrics?: 00:01:00 •Need for Metrics in Testing and Quality Analysis: 00:01:00 •Metrics Continued: 00:04:00 •What are Quality Metrics?: 00:03:00 •Tips of Selection of Quality Metrics: 00:02:00 •Lead, Spot & Lagged Indicators - Drive, Monitor & Report Indicators: 00:05:00 •Lean Manufacturing and Agility: 00:05:00 •Quantitative vs. Qualitative Indicators and Measurement Scope: 00:02:00 •Measurement and Presentation Tools: 00:02:00 •Mechanisms of Success: 00:03:00 •Monitoring, Evaluation and Reporting: 00:05:00 •Balanced Scorecard Perspectives: 00:04:00 •Strategy Mapping: 00:03:00 •Balanced Scorecards vs. Dashboards: 00:04:00 •Metrics Measurements: IT Systems in ERP: 00:04:00 •Assignment -Operations Management: Enterprise Resource Planning: 00:00:00
Overview This comprehensive course on Complete Microsoft Power BI 2021 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Power BI 2021 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Complete Microsoft Power BI 2021. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Power BI 2021 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 140 lectures • 14:25:00 total length •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 •Creating our initial project file: 00:04:00 •Working with the attached project files: 00:04:00 •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 1 - Exercise Solution: 00:11:00 •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 •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 •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 •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 •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 •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 •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 •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 •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 •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 •Congratulations & next steps: 00:06:00 •The End: 00:01:00 •Resources - Complete Microsoft Power BI 2021: 00:00:00
Overview This comprehensive course on Data Visualization and Reporting with Power BI will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Visualization and Reporting with Power BI comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Visualization and Reporting with Power BI. It is available to all students, of all academic backgrounds. Requirements Our Data Visualization and Reporting with Power BI is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 140 lectures • 14:25:00 total length •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 •Creating our initial project file: 00:04:00 •Working with the attached project files: 00:04:00 •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 1 - Exercise Solution: 00:11:00 •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 •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 •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 •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 •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 •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 •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 •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 •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 •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 •Congratulations & next steps: 00:06:00 •The End: 00:01:00 •Resources - Data Visualization and Reporting with Power BI: 00:00:00