385 Analyst courses in Fraserburgh delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - Parameter Reports Parameterized Reporting Create Report Parameters Modify Report Parameters Provide Default Parameter Values Provide Available Values for Parameters Lab: Creating Parameterized Reports 2 - List Data Regions Introducing the List Data Region Create Reports Using List Data Regions Modify Reports Which Use List Data Regions Lab: Creating List Reports 3 - Enhancing Reports with Complex Expressions Formatting Reports Top N Reports Running Values Lab: Enhancing Reports with Complex Expressions 4 - Enhance Reports with Images and Subreports Add Images to Reports Retrieve Images from a Database Introducing SSRS (SQL Server Reporting Services) Report Server Add Subreports to Reports Lab: Working With Images and Subreports 5 - Drilldown and Drillthrough Reports Add and Configure Drilldown Reporting Add and Configure Drillthrough Reporting Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - Sparklines, Data Bars, and Indicators Sparklines Data Bars Indicators Lab: Adding Sparklines, Data Bars, and Indicators to Reports Additional course details: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 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.

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

Data Visualization Courses London. In this Power BI Course, you will learn how to translate data trends, summaries, statistics and insights from your data into powerful and inspirational visualizations This course is ideal for managers and data analysts who need to make business decisions based on data.

SAFe® Agile Product Management: Virtual In-House Training Discover and apply the mindset, skills, and tools you need to create successful products and solutions that are desirable, viable, feasible, and sustainable. The Agile Product Management course harnesses the power of Design Thinking to develop innovative solutions with proven SAFe® capabilities to execute on those visions. Learn the right mindset, skills, and tools to create successful products from inception to retirement using Agile techniques. Recognize how Continuous Exploration fuels innovation and helps you define a vision, strategy, and roadmap to tap into new markets. Find out how to accelerate the product life cycle to get fast feedback and quickly deliver exceptional products and solutions that delight customers all while aligning with your organization's strategy, portfolio, evolving architecture, and solution intent. What you will Learn After completing the class, you should be able to: Use Design Thinking to achieve desirable, feasible, and sustainable outcomes Explore market needs, segmentation, sizing, and competitive landscape Manage value stream economics, including pricing and licensing Use empathy to drive design Apply product strategy and vision Develop and evolve roadmaps Execute and deliver value using SAFe® Explore innovation in the value stream Analyzing your Role as a Product Manager in the Lean Enterprise Continuously Exploring Markets and Users Driving Strategy with Market Segmentation Using Empathy to Drive Design Defining Product Strategy and Vision Creating Roadmaps to Build Solutions Delivering Value Managing Value Stream Economics Creating Innovation in the Value Stream

SAFe® Agile Product Management: In-House Training Discover and apply the mindset, skills, and tools you need to create successful products and solutions that are desirable, viable, feasible, and sustainable. The Agile Product Management course harnesses the power of Design Thinking to develop innovative solutions with proven SAFe® capabilities to execute on those visions. Learn the right mindset, skills, and tools to create successful products from inception to retirement using Agile techniques. Recognize how Continuous Exploration fuels innovation and helps you define a vision, strategy, and roadmap to tap into new markets. Find out how to accelerate the product life cycle to get fast feedback and quickly deliver exceptional products and solutions that delight customers all while aligning with your organization's strategy, portfolio, evolving architecture, and solution intent. What you will Learn After completing the class, you should be able to: Use Design Thinking to achieve desirable, feasible, and sustainable outcomes Explore market needs, segmentation, sizing, and competitive landscape Manage value stream economics, including pricing and licensing Use empathy to drive design Apply product strategy and vision Develop and evolve roadmaps Execute and deliver value using SAFe® Explore innovation in the value stream Analyzing your Role as a Product Manager in the Lean Enterprise Continuously Exploring Markets and Users Driving Strategy with Market Segmentation Using Empathy to Drive Design Defining Product Strategy and Vision Creating Roadmaps to Build Solutions Delivering Value Managing Value Stream Economics Creating Innovation in the Value Stream

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report

The main subject areas of the course are: Controlling the health risks of asbestos. Sample handling and waste disposal. Identification of asbestos by PLM. Gravimetric quantification of asbestos-containing materials. Discrimination and quantification of free fibres by dispersion and PCM. Analysis of soils - practical application.

SAFe® Agile Software Engineering: Virtual In-House Training The introduction of Lean-Agile and DevOps principles and practices into software engineering has sparked new skills and approaches that help organizations deliver higher-quality, software-centric solutions faster and more predictably. This workshop-oriented course explores foundational principles and practices and how continuous flow of value delivery and built-in quality are enabled by XP technical practices, Behavioral-Driven Development (BDD), and Test-Driven Development (TDD). Attendees will learn proven practices to detail, model, design, implement, verify, and validate stories in the SAFe® Continuous Delivery Pipeline, as well as the practices that build quality into code and designs. Attendees will also explore how software engineering fits into the larger solution context and understand their role in collaborating on intentional architecture and DevOps. What you will Learn To perform the role of a SAFe® Agile Software Engineer, you should be able to: Define Agile Software Engineering and the underlying values, principles, and practices Apply the Test-First principle to create alignment between tests and requirements Create shared understanding with Behavior-Driven Development (BDD) Communicate with Agile modeling Design from context for testability Build applications with code and design quality Utilize the test infrastructure for automated testing Collaborate on intentional architecture and emergent design Apply Lean-Agile principles to optimize the flow of value Create an Agile Software Engineering plan Introduction to Agile Software Engineering Connecting Principles and Practices to Built-in Quality Accelerating Flow Applying Intentional Architecture Thinking Test-First Discovering Story Details Creating a Shared Understanding with Behavior-Driven Development (BDD) Communicating with Models Building Systems with Code Quality Building Systems with Design Quality Implementing with Quality

This course has been specifically designed to assist professionals applying for Real Estate positions where a Real Estate Financial Modelling test is a requisite part of the interview process.

SAFe® Agile Software Engineering: In-House Training The introduction of Lean-Agile and DevOps principles and practices into software engineering has sparked new skills and approaches that help organizations deliver higher-quality, software-centric solutions faster and more predictably. This workshop-oriented course explores foundational principles and practices and how continuous flow of value delivery and built-in quality are enabled by XP technical practices, Behavioral-Driven Development (BDD), and Test-Driven Development (TDD). Attendees will learn proven practices to detail, model, design, implement, verify, and validate stories in the SAFe® Continuous Delivery Pipeline, as well as the practices that build quality into code and designs. Attendees will also explore how software engineering fits into the larger solution context and understand their role in collaborating on intentional architecture and DevOps. What you will Learn To perform the role of a SAFe® Agile Software Engineer, you should be able to: Define Agile Software Engineering and the underlying values, principles, and practices Apply the Test-First principle to create alignment between tests and requirements Create shared understanding with Behavior-Driven Development (BDD) Communicate with Agile modeling Design from context for testability Build applications with code and design quality Utilize the test infrastructure for automated testing Collaborate on intentional architecture and emergent design Apply Lean-Agile principles to optimize the flow of value Create an Agile Software Engineering plan Introduction to Agile Software Engineering Connecting Principles and Practices to Built-in Quality Accelerating Flow Applying Intentional Architecture Thinking Test-First Discovering Story Details Creating a Shared Understanding with Behavior-Driven Development (BDD) Communicating with Models Building Systems with Code Quality Building Systems with Design Quality Implementing with Quality