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 ...
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 fiel...
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...
Comments
Post a Comment