Reporting Services Training Course
Reporting Services (or SQL Server Reporting Services - SSRS) is a service available as part of the Microsoft SQL Server package that allows you to create, manage and deliver various types of reports. Here are the main features and functions Reporting Services:
- It allows you to create a variety of reports such as tabular reports, charts, graphs, map reports, as well as subscription reports and interactive reports.
- Ability to connect to various data sources, such as databases, Excel files, text files or external data sources.
- It has a graphical environment (Report Builder and SQL Server Data Tools) that facilitates the design and creation of reports without the need for programming.
- Allows you to manage reports, catalog, share, schedule and view reports.
- Provides various report delivery methods, including email, server sharing, interactive web publishing, printing, etc.
- It has permission management mechanisms that enable control of access to reports.
- Enables the creation of reports that allow users to interactively filter, sort and navigate data.
SQL Server Reporting Services is a tool used by organizations to generate, manage and deliver various types of business reports. Thanks to this tool, users are able to effectively use data, visualize information and support decision-making based on data analysis.
Course Outline
- Introduction to Reporting Services
- Creating reports
- Shared sources
- Using grouping in reports
- Parameterization of reports - use of filters and parameters
- Report Manager - publication, properties, security management
- Report Manager - cache and subscription usage
- Self-Service BI and PowerView reports
Open Training Courses require 5+ participants.
Reporting Services Training Course - Booking
Reporting Services Training Course - Enquiry
Reporting Services - Consultancy Enquiry
Testimonials (4)
The topic was interesting, and the trainer was very friendly and has adept knowledge of the subject.
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
ćwiczenia i sposób ich tłumaczenia
Marcin Lipiec - Izba Administracji Skarbowej w Rzeszowie
Course - Wprowadzenie do Neo4j - grafowej bazy danych
Interakcja z prowadzącym, możliwość zadawania pytań na gorąco
Grzegorz Ziegert
Course - Administration with Powershell
Related Courses
Hasura GraphQL Engine
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at database administrators and developers who wish to use Hasura to build, access, and manage databases and applications efficiently with GraphQL.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start building databases with Hasura.
- Build, run, manage data access and queries on Hasura using GraphQL models.
- Secure data access by setting up authentication with JSON Web Tokens and Firebase.
- Extend database functions by integrating business logic.
- Manage database migrations and metadata effectively on Hasura to prevent data loss.
Blazegraph: Creating a Graph Database Application
21 HoursBlazegraph is an open source, Java-based RDF graph database for storing and representing data with complex relationships. It supports Blueprints and RDF/SPARQL 1.1.
In this instructor-led, live training, participants will learn how to use Blazegraph to capture complex data in graph format for retrieval from a number of sample applications. All exercises will be carried out hands-on in a live-lab environment.
By the end of this training, participants will be able to:
- Install and configure Blazegraph in standalone mode, clustered mode (optional) or embedded mode (optional)
- Create, test and deploy a sample application to query complex data in a Blazegraph data store
- Understand how to leverage GPU (graphics processing unit) to accelerate computations
Audience
- Developers
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
Beyond the Relational Database: Neo4j
21 HoursIn this instructor-led, live hands-on training in Poland, we will set up a live project and put into practice the skills to model, manage and access your data using neo4j. We contrast and compare graph databases with SQL-based databases as well as other NoSQL databases and clarify when and where it makes sense to implement each within your infrastructure.
Building Graph Databases with Neo4j AuraDB
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to use Neo4j AuraDB graph database to build cloud applications with high availability and zero administration.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start developing graph database applications with Neo4j AuraDB.
- Understand the features, core concepts, and architecture of Neo4j AuraDB.
- Learn how to build and scale graph database applications in the cloud.
- Enhance cloud security with AuraDB's pre-configured authentication and encryption features.
- Migrate existing Neo4j databases to AuraDB.
Wprowadzenie do Neo4j - grafowej bazy danych
7 HoursNoSQL Database with Microsoft Azure Cosmos DB
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at database administrators or developers who wish to use Microsoft Azure Cosmos DB to develop and manage highly responsive and low latency applications.
By the end of this training, participants will be able to:
- Provision the necessary Cosmos DB resources to start building databases and applications.
- Scale application performance and storage by utilizing APIs in Cosmos DB.
- Manage database operations and reduce cost by optimizing Cosmos DB resources.
Developing Applications with Oracle Application Express (APEX)
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
- Set up the necessary development environment to start developing database apps with Oracle APEX.
- Understand and explore the Oracle APEX tools to build a fully-featured application.
- Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
- Extend the functionality of complex enterprise apps easily with Oracle APEX.
- Optimize and scale application performance and deployment.
- Control and secure access to application data and components.
Business Intelligence with SSAS
14 HoursSSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.
In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.
By the end of this training, participants will be able to:
- Install and configure SSAS
- Understand the relationship between SSAS, SSIS, and SSRS
- Apply multidimensional data modeling to extract business insights from data
- Design OLAP (Online Analytical Processing) cubes
- Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
- Deploy real-world BI solutions using SSAS
Audience
- BI (Business Intelligence) professionals
- Data Analysts
- Database and data warehousing professionals
Format of the Course
- Interactive lecture and discussion
- Lots of exercises and practice
- Hands-on implementation in a live-lab environment
Course Customization Options
- This training is based on the latest version of Microsoft SQL Server and SSAS.
- To request a customized training for this course, please contact us to arrange.
Introduction to SQL Server 2012 Integration Services (SSIS)
28 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services.
By the end of this training, participants will be able to:
- Understand the principles of ETL and the role of SSIS.
- Create, deploy, and manage SSIS packages.
- Design and implement Control Flow to define the flow of tasks in a package.
- Implement Workflow and set up constraints for effective task execution.
- Construct Data Flows to extract, transform, and load data.
- Work with Variables and Containers to enhance package flexibility.
- Manage Transactions to ensure data consistency.
- Implement effective error handling and debugging techniques.
- Set up Logging for tracking and monitoring.
- Handle Slowly Changing Dimensions for managing changing data.
- Deploy a Package for production use.
- Implement Security measures to protect sensitive data.
- Utilize Scripting to extend SSIS functionality.
- Apply Best Practices for efficient and maintainable SSIS solutions.
Business Intelligence in MS SQL Server 2008
14 HoursTraining is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
Developing in SQL Server Business Intelligence
35 HoursDevelopers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects.
The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself.
4 Top Takeaways from the Course
- Make your existing data work harder for you
- Integrate diverse data stores to a single repository
- Transform raw data to business intelligence
- Create eloquent reports from raw data
Administration with Powershell
35 HoursThis intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration.
Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
Milvus: Open-Source Vector Database for AI Applications
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn about Milvus and its practical applications in various AI scenarios.
By the end of this training, participants will be able to:
- Understand the architecture and features of Milvus.
- Implement vector databases in different AI applications.
- Perform similarity searches with high accuracy and speed.
- Apply Milvus to real-world AI challenges.
Pinecone: Vector Database Solutions for AI
21 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level to intermediate-level data scientists and software developers who wish to learn how to apply Pinecone to various AI scenarios, from semantic search to personalization.
By the end of this training, participants will be able to:
- Understand the architecture and features of Pinecone.
- Implement vector databases in different AI applications.
- Perform similarity searches with high accuracy and speed.
- Apply Pinecone to real-world AI challenges.
Introduction to Vector Databases
14 HoursThis instructor-led, live training in Poland (online or onsite) is aimed at beginner-level software developers and database administrators who wish to learn the basics of vector databases, including their structure, operation, and use cases.
By the end of this training, participants will be able to:
- Understand the concept and purpose of vector databases.
- Recognize the differences between vector and traditional databases.
- Learn basic techniques for creating and managing vector data.
- Perform simple similarity searches.
- Appreciate the role of vector databases in AI applications.