491 Intelligence courses in London delivered Live Online

OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports, as well as best practices for authoring great reports and dashboards for business users. The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course. COURSE BENEFITS: Understand the need for storytelling with data Understand the agile process to creating Power BI data visualizations Understand the art behind visualizations Gain familiarity with Power BI report layouts and structure Understand implications behind choosing the right charts Gain familiarity with using Power BI custom visuals WHO IS THE COURSE FOR? Power BI report developers who wish to improve the aesthetic quality of their reports Power BI and other BI practitioners who would like to understand more about the theory of data visualization BI practitioners who wish to create reports that communicate the meaning behind the data more clearly Power BI users who would like to explore the types of chart and visual available that answer different types of business question COURSE OUTLINE Module 1 What Is Storytelling With Data? Volume, Velocity and Variety The importance of business questions What is a story in this context? Module 2 The Science Behind Data Visualization Basic problems to avoid Memory and visualization Ways to spark iconic, short-term and long-term memory Module 3 The Process Behind Data Visualization Using an agile approach to report development Data structure and data grain Converting the story to a data model Module 4 Dashboards And Reports Terminology and definitions Dashboard layout and structure Report layout and structure Storyboarding Drill-through, bookmarks, toggles and tooltips Module 5 Chart Selection Charts for comparison Time series Proportions Constructing effective tables, cards and slicers Scatterplots Module 6 Accessibility And Custom Visuals Report accessibility checklists Custom visuals Creating a custom R visual Charticulator Module 7 Publishing And Formatting Colour schemes Making a Power BI theme Use of fonts, icons and symbols Sizing dashboard and report tiles Sparklines, hyperlinks and images Module 8 Report Authoring - Best Practices Design thought process The audience Defining the platform environment The user experience Visualization Implementation and testing Optimization Module 9 Dashboard And Goals Design Tips and tricks Best practices for dashboard design Tracking business metrics with goals

Duration 1 Days 6 CPD hours This course is intended for A Dynamics 365 Customer Engagement Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications. The Functional Consultant implements a solution using out of the box capabilities, codeless extensibility, application and service integrations. Overview After completing this course, you will be able to: Install and configure the application Identify common sales scenarios Complete a sales cycle Configure product catalog Manage customer records Utilize analytics tools with customer data Microsoft Dynamics 365 for Sales is an end-to-end application to manage the handling of customers and potential customers; tracking data against sales goals, automating your best practices, learning from your data and more. Sales Overview Sales overview Configuring Sales Module summary Working with Opportunities Manage customers Working with opportunities Embedded intelligence Playbooks Integrated sales tools Module summary Quotes to Orders Order processing overview Manage product catalog Create and manage quotes Create and manage orders and invoices Module summary Sales Analytics and Insights Overview Power BI AI for Sales Modules summary Additional course details: Nexus Humans MB-210T01 Dynamics 365 for Customer Engagement for Sales training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MB-210T01 Dynamics 365 for Customer Engagement for Sales course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for Anyone starting to write SAS programs Overview Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs. Access SAS, Microsoft Excel, and text data. Explore and validate data. Prepare data by subsetting rows and computing new columns. Analyze and report on data. Export data and results to Excel, PDF, and other formats. Use SQL in SAS to query and join tables. This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. Essentials The SAS programming process. Using SAS programming tools. Understanding SAS syntax. Accessing Data Understanding SAS data. Accessing data through libraries. Importing data into SAS. Exploring and Validating Data Exploring data. Filtering rows. Formatting columns. Sorting data and removing duplicates. Preparing Data Reading and filtering data. Computing new columns. Conditional processing. Analyzing and Reporting on Data Enhancing reports with titles, footnotes, and labels. Creating frequency reports. Creating summary statistics reports. Exporting Results Exporting data. Exporting reports. Using SQL in SAS Using Structured Query Language in SAS. Joining tables using SQL in SAS. Additional course details: Nexus Humans SAS Programming 1 - Essentials training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the SAS Programming 1 - Essentials course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This is an introductory-level course designed to teach experienced systems administrators how to install, maintain, monitor, troubleshoot, optimize, and secure Hadoop. Previous Hadoop experience is not required. Overview Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will learn to: Understand the benefits of distributed computing Understand the Hadoop architecture (including HDFS and MapReduce) Define administrator participation in Big Data projects Plan, implement, and maintain Hadoop clusters Deploy and maintain additional Big Data tools (Pig, Hive, Flume, etc.) Plan, deploy and maintain HBase on a Hadoop cluster Monitor and maintain hundreds of servers Pinpoint performance bottlenecks and fix them Apache Hadoop is an open source framework for creating reliable and distributable compute clusters. Hadoop provides an excellent platform (with other related frameworks) to process large unstructured or semi-structured data sets from multiple sources to dissect, classify, learn from and make suggestions for business analytics, decision support, and other advanced forms of machine intelligence. This is an introductory-level, hands-on lab-intensive course geared for the administrator (new to Hadoop) who is charged with maintaining a Hadoop cluster and its related components. You will learn how to install, maintain, monitor, troubleshoot, optimize, and secure Hadoop. Introduction Hadoop history and concepts Ecosystem Distributions High level architecture Hadoop myths Hadoop challenges (hardware / software) Planning and installation Selecting software and Hadoop distributions Sizing the cluster and planning for growth Selecting hardware and network Rack topology Installation Multi-tenancy Directory structure and logs Benchmarking HDFS operations Concepts (horizontal scaling, replication, data locality, rack awareness) Nodes and daemons (NameNode, Secondary NameNode, HA Standby NameNode, DataNode) Health monitoring Command-line and browser-based administration Adding storage and replacing defective drives MapReduce operations Parallel computing before MapReduce: compare HPC versus Hadoop administration MapReduce cluster loads Nodes and Daemons (JobTracker, TaskTracker) MapReduce UI walk through MapReduce configuration Job config Job schedulers Administrator view of MapReduce best practices Optimizing MapReduce Fool proofing MR: what to tell your programmers YARN: architecture and use Advanced topics Hardware monitoring System software monitoring Hadoop cluster monitoring Adding and removing servers and upgrading Hadoop Backup, recovery, and business continuity planning Cluster configuration tweaks Hardware maintenance schedule Oozie scheduling for administrators Securing your cluster with Kerberos The future of Hadoop

Learn advanced concepts in DAX, Data Modeling, Power BI architectural design, and more.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Cisco Unified Communications system channel partners and resellers who are responsible for deployment and application engineering for Cisco Unified Contact Center Express customers, System and technical support engineers, Day 1 and Day 2 support personnel, and Customers deploying and maintaining Cisco Unified CCX Overview Upon successful completion of this course, students will be able to create utilize advanced techniques in scripting and Cisco Unified CCX functionality The student will explore advanced techniques in scripting and Cisco Unified CCX functionality. During this five day class students will use advanced scripting to implement features that extend the functionality of Cisco Unified CCX. Cisco Unified CCX Overview Components of the Cisco Unified CCX Environment. Gateways. Routers. Cisco Unified Communications Manager. Cisco Unified CCX. Script Editor. Cisco Finesse. Cisco Unified Intelligence Center. Cisco Unified CCX Agent. External Servers. Cisco Unified CCX System Cluster Components. Engine. Database Server. Call Flow Terms. The Call Flow. The Debug Process Reactive. Non-Reactive Prompt Recording Utilities Prompt Recorder Emergency Message Recorder Basic ACD Routing Review Script Steps used in a Simple ACD Routing Script. Resource Group Routing. Defining the Contact Service Queue. Create a Simple ACD routing script Common Scripting Concepts Prompt Management. Using the Default Script. Terminating a Call and Ending a Script. Abandon Rates. Exception Handling. Script Interruptions. Check Agent Availability before and after entering queue. Using Java Methods for Holiday and Time of Day routing Accessing an External Database Database architecture and supported databases. Setting up the Database Subsystem. Using Database script steps Skills Based Routing Appling skills to agents. Defining the Contact Service Queue. Specifying the CSQ in the Script Advanced ACD Routing Overflow Routing. When to Overflow. How to get the Data Needed for Making Decisions. Describe Methods of Overflowing Basic ACD Callback Options Setup the Email Subsystem. Script for Email Notification. Script for Leaving a Recorded Message. Script for Callback when Queue Times have Decreased Enterprise Data and Session Management Define Enterprise Data in Cisco Finesse. Define a Call Variable Layout in Cisco Finesse. Define ECC Variables in the script editor. Set Enterprise Data in the script. Define Session Management. Setup Session Management. Use Session Management to Pass Variable Information Between Scripts Advanced ACD Callback Options Leave Queued Message with an Option for Callback. Scheduled Callback

In today's fast-changing competitive environment, people in all roles need to have more commercial awareness and responsibility.

The insights gained from data analysis are only truly valuable when you can be clearly expressed to other people – bosses, colleagues, clients, customers, or other stakeholders. In this workshop you’ll learn how to turn raw qualitative or quantitative data into a clear visual story through infographics and data visualization. We'll discuss the key principles for planning an effective visual, look at examples of best (and worst) practice, and learn repeatable and practical design techniques for enhancing the story. We'll also give you an overview of useful tools that will help you turn your idea into a finished infographic or data visualization. You could be conjuring up eye-catching slide decks, building effective reports and dashboards, pitching to investors, or presenting persuasive data to your most important customers.  This is a fully interactive online workshop, so be prepared to join discussions and get hands on with building your own visualisations.  Takeaways Be able to evaluate the elements that make an infographic or visualization effective. Learn quick and repeatable visual tricks for ensuring infographics convey a clear message. Understand how to tailor your approach to different audiences and context. Discover a bunch of free tools and resources to help you build your own visualizations. Understand how online, interactive visualizations work and how to create them. Delivery  We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets.
 Testimonials "Just to say what a great course this was. I have made my first report employing some of the ideas and tools you showed us – to rapturous responses! The next actions are clear for all and they all understood it! Thank you for helping me to organise my data and thoughts, showing how to present the key message up front, and how to keep it simple and focused. Gearing up for another report now!" Kay Anderson | Head of Finance | Mima "We have been using Tableau to display data for some time but knew we could do more to engage our end users. Alan’s training gave us a framework to start thinking about what we wanted to achieve with our visualisations and analysis, and some great tips on how to display information for maximum impact. Alan was an engaging trainer and we found the workshops very energising." Ellen Austin | Senior Data Analyst | London School of Economics

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

Are you looking to enter the dynamic world of real estate? Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics. At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector. On this course, you will… Become familiar with the players, structure, general terminology and overall needs of Real Estate. Learn what is Real Estate and why it is different from other asset classes Get to grips with the overall size and structure of the UK Real Estate Market Learn and analyse the links between the different parts of the property market Understand who works in the Real Estate Market, their qualifications and their job descriptions Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc… Learn how to read a real estate market report Understand how current affairs, politics and economics affects Real Estate Investment Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector Who will benefit from this course: Graduates or undergraduates studying economics, finance. Professionals working in Marketing or Accounting teams within Real Estate firms. APC students. Anyone interested in Real Estate. School leavers/A-Level Students looking to gain an understanding of Real Estate. Non cognate students who wish to transfer into Real Estate/Finance careers. Course Outline Module 1: What is and why buy Real Estate? The property Market The Size and Structure of the UK property market The impact of Real Estate in the Economy Module 2: The Real Estate Market System The Space Market The Asset Market The Development Market Module 3: How to value Real Estate An Introduction to Financial Mathematics The difference between Price, Value and Worth Property Yield Conventional Valuation Methods Module 4: How to read a Real Estate Market Report Property Market Indicators: Stock Indicators Property Market Indicators: Investment Indicators Module 5: Who works in Real Estate? The build Environment by Cobalt Recruitment Rea; Estate Agents Examples of Real Estate Market Agents CVs Real Estate Network