3193 Character courses

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? 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 SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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 SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

Advanced Diploma in Interior Design Course Overview To become a successful interior designer, creativity is not enough. You must be able to channel your creativity to build efficient, comfortable and beautiful spaces. That requires specialised skills and knowledge. The Advanced Diploma in Interior Design course is here to equip you with those essential knowledge and skills. The Advanced Diploma in Interior Design course will give you a detailed understanding of interior design. It will enrich your understanding of different styling techniques and provide you with the expertise to incorporate them into your designs. In this course, you will learn how to create a beautiful and efficient space within a budget. The informative modules will teach you the strategies for picking up the right furniture and colours. From a child's bedroom to a kitchen, you will develop the expertise to design all sorts of rooms with different types of styles - casual, formal, tropical chic and more. After completing this Advanced Diploma in Interior Design course, you will not only develop your designing skills but also receive a valuable certificate. This certificate will help you in pursuing a career in the design industry. So enrol now and start developing your skills. Learning Outcomes Learn the basic principles of interior designing Develop the expertise to design a space in a budget Understand the techniques of picking up the right pieces of furniture Gain in-depth knowledge of different time periods and their styles Build the skills to design a wide range of rooms Learn how to work with different types of styles like formal, shabby chic, casual and more Who is the Advanced Diploma in Interior Design Course for? This Advanced Diploma in Interior Design course will be highly beneficial for those who wish to pursue a career in the relevant industry. The Advanced Diploma in Interior Design course would be helpful for people with careers in: Designer Home Decorator Home Repair Expert Interior Designer Set Designer  It is also suitable for anyone interested in designing their own homes and offices.  Why Choose this Advanced Diploma in Interior Design Course? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for an online multiple-choice test for the old version, and the updated version doesn't include assessment. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Updated Version-Advanced Diploma in Interior Design Section 01: Popular Interior Design Styles and How to Use Them The 3 Types of Style That Influence Interior Design Choices 00:01:00 Art Deco Style 00:03:00 Victorian Style 00:03:00 Scandinavian Style 00:02:00 Modern Style 00:02:00 Contemporary Style 00:03:00 Eclectic Style 00:06:00 Italian Style 00:04:00 French Style 00:05:00 Industrial Style 00:04:00 Country Style: Architectural & Interiors 00:04:00 African Style 00:05:00 Section 02: Design Principles and Elements in Interiors Introduction to Design Principles & The Design Recipe 00:03:00 Design Element: Line 00:05:00 Design Element: Shape 00:03:00 Design Element: Form 00:03:00 Design Element: Colour 00:02:00 Design Element: Texture 00:05:00 Design Element: Space 00:03:00 Design Element: Value 00:01:00 Design Principle: Pattern 00:03:00 Design Principle: Contrast 00:03:00 Design Principle: Emphasis/Focal Point 00:05:00 Design Principle: Balance 00:05:00 Design Principle: Scale/Proportion 00:03:00 Design Principle: Rhythm/Movement 00:03:00 Design Principle: Unity/Harmony 00:01:00 Section 03: Introduction to Colour in Interiors The Impact of Fashion and Colour Trends 00:04:00 Colour Terminology 00:04:00 Colour Basics and Neutral Colours 00:05:00 Warm vs. Cool Colours 00:03:00 Colour Schemes 00:11:00 Colour Ratios and Applications 00:05:00 Using Colour To Trick The Eye 00:04:00 Section 04: Introduction to Space Planning In Interiors Understand why space planning is important to successful interiors 00:01:00 Efficient vs. Poorly Planned Spaces 00:04:00 Types of Building and Space Plans 00:06:00 Open and Closed Planned Spaces 00:04:00 Space Planning and The Design Principles 00:09:00 Tips and Tricks to Space Planning 00:02:00 Section 05: Textiles and Fabrics for Interiors Introduction To Textiles & Fabrics 00:01:00 Natural Fibers and Textiles 00:08:00 Synthetic Fibers and Textiles 00:06:00 Fabric Know Hows 00:10:00 End-Use of Textiles and Fabrics 00:04:00 Selecting and Recommending Textiles and Fabrics 00:04:00 Section 06: Styling and Staging Interior Spaces Introduction to Styling and Staging 00:03:00 Styling Coffee Tables 00:12:00 Styling Side Tables 00:07:00 Styling Servers and Consoles 00:05:00 Styling Dining Room Tables 00:04:00 Styling Book Cases and Display Cases 00:12:00 Styling with Scatter Cushions and Throw Pillows 00:11:00 Styling Seating and Sleeping Areas 00:05:00 Styling Walls with Art and Framing 00:11:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00 Old Version-Advanced Diploma in Interior Design Interior Design Fundamentals Define a Theme: Contemporary, Cottage, Eclectic, Southwest 01:00:00 Budget Design for Your Living Room, Den or Family Room 01:00:00 Budget Ideas for Kitchen Design 01:00:00 Budget Bedroom Makeover 01:00:00 Closet Cleanups 01:00:00 Need a Home Office? 00:30:00 Camouflage with Paint! 01:00:00 Faux Finishes Are Hot - Bare Walls Are Not! 00:30:00 Window Treatments 01:00:00 Making the Most of Molding 00:30:00 Fabulous Furniture Finds 00:30:00 Decorate With Wallpaper 01:00:00 Freehand or Stencil A Mural Makes the Wall! 01:00:00 Accessorize - Funky Can Be Fun! 01:00:00 Have Some Fun with Fabric! 01:00:00 Interior Decorating Basics HOW TO REARRANGE A ROOM 02:00:00 HOW TO ANALYZE A ROOM AS PROFESSIONALS DO BEFORE YOU 01:00:00 HOW TO CREATE A ROOM 02:00:00 HOW TO DETERMINE CHARACTERS OF HANGINGS AND FURNITURES-COVERING FOR A GIVEN ROOM 01:00:00 CANDLESTICKS, LAMPS, FIXTURES FOR GAS AND ELECTRICITY, AND SHADES 01:00:00 WINDOW SHADES AND AWNINGS 00:30:00 TREATMENT OF PICTURES AND PICTURE FRAMES 01:00:00 TREATMENT OF PIANO CASES 00:15:00 TREATMENT OF DINING-ROOM BUFFETS AND DRESSING-TABLES 00:15:00 TREATMENT OF WORK TABLES, BIRD CAGES, DOG BASKETS AND FISH GLOBES 00:30:00 TREATMENT OF FIREPLACES 00:30:00 TREATMENT OF BATHROOMS 01:00:00 PERIOD ROOMS 01:00:00 PERIODS IN FURNITURE 01:00:00 CONTINUATION OF PERIODS IN FURNITURE 01:00:00 THE GOTHIC PERIOD 00:30:00 THE RENAISSANCE 01:00:00 FRENCH FURNITURE 01:00:00 THE PERIODS OF THE THREE LOUIS 01:00:00 THE MAHOGANY PERIOD 02:00:00 THE COLONIAL PERIOD 00:30:00 THE REVIVAL OF DIRECTOIRE AND EMPIRE FURNITURE 00:30:00 THE VICTORIAN PERIOD 00:30:00 PAINTED FURNITURE 00:30:00 TREATMENT OF AN INEXPENSIVE BEDROOM 01:00:00 TREATMENT OF A GUEST ROOM (Where economy is not an item of importance) 01:00:00 A MODERN HOUSE IN WHICH GENUINE JACOBEAN FURNITURE IS APPROPRIATELY SET 00:30:00 UNCONVENTIONAL BREAKFAST-ROOMS AND SPORTS BALCONIES 01:00:00 SUN-ROOMS 01:00:00 TREATMENT OF A WOMAN'S DRESSING-ROOM 00:30:00 THE TREATMENT OF CLOSETS 00:30:00 TREATMENT OF A NARROW HALL 00:15:00 TREATMENT OF A VERY SHADED LIVING-ROOM 00:15:00 SERVANTS' ROOMS 00:15:00 THE BABY'S ROOMS: THE DAY ROOM, THE NIGHT ROOM 01:00:00 ROOMS FOR THE ELDERLY 01:00:00 A YOUNG GIRL'S ROOM 01:00:00 THE YOUNG BOY'S ROOM 00:30:00 TABLE DECORATION 01:00:00 WHAT TO AVOID IN INTERIOR DECORATION: RULES FOR BEGINNERS 01:00:00 FADS IN COLLECTING 01:00:00 WEDGWOOD POTTERY; OLD AND MODERN 01:00:00 ITALIAN POTTERY 00:15:00 VENETIAN GLASS, OLD AND MODERN 00:30:00 CONCLUSION 00:15:00 Interior Design INTRODUCTION 00:30:00 DO'S AND DON'TS OF DECORATING 01:00:00 GETTING IDEAS 00:15:00 ELEMENTS OF DESIGN 01:00:00 ORGANIZE YOUR IDEAS 01:00:00 DECORATING ON A BUDGET 01:30:00 MINIMALIST STYLE 01:00:00 CASUAL STYLE 00:30:00 FORMAL STYLE 00:30:00 SHABBY CHIC STYLE 00:30:00 PARIS APARTMENT STYLE 00:30:00 FRENCH COUNTRY STYLE 00:30:00 TROPICAL CHIC STYLE 00:30:00 LODGE STYLE 00:30:00 USING WHAT YOU'VE GOT 00:30:00 DECORATING IN A DAY 00:30:00 CHOOSING ART 01:00:00 CONCLUSION 00:15:00 Recommended Reading Recommended Reading: Advanced Diploma in Interior Design 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Advanced Diploma in Interior Design 00:30:00 Final Exam Final Exam- Advanced Diploma in Interior Design 00:30:00

Are you passionate about writing and dream of seeing your name on a bestseller list? Enrolling in our "How to Write a Bestselling Novel" course is your first step toward that goal. In today's world, the ability to write compelling stories is more important than ever. This course is much needed as it provides you with the essential skills to write stories that captivate and engage readers. Writing effectively can greatly enhance your daily life by improving communication skills and creativity. Professionally, mastering the art of writing can open doors to numerous job opportunities in the UK, with writers earning an average salary of £25,000 to £50,000 per year, depending on their experience and success. The course covers everything from understanding the market to crafting compelling characters and building a captivating plot. Writing is not just a skill but an asset in various sectors, which are seeing a significant growth of 12% annually. By learning to write effectively, you can build a strong author brand, making you a desirable candidate in publishing and content creation industries. So, take this opportunity to write your future success story! Key Features: CPD Certified How to Write a Bestselling Novel Course Free Certificate from Reed CIQ Approved How to Write a Bestselling Novel Course Developed by Specialist Lifetime Access Course Curriculum: Module 01: Understanding the Market Module 02: Crafting Compelling Characters Module 03: Building a Captivating Plot Module 04: Mastering Dialogue Module 05: Setting the Scene Module 06: Crafting an Irresistible Hook Module 07: Building Your Author Brand Learning Outcomes: Understand market dynamics for writing bestsellers, targeting reader preferences effectively. Create vivid characters, making your novel engaging and relatable to readers. Develop captivating plots, mastering the art of storytelling for bestseller potential. Craft authentic and compelling dialogue to breathe life into your characters. Set the scene skillfully, creating immersive environments for reader connection. Construct irresistible hooks that grab attention, setting your novel apart instantly. CPD 10 CPD hours / points Accredited by CPD Quality Standards How to Write a Bestselling Novel 2:09:33 1: Module 01: Understanding the Market Preview 19:59 2: Module 02: Crafting Compelling Characters 16:58 3: Module 03: Building a Captivating Plot 17:07 4: Module 04: Mastering Dialogue 15:44 5: Module 05: Setting the Scene 19:28 6: Module 06: Crafting an Irresistible Hook 18:38 7: Module 07: Building Your Author Brand 20:39 8: CPD Certificate - Free 01:00 Who is this course for? This How to Write a Bestselling Novel course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of How to Write a Bestselling Novel. Moreover, this course is ideal for: Aspiring writers seeking bestseller success and literary recognition. Authors eager to enhance their storytelling skills and commercial appeal. Fiction enthusiasts looking to turn their passion into marketable novels. Creative minds aiming to build a distinctive author brand and identity. Those keen on writing novels that resonate with a wide readership. Requirements There are no requirements needed to enrol into this How to Write a Bestselling Novel course. We welcome individuals from all backgrounds and levels of experience to enrol into this How to Write a Bestselling Novel course. Career path After finishing this How to Write a Bestselling Novel course you will have multiple job opportunities waiting for you. Some of the following Job sectors of How to Write a Bestselling Novel are: Novelist - £24K to £60K/year. Scriptwriter - £30K to £55K/year. Copywriter - £20K to £45K/year. Editor - £25K to £50K/year. Literary Agent - £25K to £50K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Easily learn the skills and knowledge you desire in MS Office with our Microsoft Office for Admin, you get an unparalleled learning experience with us and you get a digital certificate, transcript and a student ID card all included with the course price. What makes us the go to choice for people who want to learn about MS Office is our dedication and commitment to providing you with the best service possible. You will get unlimited access to the Microsoft Office for Admin, no matter where you are in the world you will be able to access your Microsoft Office for Admin any time you want. Should you have any questions while studying this Microsoft Office for Admin, our experienced tutors and mentors will answer them via email and live chat. With the original certificate you get after completing your Microsoft Office for Admin you will gain the CPD qualifications that will help you succeed out in the world and in your career. With our Student ID card you will get discounts on things like music, food, travel and clothes etc. Enrol in our Microsoft Office for Admin today and start learning. Why buy this Microsoft Office for Admin? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Office for Admin 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 Microsoft Office for Admin does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Microsoft Office for Admin was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Office for Admin is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:30:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline1 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View1 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentatio 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options1 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database1 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00

Dive into the realm of effective management with our course, 'Essentials of Becoming a Manager and Managing Teams'. Navigate the challenges of stepping into a managerial role in 'New Manager Mastery'. Discover the art of selecting the perfect candidate for your team in 'A Masterclass in Hiring For Your Teams' and foster an environment that promotes continuous growth with 'Creating a Culture of Learning in Your Organisation'. Equip yourself with top-tier interview techniques, manage stress, lead with conviction, conduct impactful meetings, and delve into the intricacies of advanced team management. Learning Outcomes Understand the transition intricacies and best practices of becoming a new manager. Master the strategies to effectively hire and onboard team members. Establish and nurture a growth-oriented learning culture within the organisation. Acquire techniques to proficiently manage stress, ensuring personal and team well-being. Lead meetings effectively and gain insights into advanced aspects of team leadership. Why buy this Essentials of Becoming a Manager and Managing Teams course? 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 Essentials of Becoming a Manager and Managing Teams 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 Essentials of Becoming a Manager and Managing Teams course for? Aspiring managers looking to transition into leadership roles seamlessly. Team leaders seeking to refine their hiring and team-building strategies. Organisational heads aiming to instil a robust learning culture. Professionals wanting to enhance their interview conduction skills. Individuals eager to develop leadership attributes and manage workplace stress. Prerequisites This Essentials of Becoming a Manager and Managing Teams does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Essentials of Becoming a Manager and Managing Teams 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 Manager: £30,000 - £45,000 Team Leader: £25,000 - £35,000 HR Specialist: £28,000 - £40,000 Training and Development Officer: £27,000 - £37,000 Stress Management Consultant: £35,000 - £50,000 Meetings Coordinator: £22,000 - £30,000 Course Curriculum Section 01: New Manager Mastery What to Expect & About Me 00:02:00 Well Done! 00:02:00 It's a Different Job 00:03:00 You're Scared? Good! 00:02:00 The Manager Mindset 00:03:00 Set Expectations 00:04:00 Get Learning Leadership! 00:03:00 What is Culture? 00:02:00 Culture of Fairness 00:08:00 People Are Crazy 00:02:00 Mastering One To One Meetings 00:05:00 Manager to Coach 00:07:00 Me? A Psychologist? 00:02:00 Emotional Intelligence 00:05:00 Mastering Performance Evaluations 00:07:00 Welcoming New Starters 00:07:00 How to Hire a Diverse Workforce 00:06:00 Get the Basics Right Every Time 00:02:00 Conclusion 00:02:00 Section 02: A Masterclass In Hiring For Your Teams Introduction 00:02:00 The Importance of the Interview Process 00:03:00 What's Wrong With The Interview Process 00:07:00 Human Vs. Algorithm 1 00:02:00 Unconscious Interviewer Biases 00:03:00 Be Data Driven 00:03:00 Let's See You In Action 00:02:00 Keep it Relevant 00:02:00 Seriously Avoid These Topics 00:03:00 Benefits of a Diverse Workforce 00:03:00 How to Hire a Diverse Workforce 00:06:00 Hunger and Desire Over Skills 00:03:00 Culture Addition, Not Culture Fit 00:03:00 Compliment, Backup or Add To The Team 00:05:00 Hiring The Right Rank 00:04:00 What Are Your Location Restrictions 00:01:00 The Risk Of Delivering Less 00:02:00 The Risk Of Burnout 00:02:00 The Risk Of Losing The Headcount 00:02:00 Confirm The Job Is What They Think It Is 00:02:00 Sell Yourself, The Team & The Company 00:03:00 Don't Be A Jerk 00:02:00 It's Not About Making You Look Good 00:02:00 Managing Recruitment Agencies 00:04:00 Communications With The Candidate 00:03:00 Be Ready 00:03:00 Assign A Buddy 00:02:00 You Got It Wrong! 00:02:00 Conclusion 00:03:00 Section 03: Creating a Culture Of Learning In Your Organization What To Expect From The Course 00:02:00 Why Even Bother? 00:07:00 What Learning Used To Be Like 00:02:00 Individual Learner 00:01:00 Everyone Says They Are A Self-Learner 00:10:00 Online Communities 00:02:00 Embedding Learning Into Daily Life 00:03:00 Teach It To Learn It 00:02:00 Learning New Vs Becoming Expert 00:01:00 Listen Faster 00:01:00 Tom's Approach 00:02:00 The Paid Training Course Is History 00:03:00 Develop The Right Mental Habits 00:06:00 Make It Easier On Yourself 00:02:00 Manager Responsibilities 00:01:00 Are You Really A Centre Of Excellence? 00:02:00 Learning As Part Of Performance Evaluation 00:02:00 Don't Worry If People Leave 00:01:00 The Benefits Of A Skilled User Base 00:02:00 Push It, Push It, Push It 00:01:00 The Golden Hour 00:09:00 Internal Mobility 00:03:00 Team Secondment 00:02:00 Make People Good Enough To Quit 00:03:00 Lunch & Learns 00:02:00 Personalised Learning Plans 00:02:00 Use It Or Lose It 00:02:00 Certifiably Great 00:02:00 Get A Learning Buddy 00:02:00 Senior Leaders Responsibilities 00:01:00 Walk It From The Top 00:02:00 Learning Wherever, Whenever 00:02:00 Show Us The Data 00:02:00 Create Learning Champions 00:02:00 Gamification 00:02:00 Sell, Sell, Sell 00:03:00 Don't Block The Useful Sites 00:03:00 Create A Varied Library Of Resources 00:02:00 Encourage Conferences And Seminars 00:04:00 The Feedback Loop 00:02:00 Learning Is Expensive 00:03:00 Learning Takes Time 00:02:00 Concluding Remarks 00:04:00 Section 04: Job Interview Practicals: Complete Interview Skills Training Interview Masterclass - Maximize Your Chances of Success 00:03:00 Get Yourself Game Ready! 00:08:00 Final Prep Tips! 1-2 Days Before Interview 00:03:00 It's Interview Day! How to ACE the interview! 00:07:00 Positive Personality Traits Interviewers Are Desperate For 00:07:00 How to Engage & Impress in Conversation 00:05:00 The Art of Asking Questions 00:08:00 How to Answer Questions Using Skill & Psychological Tricks 00:10:00 After Interview - Still More You Can Do 00:05:00 Staying Professional 00:02:00 That Wasn't What You Expected!! 00:03:00 Waiting For The Answer 00:02:00 Let's Review The Tips - So Much To Consider 00:04:00 Section 05: Beating Burnout - Practical & Complete Stress Management Introduction to Overcoming Burnout 00:03:00 The Problem of Burnout in Modern Workplaces 00:06:00 Symptoms of Burnout - Do You Have It? 00:03:00 How Individuals Can Fight Back Against Burnout 00:12:00 How Leaders Can Create A Burnout Free Culture 00:10:00 Let's Review The Advice - What's Important? 00:03:00 Section 06: Practical Leadership: Complete Guide To Great Leadership Characteristics of Great Leaders - Introduction 00:02:00 Honesty, Coaching & The Mission 00:08:00 Empathy, Togetherness & Feedback 00:06:00 Change, Authenticity & Enablement 00:05:00 Perspective, Empowerment & Emotional Intelligence 00:05:00 My Favourite Tips & Bonus! 00:05:00 Section 07: Mastering Meetings - A Complete Practical Guide To Meetings What to Expect 00:04:00 What & Why? 00:03:00 The Cost of Meetings 00:02:00 Red Amber & Green Meetings 00:06:00 Do You Need A Meeting? 00:04:00 Timing Considerations 00:07:00 Contents of the Invite 00:03:00 Scheduling Etiquette 00:07:00 Considerations for Externals 00:05:00 The Meeting as an Opportunity 00:02:00 Chairing Meetings 00:01:00 Your Agenda 00:08:00 Kicking Off 00:06:00 During The Meeting 00:08:00 After Meeting Minutes 00:06:00 Considerations 00:06:00 Concluding Remarks 00:02:00 Section 08: Advanced People Management - What They Don't Tell You About Team Leading! What To Expect & About Me 00:02:00 Management Vs. Coaching 00:07:00 What Is Culture? 00:02:00 Culture of Fairness 00:08:00 How To Be A Great Listener 00:05:00 Mastering Performance Evaluations 00:07:00 Welcoming New Starters 00:07:00 Stupid Things NOT To Say To Your Team 00:07:00 Your Team Made A Mistake 00:06:00 Mastering Crucial Conversations 00:05:00 When to Fire Someone 00:06:00

The series CompTIA A+ 900 Certification Advanced Diploma provides an extensive lesson about CompTIA A+ 900 Certification. A+ Certification is one of the leading certificates in the computer industry. It certifies the competency of PC Service Specialists. Sponsored by CompTIA - the Computing Technology Industry Association, and tests, the course is administered by Pearson VUE. The course includes more than 50 lessons related to the Computer industry. The course starts by describing firmware and BIOS configuration options. After that, the course will teach you about the motherboard basics including motherboard sizes, form factors, and AMD CPU socket types. The course also includes topics such as Expansion slots, RAM types and features, install and configure PC expansion cards, install and configure storage device, CPU's and cooling methods and PC connection interfaces. The course will also focus on power supplies, PC connectors, printing technologies, networking tools, etc. In short, the course provides all the necessary information about computer hardware and operating system. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then CompTIA A+ 900 Certification Advanced Diploma is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the accredited qualification. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £30,000. The sky really is the limit. Course Curriculum Configuring BIOS Firmware 00:07:00 BIOS Configuration Options 00:25:00 Motherboards Motherboard Sizes Form Factors 00:14:00 The Motherboard 00:12:00 AMD CPU Socket Types 00:11:00 Expansion Slots Expansion Cards 00:13:00 Bus Speeds 00:28:00 RAM Types and Features Memory 00:06:00 Types of RAM 00:07:00 Install and Configure PC Expansion Cards Ports 00:11:00 SCSI Connections 00:14:00 Audio Video Connections 00:26:00 Install and Configure Storage Devices Storage Devices 00:17:00 Hard Drives 00:17:00 Media Capacity 00:21:00 CPU's and Cooling Methods CPU Types and Characteristics 00:14:00 PC Connection Interfaces Physical Connections USB 00:11:00 Physical Connections VGA 00:11:00 Wireless Connections Bluetooth 00:06:00 Power Supplies Power Supply Specifications 00:16:00 Custom Computer Specifications What is a Standard Client 00:13:00 Audio Video Editing Workstations 00:08:00 Installing Displays Display Device Types 00:20:00 Backlighting 00:12:00 PC Connectors DVI to HDMI 00:13:00 Installing Peripheral Standard Input Device Types 00:16:00 Expansion Card Types 00:11:00 Multimedia Devices 00:11:00 Installing Multifunction Devices and SOHO Networks SOHO Networks 00:17:00 WPS 00:16:00 Encryption 00:14:00 Printer Technologies Printers 00:02:00 Printer Technologies Topic B Inkjet Printers 00:13:00 Printer Maintenance Technical Printer Components 00:09:00 Local and Network-Based Printers 00:22:00 Networking Network Interface Card Characteristics 00:20:00 Fiber Optic Cables 00:14:00 Properties and Characteristics of TCP/IP TCP IP 00:14:00 IP Address Classes 00:14:00 Addressing Schemes 00:17:00 TCP vs. UDP Ports 00:09:00 LDAP 00:04:00 Wi-Fi Networking Standards and Encryption Types Standards 00:03:00 Install and Configure SOHO Wireless/Wired Router Setting up your Router 00:10:00 Define Appropriate NAT Policies 00:16:00 Architecture and Internet Connection Types LANs 00:08:00 Network Topologies 00:11:00 ISPs 00:06:00 Networking Tools Cable Testers 00:13:00 Laptop Hardware Components Laptops 00:09:00 Laptop Expansion Options 00:10:00 Auto-Switching and Fixed Input Power Supplies 00:09:00 Mobile Devices What is Mobile Technology 00:09:00 Mobile Device Features 00:09:00 Bluetooth Configuration Method 00:08:00 Mobile Device Ports and Accessories Mobile Device Connection Types 00:10:00 Troubleshooting Mobile Devices 00:11:00 Troubleshooting Theory Troubleshooting Theory 00:16:00 Boot to Incorrect Device 00:16:00 PC Indicator Lights 00:10:00 Repair vs. Replace 00:10:00 Troubleshooting RAID Arrays and Hard Drives Drive and Array Troubleshooting Tools 00:06:00 Common RAID Array Issues 00:17:00 Troubleshooting Video Common Video and Display Issues 00:01:00 Troubleshooting Network Issues Common Network Issues 00:12:00 Troubleshooting Printers Common Printer Troubleshooting Tools 00:14:00 Windows Operating Systems Microsoft Windows 00:12:00 Microsoft Windows Features 00:17:00 Other Operating Systems 01:00:00 Installation Types 00:14:00 Customizing System Options 00:19:00 Command Line Tools The Command Prompt 00:12:00 Microsoft Operating System Features and Tools Administrative Tools 00:41:00 Task Manager 00:28:00 Memory Diagnostic Tool 00:46:00 Control Panel Utilities The Control Panel 00:11:00 Internet Options 00:10:00 Types of User Accounts 00:11:00 Computer My Computer 00:13:00 Permissions 00:31:00 System 00:10:00 Windows Networking on Client Desktops Workgroups 00:20:00 Network Connection Types 00:18:00 Preventative Maintenance Data Backup and Restoration 00:11:00 Scheduling Tasks 00:26:00 Features and Functionality of the Mac OS and Linux Operating Systems Patch Management in Mac OS X and Linux 00:09:00 Screen Sharing 00:06:00 Mac OS Multitouch Gestures - Touchscreen 00:09:00 Client Side Virtualization What is Virtualization 00:08:00 Virtual Desktop Infrastructure 00:12:00 Cloud-based Concepts SaaS (Software as Service) 00:09:00 Network Host Properties Server Roles 00:12:00 Mobile Operating Systems Open Source Software 00:03:00 Mobile Device Network and E-mail Mobile Device Hotspot 00:10:00 Security Malware 00:09:00 Social Engineering 00:13:00 Prevention Methods Physical Security 00:14:00 Hard Drive Sanitation 00:14:00 User Education 00:26:00 Windows Security Settings Users and Groups 00:11:00 Security Best Practices Password Best Practices 00:04:00 Securing Mobile Devices Locks 00:07:00 Troubleshooting Common PC Tools Operating System Troubleshooting Tools 00:12:00 Application Errors 00:16:00 Common Network Issues 00:12:00 Common Security Issues 00:10:00 Common PC Security Issues Browser Issues 00:06:00 Common Mobile Operating Systems Troubleshooting Dim Display 00:09:00 No Sound from Speakers 00:07:00 Common Safety Practices Static Electricity 00:14:00 Electrical Hazards 00:12:00 General Power Issues 00:10:00 Hazardous Material Disposal Procedures 00:07:00 Maintenance Tools and Techniques Professional Conduct 00:11:00 Types of Hardware Toolkits 00:11:00 Hard Drive Self-Tests 00:05:00 Computer Component Maintenance Techniques 00:10:00 Privacy and Licensing Concepts Incident Response 00:08:00 Proper Communication and Professionalism 00:07:00 Set Expectations 00:06:00 Mock Exam Mock Exam - CompTIA A+ 900 Certification Advanced Diploma 00:20:00 Final Exam Final Exam - CompTIA A+ 900 Certification Advanced Diploma 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 Microsoft Power BI Masterclass 2021 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Microsoft Power BI Masterclass 2021 Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Power BI Masterclass 2021 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Microsoft Power BI Masterclass 2021 Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Microsoft Power BI Masterclass 2021? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Power BI Masterclass 2021 there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Power BI Masterclass 2021 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill.   Prerequisites This Microsoft Power BI Masterclass 2021 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Power BI Masterclass 2021 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Power BI Masterclass 2021 is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:02:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up - Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Microsoft Power BI Masterclass 2021 00:00:00 Assignment Assignment - Microsoft Power BI 00:00:00

Are you fascinated by the world of financial crime? Ready to delve into the intricate art of investigation? Our comprehensive Financial Investigator Training is designed just for you! Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In the Financial Investigator Training, learners will explore the fundamentals of financial investigation, including the various types and characteristics of financial crimes. They will gain a comprehensive understanding of the laws and regulations aimed at combating financial fraud. Through practical exercises, they will develop skills in collecting, preserving, and analyzing evidence crucial to financial investigations. Additionally, participants will learn about the role and responsibilities of a financial investigator, along with the essential components of a financial crime response plan. This curriculum equips learners with the knowledge and techniques necessary to identify, investigate, and respond to various forms of financial crime effectively. Course Curriculum Module 01: Introduction to Financial Investigation Module 02: Introduction to Financial Investigator Module 03: Categories of Financial Crimes Module 04: Characteristics of Financial Crimes Module 05: Laws against Financial Fraud Module 06: Collecting, Preserving and Gathering Evidence Module 07: Financial Crime Response Plan Learning Outcomes: Identify key concepts in financial investigation techniques for introductory understanding. Recognize the role and responsibilities of a financial investigator proficiently. Classify various types of financial crimes accurately and categorically. Describe essential characteristics distinguishing different forms of financial crimes concisely. Summarise relevant laws concerning financial fraud adequately and comprehensively. Demonstrate proficiency in collecting, preserving, and handling evidentiary material meticulously. CPD 10 CPD hours / points Accredited by CPD Quality Standards Financial Investigator Training 1:09:40 1: Module 01: Introduction to Financial Investigation 07:23 2: Module 02: Introduction to Financial Investigator 13:01 3: Module 03: Categories of Financial Crimes 12:14 4: Module 04: Characteristics of Financial Crimes 07:40 5: Module 05: Laws against Financial Fraud 10:39 6: Module 06: Collecting, Preserving and Gathering Evidence 07:30 7: Module 07: Financial Crime Response Plan 10:13 8: CPD Certificate - Free 01:00 Who is this course for? Law enforcement professionals seeking financial investigation specialisation. Financial analysts aiming to broaden their skill set in investigation techniques. Compliance officers wishing to enhance their understanding of financial crimes. Legal professionals interested in gaining expertise in financial fraud investigation. Anyone looking to pursue a career in financial crime investigation. Career path Financial Investigator Fraud Analyst Compliance Officer Intelligence Analyst Law Enforcement Officer Forensic Accountant Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you fascinated by the world of financial crime? Ready to delve into the intricate art of investigation? Our comprehensive Financial Investigator Training is designed just for you! Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In the Financial Investigator Training, learners will explore the fundamentals of financial investigation, including the various types and characteristics of financial crimes. They will gain a comprehensive understanding of the laws and regulations aimed at combating financial fraud. Through practical exercises, they will develop skills in collecting, preserving, and analyzing evidence crucial to financial investigations. Additionally, participants will learn about the role and responsibilities of a financial investigator, along with the essential components of a financial crime response plan. This curriculum equips learners with the knowledge and techniques necessary to identify, investigate, and respond to various forms of financial crime effectively. Course Curriculum Module 01: Introduction to Financial Investigation Module 02: Introduction to Financial Investigator Module 03: Categories of Financial Crimes Module 04: Characteristics of Financial Crimes Module 05: Laws against Financial Fraud Module 06: Collecting, Preserving and Gathering Evidence Module 07: Financial Crime Response Plan Learning Outcomes: Identify key concepts in financial investigation techniques for introductory understanding. Recognize the role and responsibilities of a financial investigator proficiently. Classify various types of financial crimes accurately and categorically. Describe essential characteristics distinguishing different forms of financial crimes concisely. Summarise relevant laws concerning financial fraud adequately and comprehensively. Demonstrate proficiency in collecting, preserving, and handling evidentiary material meticulously. CPD 10 CPD hours / points Accredited by CPD Quality Standards Financial Investigator Training 1:09:40 1: Module 01: Introduction to Financial Investigation 07:23 2: Module 02: Introduction to Financial Investigator 13:01 3: Module 03: Categories of Financial Crimes 12:14 4: Module 04: Characteristics of Financial Crimes 07:40 5: Module 05: Laws against Financial Fraud 10:39 6: Module 06: Collecting, Preserving and Gathering Evidence 07:30 7: Module 07: Financial Crime Response Plan 10:13 8: CPD Certificate - Free 01:00 Who is this course for? Law enforcement professionals seeking financial investigation specialisation. Financial analysts aiming to broaden their skill set in investigation techniques. Compliance officers wishing to enhance their understanding of financial crimes. Legal professionals interested in gaining expertise in financial fraud investigation. Anyone looking to pursue a career in financial crime investigation. Career path Financial Investigator Fraud Analyst Compliance Officer Intelligence Analyst Law Enforcement Officer Forensic Accountant Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you fascinated by the world of financial crime? Ready to delve into the intricate art of investigation? Our comprehensive Financial Investigator Training is designed just for you! Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In the Financial Investigator Training, learners will explore the fundamentals of financial investigation, including the various types and characteristics of financial crimes. They will gain a comprehensive understanding of the laws and regulations aimed at combating financial fraud. Through practical exercises, they will develop skills in collecting, preserving, and analyzing evidence crucial to financial investigations. Additionally, participants will learn about the role and responsibilities of a financial investigator, along with the essential components of a financial crime response plan. This curriculum equips learners with the knowledge and techniques necessary to identify, investigate, and respond to various forms of financial crime effectively. Course Curriculum Module 01: Introduction to Financial Investigation Module 02: Introduction to Financial Investigator Module 03: Categories of Financial Crimes Module 04: Characteristics of Financial Crimes Module 05: Laws against Financial Fraud Module 06: Collecting, Preserving and Gathering Evidence Module 07: Financial Crime Response Plan Learning Outcomes: Identify key concepts in financial investigation techniques for introductory understanding. Recognize the role and responsibilities of a financial investigator proficiently. Classify various types of financial crimes accurately and categorically. Describe essential characteristics distinguishing different forms of financial crimes concisely. Summarise relevant laws concerning financial fraud adequately and comprehensively. Demonstrate proficiency in collecting, preserving, and handling evidentiary material meticulously. CPD 10 CPD hours / points Accredited by CPD Quality Standards Financial Investigator Training 1:09:40 1: Module 01: Introduction to Financial Investigation 07:23 2: Module 02: Introduction to Financial Investigator 13:01 3: Module 03: Categories of Financial Crimes 12:14 4: Module 04: Characteristics of Financial Crimes 07:40 5: Module 05: Laws against Financial Fraud 10:39 6: Module 06: Collecting, Preserving and Gathering Evidence 07:30 7: Module 07: Financial Crime Response Plan 10:13 8: CPD Certificate - Free 01:00 Who is this course for? Law enforcement professionals seeking financial investigation specialisation. Financial analysts aiming to broaden their skill set in investigation techniques. Compliance officers wishing to enhance their understanding of financial crimes. Legal professionals interested in gaining expertise in financial fraud investigation. Anyone looking to pursue a career in financial crime investigation. Career path Financial Investigator Fraud Analyst Compliance Officer Intelligence Analyst Law Enforcement Officer Forensic Accountant Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.