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

  • How to Install and Configure SQL Server Reporting Services (SSRS)
  • How to Install the Report Builder Tool
  • Steps to Create Simple Reports Using Wizards
  • Steps to Create charts to Support Your Reports
  • How to Format Report Fields
  • The Steps to Add Key Performance Indicators (KPIs)
  • How to Create Dynamic Reports with Parameters
  • How to Create Drill-through Reports to Navigate Different Layers of Data

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
8 Lectures
8 Quizzes
12 Hands on Labs
  • Module 1: Getting Started with SQL Report Builder
    In 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 Reports
    This 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 Formats
    This 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 Reports
    In 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 Report
    Key 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 Report
    In 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 Report
    To 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 Expressions
    Expressions 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

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 Teaches D365 for Finance and Operations Programming

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.”

Introduction to SQL Business Analysis and Report

$99.00

    Prominent Features
  • 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