MSBI Online Training Course Content
Course Duration :45 Hours
SQL Server 2008 Analysis Services
- Core concept – BI is the cube or UDM
- Example cube as seen using Excel pivot table
- MS BI is comprehensive – more than Analysis Services on SQL Server
- Demonstration of SQL Reporting Services with cube as data source
- Modeling source schemas—stars and snowflakes
- Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
- Understanding fact (measures) and cube modeling
- Other types of modeling—data mining etc…
- Understanding the development environment
- Creating Data Sources and Data Source Views
- Creating cubes – using the UDM and the Cube Build Wizard
- Refining Dimensions and Measures in BIDS
- KPIs
- Perspectives
- Translations – cube metadata and currency localization
- Actions – regular, drill-through and reporting
- Using multiple fact tables
- Modeling intermediate fact tables
- Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
- Modeling changing dimensions – Dimension Intelligence w/ Wizard
- Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence
- Storage topics – basic aggregations, MOLAP
- Advanced Storage Design – MOLAP, ROLAP, HOLAP
- Partitions – relational and Analysis Services partitions
- Customizing Aggregation Design – Processing Design
- Rapidly changing dimensions / ROLAP dimensions
- Welcome to the Real Time – Proactive Caching
- Cube processing options
- Basic syntax
- Using the MDX query editor in SQL Server Management Studio
- Most-used Functions & Common tasks
- New MDX functions
- Adding calculated members
- Adding scripts
- Adding named sets
- .NET Assemblies
- Best practices – health monitoring
- XMLA scripting (SQL Mgmt Studio)
- Other Documentation methods
- Security – roles and permissions
- Disaster Recovery – backup / restore
- Clustering – high availability
- What and why?
- Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS
- Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
- Data Mining dimensions
- Data Mining clients
- Processing mining models
- Excel 2003 Pivot Tables
- SQL RS & Report Builder
- SPS RS web parts & .NET 2.0 report viewer controls
- Business Scorecards 2005 & ProClarity
- SharePoint 12 and AS
- Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
- Excel Services 12 and AS (Web Services)
- Product History
- SSIS Package Architecture Overview
- Development and Management Tools
- Deploying and Managing SSIS Packages
- Source Control for SSIS Packages
- The Import and Export Wizard
- Importing and Exporting Data
- Working with Packages
- Database Maintenance Plans
- Creating Database Maintenance Plans using SSMS
- Scheduling and Executing Plans
- Examining Database Maintenance Plan Packages
- Changes in SQL Server 2005 Service Pack 2
- Launching BIDS
- Project templates
- The package designer
- The Toolbox
- Solution Explorer
- The Properties window
- The Variables window
- The SSIS menu
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
- The FTP Task
- The Send Mail Task
- Containers – grouping and looping
- The Web Service Task
- The WMI tasks
- The Analysis Services tasks
- The Execute Process Task
- The Execute Package Task
- Data Flow Overview
- Data Sources
- Data Destinations
- Data Transformations
- The Copy Column Transformation
- The Derived Column Transformation
- The Data Conversion Transformation
- The Conditional Split Transformation
- The Aggregate Transformation
- The Sort Transformation
- Data Viewers
- Variables Overview
- Variable scope
- SSIS system variables
- Using variables in control flow
- Using variables in data flow
- Using variables to pass information between packages
- Property expressions
- Configuration Overview
- Configuration options
- Configuration discipline
- SSIS debugging overview
- Breakpoints in SSIS
- SSIS debugging windows
- Control Flow: The OnError event handler
- Data Flow: Error data flow
- Configuring Package Logging
- Built-in log providers
- Revisiting data sources and destinations
- The Lookup Transformation
- Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
- The Multicast Transformation
- The Merge and Merge Join Transformations
- The Data Mining Query Transformation
- The Data Mining Model Training Destination
- The Slowly Changing Dimension Transformation
- Introduction to SSIS scripting
- The SSIS script editor
- The SSIS object model
- Script in Control flow: The Script Task
- Script in Data flow: The Script Component
- Introduction to SSIS component development
- Configurations and deployment
- The deployment utility
- Deployment options
- Deployment security
- Executing packages – DTExec and DTExecUI
- The SSIS Service
- Managing packages with DTUtil
- Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent
- Tour of Features
- Reporting Services Architecture
- Reporting Services Terminology
- Reporting Services Editions
- Taking Reporting Services for a Spin
- Deconstructing Reporting Services
- Shared Data Sources
- Creating Reports from Scratch
- Creating Expressions
- Using the Global Collections
- Formatting Items
- Conditional Formatting
- Creating Groups
- Calculating Totals and Percentages
- Interactive Sorting
- Creating Drill-Down Reports
- Creating Report Parameters
- Creating Drop-Down Parameters
- Multi-Valued Parameters
- Debugging Parameter Issues
- Creating a Basic Matrix Report
- Matrix Subtotals
- Creating a Basic Chart
- Exploring the Charting Possibilities
- Deploying Reports and Data Sources
- Exporting Reports and Printing
- Using the Web-Based Report Manager
- Using SQL Server Management Studio-based Reporting Services Manager
- Two Parts to Reporting Services Security
- Securing Access to Reports
- Data Source Security
- The Many Reporting Services APIs
- Integrating Reporting Services into Applications using URL Access
- Using the Report Viewer Controls
- Using the Reporting Services Web Service
- Working with Custom Assemblies
- Caching and Snapshots
- Creating Standard Subscriptions
- Creating Data-Driven Subscriptions
- Managing Subscriptions
- The Report Builder Architecture
- Creating Report Model Projects
- Running Report Builder
Highlights of MSBI Online Training:
- MSBI Real Time Project Support and Documentation:- MSBI Real-time project support related design and migration and function setup documentation also teach under training
- Interview Skills based on MSBI:- Mark interview conducted on every week and provide more than 500+ interview questions by end of course
- MSBI Certification Support:-Providing MSBI certified training, 50+ learner certified through RamJS Technologies in MSBI technology.
- MSBI Resume Preparation: – Based on learner experience we helps him to show his confidence through resume. We will help you to prepare to shortlist resumes.
- Small Training Batch:-One to one session will arrange by RamJS Technologies for learner comfortability.
- MSBI Practical Guidance:- Everyday tasks and practical exercises as homework
- 12+ Years of Real-time BI architect Experience in IT Industry
- Worked on MSBI certified professional with various Great MNC’s
- Real-time project oriented training with step-by-step Scenarios.
- Technical and functional and migrations and security design Documentation approaches
- Covering the Pre-requisites for learning MSBI
- Completed 250+ coaching Assignment around 800 students
The MSBI training contains all real time industry standards with ERP and multiple domains.