1182 OV courses in Birmingham

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

We will come to your school at a time that suits you and run a 2-hour workshop for all staff. We will present in clear and simple terms the school’s duties under the Equality Act, help you guard against discrimination, and leave you with useful resources. How will this workshop help your school? This is a practical, "hands on" workshop designed to be engaging and constructive. Over and above helping your school fulfil its legal duties, it will help ensure that nobody is left behind or discriminated against. The workshop will show how all protected characteristics covered by the Equality Act 2010 can be reflected positively in everyday school life. It will consider real-life examples and make this more meaningful and relevant by inviting participants to bring their own examples of equality challenges in school. We will show you how to get the best out of CSIE’s toolkit ‘Equality: Making It Happen’ – a succinct and user-friendly set of reference cards to help schools promote equality – and leave you with at least two complimentary copies. Above all, the workshop will help develop a shared understanding and build a consistent response to diversity and equality. We understand that all schools are at different stages of this journey, so this workshop will assist you in determining next steps and areas of specific focus for your setting. What will the workshop cover? The workshop will: provide an overview of the Equality Act 2010, including the Public Sector Equality Duty and what it means for all schools bring awareness to unconscious bias and how it can influence our interactions present strategies for removing barriers to learning and participation address intersectionality and how it affects people’s experiences help develop confidence and language for discussing sensitive equality issues add flesh to the bones of all the above, by considering real-life examples Who is it for? The workshop has been designed for all primary and secondary school staff and governors; delivery is adjusted to the context of each school. We encourage all teaching and non-teaching staff to attend, so that your school can develop a coherent and consistent response to diversity and equality. Feedback from previous CSIE equality workshops: Very knowledgeable presenter. I feel more empowered. Clear and concise. Very thought provoking. Clear, compassionate presentation.

The course price includes Refreshments, Car Parking Fees, Workbooks, Resources including access to our Trainer Resource Pack via the Approved Trainer HUB, Approved Trainer Membership, Approved Trainer T-Shirt, Ongoing Quality Assurance , support and Certification. We deliver this course to small groups a maximum of 4 people attend this course at our training premises ensuring all our learners receive Quality time with the Trainers/ Assessors delivering the course.

Manicures can be found on nearly every treatment menu and are often the bread and butter of many businesses. The manicure offers the therapist or technician a whole range of options to suit nearly every client. This course will teach you everything you need to know about offering a professional manicure and includes a practical training session and assessment. Gel Polish treatments are an increasingly popular treatment within the professional beauty industry. Gel Polish is applied to the client’s nail and then cured using an LED or UV lamp to create a longer lasting nail treatment (up to 3 weeks) than a standard manicure. The GTi Gel Polish course covers how to complete gel polish application and demonstrates the correct removal techniques. The course also covers reception and consultation, contra-indications to treatment and aftercare advice. The GTi Tips With Acrylic Overlay course will teach you how to apply the Acrylic System (Liquid and Powder) in conjunction with nail tips. The course covers how to complete the application and demonstrates the correct removal techniques. It also covers reception and consultation, contra-indications to treatment and aftercare advice. On completion of the course you will receive three recognised and insurable qualifications. Includes: 3 Hard copy take home training manuals. Duration – Fast track two-day practical classroom-based training plus online theory work. Theory work to be completed in your own time via The Guild student portal before your practical course date. Practical day – 10am – 6pm, 10:30am – 5pm & 11am-5:30pm inc short lunch break. It is advisable that students arrive 15 mins early to ensure a prompt start. In a lot of cases the practical training can be finished earlier than expected depending on how many students there are, and the time taken on practical work. Widely recognisable and insurable qualification, allowing you to deliver this treatment on the paying general public. Class size - Maximum 8 students in a class

Intercultural Competence: In-House Training In a world that conducts business across continents and geographical borders, more than ever it is essential for team and organizational leaders to not only understand but also embrace the diversity of cultures; this is intercultural competence. Intercultural competence gives one the ability to effectively and appropriately communicate with people from other cultures in a competitively complex world. The participant in this program will gain cultural insights needed to build intercultural teams and navigate cultural diversities, without knowingly violating what are deemed to be acceptable or unacceptable cultural norms. What you will Learn At the end of this program, you will be able to: Articulate on the meaning of culture and intercultural competence Express the importance of body language and appropriately demonstrate its emblems Describe three cultural models and consider their application in assimilating cultural behaviors Define emotional intelligence and explain how it is linked to cultural intelligence Examine the four cultural intelligence capabilities and give examples of how each is developed Develop a personal cultural profile and compare its dimensions to gain an appreciation for intercultural competence Foundation Concepts Fundamentals of culture Culture and body language Culture and proxemics Cultural Models Iceberg culture model The onion model of culture Hofstede's model of national cultures High-context and low-context cultures Cultural Intelligence Emotional intelligence overview Cultural intelligence overview Cultural Profile Cultural profile dimensions Understanding your cultural profile

Introduction to Project Management: In-House Training This course provides practical insights into what is project management and how it is performed in a structured manner. This course provides practical insights into what is project management and how it is performed in a structured manner. You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. What you Will Learn You will learn how to: Articulate on the basics of the project management profession Explain project management terms and concepts in practice Speak on how projects originate in mature organizations Employ a disciplined approach to initiating, planning, and managing projects to closure Identify and describe the roles and responsibilities of key project stakeholders Consider standard project processes to implement based upon the PMBOK® Guide Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially Summary and Next Steps Review of goals, objectives, key concepts, and expectations Evaluations

Grateful Leadership: In-House Training Effective leaders must find ways to enhance people's level of engagement, commitment, and support, especially during the difficult periods of time that all organizations may face. Grateful leaders can tap into the power of personal commitment and dedication by acknowledging people in an authentic and heartfelt manner. Those leaders who model true acknowledgment behavior will inspire others to do the same and to want to dramatically increase their levels of contribution to the organization, making the power of acknowledgment transformational. What you will Learn You'll learn how to: Understand and develop the capability to act upon the need for Grateful Leadership to create a culture of appreciation in the workplace Understand the potentially huge benefits of Grateful Leadership in the workplace Overcome the barriers to using acknowledgment Demonstrate the language and subtleties of authentic and heartfelt acknowledgement behavior Describe the Seven Principles of Acknowledgment for 'High-Interest Benefits' in the context of participant's personal leadership style Describe how to coach teams, managers, and other corporate stakeholders in using Grateful Leadership to produce breakthrough results Getting Started Introductions Course goals and objectives Introspection on the practice of Grateful Leadership The Workforce Engagement Sustainability Challenge Employees who are engaged, not engaged, and actively disengaged The costs of non-engagement Meeting the workforce engagement challenge Acknowledgment, Engagement, and Leadership Acknowledgment and its benefits Recognition versus acknowledgment 'Challenging people' case study Blanchard, Covey, Keith (Servant Leadership): how acknowledgment fits into these leadership models Leadership and acknowledgment The 5 C's - Consciousness, Courage, Choice, Communication, Commitment Employing the Power of Acknowledgment Overcoming barriers to acknowledgment The Seven High-Interest Benefits Principles of Acknowledgment Exploring the acknowledgment process Applying the Principles of Acknowledgment within the Context of Your Personal Leadership Style Case study The ROI of Grateful Leadership Creating your Grateful Leadership Personal Action Plan™ Creating a Vision Statement for your organization that incorporates Grateful Leadership into your corporate culture The 360° Grateful Leadership Competency Assessment Summary What did we learn, and how can we implement this in our work environments?

The course price includes Refreshments, Car Parking Fees, Workbooks, Resources including access to our Trainer Resource Pack via the Approved Trainer HUB, Approved Trainer Membership, Approved Trainer T-Shirt, Ongoing Quality Assurance , support and Certification. We deliver this course to small groups a maximum of 4 people attend this course at our training premises ensuring all our learners receive Quality time with the Trainers/ Assessors delivering the course.

This one day training will give learners an overview of how to deliver Cognitive Stimulation Therapy (CST). CST is a brief evidence-based group treatment for people with dementia. This interactive course will include a background about CST and how it can be used, research overview and detailed presentation of the treatment, including video footage and role-play.

We deliver Workplace PAT Testing Courses across most of the UK to assist businesses with Compliance. We also work with Bridges into Work and ReACT in association with Careers Wales and the Welsh Government to offer work based skills which some Candidates could be eligible for Government funding.