5398 Courses in Cardiff delivered Online

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

In today’s digital age, ensuring your workstation is set up correctly is essential for maintaining both health and productivity. This course offers a structured approach to understanding the key aspects of computer workstation safety, providing guidance on how to optimise your working environment. Whether you spend long hours at a desk or simply use a computer for occasional tasks, this training will teach you the fundamentals of ergonomics, proper equipment placement, and posture management to avoid strain or injury. Our course is designed to equip individuals with the necessary knowledge to create a safe and comfortable workspace without the need for in-person instruction. It covers vital topics such as adjusting seating, screen positioning, and keyboard usage, all of which can help mitigate common issues like eye strain, back pain, and repetitive stress injuries. Delivered in an accessible online format, this training ensures you can improve your workstation safety at your own pace, promoting a healthier, more efficient working environment without the need for a classroom setting. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum of Computer Workstation Safety Training Module 01 :Introduction to Computer Workstation Safety Module 02 :Ergonomics in Computer Workstation Module 03 :Preventing Repetitive Strain Injuries (RSI) Module 04 :Preventing Eye Injuries Module 05 :Posture and Movement Module 06 :Stretching and Relaxation Techniques Module 07 :Digital Security Learning Outcomes: Master Ergonomic Principles Apply RSI Prevention Techniques Implement Eye Safety Measures Optimize Posture and Movement Execute Relaxation Techniques Strengthen Digital Security Awareness Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Office workers seeking to enhance workstation safety. IT professionals prioritizing digital security. Health and safety enthusiasts wanting specialised knowledge. Students aiming to bolster their employability. Managers striving for a safer work environment. Individuals concerned about long-term health impacts. Entrepreneurs focused on employee well-being. Anyone using a computer for extended periods. Career path Health and Safety Officer Ergonomics Consultant Occupational Health Specialist IT Security Analyst Office Manager Occupational Therapist Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Get ready for an exceptional online learning experience with the Merchandising Bundle! This carefully curated collection of 30 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. The Merchandising Bundle is a dynamic package that blends 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 Merchandising - Bundle package has something for everyone. As part of the Merchandising Bundle package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Merchandising bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following 30 CPD Accredited Courses: Course 01: Merchandising Course 02: Visual Merchandising Diploma Course 03: Store Assistant Course 04: Retail Management Course 05: Retail Associate Certificate Course 06: Fashion Store Assistant Course 07: Warehouse Operative Course 08: Inventory Controller Course 09: Product Management Course 10: Quality Management Course 11: Interior Design Diploma Course 12: Interior Design: Space Planning Course 13: Styling & Staging in Interior Design Course 14: Supply Chain Management Course 15: Certificate in Purchasing and Procurement Course 16: Purchase Ledger Course 17: Operations Management: Process Mapping & Supply Chain Course 18: Supply Chain Management for Different Retail Formats Course 19: Import/Export Course 20: Logistic Management Course 21: Transport Planner Course Course 22: Port Management Diploma Course 23: Level 3 E-commerce Management Course 24: Sales Negotiation Training Course Course 25: Creating Highly Profitable Sales Funnels Course 26: Customer Relationship Management Course 27: SAP Controlling (CO) - Product Costing S4HANA Course 28: Xero Accounting and Bookkeeping Training Course 29: Compliance and Risk Management Diploma Course 30: Workplace Productivity Training What will make you stand out? Upon completion of this online Merchandising bundle, you will gain the following: CPD QS Accredited Proficiency with this Merchandising bundle After successfully completing the Merchandising bundle, you will receive a FREE CPD PDF Certificates as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Merchandising bundle The online test with immediate results You can study and complete the Merchandising bundle at your own pace. Study for the Merchandising bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Merchandising 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 Merchandising, a rich anthology of 30 diverse courses. Each course in the Merchandising bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Merchandising 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 Merchandising bundle offers you the flexibility and convenience to learn at your own pace. Make the Merchandising package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Merchandising 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 You are cordially invited to enroll in this Merchandising bundle; please note that there are no formal prerequisites or qualifications required. We've designed this curriculum to be accessible to all, irrespective of prior experience or educational background. Career path Unleash your potential with the Merchandisingbundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Merchandising bundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before. Diploma of Landscape Architecture (Online) - CPD Certified Did you know that demand for Landscape Architects in the UK has soared by 20% in the last five years? Propel your career forward with our online "Diploma of Landscaping" course, offering CPD-certified, comprehensive, 4-in-1 bundled learning. Immerse yourself in a journey from fundamentals to advanced concepts taught by experienced professionals. Our structured, easy-to-follow modules equip you with the right skills and knowledge to excel in this rapidly-growing field. Set your career in motion today and become a part of the thriving £1 billion UK landscaping industry. Explore new horizons, learn from experts, and craft your future with the Diploma of Landscaping (Online). Courses Are Included in this Diploma of Landscaping (Online) - CPD Certified Bundle: Course 01: Diploma in Landscape Architecture at QLS Level 4 Course 02: Advanced Diploma in Architectural Studies at QLS Level 7 Course 03: Land Management Course Course 04: Environment Management Course Learning Outcomes of Landscape Architecture Gain comprehensive knowledge of landscaping principles, techniques, and design principles, with a focus on sustainability and environmental considerations. Develop practical skills in landscape planning, site analysis, and project management, enabling you to execute professional landscaping projects. Understand the UK landscaping industry's current trends and market demands, backed by up-to-date statistics and insights. Acquire proficiency in using industry-standard software and tools for landscape design, enhancing your efficiency and productivity. Receive a CPD certification upon completion, boosting your credibility and increasing your chances of securing lucrative job opportunities in the growing UK landscaping sector. Data: According to the Landscape Institute, the landscaping industry in the UK generates approximately £1 billion in revenue annually. Furthermore, the demand for skilled landscape architects is projected to grow by 14% by 2027, as reported by the Office for National Statistics. Why Choose Our Landscape Architecture Course? FREE Landscape Architecture certificate accredited Get a free student ID card with Landscape Architecture Training Learn Landscape Architecture from anywhere in the world Landscaping is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to the Landscape Architecture course materials Landscaping comes with 24/7 tutor support So enrol now in this Landscape Architecture Today to advance your career! Start your learning journey straightaway with Diploma of Landscape Architecture! This Landscape Architecture curriculum has been designed by Landscape Architectureexperts with years of experience behind them. This course is extremely dynamic and well-paced to help you understand Landscape Architecture with ease. You'll discover how to master the Landscaping skill while exploring relevant and essential topics. Assessment Process of Diploma of Landscape Architecture Once you have completed all the courses in the Landscape Architecture bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Diploma of Landscape Architecture (Online) - CPD Certified This Diploma of Landscape Architecture bundle is suitable for everyone. Requirements Diploma of Landscape Architecture (Online) - CPD Certified You will not need any prior background or expertise to enrol in this Diploma of Landscaping . Career path Diploma of Landscape Architecture (Online) - CPD Certified This Diploma of Landscape Architecture bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Plumbing: Plumbing Training Online Plumbing is a system of pipes and fixtures installed in a building for the distribution of potable water and the removal of waterborne wastes. Plumbing is usually distinguished from water and sewage systems, which serve a group of buildings or a city. Plumbers are skilled professionals who install and maintain piping and water systems in residential and commercial buildings. Do you want to start a plumbing: plumbing career or advance your plumbing skills? Then this Plumbing: Plumbing Course will provide you with a solid foundation to become a confident plumber and develop more advanced skills, whether you are self-taught and want to fill in the gaps for improved efficiency and productivity. Our Professional Plumbing: Plumbing Course will teach you the fundamental skills and knowledge needed to advance your career as a professional plumber. Special Offers of this Plumbing: Plumbing Course This Plumbing: Plumbing Course includes a FREE PDF Certificate. Lifetime access to this Plumbing: Plumbing Course Instant access to this Plumbing: Plumbing Course Get FREE Tutor Support from Monday to Friday in this Plumbing: Plumbing Course Why Choose This Plumbing: Plumbing Course from Us Plumbing: Plumbing Course developed by industry experts. Free PDF certificate as soon as completing the Plumbing: Plumbing course. Main Course: Professional Plumbing GIFT COURSES: Course 01: Communication Skills Course 02: Level 5 Negotiation Skills Course 03: Anger Management [ Note: Free PDF certificate as soon as completing the Plumbing: Plumbing course] Plumbing: Plumbing Training Course Curriculum of Professional Plumbing: Plumbing Training Industry Experts Designed this Professional Plumbing course into 04 detailed modules. Module 01: Introduction to Plumbing Module 02: Plumbing Terminologies Module 03: Water supply Module 04: Materials/Equipment Assessment Method of Plumbing: Plumbing After completing each module of the Plumbing: Plumbing Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Plumbing: Plumbing After completing the MCQ/Assignment assessment for this Plumbing: Plumbing course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Plumbing: Plumbing This comprehensive Plumbing: Plumbing Training is ideal for anyone looking to advance their career or improve their job prospects in the plumbing industry. Requirements Plumbing: Plumbing There are no specific requirements for this course because it does not require any advanced knowledge or skills. Career path Plumbing: Plumbing

Financial Investigator Training Course is Now The Most Demanding Course to Advance Your Career! Financial Investigator Course is for those who want to advance in this field. Throughout this course, you will learn the essential skills and gain the knowledge needed to become well versed in Personal Finance. Our course starts with the basics of Financial Investigator training and gradually progresses towards advanced topics. Therefore, each lesson of this course is intuitive and easy to understand. Financial Investigator Course Basic Learning Outcomes: Upon successful completion of this highly appreciated this Financial Investigator training Course, you'll be a skilled professional, besides- You can provide services related to Financial Investigator with complete knowledge and confidence. You'll be competent and proficient enough to explore Financial Investigator related job fields on your own. Furthermore, you can train up others and grow an efficient peer community in your locality and serve people. It will enhance your portfolio, you can use the certificate as proof of your efficiency to the employer. It will boost up your productivity, you can use the skill and credentials, and become more competent in your vocation with increased earning! So, stand out in the job market by completing the course. Get an accredited certificate and add it to your resume to impress your employers. Along with the Financial Investigator training course, you also get: Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials- Anytime, Anywhere - From Any Smart Device (Laptop, Tablet, Smartphone Etc.) 100% Learning Satisfaction Guarantee Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny, bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. Curriculum Breakdown of the Financial Investigator Course: Module 1: Introduction Module 2: Characteristics of Financial Crimes Module 3: Categories of Financial Crimes Module 4: Financial Crime Response Plan Module 5: Collecting, Preserving and Gathering Evidence Module 6: Laws against Financial Fraud CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. Requirements To enrol in this course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to this course.

Do you wonder why is it that the Richard Branson's of this world are rich and successful? What is the secret behind their success? Successful people are conscientious about how they use their time. No matter how you put it together, we all have 24 hours in a day, so the key lies in knowing to use our time wisely. In this course, you will be introduced to some ways that will help you dramatically increase your productivity through the more efficient use of your day. You will also be taught how to overcome procrastination - that great enemy of effective time management. You will also gain the understanding of how to set realistic and achievable goals and the ability to achieve these goals Course Highlights Time Management Diploma is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Time Management Diploma into 6 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 5 hours, 55 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Time Management Diploma Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Time Management Diploma is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Time Management Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Time Management Diploma Where Do You Spend Your Time FREE 01:00:00 Managing Tasks FREE 01:00:00 Planning 01:00:00 Goals 01:00:00 Tips From The Gurus 01:00:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Time Management Diploma 00:20:00 Final Exam Final Exam- Time Management Diploma 00:20:00

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing