Introduction to SQL Business Analysis and Report
Our Introduction to SQL Business Analysis and Report course focuses on how to create, format, and share basic Reporting Services paginated reports. The [...]
What you will learn
Requirements
- Familiarity with Windows 10
- Knowing how to install programs and navigate files
- Videos are best viewed with 1920 x 1080 resolution
Description
Our Introduction to SQL Business Analysis and Report course focuses on how to create, format, and share basic Reporting Services paginated reports. The course will walk you through the setup process, detailing the steps to build a report. It will also give you an overview of a report's interactive elements, such as formatting and charts. Every module gives you tips on how to ensure your reports are dynamic and follow the best practices. After completing this course, you will be able to pursue a career as a SQL Business Analyst and Report Writer.
Course Content
-
Module 1: Getting Started with SQL Report BuilderIn this lecture, you will learn how to set up a basic environment using Report Builder. You will also get familiar with the basics of SQL Server Reporting Services (SSRS) and create a quick chart report offline.
Lessons Duration 
Lesson 1: Getting ready Lesson 2: Installing Configuring SSRS Lesson 3: Create a Quick Chart Report Offline 
Module 1: Quiz Labs Duration 
Lab 1: Create a Quick Chart Report Offline -
Module 2: Create Basic ReportsThis module will teach you how to create a basic table and a Matrix report using Wizards. You will also use queries to generate sample data.
Lessons Duration Lesson 1: Creating a Basic Table Report Lesson 2: Creating a Matrix Report Module 2: Quiz Labs Duration
Lab 1: Creating a Basic Table Report
Lab 2: Creating a Matrix Report -
Module 3: Working with Free Form Reports and FormatsThis lecture will teach you the different techniques you can use to format report fields. You will also learn how to add graphics and free text in a free form report.
Lessons Duration Lesson 1: Creating a Free Form Report Lesson 2: Format Text in Report Module 3: Quiz Labs Duration
Lab 1: Creating a Free Form Report
Lab 2: Format Text -
Module 4: Adding Charts to Your ReportsIn this lecture, we will teach you a common method to illustrate relationships between data using charts. We will also show you how you can add pie and bar charts to your report to make it more appealing.
Lessons Duration Lesson 1: Add a Column Chart to Your Report (Report Builder) Lesson 2: Add a Pie Chart to Your Report (Report Builder) Lesson 3: Add a Sparkline to Your Report (Report Builder) Module 4: Quiz Labs Duration
Lab 1: Add a Column Chart to Your Report (Report Builder)
Lab 2: Add a Pie Chart to Your Report (Report Builder)
Lab 3: Add a Sparkline to Your Report (Report Builder) -
Module 5: Add Key Performance Indicators to Your ReportKey Performance Indicators (KPIs) are values that measure if a company is achieving its primary business objectives. In this module, we will teach you how to add KPIs to Reporting Services paginated report.
Lessons Duration Lesson 1: Using Key Performance Indicators Module 5: Quiz Labs Duration
Lab 1: Using Key Performance Indicators -
Module 6: A Parameterized ReportIn this module, you will learn how to use Parameterized Reports and how to interactively define the parameters to compile results.
Lessons Duration Lesson 1: Adding a Parameter to a report Module 6: Quiz Labs Duration
Lab 1: Adding a Parameter to a report -
Module 7: Map ReportTo visualize business data against a geographical background, you can add a map to your Reporting Services paginated report. In this module, you will learn about map features and how you can use them to display data on the geographical background of a Reporting Services paginated report.
Lessons Duration Lesson 1: Adding Map to Reports Module 7: Quiz Labs Duration
Lab 1: Adding Map to Reports -
Module 8: Introducing ExpressionsExpressions are widely used throughout Reporting Services paginated reports to retrieve, calculate, display, group, sort, filter, parameterize, and format data. In this module, you will learn to add simple and complex expressions to these reports.
Lessons Duration Lesson 1: Adding Expression in Reports Module 8: Quiz Labs Duration
Lab 1: Using Expression in Report Builder
About the Instructor
Brandon Ahmad, MCSE
Brandon Teaches D365 for Finance and Operations Programming
Microsoft Certified Trainer Regional Lead - USA
8.8 out of 9.0 Average Instructor Rating
Top Instructor Award Twice
MCSE Certification in Dynamics 365
Freelances as hands-on Technical Lead with very advanced development scenarios for Day Job
Brandon Ahmad is a Dynamics 365 Technical Solutions
Architect and CEO of Instructor Brandon.
In his years of experience working with different Microsoft Technologies such as
Dynamics 365, Power BI and Power Apps,
he has been able to consult over 60 implementations across the globe. Being
solution-oriented and implementing advanced scenarios,
he has dedicated his time to creating training courses for programmers and
developers alike; those interested mainly in learning Microsoft Technologies.
As an Instructor, he strongly believes in being able to master developmental skills;
as long as one achieves the right set of training and guidance.
Providing students with several enhanced Microsoft training courses that focus on
providing a hands-on learning experience, Ahmad’s biggest secret to teaching lies in
his ability to nurture those who take his courses.
His best reward (in his own words) is “hearing that my students saved time and
mastered Microsoft Technology skills, knowing that my courses played a vital part in
that success.”
10 hours of course content
Custom-enhanced HTML5 RDP labs
Interactive video lessons & quizzes
Mobile app
Dedicated support (1 hour a day)
Certification after completion
Licenses for hands-on training