MS-MCSA-BI Reporting MCSA: BI Reporting (MS-MCSA-BI Reporting)

It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE). This boot camp prepares you for the following exams:
  • Virtual Classroom

    Learning Style
  • Intermediate

    Difficulty
  • 5 Days

    Course Duration
  • 5 Days

    SATV Value
Pricing
About Individual Course:
  • Individual course plan gives you access to this course
New
$3,495.00
$3,495.00
/ Seat
It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE). This boot camp prepares you for the following exams:

About this course:

Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

This boot camp prepares you for the following exams:

*Boot camp includes lunch, exam vouchers, and exam prep material where applicable.

Course Objective:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.
  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel.

Audience:

  • Students who are experienced with analyzing data with Excel and who wish to add BI techniques.
  • SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisite:

  • Excellent knowledge of relational databases and reporting.
  • 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.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Good Knowledge of Excel spreadsheets, functions, and charts.

Suggested prerequisite course:

Power BI for Excel 2013 - Level 1 - Report Builders (TLGPPTRB13)

More Information
Brand Microsoft
Lab Access No
Learning Style Virtual Classroom
Difficulty Intermediate
Course Duration 5 Days
Language English
SATV Value 5 Days
VPA Eligible VPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's