25 Maths courses in Walton-on-Thames

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

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

Welcome to GLA Tutors, a pioneering platform for primary school tutoring and SATs preparation.  At GLA Tutors, we understand the importance of a strong foundation in primary school subjects and strive to provide comprehensive support to help children excel in their academic journey. Our team of expert tutors is well-versed in the English National Curriculum, which forms the basis of primary school education in the UK. We have carefully analysed the curriculum requirements to ensure that our tutoring services cover all key subjects and align with the learning objectives set by the curriculum. Our provision for tutoring all primary school subjects encompasses a wide range of subjects, including: 1. English: - Reading comprehension - Vocabulary development - Grammar and punctuation - Writing skills 2. Mathematics: - Number and place value - Addition, subtraction, multiplication, and division - Fractions, decimals, and percentages - Geometry and measurement 3. Science: - Investigating scientific phenomena - Understanding the natural world - Conducting experiments and making observations - Developing scientific thinking and inquiry skills 4. History: - Understanding historical events and timelines - Exploring significant figures and civilizations - Analysing primary and secondary sources - Developing historical knowledge and critical thinking skills 5. Geography: - Studying different landscapes and environments - Investigating human and physical geography - Exploring global issues and sustainability - Developing geographical skills and understanding At GLA Tutors, we understand that preparing children for SATs can be a challenging task. Our tutors are well-versed in the SATs format and content, and they provide targeted support to help children excel in their exams. We cover all areas of the SATs, including English (reading, grammar, and writing) and Mathematics, ensuring that children are well-prepared and confident on exam day. Our tutoring sessions are designed to be engaging and interactive, fostering a love for learning and encouraging children to reach their full potential. We use a variety of teaching techniques, including hands-on activities, visual aids, and interactive resources, to make learning enjoyable and effective. With GLA Tutors, you can be assured that your child will receive top-quality tutoring in all primary school subjects and be well-prepared for SATs. Our tutors are committed to providing personalised support, tailoring their teaching methods to meet the unique learning needs of each child. Join us and let us help your child thrive academically and achieve success in their primary school journey and SATs.

Our Team Building Programmes are 'simply excellent' (quote from Unilever). They always deliver much greater energy' motivation and efficiently accelerates to a galvanised, integrated team for their Manager/Team Leader. They're great fun and very commercially orientated - the best of both key elements to a successful and long-lasting high performance team. A successful company is always made up of successful teams. Teams that can work autonomously with a clearly defined set of goals, roles, vision, responsibility and culture will always reach for and achieve far greater success than a team that works just as a group of individuals. Our team building solutions are individually built and geared towards teams at any level within an organisation, providing an independent and objective perspective to promote a common purpose such as the creation of a 'high performance team'. Out With The Old Traditionally, team building events have been restricted to certain levels of management where they head off site for a bit of archery, quad biking and paintballing or something along those lines. Then over some coffee and cocktails, business plans and more efficient ways to work are casually discussed. Whilst being out having fun instead of being at work may improve an individual person's mood, the effect will only be short-term, and will not go far in creating permanent and cohesive teams who are able to overcome challenges together and drive the business forward when back in the workplace. In With The New Today's business thinking is more strategic and certainly has to look for returns on the investment. That is why Dickson Training Ltd's team building programmes are bespoke and built to your requirements through research, understanding your business and, most importantly, what results and achievements you are looking to get out of the programme. Once "what success looks like" has been established, we create tasks and activities that will test your leadership, problem solving, communication and team work skills. When the tasks have been completed, the learning - both practical and theory - is debriefed to the group as well as how it will translate back in your business. Not only are our events great fun, but they provide participants with learning points they can act upon to improve or enhance the working practices/environment. Team Building That Gets Results We have a highly innovative team who design team builds to suit all budgets and time or space restrictions. Large or small, we will develop the perfect event to meet your commercial objectives, keeping in line with your values and company culture. More recently we have combined team galvanising events with ways to engage the participants with and support their local communities. This solution has proved extremely popular with our clients and we are continuing to develop more and more programmes doing exactly this. " Phil did everything in a very professional and focused manner, without losing sight of the overall aims or having 'fun'. When I moved to Airbus UK and subsequently European Aeronautic Defense and Space Company (EADS), I had no hesitation in recommending Phil and the team to deliver the required training and team events.  Without doubt Phil and his team are excellent providers of training, to suit even bespoke requirements, and I would not hesitate in recommending the team to any business in the future. " Glenn Brown, Systems & Expertise Manager, Airbus Personnel Service Augmented Skills – an Essay by Phil Dickson All of you, who are reading this, and all the people you meet and work with will have – ‘Augmented Skills’. So – if you are an IT Engineer or a Pharmacist; perhaps you are, or know, a Departmental Leader and you work with a Logistics Project Manager; these roles will demand core skills, whether they be technical know-how or qualifications in the discipline. But to be that bit better; more reliable; more effective & productive and therefore more valuable and, frankly, marketable – capitalizing on ‘Augment Skills’ comes into play. The I T Engineer who was a Chess Champion at Uni, which would indicate that they possess some key ‘Augmented skills’ including how they plan 3 steps ahead and are always prepared for the unexpected. The Pharmacist, who is a keen sportsperson in their private life, will likely be tenacious, team-orientated and disciplined – again these are superb qualities to have in this – or any – role. Your colleagues, as well as yourself, will have ‘Augmented Skills’ that will be an asset if only they are explored and applied to their role and indeed, career. Everyone has their own 'Super-power' If they love gardening, they are probably strategic, patient and inclined to research; if they cook or bake, they are usually well organized and comfortable with multi-tasking. A big reader will tend to be considered and possess good critical thinking faculties, and an amateur mechanic or keen DIY person will often be practical, resourceful and very determined. I have observed that many new Parents discover they have ‘Augmented Skills’ they didn’t know they had... such as getting order out of chaos and displaying industrial amounts of patience and good grace when they really do not feel like it. They very often become far more compassionate and empathetic. Most people have their very own ‘Superpower’. Invite your team members to offer their ‘Augmented Skills’ to your work-place – and just watch as it elevates the motivation levels and improves results. It’ll be very rewarding for all concerned – and for meeting the Team’s objectives, to encourage the person who is a talented artist to be a sounding board on some of the marketing imagery and layouts; for the team member who is great at Maths or resolving crosswords to be asked for their input to solving a problem that is causing logistical or operational headaches. Never exploit a Team member’s unique special skills at their expense I would like to stress, however, that it must never be an area where a team member gets exploited by harvesting their unique special skills to coerce them into taking on greater responsibilities and tasks without providing them with the commensurate salary and status. To do so would be immoral and, ultimately, counter-productive as it would lead to resentment and disenfranchisement. This is about encouraging people’s capability and inviting their input to boost confidence and enhance the team’s capability. Often, we need to be more than what our Job Description says It is also important to highlight that whatever a person’s role or function is – they will definitely need to have additional capabilities to be effective. The best example of this is when we designed and delivered a range of ‘Advanced Customer Care skills’ training sessions for the Met Office a few years ago…we met so many remarkably super-bright Meteorologists, many of whom were having to make significant adjustments to answering questions from Customers that seemed to be illogical and often, obtuse. It wasn’t enough for these Meteorologists to be highly skilled at interpreting data and identifying patterns – they needed ‘Augmented skills’ to make that information accessible to members of the public (and Council workers and Air Traffic controllers and Shipping agents) and many other people, as to what that particular weather system was going to be like in their area and at what time. They have to know how to ‘de-jargonise’ the material and provide succinct, clear, and yet temperate, descriptions without ever appearing exasperated, impatient or judgmental in response to sometimes quite silly questions. For a highly trained scientist – that can be counter-intuitive. Being Philosophical... and a wee bit pretentious At the risk of being a little Philosophical (and probably a wee bit pretentious) – in my own role of Trainer – my core skills have to include – being a very good communicator, an active listener and have innovative and engaging ways to convert an idea, or a model, into practical application that my Delegates and Clients gain tangible benefits from. This is how it applies to me... I really enjoy composing short, light classical-style piano pieces. Now, to do this well, you need to be able to find a transition from one chord or melody to a different theme or key. It has to be worked out very carefully to have incremental transitions and pleasant-sounding developments as the piece unfolds. I think I have become better at this as I have honed my skills as a composer. But I have realized that these very same skills have ‘Augmented’ my ability to help a Manager, or a Team, move from a state of conflict; tension; disfunction; disenfranchisement; lack of confidence to a place that is more harmonious with far greater productivity. The very same process of careful listening, considering options, taking well-considered steps, having a creative, sometimes brave, move towards a resolution are at play in both Training and Piano Compositions! Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

Welcome to GLA Tutors, a pioneering platform for primary school tutoring and SATs preparation.  At GLA Tutors, we understand the importance of a strong foundation in primary school subjects and strive to provide comprehensive support to help children excel in their academic journey. Our team of expert tutors is well-versed in the English National Curriculum, which forms the basis of primary school education in the UK. We have carefully analysed the curriculum requirements to ensure that our tutoring services cover all key subjects and align with the learning objectives set by the curriculum. Our provision for tutoring all primary school subjects encompasses a wide range of subjects, including: 1. English: - Reading comprehension - Vocabulary development - Grammar and punctuation - Writing skills 2. Mathematics: - Number and place value - Addition, subtraction, multiplication, and division - Fractions, decimals, and percentages - Geometry and measurement 3. Science: - Investigating scientific phenomena - Understanding the natural world - Conducting experiments and making observations - Developing scientific thinking and inquiry skills 4. History: - Understanding historical events and timelines - Exploring significant figures and civilizations - Analysing primary and secondary sources - Developing historical knowledge and critical thinking skills 5. Geography: - Studying different landscapes and environments - Investigating human and physical geography - Exploring global issues and sustainability - Developing geographical skills and understanding At GLA Tutors, we understand that preparing children for SATs can be a challenging task. Our tutors are well-versed in the SATs format and content, and they provide targeted support to help children excel in their exams. We cover all areas of the SATs, including English (reading, grammar, and writing) and Mathematics, ensuring that children are well-prepared and confident on exam day. Our tutoring sessions are designed to be engaging and interactive, fostering a love for learning and encouraging children to reach their full potential. We use a variety of teaching techniques, including hands-on activities, visual aids, and interactive resources, to make learning enjoyable and effective. With GLA Tutors, you can be assured that your child will receive top-quality tutoring in all primary school subjects and be well-prepared for SATs. Our tutors are committed to providing personalised support, tailoring their teaching methods to meet the unique learning needs of each child. Join us and let us help your child thrive academically and achieve success in their primary school journey and SATs.

Elevate Your Learning Journey with HRB Education - Where Potential Meets Excellence

Subject content Students will draw upon a range of texts as reading stimulus and engage with creative as well as real and relevant contexts. Students will have opportunities to develop higher-order reading and critical thinking skills that encourage genuine enquiry into different topics and themes. We can help students to read fluently and write effectively. Students will be able to demonstrate a confident control of Standard English and write grammatically correct sentences, deploying figurative language and analysing texts. For GCSE English Language students should: read fluently, and with good understanding, a wide range of texts from the 19th, 20th and 21st centuries, including literature and literary non-fiction as well as other writing such as reviews and journalism read and evaluate texts critically and make comparisons between texts summarise and synthesise information or ideas from texts use knowledge gained from wide reading to inform and improve their own writing write effectively and coherently using Standard English appropriately use grammar correctly and punctuate and spell accurately acquire and apply a wide vocabulary, alongside a knowledge and understanding of grammatical terminology, and linguistic conventions for reading, writing and spoken language listen to, and understand, spoken language and use spoken Standard English effectively. Texts GCSE English Language is designed on the basis that students should read and be assessed on high-quality, challenging texts from the 19th, 20th and 21st centuries. Each text studied represents a substantial piece of writing, making significant demands on students in terms of content, structure and the quality of language.  The texts, across a range of genres and types, support students in developing their own writing by providing effective models.  The texts include literature and extended literary non-fiction, and other writing such as essays, reviews and journalism (both printed and online). We can provide assistance for everything you need to prepare students for exams, including: past papers, mark schemes and examiners’ reports specimen papers and mark schemes for new courses exemplar student answers with examiner commentaries guidance in planning and writing cohesively high quality revision guides

Unlocking Success in GCSE Geography! At GLA Tutors, we are dedicated to helping students excel in their GCSE Geography examinations. Our experienced tutors are passionate about the subject and committed to providing comprehensive support tailored to the AQA examination board's specification. Let's dive into the breakdown of the AQA GCSE Geography specification: Paper 1: Living with the Physical Environment This paper focuses on understanding natural landscapes, such as rivers, coasts, and ecosystems. Our tutors will guide students through topics like the water cycle, coastal processes, and the impact of climate change. We offer in-depth explanations, interactive activities, and exam-style practice to build a solid foundation. Paper 2: Challenges in the Human Environment This paper explores the relationship between humans and their environment, including urban areas, development, and global issues. Our tutors will delve into concepts like population dynamics, urbanisation, sustainable development, and global inequalities. Through engaging discussions and real-world examples, we help students grasp the complexities of human geography. Paper 3: Geographical Applications In this paper, students apply their geographical skills to investigate real-world issues and carry out fieldwork. Our tutors will guide students through the process of designing and conducting fieldwork, collecting and analysing data, and presenting their findings. We provide practical guidance, research resources, and feedback to develop strong investigative skills. At GLA Tutors we go beyond the specification to nurture a deep understanding of geography. Our tutors create a supportive and engaging learning environment that encourages critical thinking, analysis, and effective exam techniques. We offer personalised one-on-one sessions, group discussions, and access to a range of learning materials to cater to each student's needs. Whether it's understanding the intricacies of physical processes or analysing the complexities of human interactions, our tutors are here to guide students towards success in their GCSE Geography journey. Join us and unlock your full potential in GCSE Geography! Feel free to explore our website for more information or reach out to us with any questions you may have. Let's embark on this exciting learning adventure together!  https://www.globallearners.academy/services/gcse We can provide assistance for everything you need to prepare students for exams, including: past papers, mark schemes and examiners’ reports specimen papers and mark schemes for new courses exemplar student answers with examiner commentaries high quality revision guides

Getting to grips with GCSE History At GLA Tutors, we are dedicated to helping students excel in their GCSE History examinations. Our experienced tutors are passionate about history and committed to providing comprehensive support aligned with the AQA examination board's specification.  Let's explore the breakdown of the AQA GCSE History specification: Paper 1: Understanding the Modern World This paper focuses on key historical events and developments from the 20th century. Our tutors will guide students through topics such as the origins of World War I, the Treaty of Versailles, the rise of Hitler and the Nazis, the Cold War, and the civil rights movement. We provide in-depth analysis, engaging discussions, and access to a wide range of historical sources to help students develop a deep understanding of these crucial events. Paper 2: Shaping the Nation In this paper, students will explore the history of Britain from medieval times to the present day. Our tutors will delve into topics such as the Norman Conquest, the Tudors, the Industrial Revolution, the British Empire, and the impact of immigration. We provide comprehensive guidance on key historical figures, significant events, and the social, political, and economic changes that shaped the nation. Through interactive lessons and engaging activities, we help students develop a strong grasp of British history. Historical Investigation This component allows students to conduct an in-depth investigation on a topic of their choice. Our tutors will provide guidance on selecting a suitable topic, conducting research, analysing sources, and presenting findings. We help students develop critical thinking skills, research methodology, and the ability to construct coherent and well-supported arguments. This component allows students to develop their historical research skills while exploring a topic of personal interest. At GLA Tutors, we foster a supportive and inclusive learning environment, where students can explore and deepen their understanding of history. Our tutors provide personalised one-on-one sessions, group discussions, and access to a range of learning resources to cater to each student's unique needs. Beyond the specification, we encourage critical thinking, historical empathy, and the ability to analyse and interpret historical sources. We also focus on developing strong exam techniques, essay writing skills, and effective revision strategies to maximise exam success. Join us at GLA Tutors and embark on a transformative journey in GCSE History. Our tutors are here to guide you towards academic excellence, a deeper appreciation for the past, and the ability to critically analyse historical events and their impact on the world today. Feel free to explore our website for more information or reach out to us with any questions you may have. We can provide assistance for everything you need to prepare students for exams, including: past papers, mark schemes and examiners’ reports specimen papers and mark schemes for new courses exemplar student answers with examiner commentaries high quality revision guides

Excelling in GCSE Religious Studies! At GLA Tutors, we are dedicated to helping students succeed in their GCSE Religious Studies examinations. Our experienced tutors are passionate about the subject and committed to providing comprehensive support aligned with the AQA examination board's specification. Let's explore the breakdown of the AQA GCSE Religious Studies specification: Paper 1: The Study of Religions: Beliefs and Teachings This paper focuses on the study of two religions, such as Christianity and Islam. Our tutors will guide students through the fundamental beliefs, teachings, and practices of these religions. We delve into topics like the nature of God, religious texts, worship, and the impact of religion on individuals and society. Through engaging discussions and thought-provoking exercises, we help students develop a deep understanding of religious beliefs. Paper 2: Thematic Studies This paper explores ethical and philosophical issues, as well as the influence of religion in the modern world. Our tutors will delve into topics like crime and punishment, human rights, life and death, and religion and society. We provide in-depth analysis, case studies, and perspectives from different religious traditions to enable students to critically examine these issues. We also emphasise the development of strong argumentation and evaluation skills. Paper 3: Study of Religion: Textual Studies In this paper, students will explore religious texts and their significance. Our tutors will guide students through the study of sacred texts, such as the Bible or the Qur'an. We help students analyse and interpret these texts, understand their historical and cultural context, and explore their relevance in contemporary society. We provide comprehensive guidance on textual analysis and the application of religious teachings to real-life situations. At GLA Tutors, we foster a supportive and inclusive learning environment, where students can explore and deepen their understanding of religious studies. Our tutors provide personalised one-on-one sessions, group discussions, and access to a range of learning resources to cater to each student's unique needs. Beyond the specification, we encourage critical thinking, empathy, and open-mindedness, enabling students to engage with complex ethical and philosophical questions. We also focus on developing strong exam techniques, essay writing skills, and effective revision strategies to maximize exam success. Join us at GLA Tutors and embark on a transformative journey in GCSE Religious Studies. Our tutors are here to guide you towards academic excellence, a deep appreciation for religious diversity, and the ability to apply religious teachings to real-world contexts. Feel free to exploreour websitefor more information or reach out to us with any questions you may have.  https://www.globallearners.academy/services/gcse We can provide assistance for everything you need to prepare students for exams, including: past papers, mark schemes and examiners’ reports specimen papers and mark schemes for new courses exemplar student answers with examiner commentaries high quality revision guides