Learn MSBI Programming in Ireland and UK from Professional trainers. Course starts from €400 or £335 or $425. Choose timings at your convenience.
About the Course
Course Objective
Course Features
Certification
Reviews
MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries.
ChartTics offers real time and practical MSBI training Online in Dublin, Ireland and UK , Live Instructor-led Online training and Video training will advance your career as Business Intelligence Developer or Analyst.
After the completion of course at ChartTics, you will be able to:
- Learn how to create ETL jobs using SSIS.
- Create reports using SSRS.
- Create cubes and administer them using SSAS.
- Online Courses: 30 Hours
- Assignments: 20 Hours
- Project: 15 Hours
At the end of your course, you will work on a real time Project. Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading.
If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.
RATING
REVIEWS
|
Submit your review
|
|
|
|
|
ChartTics
Average rating:
4 reviews
Jan 16, 2017
BI Consultant at BSkyb, UK
MSBI course was absolutely great. Instructor taught all the concepts thoroughly and he is very knowledgeable, clarified and answered all the questions.
Jan 16, 2017
Data Migration Consultant at Vodafone, UK
The course was really helpful for me to understand the concepts from beginning to end. The instructor was so knowledgeable, patient. There was never any technical issue like audio/video/connectivity and the classes were very smooth
Jan 16, 2017
Consultant at Admiral UK
ChartTics is best in my experience. Once joined you will come to know what a good decision you have made to improve your career.The course was so comprehensive and practical. Both the Assignments in between the course and the final project all made me an experienced developer now.
Jan 16, 2017
Business Data Analyst, TSB, UK
The MSBI course curriculum is really good and the training was awesome.Interactive learning classes, knowledgeable instructors and great support staff is the added advantage for people.
COURSE FEES
Online Training
€400
- Instructor led Online
- Interactive Training
Classroom Training
€700
- Classroom in Dublin
- Interactive Training
1-to-1 Online
€700
- Instructor led Online
- One-to-One Training
COURSE CONTENT
Section 1SQL Server Integration Services (SSIS)
Lecture 1Introduction to SSIS Packages and Legacy DTS Packages
Lecture 2Introduction of (BIDS) and Explanation of All tool boxes, Solution Explorer, Package variables
Lecture 3Import and Export Wizard, Control Flow and Dataflow tasks
Lecture 4Control Flow tasks like Execute SQL Task, BULK insert tasks, File System tasks , The FTP Task and Send mail
Lecture 5Dataflow tasks and transformations introduction
Lecture 6Data sources, Data transformations, Copy column Transformation, Derived Column transformation,
Lecture 7Slowly Changing Dimension (SCD) Concepts and its Transformations.
Lecture 8Debugging, Error Handling and Logging
Lecture 9How to implement Check points.
Lecture 10SSIS Package Deployment and Package Management
Section 2SQL Server Analysis Services (SSAS)
Lecture 11 Introduction to Data Warehousing, OLTP, OLAP, Star Schema
Lecture 12Understanding Dimension Modeling
Lecture 13Creating Data source and Data source views
Lecture 14Creating the Cube through Wizard and through UDM.
Lecture 15Creating the Cube through Wizard and through UDM.
Lecture 16Creating Dimensions and Measures in SSAS and how to add those in Cube.
Lecture 17Partitions and Aggregations Design in cube and Processing Options in cube
Lecture 18How to do Slice and Dice in the Cube .
Lecture 19Key Performance Indicators(KPI) , Perspectives and Translations
Lecture 20Full Coverage of MDX and its functions from Basics to Advanced
Section 3SQL Server Reporting Services (SSRS)
Lecture 21SSRS Architecture and how to configure SSRS
Lecture 22What is Shared Data source
Lecture 23How to Create an Ad-hoc Report from Wizard
Lecture 24Creating Expressions and Conditional Formatting
Lecture 25Creating Report Parameter and Debugging Parameter issues.
Lecture 26How to create a Basic Matrix Report , Tablix Report and Charts.
