MS BI, also known as Microsoftās Business Intelligence is the ultimate solution for the development of corporate level Data Management and Decision Making systems. MS BI is very helpful and plays significant role in day to day operations of SQL Server professionals. MS BI fulfills the corporate needs such as data warehousing, analysis and reporting. Looking out to be an MS BI professional? Register with us @ Bilytica
There could be many software online trainingcenters for the students and professionals to obtain knowledge in latest technologies that could enhance their growth in terms of career building. If you want to opt for MS BI online training, please visit www. bilytica.com which is the perfect place for you that give you a rewarding experience of learning MS BI. We provide MS BI online training to the working professionals and students through immensely experienced trainers from the industry.
We the Best Online Trainers are dedicated online training partners in making our students into perfect MS BI professionals assuring the best quality training in the training industry in handling multiple online training courses. Besides, we also provide the well drafted MS BI online training material that makes you a perfect MS BI professional.
MS BI Online Training course details
MSBI
SQL Server 2005 Analysis Services
- What Is Microsoft BI?
- 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
OLAP Modeling
- 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ā¦
Using SSAS in BIDS
- 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
Intermediate SSAS
- KPIs
- Perspectives
- Translations ā cube metadata and currency localization
- Actions ā regular, drill-through and reporting
Advanced SSAS
- 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
Cube Storage and Aggregation
- 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
Beginning MDX
- Basic syntax
- Using the MDXĀ query editor in SQL Server Management Studio
- Most-usedĀ Functions & Common tasks
- New MDXĀ functions
Intermediate MDX
- Adding calculatedĀ members
- Adding scripts
- Adding named sets
- .NET Assemblies
SSAS Administration
- Best practices āĀ health monitoring
- XMLA scriptingĀ (SQL Mgmt Studio)
- OtherĀ Documentation methods
- Security ā rolesĀ and permissions
- DisasterĀ Recovery ā backup / restore
- Clustering āĀ high availability
Introduction to Data Mining
- 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
Introduction to Reporting Clients
- Excel 2003 PivotĀ Tables
- SQL RS &Ā Report Builder
- SPS RS web partsĀ & .NET 2.0 report viewer controls
- BusinessĀ Scorecards 2005 & ProClarity
Future Directions ā Integration with Office 12
- SharePoint 12Ā Ā and AS
- Report CenterĀ (type of dashboard) uses KPIs, Reports, Excel Web, Filter
- Excel Services12 and AS (Web Services)
SQL Server 2005 Integration Services
Introduction to SQL Server Integration Services
- Product History
- SSIS PackageĀ Architecture Overview
- Development andĀ Management Tools
- Deploying andĀ Managing SSIS Packages
- Source ControlĀ for SSIS Packages
SSIS for DBAs: Using SQL Server Management Studio
- 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
Business Intelligence Development Studio
- Launching BIDS
- ProjectĀ templates
- The packageĀ designer
- The Toolbox
- SolutionĀ Explorer
- The PropertiesĀ window
- The VariablesĀ window
- The SSIS menu
Introduction to Control Flow
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
- The FTP Task
- The Send Mail Task
Advanced Control Flow
- Containers ā grouping and looping
- The Web ServiceĀ Task
- The WMI tasks
- The AnalysisĀ Services tasks
- The ExecuteĀ Process Task
- The ExecuteĀ Package Task
Introduction to Data Flow
- 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 and Configurations
- 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
Debugging, Error Handling and Logging
- 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
Advanced Data Flow
- 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
Extending SSIS through Custom Code
- 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
SSIS Package Deployment
- ConfigurationsĀ and deployment
- The deploymentĀ utility
- DeploymentĀ options
- DeploymentĀ security
- ExecutingĀ packages ā DTExec and DTExecUI
SSIS Package Management
- The SSIS Service
- ManagingĀ packages with DTUtil
- ManagingĀ packages with SQL Server Management Studio Scheduling packages with SQL Ā Ā Ā Ā Server Agent
SQL Server 2005 Reporting Services
Introduction to SQL Server Reporting Services
- Tour of Features
- ReportingĀ Services Architecture
- ReportingĀ Services Terminology
- ReportingĀ Services Editions
- Taking ReportingĀ Services for a Spin
Creating Reports
- DeconstructingĀ Reporting Services
- Shared DataĀ Sources
- Creating ReportsĀ from Scratch
Calculations and Formatting
- CreatingĀ Expressions
- Using the GlobalĀ Collections
- Formatting Items
- ConditionalĀ Formatting
Grouping and Sorting
- Creating Groups
- CalculatingĀ Totals and Percentages
- InteractiveĀ Sorting
- CreatingĀ Drill-Down Reports
Report Parameters
- Creating ReportĀ Parameters
- CreatingĀ Drop-Down Parameters
- Multi-ValuedĀ Parameters
- DebuggingĀ Parameter Issues
Creating Matrix Reports and Charts
- Creating a BasicĀ Matrix Report
- Matrix Subtotals
- Creating a BasicĀ Chart
- Exploring theĀ Charting Possibilities
Managing Reporting Services
- DeployingĀ Reports and Data Sources
- ExportingĀ Reports and Printing
- Using theĀ Ā Web-Based Report Manager
- Using SQL ServerĀ Management Studio-based Reporting Services Manager
Reporting Services Security
- Two Parts toĀ Reporting Services Security
- Securing AccessĀ to Reports
- Data SourceĀ Security
Programming Reporting Services
- The ManyĀ Reporting Services APIs
- IntegratingĀ Reporting Services into Applications using URL Access
- Using the ReportĀ Viewer Controls
Advanced Reporting Services Programming
- Using theĀ Reporting Services Web Service
- Working withĀ Custom Assemblies
Snapshots and Subscriptions
- Caching andĀ Snapshots
- CreatingĀ Standard Subscriptions
- CreatingĀ Data-Driven Subscriptions
- ManagingĀ Subscriptions
Ad-Hoc Reporting with Report Builder
- The ReportĀ Builder Architecture
- Creating ReportĀ Model Projects
- Running ReportĀ Builder