Scribd Logo
Upload

Welcome to Scribd!

  • 1 views

    Power bi

    Uploaded by

    muk1997.muk

    Copyright:

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

    Power bi

    Uploaded by

    muk1997.muk
    1 views16 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Power bi

    Uploaded by

    muk1997.muk

    Copyright:

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

    Muhammad Umer Khan (973-2024)

    Rayyan Shaikh (1025-2024)

    To
    Sir Saleem
    Introduction to Computer
    Introduction to Power BI:
    • Microsoft’s business intelligence and data
    visualization tool.
    • Helps transform raw data into insightful
    reports and dashboards.
    • Ideal for making data-driven decisions in
    real time.
    Key Features of Power BI.
    • Data Integration: Connects to numerous data
    sources (e.g., Excel, SQL databases, cloud services).

    • Data Transformation: Cleans and organizes


    data using Power Query.

    • Data Visualization: Offers a variety of visuals,


    such as charts, graphs, and maps.
    Key Features of Power BI Con’t.
    • Dashboards: Combines visuals for an interactive, high-
    level view of metrics.

    • Collaboration and Sharing: Easy sharing of reports


    and dashboards within an organization.

    • AI and Machine Learning: Built-in AI tools for


    deeper insights.
    Components of Power BI
    • Power BI Desktop: Desktop tool for building
    complex reports.

    • Power BI Service (Online): Cloud platform


    for publishing and sharing.

    • Power BI Mobile: Access and interact with data


    on the go.
    Power BI Desktop Interface:
    •Navigation Pane (Fields, Visualizations, Filters)
    Power BI Desktop Interface Con’t.
    •Report Canvas (Where visuals are created)
    Power BI Desktop Interface Con’t
    • Ribbon (For data management, visuals, etc.)
    Power BI Desktop Interface Con’t
    • Query Editor (For data transformation)
    Use Cases of Power BI
    • Sales Analysis: Track performance, identify trends, and forecast sales.
    • Yearly wise Sale by product

    • Total Sales

    • Total Sales by Discount brands

    • Total sales by country

    • Total Profits
    Use Cases of Power BI
    • Customer Insights: Analyze customer behavior and feedback.
    • Customer Complaint.

    • New Customers.

    • No of Churns Customers.

    • Total Customers

    • Profits
    Use Cases of Power BI:
    • Operations and Logistics: Streamline supply chain and track efficiency.

    • Total Quantity

    • Order Details

    • Delay Orders

    • Profits
    Use Cases of Power BI:
    • HR and Employee Metrics: Monitor workforce productivity and
    engagement.
    • Total Employee’s Count

    • Active Employee’s

    • Left Employee’s

    • No of Employees' by Age.
    Connecting to Data Sources:
    • Excel: Easily load data from Excel workbooks, including
    tables, ranges, and PivotTables.
    • SQL Server: Connect directly to SQL Server databases to
    pull structured data for reporting and analysis.
    • Web data: Retrieve data from online sources, such as
    websites, APIs, or custom web scraping tools.
    • CSV Files: Power BI can load data from CSV (Comma-
    Separated Values) files, a widely used format for sharing data.
    • Cloud-based sources: Azure, Google Analytics, and other
    cloud services.
    Conclusion
    • Power BI is a powerful tool for creating insights that
    drive business success.

    • Enables better decision-making with its user-friendly,


    flexible, and scalable BI capabilities .
    T h an k You !

    You might also like