• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

12855 Courses in Cardiff delivered Online

Microsoft Power BI Desktop (live online classes)

By Microsoft Office Training

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

Microsoft Power BI Desktop (live online classes)
Delivered OnlineFlexible Dates
£750

PL-300T00 Microsoft Power BI Data Analyst

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - Discover data analysis Overview of data analysis Roles in data Tasks of a data analyst 2 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 3 - Get data in Power BI Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors 4 - Clean, transform, and load data in Power BI Shape the initial data Simplify the data structure Evaluate and change column data types Combine multiple tables into a single table Profile data in Power BI Use Advanced Editor to modify M code 5 - Design a semantic model in Power BI Work with tables Create a date table Work with dimensions Define data granularity Work with relationships and cardinality Resolve modeling challenges 6 - Add measures to Power BI Desktop models Create simple measures Create compound measures Create quick measures Compare calculated columns with measures 7 - Add calculated tables and columns to Power BI Desktop models Create calculated columns Learn about row context Choose a technique to add a column 8 - Use DAX time intelligence functions in Power BI Desktop models Use DAX time intelligence functions Additional time intelligence calculations 9 - Optimize a model for performance in Power BI Review performance of measures, relationships, and visuals Use variables to improve performance and troubleshooting Reduce cardinality Optimize DirectQuery models with table level storage Create and manage aggregations 10 - Design Power BI reports Design the analytical report layout Design visually appealing reports Report objects Select report visuals Select report visuals to suit the report layout Format and configure visualizations Work with key performance indicators 11 - Configure Power BI report filters Apply filters to the report structure Apply filters with slicers Design reports with advanced filtering techniques Consumption-time filtering Select report filter techniques Case study - Configure report filters based on feedback 12 - Enhance Power BI report designs for the user experience Design reports to show details Design reports to highlight values Design reports that behave like apps Work with bookmarks Design reports for navigation Work with visual headers Design reports with built-in assistance Tune report performance Optimize reports for mobile use 13 - Perform analytics in Power BI Explore statistical summary Identify outliers with Power BI visuals Group and bin data for analysis Apply clustering techniques Conduct time series analysis Use the Analyze feature Create what-if parameters Use specialized visuals 14 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 15 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method Additional course details: Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.

PL-300T00 Microsoft Power BI Data Analyst
Delivered OnlineFlexible Dates
£1,785

Programming with Python

By Xpert Learning

About Course Master the Fundamentals of Programming with Python Course Description Embark on an exciting journey into the world of programming with this comprehensive Python course, designed to equip you with the essential skills and knowledge to become a proficient Python programmer. Whether you're a complete beginner or seeking to enhance your existing Python skills, this course caters to all levels of expertise. What will be discussed in detail? Introduction to Python: Delve into the basics of Python programming, including variables, data types, operators, and control flow statements. Working with Data Types: Explore the fundamental data types in Python, including numbers, strings, booleans, and lists. Python Strings: Master the art of manipulating strings, including slicing, concatenation, and string formatting techniques. Python Lists: Discover the power of lists, one of Python's most versatile data structures, and learn how to create, access, modify, and iterate over lists. Python Casting and Input: Understand the concept of type casting and learn how to take user input from the console. Python Dictionary: Uncover the usefulness of dictionaries, another essential data structure in Python, and learn how to store and retrieve data using key-value pairs. Python Date and Time: Learn how to handle date and time operations in Python, including creating, formatting, and manipulating date and time objects. Python Loop Part 1: Master the 'for' loop, a fundamental looping construct in Python, to iterate over sequences and perform repetitive tasks. Python Loop Part 2: Expand your understanding of loops by exploring the 'while' loop, used to execute a block of code repeatedly while a condition remains true. Creating a Function: Discover the power of functions, reusable blocks of code that perform specific tasks, and learn how to define, call, and pass arguments to functions. Python OOP Part 1: Delve into the world of Object-Oriented Programming (OOP) with Python, and learn the concepts of classes, objects, inheritance, and polymorphism. Python OOP Part 2: Enhance your OOP skills by exploring advanced concepts such as abstract classes, multiple inheritance, and operator overloading. Python Advanced OOP Part 1: Discover more advanced OOP techniques, including class methods, static methods, and decorators. Python Advanced OOP Part 2: Master the concept of exception handling, a crucial aspect of robust programming, and learn how to handle errors and exceptions effectively. Error Handling: Understand the importance of error handling in Python programming and learn how to identify, handle, and prevent errors. Python File Handling: Learn how to read, write, and manipulate files in Python, enabling you to store and retrieve data from external sources. Python Modules: Explore the concept of modules, reusable code libraries, and discover how to import, use, and create your own modules. Why should you enroll into it? Gain a comprehensive understanding of Python programming: Master the fundamentals of Python programming, from basic syntax to advanced OOP concepts. Develop practical coding skills: Apply your theoretical knowledge to hands-on coding exercises, solidifying your understanding and building your confidence. Prepare for a career in programming: Equip yourself with the essential skills required for entry-level programming positions. Enhance your problem-solving abilities: Learn to think algorithmically and develop effective problem-solving techniques using Python programming. Expand your skillset and knowledge: Whether you're a beginner or an experienced programmer, this course will broaden your understanding of Python and its capabilities. What will be taught? (Learning Outcomes/Learning Objectives) Understand the fundamental concepts of Python programming Work with different data types, including numbers, strings, lists, dictionaries, and Booleans Master control flow statements such as 'if', 'elif', and 'else' Create and manipulate Python functions Implement Object-Oriented Programming (OOP) concepts using classes, objects, inheritance, and polymorphism Handle errors and exceptions effectively Read, write, and manipulate files in Python Import, use, and create Python modules What Will You Learn? Understand the fundamental concepts of Python programming Work with different data types, including numbers, strings, lists, dictionaries, and Booleans Master control flow statements such as 'if', 'elif', and 'else' Create and manipulate Python functions Implement Object-Oriented Programming (OOP) concepts using classes, objects, inheritance, and polymorphism Handle errors and exceptions effectively Read, write, and manipulate files in Python Import, use, and create Python modules Course Content Introduction to Python Introduction to Python Working with Data Types Working with Data Types Python Strings Python Strings Python List Python List Python Casting and Input Python Casting and Input Python Dictionary Python Dictionary Python Date and Time Python Date and Time Python Loop (Part - 1) Python Loop (Part - 1) Python Loop (Part - 2) Python Loop (Part - 2) Python While Loop Python While Loop Creating a Function Creating a Function Python OOP (Part - 1) Python OOP (Part - 1) Python OOP (Part - 2) Python OOP (Part - 2) Python Advanced OOP (Part - 1) Python Advanced OOP (Part - 1) Python Advanced OOP (Part - 2) Python Advanced OOP (Part - 2) Error Handling Error Handling Python File Handling Python File Handling Python Modules Python Modules A course by Uditha Bandara Microsoft Most Valuable Professional (MVP) RequirementsA basic understanding of computers and operating systemsA willingness to learn and practice codingA computer with internet access and the ability to install Python Audience Beginners with no prior programming experience Programmers seeking to transition to Python Individuals looking to enhance their programming skills and knowledge Anyone interested in pursuing a career in programming Audience Beginners with no prior programming experience Programmers seeking to transition to Python Individuals looking to enhance their programming skills and knowledge Anyone interested in pursuing a career in programming

Programming with Python
Delivered Online On Demand
£9.99

Pelvic Floor Confidence Course LIVE ONLINE

By For A Better You - Pilates & Pelvic Floor Health

Your Journey to Pelvic Floor Confidence starts here.. Are you ready to feel more confident in your pelvic floor when you cough, sneeze, laugh, run, jump or exercise? Then this course is for you!! I will show you in JUST 4 WEEKS how to improve your pelvic floor function & feel confident again! Pelvic Floor Confidence can be yours in just 4 weeks!!! Proven Results = A more confident you and a stronger pelvic floor The course has been designed to give you more information about the pelvic floor, how it works and what it does. You will learn how to work with your pelvic floor and increase it’s capacity to best serve your lifestyle and improve your pelvic floor confidence in a functional way. Week 1 – Understanding the pelvic floor and an introduction into the fundamentals of pelvic floor exercises, introduction to functional exercises Week 2 – Pelvic Floor first stage exercises, distraction techniques for urge incontinence and understanding our toilet patterns, with functional exercises Week 3 – Next Step Pelvic Floor Exercises, Pelvic Organ Prolapse and living with it, toilet habits and functional exercises Week 4 – Advanced Pelvic Floor Exercises, Bowel Issues and Irritants. Once you have completed the 4 weekly sessions you will have access to a 12 week follow on programme that will help you implement further what you have learned. This course has been designed to help you understand the importance of your pelvic floor and to help you support it in a functional way.

Pelvic Floor Confidence Course LIVE ONLINE
Delivered Online
£169

Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access)

4.3(43)

By John Academy

Description: Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is intended to prepare you to get complete control on Microsoft Office 2016. It is designed to educate about Microsoft Office 2016. In this course, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the essentials to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, adjust cells, create columns, rows and much more. This advanced course helps you to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Finally, you will learn how to set up and use Outlook on Windows. It will assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and so much more. Overall, this course is created especially for you to provide all information to access Microsoft Office 2016. Enroll today and get benefit from this course. Learning Outcomes: Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions Ways to update worksheet properties, create and edit macros, applying conditional formatting and add data validation criteria Auditing worksheets through tracing cells, troubleshooting invalid data and formula errors, watching and evaluating formulas, and creating a data list online Create Sparklines, scenarios and interactive data using Power View Perform what-if analysis and statistical analysis with the Analysis ToolPak Ways to multitask by consolidating data, linking cells in different workbooks, and merging them Export Excel data, import delimited text files, integrate Excel data with the web and create web queries How to import and export XML data PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets Change message settings, properties, options, using automatic replies and inserting objects Sort and filter options, organising and searching messages, managing junk mail and mailbox Managing advanced calendar options, additional calendars, meeting responses, and assigning tasks Advanced, forward and export contact options, handling contacts and editing electronic business cards Sharing calendars and contacts whilst also delegating access to mail folders to others Modifying data file settings and backing up Outlook items Email security and configuring email message security Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Advanced 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access)
Delivered Online On Demand3 days
£21

KNIME - A Guide for Absolute Beginners

By Packt

This is a complete crash course about KNIME for beginners. Here, we will learn how to do data cleaning and data preparation without any code, using KNIME. We will also cover data visualization using Tableau and Power BI Desktop. Then we will understand the predictive analytics capabilities of KNIME and finally, cover machine learning in KNIME.

KNIME - A Guide for Absolute Beginners
Delivered Online On Demand2 hours 31 minutes
£37.99

Inventory Management for Product Managers - 20 Courses Bundle

By NextGen Learning

Get ready for an exceptional online learning experience with the Inventory Management 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. Imagine the opportunities that await you as a certified expert in Inventory Management! With this credential, top companies across industries will seek you for you, including retail, manufacturing, logistics, and more. Open doors to lucrative positions such as Inventory Manager, Supply Chain Analyst, or Operations Director, where you'll be entrusted with the critical responsibility of optimising inventory levels, reducing costs, and ensuring seamless operations. As part of this package, you will receive complimentary PDF certificates for all courses in this Inventory Management bundle at no extra cost. Equip yourself with the Inventory Management bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Inventory Management Bundle Comprises the Following CPD Accredited Courses: Inventory Management Product Management Certificate in Purchasing and Procurement Supply Chain Management Operations Management: Process Mapping & Supply Chain Merchandising Import/Export Logistics Management SAP Controlling (CO) - Product Costing S4HANA Commercial law Warehouse Operative Warehouse Safety Manager Diploma in Lean Process and Six Sigma Retail Psychology Visual Merchandising Diploma Compliance and Risk Management Diploma Career Development Plan Fundamentals Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Master efficient inventory management techniques for increased profitability. Develop strategic product management expertise to drive revenue growth. Understand industry trends and best practices through the Inventory Management Bundle. Acquire skills in purchasing and procurement for cost-effective sourcing Enhance personal and professional growth with the Inventory Management Bundle. Build a strong knowledge base in your chosen course via thisBundle. Develop expertise in SAP Controlling, commercial law, and warehouse operations. With the Inventory Management package, validate your learning with a CPD certificate. Master the art of inventory management, optimising levels to reduce costs and improve operational efficiency. Develop strategic product management skills, enabling you to strategically develop, launch, and manage products that meet market demands and drive business growth. Acquire expertise in purchasing and procurement, negotiating deals and implementing cost-saving measures. Embrace the future of learning with Inventory Management, a rich anthology of 20 diverse courses. Each course in the Inventory Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This bundle will take you on a unique and enriching educational journey. Successfully navigate the challenges of import/export and logistics management, ensuring seamless movement of goods across international borders and maximising opportunities in the global marketplace. Specialise in key aspects of inventory management, including SAP Controlling (CO) - Product Costing S4HANA, to handle product costs and enhance financial performance proficiently. Acquire a solid understanding of commercial law to ensure compliance and mitigate legal risks. Enrol in our Inventory Management bundle today and unlock the keys to efficient supply chain operations. Take the first step towards a successful career in inventory management and supply chain excellence. Don't miss out on this opportunity - join us now and gain the knowledge and skills needed to thrive in this dynamic field. Let's embark on this transformative journey together! CPD 220 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Inventory Management bundle is perfect for: Lifelong learners are looking to expand their knowledge and skills. Professionals are seeking to enhance their careers with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Our Inventory Management bundle will prepare you for a range of careers, including: Inventory Manager Supply Chain Analyst Purchasing Specialist Logistics Coordinator Operations Manager Supply Chain Consultant Professionals in these roles can expect a combined salary range of £30,000 to £70,000 per year in the United Kingdom. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Inventory Management for Product Managers - 20 Courses Bundle
Delivered Online On Demand3 days
£99

Game Designing Training Course 3ds Max and Unity 3D (Live Online Only)

By London Design Training Courses

Why Learn Game Designing Training Course 3ds Max and Unity 3D? Click for more info Learn Game Designing with 3ds Max and Unity 3D for industry demand, 3d and 2d skills, game design, AR/VR projects, game programming, and 3d visualization. Enhance your career in the thriving gaming and interactive media industry. Duration: 40 hrs. Method: 1-on-1 & Tailored content. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Explore the World of Unity 3D with Our Training Courses Unity is a robust cross-platform game development engine, responsible for creating a significant portion of the world's games. Learn ultimate game development platform to build top-notch 3D & 2D games, deployable on mobile, desktop, VR/AR, consoles, or the Web. The opportunities are limitless. Led by certified and experienced Unity instructors, our training courses are filled with practical, real-world exercises. 40-hour Game Designing Training Course with 3ds Max and Unity 3D: Course Overview: Module 1: Introduction to 3ds Max and Unity 3D (4 hours) Get acquainted with 3ds Max and Unity 3D interfaces and workflows Efficiently set up and manage projects Master importing and handling assets Module 2: 3D Modeling with 3ds Max (8 hours) Dive into 3D modeling techniques Create stunning 3D models using 3ds Max Explore polygonal, spline, and NURBS modeling Enhance models with textures and materials Module 3: Animation and Rigging with 3ds Max (8 hours) Understand animation techniques in 3ds Max Rig 3D models for smooth animations Bring creations to life with keyframe animation Employ procedural animation methods Export animations for Unity 3D integration Module 4: Game Design with Unity 3D (8 hours) Learn the Unity 3D game engine Grasp essential game mechanics and concepts Create and manage game scenes and levels Master control of game objects and components Utilize physics and collision detection for immersive experiences Module 5: Scripting and Programming with Unity 3D (8 hours) Introduce Unity 3D scripting with C# Understand variables, data types, and functions in C# Control game objects and components using C# Explore game loops and events for interactive gameplay Module 6: User Interfaces and Audio with Unity 3D (4 hours) Design captivating user interfaces within Unity 3D Implement interactive buttons, sliders, and input fields Elevate games with audio import and editing Control sound effects and background music Module 7: Optimization and Deployment (4 hours) Master game optimization in Unity 3D Enhance game performance through scripting techniques Build and test games for various platforms Publish games on the web or app stores Game Designing Training Course 3ds Max and Unity 3D (Live Online Only): Explore advanced 3ds Max techniques for modeling, lighting, and cameras Dive into character animation for lifelike characters Enhance Unity 3D skills with real-time development and game authoring settings Unity - Real-time 3D Development Platform: Unlock Your Creativity https://www.unity.com/ Create 3D, 2D, VR & AR Experiences For Any Industry: Games, Auto, AEC, Film, And More. Complete Solution To Develop Better, Iterate Faster, And Grow Your Business. Amazing Games. Immersive Experiences. Multi-Platform Support. 3ds Max Free Trial | Autodesk Download a free 30-day trial of 3ds Max, 3D modeling, and rendering software for design visualization, games, and animation.

Game Designing Training Course 3ds Max and Unity 3D (Live Online Only)
Delivered OnlineFlexible Dates
£1,200

SQL for Data Science, Data Analytics and Data Visualization

4.5(3)

By Studyhub UK

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

SQL for Data Science, Data Analytics and Data Visualization
Delivered Online On Demand7 hours 15 minutes
£10.99

Essential Adobe InDesign Training Course

By ATL Autocad Training London

Who is this for? Essential Adobe InDesign Training Course. Acquire Adobe InDesign basics from certified instructors. Master layout design, typography, and core design concepts. Opt for in-person or live online sessions. Receive a Certificate of Completion and lifelong email assistance. Lean desktop publishing skills and quality layouts.  Click here for more info: Website Duration: 5 hours Approach: Individualized 1-on-1 training with customized content. Schedule: Flexible sessions, available Monday to Saturday from 9 am to 7 pm. Course Outline: Module 1: Introduction to Adobe InDesign (1 hour) Familiarize with workspace and tools Create new documents with appropriate page size and margins Effectively format text and images Customize the interface for efficient workflow Module 2: Text Formatting and Styles (1 hour) Apply consistent character and paragraph styles Manage text flow using frames Organize lists with bullets and numbering Master special characters for precise typography Module 3: Working with Images (1 hour) Import and position images in documents Adjust image size and alignment within frames Create professional layouts with text wrapping around images Enhance visuals with image frames and effects Module 4: Layout Design (1 hour) Create precise grids and guides for alignment Arrange objects for balanced layouts Streamline work with layers Maintain consistency using master pages and templates Module 5: Printing and Exporting (1 hour) Understand color modes and print principles Export to PDF and other formats for diverse outputs Ensure print readiness through preflighting Efficiently archive and manage InDesign files Through practical exercises, solidify your grasp of each module, enabling you to design visually appealing layouts, craft documents for various purposes, and manage InDesign projects adeptly. Adobe InDesign's potential is vast, and this fundamentals course opens doors for you to explore diverse design projects. Seize this opportunity to unleash your creative prowess with InDesign! Upon completing the Adobe InDesign Fundamentals course, participants will be able to: Master InDesign Tools: Demonstrate proficiency in utilizing InDesign's essential tools, workspace, and interface for effective design workflows. Layout Design Skills: Create visually appealing layouts using grids, guides, and balanced object arrangements, ensuring professional-quality design. Text Formatting Mastery: Apply consistent character and paragraph styles, manage text flow, and enhance typography with special characters. Image Manipulation Expertise: Import, position, and enhance images within frames, integrating them seamlessly into layouts. Printing and Exporting Proficiency: Understand color modes, print principles, and export documents to various formats, ensuring print readiness and diverse output options. Efficient Project Management: Utilize layers, master pages, and templates for streamlined project organization and management in InDesign. Book Recommendations: "InDesign CC Classroom in a Book" by Kelly Kordes Anton and John Cruise: This official Adobe guide provides hands-on lessons and practical techniques for mastering InDesign's core features. "InDesign Type: Professional Typography with Adobe InDesign" by Nigel French: Explore advanced typography techniques, layout principles, and typographic finesse specific to Adobe InDesign. "Real World Adobe InDesign CC" by Olav Martin Kvern, David Blatner, and Bob Bringhurst: A comprehensive guide offering practical insights, tips, and real-world techniques for InDesign users of all levels. "The Adobe InDesign CS6 Book for Digital Photographers" by Scott Kelby: Focused on integrating photography with InDesign, this book provides valuable insights into creating visually stunning layouts with images. "InDesign Secrets" by David Blatner and Anne-Marie Concepción: This book is packed with expert tips, tricks, and techniques that can significantly enhance your efficiency and creativity in InDesign. 1-on-1 InDesign Courses: Personalized Learning: Tailored 1-on-1 courses designed to meet your specific learning needs and goals. Expert Instructors: Learn from industry professionals with extensive experience in animation and design. Flexible Scheduling: Schedule sessions at your convenience, allowing you to balance learning with your busy lifestyle. Comprehensive Curriculum: Dive deep into animation techniques, software mastery, and creative skills through our comprehensive courses. Hands-On Training: Get practical, hands-on experience with real-world animation projects, enhancing your skills effectively. Individual Attention: Benefit from personalized attention and detailed feedback from instructors, ensuring your progress and understanding. Professional Development: Acquire skills relevant to the industry, empowering you for career advancement in animation and related fields. Portfolio Enhancement: Develop a strong portfolio with the guidance of experts, showcasing your newfound skills and creativity. Post-Course Support: Enjoy continued support even after the course completion, ensuring you have resources for ongoing learning and growth. Certification: Receive a certificate upon course completion, validating your expertise and enhancing your professional credentials. Course Highlights: Master Adobe InDesign's key features for layout, text, images, and graphics. Learn design principles and typography techniques for visually appealing documents. Efficiently handle multi-page projects like magazines and brochures. Utilize styles, templates, and libraries for streamlined design and consistency. Explore advanced techniques for interactive PDFs and digital publishing. Earn a Certificate of Completion for your Adobe InDesign proficiency. Flexible learning options: in-person or live online sessions. Lifetime email support for ongoing assistance after the course. Adobe InDesign Learn & Support https://helpx.adobe.com â€º support › indesign Get started with Adobe InDesign. Find tutorials, the user guide, answers to common questions, and help from the community forum.

Essential Adobe InDesign Training Course
Delivered in London or OnlineFlexible Dates
£180