1892 Courses delivered 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.

Duration 2 Days 12 CPD hours This course is intended for This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps. Overview After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business. 1 - AN INTRODUCTION TO POWERAPPS What is PowerApps? The benefits of apps How to get PowerApps Canvas Apps and Model-Driven Apps License Options and Costs Discover PowerApps with Templates Lab 1: Introduction to PowerApps 2 - GETTING STARTED WITH POWERAPPS Building a new app from a data source Add, edit and remove controls Intro to Formulas Testing an app App Settings Publish and Share Apps Version History and Restore PowerApps Mobile App Lab 1: Getting Started 3 - BRANDING AND MEDIA Less is more Duplicate Screens Fonts Screen Colours and Matching Colours Screen Backgrounds Buttons and Icons Hide on Timer Size and Alignment by reference Show and Hide on Timer Lab 1: Branding and Media 4 - POWERAPPS CONTROLS Text Controls for Data Entry and Display Controls ? Drop downs, combo box, date picker, radio button and more Forms ? Add and edit data in underlying data sources quickly Charts ? present information in pie, line and bar charts Lab 1: Build Apps from Blank 5 - DATA SOURCES AND LOGIC Data Storage and Services How do I decide which database to use? Connect to on-premises data - Gateway What is Delegation? Specific Data Examples Displaying Data Lab 1: Data Source and Logic 6 - MODEL-DRIVEN APPS What is a model-driven app? Where will my data be stored? How do create a model-driven app Canvas vs model-driven summary Lab 1: Model-Driven App 7 - POWERAPP INTEGRATION Embed PowerApps in Teams Embed PowerApps in SharePoint Online Start a Flow from a PowerApp Lab 1: PowerApp Integration 8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS Identify which users have been using PowerApps Reuse an app in another location (move from testing or development to production) Review app usage Prevent a user from using PowerApps Manage environments Lab 1: Administration and Maintenance Additional course details: Nexus Humans 55265 Microsoft PowerApps 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 55265 Microsoft PowerApps 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.

Strengthen your marriage with professional marriage counselling in London. Our experienced counsellors help couples navigate marital issues such as communication problems, intimacy concerns, and trust issues. Through tailored therapy sessions, we aim to foster a healthy, loving relationship that can withstand life's pressures and challenges. Key areas: couples therapy, relationship counselling, marital therapy, marriage support, relationship advice, marriage guidance, partnership counselling. 3 x 1 hour sessions 

Improve your relationship with dedicated couple counselling in London. Our therapists offer tailored sessions to address specific issues, enhance communication, and foster mutual understanding between partners. Whether you're facing daily conflicts or significant relationship challenges, our supportive counselling can help you rebuild and strengthen your connection. Key areas: relationship therapy, couples counselling, partnership counselling, relationship support, therapy for couples, couples guidance, relationship enhancement. 3 x 1 hour sessions 

Overcome depression with professional counselling in London. Our expert therapists provide compassionate support and effective strategies to manage and alleviate depressive symptoms. Through personalized therapy sessions, we aim to help you regain control of your life, improve your mental health, and achieve a sense of well-being and happiness. Key areas: depression therapy, mental health counselling, depression support, therapy for depression, depression treatment, emotional support, mental wellness. 3 x 1 hour sessions

Reconnect and resolve conflicts with expert couples counselling in London. Our skilled therapists provide a safe and supportive space for partners to communicate effectively, address underlying issues, and improve their relationship. Whether you're dealing with infidelity, communication breakdowns, or other challenges, our tailored approach can help you build a stronger and more loving partnership. Key areas: relationship counselling, marriage counselling, couples therapy, partnership therapy, conflict resolution, relationship support, communication therapy. 3 x 1 hour sessions 

Access confidential and personalized private counselling in London. Our experienced therapists provide one-on-one sessions to address your unique mental health needs, including anxiety, depression, stress, and more. With a focus on privacy and individualized care, our therapy services aim to support your journey towards mental well-being and personal growth. Key areas: confidential therapy, one-on-one counselling, private therapy, individual counselling, personal therapy sessions, private mental health support, discreet counselling. 3 x 1 hour sessions

Navigate your grief with expert bereavement counselling in London. Our caring therapists offer support and guidance to help you cope with the loss of a loved one, providing a safe space to process your emotions and begin healing. With a focus on empathetic care and personalized strategies, we aim to support you through every stage of your bereavement journey. Key areas: grief counselling, loss therapy, mourning support, bereavement therapy, emotional support, grief support, loss counselling. 3 x 1 hour sessions 

Description: Find solace and support with grief counselling in London. Our compassionate therapists help you navigate the grieving process, offering a safe space to express your emotions and begin healing after a loss. With personalized strategies and empathetic care, we aim to support you through every stage of grief and help you find a path towards emotional recovery. Key areas: bereavement counselling, loss support, grief therapy, mourning support, emotional healing, grief support, bereavement therapy. 3 x 1 hour sessions

Manage and reduce anxiety with professional counselling in London. Our experienced therapists provide tailored strategies and support to help you cope with anxiety, reduce stress, and live a more peaceful life. With a focus on personalized care and effective techniques, our counselling services aim to help you achieve long-term mental well-being and resilience. Key areas: anxiety therapy, stress counselling, anxiety support, therapy for anxiety, anxiety management, stress management, mental health support. 3 x 1 hour sessions