37 Analytics courses in Glasgow

Businesses that don't control their costs don't stay in business. How well are you doing? Is everyone in your organisation sufficiently aware of costs, managing them effectively and maximising opportunities to reduce them? If there is scope for improvement, this course will help get you back on track. It will demonstrate that cost reduction is so much more than cost control and cost cutting. True cost management is about being aware of costs, seeking to reduce them through good design and efficient operating practices whilst taking continuing action on overspending. This course will develop the participants' skills in: * Being aware of costs at all times * Seeking cost reduction from the start (including life-cycle costing) * Appraising projects / production to identify and take out risk * Understanding real budgeting * Using techniques such as ZBB and ABC where appropriate * Ensuring cost reports lead to action * Managing a cost reduction process that delivers Benefits to the organisation will include: * Identification of cost reduction and business improvement opportunities * Better reporting and ownership of costs * Greater awareness and control of everyday costs 1 INTRODUCTION - THE COST MANAGEMENT PROCESS * The risks of poor cost control * Capital and revenue costs * The importance of cost awareness * The importance of cost reduction * Cost management - the key aspects * How to build a cost management and control process checklist for your areas of responsibility 2 COST REMOVAL - TAKING OUT COSTS * Cost awareness * Costs of poor design / poor processes * Value engineering * Removing redundant costs 3 THE NEED FOR COMMERCIAL, TECHNICAL AND FINANCIAL APPRAISALS * Understand the problems before cash is committed and costs incurred * Making the effort to identify commercial and technical risk * The time value of money - DCF techniques for long term projects * Cost models for production processes and projects * Costing models - project appraisals * The use of spreadsheets to identify sensitivity and risk * How to focus on risk management 4 BUDGETING - PROPER BUDGETING CHALLENGES COSTS * The philosophy of the business - are costs an issue? * The importance of having the right culture * The need for detailed business objectives * Budgetary control measures * Designing budget reports - for action 5 ZERO-BASED BUDGETING (ZBB) - THE PRINCIPLES * Much more than starting with a clean sheet of paper * What ZBB can achieve * The concept of decision packages - to challenge business methods and costs * Only necessary costs should be incurred * A review of an operating budget - demonstrating what ZBB challenges and the costs it may lead to being taken out 6 AWARENESS OF OVERHEADS AND OTHER COSTS * Definitions of cost - direct and indirect * Dealing with overheads - what is meant by allocation, absorption or apportionment? * The apparent and real problems with overheads * Different ways of dealing with overheads * Review of overhead allocation methods and accounting and reporting issues 7 OVERHEADS AND PRODUCT COSTING * Activity-based costing (ABC) - the principles * Where and how the ABC approach may be helpful * Know the 'true' cost of a product or a project * Should you be in business? Will you stay in business? * Identifying weaknesses in a traditional overhead allocation * How ABC will help improve product or service costing * Identifying which products and activities should be developed and which abandoned 8 COST REDUCTION CULTURE * The need for cost reports * What measures can be used to identify over-spends as early as possible * Cost control performance measures and ratios 9 DESIGN OF COST CONTROL REPORTS * Reports should lead to action and deliver * Selecting cost control measures which can be acted upon * Practice in designing action reports 10 COURSE SUMMARY - DEVELOPING YOUR OWN COST ACTION PLAN * Group and individual action plans will be prepared with a view to participants identifying their cost risks areas and the techniques which can be immediately applied to improve costing and reduce costs

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 INTRODUCTION * Power BI ecosystem * Things to keep in mind * Selecting dashboard colours * Importing visuals into Power BI * Data sources for your analysis * Joining tables in Power BI 2 WORKING WITH DATA * Utilising a report theme * Table visuals * Matrix visuals * Drilling into hierarchies * Applying static filters * Group numbers with lists * Group numbers with bins 3 CREATING VISUALS * Heatmaps in Power BI * Visualising time-intelligence trends * Ranking categorical totals * Comparing proportions * View trends with sparklines 4 COMPARING VARIABLES * Insert key performance indicators (KPI) * Visualising trendlines as KPI * Forecasting with trendlines * Visualising flows with Sankey diagrams * Creating a scatter plot 5 MAPPING OPTIONS * Map visuals * Using a filled map * Mapping with latitude and longitude * Mapping with ArcGIS or ESRI 6 CREATING DASHBOARDS * High-level dashboard * Migration analysis dashboard * Adding slicers for filtering * Promote interaction with nudge prompts * Searching the dashboard with a slicer * Creating dynamic labels * Highlighting key points on the dashboard * Customised visualisation tooltips * Syncing slicers across pages 7 SHARING DASHBOARDS * Setting up and formatting phone views * Exporting data * Creating PDF files * Uploading to the cloud * Share dashboards in SharePoint online

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: * Calculate with absolute reference * Group worksheets * Link to tables * Use the function library effectively * Get to grips with the logical IF function * Use conditional formatting * Create pivot table reports * Use data validation * Master the VLOOKUP function 1 CALCULATING WITH ABSOLUTE REFERENCE * The difference between a relative and absolute formula * Changing a relative formula to an absolute * Using $ signs to lock cells when copying formulas 2 GROUPING WORKSHEETS * Grouping sheets together * Inputting data into multiple sheets * Writing a 3D formula to sum tables across sheets 3 LINKING TO TABLES * Linking to a source table * Using paste link to link a table to another file * Using edit links to manage linked tables 4 THE FUNCTION LIBRARY * Benefits of writing formulas in the function library * Finding the right formula using insert function * Outputting statistics with COUNTA and COUNTBLANK * Counting criteria in a list with COUNTIFS 5 LOGICAL IF FUNCTION * Outputting results from tests * Running multiple tests for multiple results * The concept of outputting results from numbers 6 CONDITIONAL FORMATTING * Enabling text and numbers to standout * Applying colour to data using rules * Managing rules * Copying rules with the format painter 7 VIEW SIDE BY SIDE * Comparing two Excel tables together * Comparing two sheets together in the same file 8 PIVOT TABLE REPORTS * Analysing data with pivot tables * Managing a pivot table's layout * Outputting statistical reports * Controlling number formats * Visualising reports with pivot charts * Inserting slicers for filtering data 9 DATA VALIDATION * Restricting data input with data validation * Speeding up data entry with data validation 10 VLOOKUP FUNCTION * Best practices for writing a VLOOKUP * A false type lookup * A true type lookup * Enhance formula results with IFNA 11 PRINT OPTIONS * Getting the most from print * Printing page titles across pages * Scaling content for print

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: * Create tables * Use functions * Manage rows and columns * Write formulas * Manage sheets * Use content formats * Handle larger tables * Create reports and charts 1 CREATING A TABLE * Creating an Excel table from scratch * Wrapping text in cells * Speeding up data entry using AutoFill * Sorting columns 2 INSERTING FUNCTION * Inserting function calculators * Using AutoSum to sum numbers * Statistical calculations AVERAGE, MAX and MIN 3 TABLE ROWS AND COLUMNS * Inserting and deleting rows and columns * Adjusting multiple column widths and row heights * Hiding and unhiding rows and columns 4 FORMULA WRITING * The basics of formula writing * Understanding mathematical symbols * Using multiple mathematical symbols in a formula * When to use brackets * Troubleshooting calculation errors 5 MANAGING SHEETS * Inserting, renaming, moving and deleting sheets * Copying a worksheet to another file * Copying a table to another sheet 6 MANAGING CONTENT FORMATS * Applying data formats * Managing number formats * Controlling formats with the Format Painter 7 MANAGING LARGER TABLES * Applying freeze panes to lock tables when scrolling * Sorting on multiple columns * Using filters to extract table information 8 CREATING AND MODIFYING CHARTS * Creating a pie chart * Creating a column chart * Inserting chart titles and data labels * Controlling chart formatting * Changing chart types 9 PRINTING * Previewing and printing tables and charts * Modifying page orientation * Adjusting print margins * Printing a selection 10 CALCULATING WITH ABSOLUTE REFERENCE * The difference between a relative and absolute formula * Changing a relative formula to an absolute * Using $ signs to lock cells when copying formulas 11 PIVOT TABLES * Create a pivot table report * Insert a pivot chart into a report

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: * Nest formulas * Get the most from pivot tables * Use conditional formatting * Write array formulas * Explore the lookup functions * Calculate by criteria * Use 'goal seek' and 'scenario manager' for what-if analysis * Record macros 1 NESTING FORMULAS * Principles of nesting formulas together * Using IF with AND or OR to answer questions * Nesting an AND function in an IF * Nesting an OR function in an IF 2 ADVANCED PIVOT TABLE REPORTS * Grouping dates, numerical and text items * Running percentage analyse * Running analyses to compare data * Inserting Field calculations * Finishing off with a user-friendly dashboard 3 ADVANCED CONDITIONAL FORMATTING * Colour table rows based on criteria in it * Applying colour to approaching dates * Exploring the different rule types 4 LOOKUP FUNCTIONS * Going beyond the VLOOKUP function * Lookups that retrieve data from left or right * The versatile INDEX and MATCH functions * Retrieving data from columns with duplicates 5 CALCULATE BY CRITERIA * Using SUMIFS to sum by criteria * Finding an average by criteria with AVERAGEIFS * Use SUMPRODUCT to multiply then add different values 6 WHAT-IF ANALYSIS * Use Goal Seek to meet targets * Forecast reports with the Scenario Manager 7 RECORDING MACROS * Macro security * Understanding a Relative References macro * Recording, running and editing macros * Saving files as Macro Enabled Workbooks * Introduction to VBA code * Making macros available across workbooks * Add a macro button to the Quick Access toolbar

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: * Ensure the integrity of their databases * Manage field properties * Use the query functions effectively * Save time with the query expression builder * Create different types of query more quickly * Design better forms * Link expressions in forms * Create better and more useful reports * Import and export tables more easily 1 TABLE RELATIONSHIP INTEGRITY * Identifying relationships * Identifying criteria for data integrity * Applying referential integrity * Managing relationship join types 2 TABLE FIELD PROPERTIES * Field properties overview * Using input mask field * Using default value fields * Using field validation rules 3 QUERY FUNCTIONS * Running aggregate function calculations * Running sum, average, count, max and min functions * Grouping calculated data 4 QUERY CALCULATIONS * Using query operators and expressions * Adding calculated fields to a query * Using the query expression builder 5 ACTION QUERIES * Creating make table queries * Creating append queries * Creating update queries * Creating delete queries 6 DESIGNING FORMS * Adding form controls * Aligning and arranging form controls * Adding pictures and labels to forms * Adding new fields to a form * Controlling tab order * Adding command buttons * Adding a combo box control * Formatting data using conditional formatting 7 FORM EXPRESSIONS (CALCULATIONS) * Using the form expression builder * Working with a property sheet within a form * Linking expressions within a form 8 WORKING WITH REPORTS * Creating reports with the report wizard * Inserting report fields * Formatting fields * Inserting report headers and footers * Working with a property sheet within a report 9 GROUPED REPORTS * Creating groups with the report wizard * Sorting grouped data * Grouping alphabetically * Grouping on date intervals * Creating sub reports * Adding calculations to groups 10 IMPORTING AND EXPORTING TABLES * Importing tables into Access * Exporting tables from Access * Importing and linking data in Access