DAX studio for evaluating DAX calc, vpaq metrics analysis, checking the queries running against the dataset etc.
Tabular editor for OLS, updating the RLS logic in the live model, creating all the empty partitions, current day partitions manually in case of dataset failures, to use BPA analyzer etc.
ALM tool kit for deployment
TMSL/XLMA endpoint to manually refresh tables, partitions etc.
DAX sound understanding of advanced dax functions is required to handle complex calculations
Dataset optimization query folding, incremental refresh policy and strategize the partitions for better refresh through put, must have clear understanding of vpaq metrics and fine tune the models wherever feasible
Security test if the candidate has exposure implementing security with the combination of both RLS & OLS.
Understanding of Capacity metrics dashboard is a must to monitor the datasets that consumes high computation, storage, time taken to complete the refresh etc. Gateway log analytics experience is a great plus.
SQL proficiency is a must for data validation, optimizing views/procedures, supporting sql based near real time reports.
Subscriptions and bursting should be good in developing paginated reports to share the data with external vendors.
Power Automate experience is required to an extent as we refresh the datasets via enhanced api calls, bursting, load smart sheets, csv file to the database etc.
