Scribd Logo
Upload

Welcome to Scribd!

  • 81 views

    PowerBi Quick Insights? ??

    Uploaded by

    soumyatipkuntu
    Gartner has ranked Microsoft as a Leader in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for the thirteenth year in a row. Power BI is Microsoft's cloud-based self-service business analytics tool. It allows users to connect to over 170 data sources, transform data with Power Query, create reports and dashboards with Power View, and share insights with Power BI Service. Some key capabilities of Power BI include data modeling with Power Pivot, predictive analytics using Python scripts, and real-time dashboards with the Power BI mobile apps. While powerful, it also has some limitations around data volume, real-time data updates, and licensing costs.

    Copyright:

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

    PowerBi Quick Insights? ??

    Uploaded by

    soumyatipkuntu
    81 views63 pages
    Gartner has ranked Microsoft as a Leader in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for the thirteenth year in a row. Power BI is Microsoft's cloud-based self-service business analytics tool. It allows users to connect to over 170 data sources, transform data with Power Query, create reports and dashboards with Power View, and share insights with Power BI Service. Some key capabilities of Power BI include data modeling with Power Pivot, predictive analytics using Python scripts, and real-time dashboards with the Power BI mobile apps. While powerful, it also has some limitations around data volume, real-time data updates, and licensing costs.

    Original Description:

    this is Power BI notes

    Original Title

    PowerBi Quick Insights?‍??

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Gartner has ranked Microsoft as a Leader in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for the thirteenth year in a row. Power BI is Microsoft's cloud-based self-service business analytics tool. It allows users to connect to over 170 data sources, transform data with Power Query, create reports and dashboards with Power View, and share insights with Power BI Service. Some key capabilities of Power BI include data modeling with Power Pivot, predictive analytics using Python scripts, and real-time dashboards with the Power BI mobile apps. While powerful, it also has some limitations around data volume, real-time data updates, and licensing costs.

    Copyright:

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

    PowerBi Quick Insights? ??

    Uploaded by

    soumyatipkuntu
    Gartner has ranked Microsoft as a Leader in the 2023 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms for the thirteenth year in a row. Power BI is Microsoft's cloud-based self-service business analytics tool. It allows users to connect to over 170 data sources, transform data with Power Query, create reports and dashboards with Power View, and share insights with Power BI Service. Some key capabilities of Power BI include data modeling with Power Pivot, predictive analytics using Python scripts, and real-time dashboards with the Power BI mobile apps. While powerful, it also has some limitations around data volume, real-time data updates, and licensing costs.

    Copyright:

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

    Source: https://www.prnewswire.

    com/news-releases/data-analytics-market-size-to-
    grow-by-usd-196-47-billion--32-of-the-market-growth-will-originate-from-apac--17-
    000-technavio-reports-301521031.html
    https://zoommetrix.com/martech/tableau-
    market-share-business-intelligence-tools/
    While Excel begins to slow
    down when dealing with huge
    Gartner has ranked models, Power BI is designed
    Microsoft a to handle tables with more
    Leader in the than 100 million
    records without breaking a
    Gartner 2022 sweat
    Magic Quadrant
    for Analytics and
    It’s fairly uncommon for your
    Business Power BI Workbook (.PBIX file)
    Intelligence to be much less than your
    Platforms for the original data sets – in fact,
    thirteenth year in a row.
    1GB databases are
    typically compressed
    down to roughly 50 –
    200MB in size.
    170+ Data
    Sources Types in
    Power BI
    Power BI – Salient Features
    Top Companies Using Power BI

    ADOBE SIEMENS COCACOLA

    SHELL AIRBUS UNILEVER

    AIRBUS PEPSICO H&M

    DELL ACCENTURE Rolls-Royce

    Response generated by chatGPT!


    Gartner Magic Quadrant for
    Analytics and BI Platforms

    Source: https://www.gartner.com/reviews/market/analytics-business-
    intelligence-platforms
    2023 Gartner
    Magic
    Quadrant for
    Analytics and
    Business
    Intelligence
    Platforms

    https://powerbi.microsoft
    .com/en-
    in/blog/microsoft-named-
    a-leader-in-the-2023-
    gartner-magic-quadrant-
    for-analytics-and-bi-
    platforms/
    Challengers

    Visionaries
    Source:
    https://www.forbes.com/advis
    or/business/software/best-
    data-analytics-tools/
    POWERBI POPULARITY – GOOGLE TRENDS

    https://zoommetrix.com/martech/tableau-
    market-share-business-intelligence-tools/
    Limitations of Power BI

    Data Volume Real-time Data Data Limited Licensing Cost


    Limitation Updates Transformation Customization • Full capabilities
    • Max File Size = 1 • Designed for Complexity Options are high cost.
    GB periodic or • Complex ETL may • Most capabilities
    • Max Dataset for scheduled data need writing online or cloud
    Power BI pro = 10 refreshes scripts (DAX based
    GB • Support real-time language) • Limited
    but performance capabilities offline
    issues

    Response generated by chatGPT!


    Power Query Power Pivot Power View Power Map

    Power BI Power BI Power Service


    Power Q&A
    Desktop Website (SAAS)

    Data
    Power BI
    Data Catalog Management
    Mobile Apps
    Gateway
    Windows
    IoS
    Company’s Data Android
    POWER BI VS TABLEU
    HOW TO DO PREDICTIVE ANALYSIS USING PYTHON IN POWER BI
    Use Power Query Editor on your
    dataset and CCP your python code
    2 through add python script button

    Write your enter


    predictive analysis code
    1 in python [Code
    provided in GitHub]

    Use DAX to get prediction accuracy


    from selected cell
    Generate
    pie charts
    3 visuals for
    predictive
    outcome
    POWER BI SERVICE

    Top 15 Power BI Project Ideas For Practice


    2023 (mindmajix.com)
    Data Source(s)
    • Bank Churn Analysis by Gurpreet
    Video: End to End power BI Project – Customer Churn Analysis | Power BI
    Mastery, Source: https://www.youtube.com/watch?v=HHu0FLM6Fp0 , Data
    source: Download Bank Customer Churn Data: https://tinyurl.com/z4r3mv34
    • Telecom churn analysis by Satyajit, Video:
    https://www.youtube.com/watch?v=Xu5x-vn8J6M , github source
    https://github.com/pik1989/ChurnAnalysisProject-PowerBI/
    Presentation Sources
    • Data Modelling In Power BI | Types Of Data Modelling In Power BI | Power BI | Simplilearn
    https://youtu.be/-_DJPRrFQXI
    • https://oprismonicasimona.wixsite.com/biconsultancy/single-post/2016/03/30/user-
    experience-design
    • Power Bi vs Tableau | Power Bi And Tableau Difference | Which One To Choose?
    |Simplilearn ttps://www.youtube.com/watch?v=b_ODnhv68OI
    • Gartner Magic Quadrant for Business intelligence,
    https://www.gartner.com/reviews/market/analytics-business-intelligence-platforms
    • G2 Top 20 Analytics Platforms for enterprises, https://www.g2.com/categories/analytics-
    platforms?tab=highest_rated&utf8=%E2%9C%93&segment=enterprise&region=

    You might also like