2903 Intelligence courses in Coventry delivered Online

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics 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 Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Transform your data into actionable insights with Microsoft Power BI. Empower your business decisions through dynamic visualizations, interactive dashboards, and robust analytics. Unleash the power of data with this industry-leading business intelligence tool, designed to help you make informed choices and drive success. Explore the capabilities of Microsoft Power BI today for a smarter, data-driven future.

This course has been specifically designed to assist professionals applying for Real Estate positions where a Real Estate Financial Modelling test is a requisite part of the interview process.

In today’s competitive job market, leaders are hired for more than just experience—they’re hired for mindset, adaptability, and the ability to manage people through uncertainty. The Leadership and People Management: 20-in-1 Premium Online Courses Bundle gives you the well-rounded credibility you need to move into team leadership, operations, or HR management. Packed with 20 essential courses, this all-in-one professional upgrade was designed to help you stand out and get hired faster. Description Employers across industries—finance, healthcare, education, tech, logistics—are all on the lookout for leaders who understand people. This bundle helps you prove that you do. From communication to crisis management, conflict resolution to remote team handling, these certifications show you’re not just a manager—you’re a people-first strategist. It’s ideal for professionals eyeing a promotion, graduates transitioning into team roles, or freelancers moving into organisational leadership. With hiring managers prioritising emotional intelligence, productivity strategy, and team cohesion, now is the time to boost your credentials. This 20-course bundle offers enormous value—and serious career leverage. But like all strategic windows, it’s limited. If you're ready to step forward into leadership, don’t let this opportunity slip past. FAQ What jobs does this bundle support? Team leader, operations manager, HR coordinator, project lead, and departmental supervisor. Do I need to be in a leadership role already? No—this is perfect for aspiring leaders or those transitioning into management. Is this suitable for remote work careers? Yes, especially with included topics like online meeting and remote team management. Do I receive certificates? Yes—each course includes a downloadable certificate for your CV and LinkedIn. How flexible is the training? Fully online, 24/7 access. Learn at your pace. Is this a permanent offer? No—this bundle is available only for a short time.

Conflict in the workplace is inevitable—how you handle it determines your leadership potential. This 20-in-1 Conflict Resolution Training bundle is your secret weapon for building a career in HR, leadership, healthcare, or mental wellness sectors, where soft skills are a hard requirement. If you want to become the go-to person for calm under pressure, this bundle sets you apart. Description Mastering conflict resolution isn’t just for managers—it's a core competency in nearly every profession. From navigating tough conversations to promoting workplace wellbeing, this collection empowers you with the tools employers actively seek in team leads, HR assistants, care workers, and educators. Don’t miss the chance to level up with in-demand skills that rarely get taught, but frequently get rewarded. For anyone who wants to lead with empathy, manage with confidence, or support others in high-stakes environments, this bundle delivers exceptional career value—without the premium price tag. FAQ Who should take this bundle? HR professionals, team leaders, support workers, educators, mental health workers, and anyone in people-facing roles. How does this help me get hired? Employers are actively searching for candidates with emotional intelligence, communication mastery, and leadership potential—this bundle ticks all the boxes. Is there any certification included? Yes. Each course comes with a completion certificate, giving your CV and professional profile a credibility boost. Which industries find this most relevant? HR, healthcare, education, social work, non-profits, and management consulting, to name a few. Can I learn in my spare time? Yes! All courses are self-paced and come with lifetime access. What makes this bundle worth it now? These skills are evergreen—but opportunities to master them in one place, at this price, are limited. Don’t miss the window.

In care, education, mental health, and beyond—understanding human behaviour is no longer optional. The Psychology: 20-in-1 Premium Online Courses Bundle gives you the multi-dimensional credentials employers expect from today’s compassionate professionals. Whether you're entering the field or enriching your current role, this bundle proves you're built for people-first work. Description Professionals in social work, mental health, education, or support roles are increasingly expected to bring a working knowledge of behavioural science, counselling basics, and emotional intelligence. This bundle delivers 20 certifications to help your CV reflect modern psychological awareness—while setting you apart in the hiring process. From autism support to brain disorders, from CBT to self-esteem, this collection shows employers you're not just qualified—you’re holistically prepared. It also adds value for those in education, HR, social care, or even customer-facing corporate roles. Psychology opens doors. This bundle gives you the keys—before the vacancies are gone. FAQ Q: Is this only for psychologists or therapists? A: Not at all. It suits anyone working in education, care, support services, coaching, or people-focused careers. Q: What jobs can this help me get? A: Mental health assistant, support worker, SEN teaching assistant, care coordinator, or HR wellbeing lead. Q: Can I add these certificates to my job applications? A: Yes—each course provides certification to enhance your portfolio and CV. Q: Is this suitable for beginners? A: Absolutely. No prior experience in psychology is required to benefit from this bundle. Q: Does it include personal development skills? A: Yes. Courses also cover self-organisation, communication, negotiation, and problem-solving. Q: Why buy now? A: Demand for emotionally intelligent professionals is rising—this bundle helps you respond, not react.

Where people work, conflicts happen—and skilled professionals who can resolve them are in high demand. This 20-in-1 Conflict Management bundle was made to turn you into that person. If you’re aiming for leadership, HR, or client-facing roles, don’t let this opportunity pass. Description From workplace tension to high-pressure negotiations, modern work environments require more than technical skills—they demand emotional intelligence, communication, and strategic thinking. This Conflict Management bundle is crafted for professionals who want to be known not just for getting results, but for bringing harmony and resilience to the table. Perfect for HR professionals, team leaders, mental health support roles, and office managers, this bundle combines interpersonal awareness with organisational and communication capabilities. The result? A well-rounded candidate who stands out in interviews and excels in real-world roles. This 20-course collection doesn’t just make you employable—it makes you indispensable. Great workplaces don’t run on talent alone—they run on those who can manage people, emotions, and problems with grace. FAQ Q: What types of jobs is this bundle useful for? A: HR roles, team leadership, workplace counselling, office administration, and coaching. Q: Will this help in a mental health or education setting? A: Yes, many of the included topics are highly applicable in those environments. Q: Can I study these alongside a full-time job? A: Absolutely—learn anytime, with lifetime access. Q: Is this just for professionals, or also for beginners? A: It’s suitable for anyone looking to become more hireable in people-focused careers. Q: How does this help me stand out? A: Employers value those who bring harmony to teams—it’s a leadership trait in demand.

Highlights of the Course Course Type: Online Learning Duration: 8 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about forensic investigation Understand the core competencies and principles of forensic investigation Explore the various areas of forensic investigation Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert pentester Cyber Security and Digital Forensics for Pentesters - Hands-on Course Master the skills you need to propel your career forward in digital forensic investigation. This course will equip you with the essential knowledge and skillset that will make you a confident pentester and take your career to the next level. This comprehensive cyber security and digital forensics course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this cyber security and digital forensics course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This cyber security and digital forensics course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.  This comprehensive course will teach you the theory of effective digital forensic investigation practice and equip you with the essential skills, confidence and competence to assist you in the digital forensic investigation industry. You'll gain a solid understanding of the core competencies required to drive a successful career in digital forensic investigation. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for pentester or for people who are aspiring to specialise in digital forensic investigation. This cyber security and digital forensics course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification.  Enrol in this cyber security and digital forensics course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive cyber security and digital forensics course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this digital forensic investigation can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This cyber security and digital forensics course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This cyber security and digital forensics course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This cyber security and digital forensics course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Course Overview Course Overview 00:06:00 Building Your Forensics Lab Environment Using VirtualBox Video - Downloading ISO and OVA Files for VirtualBox 00:08:00 Video and lab - Create a Virtual Install of CSI Linux 2021.2 00:12:00 Video and Lab - Create a Kali Live (Forensic Mode) VM Using VirtualBox 00:06:00 Video and lab - Create a Virtual Install Kali Image Using VirtualBox 00:11:00 Video and Lab - Create Virtual Install of Windows 10 Using VirtualBox 00:08:00 Video and Lab - Create a Virtual Install of Metasploitable2 Using VirtualBox 00:10:00 Using Kali Forensic Mode and Autopsy Video and Lab -Getting Started with Autopsy 00:10:00 Video and Lab - Simulate Creating a Disk Image for a Forensic Analysis 00:11:00 Video and Lab - Examining a forensic Disk Image Using Autopsy 00:12:00 Digital Forensics Case Management Video and Lab - Installing the WebMap-Nmap Dashboard 00:12:00 Open-source Intelligence (OSINT) Video and Lab - Conducting OSINT Using CSI Linux Investigator 00:08:00 Video and Lab - Find Social Media Accounts Using Sherlock 00:07:00 Video - OSINT Framework - Overview 00:16:00 Using Shodan to Search for Vulnerable Devices Video and Lab - Preparing CSI Investigator to Use Shodan 00:05:00 Video and Lab - Using Shodan to Find Vulnerable Devices 00:16:00 Video and lab - Using Shodan to Search for Vulnerable Databases 00:08:00 Computer Forensics Video - Attaching an External USB Device in Kali 00:07:00 Video and Lab - Acquiring a Forensic Copy of the Windows Registry 00:15:00 Video and Lab - Analyzing the Windows Registry for Evidence 00:14:00 Video and Lab - Dumping Wi-Fi Credentials Using netsh 00:04:00 Video and Lab - Email Header Analysis 00:17:00 Video and Lab - Using Shellbags to View Hidden or Deleted Folders 00:06:00 Video and Lab - Extracting Thumbnail Images From a Suspects Machine 00:05:00 Video and lab - Memory Forensics Using the Volatility Framework 00:19:00 Reverse Engineering and Malware Analysis Video and Lab - Install Ghidra on CSI Linux 00:07:00 Video and Lab - Introduction to Using Ghidra 00:14:00 Video and Lab - Reverse Engineering crackme0x00 Using Ghidra 00:06:00 Video and Lab - Reverse Engineering crackme0x05 Using Ghidra 00:12:00 Video and Lab - Analyzing the WannaCry KillSwitch Using Ghidra 00:17:00 Malware Hunting with Sysinternal Tools Video - Overview of Sysinternal Tools 00:08:00 Video - Overview of Sysinternal's Process Explorer 00:00:00 Video and Lab - Finding Malware with Sysinternals Process Explorer 00:09:00 Stenography Video and Lab - Using Steghide for Hiding and Extracting Data 00:11:00 Video and Lab - Using the EXIFtool to Read and Write EXIF Tags 00:10:00 Network Forensics Using Wireshark Video - Overview of Wireshark 3.2 00:11:00 Video - Wireshark Capture Options 00:07:00 Video - Wireshark Toolbar Icons 00:03:00 Video and Lab - Installing a Wireless Adapter in Kali 00:09:00 Video and Lab - Hacking a Wireless Network Using Kali Linux 00:14:00 Video - Capturing Wireless Traffic Using Wireshark 00:05:00 Practice What You Learned Video and Lab - CTF Lab Build for HA: Forensics 00:11:00 Video and lab - Capture flag #1 00:12:00 Video and lab - Capture flag #2 00:10:00 Video and lab - Capture flag #3 00:20:00 Video and lab - Capture flag #4 00:09:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Are you looking to enhance your employees' abilities and skills in Business Analysis and Management? If yes, then you have come to the right place. Our comprehensive Business Analysis and Management course at Compliance Central is designed to help your team produce the best possible outcomes by mastering the essential Business Analysis and Management skills. Whether your employees are new to Business Analysis and Management or already working in the field, this course will provide them with the necessary knowledge and skillsets to excel. Why Employee Training Matters: Boost Productivity: Well-trained employees work more efficiently, driving productivity in all areas. Increase Employee Morale: Invest in your employees' growth, leading to a positive work environment and higher retention rates. Stay Ahead of Competitors: Equip your workforce with the latest skills and knowledge to outshine the competition. Ensure Compliance and Safety: Specialised training keeps your business compliant and your workplace safe. Improve Customer Satisfaction: Well-trained staff deliver exceptional service, building loyal customer relationships. Why Choose Us? Expert-Developed Training: Industry professionals have developed valuable insights and helpful learning. Flexible Learning: Online Business Analysis and Management course allows employees to learn at their own pace. Ongoing Support: Dedicated Business Analysis and Management experts are available to guide your employees throughout the training process. Certificates of Achievement: Recognise your employees' commitment with CPD Certified certificates. Employer Dashboard: Easily track employee Business Analysis and Management progress in our user-friendly dashboard. Empower Your Workforce Today! Invest in your company's future success. Join us to start your employees' Business Analysis and Management training and watch your business thrive. Compliance Central - Empowering Businesses Through Knowledge Empower Your Business with Comprehensive Employee Training! At Compliance Central, we understand that well-trained employees are the backbone of successful organisations. Elevate your workforce and propel your business forward with our tailored online training programs. Curriculum Breakdown Of Business Analysis and Management Training Course: Module 01: Introduction to Business Analysis Module 02: Business Processes Module 03: Business Analysis Planning and Monitoring Module 04: Strategic Analysis and Product Scope Module 05: Solution Evaluation Module 06: Investigation Techniques Module 07: Ratio Analysis Module 08: Stakeholder Analysis and Management Module 09: Process Improvement with Gap Analysis Module 10: Documenting and Managing Requirements Module 11: Career Prospect as a Business Analyst in the UK Our Business Analysis and Management course starts with the fundamentals and gradually progresses to cover advanced topics, making each lesson intuitive and easy to understand. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Business Analysis and Management course is ideal for new professionals looking to thrive in the Business Analysis and Management field. Requirements Enrolling in this Business Analysis and Management course only requires a basic understanding of the English language and an internet connection. Career path Completing the Business Analysis and Management course will enhance your employees' knowledge and confidence. Business Analyst: £35,000 to £60,000 per year Management Consultant: £40,000 to £70,000 per year Project Manager: £35,000 to £65,000 per year Operations Manager: £40,000 to £70,000 per year Business Development Manager: £35,000 to £60,000 per year Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

Join our Microsoft Power BI Masterclass course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Power BI Masterclass course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Power BI Masterclass course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Power BI Masterclass. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Power BI Masterclass course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Power BI Masterclass is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Power BI Masterclass course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Power BI Masterclass Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. 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 00:00:00