MSBI-SSAS,SSIS,SSRS,SQL SERVER,POWER BI LIVE ONLINE TRAINING BY HANDSON EXPERTS FROM HYDERABAD,INDIA

Post# A542646 · new Jersey, Maryland · Posted by: raj

MSBI[SSAS,SSIS,SSRS],POWER-BI,SQL SERVER REALTIME TRAINING (ONLINE + CORPORATE),JOB SUPPORT,INTERVIEW SUPPORT BY CERTIFICATION LEVEL TRAINERS

FOR FREE DEMO contact us at:
Email : raj@apex-online-it-training.com »
Phone/WhattsApp : +91-8500122107

Interview Questions, Recorded Video Sessions, Materials,Mock Interviews Will be provided

MSBI –SQL SERVER Course Content

SQL SERVER
a) Introduction to SQL
b) DBMS and RBMS basics
c) DML & DDL statements basis
d) Keywords and pre-defined functions in SQL
e) Keys, Constraints
f) Joins
g) Subqueries, Row Number, Rank, Dense Rank, Common Table Expressions
h) Table Variables and Temporary Tables
i) Functions & Stored Procedures
j) Cursors
k) Triggers
l) Performance Tuning & Query Optimization

1) SSIS
a) Introduction to SSIS
b) Control Flow, Data Flow and Containers
c) Transformations -- Includes All Transformations inside Dataflow
d) Slowly Changing Dimensions(SCD)
e) Tasks used inside Control Flow
f) Check Points
g) Logging
h) Configurations
I) Jobs & Scheduling Packages
j) Deploying SSIS packages
k) Performance Tuning of SSIS packages & Optimizations Techniques
L) Different Kinds of Data Loadings (Incremental Loading)
M) Protection Levels in SSIS
N) Precedence constraints

3) SSRS
a) Introduction to SSRS
b) Core Components - Data Tab, Layout Tab & Preview Tabs
c) Designing Reports - Header, Footer, Details, Query Designer
d) Creating parameters in reports, Types of parameters, Cascading Parameter
e) Drilldown Reports
f) Matrix Reports
g) Image, Rectangular, Chart and List Reports
h) Sub report
I) Report Deployment and Security
j) Drill through Reports
k) Report Caching
l) Subscriptions
m) Adhoc Reports
N) Linked Report
o) Report Manager and Report Server
p) Report Snapshot
q) Gauge, Data Bars, Spark Lines, Indicators

3) SSAS
a) Introduction to Data Ware Housing, SSAS, DataMart’s
b) Dimension and Fact tables
c) Types of Dimensions
d) Schema - Star & Snowflake
e) Cube-Advantages, Creation, Processing
f) Options inside Data Source View - Named Query, Add/Remove tables, New Relationship
g) Levels, Members, Hierarchy
h) Measures - Additive, Semi Additive, Non Additive
j) Fact less Fact tables
k) Storage Modes
l) Cube Securities
m) Partitions, Calculations, Perspectives
n) Create Reports in ssrs using cube
o)How to browse cube from Excel

4) Power BI
a) What is Power BI
b) What are different data sources in Power BI
c) How to connect to Power BI using SSAS Cube and SQL Server
d) How to create Report in Power BI

e) How to Publish Reports into Power BI Online

FOR More Details contact:
Email : raj@apex-online-it-training.com »
Phone/WhattsApp : +91-(850) 012-2107



related

BEST HADOOP REALTIME CERTIFICATION TRAINING FROM HYDERABAD,INDIA FOR FREE DEMO contact us : Email : [email protected] Phone/WhatsApp : +91-(850) 012-2107 In

BIGDATA/HADOOP LIVE HANDS-ON TRAINING[ONLINE & CORPORATE],INTERVIEW SUPPORT AND JOB SUPPORT @APE
Type
Offer
Contract type
Permanent
Name
SRI RAJA
Phone number
8500122107

Contact this User

It is NOT ok to contact this poster with commercial interests.
Reply to
[email protected]