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

80 Spreadsheet courses in Belfast delivered Live Online

Analysing and Managing Key Data

By Centre for Competitiveness

Data Data Everywhere – For what purpose? Which data is crucial to driving your organisation? How do we Analyse data to drive improvements? Course Overview Organisations generally collect enormous amounts of data. However, what data or information is really needed? How do we present the data that we have collected so that it is openly available and can be understood and used to drive the business? Is the data collected driving change? Structure of the Course This one-day workshop will enable participants to gain the necessary skills to collect, analyse and present data in an understanding and meaningful way and assist the decision-making process. It looks at how to translate data into useful and meaningful information that can contribute towards real problem solving, effective performance indicators, leading to the development of effective KPI’s, among others. Alternatively, if an organisation is in the process of selecting data collection methods and appropriate analysis, then this workshop will also help. Data analysis skills are essential to providing honest and accurate analysis, determining statistical significance, reliability, and validity on which to base their decisions, whether it is to improve quality, profitability, efficiency, or competitiveness. Improper statistical analyses distort findings and can mislead or negatively influence decision-making and the perception of the data collected. The correct analysis of data is a process of systematically applying statistical and / or logical techniques to describe and illustrate, condense, and recap, and evaluate data so that it can be used effectively. This workshop provides essential learning for staff at all levels of the organisation. Course content: 1. Data Types Discrete data Continuous data 2. Data Collection Sheet design Testing, prior to full-scale data collection 3. Data Input into Spreadsheet 4. Determination of Basic Descriptive Statistics Mean Median Mode Minimum and maximum values Range Standard deviation 5. Graphical Analysis Bar charts Line graphs Pie charts Scatter diagrams 6. Determination of Relationships between Factors Relationship between discrete factors Relationship between continuous factors 7. Use of Data in Decision Making 8. Establishment of Key Performance Indicators 9. Determination of Data Reliability 10. Summary Who would benefit from this Approach? Anyone who collects, manages, analyses and uses data to drive business performance. Delivery The course is delivered through virtual, tutor-led classes as structured above. The platform used is Adobe Connect which utilizes e-work rooms, video and streamed trainers. Cost £200 + VAT If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Analysing and Managing Key Data
Delivered OnlineFlexible Dates
£200

Power BI® - Business Data Analytics

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course  This 3 full-day training course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data. The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they've learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn't be able to do what they need to do. This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries. Training Objectives Upon completion of this training course, participants will be able to: Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis Combine data sources together and gain an introductory understanding of the M language Write formulas using the DAX language for generating custom columns, measures and tables Design reports and dashboards using a wide range of both built-in and custom visuals Publish reports and dashboards to PowerBI®.com Share reports and dashboards with others using PowerBI®.com Customize reports and dashboards so that different user groups automatically see their own personalized views Target Audience This training course is intended for: Financial Analysts Accountants Budgeting and planning specialists Treasury Risk Managers Strategic Planners This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending. Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included. Course Level Basic or Foundation Trainer Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years' experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings. He has trained delegates from a wide variety of Oil & Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions. Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm. He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing. Highlights from his oil and gas experience include: Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets. Auditing and further development of life of project models for Chevron's Strategic Planning Division analysing their North West Shelf assets. Development of business plan and budgeting models for multinational oil & gas assets. Development of cash flow and taxation models for a variety of oil gas companies. Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Power BI® - Business Data Analytics
Delivered in Internationally or OnlineFlexible Dates
£2,493 to £2,899

Microsoft Excel training | Excel Courses for Accountants

By Osborne Training

Microsoft Excel training | Excel Courses for Accountants: Excel Courses Overview Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. Comprehensive excel courses come with up to date material to practice at home and during your class. Excel courses for accountants This course is a highly recognised excel course for accountants. We will also provide a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental program for professional Accountants. Excel spreadsheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills in excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills in Excel is a must for any potential professional accountants and who are already running a practice or considering opening a practice. Certificate of Attendance Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Tables and Bordering Look up References (Vlookup, Hlookup, etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis

Microsoft Excel training | Excel Courses for Accountants
Delivered OnlineFlexible Dates
Price on Enquiry

AutoCAD Training Course for Electrical

By ATL Autocad Training London

Exclusive to AutoCAD subscribers, the AutoCAD Electrical toolset simplifies electrical system creation. Click here for more info: Website Our course provides a strong foundation in 2D electrical design, covering essential tools. Flexible one-on-one sessions from 9 a.m. to 7 p.m., Monday to Saturday. Call 02077202581 or book online. The 16-hour course offers flexibility, divide hours across days. Benefit from individualized attention and tailored content. Enroll for in-person or Zoom sessions to excel in AutoCAD Electrical. AutoCAD Electrical Course Content: Introduction to AutoCAD Electrical Software: Overview and features of AutoCAD Electrical Understanding the software interface and tools Project file structure and management Layout and Navigation: Navigating the AutoCAD Electrical workspace Creating new project files and using attribute editors Understanding WDD, WDX, and WDF project files Exploring the Project Manager interface and attribute editors Electrical Diagram Drawing: Numbering and titling wires in diagrams Labelling components Utilizing diagram symbol libraries Creating and editing Electrical Control Circuits (ECC) Component dialog box and Circuit Scale dialog box Introduction to Programmable Logic Controllers (PLCs) and Integrated Systems: PLC Symbols and Concepts Inserting Programmable Logic Controllers (PLCs) into diagrams Adding PLC Units to diagrams Working with PLC Input and Output points and circuits Understanding PLC-based classification Using the Spreadsheet to PLC Input and Output Points utility Custom and Bespoke Symbols: Creating custom symbols for Switches, Wires, Contactors, Motors, Transformers, etc. Specifying symbol conventions and standards Offline and online usage of AutoCAD Electrical databases Drawing for Terminals and Plans: Implementing Terminal symbols in diagrams Handling terminal plans and locations Working with compound level terminals and locations Utilizing the Component command for single and multiple components Managing Jumpers and wiring Modifying Terminal Strips and Dual In-Line Packages (DIP) Understanding DIN Rail, Electrical Enclosure, Circuit Breakers, and Electrical Equipment Generating PDFs and Reports: Exporting drawings to PDF format Organizing report templates Automating the generation of reports Creating Electrical Audit Reports This AutoCAD Electrical course provides comprehensive knowledge of the software, focusing on electrical diagram drawing, symbol creation, PLC integration, terminal planning, and report generation. Participants will gain the skills needed to efficiently design electrical systems using AutoCAD Electrical software. Upon completion, participants will proficiently use AutoCAD Electrical to create precise electrical diagrams, integrate PLCs, design custom symbols, plan terminals, and generate reports efficiently. They will possess the skills needed to confidently design electrical systems and enhance their expertise in electrical design and drawing. AutoCAD Electrical Training Course: Master precision in specialized electrical design skills. Optimize your design process with streamlined workflows. Ensure compliance with industry standards consistently. Boost productivity in electrical design tasks. Facilitate seamless collaboration with fellow professionals. Benefit from recorded lessons for convenient review. Enjoy continuous support with lifetime email assistance. Unleash the complete power of AutoCAD for your electrical design needs. Enroll today and craft precise, professional electrical drawings confidently. Select between in-person and live online sessions to suit your preference. Flexible Evening Sessions: Learn AutoCAD at your own pace with evening sessions designed for busy individuals. Boost your career opportunities in computer-aided design. Comprehensive Skill Development: Gain a strong foundation in AutoCAD's core features and advance to 3D modeling and rendering techniques, enhancing your design capabilities. Industry-Standard Knowledge: Become proficient in AutoCAD, a widely used CAD software in architecture, engineering, and construction fields, making you highly sought after by employers. Practical Application: Apply AutoCAD skills to real-world design scenarios, creating detailed plans for professional projects in architecture, engineering, and mechanical fields. Recorded Lessons for Review: Access lesson recordings to reinforce learning and review specific topics or techniques whenever needed. Lifetime Email Support: Enjoy ongoing support with lifetime email assistance, even after completing the course, for guidance and clarification.

AutoCAD Training Course for Electrical
Delivered in London or OnlineFlexible Dates
£558

AutoCAD Electrical Training Course | Bespoke

By London Design Training Courses

Why Choose AutoCAD Electrical Training Course | Bespoke? Course Link Master electrical drawings, schematics, and layouts. Utilize symbol libraries and automated circuit design. Access recorded lessons and lifetime email support.  "Say goodbye to group classes and hello to 1-on-1 Courses. Dial 02077202581 or WhatsApp 07970325184 to reserve your dates. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD Electrical Training Course: Specialized electrical CAD design skills with precision. Streamlined workflows for efficient design. Consistent adherence to industry standards. Increased productivity in electrical design. Enhanced collaboration with other professionals. Access to recorded lessons for review. Lifetime email support for ongoing assistance. Learn AutoCAD for electrical design. Enroll now and create accurate and professional electrical drawings with confidence. Choose in-person or live online sessions. AutoCAD Electrical Training Course: Specialized electrical CAD design skills with precision. Streamlined workflows for efficient design. Consistent adherence to industry standards. Increased productivity in electrical design. Enhanced collaboration with other professionals. Access to recorded lessons for review. Lifetime email support for ongoing assistance. Learn AutoCAD for electrical design. Enroll now and create accurate and professional electrical drawings with confidence. Choose in-person or live online sessions. AutoCAD Electrical Course Content: Introduction to AutoCAD Electrical Software: Overview and features of AutoCAD Electrical Understanding the software interface and tools Project file structure and management Layout and Navigation: Navigating the AutoCAD Electrical workspace Creating new project files and using attribute editors Understanding WDD, WDX, and WDF project files Exploring the Project Manager interface and attribute editors Electrical Diagram Drawing: Numbering and titling wires in diagrams Labelling components Utilizing diagram symbol libraries Creating and editing Electrical Control Circuits (ECC) Component dialog box and Circuit Scale dialog box Introduction to Programmable Logic Controllers (PLCs) and Integrated Systems: PLC Symbols and Concepts Inserting Programmable Logic Controllers (PLCs) into diagrams Adding PLC Units to diagrams Working with PLC Input and Output points and circuits Understanding PLC-based classification Using the Spreadsheet to PLC Input and Output Points utility Custom and Bespoke Symbols: Creating custom symbols for Switches, Wires, Contactors, Motors, Transformers, etc. Specifying symbol conventions and standards Offline and online usage of AutoCAD Electrical databases Drawing for Terminals and Plans: Implementing Terminal symbols in diagrams Handling terminal plans and locations Working with compound level terminals and locations Utilizing the Component command for single and multiple components Managing Jumpers and wiring Modifying Terminal Strips and Dual In-Line Packages (DIP) Understanding DIN Rail, Electrical Enclosure, Circuit Breakers, and Electrical Equipment Generating PDFs and Reports: Exporting drawings to PDF format Organizing report templates Automating the generation of reports Creating Electrical Audit Reports This AutoCAD Electrical course provides comprehensive knowledge of the software, focusing on electrical diagram drawing, symbol creation, PLC integration, terminal planning, and report generation. Participants will gain the skills needed to efficiently design electrical systems using AutoCAD Electrical software. Upon completing the AutoCAD Electrical course, participants will master the intricacies of the software. They will adeptly create accurate electrical diagrams, seamlessly integrate PLCs, design personalized symbols, strategize terminal layouts, and produce reports with precision and efficiency. Armed with these skills, graduates will possess the expertise to confidently design complex electrical systems. This proficiency opens avenues in various job roles such as Electrical Design Engineer, CAD Technician, Control Systems Designer, or even Project Manager in industries like manufacturing, automation, and engineering consultancy.

AutoCAD Electrical Training Course | Bespoke
Delivered in London or OnlineFlexible Dates
£480

Effective Data Visualisation

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is aimed at anyone currently working with data who is interested in using data visualisation to more effectively communicate their results. Overview At completion, delegates will understand how data visualisations can be best used to communicate actionable insights from data and be competent with the tools required to do it. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. Course Outline The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to horse breeding. The companies doing this most successfully understand that using sophisticated analytics approaches to unlock insights from data is only half the job. Communicating these insights to all of the different parts of an organisation is just as important as doing the actual analysis. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. To attend this course delegates should be competent in the use of data analysis tools such as reporting tools, spreadsheet software or business intelligence tools. The course will explore the following topics through a series of interactive workshop sessions: Fundamentals of data visualisation Data characteristics & dimensions Mapping visual encodings to data dimensions Colour theory Graphical perception & communication Interaction design Visualisation different characteristics of data: trends, comparisons, correlations, maps, networks, hierarchies, text Designing effective dashboards

Effective Data Visualisation
Delivered OnlineFlexible Dates
Price on Enquiry

Computing - IT Skills for Windows OS (modular) - Online Tuition

5.0(8)

By GLA Tutors Home or Online

Learn everything you need to know to be fully competent with Window OS. This syllabus takes you around the basics and then on another deep dive into all the elements. Discover things you never knew and speed up your experience using Windows OS. Module 1: Introduction to Windows OS • Understanding the Windows operating system • Navigating the Windows interface • Customizing system settings and preferences Module 2: File Management • Managing files and folders in Windows Explorer • Copying, moving, and renaming files • Using the Recycle Bin and data recovery Module 3: Windows Built-in Apps • Using Microsoft Edge for web browsing • Effective web searching using search engines • Email management with Windows Mail • Calendar and task management with Windows Calendar Module 4: Software Installation and Updates • Installing and updating software applications • Managing and uninstalling programs • Windows Store and app installations Module 5: Microsoft Office Basics • Introduction to Microsoft Office suite • Using Microsoft Word for document creation • Basic spreadsheet management with Microsoft Excel Module 6: Microsoft Office Intermediate Skills • Advanced features in Microsoft Word • Creating and formatting spreadsheets in Microsoft Excel • Creating dynamic presentations with PowerPoint Module 7: Multimedia and Graphics • Basic image editing with Paint • Using Windows Photo app for photo management • Creating graphics with Paint 3D Module 8: Productivity and Collaboration • Using OneDrive for cloud-based storage and collaboration • Working with Windows Sticky Notes and To-Do • Collaborative editing with Microsoft Office Online Module 9: Troubleshooting and Maintenance • Identifying and resolving common Windows issues • Using Task Manager for performance monitoring • Maintenance tasks for Windows OS Module 10: Windows Security and Privacy • Overview of Windows security features • Online safety and privacy best practices • Protecting personal data and devices Module 11: Advanced Windows Features • Customizing the Windows Start Menu and Taskbar • Using Cortana for voice commands and search • Virtual desktops and advanced multitasking Module 12: Using AI and Chat GPT • Introduction to AI and Chat GPT technology • Exploring AI-powered features in Windows • Using Chat GPT for productivity and assistance Module 13: Browsing and Search Engines • Effective use of web browsers • Utilizing search engines for research • Online safety and privacy while browsing Module 14: Cybersecurity • Understanding cybersecurity threats • Protecting against malware and phishing attacks • Secure online practices and password management Module 15: Software Installation and Factory Reset • Installing and updating software applications • Factory resetting a Windows device • Data backup and recovery during resets Module 16: Final Projects and Assessment • Culminating projects showcasing Windows OS skills • Practical exams assessing Windows software knowledge and skills • Preparing for industry-recognized certifications (optional) Please note that the duration and depth of each module can vary depending on the level of expertise required and the specific needs of the learners. Additionally, it's important to adapt the curriculum to the learners' proficiency levels, whether they are A Level/GCSE students or adult learners with different experience levels.

Computing - IT Skills for Windows OS (modular) - Online Tuition
Delivered OnlineFlexible Dates
£40

Project appraisal and risk management (In-House)

By The In House Training Company

Where should management effort be directed? In controlling costs and ensuring proper engineering in live projects? - yes, of course, but true cost control comes by understanding, eliminating and minimising risk prior to a business committing any funds. This course studies the stages required for practical financial and business appraisals of projects and capital expenditure. This course has two primary objectives: To impart the knowledge and skills required to ensure as risk-free as possible expenditure of that scarce resource, cash - the investors', governments' or shareholders' money must not be squandered To improve the quality of the appraisal process in the widest sense - demonstrating how the process of project and capital expenditure appraisal can be used to dramatically improve cost control and deliver as risk-free as possible expenditure As a result of the course, participants will be able to: Understand the economics of appraisal Be in control of their projects from the start Understand the economics of their projects - and devise the most appropriate mode Carry out sensitivity analysis and identify risk Improve their methods of appraisal and approach Focus on the risk areas and take out risk and control costs before they over-run The benefits of attending this course will be demonstrable from day one. Thorough appraisals and risk assessment follow through to success in project management and detailed cost control and project management. 1 Introduction Why appraise? Taking risk out of investment The short- and long-term results of not appraising business expenditure 2 Developing an appraisal process The process - overall and stage-by-stage objectives Understand business and technical risks Manage resources and time Do you invest enough time and effort at this stage? Take out the risks - control costs before you are committed to contracts and action Checklists 3 Appraisal arithmetic Review of the arithmetic of appraisalThe time value of moneyThe effects of different interest or required ratesThe effects of inflation (or deflation) in prices and costs Understanding the economics of appraisal is essential 4 Appraisal measures Meaning and use of appraisal measures Identifying the most appropriate measures for your particular business Payback Discounted cash flow measures - NPV and IRR Other measures - FW, AW, Profitability Index The meaning of the measures and their application in practice 5 Cost benefit analysis The effect on decision-making of more intangible benefits Cost benefit analysis Ensuring costs are genuine Measuring intangible benefits Environmental issues Consideration of intangible benefits in the appraisal decision-making process 6 Developing appropriate models Developing models - examples of spreadsheet models and measures for many different situations Modelling investment opportunities - summarising outcomes Sensitivity analysis - identifying, quantifying and taking out risk 7 Developing an appraisal process The process - managing risk from the outset Using the process in risk management, negotiating and project management Take out risk by thoroughly knowing your project - developing your own process

Project appraisal and risk management (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Python for Data Science Primer: Hands-on Technical Overview (TTPS4872)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level): How to work with Python interactively in web notebooks The essentials of Python scripting Key concepts necessary to enter the world of Data Science via Python This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it's often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. Additional course details: Nexus Humans Python for Data Science Primer: Hands-on Technical Overview (TTPS4872) 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 Python for Data Science Primer: Hands-on Technical Overview (TTPS4872) 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.

Python for Data Science Primer: Hands-on Technical Overview (TTPS4872)
Delivered OnlineFlexible Dates
Price on Enquiry

Python for Data Science: Hands-on Technical Overview (TTPS4873)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level): How to work with Python interactively in web notebooks The essentials of Python scripting Key concepts necessary to enter the world of Data Science via Python This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. An Overview of Python Why Python? Python in the Shell Python in Web Notebooks (iPython, Jupyter, Zeppelin) Demo: Python, Notebooks, and Data Science Getting Started Using variables Builtin functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Sequences, Arrays, Dictionaries and Sets About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Generator Expressions Nested sequences Working with Dictionaries Working with Sets Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Functions Defining functions Parameters Global and local scope Nested functions Returning values Essential Demos Sorting Exceptions Importing Modules Classes Regular Expressions The standard library Math functions The string module Dates and times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Python and Data Science Data Science Essentials Pandas Overview NumPy Overview SciKit Overview MatPlotLib Overview Working with Python in Data Science Additional course details: Nexus Humans Python for Data Science: Hands-on Technical Overview (TTPS4873) 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 Python for Data Science: Hands-on Technical Overview (TTPS4873) 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.

Python for Data Science: Hands-on Technical Overview (TTPS4873)
Delivered OnlineFlexible Dates
Price on Enquiry