phone  Contact Us  

Microsoft MCSA: BI Reporting Training Bundle

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


  • Insoft Training
    • Microsoft MCSA: BI Reporting Training Bundle
    4 days  (Instructor Led Online)  |  Microsoft MCSA SQL
    Enquire Now

    Course Details

    The Microsoft MCSA: BI Reporting Training Bundle helps you prepare for the MCSA BI Reporting certification in four days. The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. Also, this course gives students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

     

    You can also complete this certification by attending two separate courses:

    This training already retired on 30th of June 2020.
    See other Microsoft courses

    Objectives

    After completing this course, students will be able to:

    • 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 CSV files
    • 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

    Prerequisites

    Before attending this course, students must have:

    • 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
    • Familiarity with Microsoft Office applications – particularly Excel
    • Basic knowledge of the Microsoft Windows operating system and its core functionality
    • Working knowledge of relational databases
    • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals
    • Basic knowledge of data analytics