- Home
- Courses
- Business Intelligence
- Microsoft Business Intelligence
Microsoft Business Intelligence Training and Certification Course In Pune

Duration of course: 40 hrs
Best Blended Syllabus for Microsoft Business Training in Pune by a 100% Placement-Oriented Training Institute
Instructor-led MSBI Live Online Training
Don't Wait for IT!
Let's Build a Great Career in IT!
Our Candidate's Placement Record!
Book Your Seat Now ! At just ₹2000!
No Cost Two Easy Installments!
Can’t find a batch you were looking for?
Microsoft Business Intelligence Training Course
Best Blended Syllabus for Microsoft Business Intelligence Training in Pune by a 100% Placement-Oriented Training Institute
- Datawarehousing Basics
- Product History
- SSIS Package Architecture Overview
- Development and Management Tools
- 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, 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
- The Import and Export Wizard
- Importing and Exporting Data
- Scheduling and Executing Plans
- 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 Slowly Changing Dimension Transformation
- Transaction Handling in SSI
- Check Point configurations
- 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
- Overview of SQL Server Analysis Services
- Installing SQL Server Analysis Services
- 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
- Creating Data Sources and Data Source Views
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attribute
- Creating cubes
- Refining Dimensions and Measures in BIDS
- KPIs
- Perspectives
- Translations – cube metadata and currency localization
- Partitions
- Storage topics – basic aggregations, MOLAP, ROLAP, HOLAP
- Aggregations
- Using the MDX query editor in SQL Server Management Studio
- Most-used Functions & Common tasks
- New MDX functions\
- Securing a cube
- Deployment and processing the CUBE
- 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
Microsoft Business Intelligence Training Completion Certificate
To Obtain The Microsoft Business Intelligence Training Course Completion Certification,You Have To Fulfill The Following Criteria
- Complete the Microsoft Business Intelligence Training Course Online/Classroom Training
- You can attend multiple batches of the same trainer & complete the Microsoft Business Intelligence Training
- Completion of all exercises, assignments & capstone project.
150+
Batches Completed
Industry Oriented Syllabus
Designed By Expert
2000+
Happy Students
Self Assessments
Quizzes, POC
8+
8+ Years Of Experience
Recorded Sessions
1 Year Of Access
Microsoft Business Intelligence Training Completion Certificate
GET CERTIFIED ON COURSE COMPLETION
Course Benefits
- No prerequisite
Cloud based cluster available for hands on practice
Course designed for non-IT as well as IT professionals
Flexible batch switch is available
Placement assistance in MNC
Classroom & Online Training – Can switch from online training to classroom training with nominal fee
Working professional as instructor
Proof of concept (POC) to demonstrate or self-evaluate the concept or theory taught by the instructor
100% placement calls guaranteed till you get placed
Interview Preparation Support
Resume Building & Mock Interview
Evaluation after each Topic completion
Hands-on Experience with Real-Time Projects
STAY TUNED WITH US
Let's begin a dialogue with our career concealer!

About Course
Technogeeks's AWS classes in Pune follow a structured cloud computing methodology to get real-time insights on AWS core capabilities and Services.
Our IT training institute instructors are well established cloud professionals and have in-depth experience in AWS cloud computing.The course is outlined to get the most out of the course to start a decent, excellent career in the IT industry after course completion at our training institute in Pune
The course is designed to help you understand AWS architectural principles and services. With this AWS training, you will learn how cloud computing redefines the rules of IT architecture and how to design, and scale AWS Cloud implementations with best practices recommended by Amazon.
- Batches Completed – 150+
- Students - 2000+
- Course Duration: 40 Hours
- 30+ Assignments with 2 Real time Projects
- Assignment Duration: 30 hours
- Modules: 23
Training Projects
FAQ
Yes, you can attend demo session before you enroll either we can provide you the recorded lecture so that you can watch it as per your schedule or you can attend live demo lecture either online or offline
Yes, we do provide the placement assistance in which how we work on real time projects will be taught,resume preparation and Job openings will also be provided.More than 80% of candidates have changed their profile by getting either promotion or getting new job offers on good package.
Checkout our Telegram Channel for Placement Assistance (Open in Mobile Browser): https://t.me/technogeekssolutions
If you miss classes, you can get recording sessions of the lectures.
Testimonial Review
CONTACT US TO DISCUSS HOW WE CAN HELP YOU.
Our candidates are working with





