Scribd Logo
Upload

Welcome to Scribd!

  • 77 views

    Power BI

    Uploaded by

    Gấu Bear
    Power BI is a business analytics tool that allows users to visualize and explore data across various platforms and devices. It includes services for the web, desktop applications, and mobile devices. Power BI builds on datasets, reports, dashboards, and tiles to provide insights. It connects to various data sources and allows for data transformation and modeling. Visualizations, publishing, exploration and other features help users understand and share business intelligence.

    Copyright:

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

    Power BI

    Uploaded by

    Gấu Bear
    77 views14 pages
    Power BI is a business analytics tool that allows users to visualize and explore data across various platforms and devices. It includes services for the web, desktop applications, and mobile devices. Power BI builds on datasets, reports, dashboards, and tiles to provide insights. It connects to various data sources and allows for data transformation and modeling. Visualizations, publishing, exploration and other features help users understand and share business intelligence.

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Power BI is a business analytics tool that allows users to visualize and explore data across various platforms and devices. It includes services for the web, desktop applications, and mobile devices. Power BI builds on datasets, reports, dashboards, and tiles to provide insights. It connects to various data sources and allows for data transformation and modeling. Visualizations, publishing, exploration and other features help users understand and share business intelligence.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    77 views14 pages

    Power BI

    Uploaded by

    Gấu Bear
    Power BI is a business analytics tool that allows users to visualize and explore data across various platforms and devices. It includes services for the web, desktop applications, and mobile devices. Power BI builds on datasets, reports, dashboards, and tiles to provide insights. It connects to various data sources and allows for data transformation and modeling. Visualizations, publishing, exploration and other features help users understand and share business intelligence.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 14

    Using Microsoft Power BI to

    Explore and Visualize Data


    [ Instructor Name ]
    [ Instructor E-mail ]
    Power BI
    Power BI is a suite of
    business analytics
    tools to analyze data
    and share insights,
    with tools for
    business users to gain
    access to their most
    important metrics in a
    single location across
    all devices and
    platforms.
    Tools & Platforms

    Services Desktop Mobile Embedded

    • Web-based • Windows only • Cross-platform • Report


    • All platforms • Robust design • Report viewers integration
    • Limited design tools • REST services
    tools • Query and • Create custom
    • Limited data modeling tools visualizations
    sources
    • Dashboards
    • Publishing
    Power BI Building Blocks

    • Visualizations
    • Datasets
    • Reports
    • Dashboards
    • Tiles
    Building Block Associations

    +
    DATA DEVICES
    SOURCES
    REPORTS VISUALIZATIONS
    DASHBOARDS
    Getting Data
    Power BI can connect to wide variety of data sources, including on-premises
    databases, Azure storage, Excel worksheets and a large number of 3 rd party services.

    • Clean and transform data


    with the Query Editor
    • Connect to advanced data
    sources and create
    transformations
    • “Massage” irregularly
    formatted data
    Modeling
    Modeling is the technique of creating a logical connections and
    relationships between data sources.

    • Create Calculated Columns


    • Optimize data models for
    better visuals
    • Create Measures and work
    with time-based functions
    • Create Calculated Tables
    Visualizations
    A visualization is a visual representation of data, such as a chart,
    graph, map, or other “visual” representations of data.

    • Line, bar, pie, stacked


    • Matrix/pivots
    • Key performance
    • Tree maps
    • Geo and filled maps
    • Slicers/filters
    • Custom visualizations
    Publishing & Sharing
    • Publish reports from Power BI
    Desktop to the Power BI Service
    • Print and export dashboards
    • Manually republish and refresh
    data
    • Create and connect to content
    packs
    • Integrate OneDrive for Business
    Exploring Data
    • Use Quick Insights
    • Ask questions using
    natural language
    • Create custom Q&A
    suggestions
    • Share Dashboards with
    your organization
    • Edit Tile details
    Data Analysis Expressions
    DAX is a collection of functions, operators, and constants that can
    be used in a formula, or expression, to calculate and return one or
    more values.
    • Measure
    Calculation on a collection
    of rows AFTER
    aggregation.
    • Calculated Column
    Calculation on each
    individual row BEFORE
    aggregation.
    Power BI Service Integration
    Power BI Service
    DEVELOPER
    integration is facilitated AZURE
    SUBSCRIPTION

    via Power BI
    Embedded. Power BI
    Embedded is an Azure
    AZURE
    service that enables DATA
    WORKSPACES WORKSPACE

    developers to surface
    Power BI data
    experiences within their APP

    applications.
    Hands-On Lab
    Power BI HOL.html
    © 2016 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
    The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it
    should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO
    WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

    You might also like