Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Norge)
On this accelerated 3 day MCSE: Data Management and Analytics (Business Intelligence Solutions) 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.
You'll be prepared for and sit the 70-746: Designing Business Intelligence Solutions with Microsoft SQL Server exam, which is covered for by your Certification Guarantee. Exam 70-746 is an elective for MCSE: Data Management and Analytics certification.
After completing this course, you'll be able to:
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.
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.
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 Learning Partner, which means we'll make sure you have access to the latest curriculums and the most up-to-date content.
This module enables students to plan the components of a BI Solution.
Lessons
Lab : Planning BI Solutions
After completing this module, you will be able to:
This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.
Lessons
Lab : Planning BI Infrastructure
After completing this module, you will be able to:
This module describes how to design a data warehouse given a set of user requirements.
Lessons
Lab : Designing a Data Warehouse Logical Schema
After completing this module, you will be able to:
This lesson describes how to design an extract, transform and load (ETL) solution.
Lessons
Lab : Designing an ETL Solution
After completing this module, you will be able to:
This module describes how to design analytical data models for specific BI scenarios.
LessonsLab : Designing Analytical Data Model
Lab : Designing Dimensions and Hierarchies
After completing this module, you will be able to:
This module describes how to choose an appropriate delivery solution for a given scenario.
Lessons
Lab : Planning a BI Delivery Solution
After completing this module, you will be able to:
This module describes how to design a reporting services solution.
Lessons
Lab : Designing a Reporting Services Solution
After completing this module, you will be able to:
In this module students will learn how to design a reporting solution using Excel.
Lessons
Lab : Designing and Excel Reporting Solution
After completing this module, you will be able to:
This module introduces the use of SharePoint Server as a BI solution.
Lessons
Lab : Implementing a SharePoint Server BI Solution
Lab : Implementing PerformancePoint Services
After completing this module, you will be able to:
At the conclusion of this module you will be able to optimise and monitor a BI solution.
Lessons
Lab : Monitoring and Optimising a BI Solution
After completing this module, you will be able to:
At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.
Lessons
Lab : Operating a BI Solution
After completing this module, you will be able to:
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:
To achieve the MCSE: Data Management and Analytics certification, you are required to pass exam 70-746 as well as the exams aligned to one of the following MCSA:
Prior to sitting the course it is required that you have the following:
Vi har lært opp 134.561 personer på 12 år. Vi ba dem om å anmelde vår akselererte opplæring. Akkurat nå har 95,30% angitt at Firebrand overgikk forventningene:
"Great trainers and facilities, and being away from work & family really helps you focus on the material."
R.C.M., PGI - Protection Group International Ltd.. (22/4/2024 (Mandag) til 27/4/2024 (Lørdag))
"Excellent training. Material and instructor very good. Good facilities. Preferred method of learning moving forward."
J.B.. (22/4/2024 (Mandag) til 27/4/2024 (Lørdag))
"The in-person training is always effective. I have never done certification before I have around 20+ yrs of exp and I did my first one with Firebrand. The only reason I passed the exam due to focused time and no distraction."
Arul Jayaraman, Yayati consulting ltd. (22/4/2024 (Mandag) til 27/4/2024 (Lørdag))
"The course was very interesting and interactive."
Matthew Clulee, Venture Systems Group. (23/4/2024 (Tirsdag) til 26/4/2024 (Fredag))
"A good training course, with experienced and knowledgeable instructor, reacting to skills and experience level of the class students."
Mike Hilton, WWF-UK. (22/4/2024 (Mandag) til 24/4/2024 (Onsdag))
Start |
Slutt |
Kapasitet |
Plass |
Registrer deg |
---|---|---|---|---|
26/8/2024 (Mandag) |
28/8/2024 (Onsdag) |
Ferdig - Gi tilbakemelding |
- |
|
|
|
|
|
|
10/2/2025 (Mandag) |
12/2/2025 (Onsdag) |
Begrenset kapasitet |
Landsdekkende |
|
24/3/2025 (Mandag) |
26/3/2025 (Onsdag) |
Ledige plasser |
Landsdekkende |
|
5/5/2025 (Mandag) |
7/5/2025 (Onsdag) |
Ledige plasser |
Landsdekkende |
|
16/6/2025 (Mandag) |
18/6/2025 (Onsdag) |
Ledige plasser |
Landsdekkende |
|