1639 Database courses in Cardiff delivered Online

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

At work, are you required to use the Microsoft Office 2016 suite, including Word, Excel, PowerPoint, Access, and Outlook? If so, then why not master both the basic and advanced features of these in order to fully benefit your career. Whether you’re a Microsoft Office 2016 beginner or otherwise, taking our popular Microsoft Office 2016 Complete Course will help you to learn new skills. Packed into logical sections and bite-sized modules taught by experts in their field, the course teaches you everything you need to know to use each of the programmes in the Microsoft Office 2016 suite. Working logically through all programmes, the course shows learners how to take full advantage of the Microsoft Office 2016 suite and improve productivity. On completion of the course, you’ll be able to create, edit and effectively maintain Word documents, workbooks and spreadsheets, presentations, desktop databases and emails. Students will also receive an internationally respected certification. If you wish to show your employer that your Microsoft Office 2016 skills are outstanding, then this course is for you. Why choose this course Earn a free e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? This course is ideal for anyone looking to gain Microsoft Office Specialist (MOS) certification. It is aimed at those who wish to develop their skills using Microsoft Office applications, or those in or seeking any office role, including that of PA, Secretary, Admin Assistant, and Administrator, Office Manager, and so on. No experience or previous qualifications are required, so it is available to all students, of all academic backgrounds. Career Path Administrative Assistant – £18K–£30K Data Analyst – £25K–£45K Office Manager – £24K–£40K Executive Assistant – £25K–£50K Financial Analyst – £30K–£60K Project Coordinator – £22K–£38K Course Contents Microsoft Word 2016 Microsoft Excel 2016 Microsoft PowerPoint 2016 Microsoft Outlook 2016 Microsoft Access 2016

Are you looking to enhance your Customer Service & CRM skills? If yes, then you have come to the right place. Our comprehensive course on Customer Service & CRM will assist you in producing the best possible outcome by mastering the Customer Service & CRM skills. The Customer Service & CRM course is for those who want to be successful. In the Customer Service & CRM course, you will learn the essential knowledge needed to become well versed in Customer Service & CRM. Our course starts with the basics of Customer Service & CRM and gradually progresses towards advanced topics. Therefore, each lesson of this Customer Service & CRM course is intuitive and easy to understand. Why would you choose the Customer Service & CRM course from Compliance Central: Lifetime access to Customer Service & CRM course materials Full tutor support is available from Monday to Friday with the Customer Service & CRM course Learn Customer Service & CRM skills at your own pace from the comfort of your home Gain a complete understanding of Customer Service & CRM course Accessible, informative Customer Service & CRM learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the bundle Study Customer Service & CRM in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Course Improve your chance of gaining in demand skills and better earning potential by completing the Customer Service & CRM Curriculum Breakdown of the Customer Service & CRM Course Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Customer Service & CRM course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Customer Service & CRM. It is also great for professionals who are already working in Customer Service & CRM and want to get promoted at work. Requirements To enrol in this course, all you need is a basic understanding of the English Language and an internet connection. Career path The Customer Service & CRM course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Customer Service & CRM. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Are you looking to enhance your IT Consultant skills? If yes, then you have come to the right place. Our comprehensive course on IT Consultant will assist you in producing the best possible outcome by mastering the IT Consultant skills. The IT Consultant course is for those who want to be successful. In the IT Consultant course, you will learn the essential knowledge needed to become well versed in IT Consultant. Our IT Consultant course starts with the basics of IT Consultant and gradually progresses towards advanced topics. Therefore, each lesson of this IT Consultant course is intuitive and easy to understand. Why would you choose the IT Consultant course from Compliance Central: Lifetime access to IT Consultant course materials Full tutor support is available from Monday to Friday with the IT Consultant course Learn IT Consultant skills at your own pace from the comfort of your home Gain a complete understanding of IT Consultant course Accessible, informative IT Consultant learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the IT Consultant Study IT Consultant in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your IT Consultant Course IT Consultant Curriculum Breakdown of the IT Consultant Course Course Outline: Section 01: How People Use Computers Section 02: System Hardware Section 03: Device Ports and Peripherals Section 04: Data Storage and Sharing Section 05: Understanding Operating Systems Section 06: Setting Up and Configuring a PC Section 07: Setting Up and Configuring a Mobile Device Section 08: Managing Files Section 09: Using and Managing Application Software Section 10: Configuring Network and Internet Connectivity Section 11: IT Security Threat Mitigation Section 12: Computer Maintenance and Management Section 13: IT Troubleshooting Section 14: Understanding Databases Section 15: Developing and Implementing Software CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The IT Consultant course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in IT Consultant. It is also great for professionals who are already working in IT Consultant and want to get promoted at work. Requirements To enrol in this IT Consultant course, all you need is a basic understanding of the English Language and an internet connection. Career path IT Project Manager: £40,000 to £80,000 per year IT Business Analyst: £35,000 to £60,000 per year IT Consultant: £35,000 to £70,000 per year Solutions Architect: £45,000 to £85,000 per year IT Service Delivery Manager: £40,000 to £70,000 per year IT Program Manager: £50,000 to £95,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

CRM (Customer Relationship Management) Online Do you want to get a comprehensive understanding of Customer Relationship Management? Then you are in the right place. Our CRM Course (Customer Relationship Management), focuses on strategies and tools to optimize interactions with customers. Participants of the CRM Course (Customer Relationship Management) learn to leverage CRM systems, analyse customer data and implement effective communication strategies. The CRM Course (Customer Relationship Management) covers customer retention, acquisition, and satisfaction. Our CRM Course (Customer Relationship Management) also emphasises the role of technology in enhancing relationships. Moreover, the CRM Course (Customer Relationship Management) include CRM implementation, customer segmentation, and the integration of sales. How to do marketing and customer service is also a part of this CRM Course (Customer Relationship Management). Participants of the CRM Course (Customer Relationship Management) will gain practical insights into building long-lasting customer connections. Why Choose the CRM (Customer Relationship Management) Course from Us Self-paced CRM course, access available from anywhere. Easy to understand, high-quality study materials. CRM Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the CRM course. Course Included Main Course: CRM (Customer Relationship Management) Free Courses Course 01: Level 2 Customer Service [ Note: Free PDF certificate as soon as completing the CRM: CRM course] CRM (Customer Relationship Management) Online Training Course Curriculum of CRM Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Assessment Method of CRM After completing each module of the CRM (Customer Relationship Management) Online Training, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification of CRM After completing the MCQ/Assignment assessment for the CRM (Customer Relationship Management) Online Training course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? CRM (Customer Relationship Management) Online Training This CRM: CRM Course (Customer Relationship Management) is designed for anyone who wants to build strong customer relationships and improve their business prospects. Requirements CRM (Customer Relationship Management) Online Training There are no specific requirements for this CRM: CRM course because it does not require any advanced knowledge or skills. Career path CRM (Customer Relationship Management) Online Training Through this CRM: CRM Course (Customer Relationship Management) completion, you can get jobs like: CRM Analyst (£25,000 - £35,000) Manager (£30,000 - £50,000) Customer Service Manager (£25,000 - £50,000) Marketing Manager (£30,000 - £60,000) Sales Manager (£30,000 - £60,000) Certificates Certificate of completion Digital certificate - Included

Elevate your skills with the Diploma in Microsoft Azure 2017 – a comprehensive program offering in-depth insights and hands-on training in the latest cloud computing technologies. Master the intricacies of Microsoft Azure, stay ahead in the ever-evolving tech landscape, and unlock new career opportunities. Enroll now for a transformative learning experience that aligns with the cutting-edge advancements of 2017.

Transform your customer service expertise with our Advanced Diploma in Customer Service. Gain a comprehensive understanding of industry best practices, advanced communication strategies, and cutting-edge customer-centric approaches. Elevate your skills, boost customer satisfaction, and propel your career to new heights. Enroll now for a specialized program designed to empower you with the knowledge and tools needed to excel in the dynamic world of customer service.

Did you know that information technology is one of the fastest-growing fields in the technology industry? To meet employers’ growing demand, Janets has developed an IT Administrator Diploma to give students a kickstart in the field. You can become entrusted to implement and maintain computer systems, mobile devices, databases, and more through the IT Administrator Diploma. Thanks to our hands-on learning method using real hardware and software, you will receive individualised assistance from teachers and quickly develop the practical skills you need to succeed in the IT business. Learning Outcomes You will be able to install and configure software applications efficiently. You will be capable of troubleshooting and repairing hardware components effectively. Gain the skills to implement robust security measures to protect IT systems. Acquire proficiency in setting up and maintaining computer networks. Develop basic IT literacy encompassing fundamental concepts and terminology. Demonstrate proficiency in conducting software installations and updates proficiently. Execute hardware diagnostics and resolve technical issues with precision. Implement security protocols to safeguard against cyber threats and data breaches. Configure and manage network infrastructure to ensure optimal performance and connectivity. Apply IT principles and practices to enhance organisational productivity and efficiency. Why choose this course Affordable, Accessible, informative and well-structured study materials Earn a globally recognised accredited qualification Study in your own time, at your own pace, through any device Benefit from feedback through mock exams and multiple-choice assessments Excellent career advancement/career switch opportunities Get 24/7 help or advice from our email and live chat teams Who is this course for Aspiring IT professionals seeking to kickstart a career in system administration and network management. Individuals interested in acquiring foundational knowledge and skills in IT administration and support. Employees looking to enhance their IT literacy and expand their job opportunities in various industries. Entrepreneurs or small business owners aiming to manage their IT systems more effectively. Students pursuing higher education in computer science or related fields who require IT skills. Entry requirements This course is available to learners of all academic backgrounds, but you must be 16 or above to undertake the qualification. Apart from that, all you need is an internet connection, a good understanding of English and a passion for learning. Certification Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Method of Assessment On successful completion of the IT Administrator Diploma, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Career path IT Administrator Network Administrator Systems Administrator IT Support Specialist Help Desk Technician Technical Support Engineer Information Systems Manager Network Security Analyst Course Content Module 01: Software Module 02: Hardware Module 03: Security Module 04: Networking Module 05: Basic IT Literacy

The Computer Operating and Maintenance Experts Training course trains you to work as a Computer Operating and Maintenance Experts. The course shows you how to install operating software and hardware, how to work with internet and internet security, how to upgrade and maintain computers, how to troubleshoot networks and design databases, and more. This knowledge will help you to become an expert in computer operating and maintenances. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.

A course by Sekhar Metla IT Industry Expert RequirementsNo prior technical experience is required! All you need a computer!No SQL experience needed. You will learn everything you need to knowNo software is required in advance of the course (all software used in the course is free) Audience Beginner SQL, Data Science and Analytics - developers curious about SQL Career Anyone who wants to generate new income streams Anyone who works with data analytics, or databases! Anyone who wants to become Business intelligence developer Anyone who wants to start their own business or become freelance Anyone who wants to become a Data Science developer If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information Someone who wants to learn skills that give them the potential to earn near SIX figures! Audience Beginner SQL, Data Science and Analytics - developers curious about SQL Career Anyone who wants to generate new income streams Anyone who works with data analytics, or databases! Anyone who wants to become Business intelligence developer Anyone who wants to start their own business or become freelance Anyone who wants to become a Data Science developer If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information Someone who wants to learn skills that give them the potential to earn near SIX figures!