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 64,904 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 64,904 students and asked them all to review our Accelerated Learning. Currently, 96.53% 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) (6/3/2017 to 10/3/2017)

"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) (9/9/2017 to 17/9/2017)

"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) (16/9/2017 to 17/9/2017)

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

"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) (9/9/2017 to 17/9/2017)

"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) (9/9/2017 to 17/9/2017)

"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) (9/9/2017 to 17/9/2017)

"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) (9/9/2017 to 17/9/2017)

"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) (9/9/2017 to 11/9/2017)

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

"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) (21/8/2017 to 26/8/2017)

"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) (21/8/2017 to 26/8/2017)

"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) (21/8/2017 to 26/8/2017)

"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) (21/8/2017 to 26/8/2017)

"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) (17/8/2017 to 20/8/2017)

"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) (14/8/2017 to 19/8/2017)

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

"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) (5/8/2017 to 13/8/2017)

"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) (5/8/2017 to 13/8/2017)

"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) (7/8/2017 to 12/8/2017)

"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) (7/8/2017 to 12/8/2017)

"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) (7/8/2017 to 11/8/2017)

"Excellent facility with excellent trainers."
Owen Heaume . - Microsoft MCSA: Office 365 (5 days) (7/8/2017 to 11/8/2017)

"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) (8/8/2017 to 10/8/2017)

"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) (5/8/2017 to 7/8/2017)

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

"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) (31/7/2017 to 5/8/2017)

"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) (31/7/2017 to 5/8/2017)

"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) (31/7/2017 to 5/8/2017)

"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) (31/7/2017 to 5/8/2017)

"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) (31/7/2017 to 5/8/2017)

"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) (31/7/2017 to 5/8/2017)

"Excellent Environment and training provided. Thank you"
Anonymous - Microsoft MTA Networking Fundamentals (2 days) (2/8/2017 to 3/8/2017)

"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) (31/7/2017 to 3/8/2017)

"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) (31/7/2017 to 3/8/2017)

"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) (31/7/2017 to 3/8/2017)

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

"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) (17/7/2017 to 22/7/2017)

"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) (3/7/2017 to 6/7/2017)

"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) (24/6/2017 to 4/7/2017)

"Excellent learning environment, knowledgeable staff. Well paced course syllabus."
Matthew Ottley, Manuli Hydraulics UK Ltd. - Microsoft MCSA: Windows Server 2016 (11 days) (24/6/2017 to 4/7/2017)

"5th Course at firebrand, and as always a great experience. Trainers are friendly and willing to answer most any questions you may have, even if they have to get back to you later 10/10"
Ethan ODonnell. - Microsoft Windows Server 2016 - Networking (3 days) (28/6/2017 to 30/6/2017)

"Very happy with the course and cannot wait to come back for mtadev in a couple of months. Definitely enjoy server work."
Jamie H., Watchfinder&co. - Microsoft MCSA: Windows Server 2016 (11 days) (24/6/2017 to 4/7/2017)

"Have been to Firebrand several times and the training is of a high standard. Great way to get qualified in a short time."
Richard Smith, Redcare (5G Communications). - Microsoft MCSA: Windows Server 2012 R2 (9 days) (13/5/2017 to 21/5/2017)

"If you are prepared to attend an intense training course, Firebrand is for you. After 3 days of training, I gained a huge amount of knowledge. Just be ready to learn! And take your skills to the next level."
Mark Cunningham, Capgemini. - Microsoft Specialist: Dynamics CRM 2016 Customisation and Configuration (4 days) (16/5/2017 to 19/5/2017)

"Firebrand provides great training with brilliant instructors. The course was enjoyable and the resources I had access to were fantastic"
Azimuth Jenkins, Capgemini. - Microsoft Specialist: Dynamics CRM 2016 Customisation and Configuration (4 days) (16/5/2017 to 19/5/2017)

"Very professional, interesting, comprehensive training! "
Michal Jarosinski, UTILITA.ENERGY. - Microsoft MTA Networking, Security & Windows Server Administration (6 days) (8/5/2017 to 13/5/2017)

"Highly engaging trainer! Found the MCSA Server 2012 course to be intense but it was helped along the way with the unique and fun way that the trainer took with his approach to it. Hes very, very knowledgeable in the subject which is helped with live notes to take a way (a first for me!) and provided time to carry out labs to test out what is learnt in theory."
The Vinh Hoang, Agent Provocateur Ltd. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (1/4/2017 to 9/4/2017)

"Really impressed with the training and the on-site facilities. Its been a great experience. "
Matt Hill, Coeo Ltd. - Microsoft Azure Academy: Data Lake & Data Factory (2 days) (30/3/2017 to 31/3/2017)

"Good experience at the course. Great introduction and working experience with Data Lakes and Data Factory. The instructor was very patient and clear."
Terry Choo, eBECS. - Microsoft Azure Academy: Data Lake & Data Factory (2 days) (30/3/2017 to 31/3/2017)

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 080 80 800 888

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 080 80 800 888

Course 20767A: Implementing a SQL Data Warehouse

Module 1: Introduction to Data Warehousing

Describe data warehouse concepts and architecture considerations.

Lessons

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

Lab : Exploring a Data Warehouse Solution

After completing this module, you will 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 Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances

Lab : Planning Data Warehouse Infrastructure

After completing this module, you will 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

  • Logical Design for a Data Warehouse
  • Physical Design for a Data Warehouse

Lab : Implementing a Data Warehouse Schema

After completing this module, you will 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

After completing this module, you will 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

Lab : Implementing an Azure SQL Data Warehouse

After completing this module, you will 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 will 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

After completing this module, you will 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

Lab : Implementing Control Flow in an SSIS Package

Lab : Using Transactions and Checkpoints

After completing this module, you will 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

After completing this module, you will be able to:

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

Module 9: Implementing an Incremental ETL Process

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
  • Temporal Tables

Lab : Extracting Modified Data

Lab : Loading Incremental Changes

After completing this module, you will be able to:

  • Describe incremental ETL
  • Extract 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

Lab : De-duplicating Data

After completing this module, you will 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

  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub

Lab : Implementing Master Data Services

After completing this module, you will 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 Custom Components in SSIS
  • Using Scripting in SSIS

Lab : Using Scripts and Custom Components

After completing this module, you will 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

After completing this module, you will 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
  • Introduction to Reporting
  • An Introduction to Data Analysis
  • Analysing Data with Azure SQL Data Warehouse

Lab : Using Business Intelligence Tools

After completing this module, you will 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 20768A: Developing SQL Data Models

Module 1: Introduction to Business Intelligence and Data Modeling

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 Data Warehouse

After are completing this module, you will be editable to:

  • Describe the concept of business intelligence
  • Describe the Microsoft business intelligence platform

Module 2: Creating Multidimensional Databases

This module describes the steps required to create a multidimensional database with analysis services

Lessons

  • Introduction to multidimensional analysis
  • Creating data sources and data source views
  • Creating a cube
  • Overview of cube security

Lab: Creating a multidimensional database

After are completing this module, you will be editable to:

  • Use multidimensional analysis
  • Create data sources and data source views
  • Create a cube
  • Describe cube security

Module 3: Working with Cubes and Dimensions

This module describes how to implement dimensions into a cube

Lessons

  • Configuring dimensions
  • Define attribute hierarchies
  • Sorting and grouping attributes

Lab: Working with Cubes and Dimensions

After are completing this module, you will be editable to:

  • Configure dimensions
  • Define attribute hierarchies.
  • Sort and group attributes

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

After are completing this module, you will be editable to:

  • Work with Measures
  • Work with measure groups

Module 5: Introduction to MDXT

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

After are completing this module, you will be editable to:

  • Describe the fundamentals of MDX
  • Add calculations to a cube
  • Query a cube using MDX

Module 6: Customising Cube Functionality

This module describes how to customise a cube

Lessons

  • Implementing key performance indicators
  • Implementing actions
  • Implementing perspectives
  • Implementing translations

Lab: Customising a Cube

After are completing this module, you will be editable to:

  • Implement key performance indicators
  • Implement actions
  • Implement perspectives
  • Implement translations

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

This module describes how to implement a tabular data model in PowerPivot

Lessons

  • Introduction to tabular data models
  • Creating a tabular data model
  • Using an Analysis Services tabular model in an enterprise BI solution

Lab: Working with an Analysis Services tabular data model

After are completing this module, you will be editable to:

  • Describe tabular data models
  • Create a tabular data model
  • Be printable to use an Analysis Services tabular data model into 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

After are completing this module, you will be editable to:

  • Describe the fundamentals of DAX
  • Use DAX to create Calculated Columns and Measures in a tabular data model

Module 9: Performing Predictive Analysis with Data Mining

This module describes how to use data mining for predictive analysis

Lessons

  • Overview of data mining
  • Using the data mining add-in for Excel
  • Creating a custom data mining solution
  • Validating a data mining model
  • Connecting to and consuming a data mining model

Lab: Perform Predictive Analysis with Data Mining

After are completing this module, you will be editable to:

  • Describe data mining
  • Use the data mining add-in for Excel
  • Create a custom data mining solution
  • Validate a data mining solution
  • Connect to and consume a data mining solution

Read more ...

Interested? See prices or call 080 80 800 888

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 (30-35%)
  • Extract, transform and load data (35-40%)
  • Integrate solutions with cloud data and big data (15-20%)
  • 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 080 80 800 888

Microsoft Official Curriculum

  • MOC 20767A - Implementing a SQL Data Warehouse
  • MOC 20768A - 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 080 80 800 888.

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 080 80 800 888

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 080 80 800 888 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 080 80 800 888