Power BI
Introduction
• A data visualization and reporting platform.
• Primarily designed for business intelligence purposes.
• Introduces by Microsoft in 2013 as a part of power platform.
• Initially started as a service for SSRS(SQL Server Reporting
Service).
• This platform enables data preparation, data visualization,
distribution, and management through development tools and
an online platform.
Power BI as a platform
• Power BI is a collection of tools.
• But it exists as a part of much bigger service.
• It consist of 3 separate tools,
• Power BI Desktop
• Power BI Service
• Power BI Mobile App(s) in Android / IOS etc.…
• We are using Power BI Desktop
Uses of Power BI
• Creating reports and dashboards that present data sets in multiple ways using
visuals .
• Connecting various data sources, such as Excel sheets, onsite data warehouses,
and cloud-based data storage, and then transforming them into business insights.
• Turning data into a wide range of different visuals, including pie charts,
decomposition trees, gauge charts, KPIs, combo charts, bar and column charts,
and ribbon charts – among many other options.
• Providing company-wide access to data, data visualization tools, and insights in
order to create a data-driven work culture.
Who uses Power BI?
• Business analysts
• Business intelligence analysts
• Supply chain analysts
• Data analyst
Terms used in Power BI
ETL Process with Power BI
• Power BI is widely used for self-service BI and integrates ETL
directly into its workflow using Power Query and Dataflows.
• Power Query Editor
• Extract: Connects to 100+ data sources.
• Transform: UI for data cleaning, merging, filtering, pivoting, etc.
• Load: Loads data into Power BI datasets or dataflows.
• M Language: Advanced users can write custom transformation scripts.
ETL Process with Power BI
• Dataflows
• Cloud-based ETL pipelines using Power Query Online.
• Reusable across multiple reports and datasets.
• Integration with Azure Data Lake for scalable storage
Dashboard building with Power BI
• Drag-and-drop visuals (bar, line, map, matrix, etc.).
• DAX (Data Analysis Expressions) for calculated columns and
measures.
• Real-time dashboards with streaming data.
• Sharing and collaboration via Power BI Service and Microsoft
Teams.
Oracle BI
Introduction
• Oracle Business Intelligence (Oracle BI) is a package of tools
and technologies designed to provide comprehensive business
analytics, reporting, and data visualization capabilities.
• It enables organizations to make data-driven decisions by
transforming raw data into actionable insights.
ETL Process with Oracle BI
• Oracle BI includes tools like Oracle Data Integrator (ODI) and
Oracle BI Publisher, which support ETL and reporting.
• Oracle Data Integrator (ODI)
• Extract: Connects to various data sources (Oracle DB, SQL Server, flat
files, etc.).
• Transform: Uses declarative design (ELT model) to define
transformation logic.
• Load: Loads transformed data into target data warehouses or marts.
• Knowledge Modules: Reusable components for data integration tasks.
• Scheduling and Automation: Built-in scheduler for automating ETL
workflows.
Dashboard building with Oracle BI
• Drag-and-drop interface for creating interactive dashboards.
• Supports KPIs, charts, pivot tables, and scorecards.
• Integration with Oracle BI Publisher for pixel-perfect reports.
• Role-based access control for secure data visualization.
Alternative tools
• Tableau
• Domo
• Yellowfin
• Qlink Sense
• SAP Business Intelligence
16
