3163 Microsoft courses in Cardiff delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course is designed for post-sales audiences and is aimed at channel partners, customer network engineers and administrators whose interest is focused around designing a scalable infrastructure with the FlexPod. Overview Upon completing this course, you will be able to meet these overall objectives: Describe the FlexPod data center solutions and architecture Identify FlexPod workload sizing and technical specifications Describe the FlexPod deployment and management strategies The goal of this course is to evaluate the FlexPod solution design process in regards to the contemporary data center challenges. The course provides a comprehensive understanding of the reconnaissance and analytics to assess computing solution performance characteristics and requirements. In addition this course will describe the hardware components of the FlexPod and the process for selecting proper hardware for a given set of requirements. FlexPod Data Center Solutions and Architecture Describe data center elements Identify data center business challenges Identify data center environmental challenges Identify data center technical challenges Describe the data center consolidation trend Describe the FlexPod solution Identify the benefits of FlexPod Describe FlexPod platforms Describe FlexPod validated and supported designs Identify the supported Cisco UCS components Identify the supported Cisco Nexus switch components Identify the supported NetApp storage components FlexPod Workload Sizing and Technical Specifications Describe FlexPod performance characteristics Describe server virtualization performance characteristics Describe desktop virtualization performance characteristics Describe reconnaissance and analysis tools Describe the process for deploying analysis tools Configure the Microsoft MAP Toolkit Identify FlexPod Design components Describe FlexPod Sizing considerations Employ Cisco UCS Application Sizer Employ Cisco UCS VXI Resource Comparison tool Describe NetApp Solution Builder Sizing tool FlexPod Deployment and Management Strategies Describe key FlexPod LAN features Describe key FlexPod SAN features Identify FlexPod server provisioning features List FlexPod high availability features Describe supported FlexPod SAN features Describe FlexPod virtual storage tiering features Identify Cisco FlexPod validated designs Identify FlexPod data center with VMware vSphere 5.1 Identify FlexPod data center with VMware vSphere 5.1 with Cisco Nexus 7000 Identify FlexPod data center with Microsoft Private Cloud Enterprise Design Guide Identify FlexPod Select with Cloudera's Distribution including Apache Hadoop (CDH) Identify FlexPod Cisco Nexus 7000 and NetApp MetroCluster for multisite deployment Identify data center operations and management challenges Describe FlexPod validated management solutions Describe Cisco UCS Director turnkey solutions Identify Cisco UCS Director management types Describe Cisco UCS Director automation Describe self-service provisioning and reporting Identify the customer challenges and goals Describe the workload analysis Describe the component selection process Review the selected component Analyze the solution Additional course details: Nexus Humans Cisco Designing the FlexPod Solution (FPDESIGN) 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 Cisco Designing the FlexPod Solution (FPDESIGN) 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.

Microsoft Excel is more than just rows and columns — it's a powerhouse for professionals who know how to make it work for them. This course zeroes in on four of Excel’s most essential lookup functions: VLOOKUP, XLOOKUP, MATCH, and INDEX. Whether you're reconciling data, building dynamic reports, or navigating large spreadsheets, these tools save time, reduce errors, and make you look like you actually enjoy spreadsheets — even if you don’t. You'll learn how each function behaves, when to use one over the other, and how to string them together to achieve powerful results. The course is designed for learners who want to use Excel efficiently, without getting buried in formulas that behave like they’ve had too much coffee. With clear explanations, useful examples, and a touch of logic that even your sleep-deprived Monday brain can follow, this course gets straight to the point. If you've ever stared at a dataset wondering where to begin, you're in the right place — no fluff, just formulas that do the heavy lifting. Learning Outcomes: Utilise Vlookup and Xlookup to retrieve data efficiently Understand how to use Match and Index functions Learn to compare and match large data sets Automate data processing and analysis Improve data accuracy and reliability Increase productivity and save time on manual calculations Course Curriculum: 1.1 Excel vlookup 1.2 Excel xlookup 1.3 Excel vlookup 1.4 Excel vlookup 1.5 Excel vlookup 1.6 Excel vlookup 1.7 Excel vlookup How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Analyst (£26,000 - £45,000) Financial Analyst (£25,000 - £50,000) Business Analyst (£26,000 - £52,000) Accountant (£22,000 - £48,000) Operations Manager (£24,000 - £61,000) Project Manager (£29,000 - £65,000) Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code. This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 1: Introduction to TSQL for Business Intelligence Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 4: Creating an Appropriate Aggregation Level Using GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 7: Getting Your Dataset to the Client Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Additional course details: Nexus Humans Writing Analytical Queries for Business Intelligence 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 Writing Analytical Queries for Business Intelligence 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.

Course Overview This "Microsoft Power BI - Master Power BI in 90 Minutes!" course offers a concise yet comprehensive introduction to Power BI, empowering learners to quickly create and manage data dashboards. The course is designed for both newcomers and those looking to enhance their skills, covering essential topics to help users understand and utilise Power BI for data analysis and reporting. Upon completion, learners will gain the ability to design dynamic dashboards, manipulate data, and visualise trends, providing valuable insights for decision-making in various business environments. Course Description This course takes learners through Power BI’s core functionalities, starting with an introduction to the platform before advancing to building basic and sophisticated dashboards. Learners will explore key aspects such as data import, filtering, and the creation of interactive visuals. By working with live data, participants will develop an understanding of how to generate real-time reports, enhancing their ability to analyse data and derive insights. The course offers both beginner and advanced concepts, ensuring that all participants can apply what they’ve learned to real-world data scenarios. Upon completing the course, learners will feel confident in their ability to utilise Power BI to its full potential in any business context. Course Modules Module 01: Power BI - Introduction Module 02: Your First Power BI Dashboard Module 03: Your Advanced Power BI Dashboard with Real Live Data Module 04: Course Bonuses (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to improve data visualisation and reporting capabilities. Beginners with an interest in business intelligence or data management. Anyone looking to gain insights into data-driven decision-making. Career Path Business Intelligence Analyst Data Analyst Data Visualisation Specialist Marketing Data Analyst Financial Analyst

With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Get ready for an exceptional online learning experience with the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Trading & Investment package has something for everyone. As part of the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) package, you will receive complimentary PDF certificates for all courses in Trading & Investment bundle at no extra cost. Equip yourself with the Trading & Investment bundle to confidently navigate your career path or personal development journey. Enrol our Trading & Investment bundle today and start your career growth! This Trading & Investment Bundle Comprises the Following CPD Accredited Courses: Course 01: Stock Market Investing for Beginners Course 02: Forex Trading Diploma Course 03: Investment Course 04: Technical Analysis Masterclass for Trading & Investing Course 05: Complete Swing Trading Training Course 06: Trading - Gold Trading Course 07: Cryptocurrency: Wallets, Investing & Trading Course 08: Trading and Financing: Candlestick Pattern Course 09: Stock Trading Analysis with Volume Trading Course 10: Stock Market Day Trading Strategies Course 11: Penny Stocks Trading Course 12: Day Trade Stocks with Price Action and Tape Reading Strategy Course 13: Capital Budgeting & Investment Decision Rules Course 14: Investment Banking: Venture Capital Fundraising for Startups Course 15: Anti-Money Laundering (AML) Training Course 16: Risk Management Course 17: Financial Ratio Analysis for Business Decisions Course 18: Data Analysis and Forecasting in Excel Course 19: Microsoft Excel Complete Course 2019 Course 20: Decision-Making and Critical Thinking Learning Outcome: By completing the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Trading & Investment Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Trading & Investment Bundle. Build a strong knowledge base in your chosen course via the Trading & Investment Bundle. Benefit from the flexibility and convenience of online learning. With the Trading & Investment package, validate your learning with a CPD certificate. Each course in Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock), a rich anthology of 15 diverse courses. Each course in the Trading & Investment bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle offers you the flexibility and convenience to learn at your own pace. Make the Trading & Investment package your trusted companion in your lifelong learning journey. CPD 210 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) course. Career path Unleash your potential with the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock)bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Feeling Stuck in Your Career? The Web Design with Basic HTML, Coding & Javascript 20 in 1 Courses Bundle is Your Skill-Building Solution. This exceptional collection of 20 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, Web Design with Basic HTML, Coding & Javascript bundle provides an engaging learning experience, helping you learn skills across various disciplines. With The Web Design with Basic HTML,Coding & Javascript 20 in 1 Courses Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. Web Design with Basic HTML, Coding & Javascript bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of The Web Design with Basic HTML, Coding & Javascript 20 in 1 Courses bundle on your job life and career growth! This The Web Design with Basic HTML,Coding & Javascript 20 in 1 Courses Bundle Comprises the Following CPD Accredited Courses: Course 01: Basic HTML 5 Course 02: Learn CSS Coding from Scratch Course 03: JavaScript for Everyone Course 04: Web Design for Beginners: Build Websites in HTML & CSS Course 05: Masterclass Bootstrap 5 Course - Responsive Web Design Course 06: Bootstrap 4 Responsive Web Development Course 07: Web Design and WordPress Training Course 08: Diploma in Web Design - Video Training Course 09: HTML Web Development Crash Course Course 10: PHP Webforms for Everyone Course 11: Web Design in Affinity Designer Course 12: Modern PHP Web Development w/ MySQL, GitHub & Heroku Course 13: Restful API Web Services with PHP and MySQL: Bootcamp Course 14: Learn to Build Complete CMS Blog in PHP MySQL Bootstrap & PDO Course 15: SQL for Data Science, Data Analytics and Data Visualization Course 16: Microsoft SQL Server Development for Everyone Course 17: jQuery: JavaScript and AJAX Coding Bible Course 18: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 19: Web Design with Adobe XD Course 20: PHP for Beginners 2023 Guide: Develop a E-Commerce Store What will make you stand out? Upon completion of this online The Web Design with Basic HTML,Coding & Javascript 20 in 1 Courses Bundle, you will gain the following: CPD QS Accredited Proficiency with this Web Design with Basic HTML,Coding & Javascript Bundle After successfully completing Web Design with Basic HTML,Coding & Javascript bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Web Design with Basic HTML,Coding & Javascript Bundle The online test with immediate results You can study and complete Web Design with Basic HTML,Coding & Javascript bundle at your own pace. Study for Web Design with Basic HTML,Coding & Javascript bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Web Design with Basic HTM ,Coding & Javascript 20 in 1 Courses bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Web Design with Basic HTML,Coding & Javascript bundle, a comprehensive, complete collection of 20 courses. Each course in Web Design with Basic HTML ,Coding & Javascript bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Web Design with Basic HTML ,Coding & Javascript bundle offers the flexibility and convenience to learn at your own pace. Make the Web Design with Basic HTML ,Coding & Javascript package your trusted partner in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Web Design with Basic HTML ,Coding & Javascript 20 in 1 Courses is perfect for: Expand your knowledge and skillset for a fulfilling career with Web Design with Basic HTML ,Coding & Javascript bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with Web Design with Basic HTML ,Coding & Javascript bundle. Discover your passion or explore new career options with the diverse learning opportunities in Web Design with Basic HTML ,Coding & Javascript bundle. Learn on your schedule, in the comfort of your home - Web Design with Basic HTML ,Coding & Javascript bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with Web Design with Basic HTML ,Coding & Javascript bundle. Certificates CPD Certificates Digital certificate - Included

From downloading and installing to creating beautiful dashboards, this course takes you through all the essential concepts of the MicroStrategy Desktop application. You will learn to import data from Excel and transform this data into appealing charts, filters, and graphs that are easy to understand.