To help you prepare for this exam, our instructor-led course 10777 describes how to implement a BI platform to support information worker analytics. In this course students will learn how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Course 10777 helps people prepare for the exam 70-463.

Audience Profile

The primary audience for this exam is ETL and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Their primary responsibilities may include:

Excellent Teacher, school facility, and books. Staff very helpful and available. CFR Class is the best training I have been in. The lab work is excellent and the system training is up to date and easy to use.

I have very little experience with web design, but I am confident in my new skills. IT is is best to have basic understanding of at least HTML, but the teachers are very knowledgable. Be sure to ask questions and practice. I learned a lot in such liitel time.

The instructor is the best thing about the school. The instructor is nice and great. The other two sub instructors are also nice. It was not easy for me to learn now things at my age but I did thanks to LIIT.

LIIT was very helpful in helping me to uderstand as well as use computers in a corporate environment. I definitely recommend this to all who are trying to get their foot in the door in the IT industry.

The LIIT Course was a positive experience both regarding to kowledge gained and the staff. The instructor was positive and always hellpful with the course and with the resume and job assistance I would recommend this school to anyone.

The director, Mr. Alam, allowed me to move to another room where there is less noise, which was amplified with my hearing aids, because disruptive to my training classes. His understanding was appreciated. The PROGRAM allowed progressing through the microsoft suite at your own pace; which was an advantage. The IT Support always responded to questions. The program will be a great tool in my employment search.

The instructors are wonderful and very helpful. They are willing to go the extra mile to assist and give you practical advise in attaining the knowledge to pursue your career goals. Mr. Alam provides you with the necessary resources to assist in your education. The rest is up to you! Take advantage of the opportunities provided.

First I want to thank you for this opportunity to be in this school; I t was a nice experience , and understood I was not alone, my classmates were very nice and our instructor is GREAT with knowledge and very helpful everytime and on every need. THANK YOU INSTRUCTOR and THANK YOU LASCOMP!

As a long time PM, with over 20+ years' experience, LIIT provided a strong curriculum in PMP training. I know that the training will rfeinforce my confidence and kills in moving forward PMP Certification.

I really like coming to this school, because the facility and teacher was very helpful to gain my knowledge and certification for microsoft. The teacher was very helpful and pleasant to work with and is the best teacher ever.

At first I was a little hesitant about LasComp's teaching style not being teacher led), but it turned out that it was a good thing. I was able to progress at my own speed and had the help of the teacher if I encountered difficulty.

The class was very informative and went at a good pace. There was a lot of interaction between members of the class which was helpful in reviewing the test questions. The teacher was very knowledgable and personable. I enjoyed the class and would recommend it.

Mr. Alam, Instructors and staff are very knowledgable, kind and bery helpful. I am glad that I picked lasComp Institute to enhance my computer skills and add a new career direction as a MAAS-Medical Administration Assistant. I would recommend this school for anyone looking to develop new skills.

The Classes were comprehensive and the instructor knowledgable. Although there were many students; the instructor always available whenever I needed help. She was and also very patient. Additionally, the atmosphere was friendly and relaxed.

Excellent program at a great location with an amazing instructor . I have learned so much in 2 months here than I have ever done in the last 5 years. I wish I could have done this sooner because so far best decision I've made.

The director is friendly helpful and knowledgable. Teachers were excellent. The facilties are state of the art and up to date. Very surprising how many computers there are for the students. You work and learn at your own pace. Teachers are very patient. My program was taught well. Sad to see it end.

The class is very easy to understand; the labs done during the classroom help understanmd everything faster. The professor taught very well and the school provided you with anything you needed to study for the exam.

Before I started at LIIT I asked who was the best IT School ground. The answer was LASCOMP and they they delivered what I was looking for. The Staff is awesome and now my future is bright. Thank you for the esteem boost.

I appreciate the "Learn at your own pace" format. I know it may not be everyones cup of tea, but if you need to slow down to pay more attention, you can or if you want to fly thorugh the sections that's an option (if you already know some of it, a taught" class may hold you back).

Class Conducted by teacher being available was helpful. Learned a lot of programs in short amount of time - Hope I am able to retain information for the future. Happy to know I am welcome back anytime - THANK YOU!

The Instructors is wonderful and knowsexcel very well. The Duration of the accounting & Bookkeeping class. Should be longer you can follow the book and speed thorough chapter and not retain much. Students needs to that the instructor to understand what they are doing.

Great School great teachers and Shams makes sure you are progressing and are take care of. The facilty is cozy and the equipment is new and functional. The way they have it set up enables the student to learn at their own pace. No pressure from the teachers or to finish, the environment is ideal to learn and master whatever course you decide. The AOSS class helped me learn new things with Microsoft Office that I would have never otherwise learned. Shams and the teachers are great team and this is the place to go if you want to actually learn something without the added stress that most schools place on you.

I had the opportunity to expand my knowledge in networking. The instructor was very knowledgable of the materials and very helpful especially the classroom with small amount of the student helped to have enough time to do question and answer.

Knowledgable teachers in a friendly, almore "FAMILY" environment. Equipment up to date and were maintained, other students easy to work with and Network together. I have had and overall positive experience.

Detailed step by step process of software programs and accounting fundamental principles. smaller classes provide more "One on One" individual training/assessmen from instructors. Great program for new or experienced in the accounting field.

During my time at LIIT, I have gained more knowledge of working with the programs dealing with Microsoft Office Applications and learning quickbooks. My instructor was very helpful nd knowledgable and patience. I would recommend LIIT school to others.

I had the opportunity to take the PMP class at LIIT with great intructor. It was great. Small class which allows for more interaction and personalized class. Our instructor was amazing and had great tips to help us pass the exam. Thank you for th opportunity.

Classes are great !!! HAving personally taught classes years ago, retention of learned & practical use is important. I feel more times on lengthy key chapters like, Cost or Time management are imperative to passing PMBOK standard questions. MS Project needs better integration & different teaching process. PROJECT needs to work.

I fealt really happy with my knowledge. I am more confident when I went looking for a new job position. The Teacher in this school are very professional and kind with the students. I am very happy to recommend lascomp to others.

The dynamics was excellent. The instructor added a lot of depth of knowledge from his PM experience. The instructor challenged us to think within the PMBOK(PMI) universe. This is a must for practical project managers.

Excellent class, great instructor. I am very happy that I chose lascomp to take this course. I will highly recommend the school to anyone wanting to take a class in preparation for Project Management certifications.

My Experience learning microsoft office and quickbooks pro at LIIT was wonderful. Not only did I learn a great deal, I also enjoyed the people/teachers who assisted me throughout the course. Very helpful, kind people and I enjoyed the entire experience.

I liked to study in he liit Montvale location very much. director of the achool Alam was very helpful during all my training. The teachers of all classes that I took were very knowledgeable. I had greatly improved my skills.

Mr. Alam has been flexible to allow students to go on job interviews, etc. He works with the students whenever possible. The instructors work in the industry and bring real life knowledge, tips, interview questions etc. to the class.

The School was very accomodating in working with students schedules. Encouraged class paticipation. They tried and succeeded in getting all of the students involved. They were able to do this due to small class size.

This class is very good. It provided me a loot of information about Project Manager's role, which I found out my previcious job had overlapped a lot of functionalization with PM. Now I'd have learned more. My experience on PM that would help me on the job interview. I wich this course would also cover some waterfall and agile concepts.

Teachers are very easy to talk to and very willing to help. Mr. Alam is very helpful and understanding. Classes are easy and you can take it at your own pace. Great place to make friends and clasmates help each other out.

The amount of software knowledge that I acquired during my 5 to 6 months training persued, Exceeded my expectation levels. Very satisfied with the there knowledge that I attaintd at LIIT. VERY SATISFIED.

Excellent School offering an Optional environment for student learning. Classes were Small with one on one assistance when needed. Instructors were great knowledge and well experienced. Thank you Alam for a great course.

I was very impressed by the knowledge & professionalism of the instructor, and the way he “led” the students through & studies discussions & testing, guiding how to understand the PMP rationale in testing.

Excellent Instructors! It was a pleasure attending class here. Mr. Alam was very responsive to all my needs. He worked with me in getting the classes which I wanted to learn. LIIT ( LasComp Institute of IT) helped me to get my new job!

The school "LasComp owned by Mr. Alam is a perfect place to learn and be certified. Thank you, to my teachers: Dr. Anand K. and Tom P., who tried their best to understand, guide and impart their knowledge to a student like me. I'm going to pass this good impression of mine to the students who will be interested to come and learn form their betterment in life.

I was impressed by the depth and knowledge of the instructor. I look forward to attending another class in the near future. The LasComp facility is comfortable and easily accessible. Classrooms are warms bright & the computer equipment is modern.

- Ana J.

Very well done. I liked the option of the fast paced course. I was able to get it done quick and still able to cover the dense material at a level of understanding.

In this place you will find people willing to help you throughout the process to make you awre marketble to find a job.

Thanks,

Program: Medical Administrative Assistant Specialist

- Paola C.

The overall course was excellent. I do think that discussions at times become too lengthy, students interjected too much. Oneremedy maybe the use of a projector that would create more of an audience atmosphere among students, tather than a one on one setup. A realted issue is that more time could be devoted to reviewing the several technical subject areas that constitute a large precentage of the exam.

- Mark F.

Instructors provided us with a lot of material. Instructors were very knowledgeable and patient with the students. Being allowed to retake classes at no additional cost is GREAT!!

mike was a very knowledgeable instructor. He is a professional, extremely polite and enjoyable lean from. However, I wish there was more of a coaching direction on how to do better on the pre-test so that I can gain more confidence for the SHRM exam. Excellent teacher.

The school “LasComp owned by Mr. Alam” is a perfect place to learn and be certified thank you, to my teacher. Dr. K. and Tom P., who tried their best to understood, guide& impart their knowledge to a student like me. I’m going to pass this good impression of mine to the students who will be interested to come and learn for their betterment in life

- Norma A.

Our instructor is extremely knowledgeable e and the heads on portion of the class really helped for better understanding of the practices.

- Joseph D.

The instructor was insightful and well prepared bringing real world scenario’s to the classroom. Having a professional network engineer teaching the class made it all worth while

LIIT (LasComp Institute of IT) was very helpful in extending my SQL server knowledge. The teacher was expert in SQL server and if he did not have answer he responded. Teacher aslo went the extra mile to help further knowledge.

This exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.The higher the percentage, the more questions you are likely to see on that content area on the exam.The information after “This objective may include but is not limited to” is intended to further define or scope the objective by describing the types of skills and topics that may be tested for the objective. However, it is not an exhaustive list of skills and topics that could be included on the exam for a given skill area. You may be tested on other skills and topics related to the objective that are not explicitly listed here.

Design and Implement a Data Warehouse (11%)

Design and implement dimensions.

This objective may include but is not limited to: design shared/conformed dimensions; determine if you need support for slowly changing dimensions; determine attributes; design hierarchies; determine whether you need star or snowflake schema; determine the granularity of relationship with fact tables; determine the need for auditing or lineage; determine keys (business transactional or your own data warehouse/surrogate keys); implement dimensions; implement data lineage of a dimension table

Design and implement fact tables.

This objective may include but is not limited to: design a data warehouse that supports many to many relationships; appropriately index a fact table; using columnstore indexes; partitioning; additive measures; semi additive measures; non additive measures; implement fact tables; determining the loading method for the fact tables; implement data lineage of a fact table; design summary aggregation tables

Extract and Transform Data (23%)

Define connection managers.

This objective may include but is not limited to: plan the configuration of connection managers; package level or project level connection manager; define a connection string; parameterization of connection strings

Design data flow.

This objective may include but is not limited to: define data sources and destinations; distinguish blocking and non-blocking transformations; use different methods to pull out changed data from data sources; determine appropriate data flow components; determine the need for supporting Slowly Changing Dimensions (SCD); determine whether to use SQL Joins or SSIS lookup or merge join transformations; batch processing versus row by row processing; determine the appropriate transform to use for a specific task; determine the need and method for identity mapping and deduplicating; fuzzy lookup, fuzzy grouping and Data Quality Services (DQS) transformation; determine the need for text mining; determine the need for custom data sources, destinations, and transforms; determine what to do with erroneous rows; determine auditing needs; determine sampling needs for data mining (advanced); trusted/authoritative data sources, including warehouse metadata

Implement data flow.

This objective may include but is not limited to: debug data flow; use the appropriate data flow components; SQL / SSIS data transformation; create SSIS packages that support slowly changing dimensions; use the Lookup task in SSIS; map identities using SSIS Fuzzy Lookup (advanced); specify a data source and destination; use data flows; different categories of transformations; read, transform & load data; understand which transforms to use to accomplish a specific business task; data correction transformation; performance tune an SSIS dataflow; optimize Integration Services packages for speed of execution; maintain data integrity, including good data flow

Manage SSIS package execution.

This objective may include but is not limited to: schedule package execution by using SQL Server Agent; execute packages by using DTEXEC; execute packages by using SQL Server Management Studio; implement package execution; plan and design package execution strategy; use PowerShell to execute script; monitor the execution using Manangement Studio; use DTEXECUI; ETL restartability

Implement script tasks in SSIS.

This objective may include but is not limited to: determine if it is appropriate to use a script task; extending the capability of a control flow; perform a custom action as needed (not on every row) during a control flow

Load Data (27%)

Design control flow.

This objective may include but is not limited to: determine control flow; determine containers and tasks needed; determine precedence constraints; design an SSIS package strategy with rollback, staging and transaction control; decide between one package or multiple packages; determine event handlers; determine variables; determine parameters on package and project level; determine connection managers and whether they are package or project level; determine the need for custom tasks; determine how much information you need to log from a package; determine the need for checkpoints; determine security needs

This objective may include but is not limited to: checkpoints; debug control flow; implement the appropriate control flow task to solve a problem; data profiling; use sequence containers and loop containers; manage transactions in SSIS Packages; managing parallelism; using precedence constraint to control task execution sequence; creating package templates; using the execute package task

Implement data load options.

This objective may include but is not limited to: implement a full and incremental data load strategy; plan for an incremental update of the relational Data Mart

Implement script components in SSIS.

This objective may include but is not limited to: create an SSIS package that handles SCD Type 2 changes without using the SCD component; work with Script component in SSIS; deciding when it is appropriate to use a script component versus a built in; source, transformation, destination component; use cases: web service source and destination, getting the error message

Configure and Deploy SSIS Solutions (24%)

Troubleshoot data integration issues.

This objective may include but is not limited to: performance issues; connectivity issues; execution of a task or tranformation failed; logic issues; demonstrate awareness of the new SSIS logging infrastructure; troubleshoot a failed package execution to determine the root cause of failure; troubleshoot SSIS package failure from an invalid datatype; implement break points; data viewers; profile data with different tools; batch cleanup

Install and maintain SSIS components.

This objective may include but is not limited to: software installation (IS, management tools); development box and server; install specifics for remote package execution; planning for installation (32 versus 64-bit); upgrade; provisioning the accounts; creating the catalog

Implement auditing, logging, and event handling.

This objective may include but is not limited to: audit package execution by using system variables; propagate events; use log providers; log an SSIS execution; create alerting and notification mechanisms; use Event Handlers in SSIS to track ETL events and errors; implement custom logging

Deploy SSIS solutions.

This objective may include but is not limited to: create and configure an SSIS catalog; deploy SSIS packages by using the deployment utility; deploy SSIS packages to SQL or file system locations; validate deployed packages; deploy packages on multiple servers; how to install custom components and tasks; deploy SSIS packages by using DTUTIL

Configure SSIS security settings.

This objective may include but is not limited to: SSIS catalog database roles; package protection levels; secure Integration Services packages that are deployed at the file system; secure Integration Services parameters, configuration

Build Data Quality Solutions (15%)

Install and maintain Data Quality Services.

This objective may include but is not limited to: installation prerequisites; .msi package; adding users to the DQ roles; identity analysis, including data governance