Dallas-Ft Worth, TX
El Paso, TX
Kansas City, MO
New York, NY
|Toronto, ON||09/09-09/13||Virtual Classroom||09/09-09/13||Wash Metro Area, DC||09/09-09/13||Vancouver, BC||09/09-09/13||Tulsa, OK||09/09-09/13||San Francisco, CA||09/09-09/13||Sacramento, CA||09/09-09/13||Richmond, VA||09/09-09/13||Pittsburgh, PA||09/09-09/13||Parsippany, NJ||09/09-09/13||Ottawa, ON||09/09-09/13||Omaha, NE||09/09-09/13||Oklahoma City, OK||09/09-09/13||Kansas City, MO||09/09-09/13||Framingham, MA||09/09-09/13||Denver, CO||09/09-09/13||Columbus, OH||09/09-09/13||Chicago, IL||09/09-09/13||Calgary, AB||09/09-09/13||Baltimore, MD||09/09-09/13||Ottawa, ON||12/02-12/06|
[ Select a date to register ]
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 five-day 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.
5 Days/Lecture & Lab
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 least 2 years' experience of working with relational databases, including:
Designing a normalized database.
Creating tables and relationships.
Querying with Transact-SQL.
Some basic knowledge of data warehouse schema topology (including star and snowflake schemas). Some exposure to basic programming constructs (such as looping and branching). An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Last Update: June 18, 2013