Course #:55005 Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 Training 04/12/2021 - 04/13/2021 USD$1,575.00 Instructor Led Virtual 04/26/2021 - 04/27/2021 USD$1,575.00 Instructor Led Virtual 06/14/2021 - 06/15/2021 USD$1,575.00 Instructor Led Virtual 06/28/2021 - 06/29/2021 USD$1,575.00 Instructor Led Virtual 07/06/2021 - 07/07/2021 USD$1,575.00 Instructor Led Virtual 08/09/2021 - 08/10/2021 USD$1,575.00 Instructor Led Virtual This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release. The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options. What you will Learn After completing this course, students will be able to: Plan the reports. Use Report Builder 3.0 and understand the parts of the interface. Launch Report Builder 3.0 from multiple sources. Understand management options. Create embedded data sources and datasets. Create shared data sources and datasets. Create shared data sources and datasets. Understand and utilize the Table or Matrix Wizard. Understand and utilize the Chart Wizard. Understand and utilize the Map Wizard. Understand and utilize lists. Understand and utilize tables. Understand and utilize matrices. Understand and utilize data regions. Understand and utilize parameters. Understand and utilize expressions. Understand and utilize report parts. Understand and utilize formatting options. Understand visualization options. Understand and utilize charts. Understand and utilize sparklines. Understand and utilize gauges. Understand and utilize maps. Understand filtering, grouping, and sorting. Understand and utilize dynamic headers and footers. Understand and utilize report templates. Understand and utilize HTML and texboxes. Understand and utilize lists as containers. Understand and utilize subreports. Understand report subscription options. Understand security.. Prerequisites A basic understanding of relational databases. Audience This course is intended for power users, developers, and IT professionals that will be involved with the design, development, and maintenance of reports created with Report Builder 3.0. Duration 2 days Outline of Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 Training Module 1: Course Overview This module explains how the class will be structured and introduces course materials and additional administrative information.Lessons Introduction Course Materials Facilities Prerequisites What We'll Be Discussing Lab : Course Overview Successfully log into their virtual machine. Have a full understanding of what the course intends to cover. Module 2: Introduction to Report Builder 3.0 This module introduces the interface of Report Builder 3.0, the different features available, and variances in data sources and datasets.Lessons Planning Your Reports Understanding Variances Between SQL Versions Exploring The Report Builder 3.0 Interface Examining Management Utilizing Data Sources Working with Datasets Lab : Introduction to Report Builder 3.0 Explore the Report Builder 3.0 Interface Create an Embedded Data Source into SQL 2014 Engine Create an Embedded Data Source into SQL 2014 Analysis Services Create a Shared Data Source Using the Report Manager Create a Shared Dataset Using the Shared Data Source Plan the reports. Use Report Builder 3.0 and understand the parts of the interface. Launch Report Builder 3.0 from multiple sources. Understand management options. Create embedded data sources and datasets. Create shared data sources and datasets. Module 3: Report Builder 3.0 Wizards This module covers report basics exploring lists, matrices, and tables along with the wizards. Data regions will also be explained.Lessons Exploring Table or Matrix Wizard Utilizing Chart Wizard Working with Map Wizard Lab : Report Builder 3.0 Wizards Create Five Shared Data Sources and Two Shared Datasets Use the Table or Matrix Wizard Use the Chart Wizard Use the Map Wizard Create shared data sources and datasets. Understand and utilize the Table or Matrix Wizard. Understand and utilize the Chart Wizard. Understand and utilize the Map Wizard. Module 4: Report Builder 3.0 Basic Reports In this module we examine parameters, filters, and the expressionable aspect of reports. We also cover formatting options.Lessons Utilizing Lists Using Tables Exploring Matrix Mastering Data Region(s) Examining Parameters Working with Expressions Understanding Report Parts Formatting Reports Lab : Report Builder 3.0 Basic Reports Creating a Report Using Lists Creating a Report Using Tables Creating a Report Using a Tablix Creating a Report with a Query Parameter Report Parameter with a Shared Dataset Create Parameters Using a Dataset as a Filter Using Expressions in Your Report Creating a Report Using Report Parts Report Formatting Understand and utilize lists. Understand and utilize tables. Understand and utilize matrices. Understand and utilize data regions. Understand and utilize parameters. Understand and utilize expressions. Understand and utilize report parts. Understand and utilize formatting options. Module 5: Report Builder 3.0 Graphics This module is a detailed look at graphics including charts, images, sparklines, data bars, gauges, and Bing maps.Lessons Understanding Visualizations Utilizing Charts Exploring Gauges Examining Maps Lab : Report Builder 3.0 Graphics Using Sparklines in a Report Report Builder Chart Borders, Titles, and Legends Linear Gauges Basic Maps Basic Maps with Color Understand visualization options. Understand and utilize charts. Understand and utilize sparklines. Understand and utilize gauges. Understand and utilize maps. Module 6: Intermediate Reporting This module covers intermediate reporting with emphasis on actionable reports, and a section exploring report subscriptions and security.Lessons Filtering, Grouping, and Sorting Utilizing Dynamic Headers and Footers Visualizing Your Company Report Templates Understanding HTML5 and Textboxes Using the List Object to Combine Other Items Creating Subreports and Drillthrough Reports Exploring Subscriptions Examining Security Lab : Intermediate Reporting Report Header and Footer Creating Report Templates Embedding HTML in a Textbox Lists as Containers Subreports Understand filtering, grouping, and sorting. Understand and utilize dynamic headers and footers. Understand and utilize report templates. Understand and utilize HTML and texboxes. Understand and utilize lists as containers. Understand and utilize subreports. Understand report subscription options. Understand security. Module 7: Report Builder 3.0 Tips and Tricks This module is optional and contains 20 tips and tricks with step-by-step instructions. Lessons Lab : Report Builder 3.0 Tips and Tricks Use what they’ve learned throughout this course. We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC. View Course Outline Share This Request On-Site or Customized Course Info REGISTER FOR A COURSEWARE SAMPLE x Sent First Name Last Name Email Request On-Site or Customized Course Info x Sent First Name Last Name Phone Number Company Name Email Question
Course #:55005 Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 Training 04/12/2021 - 04/13/2021 USD$1,575.00 Instructor Led Virtual 04/26/2021 - 04/27/2021 USD$1,575.00 Instructor Led Virtual 06/14/2021 - 06/15/2021 USD$1,575.00 Instructor Led Virtual 06/28/2021 - 06/29/2021 USD$1,575.00 Instructor Led Virtual 07/06/2021 - 07/07/2021 USD$1,575.00 Instructor Led Virtual 08/09/2021 - 08/10/2021 USD$1,575.00 Instructor Led Virtual This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release. The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options. What you will Learn After completing this course, students will be able to: Plan the reports. Use Report Builder 3.0 and understand the parts of the interface. Launch Report Builder 3.0 from multiple sources. Understand management options. Create embedded data sources and datasets. Create shared data sources and datasets. Create shared data sources and datasets. Understand and utilize the Table or Matrix Wizard. Understand and utilize the Chart Wizard. Understand and utilize the Map Wizard. Understand and utilize lists. Understand and utilize tables. Understand and utilize matrices. Understand and utilize data regions. Understand and utilize parameters. Understand and utilize expressions. Understand and utilize report parts. Understand and utilize formatting options. Understand visualization options. Understand and utilize charts. Understand and utilize sparklines. Understand and utilize gauges. Understand and utilize maps. Understand filtering, grouping, and sorting. Understand and utilize dynamic headers and footers. Understand and utilize report templates. Understand and utilize HTML and texboxes. Understand and utilize lists as containers. Understand and utilize subreports. Understand report subscription options. Understand security.. Prerequisites A basic understanding of relational databases. Audience This course is intended for power users, developers, and IT professionals that will be involved with the design, development, and maintenance of reports created with Report Builder 3.0. Duration 2 days Outline of Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 Training Module 1: Course Overview This module explains how the class will be structured and introduces course materials and additional administrative information.Lessons Introduction Course Materials Facilities Prerequisites What We'll Be Discussing Lab : Course Overview Successfully log into their virtual machine. Have a full understanding of what the course intends to cover. Module 2: Introduction to Report Builder 3.0 This module introduces the interface of Report Builder 3.0, the different features available, and variances in data sources and datasets.Lessons Planning Your Reports Understanding Variances Between SQL Versions Exploring The Report Builder 3.0 Interface Examining Management Utilizing Data Sources Working with Datasets Lab : Introduction to Report Builder 3.0 Explore the Report Builder 3.0 Interface Create an Embedded Data Source into SQL 2014 Engine Create an Embedded Data Source into SQL 2014 Analysis Services Create a Shared Data Source Using the Report Manager Create a Shared Dataset Using the Shared Data Source Plan the reports. Use Report Builder 3.0 and understand the parts of the interface. Launch Report Builder 3.0 from multiple sources. Understand management options. Create embedded data sources and datasets. Create shared data sources and datasets. Module 3: Report Builder 3.0 Wizards This module covers report basics exploring lists, matrices, and tables along with the wizards. Data regions will also be explained.Lessons Exploring Table or Matrix Wizard Utilizing Chart Wizard Working with Map Wizard Lab : Report Builder 3.0 Wizards Create Five Shared Data Sources and Two Shared Datasets Use the Table or Matrix Wizard Use the Chart Wizard Use the Map Wizard Create shared data sources and datasets. Understand and utilize the Table or Matrix Wizard. Understand and utilize the Chart Wizard. Understand and utilize the Map Wizard. Module 4: Report Builder 3.0 Basic Reports In this module we examine parameters, filters, and the expressionable aspect of reports. We also cover formatting options.Lessons Utilizing Lists Using Tables Exploring Matrix Mastering Data Region(s) Examining Parameters Working with Expressions Understanding Report Parts Formatting Reports Lab : Report Builder 3.0 Basic Reports Creating a Report Using Lists Creating a Report Using Tables Creating a Report Using a Tablix Creating a Report with a Query Parameter Report Parameter with a Shared Dataset Create Parameters Using a Dataset as a Filter Using Expressions in Your Report Creating a Report Using Report Parts Report Formatting Understand and utilize lists. Understand and utilize tables. Understand and utilize matrices. Understand and utilize data regions. Understand and utilize parameters. Understand and utilize expressions. Understand and utilize report parts. Understand and utilize formatting options. Module 5: Report Builder 3.0 Graphics This module is a detailed look at graphics including charts, images, sparklines, data bars, gauges, and Bing maps.Lessons Understanding Visualizations Utilizing Charts Exploring Gauges Examining Maps Lab : Report Builder 3.0 Graphics Using Sparklines in a Report Report Builder Chart Borders, Titles, and Legends Linear Gauges Basic Maps Basic Maps with Color Understand visualization options. Understand and utilize charts. Understand and utilize sparklines. Understand and utilize gauges. Understand and utilize maps. Module 6: Intermediate Reporting This module covers intermediate reporting with emphasis on actionable reports, and a section exploring report subscriptions and security.Lessons Filtering, Grouping, and Sorting Utilizing Dynamic Headers and Footers Visualizing Your Company Report Templates Understanding HTML5 and Textboxes Using the List Object to Combine Other Items Creating Subreports and Drillthrough Reports Exploring Subscriptions Examining Security Lab : Intermediate Reporting Report Header and Footer Creating Report Templates Embedding HTML in a Textbox Lists as Containers Subreports Understand filtering, grouping, and sorting. Understand and utilize dynamic headers and footers. Understand and utilize report templates. Understand and utilize HTML and texboxes. Understand and utilize lists as containers. Understand and utilize subreports. Understand report subscription options. Understand security. Module 7: Report Builder 3.0 Tips and Tricks This module is optional and contains 20 tips and tricks with step-by-step instructions. Lessons Lab : Report Builder 3.0 Tips and Tricks Use what they’ve learned throughout this course. We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC. View Course Outline Share This Request On-Site or Customized Course Info REGISTER FOR A COURSEWARE SAMPLE x Sent First Name Last Name Email Request On-Site or Customized Course Info x Sent First Name Last Name Phone Number Company Name Email Question