MSBI
We provide the best MSBI training.
MSBI Course content
SSIS: SQL Sever Integration Services
1. About SSIS
2. ETL procedures
3. About DTS Packages
4. About Business Intelligence Projects
5. About SQL Server Data Tools (SSDT)
6. Elements of a SSIS project
a. Data Sources
b. SSIS Packages
7. Elements of a Package
a. Connection Managers
b. Control Flow Items
c. Dataflow
d. Event handlers
e. Package explorer
8. Creating a SSIS Project using SQL Server Data Tools
9. Creating a new Package
10. Executing a package
11. Logging ETL operations
12. Handling errors (exception handling)
13. Adding an existing package to the Project
Planning an SSIS project
14. Understanding the tasks
15. Planning control flow operations
16. Planning data flow operations
Optimizing an SSIS Project
17. Running and monitoring
18. Optimizing
Deploying & Running SSIS Projects
19. Deployment procedure
20. Manual Execution
21. Scheduling
SSRS: SQL Server Reporting Services
22. Importance of Reporting Servers & Services
23. About SSRS
24. Installing SSRS
25. Stopping and starting SSRS services
26. Using reporting services tools
27. Logon to SSRS
SSRS Projects
28. Elements of SSRS projects
a. Data sources
b. Reports
c. Report designer
29. Report planning/modeling
30. Creating a SSRS project
31. Formatting reports
32. Adding/Removing data sets
33. Adding calculated values to the reports
34. Using parameters and filters
35. Using Parameter
36. Executing reports
Publishing reports
37. Publishing reports onto a SSRS Server
Report Subscriptions
38. About Report Subscriptions
39. Creating Report Subscriptions
40. Managing Report Subscriptions
SSAS: SQL Server Analysis Services
1. Importance of Analytical systems and solutions in business development
2. Introduction and About SSAS
Building SSAS Projects
3. Elements of SSAS Projects
a. SSAS Database (OLAP database)
b. Data sources
c. Data source views
d. Dimensions & Facts
e. Measures
f. Cubes
g. Mining structures
4. Creating a SSAS Project (Multidimensional Analysis Solution)
5. Creating a cube
6. Planning Dimensions and facts (tables/views)
7. Dimension hierarchies
8. Sorting an Grouping attributes
9. Configuring Measures & Measure groups
10. Building KPI (Key Performance Indicators)
11. Building Actions
12. Building Partitions
13. Building Perspectives
14. Building Translations
MDX Queries
15. MDX Fundamentals
16. Writing MDX queries
17. Adding MDX Calculations to a Cube
Deploying a SSAS Package
18. Debugging a SSAS Project
19. Deploying a SSAS Database (Project)
20. Securing SSAS database services using Roles
