Mandatory Learnings for Power BI Beginners

1. Create connection with share point/Google sheet/folders.

   1. Know how to change the connection between GS to local excel, without getting rid of the original table,

                                                              i.      as everything is setup in dax based on this original table

                                                            ii.      as all the calc columns has been setup

                                                          iii.      Reference vs Duplicate Table; creating Bridge tables 

2. Date locale Date formatting.

   1. Know how to use dates efficiently in any format without running into date errors. 
      

3. Unpivot column.

   1. Other Columns

   2. Only Selected 
      

4. Merge columns in Transform data. 
   

5. Solutions and Challenges in Sorting 

   
   

6. Formats

   1. creating blank table for key measures.

   2. To keep data in proper data type format.

   3. Proper formulas indentation

   4. Spelling and proper punctuation 
      

7. Finding the errors and handle the errors during importing data in power query. 
   

8. Working with Dates(Calendar Table) –

   https://www.dataroars.com/post/how-to-create-a-calendar-date-table
   

9. Financial Calendar tables 
   

10. Time Intelligence using Dates 
    

11. UseRelationship for indirect columns 
    

12. Dynamic Formatting which is a new feature and can be done in Modelling (Relationship) pane 
    

13. Using Bookmarks, Selection pane, and Sync Slicers. 
    

14. Showing Latest Refresh Data/Time in a given timezone. 
    

15. Fields Parameter
    

16. Group By (Power Query)
    

17. Clearing and Giving permission in Data Source Settings.