Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    PBI Reg Batch 41 Session 4 - May 17

    Uploaded by

    ram Dindu
    1. Create a report with visuals to show KPIs such as number of students by country, institute, department, and qualification. 2. Include visuals like cards, tables and charts to display student counts and percentages. 3. Add a timeline visual to enable time series analysis of active vs withdrawn classes over quarters and years.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    PBI Reg Batch 41 Session 4 - May 17

    Uploaded by

    ram Dindu
    22 views13 pages
    1. Create a report with visuals to show KPIs such as number of students by country, institute, department, and qualification. 2. Include visuals like cards, tables and charts to display student counts and percentages. 3. Add a timeline visual to enable time series analysis of active vs withdrawn classes over quarters and years.

    Original Description:

    POWERBI

    Original Title

    PBI Reg Batch 41 Session 4- May 17

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. Create a report with visuals to show KPIs such as number of students by country, institute, department, and qualification. 2. Include visuals like cards, tables and charts to display student counts and percentages. 3. Add a timeline visual to enable time series analysis of active vs withdrawn classes over quarters and years.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    22 views13 pages

    PBI Reg Batch 41 Session 4 - May 17

    Uploaded by

    ram Dindu
    1. Create a report with visuals to show KPIs such as number of students by country, institute, department, and qualification. 2. Include visuals like cards, tables and charts to display student counts and percentages. 3. Add a timeline visual to enable time series analysis of active vs withdrawn classes over quarters and years.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 13

    Creating Report in Power BI

    A Report is a combination of multiple Visuals


    Publishing On Power BI Service
    Power BI Service is a sharing tool to share the visualization with other users.
    You need to create a Power BI Service account and publish your creation on it
    Home - > Publish
    Publishing On Power BI Service
    Power BI Service
    Comments, Subscribe, Share
    Dashboard in Power BI
    In Power Bi dashboard can be created only in Power BI Service. To ad a visual you just
    need to pin the Visual to the dashboard.

    Dashboard can also be created through My workplace.


    Dashboard in Power BI

    PowerBi Dashboard are not interactive by default. To make the dashboard


    interactive you need to pin the live page.
    These are actually useful if you want to see the static view.
    Dashboard in Power BI
    • Power Bi dashboards are not interactive by default.
    • To make the dashboard interactive you need to pin the live page.
    • In the real time scenario Reports are majorly used.
    • These are actually useful if you want to see the static view.
    Refreshing Data in Power BI
    To refresh the data you need to go to : My workspace ->Datasets ->
    Refresh
    Refreshing Data in Power BI
    The Refresh failed message is displayed as the Data Gateway is not
    configured. To resolve this : Download & Install Data Gateway.

    • Refresh the dataset


    • Check for Username & password under
    My workspace ->Datasets -> Settings -> Data Source Credentials
    • Scheduled refresh (8 Schedules in Pro & 48 in Premium Account)
    Refreshing Data in Power BI
    Once the Gateway is installed and configured successfully, below
    confirmation will be displayed.
    Refreshing Data in Power BI
    Now try to refresh the Dataset. You may be prompted with the
    below message.

    To resolve this you need to


    specify the Data source
    credentials
    Scheduled Refresh in Power BI
    You can automate the refresh by scheduling a refresh.

    Turn on the Scheduled Refresh


    Specify the frequency (Daily / Weekly)
    Set the time
    Specify a refresh failure email recipient
    Apply

    Note : Refresh can be done 8 times a day in Pro Account


    In Premium account it can be done 48 times
    Visualize the data in any meaningful way to help the institute to analyse the
    data.
    Design a report for the planning data based on country, institute, department,
    year, quarter, and qualification.

    KPI
    • No of Students per Country
    • No of Students per Institute
    • No of Students per Department
    • No of Students per Qualification
    • Percentage of Withdrawn cases
    • Time series analysis of active and withdrawn classes

    You might also like