Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server 2014 - Only 3 Days

Seven reasons why you should sit your SQL Server BI Solutions course with Firebrand Training

Find Out How We Help You To Learn New Skills Quickly

  1. You'll be SQL Server BI Solutions certified in just 3 days. With us, you’ll be SQL Server BI Solutions trained in record time
  2. Our SQL Server BI Solutions course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
  3. Pass SQL Server BI Solutions 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 SQL Server BI Solutions. 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 SQL Server BI Solutions 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 SQL Server BI Solutions 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,486 professionals, and we’re partners with all of the big names in the business
  7. You'll do more than study SQL Server BI Solutions 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

Location

Book now

22/5/2017 (Monday)

24/5/2017 (Wednesday)

Finished

-

 

25/9/2017 (Monday)

27/9/2017 (Wednesday)

Wait list

Nationwide

 

6/11/2017 (Monday)

8/11/2017 (Wednesday)

Limited availability

Nationwide

 

18/12/2017 (Monday)

20/12/2017 (Wednesday)

Open

Nationwide

 

29/1/2018 (Monday)

31/1/2018 (Wednesday)

Open

Nationwide

 

12/3/2018 (Monday)

14/3/2018 (Wednesday)

Open

Nationwide

 

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



"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)

"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)

"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)

"The training is very intensive, but everything is taken care of and thought about. The instructor was immensely knowledgeable and had huge amounts of experience. The facility is excellent too."
Matt Bridgeworth, Softcat plc. - Microsoft Specialist: Architecting Microsoft Azure Solutions (2 days) (29/3/2017 to 30/3/2017)

"Firebrand delivers a complete studying experience that is geared towards results. Tutors and support staff are excellent with incredible knowledge and outstanding customer service. The immersive format is absolutely critical to the success of the training approach and delivers results time after time. If you want your organisation and your staff to develop and succeed then Firebrand is the training partner that you need. Completely committed to delivering the results that you deserve. Love it........"
Paul OSullivan, CSC. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (13/3/2017 to 21/3/2017)

"Very useful, very intense, Plenty of information to take in but it was all useful and will be practical for when i take it back to work. Only positives to say really."
Aman Kumar, DMS. - Microsoft MTA Database Fundamentals (2 days) (20/3/2017 to 21/3/2017)

"We had Phil Anderson, a very nice and intelligent man. He had to put through a lot of information. I did not take the exam at the end of the week, because I am a person who needs more time to process information. The course was structured and well done by Phil. I would recommend him as a trainer. Teacher gets a 9. The facilities of the training were good. Everything was prepared before the training, so it had an easy start. "
Danny van Oijen, Havenziekenhuis. - Microsoft MCSA: Windows 10 (6 days) (13/3/2017 to 18/3/2017)

"Very hard work, but it gets you through the course. My brain is so full!"
Chris Fitz-Avon. - Microsoft Developing ASP.NET MVC Web 4 Applications (3 days) (14/3/2017 to 16/3/2017)

"I would recommend Firebrand to anyone who wants to get qualified quickly in a fast learning environment. The days are tough but rewarding as well."
Nick Margerum, React CP. - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (13/3/2017 to 15/3/2017)

"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)

"Great delivery and having the freedom to learn key areas critical to my job made this course fantastic. The fact that I had a VM remotely accessible from my hotel room was a big help, allowing me to mess around with settings. "
Paul Robertshaw. - Microsoft MCSA: Windows Server 2012 R2 & MCSE: Server Infrastructure (15 days) (25/2/2017 to 11/3/2017)

"A very informative course, ideal for any server administrator. Covered many areas that my personal studying and experience hadnt reached."
PhIllip Edwards, Telis LTD. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"I love coming to do my training down at Firebrand, this is the 5th time I have been down here and I have always gained lots of experience from the courses. "
N.M. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Having little knowledge before attendance im leaving with much more confidence and understanding."
P.R. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Every one of the instructors Ive had on courses here has been amazing in there own way. They are all experts in the field when it comes to the knowledge required to pass these courses."
Jai Hayes. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Firebrand Training goes into depth on the all the training courses they do, they provide all the information required for exam and do it in such a way that is easy to understand. All the instructors are friendly and always willing to help."
Adam Sells, Hospice in the Weald. - Microsoft MCSA: Windows Server 2012 R2 (9 days) (25/2/2017 to 5/3/2017)

"Excellent learning ennvironment dedicated to your specific requirements. Great professional networking as well."
K.P. - Microsoft MCSA: Windows 10 (6 days) (20/2/2017 to 25/2/2017)

"Super fast paced course in which I learnt so much!"
Claire Farina. - Microsoft MTA HTML5 App Development Fundamentals (2 days) (22/2/2017 to 23/2/2017)

"I love coming down to firebrand for my training, its really intense but very rewarding. Staff and trainers are so professional and knowledgeable "
Simon Leyland, Prodo Digitalhtml. - Microsoft MTA HTML5 App Development Fundamentals (2 days) (22/2/2017 to 23/2/2017)

"Training was extremely engaging and i am happy to say i have walked away with a lot of knowledge and NOTES! The tutor used multiple training styles so it gave everyone in the classroom the opportunity to work with their learning style. Overall a good course taught by a very good tutor. "
Daniel Whitley. - Microsoft MTA HTML5 App Development Fundamentals (2 days) (22/2/2017 to 23/2/2017)

"Intensive but enjoyable course. First step on the ladder towards MCSD."
Jason Hinsley, IM Tec Solutions. - Microsoft MTA Software Development Fundamentals (2 days) (20/2/2017 to 21/2/2017)

"I loved it! I did a 2-day course was very fast-paced and intense, the instructor was very personable, enthusiastic, extremely knowledgeable and an all-round fun guy to talk to. I learned way more than I thought I could within 2 days. The whole experience was very enjoyable and I would highly recommend it. Im already looking forward to my next course. "
Ashleigh Bair. - Microsoft MTA Software Development Fundamentals (2 days) (20/2/2017 to 21/2/2017)

"Firebrand provide an ideal training that shortens the length of the time that the training takes whilst providing all the required content. The course was delivered with a smile and a laugh. "
Tim Headicar. - Microsoft MCSA: Windows Server 2016 (11 days) (11/2/2017 to 21/2/2017)

"I have had a great 11 days on this course, i have learnt all i need to pass the exams, the instructor was great and very knowledgeable. I will be looking to come back and further my qualifications here again."
T.S. - Microsoft MCSA: Windows Server 2016 (11 days) (11/2/2017 to 21/2/2017)

"I have been to Firebrand 9 times now and looking forward to coming back again! Having all resources that I could possibly need within 1 facility means that the time here can be dedicated solely to training and get the best accelerated experience. "
R.M, Gamma. - Microsoft MCSA: Windows Server 2016 (11 days) (11/2/2017 to 21/2/2017)

"My experience at Firebrand was amazing. The instructors level of knowledge was beyond my expectations and the facilities were excellent"
John Cutt. - Microsoft MCSE: SharePoint 2016 (6 days) (6/2/2017 to 11/2/2017)

"The training I received at whilst training with Firebrand was excellent. 11 Days on the course was hard work and demanded a lot of will power. I put in the time and effort and it paid off for me. Thank you to all involved. See you next time."
M.C. - Microsoft Dynamics CRM 2016 (11 days) (29/1/2017 to 8/2/2017)

"I found the courses, trainers and accommodation very good. I learnt a lot and felt very comfortable. I think accelerated learning is a good way to learn and firebrand delivers this very well."
Joanne Nash, Fujitsu Services. - Microsoft Dynamics CRM 2016 (11 days) (29/1/2017 to 8/2/2017)

"It was intense but provides the focus necessary to achieve so much in such a short time. The environment prevents distraction, the course material was detailed and the instructor very knowledgeable and helpful."
Tunde Tayo. - Microsoft Dynamics CRM 2016 Cloud (7 days) (2/2/2017 to 8/2/2017)

On this accelerated 3 day course, you'll learn how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform.

This course, which is 50% faster than other traditional training dives into the reasoning for self-service BI, describes how to use Microsoft SQl Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, Microsoft Office 365 Power BI and Windows Azure HDInsight to perform Big Data analysis.

After completing this course, you'll be able to:

  • Describe key features and benefits of self-service BI
  • Use SQL Server Reporting Services to implement a self-service reporting solution
  • Use PowerPivot, Power Query, Power View and Power Map in Microsoft Excel
  • Use Microsoft SharePoint Server to implement collaborative self-service BI solutions
  • Provision and use a Windows Azure HDInsight cluster for Big Data analysis
  • Use Pig and Hive to analyse big data in Windows Azure HDInsight

Our experienced Microsoft Certified Trainers (MCT) will guide you through the Microsoft Official Curriculum (MOC). Using our unique Lecture | Lab | Review technique, you will accelerate your learning, developing hands-on skills to apply to real-life scenarios through a combination of practical exercises and theory.

You will be prepared for and sit the 70-746: Designing Business Intelligence Solutions with Microsoft SQL Server exam during the course. This is covered for by your Certification Guarantee. Exam 70-746 is an elective for MCSE: Data Management and Analytics certification.

This course is aimed at database and business intelligence professionals who are familiar with data warehouses and enterprise BI solutions built with SQL Server technologies. Experienced data analysts who want to learn how to use Microsoft technologies for self-service analysis and reporting will also benefit from attending this course.

Read more ...

Interested? See prices or call +971 4 3199019

Microsoft Certified Trainers (MCT): You'll be trained by our experienced Microsoft Certified Trainers. This means you'll benefit from the insight their knowledge and experience has to offer.

Microsoft Official Curriculum (MOC): Firebrand is a Microsoft Gold Learning Partner, which means we'll make sure you have access to the latest curriculums and the most up-to-date content.

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 and exams on your return). 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 +971 4 3199019

Course 20467D: Designing Business Intelligence Solutions with Microsoft SQL Server 2014


Module 1: Planning a BI Solution

This module enables students to plan the components of a BI Solution.

Lessons

  • Elements of a BI Solution
  • Planning a BI Project
  • The Microsoft BI Platform

Lab : Planning BI Solutions

After completing this module, you will be able to:

  • Describe the components of a BI Solution.
  • Identify the components of a BI Solution.
  • Plan a BI Project.

Module 2: Planning BI Infrastructure

This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.

Lessons

  • Considerations of BI Infrastructure
  • Planning Data Warehouse Hardware

Lab : Planning BI Infrastructure

After completing this module, you will be able to:

  • Describe the components of a BI Infrastructure and where you would use them.
  • Plan for the hardware requirements of a data warehouse implementation.

Module 3: Designing a Data Warehouse

This module describes how to design a data warehouse given a set of user requirements.

Lessons

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Design FACT tables

Lab : Designing a Data Warehouse Logical Schema

After completing this module, you will be able to:

  • Design a data warehouse.
  • Design dimension tables.
  • Design Fact tables.
  • Design a logical schema for a data warehouse.

Module 4: Designing an ETL solution

This lesson describes how to design an extract, transform and load (ETL) solution.

Lessons

  • ETL Overview
  • Planning for Data Extraction
  • Planning for Data Transformations
  • Planning for Data Loading

Lab : Designing an ETL Solution

After completing this module, you will be able to:

  • Describe the components of an ETL solution.
  • Design an ETL solution.

Module 5: Designing Analytical Data Models

This module describes how to design analytical data models for specific BI scenarios.

Lessons
  • Introduction to Analytical data Models
  • Designing Analytical Data Models

Lab : Designing Analytical Data Model

Lab : Designing Dimensions and Hierarchies

After completing this module, you will be able to:

  • Describe the features of an analytical data model.
  • Design an analytical data model.

Module 6: Planning a BI Delivery Solution

This module describes how to choose an appropriate delivery solution for a given scenario.

Lessons

  • Considerations for BI delivery
  • Common Reporting Scenarios
  • Choosing a Reporting Tool

Lab : Planning a BI Delivery Solution

After completing this module, you will be able to:

  • Describe the components of a BI delivery solution.
  • Describe some common reporting scenarios.
  • Choose an appropriate delivery solution for a given scenario.

Module 7: Designing a Reporting Services Solution

This module describes how to design a reporting services solution.

Lessons

  • Planning a Reporting Solution
  • Designing Reports
  • Planning Report Consistency

Lab : Designing a Reporting Services Solution

After completing this module, you will be able to:

  • Plan for a reporting Services solution.
  • Design reports for a reporting services solutions.
  • Plan for consistency of reporting

Module 8: Designing an Excel Based reporting Solution

In this module students will learn how to design a reporting solution using Excel.

Lessons

  • Using Excel for Data Reporting and Analysis
  • PowerPivot in Excel
  • Power View in Excel

Lab : Designing and Excel Reporting Solution

After completing this module, you will be able to:

  • Describe key features of excel reporting solutions.
  • Use PowerPivot in Excel to create reports.
  • Use Power View in excel to create reports.

Module 9: Planning a SharePoint Server BI Solution

This module introduces the use of SharePoint Server as a BI solution.

Lessons

  • Introduction to SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning Reporting Services Configuration
  • Planning PowerPivot Configuration
  • Planning for PerformancePoint Services

Lab : Implementing a SharePoint Server BI Solution

Lab : Implementing PerformancePoint Services

After completing this module, you will be able to:

  • Describe the components of a SharePoint Server BI solution.
  • Plan security for a SharePoint Server BI solution.
  • Plan reporting solutions for a SharePoint Server BI solution.
  • Describe the components of a PerformancePoint Solution.
  • Implement PerformancePoint services.

Module 10: Monitoring and Optimising a BI Solution

At the conclusion of this module you will be able to optimise and monitor a BI solution.

Lessons

  • Overview of BI Monitoring
  • Monitoring and Optimising the Data Warehouse
  • Monitoring and Analysing Analysis Services
  • Monitoring and Optimising Reporting Services

Lab : Monitoring and Optimising a BI Solution

After completing this module, you will be able to:

  • Describe the options for monitoring and optimising a BI solution.
  • Be able to monitor and optimise a BI solution.

Module 11: Operating a BI Solution

At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.

Lessons

  • Overview of BI Operations
  • ETL Operations
  • Data Warehouse Operations
  • Analysis Services Operations
  • Reporting Services Operations

Lab : Operating a BI Solution

After completing this module, you will be able to:

  • Describe the components to be managed in a BI Solution.
  • Be able to manage the components of a BI solution.

Read more ...

Interested? See prices or call +971 4 3199019

You'll sit the following exam at the Firebrand Training Centre during your accelerated course. This is covered by your Certification Guarantee:

Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

This exam will measure you on the following skills:

  • Plan business intelligence (BI) infrastructure (15-20%)
  • Design BI infrastructure (15-20%)
  • Design a reporting solution (20-25%)
  • Design BI data models (30-35%)
  • Design an ETL solution (10-15%)

Read more ...

Interested? See prices or call +971 4 3199019

Microsoft Official Curriculum

  • MOC 20467D Designing Business Intelligence Solutions with Microsoft SQL Server 2014

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 Certification Programs includes

  • 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 **
  • Near site testing, Transportation to/from Testing Center are provided ***
  • Accommodation, all meals, unlimited beverages, snacks and tea / coffee****
  • Examination Passing Policy

Please note

  • * Not on all courses
  • ** Examination vouchers are not included for the following courses: PMP, CAPM, CISA, CISM, CGEIT, CRISC and CISSP CBK Review
  • *** Not included in our PMP, CAPM, CISA, CISM, CGEIT, CRISC, or ITIL Managers and Revision Certifications
  • **** Accommodation not included on the CISSP CBK Review Seminar

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.

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.

Read more ...

Interested? See prices or call +971 4 3199019

Prior to sitting the course it is required that you have the following:

  • Knowledge of data warehousing and data modeling principles.
  • Experience with Microsoft Excel and Microsoft SharePoint Server 2013.

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 +971 4 3199019 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 +971 4 3199019