Design & Install Analysis Services
SQL Server 2014
| Intermediate
- 12 Videos | 1h 3m 56s
- Includes Assessment
- Earns a Badge
SQL Server Analysis Services (SSAS) lets you use different models to analyze large amounts of data. Explore the benefits each model provides, and how to install and configure SSAS.
WHAT YOU WILL LEARN
-
explain the functionality OLAP and data mining provide for business intelligenceexplain the functionality tabular mode provides for business intelligenceexplain the functionality of SQL Server BI features with SharePoint, including PowerPivotidentify the different BI features to install based on a scenarioidentify the appropriate data model to use for data analysisidentify the development and production considerations for install SSAS
-
install SSAS in multidimensional modeinstall SSAS in Tabular modeinstall PowerPivot for SharePoint with use in SSASupgrade an SSAS instanceupdate an SSAS instanceconfigure server and database level security for an SSAS instance
IN THIS COURSE
-
1.Overview of the Multidimensional and Data Mining Mode9m 10sUP NEXT
-
2.Overview of Tabular Mode5m 21s
-
3.Overview of BI Features with SharePoint5m 46s
-
4.SQL Server BI Scenarios and SharePoint5m 15s
-
5.Identify the Correct Model for Data Analysis4m 15s
-
6.Identify the Development and Production Considerations5m 49s
-
7.Installing SSAS in Multidimensional Mode4m 52s
-
8.Installing SSAS in Tabular Mode4m 20s
-
9.Installing SQL Server PowerPivot for SharePoint4m 36s
-
10.Upgrading an SSAS Instance5m 37s
-
11.Updating an SSAS Instance3m 6s
-
12.Configuring Security for an SSAS Instance5m 50s
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.