UrbanPro
true

Microsoft Business Intelligence, SSAS, SSIS, SSRS

LIVE
Ongoing

Course offered by Pankaj Rana

7 reviews
SSIS: Architecture and Introduction to SQL Server Integration Services. Designing and Implementation of SSIS packages. Designing and Implementation of Control Flow & Data Flow. Debugging and Managing Package Execution. Detecting and Handling Processing Errors. Securing and Deploying SSIS Packages. SSAS : Understanding BI and Data warehousing Architecture and Understanding Analysis Services Designing and Creating Dimensions. Designing Measures, Measure Group and Aggregations. Implementing Security and Managing Deployment. SSRS : Architecture and Introduction to SQL Server Reporting Services. Designing and Implementation of Reporting Services Projects. Use report models to implement reporting for business users. Configure report publishing and execution settings. Implementing subscription for reports.

Topics Covered

SSIS Course Objectives: 16Hrs Module 1: Architecture and Introduction to SQL Server Integration Services Need for SSIS SSIS and DTS Comparison SSIS Architecture Control Flow Architecture Data Flow Architecture Data Pipeline Usage Precedence Constraints SSIS Event Handler SSIS Components SSIS Development Studio - BIDS SSIS Runtime Services SSIS Package Deployment SSIS Folders and File Structure Module 2: Designing and Implementation of SSIS packages SSIS Data Types, SSIS Variables, Connection Managers Data Flow Tasks usage SSIS Expressions Module 3: Designing and Implementation of Control Flow & Data Flow. Control Flow For Loop Container For each Loop Container Sequence Container Bulk Insert Task Data Flow Task Execute Package Task Execute SQL Task File System Task FTP Task Script Task Send Mail Task Transfer Database Task WMI Data Reader Task WMI Event Watcher Task XML Task Maintenance Plan Task Backup Database Task Shrink Database Task. Row Transformation: Character Map Transformation Copy Column Transformation Data Conversion Transformation Derived Column Transformation Script Component Transformation OLEDB Command transformation Rowset Transformation: Aggregate Transformation, Sort Transformation, Percentage Sampling Transformation, Row Sampling Transformation, Pivot Transformation, Unpivot Transformation Other Transformation Export Column, Import Column, Audit, Row Count, Slowly Changing Dimension Data Flow Task Split and Join Transformation Understanding of Extraction, Transformation, Loading Conditional Split, Multicast, Merge, Merge Join, Union All, Lookup Data Flow Sources Data Quality Transformation ADO NET Source, Excel Source Flat File Source, OLE DB Source, XML Source Fuzzy Lookup, Fuzzy Grouping Data Mining Transformation Data Mining Query, Term Extraction, Term Lookup Synchronous and Asynchronous Transformation SSIS Expression Data Sources Module 4: Debugging and Managing Package Execution Debugging Control Flow Debugging Data Flow Debugging Script Task Packaging Configuring XML File Configuring Multiple Configuring File, Package Logging Module 5: Detecting and Handling Processing Errors Error Handling Basic Error Detection and Handling Understanding of Event Handler Maintaining Data Consistency with Transactions Checkpoint, Checkpoint Restarts and Transaction Module 6: Securing and Deploying SSIS Packages Creating Deployment Utility, Securing Package Role – Based Security, Deployment Option Monitoring Package Execution and Event Logs Optimizing SSIS Packages Best Practices in SSIS, Real Time Scenario Discussion, Mock Project - 1 – Automation Legend: Students/Trainees should know/Aware before attending this course Basic SQL Server knowledge, SQL Server Run Time Services, SQL Server Agent After completion of this tool, Students will able to Handel the ETL Process, Design SSIS Package etc SSAS Course Objectives 16hrs Module 1: Understanding BI and Data warehousing Data warehouse concepts, Data warehouse Architecture Difference between Ralph Kimball and Bill Inmon’s What is Business Intelligence? Difference between OLTP vs. OLAP Module 2: Architecture and Understanding Analysis Services Understanding of OLAP, MOLAP, ROLAP What is SSAS? Need for SSAS SSAS Architecture Understanding of CUBE Structure Understanding of Schemas (Star, Snowflake) Data Source usage, Data Source View Computed and Named Queries Module 3: Designing and Creating Dimensions Understanding of Dimension Table Creating Dimension Table Understanding of Parent – Child Dimension Building Levels, Understanding of Fact Table Creating Fact Table Module 4: Designing Measures, Measure Group and Aggregations Measures and Additives, Semiadditive Measures Understanding of Aggregation Designing User Hierarchies Optimizing Aggregation, Query Log Usage Based Optimization Cube Operations – Dimension usage and Flexible cubes Building Fact-Dimension, Creating Calculation, MDX Scripting for Calculation Defining KPI’s and usage Partitioning, Perspective and usage What is MDX? Need of MDX MDX Basics, Complex MDX Queries, MDX Functions What is Data mining? Need for Data Mining Data mining structures and Algorithm Data mining levels, operating predictions Prediction Functions and Analysis Module 5: Implementing Security and Managing Deployment Using Role based security, Object level access Drill through Security, Windows Level Authentication, Security Audits. Deployment phases: OLAP Database Backups, Compression and Encryptions Restore Option, Write – Backs in Cube Automating Database Processing using SSIS Verification Techniques Managing Deploy Process Best Practices in SSAS, Real Time Scenario Discussion, Mock Project - 1 After completing of this course students will able to do: Design CUBE -OLAP DB SSRS Course Objectives 8hrs Module 1: Architecture and Introduction to SQL Server Reporting Services. Understanding of Reports, Introduction to SSRS, Need for SSRS Reporting Services SSRS three phase Lifecycle . SSRS Architecture Reporting components, Tools, Web Service Requirements and usage SSRS and IIS, and SQL Server Web Services Requirement for Virtual Directories Module 2: Designing and Implementation of Reporting Services Projects Report planning, Data Sources, Enterprise and Adhoc-reports Optimizing Data Sources Configuring connection and Data providers SSRS Expression, Parameter and Multi valued Parameter Filters in Data source Report Designer: Wizard based reports, custom reportsUsing Table and Matrix Chart based report and images Sub Reports, Reporting Option, Tabular Reports Exporting Reporting data Module 3: Use report models to implement reporting for business users Understanding of Report models Designing Report models Identifying Entities Identifying different Attributes Numerical Aggregation, Time Aggregation Module 4: Configure report publishing and execution settings Deployment Option Build and Deploy, publishing reports Configuration Option Managing Configuration Files Module 5: Implementing subscription for reports Creating Standard Subscription Data Driven Subscription Subscription Logging options Benefits of SSRS Logging Server Level Logging Options Report level logging Audit reports execution Best Practices in SSRS, Real Time Scenario Discussion, Mock Project – 1 After completing of this course students will able to do: Design Reports, publish reports subscription of the reports. After completing of MSBI course students will able to give solution to Business and handle the MSBI Projects, will become MSBI Developer

Who should attend

Any graduates, Masters, working professionals, looking for career in business intelligence..

Pre-requisites

Knowledge of SQL Server

What you need to bring

Note book, Laptop

Key Takeaways

Best knowledge on all the concepts of MSBI, integration , Reporting and Analysis, Real time hand on challenges handling..

Gallery (2)

Intro Video

About the Trainer

3.9 Avg Rating

7 Reviews

6 Students

7 Courses

Experienced working professionals/ industry experts
Working on real time on Hadoop
Having a vast experience of Implementation experience
Prepares you to write any certification applicable

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Microsoft Business Intelligence, SSAS, SSIS, SSRS by Pankaj Rana

GITS Academy picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Microsoft Business Intelligence, SSAS, SSIS, SSRS by Pankaj Rana

GITS Academy picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more