Building reports using the powerful tool Power Query on Excel.
Automate data extraction tasks from web or Excel tables. Other data sources such as CSV and databases can be automated as well.
Develop custom measures that can track your KPIs and metrics. With the use of Excel Power Query, we can automate the data clean up utilizing DAX (Data Analysis Expression)