Data Warehousing & Business Intelligence Deployment
SQL Server 2014
| Intermediate
- 10 Videos | 37m 10s
- Earns a Badge
To gain a business edge, it is vital to extract business intelligence from data warehouses. Examine how to achieve this goal using SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
WHAT YOU WILL LEARN
-
create a SQL Server Analysis Service project using SQL Server Data Toolscreate a data source in SQL Server Analysis Services using SQL Server Data Toolscreate a cube in SQL Server Analysis Services using SQL Server Data Toolsdeploy SQL Server Analysis ServicesQuery SQL Server Analysis Services using Excel
-
connect to a data source to create a report in SQL Server Report Buildercreate a basic SQL Server Reportcreate a SQL Server report with calculationscreate a SQL Server report with end user interactive elementsdeploy a SQL Server report
IN THIS COURSE
-
1.Creating an SSAS Project3m 44sUP NEXT
-
2.Creating an SSAS Data Source3m 25s
-
3.Creating an SSAS Cube3m 13s
-
4.Deploying SSAS2m 55s
-
5.Querying SSAS4m 49s
-
6.Connecting SSRS to a Data Source4m 31s
-
7.Creating a Report3m 8s
-
8.Creating a Report with Calculations3m 10s
-
9.Creating Reports with Interactivity4m 43s
-
10.Deploying a SQL Server Report3m 35s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.