Sale

Designing Self-Service Business Intelligence and Big Data Solutions (MS-20467)

This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform.
    • Learning Style
      Virtual Instructor-Led
    • Difficulty
      Beginner
    • Course Duration
      5 Days
This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform.
Start FREE Subscription Trial
Start Your 7-Day FREE Trial with our Master subscription plan that gives you access to this course PLUS:

  • 640 high impact technical, end user and learning & business management courses
  • Includes courses in multi-modality - 100% online self-paced + Virtual Instructor Led courses
  • Course completion certificates
  • Live instructor Coach, tech support and you will be assigned your personal Learning Concierge
  • 7-Day FREE Trial
    Then Billed As One Annual Payment of
    $1,499.00
    Every Year Until Canceled
  • Start FREE Trial
Purchase As Individual Course
  • Live Online Instructor Led Delivery
  • Attend from Home or Office
  • Guaranteed to Run Schedules
  • Virtual Hands-On Labs

  • Now Only $2,695.00 Regular Price $2,895.00
    Virtual Instructor-Led
  • Enroll Now
Purchase For Teams
Team Pricing Available - Request A Quote Today!

  • Group Discounts & Private Training Available
  • Free Learning Management Center
  • Group Reporting & Tracking
  • Author / Publish Your Own Courses
  • Request Team Enrollment

This course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.


    Course Objectives

    • Describe key features and benefits of self-service BI.
    • Use SQL Server Reporting Services to implement a self-service reporting solution.
    • Use PowerPivot in Microsoft Excel to create analytical data models.
    • Use Power Query in Microsoft Excel to import data into a data model.
    • Use Power View in Microsoft Excel to create interactive data visualizations.
    • Use Power Map in Microsoft Excel to create geographic data visualizations.
    • Use Microsoft SharePoint Server to implement collaborative self-service BI solutions.
    • Find and use public data in the Windows Azure Marketplace.
    • Use Microsoft Office 365 Power BI to implement cloud-based self-service BI solutions.
    • Provision and use a Windows Azure HDInsight cluster for Big Data analysis.
    • Use Pig and Hive to analyze big data in Windows Azure HDInsight.
    • Design and implement Big Data processes to support self-service BI.


    Audience

      The primary audience for this course is database and business intelligence (BI) 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.


    Prerequisites

    • Knowledge of data warehousing and data modeling principles.
    • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.
More Information
Brand Microsoft
Lab Access No
Technology Microsoft
Learning Style Virtual Instructor-Led
Difficulty Beginner
Course Duration 5 Days
Language English
SATV Value 5 Days
VPA Eligible VPA Eligible
Write Your Own Review
You're reviewing:Designing Self-Service Business Intelligence and Big Data Solutions (MS-20467)
Your Rating