Power BI ( Data Analytics )

    0
    111
    Map Unavailable

    Date/Time
    Date(s) - 17/02/2019
    10:30 am - 5:30 pm

    Categories No Categories


    To Book Your Ticket

    Payment method 1: click here

    Payment method 2: Payment via PAYTM on 9654976160, Please note that if you do payment on paytm then a cashback of 10% will be provided by us. You can choose any payment method

    (For employees of partner corporates, 20% cashback will be provided. After payment just tell us your employee ID and company name on 9654976160 / 9643749760)

    Welcome to the Training!
    If you have been tracking Satya Nadella recently – it seems even Microsoft wants to stop relying on MS Office!
    It is not just Satya Nadella.
    Jeff Bezos recently banned PowerPoint in his meetings.
    Wall Street Journal last year reported that finance chiefs worldwide are telling staff to start using Excel.
    Two Google alums launched Coda last year – aimed at providing an alternative solution to Excel.
    What is Power BI
    Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
    It is a free, self-service business intelligence cloud service that provides non-technical business users with tools for aggregating, analyzing, visualizing and sharing data.

    What We Will Cover

    Introduction

    What is good data
    Importing Data

    Advanced Data Cleaning tricks

    Connecting, Blending & Shaping Data

    Merge and Append queries

    Pivot vs. Unpivot data

    Conditional Columns

    Grouping & Aggregating data

    Segmentation: Use Grouping to cluster multiple items

    Segmentation: Use Binning to put values into equally sized groups

    Connecting, Blending & Shaping Data

    Table relationships

    “Snowflake” Schemas

    Visualizing Merge Join Types in Power BI (LEFT, RIGHT, INNER, OUTER)

    Adding a Calculated Column

    Adding a Measure

    New Measure or New Column – Which one to use when?

    Visualization Elements

    Essential Formatting settings: Color, Data Labels, Axis, Placement; Time series; Matrix Visuals; Date Slicers; Cards & KPIs; Text Cards; Map Visuals;

    Treemaps; Line & Area Charts; Trend Lines & Forecasts; Gauge Charts; Scatter Plot; Control Report Interactions; Drill down Filters; Report Bookmarks

    Projects

    Creating a dashboard

    Pulling data from the Web

    Doubts will be taken care of.

     

    To Book the tickets, Kindly use this Link

    Trainer

    Havish Madhvapaty (Co-Founder at Decode) is a doctoral student and a Microsoft Office Specialist Master.
    He is the author of 5 books (4 on analytics) and is a contributor to the global Microsoft community on MS Excel.

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here