37 Analytics courses in Sheffield

OVERVIEW -------------------------------------------------------------------------------- Data and visual analytics are emerging fields concerned with analysing, modelling, and visualizing complex high-dimensional data. It can be analysed and visualised with many languages like Python, R Programming and more. This course will help to attain the skills and give in-depth knowledge to the participant's enhanced way of modelling, analysing and visualizing techniques.  The course will highlight practical challenges including composite real-world data and will also comprise several practical studies

This course is very much a discussion, so be prepared to present and critically analyse your own and class mates work. You will also need to bring a few examples of work you have done in the past. Learning and applying best practice visualisation principles will improve effective discussions amongst decision makers throughout your organisation. As a result more end-users of your dashboards will be able to make better decisions, more quickly. This 2 Day training course is aimed at analysts with good working knowledge of BI tools (we use Tableau to present, but attendees can use their own software such as Power BI or Qlik Sense). It is a great preparation for taking advanced certifications, such as Tableau Certified Professional. -------------------------------------------------------------------------------- Contact us to discuss the Visual Analytics Best Practice course Email us if you are interested in an on-site course, or would be interested in different dates and locations -------------------------------------------------------------------------------- This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. -------------------------------------------------------------------------------- THE COURSE INCLUDES THE FOLLOWING TOPICS: WHAT IS VISUAL ANALYSIS? * Visual Analytics * Visual Analytics Process * Advantages of Visual Analysis * Exercise: Interpreting Visualisations HOW DO WE PROCESS VISUAL INFORMATION? * Memory and Processing Types * Exercise: Identifying Types of Processing * Cognitive Load * Exercise: Analysing Cognitive Load * Focus and Guide the Viewer * Remove Visual Distractions * Organise Information into Chunks * Design for Proximity * Exercise: Reducing Cognitive Load SENSORY MEMORY * Pre-attentive Attributes * Quantitatively-Perceived Attributes * Categorically-Perceived Attributes * Exercise: Analysing Pre-attentive Attributes * Form & Attributes * Exercise: Using Form Effectively * Colour & Attributes * Exercise: Using Colour Effectively * Position & Attributes * Exercise: Using Position Effectively ENSURING VISUAL INTEGRITY * Informing without Misleading * Gestalt Principles * Visual Area * Axis & Scale * Colour * Detail * Exercise: Informing without Misleading CHOOSING THE RIGHT VISUALISATION * Comparing and Ranking Categories * Comparing Measures * Comparing Parts to Whole * Viewing Data Over Time * Charts Types for Mapping * Viewing Correlation * Viewing Distributions * Viewing Specific Values DASHBOARDS AND STORIES * Exercise: Picking the Chart Type * Exercise: Brainstorming Visual Best Practice * Development Process for Dashboards and Stories * Plan the Visualisation * Create the Visualisation * Test the Visualisation * Exercise: Designing Dashboards and Stories -------------------------------------------------------------------------------- This training course includes over 20 hands-on exercises to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives an extensive training manual which covers the theory, practical applications and use cases, exercises and solutions together with a USB with all the materials required for the training. The course starts at 09:30 on the first day and ends at 17:00. On the second day the course starts at 09:00 and ends at 17:00. Students must bring their own laptop with an active version of Tableau Desktop 10.5 (or later) pre-installed. -------------------------------------------------------------------------------- WHAT PEOPLE ARE SAYING ABOUT THIS COURSE "Steve was willing to address questions arising from his content in a full and understandable way" Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs" James G. "The course tutor Steve was incredibly helpful and taught the information very well while making the two days very enjoyable." Bradd P. "The host and his courses will give you the tools and confidence that you need to be comfortable with Tableau." Jack S. "Steve was fantastic with his knowledge and knowhow about the product. Where possible he made sure you could put demonstrations in to working practice, to give the audience a clear understanding." Tim H. "This was a very interesting and helpful course, which will definitely help me produce smarter, cleaner visualisations that will deliver more data-driven insights within our business." Richard A. "Steve is very open to questions and will go out of his way to answer any query. Thank you" Wasif N. "Steve was willing to address questions arising from his content in a full and understandable way" Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs" James G.

ABOUT THIS TRAINING COURSE Business Impact: The main aim is to provide insight and understanding of data analytics and machine learning principles through applications. Field data is used to explain data-analysis workflows. Using easy to follow solution scripts, the participants will assess and extract value from the data sets. Hands-on solution approach will give them confidence to try out applicable techniques on data from their field assets. Data analysis means cleaning, inspecting, transforming, and modeling data with the goal of discovering new, useful information and supporting decision-making. In this hands-on 2-day training course, the participants learn some data analysis and data science techniques and workflows applied to petroleum production (specifically artificial lift) while reviewing code and practicing. The focus is on developing data-driven models while keeping our feet closer to the underlying oil and gas production principles. Unique Features: * Eight business use cases covering their business impact, code walkthroughs for most all and solution approach. * Industry data sets for participants to practice on and take home. * No software or complicated Python frameworks required. Training Objectives After the completion of this training course, participants will be able to: * Understand digital oil field transformation and its impact on business * Examine machine learning methods * Review workflows and code implementations * After completing the course, participants will have a set of tools and some pathways to model and analyze their data in the cloud, find trends, and develop data-driven models Target Audience This training course is suitable and will greatly benefit the following specific groups: * Artificial lift, production and facilities engineers and students to enhance their knowledge base, increase technology awareness, and improve the facility with different data analysis techniques applied on large data sets Course Level * Intermediate * Advanced Training Methods The course discusses several business use-cases that are amenable to data-driven workflows. For each use case, the instructor will show the solution using a data analysis technique with Python code deployed in the Google cloud. Trainees will solve a problem and tweak their solution. Course Duration: 2 days in total (14 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 20. This course is also available through our Virtual Instructor Led Training (VILT) format. Prerequisites: * Understanding of petroleum production concepts * Knowledge of Python is not a must but preferred to get the full benefit. * The training will use the Google Collaboratory environment available in Google-Cloud for hands-on exercises * Trainees will need to bring a computer with a Google Chrome browser and a Google email account (available for free) Trainer Your expert course leader has over 35 years' work-experience in multiphase flow, artificial lift, real-time production optimization and software development/management. His current work is focused on a variety of use cases like failure prediction, virtual flow rate determination, wellhead integrity surveillance, corrosion, equipment maintenance, DTS/DAS interpretation. He has worked for national oil companies, majors, independents, and service providers globally. He has multiple patents and has delivered a multitude of industry presentations. Twice selected as an SPE distinguished lecturer, he also volunteers on SPE committees. He holds a Bachelor's and Master's in chemical engineering from the Gujarat University and IIT-Kanpur, India; and a Ph.D. in Petroleum Engineering from the University of Tulsa, USA. Highlighted Work Experience: * At Weatherford, consulted with clients as well as directed teams on digital oilfield solutions including LOWIS - a solution that was underneath the production operations of Chevron and Occidental Petroleum across the globe. * Worked with and consulted on equipment's like field controllers, VSDs, downhole permanent gauges, multiphase flow meters, fibre optics-based measurements. * Shepherded an enterprise-class solution that is being deployed at a major oil and gas producer for production management including artificial lift optimization using real time data and deep-learning data analytics. * Developed a workshop on digital oilfield approaches for production engineers. Patents: * Principal inventor: 'Smarter Slug Flow Conditioning and Control' * Co-inventor: 'Technique for Production Enhancement with Downhole Monitoring of Artificially Lifted Wells' * Co-inventor: 'Wellbore real-time monitoring and analysis of fracture contribution' Worldwide Experience in Training / Seminar / Workshop Deliveries: * Besides delivering several SPE webinars, ALRDC and SPE trainings globally, he has taught artificial lift at Texas Tech, Missouri S&T, Louisiana State, U of Southern California, and U of Houston. * He has conducted seminars, bespoke trainings / workshops globally for practicing professionals: * Companies: Basra Oil Company, ConocoPhillips, Chevron, EcoPetrol, Equinor, KOC, ONGC, LukOil, PDO, PDVSA, PEMEX, Petronas, Repsol, , Saudi Aramco, Shell, Sonatrech, QP, Tatneft, YPF, and others. * Countries: USA, Algeria, Argentina, Bahrain, Brazil, Canada, China, Croatia, Congo, Ghana, India, Indonesia, Iraq, Kazakhstan, Kenya, Kuwait, Libya, Malaysia, Oman, Mexico, Norway, Qatar, Romania, Russia, Serbia, Saudi Arabia, S Korea, Tanzania, Thailand, Tunisia, Turkmenistan, UAE, Ukraine, Uzbekistan, Venezuela. * Virtual training provided for PetroEdge, ALRDC, School of Mines, Repsol, UEP-Pakistan, and others since pandemic. 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

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

OVERVIEW -------------------------------------------------------------------------------- Financial analysis gives you a wide understanding of a company's financial information which further helps you to analyse risks in the future and improve business prospects. It plays a vital role in calculating business profit. Professionals with the necessary skills help you to know how your business and forecast the future of the business. It helps to analyse financial statements and also to appraise the present and future prospects of the business. This course is specially designed to enhance the skills of financial professionals, in financial analytics by having in-depth knowledge of fundamentals of financial statement analysis thereby empowering their analytical skills in measuring the risk business investors are dealing with and also asking the appropriate questions. It will enhance the skills of the participant and will boost their confidence uplifting their ability to comment on business activities and analyse financial health for management. These skills and the required technical knowledge will be put into practice throughout the course using interactive examples and case studies. 

OVERVIEW -------------------------------------------------------------------------------- Objective * Understanding the Importance of Business Analysis Model * Determining various techniques of Process Modelling * Understanding the scope of modelling * Efficiently mapping the business landscape * Analysing the enterprise structure * How to avoid project failures. * Learning efficient skills of being a successful business analyst. * Understand and document various techniques for the organization delivers value. * Successful project conversion * Building team, changing the organization and overcoming resistance. * Creating an effective Business Case.

ABOUT THIS TRAINING COURSE The smart meter or smart grid represents the next-generation electrical power system. This system uses information, data & communication technology within generation, delivery and consumption of electric energy. This 4-day course will equip you with the innovations that are shaping the power generation and distribution systems and will cover topics ranging from Smart Metering Architecture, Cybersecurity, Smart Grid Systems and Power Line Communications. Training Objectives By participating in this course, you will be able to: * Comprehend the Smart Grid and Smart Meters architecture * Review latest trends and challenges within the Smart Grid Technology * Perform analysis on smart electronic meters * Comply with regulatory and metering standards * Recognize the importance of cybersecurity in smart grids * Maximize efficiency, reliability, and longevity of your smart meters and equipment * Gain valuable insights into power quality and harmonics Target Audience This course will greatly benefit the following groups but not limited to: * Smart Grid managers and engineers * Smart Meters managers and engineers * Power plant managers * Outage managers * Maintenance and operations engineers * Power regulatory personnel * Transmission managers and engineers * Distribution managers and engineers * IT managers * Renewable energy managers and engineers Course Level * Basic or Foundation * Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 4 days in total (28 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is a professional engineer with extensive experience in power system studies, substation design field-testing, and EHS programs settings for Mining and Electrical Utilities sectors. He was formally the Engineering Manager at GE Canada in Ontario. He received his M.Sc. in electrical engineering from the University of New Brunswick and his MBA from Laurier School of Business in Waterloo. He has managed and executed more than 150 engineering projects on substation design EMF audits and power system studies and analyses, EMF audits and grounding audits, for major electrical utilities, mines, oil and gas, data centers, industrial and commercial facilities in Canada and the U.S. He is a certified professional engineer in the provinces of Ontario and Alberta. He has various IEEE publications, has served as a technical reviewer for many IEEE journals in power systems and control systems, and is the chair of the Industry Application Chapter (IAS) for IEEE Toronto Section. He remains a very active member for the IEEE substation committee of IEEE Std. 81 ground testing (WGE6) and IEEE Std. 80 ground design (WGD7). A certified electrical safety trainer by GE Corporate and a Canadian Standard Association (CSA) committee member at the mining advisory panel for electrical safety, he also taught many technical courses all over Canada to industrial customers, electrical consultants as well as to electrical utilities customers. Highlighted Projects: * Various Power System Studies for 345/230 kV Stations - Nova Scotia Power (EMERA) * RF audits for Telecom tower and antennas - Cogeco/Rogers Mobile * Power System analysis - Powell Canada * Structural/Geotechnical Design and upgrades - Oakville Hydro * Underground Cables testing and sizing - Plan Group * Relay programming and design optimization - Cenovus Canada * Different Arc Flash Analysis and BESS Design - SNC Lavalin * Environmental site assessment (ESA) Phase I/II for multiple stations - Ontario * Electromagnetic compatibility (EMC) assessment for Toronto LRT expansion - MOSAIC * Battery energy storage system (BESS) installation at City of London - Siemens Canada * EMF audits for 500 kV Transmission Lines - Hydro One * EMF audits for 500 kV Transmission Lines - Hydro Quebec * AC interference for 138 kV line modeling and mitigations - HBMS Mine 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

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

ABOUT THIS TRAINING The Seismic Uncertainty Evaluation (SUE) course has evolved after a number of years of work experience in the sub-surface domain. A common question closely related to well planning is the quantification and qualification of depth uncertainty and robust estimation of the volumetric ranges, and this course addresses these topics. Training Objectives Upon completion of this course, participants will be able to: * Define a structured approach toward seismic depth uncertainty analysis * Construct data analytics on seismic products (well logs, velocities, and seismic) * Classify advance vertical ray tomography on FWI models to assure a drill ready depth seismic, faults, surfaces, and logs * Interpret probabilistic volumetric and automatic spill point control, amplitude conformance closures * De-risk the depth uncertainty by providing drilling and completion with a risking score card Target Audience This course is intended for individuals who needs to understand the basic theory and procedures for assessment/ quantification/qualification of all drill-ready products (seismic, faults, horizons, etc.) * Geologist * Geophysicist * Reservoir engineer * Drilling engineer Course Level * Intermediate Trainer Your expert course leader is a cross-functional Geoscientist and Published Author with 27 years of international experience working in Upstream Petroleum Exploration and Production for Oil and Gas Companies in Australia, India, Singapore, Saudi Arabia, and Oman. During his career he actively supported field development, static & dynamic reservoir modelling & well planning, 3D Seismic data acquisition with Schlumberger & SVUL, 3D seismic data processing with CGG & interpretation, Q.I. and field development with Woodside, Applied Geoscience, and Reliance. 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

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 THE QUERY EDITOR * Grouping rows in a table * Split row by delimiter * Add days to determine deadlines * The query editor 2 FUZZY MATCHING JOINS * Matching inconsistencies by percentage * Matching with transformation table 3 THE QUERY EDITOR M FUNCTIONS * Adding custom columns * Creating an IF function * Nested AND logics in an IF function 4 DAX NEW COLUMNS FUNCTIONS * Including TRUE with SWITCH * Using multiple conditions * The FIND DAX function * The IF DAX function * Logical functions IF, AND, OR 5 EDITING DAX MEASURES * Making DAX easier to read * Add comments to a measure * Using quick measures 6 THE ANATOMY OF CALCULATE * Understanding CALCULATE filters * Add context to CALCULATE with FILTER * Using CALCULATE with a threshold 7 THE ALL MEASURE * Anatomy of ALL * Create an ALL measure * Using ALL as a filter * Use ALL for percentages 8 DAX ITERATORS * Anatomy of iterators * A closer look at SUMX * Using RELATED with SUMX * Create a RANKX * RANKX with ALL 9 DATE AND TIME FUNCTIONS * Overview of functions * Create a DATEDIFF function 10 TIME INTELLIGENT MEASURES * Compare historical monthly data * Create a DATEADD measure * Creating cumulative totals * Creating cumulative measures * Visualising cumulative totals 11 VISUALISATIONS IN-DEPTH * Utilising report themes * Applying static filters * Group data using lists * Group numbers using bins * Creating heatmaps * Comparing proportions * View trends with sparklines 12 COMPARING VARIABLES * Visualising trendlines as KPI * Forecasting with trendlines * Creating a scatter plot * Creating dynamic labels * Customised visualisation tooltips * Export reports to SharePoint