8136 Opera courses

Level 2 Microsoft Office Essentials

Level 5 Diploma | QLS Endorsed+CPD QS Accredited - Dual Certification | 24/7 Tutor Support | All-Inclusive Cost

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop 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 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

Overview This comprehensive course on Understand Piping & Instrumentation Diagrams P&IDs will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Understand Piping & Instrumentation Diagrams P&IDs 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Understand Piping & Instrumentation Diagrams P&IDs. It is available to all students, of all academic backgrounds. Requirements Our Understand Piping & Instrumentation Diagrams P&IDs 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 119 lectures • 08:26:00 total length •Introduction: 00:04:00 •What's a P&ID ?: 00:03:00 •Why is a P&ID so important ?: 00:02:00 •Who uses P&ID's ?: 00:06:00 •How do P&ID's look like ?: 00:08:00 •Introduction- PID READING: 00:02:00 •Anatomy of a P&ID: 00:01:00 •The title block: 00:03:00 •The drawing scale: 00:03:00 •The grid system: 00:02:00 •The revision block: 00:03:00 •Changes: 00:02:00 •Notes and legends: 00:03:00 •Valve symbols: 00:14:00 •Valve actuator symbols: 00:09:00 •Control valve designations: 00:02:00 •Standards and conventions for valve status: 00:07:00 •Process equipment symbols: 00:12:00 •Piping symbols: 00:03:00 •Pipe fitting symbols: 00:03:00 •Isolating, venting & draining symbols for ease of maintenance: 00:05:00 •Instrumentation: 00:03:00 •Sensing devices and detectors: 00:04:00 •Location symbols: 00:04:00 •Modifiers and transmitters: 00:05:00 •Indicators and recorders: 00:03:00 •Controllers: 00:03:00 •Example #1 : Identifying process equipment and flow paths: 00:05:00 •Example #2 : Identifying valve position and failure mode: 00:03:00 •Example #3 : Identifying the symbols: 00:02:00 •Piping designation code: 00:06:00 •Equipment designation code: 00:03:00 •Instrument designation code: 00:02:00 •Miscellaneous designation codes: 00:02:00 •The process: 00:01:00 •Process control: 00:06:00 •The control loop: 00:02:00 •Process control terms: 00:10:00 •Control loops : Feedback control: 00:02:00 •Pressure control loops: 00:01:00 •Flow control loops: 00:01:00 •Level control loops: 00:01:00 •Temperature control loops: 00:01:00 •Multi-variable loops: 00:02:00 •Feedforward control: 00:02:00 •Feedforward + Feedback: 00:01:00 •Cascade control: 00:08:00 •Split range control: 00:03:00 •Operations on control signals: 00:02:00 •Ratio control: 00:02:00 •Batch control: 00:01:00 •Selective control: 00:01:00 •Do we need to control at all ?: 00:01:00 •Principles of equipment-wise control: 00:10:00 •Pipe control system: 00:02:00 •Control of a single pipe: 00:02:00 •Control of pressure in a pipe: 00:03:00 •Control of flow in a pipe: 00:04:00 •Flow merging: 00:08:00 •Flow splitting: 00:05:00 •Centrifugal pump control: 00:04:00 •Control valve vs Variable Frequency Drive (VFD) for centrifugal pumps: 00:03:00 •Minimum flow control for centrifugal pumps: 00:09:00 •Positive displacement pump control: 00:02:00 •Control by a recirculation pipe for PD pumps: 00:03:00 •Variable Speed Drive (VSD) control for PD pumps: 00:01:00 •Control by stroke adjustment for PD pumps: 00:01:00 •Compressor control system: 00:02:00 •Compressor capacity control: 00:12:00 •Compressor anti-surge control: 00:03:00 •Heat transfer equipment control: 00:02:00 •Heat exchanger direct control system: 00:04:00 •Heat exchanger bypass control system: 00:04:00 •Reactor temperature control: 00:06:00 •Air cooler control: 00:02:00 •Heat exchanger for heat recovery: 00:01:00 •Heat exchanger back pressure control: 00:02:00 •Basic fired heater control: 00:08:00 •Complex fired heater control: 00:05:00 •Container and vessel control: 00:07:00 •Container blanket gas control: 00:02:00 •Safety strategies: 00:01:00 •Concept of Safety Instrumented Systems (SIS): 00:01:00 •SIS actions and types: 00:14:00 •SIS extent: 00:02:00 •SIS requirement: 00:03:00 •Anatomy of a SIS: 00:02:00 •SIS element symbols: 00:01:00 •SIS primary elements : Sensors: 00:03:00 •SIS final elements: 00:04:00 •Switching valve actuator arrangements: 00:02:00 •Valve position validation: 00:02:00 •Merging a switching valve and a control valve: 00:03:00 •SIS logics: 00:01:00 •Showing safety instrumented functions on P&ID's: 00:07:00 •Discrete control: 00:05:00 •Alarm system: 00:02:00 •Anatomy of alarm systems: 00:02:00 •Alarm requirements: 00:06:00 •Alarm system symbology in P&ID's: 00:06:00 •Concept of common alarms: 00:01:00 •Fire and Gas Detection Systems (FGS): 00:03:00 •Electric motor control: 00:07:00 •P&ID representation of commands and responses: 00:05:00 •P&ID representation of inspection and repair: 00:05:00 •P&ID example of electro-motor control: 00:04:00 •P&ID example #1 : Legend and specifications: 00:05:00 •P&ID example #2 : Hydrogen delivery station: 00:16:00 •P&ID example #3 : Acid system: 00:13:00 •P&ID example #4 : Centrifugal pump: 00:09:00 •P&ID example #5 : Utility station: 00:04:00 •P&ID example #6 : Waste water filter: 00:08:00 •P&ID example #7 : Steam separator: 00:15:00 •P&ID example #8 : Flare knock-out drum: 00:14:00 •P&ID example #9 : Centrifugal compressor: 00:05:00 •P&ID example #10 : Hydrogen production from shale gas: 00:11:00 •P&ID example #11 : Fired heater: 00:07:00 •Resources - Understand Piping & Instrumentation Diagrams P&IDs: 00:00:00 •Assignment - Understand Piping & Instrumentation Diagrams P&IDs: 00:00:00

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Overview This Hospitality and Revenue Management course will unlock your full potential and will show you how to excel in a career in Hospitality and Revenue Management. So upskill now and reach your full potential. Everything you need to get started in Hospitality and Revenue Management is available in this course. Learning and progressing are the hallmarks of personal development. This Hospitality and Revenue Management will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Hospitality and Revenue Management course covers everything you must know to stand against the tough competition in the Hospitality and Revenue Management field.  The future is truly yours to seize with this Hospitality and Revenue Management. Enrol today and complete the course to achieve a Hospitality and Revenue Management certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Hospitality and Revenue Management course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Hospitality and Revenue Management course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Hospitality and Revenue Management course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Hospitality and Revenue Management is suitable for anyone aspiring to start a career in Hospitality and Revenue Management; even if you are new to this and have no prior knowledge on Hospitality and Revenue Management, this course is going to be very easy for you to understand.  And if you are already working in the Hospitality and Revenue Management field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Hospitality and Revenue Management course is a win-win for you in all aspects.  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 This Hospitality and Revenue Management course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Hospitality and Revenue Management 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 Hospitality and Revenue Management course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Hospitality and Revenue Management Module 1. Introduction to Hospitality and Revenue Management 00:16:00 Module 2. Business Prospect of the Hospitality Industry 00:13:00 Module 3. An Overview of Hotel Industry 00:17:00 Module 4: The Process of Selection and Recruitment in Hospitality Industry 00:21:00 Module 5: The Process of Development and Training in Hospitality Industry 00:21:00 Module 6. Hospitality Management Operations 00:34:00 Module 7. Management of Service Quality in Hospitality Industry 00:18:00 Module 8. Importance of Revenue Management 00:21:00 Module 9. Key Performance Indicator in Hospitality Revenue Management 00:17:00 Module 10. The Revenue Management 00:21:00 Module 11: Customer Satisfaction 00:20:00 Module 12. Promotional Strategies 00:22:00 Module 13. The Future of Hospitality Revenue Management in UK 00:21:00 Module 14. Career Prospects in the Hospitality Industry 00:12:00

Overview This comprehensive course on Computer Science With Python will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Computer Science With Python 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 Computer Science With Python. It is available to all students, of all academic backgrounds. Requirements Our Computer Science With Python 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 • 152 lectures • 04:54:00 total length •Introduction: 00:03:00 •Quiz 1: 00:02:00 •Quiz 1 Solution: 00:01:00 •What is Programming: 00:03:00 •Quiz 2: 00:01:00 •Quiz 2 Solution: 00:01:00 •Meeting the interpreter and Problem Quiz 3: 00:01:00 •Quiz 3 solution: 00:01:00 •Congratulations: 00:01:00 •Why programming and Quiz 4: 00:02:00 •Quiz 4 Solution: 00:03:00 •Grammar and Python Rules: 00:04:00 •Backus Naur Form: 00:03:00 •Quiz 4 part 2: 00:01:00 •Quiz 4 part 2 Solution: 00:01:00 •Python Grammar and Quiz 5: 00:05:00 •Quiz 5 Solution: 00:03:00 •Quiz 6: 00:01:00 •Quiz 6 Solution: 00:02:00 •Processors: 00:02:00 •Introducing Variables: 00:05:00 •Variables Quiz 7: 00:02:00 •Variables Can Vary: 00:03:00 •Variables Quiz 8: 00:01:00 •Quiz 8 Solution: 00:01:00 •Variables Quiz 9: 00:01:00 •Quiz 9 Solution: 00:01:00 •Variables Quiz 10: 00:01:00 •Quiz 10 Solution: 00:03:00 •Introducing Strings: 00:04:00 •Using Strings Quiz 11: 00:01:00 •Quiz 11 Solution: 00:03:00 •Strings and Numbers - String Concatenation Quiz Solution: 00:03:00 •String indexing: 00:02:00 •Quiz 13: 00:01:00 •Quiz 13 Solution: 00:03:00 •String subsequences: 00:04:00 •String subsequences quiz 14: 00:01:00 •Quiz 14 solution: 00:02:00 •Understanding selection quiz 15: 00:01:00 •Quiz 15 solution: 00:04:00 •Finding string in string quiz 16: 00:04:00 •Quiz 16 solution: 00:02:00 •Testing and quiz 17: 00:02:00 •Quiz 17 solution: 00:03:00 •Find With Parameter Quiz 18: 00:02:00 •Quiz 18 solution: 00:01:00 •Extracting links from a web page Quiz 19: 00:03:00 •Extracting links from a web page Quiz 19 Solution: 00:02:00 •Final Quiz: 00:01:00 •Final Quiz Solution: 00:02:00 •Congratulations: 00:01:00 •Unit Overview: 00:03:00 •Procedural Abstraction: 00:03:00 •Introducing Procedures: 00:04:00 •Procedure code quiz 1: 00:04:00 •Quiz 1 Solution: 00:01:00 •Output and quiz 2: 00:01:00 •Quiz 2 Solution: 00:02:00 •Return Statement and Quiz 3: 00:03:00 •Quiz 3 solution: 00:02:00 •Inc Procedure Quiz 4: 00:01:00 •Quiz 4 Solution: 00:01:00 •Sum Procedure and Quiz 5: 00:01:00 •Quiz 5 Solution: 00:02:00 •Sum procedure with a return statement: 00:02:00 •Square procedure quiz 6: 00:01:00 •Quiz 6 Solution: 00:02:00 •Sum 3 Quiz 7: 00:01:00 •Quiz 7 Solution: 00:02:00 •Double string procedure quiz 8: 00:01:00 •Quiz 8 Solution: 00:01:00 •Find second quiz 9: 00:02:00 •Quiz 9 Solution: 00:02:00 •Equality Comparison Quiz 10: 00:04:00 •Quiz 10 Solution: 00:01:00 •If statement quiz 11: 00:03:00 •Quiz 11 Solution: 00:03:00 •Is friend quiz 12: 00:02:00 •Quiz 12 solution: 00:02:00 •Is friend quiz 13: 00:02:00 •Quiz 13 Solution: 00:02:00 •The Or construct: 00:03:00 •Quiz 14 solution: 00:06:00 •While loop quiz 15: 00:05:00 •Quiz 15 solution: 00:03:00 •While loop quiz 16: 00:01:00 •Quiz 16 solution: 00:02:00 •Print numbers quiz 17: 00:01:00 •Quiz 17 solution: 00:02:00 •Factorial quiz 18: 00:02:00 •Quiz 18 solution: 00:02:00 •Break quiz 19: 00:04:00 •Quiz 19 solution: 00:03:00 •Quiz 20: 00:05:00 •Quiz 20 Solution: 00:01:00 •No links quiz 21: 00:01:00 •Print all links quiz 21 solution: 00:03:00 •Final Quiz: 00:01:00 •Final Quiz Solution: 00:02:00 •Unit Overview: 00:03:00 •Stooges and quiz 1: 00:01:00 •Quiz 1 Solution: 00:01:00 •Countries quiz: 00:01:00 •Quiz 3 solution: 00:01:00 •Relative Size Quiz: 00:01:00 •Quiz 4 Solution: 00:01:00 •Lists Mutation: 00:01:00 •Different Stooges quiz: 00:01:00 •Quiz 5 Solution: 00:01:00 •Secret Agent Man Quiz: 00:01:00 •Replace Spy Quiz: 00:01:00 •Quiz 7 Solution: 00:03:00 •Python List Addition and Length: 00:02:00 •List Operations In Python: 00:02:00 •Python lists length quiz: 00:01:00 •Quiz 8 Solution: 00:01:00 •Append Quiz: 00:01:00 •Hard drive quiz: 00:01:00 •Quiz 11 Solution: 00:01:00 •Python Loops on Lists Quiz: 00:02:00 •Quiz 12 solution: 00:02:00 •Python For loops: 00:03:00 •Sum List Quiz: 00:01:00 •Measure a String Quiz: 00:01:00 •Find Element Quiz: 00:02:00 •Quiz 15 solution: 00:04:00 •Quiz 16 solution: 00:01:00 •Python Union Procedure Quiz: 00:01:00 •Quiz 17 solution: 00:01:00 •Pop in Python Quiz 18: 00:02:00 •Quiz 18 solution: 00:03:00 •Collecting Links: 00:01:00 •Get All Links: 00:02:00 •Starting Get All Links Quiz: 00:01:00 •Quiz 19 solution: 00:01:00 •Updating Links Quiz: 00:01:00 •Quiz 20 Solution: 00:01:00 •Finishing Get All Links Quiz: 00:01:00 •Quiz 21 Solution: 00:01:00 •Finishing the Python Web Crawler: 00:03:00 •Crawling Process Quiz: 00:01:00 •Quiz 22 Solution: 00:01:00 •Crawl Web Quiz: 00:01:00 •Quiz 23 Solution: 00:01:00 •Crawl Web Loop Quiz: 00:01:00 •Quiz 24 Solution: 00:02:00 •Crawl If Quiz: 00:01:00 •Quiz 25 Solution: 00:01:00 •Finishing Crawl Web and Final Quiz: 00:02:00 •Final Quiz Solution & Conclusion: 00:03:00 •Assignment - Computer Science With Python: 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