stevefox1973's channel
Loading...
390
subscribers
221,586
video views
Uploaded videos
1-10 of 65-
Adding Grouping and Drill down to SQL Server Reporting Services Reports (SSRS)
stevefox1973
9 views
Introduction to adding Grouping and Drill Down functionality to simple Tabular Reports in SQL Server Reporting Services (SSRS). This simple two-step process allows you to c...
-
Adding Totals and Subtotals to Microsoft Reporting Services Reports (SSRS)
stevefox1973
36 views
Demonstration of how to add totals and subtotals to a report within SQL Server Reporting Services (SSRS). Adding totals and subtotals is simple, but not very intuitive. So ...
-
Introduction to Transact-SQL (T-SQL) using Microsoft SQL Server
stevefox1973
65 views
Transact-Structured Query Language (T-SQL) is Microsoft's (& Sybase's) proprietary extension to SQL. T-SQL is central to using Microsoft SQL Server. All applications that c...
-
Business Intelligence Demonstration using Microsoft SQL Server & PowerPivots
stevefox1973
379 views
Demonstration of how a simple Business Intelligence Solution works. It demonstrates 1) an Extract Transform Load process (ETL), 2) Data warehouses, 3) Reporting & Scoreca...
-
Using SQL Server Integration Services (SSIS) to load a SQL Azure table
stevefox1973
715 views
SQL Server Integration Services (SSIS) can be used to load data into the a cloud based database like Microsoft SQL Azure. It involves 5 basic steps : 1) Create SQL Azure ac...
-
Creating a SQL Server Reporting Services (SSRS) report that contains a Parameter Query
stevefox1973
7,167 views
In many reporting situations users need to restrict the data visible in a report. For example filtering a master report with a drop-down list box so that only information f...
-
Creating a SQL Server Reporting Services (SSRS) report with drill down functionality.
stevefox1973
10,996 views
How to create a basic SQL Server Reporting Services project with drill down functionality using the Report Wizard. The demonstration uses Business intelligence Development ...
-
Creating a Cluster Model using the Excel Addin for SQL Server
stevefox1973
768 views
Clustering is the classification of similar objects into different groups, or more precisely, the partitioning of a data set into subsets (clusters), so that the data in ea...
-
Creating prediction queries using the SQL Server data mining add in for Excel
stevefox1973
747 views
The Data Mining Query allows you to create predictions using a data mining model that you have already created. In this demonstration I show how you can use this tool to pr...
-
Using Profit Charts in SQL Server 2008 to Optimize Marketing Campaigns.
stevefox1973
287 views
Profit charts provide an estimate of the maximum profit that can be generated from a marketing campaign using various data mining models. This demonstration used the SQL Se...
Advertisement
About stevefox1973's channel
more
less
Play all(65)