Writing Analytical Queries for Business Intelligence is unfortunately unavailable

Thankfully we have 4 other Business Intelligence Classes for you to choose from. Check our top choices below or see all classes for more options.

Writing Analytical Queries for Business Intelligence

at Hartmann Software Group

Course Details
Price:
$1,290
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Interactive Online Classroom
Share:
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 10
System Requirements: You will need an Internet connection and administrator access on your computer or laptop.
Class Delivery: Additional information on how to log into the online environment will be provided after purchasing the class.
Teacher: HSG Instructors

What you'll learn in this business intelligence training:

This three-day instructor led Microsoft SQL Server 2016 Training Course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this Microsoft SQL Server 2016 Training Course presents TSQL within the context of data analysis Â?Â? in other words, making meaning from the data rather than transaction-oriented data-tier application development.

The Microsoft SQL Server 2016 Training Course starts with a brief discussion of levels of measurement and quantitative research methodology, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path for RDBMS data retrieval for use in analytical tools such as SQL Server Reporting Services, PowerBI, R, and Excel.

Audience
This Microsoft SQL Server 2016 Training 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.

Course Outline 
  • Module 1: Introduction to TSQL for Business Intelligence
  • Module 2: Turning Table Columns into Variables for Analysis: SELECT List Expressions, WHERE, and ORDER BY
  • Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators
  • Module 4: Creating an Appropriate Aggregation Level Using GROUP BY
  • Module 5: Subqueries, Derived Tables and Common Table Expressions
  • Module 6: Encapsulating Data Retrieval Logic
  • Module 7: Getting Your Dataset to the Client

Note:
HSG courses are taught by the experienced instructors who are proven experts in their field. Our instructors are highly knowledgeable, friendly, reliable and inspiring. They speak and teach industry's best practices and often customize classes to meet individual needs.

Students are encouraged to ask questions and participate in discussions and training-labs.

Still have questions? Ask the community.

Refund Policy
To cancel or reschedule your registrations without penalty or charge, please notify us at [email protected] 14 days or more before the first day of my class.
Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 12900 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: Hartmann Software Group

 

​The solution to most IT related problems lies in a better understanding of the technology.

Founded in June of 2002, the Hartmann Software Group (HSG) is an IT training company specializing in complicated software development languages and technologies ranging from C++ to Weblogic/Oracle Application...

Read more about Hartmann Software Group

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

4 Top Choices

Google Analytics

at AcademyX -

More than ever, organizations large and small are now dependent on their web presence to reach their target audience. Understanding how visitors interact with your website and or mobile applications can provide effective insights into how compelling your messages, pages, and other content on your website are to them.  By monitoring, tracking,...

Monday Nov 25th, 9am - 4pm ET

Tableau Fundamentals

at AcademyX -

Tableau is the leader in Gartner's magic quadrant for BI (Business Intelligence and Data Analytics). Get better insight into your data with our Tableau training. In this Tableau training class, you will quickly get up to speed with the Tableau terminology and build a solid foundation to start leveraging the power of Tableau with hands on real-world...

Monday Dec 2nd, 9am - 4pm ET

  (2 sessions)
$995

2 sessions

Google Analytics Beginners

at Digital Workshop Center -

Understand your web traffic in a Google Analytics Beginners Class To understand your web traffic, you need to rely on analytics tools that can dissect the complexity of the data available for your business.  There is no better option for analytics than Google Analytics, as they are the leaders of search engine technology.  In this Google...

Tuesday Dec 3rd, 6pm - 9:30pm ET

  (2 sessions)
$279

2 sessions

Tableau Advanced

at AcademyX -

Tableau Advanced training course is intended for Tableau users who are already familiar with Tableau concepts, i.e., the creation of calculated fields, all chart options, and the basics for connecting to data including extracts. By the end of this advanced course, you will be familiar with LOD (Level of Detail) expressions, finding meaningful clusters...

Wednesday Dec 4th, 9am - 4pm ET

  (2 sessions)
$1,195

2 sessions