1724 Analytics courses delivered Online

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL

Our Digital Marketing Training course offers comprehensive insights into online marketing strategies, SEO, social media, and analytics. Gain practical skills to excel in the ever-evolving digital landscape. Join us to boost your career in the digital marketing world.

***24 Hour Limited Time Flash Sale*** Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Do you spend hours wrestling with spreadsheets? In the UK, 70% of businesses rely on Excel, but 56% of employees lack the skills to use it effectively. Imagine the time saved and insights gained by mastering this essential tool! This comprehensive Microsoft Excel bundle empowers you to transform data into meaningful insights, driving better decision-making and career advancement. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Bundle: Course 01: Microsoft Excel Course 02: New Functions in Microsoft Excel 2021 Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 04: Microsoft Excel: Excel Sheet Comparison with VBA Course 05: Microsoft Excel: Master Power Query in 120 Minutes! Course 06: Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course 07: Office Skills and Administration Management Diploma Course 08: Excel Vlookup, Xlookup, Match, and Index Course 09: Complete Microsoft Power BI 2021 Course 10: Microsoft Access Databases Forms and Reports Course 11: Excel spreadsheet for Beginner Course 12: Data Protection and Data Security Level 2 Course 13: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 14: MS Word Diploma Course 15: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 16: Excel PowerQuery and PowerPivot Course 17: PowerBI Formulas Course 18: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 19: Excel Must Know Formulas and Functions Course 20: Microsoft Teams Course 21: Excel Data Analysis Course 22: Excel Pivot Tables Course 23: Proofreading & Copyediting Course 24: Microsoft Access Tables and Queries Course 25: PowerPoint Diploma Course 26: Document Control Course 27: Outlook Tips and Tricks Course 28: Touch Typing Essentials Course 29: Data Analysis in Microsoft Excel Complete Training Course 30: The Complete Microsoft Outlook Masterclass With Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Learning Outcomes Confidently apply essential and advanced Excel formulas. Automate tasks with VBA and Power Query for efficiency. Create interactive dashboards for data visualisation. Compare spreadsheets seamlessly using advanced techniques. Extract valuable insights from your data with PivotTables and Power BI. Become a sought-after Excel expert in your workplace. Don't let this opportunity pass you by. Enrol in Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query today and take the first step towards achieving your goals and dreams. Why buy this bundle? Free CPD Accredited Certificate upon completion of this bundle Get a free student ID card with this bundle Lifetime access to the course materials Get instant access to this Microsoft Excel course Learn Microsoft Excel from anywhere in the world 24/7 tutor support with the Microsoft Excel course. Start your learning journey straightaway with our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Training! Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification of Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query You have to complete the assignment given at the end of the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. After passing the Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course is ideal for: Students seeking mastery in Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Professionals seeking to enhance Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query skills Individuals looking for a Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query-related career. Anyone passionate about Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Requirements This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query doesn't require prior experience and is suitable for diverse learners. Career path This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query bundle will allow you to kickstart or take your career in the related sector to the next stage. Data Analyst Business Intelligence Specialist Financial Analyst Project Manager Consultant Entrepreneur Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Duration 1 Days 6 CPD hours This course is intended for The audience for this course includes professionals who are new to Looker who are interested in leveraging Looker for data analysis, visualization, and reporting. The course is designed for individuals seeking to gain a comprehensive understanding of Looker's functionalities and apply these skills in their organizations to drive data-driven decision-making. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore and gain: Solid foundation in Looker's platform: Acquire a comprehensive understanding of Looker's key features, functionality, and interface, enabling you to effectively utilize the platform for your data analysis and visualization needs. Proficiency in LookML and data modeling: Develop essential skills in Looker's unique data modeling language, LookML, to create efficient and customized data models tailored to your organization's specific requirements. Expertise in creating Explores: Learn how to build, customize, and save Explores with dimensions, measures, filters, and calculated fields, empowering you to analyze your data and uncover valuable insights in a short amount of time. Mastery of dashboard design and visualization: Gain the skills to design visually appealing and informative dashboards, create various types of visualizations, and customize them to effectively communicate your data story. Improved content organization with folders and boards: Understand how to effectively use folders and boards in Looker to organize, manage, and discover content, making your data insights easily accessible for you and your team. Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker is a one day, hands-on course designed to equip professionals from a variety of backgrounds with the knowledge and skills needed to harness the full potential of their data using Looker's powerful platform. With the guidance of our expert trainers, you will gain a basic understanding of Looker's features, enabling you to create visually engaging, interactive, and insightful reports and dashboards to drive informed decision-making. Throughout this interactive workshop, you will explore Looker's key functionalities, including connecting to data sources, mastering LookML, building custom Explores, and designing captivating dashboards. With about 40% of the course dedicated to hands-on labs and a guided project, you will have ample opportunity to apply the skills you've learned in real world scenarios. Don't miss this opportunity to elevate your data analysis and visualization capabilities, enhance your professional skill set, and unlock the power of data-driven decision making. Getting Started with Looker Overview of Looker and its key features Navigating the Looker interface Connecting to Data Sources and LookML Basics Setting up and managing data connections Exploring database schemas Understanding LookML: Looker's data modeling language Creating and Customizing Explores Building and customizing Explores Adding dimensions, measures, and filters Creating calculated fields Data Visualization and Dashboard Design Creating visualizations using Looker's visualization library Customizing chart types, colors, and labels Displaying visualizations in dashboards Organizing Content with Folders and Boards Introduction to folders and boards in Looker Creating and managing folders for organizing content Setting up boards for easy content discovery Hands-on Workshop and Project Participants work on a guided project to apply the skills learned Wrap-up and Q&A Additional course details: Nexus Humans Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker (TTDVLK01) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker (TTDVLK01) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

Overview Did you know that the global HR industry is currently worth around £17,48 billion? Get a chance to shine in this highly prospective and competitive field through our HR Management bundle. Our precisely crafted courses will help you establish yourself in this field! HR is more than just a division of a company. It is essential to any business and worker's success and is the lifeblood of an organisation. The Human Resources principles covered in this CPD-accredited course will adequately equip you to begin a career in the related industry. For organisations of all sizes, managing daily HR tasks is a difficult undertaking that needs the assistance of an HR consultant. Moreover, this course will give you the essential knowledge you need to create individualised training plans and effectively handle human resources-related demands. Following your successful completion, you will have highly developed abilities that will enable you to design and manage the recruiting and selection process, organise and carry out training, implement performance improvement training, and more. Along with this HR Management Complete Bundle, you will get an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. What other courses are included with this Bundle? Course 1: Level 3 Diploma Course 2: HR And Recruitment Consultant Training Course 3: Employment Law Course 4: Office Administration Certificate Course 5: Contract Manager Diploma Course 6: Payroll Management Course Course 7: GDPR Course 8: Workplace Confidentiality Course 9: Leadership & Management Diploma Course 10: Performance Management Course 11: Effective Communication Skills Learning Outcomes The students undertaking this course will get the opportunity to - Get Introduced to Human Resources (HR) Understand the employee recruitment and selection procedure Learn the skills of an effective administrator Understand the employee training and development process Learn about performance appraisal management and employee relations Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable experience without leaving your home How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Description Begin your HR journey with Apex Learning right away! The management of human resources is essential to the success of any company and employee. In addition to ensuring regulatory compliance, HR is in charge of keeping staff members interested and inspired to perform well. This course will provide you with the overview required to achieve your objective, whether you are entirely new to human resources, are interested in learning more about the field, or need to create a more effective HR department. Additionally, students will study about the evolving function of HR, including a historical review, important procedures and duties, and contemporary trends influencing the development of HR practices. With the help of this HR Management Bundle, you will get the core knowledge necessary to create customised training plans and effectively handle human resources-related demands.When you need them, knowledgeable teachers and mentors will be available to you and will answer any of your questions via email and chat rooms. Course Curriculum of Bundle Module 01: Introduction to Human Resource In this module we will cover the following topics: Human resource management Models of HRM The Role of the HR Department Aims of HRM HRM and personnel management Impacts HR have on Organisational Performance Module 02: Employee Recruitment and Selection Procedure In this module we will cover the following topics: Attracting candidates Advertising E-recruitment Graphology Final stages Module 03: Employee Training and Development Process In this module we will cover the following topics: The justification for training Transferring training Systematic training Types of training Effective training practices Training techniques E-learning Module 04: Performance Appraisal Management In this module we will cover the following topics: The benefit of performance management Characteristics of performance management Performance management cycle Managing performance throughout the year Reviewing performance Rating performance Dealing with under-performers Module 05: Employee Relations In this module we will cover the following topics: Strategic Employee Relations Practice of Industrial Relations Employee Voice Employee Communications Module 06: Motivation and Counselling In this module we will cover the following topics: The process of motivation Types of motivation Motivation theory Motivation strategies Module 07: Ensuring Health and safety at the Workplace In this module we will cover the following topics: Managing Health and Safety At Work The importance of health and safety in the workplace Benefits of workplace health and safety Health and safety policies Conducting risk assessments Accident prevention Measuring health and safety performance Health and safety training Module 08: Employee Termination In this module we will cover the following topics: Redundancy Dismissal Relieving Letter Retirement Module 09: Employer Record and Statistics In this module we will cover the following topics: Introduction The necessity for Personnel Records Information in Personnel Records Formats of Personnel Records Module 10: Essential UK Employment Law In this module we will cover the following topics: Introduction Wages Dismissal Equality Working Parents' Rights Data Protection (GDPR) Course 2: HR And Recruitment Consultant Training Introduction to Recruitment: Importance and Implications An Overview of the Recruitment Industry The UK Recruitment Legislation Sales and Selling in the Recruitment Industry The Recruitment Process Key Performance Indicators for the Recruitment Industry Candidate Attraction for Recruitment Candidate Management Candidate Interview Processes And many more... Course 3: Employment Law Basic of Employment Law Legal Recruitment Process Employment Contracts Employee Handbook Disciplinary Procedure National Minimum Wage & National Living Wage Parental Right, Sick Pay & Pension Scheme Discrimination in the Workplace Health & Safety at Work Dismissal, Grievances and Employment Tribunals Workplace Monitoring & Data Protection Course 4: Office Administration Certificate Introduction to Office Administration Skills of an Effective Administrator Business Writing Skills Communication Skills Managing Meetings and Giving Feedback Organisational Skills Telephone Etiquette Negotiation Techniques Conflict Management Stress Management Time Management Course 5: Contract Manager Diploma Introduction to Contract Management Classification of Contracts Contract Lifecycle - Understanding The Stages Principles of English Contract Law Contract Management Plan & Efficiency Contract Manager's Roles, Responsibilities & Career Opportunities And many more... Course 6: Payroll Management Course Payroll System in the UK Payroll Basics Company Settings Legislation Settings Pension Scheme Basics Pay Elements The Processing Date Adding Existing Employees Adding New Employees Payroll Processing Basics Entering Payments Pre-Update Reports Updating Records e-Submissions Basics Process Payroll (November) Employee Records and Reports Editing Employee Records Process Payroll (December) Resetting Payments Quick SSP An Employee Leaves Final Payroll Run Reports and Historical Data Year-End Procedures Course 7: GDPR GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 11: Workplace Confidentiality Module 01: Introduction to workplace confidentiality Module 02: Business Etiquettes and Types of Confidentiality Module 03: The Importance of Confidentiality Module 04: Confidentiality with Co-workers Module 05: Preventing Confidentiality Breach Module 06: How Employers Can Protect Confidential Information Course 9: Preventing Workplace Violence and Harassment Section 1: Workplace Management: Violence What Is Workplace Harassment? Identifying the Bully How to Handle Workplace Violence Risk Assessment Being the Victim Checklist for Employers Interview Process Investigation Process Developing a Workplace Harassment Policy Section 2: Workplace Management: Harassment The Background Developing an Anti-Harassment Policy Policies in the Workplace Proper Procedures in the Workplace False Allegations Other Options Sexual Harassment Mediation Conflict Resolution The Aftermath Course 10: Performance Management Performance Management Introduction Performance Key Performance Indicators Reporting Rewarding Conclusion Course 11: Effective Communication Skills Business Communication Verbal and Non-verbal Communication Written Communication Electronic Communication Communicating with Graphics Effectively Working for Your Boss CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course bundle is designed for people who are - Looking to pursue a career in Human Resourse (HR). Willing to upgrade their skills. Trying to build an efficient workforce in HR. Working on boosting office productivity. Willing to ensure an employee friendly workplace. Requirements Our HR Management(HR) course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path HR has a huge job field. This course bundle will help the learners to pursue jobs that have huge demand in the job market, such as- Human resources officer Equalities officer Human Resources Assistant. HR Specialist Administrative Officer