Course Content

Microsoft Business Intelligence
Introduction to MSBI:
1. What is MS-BI
2. Advantages of MS-BI
3. DWH Concepts
a. –>What is DWH?
b. –>Definition of DWH (Ralph Kimball, Bill Inmon Definitions)
c. –>OLTP Vs OLAP
d. –>DWH Architecture
e. –>Data Acquisition Process (ETL)
f. –>Data Analysis Process (OLAP)
g. –>DWH Design Guidelines (Star, Snowflake Schemas)
h. –>Tools used in DWH
i. –>Data Mart
Introduction to SSIS:
4. SSIS installation
5. SSIS Architecture
6. Package
7. Tasks ,Control Flow , Data Flow
Developing SSIS Packages:
8. SSIS Wizard
9. SSIS Designer (BIDS Environment)
10. Variables and Expressions
11. Breakpoints
12. Data viewers
13. Configuring Error Output
Errors and Debugging SSIS
14. Events Handling
15. Execution Logging
16. Control Flow Tasks
17. Data Flow Tasks(ETL)
18. .Net Scripting Task
SSIS Administration
19. Configuration
20. Deployment
21. Security
22. Manually Executing SSIS Package
23. Scheduling SSIS Package
24. Importing and Exporting Packages
25. Monitoring and Optimizing Packages
DWH with SSIS
26. Dimension Tables Data Loading
27. Fact Tables Data Loading
Introduction to SSRS
28. What is SQL Server Reporting Services?
29. What can you do with SSRS reports?
30. What components does SSRS use?
31. Who uses SSRS?
Authoring Reports
32. Basics Of SSRS
33. Data Source
34. Data Set
35. SSRS Expressions
36. Reports Formatting
Advanced Authoring
37. Parameterized Reports
38. Sub Reports
39. Drill Down Reports
40. Linked Reports In SSRS
41. Filters in SSRS
42. Actions In SSRS
SSRS Administration
43. Installation and Configuration
44. Deployment and Security
45. Subscriptions and Rendering
46. Caching and Snapshots
AD – Hoc Reports Development
47. Report Model Project
48. Model Designer
49. Report Builder
Introduction to SSAS
50. Dimensions
51. Facts
52. Data Sources
53. Data Source Views
Developing Cubes
54. Cube Designer
55. Partitions and Aggregations
56. Dimension Usage
57. Calculations and Kpis
58. Perspectives, Actions
MDX Language
59. Axes, Slice
60. Tuple and set
61. MDX Queries
62. MDX expressions
SSAS Administration
63. Installation
64. Configuration
65. Deployment
66. Processing
67. Security
68. Backup and Restore