Microsoft BI Training Program
Course Completion
Training Certificate is Govern By 12 Global Associations.
Training Certificate is Powered by “Wipro DICE ID”
Training Certificate is Powered by "Verifiable Skill Credentials"
Key Highlights
140 Hrs Live Sessions
50+ Live sessions across 6 months
Free integrated labs
AWS select technology partner
No-cost EMI Option available
Placement Assistance
2 Capstone Projects
Certification from Microsoft
Live virtual classes led by industry experts
24*7 Support
Frequently Asked Questions
SQL Server Reporting Services (SSRS)
SQL Server Reporting Services (SSRS)
- Overview of SQL Server Reporting Services
- Installing Reporting Services
- Reporting Services Tools
Authoring Basic Reports
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
Enhancing Basic Reports
- Interactive Navigation
- Displaying Data
- Manipulating Data Sets
Defining Reports Data
- Using Parameters and Filters
- Using Parameter Lists
Using Report Models
- Creating Report Models
- Using Report Builder
Publishing and Executing Reports
- Publishing Report
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
Using Subscriptions to Distribute Reports
- Introduction to Report Subscription
- Creating Report Subscriptions
- Managing Report Subscriptions
Administering Reporting Services
- Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
Programming Reporting Services
- Querying for Server Information Using a Web Service
- Automation Report Management
- Rendering Reports
- Creating Custom Code
SQL Server
- Introduction to SQL Server
- Introduction to T-SQL
- Constraints
- Joins
- Functions
- Views
- Indexes
- Stored Procedures
- Cursors
- Triggers
- Difference Between Oracle & SQL Server
- SQL Queries
SQL Server Integration Server (SSIS)
SQL Server Integration Services (SSIS)
- Overview of Integration Services Solutions
- Integration Services Tools
Developing Integration Services Solution
- Creating an Integration Services Solution
- Using Variables
- Building and Running a Solution
Implementing Control Flow
- Control Flow Tasks
- Control Flow Precedence Constraints
- Control Flow Containers
Implementing Data Flow
- Data Flow Sources and Destinations
- Data Flow Transformations
- Data Flow Paths
Implementing Logging, Debugging and Error Handling
- Overview of Integration Services Logging
- Implementing Logging
- Debugging a Package
- Implementing Error Handling
Implementing Checkpoints & Transactions
- Implementing Checkpoints
- Implementing Transactions
Deploying Packages
- Package Configurations
- Deploying Packages
Managing and Securing Packages
- Managing Packages
- Securing Packages
- Scheduling Jobs
SQL Server 2008 Analysis Services (SSAS)
SQL Server 2008 Analysis Services (SSAS)
- Overview of Data Analysis Solutions
- Overview of SQL Server 2005 Analysis Services
Creating Multidimensional Analysis Solutions
- Developing Analysis Services Solutions
- Data Sources and Data Source Views
Working with Dimensions
- Configuring Dimensions
- Defining Hierarchies
- Sorting and Grouping Attributes
Working with Measures
- Working with Measure Groups
Analytical MDX
- Analytical MDX Introduction
- MDX Queries
- MDX vs. SQL
- MDX Stored Procedures
- Adding Calculations to a Cube
Customizing Cube Functionality
- Implementing Key Performance Indicator
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
Deploying and Securing an Analysis Services Database
- Deploying an Analysis Service Database
- Securing an Analysis Services Database
Maintaining a Multidimensional Solution
- Configuring Processing Settings
- Logging, Monitoring and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
Certification of Completion
Upon successfully completing the Microsoft BI Training Program, participants will be awarded a globally recognized training certificate, which is:
- Governed by 12 Global Associations for international validation
- Powered by “Wipro DICE ID” for secure digital identity verification
- Backed by Verifiable Skill Credentials, making it employer-trusted and shareable
Instructors
Julian Melanson
503,062 Students
7 Courses
10 Experience
I’m Angela, I’m a developer with a passion for teaching. I’m the lead instructor at the London App Brewery, London’s leading Programming Bootcamp. I’ve helped hundreds of thousands of students learn to code and change their lives by becoming a developer. I’ve been invited by companies such as Twitter, Facebook and Google to teach their employees.
My first foray into programming was when I was just 12 years old, wanting to build my own Space Invader game. Since then, I’ve made hundred of websites, apps and games. But most importantly, I realised that my greatest passion is teaching.
Enroll Our Course
Course Schedule
Training Timeline
Related Courses
