Implementing Data Models and Reports with Microsoft SQL Server 2012 (70-466)

Interesseret i dette kursus? Send os en forespørgsel.
Register your interest now

Kursusinfo

  • Dette kursus varer 3 dage
  • Der medfølger kursusmateriale til dette kursus
  • Fuld forplejning (Morgenmad, frokost, eftermiddagskage samt kaffe og sodavand ad libitum)
  • Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her
  • Alle eksamensforsøg er inkluderet i prisen
  • Med i prisen hører MeasureUp Practice Test
  • Du har i alt adgang til din kursus-pc i 3 uger

Varighed

Dette kursus varer 3 dage

Materialer

Der medfølger kursusmateriale til dette kursus

Forplejning

Fuld forplejning (Morgenmad, frokost, eftermiddagskage samt kaffe og sodavand ad libitum)

Garanti for beståelse

Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her

Eksamens vouchere

Alle eksamensforsøg er inkluderet i prisen

Practice Tests

Med i prisen hører MeasureUp Practice Test

Remote adgang

Du har i alt adgang til din kursus-pc i 3 uger

Implementing Data Models and Reports with Microsoft SQL Server 2012 (70-466)

About this Course

Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution.
 
This instructor-led course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466

Audience Profile

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions.  Primary responsibilities include:
  • Implementing reporting solutions by using SQL Server Reporting Services.
  • Implementing multidimensional databases by using SQL Server Analysis Services.
  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services.
  • Create visualizations of data by using PowerView.
  • Create data mining solutions by using SQL Server Analysis Services.

At Course Completion
After completing this course, students will be able to:

- Describe the components, architecture, and nature of a BI solution.
- Create reports with Reporting Services.
- Create reusable report items that simplify self-service reporting.
- Manage report execution and delivery.
- Create a multidimensional database with Analysis Services.
- Implement dimensions in a cube.
- Implement measures and measure groups in a cube.
- Use MDX Syntax.
- Customize a cube.
- Implement a Tabular Data Model in PowerPivot.
- Use DAX to query a tabular model.
- Implement a Tabular Database.
- Use PowerView to create interactive data visualizations.
- Use Data Mining for Predictive Analysis.

Lignende kurser

MCSA: SQL Server 2012/2014 (70-461, 70-462 & 70-463) Skriv dig op som interesseret til dette kursus
Developing Microsoft SQL Server 2012 Databases (70-464) Skriv dig op som interesseret til dette kursus
SQL Server 2016/2014/2012/2008 R2: Performance Monitoring & Tuning 18 maj
Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1 (70-457) Skriv dig op som interesseret til dette kursus
Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467) Skriv dig op som interesseret til dette kursus