55232 Writing Analytical Queries for Business Intelligence

Price
$1,895.00 USD

Duration
3 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

How do you transform complex tables into clean, analysis-ready datasets?

This training course teaches you how to write analytical queries using Transact-SQL (T-SQL) for business intelligence (BI) workflows. You’ll learn to manipulate columns, combine tables, aggregate results, and encapsulate logic in reusable views and procedures. With a focus on BI scenarios, the course prepares you to deliver clean, structured datasets to tools like Power BI, Excel, SSRS, and RStudio.

Course Objectives

After completing this course, you will be able to build efficient SQL queries tailored for business intelligence and data analysis needs. The training emphasizes reusable logic, data encapsulation, and structured output delivery.

  • Understand the five types of requirements for BI querying
  • Combine and reshape data across multiple tables
  • Define the correct aggregation level with GROUP BY and HAVING
  • Use CTEs, subqueries, and derived tables for cleaner logic
  • Create views and functions to streamline data access
  • Deliver datasets to BI tools like Power BI and Excel

Who Should Attend?

This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

Setting learning of information examination and business knowledge situations. For instance, a comprehension of a business-related business knowledge venture or need. Fundamental information of the Windows working framework and its center usefulness, including document framework route. Essential comprehension of the reason for social database administration frameworks, for example, SQL Server.

Agenda

Module 1: Introduction to T-SQL for Business Intelligence

  • SQL programming approaches: transactional vs analytical
  • The database engine and SSMS
  • Introduction to SELECT queries
  • Using the CarDeal sample database
  • Lab: Intro to T-SQL for BI

Module 2: SELECT Expressions, WHERE, and ORDER BY

  • Column expressions, data types, and built-in functions
  • Column/table aliases and conversions
  • Using WHERE and ORDER BY clauses
  • Lab: Write filtering and sorting queries

Module 3: JOIN Operators and Combining Tables

  • Primary/foreign key relationships
  • CROSS JOIN, INNER JOIN, OUTER JOIN variations
  • Multi-table joins and nested joins
  • Combining JOINs with WHERE and ORDER BY
  • Lab: Write multi-table SELECT queries

Module 4: Aggregating with GROUP BY

  • Defining aggregation level and granularity
  • COUNT, SUM, AVG, and other aggregate functions
  • GROUP BY and HAVING usage
  • Lab: Write grouped and aggregated queries

Module 5: Subqueries, Derived Tables, and CTEs

  • Writing correlated and non-correlated subqueries
  • Using derived tables in FROM clauses
  • Structuring logic with common table expressions (CTEs)
  • Lab: Create reusable query logic

Module 6: Encapsulating Data Retrieval Logic

  • Creating and using views
  • Table-valued functions and stored procedures
  • Creating read-access objects for analytical clients
  • Lab: Build encapsulated SQL logic

Module 7: Getting Your Dataset to the Client

  • Connecting SQL Server to Excel, Power BI, and RStudio
  • Exporting with SSMS, bcp utility, and Import/Export Wizard
  • Best practices for client-ready data delivery
  • Lab: Export datasets and connect to BI tools
 

Upcoming Class Dates and Times

Nov 24, 25, 26
8:00 AM - 4:00 PM
ENROLL $1,895.00 USD
Weekday Sessions / Guaranteed to Run
Virtual: Online - CST
CourseID: 3601607E
               
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons