Posts

Showing posts from August, 2023

HOW TO CREATE DASHBOARD USING POWER BI

Image
 Many Dataset available in Kaggle choose any one if you don't have here i have choosen HR dataset and loaded it as shown below Now as i have list of all Hiring Years  I will use Slicer option as shown : Now i will choose column that is required inside slicer  To make it look good we will go in slider settings and change it accordingly here i am doing it as a tile . then it will look like this  Now in visualization add some background color  now add color in tiles so for that click on tile and then in visualization in general go to effects and add color accordingly  this is how it will look like after adding color and some shadow accordingly now add different different plots and graphs according to data : THANK YOU!!!!

Data Modeling Using Power BI

Image
  Data modeling : It is the visual representation of data elements and the connection between them .  ER Diagrams : Entity relationship diagram basically it contains different symbols and attributes . Cardinality:- Many To One:-  In many to one relationship,   The column in one table can have more than one instance of a value, and the other related table, often knows as the lookup table, has only one instance of a value. One To One:-  In a one to one relationship, the column in one table has only one instance of a particular value, and the other related table has only one instance of a particular value. One To Many:-  In a one to many relationships, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value. Many To Many:-  We can establish a many-to-many relationship between composite tables, which removes requirements for unique values in tables. Step 1 : Click on get d...