Course overview
The Microsoft Certified Solutions Associate (MCSA) certification focuses on the ability to design and build technology solutions, which may include integrating multiple technology products, and span multiple versions of a single technology, whether on-premises or in the cloud.
An individual can choose to become a certified Associate in one or several Microsoft technologies. This certification bundle is ‘SQL 2016 Business Intelligence (BI) Development’ focused.
By gaining this MCSA certification, you can prove your mastery of the primary set of SQL 2016 BI Development skills required to reduce IT costs and deliver more business value.
Upon completion of this course, you’ll receive a Microsoft MCSA ‘Acclaim’ badge in SQL 2016 BI Development that you can add to your CV or social media profile for prospective employers to see. You’ll also receive a Microsoft certification validating your SQL 2016 BI Development skills.
What you'll learn
- Designing and implementing an effective data warehouse, including dimension tables, fact tables, indexes, storage, partitioning, and more
- Establishing successful processes for extracting, transforming, and loading data (ETL) with SQL Server Integration Services (SSIS) and Transact-SQL (T-SQL)
- Integrating solutions that encompass cloud data and big data, using Polybase Integrate, Hadoop Integrate, the Azure Blob service, and related tools
- Ensuring high levels of data quality with a Data Quality Services (DQS) knowledge base and a Master Data Services (MDS) model
- Design a multidimensional BI semantic model
- Design a tabular BI semantic model
- Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
- Configure and maintain SSAS
Recognition
Study method
- Online
- Blended
- In-class
Duration study load
Learners can complete a course within this bundle from anywhere between 30-60 days. Revision for each exam will take a minimum of 2 weeks. We recommend you spend at least 6 hours on the course per week to be able to finish it within 12 months or sooner. You will have full access to the course material and resources for 12 months and must take your exams within this period.
Course features
- Expert instructor-led training
-
Visual demonstrations & multimedia presentations
-
Quizzes & exam simulators
- Flash cards & educational games
-
Navigation & controls
Features of MeasureUP practice tests:
- Questions are similar to exam questions, allowing you to test your knowledge of exam objectives
- Detailed explanations for both correct and distractor answers reinforce the material
- ‘Study Mode’ covers all objectives ensuring topics are covered
- ‘Certification Mode’ (timed) prepares students for exam taking conditions
- Instant, drill-down score reports tell you exactly the areas to focus on
Assessment
Certification exams included:
- Microsoft 70-767 Implementing a SQL Data Warehouse
- Microsoft 70-768 Developing SQL Data Models
MeasureUP practice tests included:
- Microsoft 70-767 Implementing a SQL Data Warehouse
- Microsoft 70-768 Developing SQL Data Models
Materials
Your course can be done from anywhere in the world. If you decide to move to a different city or even country, you can continue with the course from wherever you are. All you need is a device such as a desktop computer, laptop, tablet, smartphone, and an internet connection.
Delivery
What is an MCSA?
Subjects
- Design and Implement a Data Warehouse
- Extract, Transform, and Load Data
- Integrate Solutions with Cloud Data and Big Data
- Build Data Quality Solutions
- A: Design a Multidimensional Business Intelligence (BI) Semantic Model
- B: Design a Tabular BI Semantic Model
- C: Develop Queries Using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
- D: Configure and Maintain SQL Server Analysis Services (SSAS)
About Hudson
In the confusing world of e-learning, Hudson is quite simply one of the best at what they do. Why? Because they offer first-class customer service. The Hudson Learning Center puts their customers’ needs before anything else. If there’s something they can do to help you, Hudson will climb mountains to do it.
The Hudson online courses, certifications, and diplomas are highly effective, offering a whole range of features designed to get you certified faster. Some of these incredible features include video and audio based training so you can see and hear your tutor, 24/7 online tutor support, and online labs to practice your skills in a simulated environment.
Come and give Hudson a try. They’ll change the way you think about learning.
