55232 Writing Analytical Queries for Business Intelligence

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.
Course Details

Price:

$1,895.00

Days:

3

Location:

Virtual

Course Overview

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

Identify independent and dependent variables and measurement levels in their own analytical work scenarios. Identify variables of interest in relational database tables. Choose a data aggregation level and data set design appropriate for the intended analysis and tool. Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. Create stored procedures, views, and functions to modularize data retrieval code.

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.

SharePoint Online Fundamentals

  • Office 365 overview
  • SharePoint Online interface
  • Understanding permissions and roles

Creating and Managing Sites

  • Creating subsites and applying templates
  • Configuring site structure and navigation

Web Pages and Content

  • Working with classic and modern pages
  • Using web parts and layout options

Working with Apps

  • Lists and libraries
  • Managing views and content organization

Business Process Automation

  • Intro to Power Automate (Flow)
  • Building basic automation workflows
  • Power Apps integration

Permissions and Security

  • Configuring access levels and sharing
  • Managing site and item-level security

Search and Content Management

  • Using metadata and content types
  • Implementing content management strategies
Class Dates & Times
Filters Sort results
Reset Apply
03/18/2026 - 03/20/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$1,895.00
07/08/2026 - 07/10/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$1,895.00
11/24/2025 - 11/26/2025
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$1,895.00
— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.