55232 Writing Analytical Queries for Business Intelligence

About this course

Write T-SQL queries that answer business questions. Over three days you will work through BI query requirements, combine and reshape data across tables, aggregate with GROUP BY and HAVING, use subqueries, derived tables and CTEs, create views and functions, and deliver datasets to Power BI and Excel.

What you'll learn

• 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

Curriculum

Who it's for

Analysts and BI developers who query SQL Server.

Before you start

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