Discover Classes. Earn Rewards.
Writing Analytical Queries for Business Intelligence is unfortunately unavailable

Thankfully we have 25 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
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
Booking this class for a group? Find great private group events here

25 Top Choices

Google Analytics Introduction

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

This class is designed to provide you with in-depth knowledge of the features available in Google Analytics and teach you how to leverage them to best serve your business needs. This class is different from other Google Analytics training classes in that it includes many hands-on interactive exercises, ensuring that students who complete the course...

Wednesday Dec 9th, 10am - 4:45pm Eastern Time

  (2 sessions)
$795

2 sessions

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Thursday Dec 10th, 10am - 5pm Pacific Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Thursday Dec 10th, 10am - 5pm Pacific Time

Google Analytics Bootcamp (Virtual)

This class is temporarily being offered remotely.

at Noble Desktop - Virtual Classroom

In this 2-day intensive course, you’ll learn how to use Google Analytics, interpret its data, and make better business decisions This comprehensive workshop takes a deep dive into Google Analytics and its many applications. Learn how to set up an account and understand what you should be tracking. Leave with a solid understanding of the tool and...

Thursday Dec 10th, 10am - 5pm Eastern Time

  (2 sessions)
$650

2 sessions

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to...

Thursday Dec 10th, 11am - 6pm Mountain Time

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to...

Thursday Dec 10th, 12pm - 7pm Central Time

Google Analytics Bootcamp w/ Freddie Blicher

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Thursday Dec 10th, 12pm - 7pm Central Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Thursday Dec 10th, 1pm - 8pm Eastern Time

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Thursday Dec 10th, 1pm - 8pm Eastern Time

Data Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

This single day bootcamp will run through the analytical workflow -- from collecting, cleaning, analyzing and presenting insights from public data sets. We will introduce important tools used in this process such as Google Sheets and Tableau. Goals: Introduce concepts and practice using and managing data Transform data for descriptive analytics...

Monday Dec 14th, 9am - 4pm Pacific Time

Crystal Reports Part 1

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation. Information...

Monday Dec 14th, 10am - 4:45pm Eastern Time

  (2 sessions)
$895

2 sessions

Tableau Desktop Level 1: Introduction

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

Tableau has for some time been one of the most popular Business Intelligence and data visualization tools available. Why? Because, quite simply, it’s a tool that’s responsive to the needs of modern businesses. But it’s most effective when you know how to get what you want from it – it might make your business intelligent, but it isn’t going...

Monday Dec 14th, 10am - 4:45pm Eastern Time

  (4 sessions)
$1,995

4 sessions

Data Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Atlanta, Georgia 00000

This bootcamp will run through the analytical workflow -- from collecting, cleaning, analyzing and presenting insights from public data sets. We will introduce important tools used in this process such as Google Sheets and Tableau. Goals: Introduce concepts and practice using and managing data Transform data for descriptive analytics and business...

Monday Dec 14th, 1pm - 8pm Eastern Time

Qlik Sense Advanced

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

This class is an excellent course for all aspiring Qlik Sense® developers. It will take you through the basics, right through to the use of more advanced functions. Starting with a quick refresher on obtaining data from data files and databases, this class moves on to the more refined features of Qlik Sense®, including visualization, scripting,...

Thursday Dec 17th, 10am - 4:45pm Eastern Time

  (2 sessions)
$895

2 sessions

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to...

Thursday Dec 10th, 10am - 5pm Pacific Time

Google Analytics Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Saturday Dec 26th, 11am - 6pm Central Time

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to setup...

Thursday Dec 10th, 1pm - 8pm Eastern Time

Google Analytics Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

Google Analytics is the most used web analytics tool in the world. Are you harnessing its power? Understanding how Google Analytics works–beyond the basic features–gives you the ability to unlock powerful insights. In this bootcamp, we'll explore how to set concrete KPIs and track success through Google Analytics. We'll then dive into how to...

Thursday Dec 10th, 1pm - 8pm Eastern Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

Everyone wants to grow their business and make their websites successful. But how do you know if you are making progress to your goals? And how do you know what marketing activities are the most efficient and cost effective to pursue? That is the job of analytics and Google Analytics in particular. Without analytics, strategies, goals and marketing...

Tuesday Jan 12th, 6pm - 9pm Pacific Time

Google Analytics for Beginner:Key Concepts & Quick Wins

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

Google Analytics is a free tool used by over half of websites today that empowers organizations to measure what people are doing on their website or app. In this class, you’ll learn the basics of how to use Google Analytics to get real insights into your website’s visitors, their behavior and any patterns and trends. Start identifying what data...

Tuesday Jan 12th, 6pm - 9pm Pacific Time

Loading...