Hy There👋
Obejctive of Project:-
1.I was introduced to pivit tables and used them for analytics. 2.Explored the Pivot table options and did some formatting also conditonal formattings . 3.Used Power Pivot and DAX for Powerful businesss Reports. 4.Introduced to Data modelling and added targets using it in Power Pivot. 5.Breaking down of complex problems elevating the thinking processs. 6.Introduced to business metrices and terms.
ABOUT the project work :-
I was provided with the two csv files named-
- fact_bookings :- -This table contained various columns, including booking_id,property_id,check_in_date,month,week_no,booking_platform,ratings_given,booking_status,successful_bookings, and capacity. This filed contained details about every booking made for a specific property/hotel.
-dim_properties:-
-
dim_properties:- this file contained the additional details about each property.
.......Steps I performed ........
1.Imported the two CSV files to DATA MODEL and made connections .
2.Used the Diagram view to establish a relationship between the two tables bu connecting with common column.
3.Created a Pivot table and generated the DAX measures as per the specifications that were provided.
4.Used sum(),Count(), and Average() functions to create the DAX measures.
Genreated two Reports :- /
1.Showing Booking platform by weeks.
2.Showing the Atliq bookings in months of June and July .
🔚 //