20778B: Analyzing Data with Power BI




    3 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch

    Course Information

    This course will enable you to comprehend the understanding of data analysis with Power BI, the creation of the visualizations, Power BI Service and Mobile App.  

    Course Objective:

    On completion of the course, you will be able to:

    • Perform Power BI desktop data transformation, modeling, and visualization
    • Implementation of Power BI service
    • Describe Excel data connection and collaboration.
    • Describe Power BI developer API and mobile App.


    Module 1: Introduction to self-service BI solutions

    This module teaches you how to self serve with Business Intelligence [BI].

    Lessons: It introduces you to business intelligence, data analysis, visualization, overview, considerations, and tools of self-service BI.

    Lab: It explores the Enterprise BI solution


    Module 2: Introducing Power BI

    This module introduces you to the Power BI desktop and its features

    Lessons: The lessons include the Power BI and BI service

    Lab: The lab helps to create Power BI dashboard and connect to Power BI data


    Module 3: Power BI

    This module will help you to comprehend the advantages of using Power BI

    Lessons: The lessons enable you to Use Excel, databases as the data source,  comprehend the Power BI data model and service.

    Lab: It enables you to import excel files into Power BI and view reports.


    Module 4: Shaping and Combining Data

    This module helps to couple the data with built-in tools.

    Lessons: It includes learning of Power BI desktop queries, shape and combine data

    Lab: It gives practical knowledge on shaping and combining the power BI data.


    Module 5: Modeling data

    This module teaches you to shape and enhance the data.

    Lessons: It includes DAX queries, calculations, measures, and relationships.

    Lab: It enables you to crete relationship and calculations.


    Module 6: Interactive Data Visualizations

    This module enables you to create and manage the interactive data visualization

    Lessons: It helps you to create and manage the BI reports and solutions

    Lab: It will enable you to create Power BI reports and dashboard.


    Module 7: Direct Connectivity

    This module helps you to describe the Power BI connectivity options.

    Lessons: The lessons include learning of cloud data and analysis services connection

    Lab: It enables you to connect with Power BI desktop and services.


    Module 8: The Developer API

    On completion of this module, you will be able to describe the developer API.

    Lessons: You will learn about the custom visuals and developer API.

    Lab: You will learn to use developer API and custom visuals.


    • SQL Server Report Creators


    The students must have the prior knowledge of:

    • Relational databases and reporting
    • Data warehouse schema topology
    • Exposure to programming constructs, key business priorities
    • Microsoft Office applications and Excel in particular


    Name Code Fee



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.