## PowerBI Overview Steps:
- open the dataset with notepad ++
- expand the fields
- Connect to data/customer_sales1
- talk through the dataset, what it means 
- click transform data - this opens power query editor.
- show the applied steps, first auto
- check data types
- choose colummns
- Note the applied steps we are accumlating
- add year column: Add Column --> highlight transaction date --> from date & time
- rename columns
- replace activity 'med' with 'medium'
- close and apply 
- note the data types in the fields view
- show the layout
- show how to get back to the query
- create a new measure and rename it 
- Insert a text box for a title 
- Show additional formatting 
- insert some measures: 
	Average Sale Amount = AVERAGE(customer_sales1[sale amount])
	Total Customers = COUNTROWS(customer_sales1)
- Insert a text box with smart text dynamic value for average sale amount
- Add donut chart for sale 
- add who are my customers title
- Add description bar plot for current customer, gender
- change title, add data labels
- add slicer for gender
- add slicer for year
- add slicer for marketing exposure
- add new page to explore some relationships
- look at bivariate relationships - sale amount average by year


