Trainings : +91 889 8888 448 | Certifications : +91 868 8881 863
Course Content:
1. MSBI and SSIS
Architecture Overview
Learning Objectives - In this module, you will understand the need
for an Integration tool and its significance in real world. You will learn the
importance of SSIS as an integration tool and get a birds-eye-view of the
overall architecture.
Topics - Understand the Need of Business Intelligence Understand
the MSBI Architecture, Import and Export wizard, Overview of SSIS Package
Designer & Environment Installation of SQL Server and SSDT- BI
2. SSIS Control Flow
and Data Flow
Learning Objectives - In this module, you will understand the SSIS
designing environment and gain in-depth knowledge of the SSIS Control flow
& Data flow.
Topics - Understand SSIS Architecture, Control Flow & its
Components (Tasks, Containers, Precedence Constraints), Data Flow & its
Components (Source and Destination Connections, different types of
Transformations), Scenarios by combining Control Flow and Data Flow components,
System Variables and User defined variables
3. SSIS (Transactions,
Error Handling)
Learning Objectives - In this module, you will understand how the
objects of the core SSIS workflow work and interact with each other to help in
security, restorability and other key functions.
Topics - Parameters, Expressions, Event Handling, Transaction
Options, Checkpoints, Logging options (5 types), Configure Error Output and On
Error event, Package Security: Package Protection Levels
4. SSIS
(Configuration, Deployment and Scheduling)
Learning Objectives
- In this module, you
will learn advanced SSIS programming features, which will help in handling
custom requirements using .Net code. In addition, you will learn the way to
configure and deploy SSIS projects.
Topics - Custom code using Script Task, Script Component, Package
Configurations (5 types), Debugging & Troubleshooting, Executing packages –
DTExec and DTExecUI, Package Deployment, Package Scheduling using SQL Agent
5. SSIS Advance Topics
& DWH Basics
Learning Objectives - In this module, you will learn SSIS advanced
concepts such as SSIS Performance Tuning & its Best Practices. You will
also learn Introduction to Datawarehouse and its Architecture, Loading Data
into DW using SSIS as well as Introduction to Dimensional Modeling. This will
be base for understanding SSAS features.
Topics - Package Performance Tuning, SSIS Best Practices, Need for DW
& Business Intelligence, OLTP vs. OLAP, DW Architecture, Dimensional
Modeling, Schemas: Star, Snowflake
6. SSAS Cube Design
Learning Objectives - This module will help you in understanding SQL
Server Analysis Services Overview and its Architecture. It also covers various
types of SSAS models along with designing dimensions and measure groups. You
will also learn about SSAS Administration with prime focus on deployment and
processing.
Topics - Tabular Model and Multidimensional Model, Data Sources,
Data Source Views, Identify the Fact and Dimensions, Named Calculation and
Named Queries, Designing Dimensions, Dimension Hierarchies, Designing Measure
Groups, Dimension Usage with Measure Group, Attribute Relationships, Storage
Modes: MOLAP, ROLAP, HOLAP, Partitions, Aggregations, KPIs, Actions,
Translations and Perspectives
7. SSAS Deployment and
MDX, DAX
Learning Objectives - In this module, you will learn basics of MDX
& DAX and get systematic approach of basic SSAS Performance Tuning and
Troubleshooting. You will also learn the concepts of Adhoc-Reporting and
creation of a report against SSAS as a data source.
Topics - SSAS Deployment and Cube Processing, Different Processing
Options, Loading Data into DW using SSIS, MDX queries, DAX Queries, Performance
Optimization of cube and Dimension, Best Practices, Schedule the Cube
processing
8. SSRS Reporting
Learning Objectives - In this module, you will understand Reporting
Services, its Architecture and how to configure it. You will also learn about
the environment where reports are created and also about server where the
reports are deployed.
Topics - Reporting Services Architecture & Lifecycle, Report
Parameters and Multivalued, Cascading Drop down Parameters, Types of Reports:
Table, Matrix, Sub Report, Chart Report (Bar, Pie, Line), Drill-Down Report,
Drill through Report, Creating Groups, Filters, Expressions Sort and
Interactive Sort, Alternate Row Colors, Repeating Row Headers and Column
Headers, Exporting Reports to different formats
9. SSRS: Report
Manager
Learning Objectives - In this module, you will learn about different
kinds of reports and their functionalities along with best practices to be
followed. You will also learn about various SSRS Administrative
activities.
Topics - Report Manager, Deploying Reports and Data Sources,
Securing Access to Reports (Role based Security), Data Source Security, Caching
Report and Snapshot Report, Report Subscriptions: Standard, Data-Driven
Managing Subscriptions, Ad-Hoc Reporting with Report Builder, Develop SSRS
Report using MDX
10. Putting the Pieces
Together
Learning Objectives - In this module, you will understand how MSBI
ecosystem components work together in a Business Intelligence environment to
solve the Organizations data problems. This module covers end-to-end
implementation from Data Retrieval --> Data Transformation --> Data
Loading into DWH --> Data Modeling --> Report Delivery
Topics - End to End Business Intelligence case study involving SSIS,
SSAS, SSRS and MDX.
1.
SQL
2. How many types of keys and explain?
3. Diff b/n synchronous & asynchronous transformations
4. How to create database
5. Explain cursor
6. Write the syntax for rank
7. How to improve the query performance
8. Define view & index view
9. Define trigger & types of triggers
10. Diff b/n sp & function ,delete & truncate, temp tables & table variable
11. Diff b/n where & having clause
12. Diff b/n sub query & correlated sub query
13. Explain error handling in store procedure
14. i/p1 : id sal i/p2 : id sal o/p: id sal
i. 111 10,00 111 3000 111 5000
ii. 222 15,000 111 2000 222 6000
iii. 333 20,000 222 5000 333 8000
1. 222 3000
2. 222 1000
3. 333 2000
4. 333 4000
iv. 333 6000
15. explain joins &cte
16. diff b/n table scan & index scan
17. can we update complex view or not
18. explain locks
19. diff b/n delete & update
20. explain authentication
21. explain sql profiler
22. diff b/n replace & stuff
23. what is execution plain
24. explain dynamic sql
25. explain sql statistics
26. what is the scope of cte , temp tables, table variable
27. how many bytes will tiny int, small int ,int, long int
28. how to reseed the identity
29. define covered index
30. diff b/n sql server 2005 &sql server 2008
31. how to retrieve the 5th max salary in a table
32. diff b/n get date () and sysdatetime()
33. how can u execute @@error & @@row count at the same time?
34. Explain normalization forms
35. Diff b/n synonym and view
36. Diff b/n joins & sub query
37. Define dead lock
38. i/p: name o/p:
a. sun name sun ,mon , tue
i. mon
ii. tue
39.SSIS
40. diff b/n sequence & group container
41. diff b/n controlflow& data flow
42. explain event handler
43. diff b/n checkpoints & breakpoints
44. what is scheduled job & scheduled task
45. explain configurations,checkpoints,logging
46. how to scheduled the ssis package
47. error handling in ssis
48. explain audit transform
49. diff b/n look up & sort
50. what are the protection levels, isolation levels in ssis
51. explain logging modes in ssis
52. how to handle the errors in package level
53. diff b/n merge &merge join, union & union all, union all & multicast, look up& fuzzy lookup
54. define derive column, conditional split, data conversion
55. explain scd
56. what are the events in event handler
57. how to deploy the package
58. explain script task, ftp, send mail task
59. diff b/n file system & ftp
60. what are the cache modes
61. diff b/n user defined & system defined variables
62. how many types of constraints
63. how many types of configurations
64. how to deploy the project explain in different ways?
65.SSRS
66. how to deploy a report
67. how to scheduled the report
68. how to improve the performance of report
69. how many types of charts
70. what is linked report, sub report ,matrix report, parameterized, cascade report
71. define subscriptions & types of subscriptions
72. how to provide security for report
73. diff b/n report server & report manager
74. in report ,how many rendering formats
75. explain cache report
76. explain snapshot report
77. what is tablix
78.SSAS
79. How to generate a cube
80. Define measure data, dimension data
81. How to scheduled the cube
82. Explain Mdx
83. What is perspective, partitions
84. Diff b/n ods&stagging area
85. What is new named query, calculation
86. Diff b/n oltp&olap
87. Define dimension usage ,measure group
88. Explain kpi’s
89. Explain storage settings
90. Define attribute,hierarchy,
91. Define data warehousing
92. Define survogate key? purpose of survogate key explain
93. Define fact less fact table
94. Diff b/n sets & couples
95. How to create the hierarchy
96. How to process the cube
97. How to browse the cube data in excel sheet
98. Diff b/n star & snow flake schema
99. Explain types of measure
100. Define translation & browser
101. Diff b/n cube processing & cube deployment
I have taken msbi online course through IT Networks. Course is well designed and tutors are very well experienced. The course content is very good which includes real world examples & project.
Vishal Gupta
I learn a lot about the Info on MSBI. Its good for the beginners and working People. It was precise and easy to learn, you can understand the way they teach in Real time Scenarios. The Trainer was great and its worth to join ITN. Great work by ITN you save me a lot in learning the ssis and its basics examples.. Outstanding MSBI class, I learned a lot of new stuff. Great intro to SSAS. I had no clue as to what was involved in learning MSBI. I learned that Sql server after 4 years is still a valued tool. I will take other courses involving Analytics in ITN, so I can possibly earn a position as an MSBI Developer.
Akhilesh
IT Networks © 2019-20 | All Rights Reserved
Powered by Best Digital Marketing Courses in Bangalore