Description

Core Skills needed

Strong T SQL

Experience Creating Views

Experience in Tuning Queries

Power BI Architect (Hands on)

Experience in SSRS and TSQL

Dataset Modeling

Hands on DAX

Paginated Reports

Dashboards 

Experience in Power BI security setup best practices

Hands on Developer Experience with MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI at architect  and DAX

Semantic Dataset Modelling

  • Review existing models and advise on Best Practices

Report Development Experience

  • Hands on DAX experience
  • Dynamic Subscription knowledge
  • Paginated Reports
  • Dashboards
  • Drilling from a Summary Data Set to Detail Data set

Security Setup – Best Practices

  • Setup of Groups to control Works space Roles (Admin, Member, Contributor, Viewer)
  • Setup of Groups to control Works space Access
  • Best practices on how to organize Report Access
  • Best Practices on Row Level Security implementation

Power Automate for triggering dataset refreshes and report distribution

Experience working with GitHub Source Control for PowerBI

Objective:  Provide best practices for Set up BI tool set for an organization including administration of BI tools

Education

Any Graduate