Terminologies in PowerBI (Business Intelligence)

By
Terminologies POWER BI ( BUSINESS INTELLIGENCE)
Power BI, a business intelligence tool by Microsoft, has its own set of lingo. Here's a breakdown of some common Power BI terminologies:
Data Acquisition and Transformation:
 1.Data Source: Where your data comes from, like a database or Excel sheet.
 2.Data Transformation (ETL): Cleaning and structuring your data for analysis.
 3.Data Gateway: Connects your on-premises data to Power BI for cloud access.
Report Building and Sharing:
 1.Publish: Sharing reports and dashboards in the Power BI Service (cloud-based platform).
 2.App Workspace: A collaborative space to share and develop reports.
Data Model:
 1.Dimension Table: Contains descriptive data (categories), often linked to a fact table.
 2.Fact Table: Stores numerical data for analysis, usually linked to dimension tables.
 3.Relationships: Connections between tables based on common fields.
 4.Star Schema: A common data model with a central fact table linked to dimension tables.
 5.Snowflake Schema: A normalized data model with dimension tables linked to each other.
Calculations and Analysis:
 1.Measures: Calculations used to summarize and analyze data, often created with DAX formulas.
 2.DAX (Data Analysis Expressions): A formula language for creating custom calculations in Power BI.
 3.Aggregations: Pre-calculated summaries of data to improve performance.
Filters and Interactions:
 1.Slicers: Interactive filters to narrow down data on visualizations.
 2.Filters: Criteria applied to control what data is shown in reports.
 3.Drill-Down: Navigating from high-level summaries to more detailed data.
 4.Drill-Through: Jumping from a summarized value to its underlying details in another report.
Security:
 1.Row-Level Security (RLS): Controls data access at an individual row level.
 2.Object-Level Security: Restricts access to specific report elements (like charts).

This is just a glimpse into the world of Power BI terminology. By understanding these terms, you'll be well on your way to becoming a Power BI whiz!!

Thank You 😊
Version Number :- 2.128.751.0
Date Published :- 4/8/2024

Comments

Post a Comment

Popular posts from this blog

Git & Git Hub Glossary (Terminologies)

By
Image
GitHub is a web-based platform that provides hosting for version control and collaboration. It allows multiple people to work together on projects from anywhere in the world. Here are some common terminologies associated with GitHub: - **@mention**: To notify a person on GitHub by using `@` before their username¹. - **Access token**: A token used in place of a password when performing Git operations over HTTPS with Git on the command line or the API¹. - **Branch**: A parallel version of a repository that does not affect the primary or main branch, allowing you to work freely without disrupting the "live" version¹. - **Commit**: A record of changes made to a repository. A commit includes a commit message that describes what changes were made¹. - **Fork**: A personal copy of another user's repository that's independent of the original repository¹. - **Issue**: A way to track enhancements, tasks, or ...
Read more

About SQL(Structure English Query Language) and it's terms

By
Image
SQL, or Structured Query Language, is a powerful programming language used for managing and manipulating relational databases. Here's an overview of its key components and capabilities: 1 . ** Data Querying **: SQL allows users to retrieve data from databases using SELECT statements. These statements can specify which columns to retrieve, filter data based on conditions, sort results, and perform calculations. 2 . ** Data Manipulation **: SQL supports INSERT, UPDATE, and DELETE statements for adding, modifying, and removing data from database tables. 3.  ** Data Definition **: SQL enables users to define the structure of a database using CREATE, ALTER, and DROP statements. These statements are used to create and modify database schemas, tables, indexes, and constraints. 4. ** Data Control **: SQL provides statements for managing access to database objects. Users can grant or revoke privileges such as SELECT, INSERT, UPDATE, DELETE, and EXECUTE to control wh...
Read more