What is Power BI and why you should learn it?

    Power bi is a visualisation and analytics tool which helps you aggregate and present your data in the form of stories so the end users understand the data patterns and can make better data driven decisions in the business

    In Today’s world, where time is money, Power BI allow users to quickly create and publish report which is instantly available for all users in the network. Big companies are moving on PowerBI to view dashboard. Power BI have huge job markets.

    You will learn it all

    Introduction

    • Introduction to business intelligence
    • Introduction to data analysis
    • Introduction to data visualization
    • Overview of self-service BI
    • Considerations of self-service BI
    • Microsoft tools for self-service BI
    • Power BI vs. SSRS Report
    • Configure tools

    Getting Started

    • SQL Query Syntax
    • Data Types
    • Joins
    • Inner Join
    • Left Join
    • Right Join Aggregates
    • Grouping

    Creating Data Model

    • Using Excel as a Power BI data source
    • Using databases as a Power BI data source
    • The Power BI service
    • Import data into Power BI
    • Transforming Data

    Data Operations

    • Creating Relationships
    • Defining New Columns
    • Concatenating Columns
    • Performing Lookup
    • Translating
    • Adding Date Table

    Enhancing Model

    • Defining Hierarchies
    • Configuring Properties e.g. Data Categories, Formatting
    • Creating Measures

    DAX (Data Analysis Expression)

    • Introduction to DAX Functions
    • Types of DAX (DAX Calculations)
    • Working with DAX Studio
    • It All Begins With EVALUATE
    • EVALUATE Options
    • Controlling Query Row Output: The Basics
    • Controlling Query Row Output: More about Filters
    • Controlling Column Output and Grouping Basics
    • Controlling Output Grouping: More with SUMMARIZE
    • Special Output Needs: Cartesian Products
    • More Sophisticated Cartesian Products
    • Special Output Needs: Scalar Values
    • Working with Inline Measures

    Building Dashboard

    • Visualizing Data
    • Adding Visuals
    • Filtering
    • Slicer Filtering
    • Highlighting
    • Setting Properties
    • Drilling within the Hierarchy

    Publishing Dashobard Online

    • Publishing Data Sets
    • Refreshing Data
    • Power BI Mobile Apps
    • Using Power BI Gateway
    • Power BI Pro vs. Free
    • Publishing To Power BI
    • Setting Up Auto-Refresh
    • Securing Data

    A Live Project

    At this point, we will be doing one live with you. we will see some more advanced features when working on live project.

    Duration : One Week – 2 Hours/Class

    Method : TeamViewer Screen/Audio Share

    Training Fee : Rs. 12000/-

    Payment Option : Online/PayTM

    Live Screen sharing

    We do live screen sharing for our session for 40-60 minutes, that enable you to ask questions at the same time.

    Session Video

    We records entire session and send you for your practice reference.

    On Job Support

    We help you on your projects after completion of training.

    Contact Now!!

    Loading...
    Open chat
    1
    Powered by Join.chat
    Welcome! How can i help you?