46185 AR courses delivered Online

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Level 5 Diploma in Education and Training is regulated by Ofqual and prepares trainee teachers to teach in a wide range of contexts, adult qualifications. Level 5: Diploma in Education and Training DET or DTLLS course is a QCF qualification which is full 120 QCF Credit value. Formerly this course used to called Level 5 Diploma in Teaching in the Life Long Learning (DTLLS) course.

Diploma in Education and Training (DET) qualification is a recognised teaching qualification leads to QTLS status. This is a PGCE equivalent qualification which is full 120 QCF Credit value. Formerly this course used to called Level 5 Diploma in Teaching in the Life Long Learning (DTLLS) course. This course is suitable for trainers, teachers, and tutors who intend to work or already working in further education, university, training centre, college, adult and community learning or work-based training within public, private, community organisations or voluntary sectors.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Course description Figma is an industry leading web-based design tool that allows you to create user interfaces for any screen type or size, collaborate on those designs in real-time and build interactive prototypes suitable for user testing. Figma is a visual design tool so there’s no coding involved. Design is achieved by adding, combining and styling shapes, text and images on a canvas or ‘Frame’.  We run 2 consecutive Figma training days, the second day building on the practical activities from the first.  You can attend just the first day. Attending just the second day is only recommended if you’re already very comfortable with the Figma interface.  Day 1: Basic Figma design and collaboration For beginners with no prior experience with Figma who want to understand the basics, be able to create their own designs, share, collaborate and even iterate on the designs of others. You will learn: How to navigate the Figma interface. How to create your own designs by: Setting up a design file. Setting up the screen type you want to design and add grids and guides. Adding and modifying basic shapes and text to create user interface elements. How to save text and colour styles for reuse. How to create reusable components. How to use the ‘auto layout’ feature to promote tidy, consistent and usable design. How to collaborate on designs by sharing screens and commenting on designs. A brief introduction to prototyping: What’s possible. What’s not. Day 2: Component variants, design systems and prototyping  This session will cover the more sophisticated aspects of Figma use such as: How to use component variants to create: Interaction styles such as hover and mouse down states ‘Flavours’ of a widget such as primary and secondary button styles. Toggleable elements within a widget such as buttons or bullets within a product card. How to turn a collection of components into a basic design system. Prototyping fundamentals: How to make journeys clickable. How to introduce animations. Tips and tricks for effective user testing. The limitations of Figma prototyping Is it for you? With no experience of Figma necessary, this course is suitable if: If you’re involved with creating or curating digital experiences. if you want to turn your design ideas into something tangible. If you work with Figma designers and want to understand the ‘art of the possible’. If you want to collaborate with your team on Figma projects. Learning objectives After completing day 1 you will be able to: Understand the Figma user interface. Create mobile and desktop interface designs. Effectively collaborate remotely. Share designs and gather feedback. Use auto layout to promote consistent and usable designs. Understand Figma’s role in user experience design, and its limitations. After day 2 you will be able to: Understand how design systems are set up and used. Create component variants for use in your own design system. Use that design system to efficiently create a user journey. Create a prototype suitable for user testing.

LOOKING FOR: PICTURE BOOKS, YOUNG FICTION, CHAPTER BOOKS, MG, YA Penny Holroyde has worked in children's publishing for almost 30 years from foreign rights at Walker Books to Rights Director at Candlewick Press in the USA, before becoming an agent specialising in children's books with the Caroline Sheldon Literary Agency. In 2015 Penny co-founded Holroyde Cartey with Claire Cartey, former art director in children's books at Hachette. The agency focuses exclusively on authors and illustrators for the children's book market. Penny has a particular love for picture books but is looking for authors and illustrators working across fiction and non-fiction for all children's ages from pre-school to crossover. She's always looking for humour in picture books and chapter books and heart with some messaging in MG. In YA she's looking for strong character with contemporary settings. She'd also be interested in seeing some horror in YA. Penny is offering 121 sessions for young fiction, middle grade, YA and picture book writers. For chapter books, MG and YA fiction, please submit a covering letter, synopsis and the first three chapters of your manuscript in a single word document. For picture books, please submit a covering letter and two texts formatted in 12 point font in continuous stanzas (and with illustration notes if you wish to include them). Please send EITHER picture books OR another genre, not both in one submission. (In addition to the paid sessions, Penny is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Tuesday 18th February 2025

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

Understand what is meant by the term menopause and why we need to talk about it. Know how menopause can affect someone at work, and how to support colleagues experiencing it.

Identify some of the unique challenges women face in their personal and professional lives, and understand how to support and empower females in the workplace.

Understand what is meant by the term burnout to be able to identify and understand its impact on the individual and the organisation. Learn to utilise practical strategies to prevent and manage burnout.