Scribd Logo
Upload

Welcome to Scribd!

  • 41 views

    MIMU What Is PowerBI May2022

    Uploaded by

    waiyan.yasuda
    Power BI is a business analytics tool from Microsoft that allows users to connect to data, transform it, and create interactive reports and dashboards. It has a free desktop version and a version hosted on the Power BI service. The Power BI ecosystem includes tools like Power Query for data transformation and DAX for writing formulas. It integrates with other Microsoft products and has a marketplace for extensions. Power BI can be used for free with a work email but also has premium paid plans for additional capabilities and higher data limits.

    Copyright:

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

    MIMU What Is PowerBI May2022

    Uploaded by

    waiyan.yasuda
    41 views17 pages
    Power BI is a business analytics tool from Microsoft that allows users to connect to data, transform it, and create interactive reports and dashboards. It has a free desktop version and a version hosted on the Power BI service. The Power BI ecosystem includes tools like Power Query for data transformation and DAX for writing formulas. It integrates with other Microsoft products and has a marketplace for extensions. Power BI can be used for free with a work email but also has premium paid plans for additional capabilities and higher data limits.

    Original Title

    MIMU_What_is_PowerBI_May2022

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Power BI is a business analytics tool from Microsoft that allows users to connect to data, transform it, and create interactive reports and dashboards. It has a free desktop version and a version hosted on the Power BI service. The Power BI ecosystem includes tools like Power Query for data transformation and DAX for writing formulas. It integrates with other Microsoft products and has a marketplace for extensions. Power BI can be used for free with a work email but also has premium paid plans for additional capabilities and higher data limits.

    Copyright:

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

    MIMU What Is PowerBI May2022

    Uploaded by

    waiyan.yasuda
    Power BI is a business analytics tool from Microsoft that allows users to connect to data, transform it, and create interactive reports and dashboards. It has a free desktop version and a version hosted on the Power BI service. The Power BI ecosystem includes tools like Power Query for data transformation and DAX for writing formulas. It integrates with other Microsoft products and has a marketplace for extensions. Power BI can be used for free with a work email but also has premium paid plans for additional capabilities and higher data limits.

    Copyright:

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

    Power BI Online Training

    Power BI ဆသ
    ို ည်မှာ

    The video file and other learning materials can


    also be downloaded through the MIMU website. May - 2022
    https://themimu.info/training-resources/home

    1
    Introduction
    Objective
    This course has been developed by the Myanmar Information Management Unit / MIMU to support the
    information management needs of those engaged in humanitarian, development and peace-focused
    activities across Myanmar for analysis and decision-making.

    This product has been prepared for operational purposes only, to support humanitarian and development
    activities in Myanmar. The data used for these training products is sample data and may not reflect the
    actual situation. Place names are from the General Administration Department, Ministry of Home
    Affairs. The MIMU and the United Nations cannot be held responsible for any errors or omissions in this
    product, nor for any misuse or misinterpretation of any information.

    Attribution: MIMU products are not for sale and can be used free of charge with acknowledgement of
    the Myanmar Information Management Unit (MIMU).

    Disclaimer: The boundaries and names shown and the designations used on this product do not imply
    official endorsement or acceptance by the United Nations

    Copyright © Myanmar Information Management Unit 2022.

    Contact We welcome your feedback and comments through info.mimu@undp.org


    Power BI ဆိုတာ ဘာလဲ
    • BI stands for Business Intelligence
    • Business Analytics Service of Microsoft
    • Power BI Desktop Free
    • Integrate with Office 365
    • Connect, Transform, Analytics, Visualize, Share
    • And many other developer options…
    Power BI History
    2010 : originally conceived by Thierry D'Hers and Amir Netz of
    the SQL Server Reporting Services Team at Microsoft
    2010 : Project Crescent , designed by Ron George
    2011 : Initially available for public download bundled with SQL
    Server Codename Denali.
    2013 : Later renamed to Power BI for Office 365
    based on the Microsoft Excel–based add-ins: Power Query,
    Power Pivot and Power View
    2015 : Power BI was first released to the general public
    Power BI ကဘ
    ို ယ်သတ
    ူ သ
    ွေ ုံးို မဲ
    •First of their aim was Business Users
    •Later it was widely use by General Public for Reporting and Data
    Analytics
    •Office365 Users
    •Power BI Service use by work email for free
    Power BI Eco System

    Core, Power BI Core, Non-Power Non Core, Power


    Specific BI Specific BI Specific

    Natively Integrated The Extended


    Microsoft Power BI Eco
    Technology System
    Core, Power BI Specific
    Power BI Desktop
    • Free
    • Support only Windows

    Power BI Service
    • Work Email
    • Software as a Service
    • Originally Power BI for Office 365
    • Some data sources can directly connect from Power BI Service
    Core, non-Power BI Specific
    Power Query
    • Microsoft Technology to connect data and transformation
    • 100 different sources and transformation without code
    • Also can get as a software
    Data Analysis Expressions (DAX)
    • Programming language
    • Functions, operators and constants to write formulas
    • Similar to Excel Functions
    • DAX is power BI Equivariant
    Continued to next slide
    Core, non-Power BI Specific
    On-premises data gateway
    • Gateway make access local data sources to Power BI service
    • Personal Mode – Only Can Use with Power BI
    • Enterprise Mode – Can use with Microsoft Flow, Power Apps…

    SSAS (Tabular)
    • In memory-database
    • Model the data with relational constructs such as Table and
    Relationships

    Continued to next slide


    Core, non-Power BI Specific

    Microsoft App Source


    • Marketplace for finding apps, add-ins
    and extensions…
    • Custom visuals can available up there
    Non-core, Power BI Specific
    Power BI Report Server
    • On premise technology
    • Superset of SSRS

    Power BI Embedded
    • REST APIs
    • To display visualization, reports, and dashboards
    • Often used by Independent Software Vendors
    Continued to next slide
    Non-core, Power BI Specific
    Power BI Mobile Applications
    • Native Android, iOS and Windows phones
    • Able to view the reports which published to Power BI
    Service

    Power BI for mixed reality


    • Based on Power BI Mobile app
    • Designed to work with HoloLens
    Natively Integrated Microsoft
    Technologies

    Office 365 Excel Microsoft Flow PowerApps

    SharePoint Azure ML
    Technologies
    The Extended Power BI
    Technologies

    APIs SDKs Python

    R SVG
    Power BI License
    Power BI Free (Desktop is free, Service can register with work mail)
    • 1GB for Dataset, 10GB for All – Eight Refresh Per day 30 minute interval

    Power BI Pro ($9.99 per month)


    • Capacity is same as Free except on premise gateway available
    • Power BI Premium, Embedded, and Report Server still need account for each users

    Power BI Premium
    • (Capacity based, monthly) (From $5000 to $80,000)

    Power BI Embedded
    • (For Developer, hourly) (From $750 to $24000)

    Power BI Report Server


    • ($4000 - $7000 percore)
    DAX vs Power Query M
    Power Query
    • Importing, Transforming, Shaping
    • Pipeline Use
    DAX
    • Data Analysis
    • Row Level Security
    • Similar to Excel Formula
    Power BI Minimum
    Requirements for Hardware
    • Windows 8.1 / Windows Server 2012 R2, or later
    • .NET 4.6.2 or later
    • Internet Explorer 11 or later
    • Memory (RAM): At least 2 GB available, 4 GB or more recommended.
    • Display: At least 1440x900 or 1600x900 (16:9) required. Lower resolutions such as
    1024x768 or 1280x800 aren't supported, as certain controls (such as closing the startup
    screen) display beyond those resolutions.
    • Windows display settings: If you set your display settings to change the size of text, apps,
    and other items to more than 100%, you may not be able to see certain dialogs that you
    must interact with to continue using Power BI Desktop. If you encounter this issue, check
    your display settings in Windows by going to Settings > System > Display, and use the
    slider to return display settings to 100%.
    • CPU: 1 gigahertz (GHz) 64-bit (x64) processor or better recommended.

    You might also like