1763 Analytics courses in Arbroath delivered Online

OVERVIEW DIAD is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. The course focuses on five practical Labs and at the end of the day, attendees will better understand how to: Connect and transform data from a variety of data sources. Define business rules and KPIs. Explore data with powerful interactive visuals. Build stunning reports. Share their dashboards with their team business partners and publish them to the web. The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course. COURSE BENEFITS: Learn how to clean, transform, and load data from various sources 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 and share report assets to the Power BI Service WHO IS THE COURSE FOR? Data Analysts and Management Consultants with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Analysts looking for a quick introduction to Power BI who don’t have the time for the full three day PL-300 course Marketers in data-intensive organisations who need new tools to build visually appealing, dynamic charts for their stakeholders to use LAB OUTLINE Lab 1 Accessing & Preparing The Data Load data from Excel and CSV sources Manipulate the data to prepare it for reporting Prepare tables in Power Query and load them into the data model Lab 2 Data Modelling And Exploration Create a range of different charts Highlight and cross-filter Create new groups and hierarchies Add new measures to the model Lab 3 Data Visualization Add conditional formatting to a report Add logos to a filter Import a custom visual Apply a custom theme Add bookmarks to the report to tell a story Lab 4 Publishing A Report And Creating A Dashboard Create a Workspace in the Power BI Service Publish a report to the Service Create a Dashboard and pin visuals to it Generate and view insights Lab 5 Collaboration Share a Dashboard Access a Dashboard on a Mobile Device

OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations. After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model. COURSE BENEFITS: Understand the Power BI Desktop data model, its components and most effective schemas Describe concepts of calculated columns and measures Create queries using M Create calculations with DAX Understand the use of functions Create and optimize a data model Understand the consequences of data model design decisions WHO IS THE COURSE FOR? Power BI report developers who wish to improve the structure of their data models Power BI report developers who wish to use advanced features like parameters and M coding in Power Query Power BI practitioners who wish to optimise their models more effectively Attendees wishing to prepare thoroughly for the DAX In A Day course COURSE OUTLINE Module 1 Getting And Shaping The Data Understand what is meant by data model in the context of Power BI Understand the consequences of data model design decisions Understand consequences of Power BI’s data type handling Understand data connection options Module 2 Basic Data Modelling Understand basic data modelling Understand basic data model types Explore dimension tables and fact tables Explore data connections Module 3 Getting Started With M (Power Query Language) Get introduced to M Understand key components and syntax Module 4 Understanding Logic Operators Understand Transformations Understand Join operation Module 5 Introduction To DAX Get introduced to DAX and how can it be used Understand working with parameters and DAX (lab combining the previous module) Module 6 Working With Functions - DAX CALCULATE And More Understand working with functions Understand the basics of the CALCULATE formula Module 7 Modelling With Power BI & DAX Best Practice Gain familiarity with basic data modelling for business scenarios Learn some best practices for working with Power BI

OVERVIEW Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models. During this course you will review: Writing DAX formulas. Defining calculated tables and columns. Defining measures. Using DAX iterator functions. Modifying filter context. Using DAX time intelligence functions. After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns. COURSE BENEFITS: Understand Analytic queries in Power BI Create calculated tables, calculated columns and measures Use DAX functions and operators to build DAX formulas Use DAX iterator functions Create formulas that manipulate the filter context Use DAX time intelligence functions WHO IS THE COURSE FOR? Analysts with experience of Power BI wishing to develop more advanced formulas in DAX Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable LAB OUTLINE Lab 1 Setup Connect to data and understand the objectives of the future labs Lab 2 Write DAX Formulas For Power BI Create a measure Use variables in the measure definition Lab 3 Add Calculated Table And Columns Duplicate a table Create a hierarchy Create a date table Add calculated columns Lab 4 Add Measures To Power BI Desktop Models Add an implicit measure to a report Add an explicit measure Add a compound measure Add a quick measure Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model Complex summarization Higher grain summarization Create ranking measure Lab 6 Modify DAX Filter Context In Power BI Desktop Models Apply Boolean expression filter Remove filters: use ALL Remove filters: use AllSelected Preserve filters: use KeepFilters HASONEVALUE ISINSCOPE Context transition Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models TOTALYTD SAMEPERIODLASTYEAR Calculate new occurrences Snapshot calculations

In this advanced masterclass, you will master the art of copywriting, learn how to promote your service or product on social media and monitor audience engagement with advanced analytical tools. You will also explore the different types of marketing, from email marketing to YoutTube video marketing.  We will train you step-by-step on how to create ads on Facebook, make promotional videos, use keywords effectively in your content using fundamental SEO techniques, and much more. Enrol online today and kickstart an exciting career in this diverse and evolving industry.  Learning Objectives: Master essential blogging, copywriting and SEO skills Gain a solid understanding of social media marketing, tools and platforms Learn how to create effective promotional videos on YouTube Understand how Google AdWords is used to drive traffic to a website Develop your knowledge of brand-building and website structure Utilise email marketing tools for promotional campaigns and offers Follow our step-by-step guide on how to use Google Analytics Who is this Course for? This Digital Marketing Advanced Diploma Level 5 is suited to those who already have prior experience or adequate knowledge of this field and want to reach the next level in their career. If you wish to boost sales as a business owner or improve your proficiency in the workplace, this course offers practical and in-depth training in all areas of digital marketing. There are no entry requirements for this course; however, this class will be particularly beneficial for those who have a solid understanding of how online marketing works. Entry Requirement: This course is available to all learners, of all academic backgrounds. Good understanding of English language, numeracy and ICT are required to attend this course. Endorsement This course has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Certificate of Achievement Endorsed Certificate of Achievement At the successful completion of the course, the learners can order an endorsed certificate by paying the fee of £108. There is an additional £10 postal charge for international students. Certificate of Completion from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path An endorsed certificate of achievement in digital marketing will allow you to explore opportunities in the following roles: Digital Marketing Executive Digital Marketing Analyst Search Marketing Manager Head of Digital Marketing SEO Marketing Specialist PPC & Paid Social Executive Social Media Executive

Duration 5 Days 30 CPD hours This course is intended for Horizon Cloud Service on Microsoft Azure administrators, system integrators, account managers, solutions architects, solutions engineers, sales engineers, and consultants. Overview By the end of the course, you should be able to meet the following objectives: Describe the architecture of Horizon Cloud Service on Microsoft Azure Discuss the initial Microsoft Azure configurations required for the Horizon Cloud Service on Microsoft Azure deployment Discuss Horizon Cloud Service on Microsoft Azure networking concepts Discuss Horizon Cloud Service on Microsoft Azure AD requirements and integration best practices Determine steps and requirements to deploy or upgrade Horizon Cloud Service on Microsoft Azure Recognize Horizon Cloud Service console controls that are available for administrators Identify Horizon Cloud upgrade features and benefits List the steps and considerations to take when setting up a primary VM to be used as an assignable image Identify how to access desktops and application from Horizon Cloud Service on Microsoft Azure Discuss and create Remote Desktop Session Host Farms Explain power management options in the RDSH farm Create VDI desktop assignments and entitlements Manage assignable images on Horizon Cloud Service on Microsoft Azure Describe and Use Image management service for Horizon Cloud Service on Microsoft Azure Describe the integration of Dynamic Environment Manger with Horizon Cloud Service on Microsoft Azure Manage user personalization and application configurations using the Dynamic Environment Manager management console and application profiler Discuss the usage of App Volumes for Horizon Cloud Service on Microsoft Azure Discuss the integration of Workspace ONE Access with Horizon Cloud Service on Microsoft Azure Interpret scalability considerations for Horizon Cloud Service on Microsoft Azure Determine the process of deploying, configuring, and paring Horizon Cloud Connector into your pod's environment Apply troubleshooting techniques relevant to Horizon Cloud Service and Microsoft Azure Summarize the analytics and monitoring capabilities in Horizon Cloud Service on Microsoft Azure This five-day, hands-on training provides you with the knowledge, skills, and abilities to achieve competence in deploying and managing VMware Horizon© Cloud Service? on Microsoft Azure. This training increases your skills and competence in using the VMware Horizon© Cloud Administration Console and Microsoft Azure portal.Through a combination of hands-on labs and interactive lectures, you learn how to import and manage images for VDI and RDSH assignments. You also learn how to configure and use the Universal Broker function, VMware App Volumes?, Workspace ONE Access and VMware Dynamic Environment Manager? in the Horizon Cloud Service on Microsoft Azure deployment. Course Introduction Introduction and course logistics Course objectives Introduction to Horizon Cloud Service on Microsoft Azure Identify Horizon Cloud Service on Microsoft Azure features, benefits, and licensing options Interpret Horizon Cloud Service on Microsoft Azure architecture components to identify configuration prerequisite Interpret Horizon Cloud Service on Microsoft Azure deployment models Discuss the initial Microsoft Azure configurations required for the Horizon Cloud Service on Microsoft Azure deployment Microsoft Azure Networking Requirements Summarize Horizon Cloud connectivity considerations and tasks Discuss Horizon Cloud on Microsoft Azure networking concepts Identify ports required for local connections, remote connections, and endpoint operating system firewall rules Active Directory List the features and limitations of supported AD configurations Discuss Horizon Cloud Service on Microsoft Azure AD integration best practices Determine Horizon Cloud Service on Microsoft Azure AD requirements Deployment and Upgrades Determine steps and requirements to deploy Horizon Cloud Service on Microsoft Azure Discuss the features and benefits of using multiple tenant subnets for desktops and RDSH Discuss the features and benefits of using Internal and External UAG Recognize Horizon Cloud Service console controls that are available for administrators Identify Horizon Cloud upgrade features and benefits Creating Images Outline the process and choices to set up primary VMs Identify the configuration choices for importing primary VMs List steps to install the user software on the primary VM Identify steps to convert a configured primary VM to an assignable image Access Desktops and Applications Use Horizon Client to access desktops and remote applications Compare the remote display protocols that are available for Horizon Cloud Remote Desktop Session Host Farms List the steps and considerations to take when creating an RDSH farm List the actions that can be performed on farms listed on the console?s Farms page List the actions to assign an application to a user or group List the prerequisites and steps to create an RDSH session assignment VDI Desktops Compare a dedicated assignment to floating assignment Outline steps to create a VDI desktop assignment Explain the entitlement of desktops Managing Assignable Images Describe and manage assignable images Describe and Use Image management service for Horizon Cloud Service on Microsoft Azure VMware Dynamic Environment Manager Identify the VMware Dynamic Environment Manager functional areas and their benefits Prepare an infrastructure for VMware Dynamic Environment Manager Outline the steps that are required to install and configure Dynamic Environment Manager components Manage user personalization and application configurations using the Dynamic Environment Manager management console and application profiler App Volumes for Horizon Cloud Service on Microsoft Azure Explain how App Volumes works with Horizon Cloud Service on Microsoft Azure Identify the features and benefits of App Volumes in Horizon Cloud Service on Microsoft Azure Identify the interface elements of App Volumes in Horizon Cloud Service on Microsoft Azure Install and configure App Volumes in Horizon Cloud Service on Microsoft Azure Workspace ONE Access Describe the benefits of integrating VMware Horizon Cloud service with Workspace ONE Access. Describe how a user obtains access to an entitled virtual desktop or application from the Intelligent Hub catalog. Describe the importance of binding directory with Workspace ONE Access and setting up custom user attribute synchronization. Describe the importance of configuring the Remote App Access Client in Workspace ONE Access. Summarize the steps of configuring the Access settings in Horizon Cloud control panel. Access an entitled Horizon virtual desktop or application in the Intelligent Hub catalog. Scalability Considerations Discuss the Horizon Cloud Service on Microsoft Azure scalability cost and settings Describe the usage of Universal Broker in Horizon Cloud Service on Microsoft Azure Horizon Cloud Connector Describe the features and benefits of Horizon Cloud Connector List the prerequisites and requirements to connect a Horizon pod with Horizon Cloud Connector Determine the process of deploying, configuring, and paring Horizon Cloud Connector into your pod?s environment Troubleshooting Horizon Cloud Service on Microsoft Azure Discuss Horizon Cloud Service on Microsoft Azure troubleshooting basics Discuss Horizon Cloud Service troubleshooting basics Summarize the analytics and monitoring capabilities in Horizon Cloud Service on Microsoft Azure

Expand your Excel knowledge and learn how to structure and analyse large data sets.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Business Process Modeling: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP®). Learn more at www.iil.com/bacp A process model is a description of a process in terms of its steps or actions, the data flowing between them and participants in the process, machines, systems, and organizations involved. Modeling is a critical business analysis skill. It applies graphical and text communication techniques to describe the actions, objects, and relationships acted upon in the process and the steps that act upon them. This course teaches the technique of process modeling and ties together the core methods of process, behavior, and data modeling to enable business analysts to fully describe business processes in levels of detail from multiple perspectives. What you will Learn Upon completion, participants will be able to: Identify business processes and their components Work with UML diagrams Use process modeling in business diagramming Diagram and model business processes Foundation Concepts The role of the business analyst The IIBA® BABOK® Knowledge Areas Business Process Modeling (BPM) and the business analyst A practical approach to business process modeling The Context for Modeling Business Processes Overview of context for business process modeling Analyzing stakeholder information Modeling best practices Critical inputs for BPM: Business Rules Critical inputs for BPM: Context Diagrams Data Models Overview of data modeling Entity relationship diagrams Object-oriented approach Class diagrams Other data models Process Models - Part I (Non-UML) Overview of process modeling Data flow diagrams Workflow diagrams Flowcharts Process Models - Part II (UML) Overview of UML Process Models UML Activity Diagrams UML Sequence Diagrams Usage Models - Part I (Non-UML) Overview of usage modeling Prototyping options Static prototyping and storyboards Dynamic prototyping User Interface Design and user stories Usage Models - Part II (UML Use Cases) Overview of Use Cases Use Case diagrams Use Case descriptions Use Cases and the product life cycle Integrating the Models Overview of integrating the models General analysis best practices Specific analysis techniques summary Best practices for transition to design Summary and Next Steps What did we learn and how can we implement this in our work environments?

Course Overview: Social Housing Management Introduction: Social Housing Management is a comprehensive course designed to equip participants with the knowledge and skills necessary to effectively manage and administer social housing programs. With a focus on history, challenges, strategies, and best practices, this course provides valuable insights into the complexities of social housing management. Module 1: History of Social Housing This module delves into the historical evolution of social housing, tracing its origins and development over time. Participants will explore key milestones, legislative frameworks, and societal factors that have shaped the landscape of social housing. Module 2: Current Challenges and Future Developments in Social Housing Participants will examine contemporary challenges facing social housing providers, including affordability, accessibility, and sustainability. Additionally, this module explores emerging trends and future developments in social housing policy and practice. Module 3: Strategies and Best Practices for Social Housing Providers This module focuses on effective strategies and best practices for social housing providers to optimize service delivery and meet the diverse needs of tenants. Topics covered include tenant engagement, community development, and partnership building. Module 4: The Role of Technology in Social Housing Technology plays a crucial role in modernizing social housing operations and improving efficiency. This module explores the use of technology platforms, data analytics, and smart systems to enhance tenant services, asset management, and operational processes. Module 5: Financing and Funding for Social Housing Understanding financing and funding mechanisms is essential for sustaining social housing initiatives. Participants will learn about various funding sources, financial models, and investment strategies to support the development and maintenance of social housing projects. Module 6: Managing and Maintaining Social Housing Effective management and maintenance are essential for ensuring the long-term viability of social housing properties. This module covers property management principles, maintenance planning, and regulatory compliance to uphold quality standards and ensure tenant satisfaction. Module 7: Understanding the Essence of Social Housing In this concluding module, participants will reflect on the fundamental principles and values underpinning social housing. By examining the essence of social housing, participants will gain a deeper understanding of its importance in promoting social equity, inclusion, and housing justice. Conclusion: Social Housing Management offers a holistic perspective on the multifaceted nature of social housing, equipping participants with the knowledge and tools to navigate the challenges and opportunities in this critical field. Whether you're a housing professional, policymaker, or advocate, this course provides valuable insights and practical strategies for advancing social housing initiatives and improving housing outcomes for all. Course Curriculum Module 1_ History of Social Housing History of Social Housing 00:00 Module 2_ Current Challenges and Future Developments in Social Housing Current Challenges and Future Developments in Social Housing 00:00 Module 3_ Strategies and Best Practices for Social Housing Providers Strategies and Best Practices for Social Housing Providers 00:00 Module 4_ The Role of Technology in Social Housing The Role of Technology in Social Housing 00:00 Module 5_ Financing and Funding for Social Housing Financing and Funding for Social Housing 00:00 Module 6_ Managing and Maintaining Social Housing Managing and Maintaining Social Housing 00:00 Module 7_ Understanding the Essence of Social Housing Module 7_ Understanding the Essence of Social Housing 00:00

The Tableau Training on Tap (TToT™️) Level Up course takes intermediate Tableau users to being advanced users through lessons, tips and tricks and hands on exercises.