Microsoft MCSA: SQL Server 2016 - Business Intelligence Development - Only 5 Days

Seven reasons why you should sit your MCSA Business Intelligence Dev course with Firebrand Training

Find Out How We Help You To Learn New Skills Quickly

  1. You'll be MCSA Business Intelligence Dev certified in just 5 days. With us, you’ll be MCSA Business Intelligence Dev trained in record time
  2. Our MCSA Business Intelligence Dev course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
  3. Pass MCSA Business Intelligence Dev first time or train again for free. This is our guarantee. We’re confident you’ll pass your course first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  4. You’ll learn more MCSA Business Intelligence Dev. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  5. You’ll learn MCSA Business Intelligence Dev faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  6. You’ll be studying MCSA Business Intelligence Dev with the best. We’ve been named in Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified 65,143 professionals, and we’re partners with all of the big names in the business
  7. You'll do more than study MCSA Business Intelligence Dev courseware. We use practical exercises to make sure you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

When do you want to sit your accelerated course?

Start

Finish

Status

Book now

Finished

 

Open

Book now

Open

Book now

Open

Book now

Here's the Firebrand Training review section. Since 2001 we've trained exactly 65,143 students and asked them all to review our Accelerated Learning. Currently, 96.55% have said Firebrand exceeded their expectations:



"Excellent training. For anyone planning to take certification it's helpful and intensive. This training helped me understand the new features of the software and how to use those for performance improvement of our data model."
Brinda Jana, British Red Cross. - Microsoft MCSA: SQL Server 2016 - Business Intelligence Development (5 days) (2017.3.6 to 2017.3.10)

"Firebrand taught me 2 months ago for a networking course and was just as good this time, highly recommend Firebrand. Until next time!"
Jordan Duncan, LSI Architects. - Microsoft MTA Security Fundamentals (2 days) (2017.10.6 to 2017.10.7)

"This is now the 3rd time I have attended a Firebrand course and still cannot fault them. Each instructor I've had has been extremely knowledge and helpful. I have recommended FB to many colleagues."
Laura OConnor, Utilita Energy Limited. - Microsoft MTA Security Fundamentals (2 days) (2017.10.6 to 2017.10.7)

"The course was intensive with a lot to take in during a short period but you have every resource you need. Great Staff, great atmosphere and you get well looked after too. I'll be back!"
D.W.. - Microsoft MCSE: Messaging (Exchange 2016) (6 days) (2017.10.2 to 2017.10.7)

"Excellent tutor, all explained clearly and in detail."
Arkadiusz Rycyk, Environ Audio Ltd. - Microsoft Specialist: Programming in C# (4 days) (2017.10.2 to 2017.10.5)

"The teaching was dynamic, engaging, immersive and knowledgeable. The instructor made complex concepts simple. I enjoyed the course very much. "
Richard Barnes, Whale Tankers. - Microsoft Specialist: Programming in C# (4 days) (2017.10.2 to 2017.10.5)

"Intense but very rewarding course, learned a lot in a few days."
S.S.. - Microsoft Specialist: Programming in C# (4 days) (2017.10.2 to 2017.10.5)

"The course was very intense and very informative, real examples were given to concepts hard to understand."
Anonymous - Microsoft Specialist: Programming in C# (4 days) (2017.10.2 to 2017.10.5)

"Training with Firebrand has been a great way to kick-start my IT certifications and to help me aim to progress in my careers. Instructors are knowledgeable and insightful and the learning experience was top notch!"
L.M.. - Microsoft MTA: Windows Server Administration Fundamentals (2 days) (2017.10.2 to 2017.10.3)

"Great facilities, good teacher and an enjoyable course."
Adam Batten. - Microsoft MTA Software Development Fundamentals (2 days) (2017.9.28 to 2017.9.29)

"This course was condensed but covered most of the topics. Will recommend to my colleagues and friends. One has to understand OOP, SDLC, VS, .net +Core. The Dev course was tough for me but the trainer made it understandable for me. "
P.A., kpdsolutions Ltd and contract client - TfL. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (2017.9.9 to 2017.9.17)

"As expected, I had an excellent experience here and the instructor knew the subject matter very well. I will definitely recommend Firebrand anytime and any day."
Ekhorutomwen Asemota, Capgemini. - Microsoft Specialist: Architecting Microsoft Azure Solutions (2 days) (2017.9.16 to 2017.9.17)

"Excellent and to the point, cannot not praise enough the instructor whose delivery was impeccable. "
P.V.. - Microsoft MCSD: Azure Solutions Architect (9 days) (2017.9.9 to 2017.9.17)

"The training was well structured and comprehensive. I filled in my Azure knowledge gaps and the instructor prepared me for the exams excellently, and was extremely knowledgeable, patient, and friendly throughout. All hail Lord Chinzilla!"
Chris Smallman. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (2017.9.9 to 2017.9.17)

"Lots of long days paid off - the course was tough but greatly rewarding. The instructor was a brilliant coach and we wouldn't have made it through the 9 days without him. The food wasn't bad either!"
Joseph Ellis, PA Consulting. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (2017.9.9 to 2017.9.17)

"The instructor has been great. Extremely enthusiastic and engaging. Would definitely recommend him to my colleagues. The structure and coverage of the material will definitely help me succeed with Azure, thanks Victor!"
Tarun Julka, Diligent Corporation. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (2017.9.9 to 2017.9.17)

"I always enjoy my courses at Firebrand and would recommend people take their courses here."
Ridhan Romjon, Retail 247. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (2017.9.9 to 2017.9.17)

"Intensive means just that. Long and exhausting training days but the quality of instruction makes the time fly by. Looking forward to part 2!"
C.P.. - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (2017.9.9 to 2017.9.11)

"The instructor was very engaging and knew his stuff! "
Anonymous - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (2017.9.9 to 2017.9.11)

"The quality of the training at Firebrand is perfect for preparing your for the exams!"
Rachel Hillier, Computer-eye2. - Microsoft MCSA: Windows 10 (6 days) (2017.8.21 to 2017.8.26)

"If you need massive amounts of knowledge in a short time, these are the guys to train with. Excellent facility and instructors. "
Darrall Jarman, Dazzle Computer Solutions (Self Employed). - Microsoft MCSA: Windows 10 (6 days) (2017.8.21 to 2017.8.26)

"Great place to come if like me you cant sit at home and read through a book, as it just does not go in. I came here having read books and have learnt a lot in the 6 days I was here. The classrooms are quite a nice environment and if you get a good trainer then it makes the whole thing better. The days are long and a bit of a slog at times getting in at 8/8.30 and then leaving at 9. Obviously there are breaks in between but still long days and don't sleep much. Overall a great experience and will definitely be using Firebrand for training again. "
Ben Farnath-Jones, OC&C Strategy Consultants. - Microsoft MCSA: Windows 10 (6 days) (2017.8.21 to 2017.8.26)

"Although the course consisted of very long days, the instructor was brilliant, it was a good laugh in the classroom and covered the subject areas very well! "
Anonymous - Microsoft MCSA: Windows 10 (6 days) (2017.8.21 to 2017.8.26)

"The trainer was great and very engaging. I thoroughly enjoyed the course and felt that all of the modules were covered clearly and concisely."
Ethan ODonnell. - Microsoft Windows Server 2016 - Identity (4 days) (2017.8.17 to 2017.8.20)

"After finishing the training for the MCSA course, I now feel confident in taking the examination!"
Callum Nocton-Gribben, Onefile ltd. - Microsoft MCSA: SQL Server 2016 - Database Development (6 days) (2017.8.14 to 2017.8.19)

"Had a great time at Firebrand. Thank you for all your support."
Jacob Johnson, St Johns School. - Microsoft Windows Server 2016 - Networking (3 days) (2017.8.14 to 2017.8.16)

"MCSD - App Builder course experience was great, got to know lot of new stuff like Azure & MVC and information about how to develop/plan enterprise level web application. The instructor was great through out the course explaining lot of modern stuff which goes on and also balancing the course with exam perspective. "
Amit Rathod. - Microsoft MCSD: App Builder (9 days) (2017.8.5 to 2017.8.13)

"The instructor was great and answered all questions in detail as well as making sure everyone understood. I found the course challenging but learning at Firebrand helps beginners get better knowledge of all the courseware covered."
Hannah McEwan. - Microsoft MCSD: App Builder (9 days) (2017.8.5 to 2017.8.13)

"The course was of very high quality and has provided me with the relevant information to allow me to put it into practice. I attended the course with little knowledge of administering SharePoint and I am leaving knowing that I have the relevant knowledge to build and administer a SharePoint farm. This is all thanks to the instructor - he has been fantastic!"
Benjamin Riley, Halton Borough Council. - Microsoft MCSE: SharePoint 2016 (6 days) (2017.8.7 to 2017.8.12)

"Very experienced tutor also allowed flexible learning environment to discuss wider scope of applied knowledge. All In one location (accommodation and self contained classroom building that is 24 hours accessible)."
A.A.. - Microsoft MCSA: SQL Server 2016 - Database Administration (6 days) (2017.8.7 to 2017.8.12)

"The quality of the training experience was excellent! Good facilities, helpful staff and brilliant instructors. This was my first experience of official Microsoft training and Firebrand have definitely made me want more... and with them! I will be Back!"
D.W., Declaro Support Limited. - Microsoft MCSA: Office 365 (5 days) (2017.8.7 to 2017.8.11)

"Excellent facility with excellent trainers."
Owen Heaume . - Microsoft MCSA: Office 365 (5 days) (2017.8.7 to 2017.8.11)

"It has been a great course, the instructor takes a fast-paced & information dense course, yet somehow makes it feel relaxed. Its been a great 3 days."
Anonymous - Microsoft Developing ASP.NET MVC Web 4 Applications (3 days) (2017.8.8 to 2017.8.10)

"Very good course, enjoyable under many aspects. The instructor was very friendly, knowledgeable and patient (I ask many questions). Thank you"
Christian Dornetto, CRM Dynamics Ltd. - Microsoft Specialist: Programming in HTML5 with JavaScript and CSS3 (3 days) (2017.8.5 to 2017.8.7)

"Firebrands intensive courses are great for achieving qualifications fast!"
Muhammed Haque. - Microsoft Specialist: Programming in HTML5 with JavaScript and CSS3 (3 days) (2017.8.5 to 2017.8.7)

"The training was very helpful and puts a lot of things into perspective and real life. It is explained in a way that makes sense, which isn't always captured from a book."
M.J., Knauf Insulation. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (2017.7.31 to 2017.8.5)

"Really enjoyed my short time here. I've made lots of new friends and learned a lot of new stuff within the 6 days that I've been here. Gareth has been great and has helped us through every section of the course."
James Laird, Jmfinn & Co. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (2017.7.31 to 2017.8.5)

"It was a great course, relevant information and a knowledgeable instructor. It helped to make a good bond with other attendees, helping with the evening revision and practice exams together in the hotel bar, or purely just moral support! Be prepared for a lot of intense information, take notes and use whatever vice you need; coffee, sugar, fizzy drinks to keep you alert! I had a great time and would definitely recommend."
KAYLEA REED, UTILITA ENERGY. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (2017.7.31 to 2017.8.5)

"My journey at Firebrand has been great. First course with them, it was extremely informative and I learnt more than I ever would in my own time. The course duration was just right, 6 days to cover 3 modules was perfect. The practice exams are priceless, you can never prepare yourself for the real thing however they got you ready for the daunting aspect of exam conditions. The level of help, support and enthusiasm for us to succeed drives you to do your best (and the failure is not an option T-shirt helps!). Thank you - I will be back!"
Leah Hunt, Scientifica. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (2017.7.31 to 2017.8.5)

"I have learnt a lot this week with Firebrand, their instructors were all friendly and experienced, and have the experience they have in the real world has significantly contributed to my passing this course."
James Gunn, Softwerx. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (2017.7.31 to 2017.8.5)

"The course was great; fast paced enough to keep you interested and the instructors will give you excellent insight the books wont."
R.W., 3T RPD Ltd. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (2017.7.31 to 2017.8.5)

"Excellent Environment and training provided. Thank you"
Anonymous - Microsoft MTA Networking Fundamentals (2 days) (2017.8.2 to 2017.8.3)

"The instructor was very knowledgeable and very accommodating in changing and adding additional content for the course."
Colin Lobo, NCC Group. - Microsoft Azure Academy: Infrastructure and Networking (4 days) (2017.7.31 to 2017.8.3)

"Instructor was very knowledgeable in his subject. If he did not know the answer to a question he would go off and investigate to provide answers."
C.H.. - Microsoft Azure Academy: Infrastructure and Networking (4 days) (2017.7.31 to 2017.8.3)

"It was well spent 4 days understanding the Azure Platform and good pointers for security best practices for deployment, monitoring and assessment."
A.N., NCC Group. - Microsoft Azure Academy: Infrastructure and Networking (4 days) (2017.7.31 to 2017.8.3)

"Its been really hard work, but really worth the time. "
Jeffrey Vermunt, MK2. - Microsoft MCSE: Communication (Skype for Business) (6 days) (2017.7.17 to 2017.7.22)

"Training has been of high standards and quality and why I have returned for 3rd time to train with them. I would highly recommended Firebrand Training to anyone wanting to certify themselves."
S.B., Sutaj Ltd. - Microsoft MCSE: Communication (Skype for Business) (6 days) (2017.7.17 to 2017.7.22)

"Great course with a brilliant course teacher. The instructor managed to dumb down complex concepts and made an interactive educative environment."
Mohammad B, CRMCS Consultancy. - Microsoft Specialist: Programming in C# (4 days) (2017.7.3 to 2017.7.6)

"The training is very good. It is not passive, so you have to work hard, but you get all the key information you need to build upon - with your own reading and revision adding the extra insight needed for the exam. My expectation before the course was that I might pass one of the three exams, but I soon realised that if I was prepared to work in the evenings as the instructor encouraged us all to, then I could get through them all (so far Ive passed 2 with one more this afternoon!). It was up to me now. Having passed an MCP in server 2003 through self-study - which took nearly 12 months - I was very impressed with how much you can learn when able to get the answers you need from a subject matter expert and how quickly you can get through a single exam - a matter of a few days. The labs were also very useful for getting hands-on experience and testing out what you had learned during the day. In terms of the accommodation and food, it was excellent - a small issue with my shower was fixed within hours and the staff are all friendly and very professional. You get a very good choice of food and if you prefer a low carb diet like myself then thats no problem. If you prefer to relax in the evening then there is a decent bar where you can take some time out with your new friends. "
Ben Kane, Euro Recycling. - Microsoft MCSA: Windows Server 2016 (11 days) (2017.6.24 to 2017.7.4)

"Excellent learning environment, knowledgeable staff. Well paced course syllabus."
Matthew Ottley, Manuli Hydraulics UK Ltd. - Microsoft MCSA: Windows Server 2016 (11 days) (2017.6.24 to 2017.7.4)

On this accelerated 5 day MCSA: SQL Server 2016 Business Intelligence Development course, you’ll learn to implement a SQL Server 2016 data warehouse solution to support a business intelligence. You’ll go on to learn how to use the capabilities of SQL Server 2016 to create business intelligence solutions.

These skills will allow you to query, process, analyse and report on a vast amount of raw business data. Skills you’ll learn will include creating multidimensional databases and cubes, using MDX, DAX and data mining.

Your accelerated course will be taught by Microsoft Certified Trainers (MCT), using Microsoft Official Curriculum (MOC) and practice tests. You’ll also use Firebrand’s unique Lecture | Lab | Review technique, covering topics like:

  • Designing and implementing a data warehouse
  • Implementing an Azure SQL data warehouse
  • Working with measures and measure groups
  • Performing predictive analysis with data mining

This course is best suited towards database professionals who work with SQL Server 2016 and conduct analysis using business intelligence solutions.

Read more ...

Interested? See prices or call +44 207 907 1120

Use your free Microsoft training vouchers

You may be entitled to heavily-discounted training via Microsoft's Software Assurance Training Voucher (SATV) scheme. If your business has bought Microsoft software, check to see if it came bundled with free training vouchers! Vouchers can be exchanged against training for all Microsoft technologies. If you’re unsure, get in touch with us

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.

Firebrand Training provides instruction to meet every learning need:

  • Intensive group instruction
  • One-on-one instruction attention
  • Hands-on labs
  • Lab partner and group exercises
  • Question and answer drills
  • Independent study

This information has been provided as a helpful tool for candidates considering training. Courses that include certification come with a Certification Guarantee. Pass first time or train again for free (just pay for accommodation, exams and incidental costs). We do not make any guarantees about personal successes or benefits of obtaining certification. Benefits of certification determined through studies do not guarantee any particular personal successes.

Read more ...

Interested? See prices or call +44 207 907 1120

Course 20767B: Implementing a SQL Data Warehouse

Module 1: Introduction to Data Warehousing

This module describes data warehouse concepts and architecture consideration.

Lessons

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution

Lab: Exploring a Data Warehouse Solution

  • Exploring data sources
  • Exploring an ETL process
  • Exploring a data warehouse

After completing this module, you’ll be able to:

  • Describe the key elements of a data warehousing solution
  • Describe the key considerations for a data warehousing solution

Module 2: Planning Data Warehouse Infrastructure

This module describes the main hardware considerations for building a data warehouse.

Lessons

  • Considerations for data warehouse infrastructure.
  • Planning data warehouse hardware.

Lab: Planning Data Warehouse Infrastructure

  • Planning data warehouse hardware

After completing this module, you’ll be able to:

  • Describe the main hardware considerations for building a data warehouse
  • Explain how to use reference architectures and data warehouse appliances to create a data warehouse

Module 3: Designing and Implementing a Data Warehouse

This module describes how you go about designing and implementing a schema for a data warehouse.

Lessons

  • Designing dimension tables
  • Designing fact tables
  • Physical Design for a Data Warehouse

Lab: Implementing a Data Warehouse Schema

  • Implementing a star schema
  • Implementing a snowflake schema
  • Implementing a time dimension table

After completing this module, you’ll be able to:

  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse

Module 4: Columnstore Indexes

This module introduces Columnstore Indexes.

Lessons

  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes

Lab: Using Columnstore Indexes

  • Create a Columnstore index on the FactProductInventory table
  • Create a Columnstore index on the FactInternetSales table
  • Create a memory optimised Columnstore table

After completing this module, you’ll be able to:

  • Create Columnstore indexes
  • Work with Columnstore Indexes

Module 5: Implementing an Azure SQL Data Warehouse

This module describes Azure SQL Data Warehouses and how to implement them.

Lessons

  • Advantages of Azure SQL Data Warehouse
  • Implementing an Azure SQL Data Warehouse
  • Developing an Azure SQL Data Warehouse
  • Migrating to an Azure SQ Data Warehouse
  • Copying data with the Azure data factory

Lab: Implementing an Azure SQL Data Warehouse

  • Create an Azure SQL data warehouse database
  • Migrate to an Azure SQL Data warehouse database
  • Copy data with the Azure data factory

After completing this module, you’ll be able to:

  • Describe the advantages of Azure SQL Data Warehouse
  • Implement an Azure SQL Data Warehouse
  • Describe the considerations for developing an Azure SQL Data Warehouse
  • Plan for migrating to Azure SQL Data Warehouse

Module 6: Creating an ETL Solution

At the end of this module you’ll be able to implement data flow in a SSIS package.

Lessons

  • Introduction to ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow

Lab: Implementing Data Flow in an SSIS Package

  • Exploring source data
  • Transferring data by using a data row task
  • Using transformation components in a data row

After completing this module, you’ll be able to:

  • Describe ETL with SSIS
  • Explore Source Data
  • Implement a Data Flow

Module 7: Implementing Control Flow in an SSIS Package

This module describes implementing control flow in an SSIS package.

Lessons

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing consistency.

Lab: Implementing Control Flow in an SSIS Package

  • Using tasks and precedence in a control flow
  • Using variables and parameters
  • Using containers

Lab: Using Transactions and Checkpoints

  • Using transactions
  • Using checkpoints

After completing this module, you’ll be able to:

  • Describe control flow
  • Create dynamic packages
  • Use containers

Module 8: Debugging and Troubleshooting SSIS Packages

This module describes how to debug and troubleshoot SSIS packages.

Lessons

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package

Lab: Debugging and Troubleshooting an SSIS Package

  • Debugging an SSIS package
  • Logging SSIS package execution
  • Implementing an event handler
  • Handling errors in data flow

After completing this module, you’ll be able to:

  • Debug an SSIS package
  • Log SSIS package events
  • Handle errors in an SSIS package

Module 9: Implementing a Data Extraction Solution

This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.

Lessons

  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Loading modified data
  • Temporal Tables

Lab: Extracting Modified Data

  • Using a date time column to incrementally extract data
  • Using change data capture
  • Using the CDC control task
  • Using change tracking

Lab: Loading a data warehouse

  • Loading data from CDC output tables
  • Using a lookup transformation to insert or update dimension data
  • Implementing a slowly changing dimension
  • Using the merge statement

After completing this module, you’ll be able to:

  • Describe incremental ETL
  • Extract modified data
  • Load modified data.
  • Describe temporal tables

Module 10: Enforcing Data Quality

This module describes how to implement data cleansing by using Microsoft Data Quality services.

Lessons

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data

Lab: Cleansing Data

  • Creating a DQS knowledge base
  • Using a DQS project to cleanse data
  • Using DQS in an SSIS package

Lab: De-duplicating Data

  • Creating a matching policy
  • Using a DS project to match data

After completing this module, you’ll be able to:

  • Describe data quality services
  • Cleanse data using data quality services
  • Match data using data quality services
  • De-duplicate data using data quality services

Module 11: Using Master Data Services

This module describes how to implement master data services to enforce data integrity at source.

Lessons

  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Hierarchies and collections
  • Creating a Master Data Hub

Lab: Implementing Master Data Services

  • Creating a master data services model
  • Using the master data services add-in for Excel
  • Enforcing business rules
  • Loading data into a model
  • Consuming master data services data

After completing this module, you’ll be able to:

  • Describe the key concepts of master data services
  • Implement a master data service model
  • Manage master data
  • Create a master data hub

Module 12: Extending SQL Server Integration Services (SSIS)

This module describes how to extend SSIS with custom scripts and components.

Lessons

  • Using scripting in SSIS
  • Using custom components in SSIS

Lab: Using scripts

  • Using a script task

After completing this module, you’ll be able to:

  • Use custom components in SSIS
  • Use scripting in SSIS

Module 13: Deploying and Configuring SSIS Packages

This module describes how to deploy and configure SSIS packages.

Lessons

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution

Lab: Deploying and Configuring SSIS Packages

  • Creating an SSIS catalogue
  • Deploying an SSIS project
  • Creating environments for an SSIS solution
  • Running an SSIS package in SQL server management studio
  • Scheduling SSIS packages with SQL server agent

After completing this module, you’ll be able to:

  • Describe an SSIS deployment
  • Deploy an SSIS package
  • Plan SSIS package execution

Module 14: Consuming Data in a Data Warehouse

This module describes how to debug and troubleshoot SSIS packages.

Lessons

  • Introduction to Business Intelligence
  • An Introduction to Data Analysis
  • Introduction to reporting
  • Analysing Data with Azure SQL Data Warehouse

Lab: Using a data warehouse

  • Exploring a reporting services report
  • Exploring a PowerPivot workbook
  • Exploring a power view report

After completing this module, you’ll be able to:

  • Describe at a high level business intelligence
  • Show an understanding of reporting
  • Show an understanding of data analysis
  • Analyse data with Azure SQL data warehouse

Course 20768B: Developing SQL Data Models

Module 1: Introduction to Business Intelligence and Data Modelling

This module introduces key BI concepts and the Microsoft BI product suite.

Lessons

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform

Lab: Exploring a BI Solution

  • Exploring a Data Warehouse
  • Exploring a data model

After completing this module, you’ll be able to:

  • Describe BI scenarios, trends, and project roles.
  • Describe the products that make up the Microsoft BI platform.

Module 2: Creating Multidimensional Databases

This module describes how to create multidimensional databases using SQL Server Analysis Services.

Lessons

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security
  • Configure SSAS
  • Monitoring SSAS

Lab: Creating a multidimensional database

  • Creating a Data Source
  • Creating and Modifying a data Source View
  • Creating and Modifying a Cube

After completing this module, you’ll be able to:

  • Describe considerations for a multidimensional database.
  • Create data sources and data source views.
  • Create a cube
  • Implement security in a multidimensional database.
  • Configure SSAS to meet requirements including memory limits, NUMA and disk layout.
  • Monitor SSAS performance.

Module 3: Working with Cubes and Dimensions

This module describes how to implement dimensions in a cube.

Lessons

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes
  • Slowly Changing Dimensions

Lab: Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Relationships and Hierarchies
  • Sorting and Grouping Dimension Attributes

After completing this module, you’ll be able to:

  • Configure dimensions.
  • Define attribute hierarchies.
  • Implement sorting and grouping for attributes.
  • Implement slowly changing dimensions.

Module 4: Working with Measures and Measure Groups

This module describes how to implement measures and measure groups in a cube.

Lessons

  • Working with Measures
  • Working with Measure Groups

Lab: Configuring Measures and Measure Groups

  • Configuring Measu res
  • Defining Dimension Usage and Relationships
  • Configuring Measure Group Storage

After completing this module, you’ll be able to:

  • Configure measures.
  • Configure measure groups.

Module 5: Introduction to MDX

This module describes the MDX syntax and how to use MDX.

Lessons

  • MDX fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube

Lab: Using MDX

  • Querying a cube using MDX
  • Creating a Calculated Member

After completing this module, you’ll be able to:

  • Use basic MDX functions.
  • Use MDX to add calculations to a cube.
  • Use MDX to query a cube.

Module 6: Customising Cube Functionality

This module describes how to customise a cube.

Lessons

  • Introduction to Business Intelligence
  • The Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Lab: Customising a Cube

  • Implementing a KPI
  • Implementing an action
  • Implementing a perspective
  • Implementing a translation

After completing this module, you’ll be able to:

  • Implement KPIs in a Multidimensional database
  • Implement Actions in a Multidimensional database
  • Implement perspectives in a Multidimensional database
  • Implement translations in a Multidimensional database

Module 7: Implementing a Tabular Data Model by Using Analysis Services

This module describes how to implement a tabular data model in Power Pivot.

Lessons

  • Introduction to Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution

Lab: Working with an Analysis Services Tabular Data Model

  • Creating an Analysis Services Tabular Data Model
  • Configure Relationships and Attributes
  • Configuring Data Model for an Enterprise BI Solution.

After completing this module, you’ll be able to:

  • Describe tabular data models
  • Describe how to create a tabular data model
  • Use an Analysis Services Tabular Model in an enterprise BI solution

Module 8: Introduction to Data Analysis Expression (DAX)

This module describes how to use DAX to create measures and calculated columns in a tabular data model.

Lessons

  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

Lab: Creating Calculated Columns and Measures by using DAX

  • Creating Calculated Columns
  • Creating Measures
  • Creating a KPI
  • Creating a Parent - Child Hierarchy

After completing this module, you’ll be able to:

  • Describe the key features of DAX
  • Create calculated columns and measures by using DAX

Module 9: Performing Predictive Analysis with Data Mining

This module describes how to use data mining for predictive analysis.

Lessons

  • Overview of Data Mining
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to and Consuming a Data-Mining Model
  • Using the Data Mining add-in for Excel

Lab: Using Data Mining

  • Creating a Data Mining Structure and Model
  • Exploring Data Mining Models
  • Validating Data Mining Models
  • Consuming a Data Mining Model
  • Using the Excel Data Mining add-in

After completing this module, you’ll be able to:

  • Describe considerations for data mining
  • Create a data mining model
  • Validate a data mining model
  • Connect to a data-mining model
  • Use the data mining add-in for Excel

Read more ...

Interested? See prices or call +44 207 907 1120

You'll sit the following exams, covered by your Certification Guarantee:

Exam 70-767: Implementing a SQL Data Warehouse

The skills you'll be tested on include the following:

  • Design and implement a data warehouse (35-40%)
  • Extract, transform and load data (30-45%)
  • Build data quality solutions (15-20%)

Exam 70-768: Developing SQL Data Models

The skills you'll be tested on include the following:

  • Design a multidimensional business intelligence 9BI) semantic model (25-30%)
  • Design a tabular BI semantic model (20-25%)
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15-20%)
  • Configure and maintain SQL Server Analysis Services (SSAS) (30-35%)

Read more ...

Interested? See prices or call +44 207 907 1120

Microsoft Official Curriculum

  • MOC 20767B - Implementing a SQL Data Warehouse
  • MOC 20768B - Developing SQL Data Models

Firebrand Training offers top-quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their studies and certification goals.

Our Accelerated Learning Programmes include:

  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive Study Materials, Program Courseware and Self-Testing Software including MeasureUp *
  • Fully instructor-led program with 24 hour lab access
  • Examination vouchers **
  • On site testing ***
  • Accommodation, all meals, unlimited beverages, snacks and tea / coffee****
  • Transportation to/from designated local railway stations
  • Examination Passing Policy

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.

Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.

Firebrand goes digital

We’re currently migrating from printed to digital courseware. Some courseware is already available in digital, while other books remain in printed form. To find out if this course is digital, call us on +44 207 907 1120.

There are several benefits of easy-to-use digital courseware: downloads are immediate, and you’ll always have your courseware available wherever you are. You won’t need to wait for a printed book to be delivered before you start learning – and it’s better for the environment. You can choose to download the courseware to your own device, or borrow one of ours.

Considering a Microsoft course? Always have the most up-to-date Microsoft digital courseware with ‘Fresh Editions’. This gives you access to all versions of digital courseware – you’ll receive updates and revisions of your textbook, at no charge, for the life of that course.

Examination Passing Policy

Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year.  Students will only be responsible for accommodations and vendor exam fees.

Please note

  • * Not on all courses
  • ** Examination vouchers are not included for the following courses: PMI, GIAC, CISA, CISM, CGEIT, CRISC, CISSP CBK Review and CSX Practitioner Level 1,2 and 3
  • *** On site testing is not included for our PMI, GIAC, CSX Practitioner or ITIL Managers and Revision Certification Courses.
  • **** Accommodation not included on the CISSP CBK Review Seminar

Read more ...

Interested? See prices or call +44 207 907 1120

It is recommended you have at least 2 years’ experience of working with relational databases, including:

  • Designing a normalised database
  • Creating tables and relationships
  • Some exposure to basic programming constructs (such as looping and branching)

An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable

Unsure whether you meet the prerequisites?

Don’t worry - we’ll discuss your technical background, experience and qualifications to determine whether this accelerated course suits you.

Just call us on +44 207 907 1120 and speak to one of our enrolment consultants.

Firebrand is an immersive environment and requires commitment. Some prerequisites are simply guidelines; you may find your unique experience, attitude and determination enables you to succeed on your accelerated course.

Interested? See prices or call +44 207 907 1120