There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups
This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment
Managing for Growth is designed for anyone who has management and leadership responsibilities within an organisation. Suitable for newly promoted managers, team leaders and supervisors through to senior managers; the objective of the programme is to develop a culture that will translate strategy into measurable outcomes by engaging these leaders to facilitate change and innovation. The programme is extremely effective at giving managers the tools and skills to deliver sustainable change and business growth. It's also been proven to reduce costs and increase profit – even before the programme has ended. Managing for Growth is built upon three aspects common to every job: Managing Resources. Ensuring that the resources available are appropriate for the tasks for which they are required and are being used effectively. Learning how to control and coordinate a mix of available resources for maximum efficiency. Managing Relationships. Positively influencing people’s behaviour in order to motivate them and promote effective working. Focusing on listening skills, we share ways to improve communication and teamwork to get the best from both internal and external relationships. Controlling Routines. Investigating the processes/systems/routines/series of actions that are linked together to achieve a desired outcome. Recognising the importance of controlling, developing, simplifying and following routines. Managing for Growth shows your team leaders, supervisors and managers how to cultivate a culture of teamwork and continuous improvement within your organisation. Focus for Action Throughout the programme the participants take part in work-based activities that will cause them to evaluate every aspect of their job and identify areas for improvement. By the end of the programme, the participants act on these action lists and implement improvement projects that will deliver measurable results. Continuous Improvement Managing for Growth sets the framework for continuous improvement by transferring skills and knowledge enabling your team leaders to translate organisational strategies into real, measurable outcomes. Format Designed for groups of up to 6 people, the programme is spread over 4 months with the first 7 sessions being held every 2 weeks and the final session a month later. Each session lasts approximately 2 hours.
Are you looking for something that will help you understand yourself and how to interact with others more effectively? Would you like something that uses a simple four colour model to quickly allow you to understand your personality type and how you can use this knowledge to enhance your relationships and reach your goals, whatever they are? We think that Insights Discovery might be just the thing for you! What's even better is that our Discovery bundle includes both a copy of your unique profile and a 90 minute personal session with our executive coach, Cami Rose, to chat it all through and set you up for success using your new knowledge for the future. Just request a session and we'll be in touch with the link that will allow you to complete the Insights evaluator and arrange your personal coaching session at a time to suit you. Want Discovery for your team? We can do that too. Leave us your name and details and we'll be in touch to chat through your needs and objectives.
Tiny toes ballet offers fun inclusive baby, toddler & kids dance classes that nurture confidence & promote development in Essex. Book a two-week trial. Welcome to tiny toes ballet Essex Mid & South! Offering award-winning pre-school children's ballet and dance classes from 6 months upwards in Benfleet, South Woodham Ferrers, Westcliff-on-Sea, Rayleigh, Leigh-on-Sea, Southend-on-Sea. With our kids ballet classes and kids dance classes, your child will discover the joy of dancing, while also developing important skills such as coordination, balance, and rhythm. Our kids ballet classes encourage creativity, imagination, and confidence.
Tiny toes ballet offers fun inclusive baby, toddler & kids dance classes that nurture confidence & promote development in Essex. Book a two-week trial. Welcome to tiny toes ballet Essex Mid & South! Offering award-winning pre-school children's ballet and dance classes from 6 months upwards in Benfleet, South Woodham Ferrers, Westcliff-on-Sea, Rayleigh, Leigh-on-Sea, Southend-on-Sea. With our kids ballet classes and kids dance classes, your child will discover the joy of dancing, while also developing important skills such as coordination, balance, and rhythm. Our kids ballet classes encourage creativity, imagination, and confidence.
Tiny toes ballet offers fun inclusive baby, toddler & kids dance classes that nurture confidence & promote development in Essex. Book a two-week trial. Welcome to tiny toes ballet Essex Mid & South! Offering award-winning pre-school children's ballet and dance classes from 6 months upwards in Benfleet, South Woodham Ferrers, Westcliff-on-Sea, Rayleigh, Leigh-on-Sea, Southend-on-Sea. With our kids ballet classes and kids dance classes, your child will discover the joy of dancing, while also developing important skills such as coordination, balance, and rhythm. Our kids ballet classes encourage creativity, imagination, and confidence.
Tiny toes ballet offers fun inclusive baby, toddler & kids dance classes that nurture confidence & promote development in Essex. Book a two-week trial. Welcome to tiny toes ballet Essex Mid & South! Offering award-winning pre-school children's ballet and dance classes from 6 months upwards in Benfleet, South Woodham Ferrers, Westcliff-on-Sea, Rayleigh, Leigh-on-Sea, Southend-on-Sea. With our kids ballet classes and kids dance classes, your child will discover the joy of dancing, while also developing important skills such as coordination, balance, and rhythm. Our kids ballet classes encourage creativity, imagination, and confidence.
Tiny toes ballet offers fun inclusive baby, toddler & kids dance classes that nurture confidence & promote development in Essex. Book a two-week trial. Welcome to tiny toes ballet Essex Mid & South! Offering award-winning pre-school children's ballet and dance classes from 6 months upwards in Benfleet, South Woodham Ferrers, Westcliff-on-Sea, Rayleigh, Leigh-on-Sea, Southend-on-Sea. With our kids ballet classes and kids dance classes, your child will discover the joy of dancing, while also developing important skills such as coordination, balance, and rhythm. Our kids ballet classes encourage creativity, imagination, and confidence.
Tiny toes ballet offers fun inclusive baby, toddler & kids dance classes that nurture confidence & promote development in Essex. Book a two-week trial. Welcome to tiny toes ballet Essex Mid & South! Offering award-winning pre-school children's ballet and dance classes from 6 months upwards in Benfleet, South Woodham Ferrers, Westcliff-on-Sea, Rayleigh, Leigh-on-Sea, Southend-on-Sea. With our kids ballet classes and kids dance classes, your child will discover the joy of dancing, while also developing important skills such as coordination, balance, and rhythm. Our kids ballet classes encourage creativity, imagination, and confidence.