MCSA: Business Intelligence Online Training

Focused View

Knox Hutchinson

5:53:15

54 View

1 - Microsoft SQL Designing a Data Warehouse

1 - Introducing Data Warehousing.mp4

06:24

2 - Selecting a Storage Subsystem.mp4

06:59

3 - Redundant Array of Independent Disks (RAID) Levels.mp4

06:20

4 - Installing and Configuring SQL Server with SSIS.mp4

15:19

5 - Fact and Dimension Tables.mp4

04:54

6 - Star and Snowflake Schemas.mp4

06:02

7 - Designing Dimension Tables.mp4

05:07

8 - Dimension Table Details.mp4

04:44

9 - Slowly Changing Dimensions (SCD).mp4

04:42

10 - Designing Fact Tables.mp4

04:18

11 - Introducing SQL Indexes.mp4

03:21

12 - Clustered vs Non-Clustered Indexes.mp4

11:32

13 - Rowstore vs. Columnstore Indexes.mp4

07:39

14 - Introducing Data Partitioning.mp4

03:11

15 - Partition Ranges.mp4

04:32

16 - Implementing Partition Functions and Schemes.mp4

07:56

17 - Implementing a Sliding Partition Window.mp4

08:36

18 - Scale Out Solutions.mp4

08:08

2 - Microsoft SQL SSIS

1 - Introducing SSIS.mp4

06:38

2 - Introducing Flows.mp4

08:08

3 - Connection Manager.mp4

07:19

4 - Precedence and Expression Constraints.mp4

04:43

5 - SSIS in Action.mp4

06:37

6 - File Tasks.mp4

07:29

7 - Web Service Tasks.mp4

05:40

8 - Variables.mp4

08:42

9 - Transactions.mp4

05:00

10 - Checkpoints.mp4

04:29

11 - Profiling the Source Data.mp4

06:30

12 - Parallelism.mp4

05:47

13 - Basic Transformations.mp4

08:40

14 - Pivot.mp4

05:34

15 - Aggregations.mp4

07:35

16 - Fuzzy Data Transformations.mp4

08:30

17 - Slowly Changing Dimension (SCD) Data Flows.mp4

12:04

18 - SSIS Merge and Lookups.mp4

11:28

19 - Incremental Loading with T-SQL MERGE.mp4

10:55

20 - Enabling Change Data Capture (CDC).mp4

06:57

21 - Implementing CDC.mp4

09:39

22 - Debugging and Troubleshooting.mp4

05:00

23 - Securing SSIS Packages.mp4

04:53

24 - Deploying a Package to SSIS.mp4

05:06

3 - Microsoft SQL Data Quality

1 - Installing Data Quality Services (DQS).mp4

05:54

2 - Data Quality Knowledge Base (DQKB), Domains, and Attributes.mp4

08:06

3 - DQS Data cleaning.mp4

04:18

4 - DQS Data Flow Tasks in SSIS.mp4

05:28

5 - Handling Duplicates in DQS.mp4

06:49

6 - Installing Master Data Services (MDS).mp4

09:39

7 - Managing Master Data.mp4

08:03

8 - System Administration, MDS Hierarchies, and Business Rules.mp4

07:28

9 - Importing and Exposing Data in MDS.mp4

02:45

10 - Preparing for the 70-767 Exam.mp4

01:38

More details

The exam associated with this course has been retired. However, this course still retains value as a training resource.
This advanced Microsoft MCSA: Business Intelligence training covers the objectives in the 70-768 exam, which is one of the two exams required to earn the MCSA: SQL 2016 BI Development certification.
There are some data analysts who read about using multidimensional data models, maintaining OLAP cubes, or implementing tabular data models and they get excited -- while others brace themselves. Whether the idea of those business intelligence solutions excites you or fills you with dread, this training has got you covered. The Microsoft Certified Solutions Associate in SQL 2016 Business Intelligence Development (MCSA: SQL 2016 BI Development) certification is more than just a mouthful, it also covers challenging topics in developing SQL data models. But not to worry: you'll be ready for one of the two certifying exams with our MCSA: Business Intelligence training.
For anyone with data analysts on their team, this Microsoft training can be used for 70-768 exam prep, onboarding new data analysts, individual or team training plans, or as a Microsoft reference resource.
MCSA: Business Intelligence: What You Need to Know
For any data analyst using this training for exam preparation, our MCSA: SQL 2016 BI Development course maps to the Microsoft 70-768 exam objectives, and covers topics such as:
Implementing business intelligence solutions using multidimensional data models
Using online analytical processing (OLAP) cubes
Deploying and maintaining tabular data models
Configuring and maintaining SQL Server Analysis Services (SSAS)
Querying with multidimensional expressions (MDX) and data analysis expressions (DAX)
Who Should Take MCSA: Business Intelligence Training?
This MCSA: Business Intelligence training is considered associate-level Microsoft training, which means it was designed for data analysts. This SQL skills course is valuable for new IT professionals with at least a year of experience with data models and experienced data analysts looking to validate their Microsoft skills.
New or aspiring data analysts. If you're a new data analyst, or if you're considering entering the field, the need to design multidimensional business intelligence semantic models isn't so much a choice but an inevitability. Half of the MCSA: SQL 2016 is focused on using business intelligence data with high-quality models -- and this training covers that half of the exam.
Experienced data analysts. Data analysts who've been working for several years should recognize the value of knowing how to implement and maintain data models. This MCSA: SQL 2016 BI training gives you familiarity and expertise in designing, developing and creating them. If in your career so far you've missed out on using tabular BI semantic models, multidimensional expressions or data analysis expressions, this training can round out your knowledge.

User Reviews

Rating

average 0

Total votes0

Focused display

Business Intelligence

Knox Hutchinson

Instructor's Courses

The personal touch, coupled with the ability to go at your own pace, makes video training far and away the best way to learn.

Knox brings a wealth of data analysis and visualization experience to CBT Nuggets. Knox started off as a CBT Nuggets learner, became a mentor in our Learner Community, and is now a trainer. Having benefited from the CBT Nuggets Learning Experience firsthand, Knox creates training that connects with learners. Knox also has a wide range of IT experience. Prior to joining CBT Nuggets, Knox worked as an IT consultant, advising in a variety of areas including networking, cloud computing, and project management.

Certifications: Microsoft MCSE: Cloud Platform and Infrastructure, Microsoft MCP: Administering SQL Server 2012/2014 Databases, Cisco DevNet Professional, Cisco CCNP: Enterprise, Certified Meraki Network Operator (CMNO), JNCIA-JUNOS, JNCIA-DevOps, Tableau Desktop Qualified Associate, and CompTIA Network+

Areas of expertise: Data analysis and visualization, business intelligence solutions

CBT Nuggets

View courses CBT Nuggets

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.