JD-Power BI Dev

Develop requirements, wireframes, and dashboards for varied audiences related to financial and project management related metrics. These dashboards will pull from multiple data sources and require the need to format and aggregate data. 

Top 3 Skills 

1. Power BI 

Visualization – Produce compelling and informative visualizations using various native and custom chart types. Create and maintain relationships between visuals, filters, bookmarks, and numeric/field parameters. Design strategic visual interactions that enhance the end-user’s experience using cross- filtering and cross- highlighting. 

DAX Language – Write and optimize DAX expressions to create measures and calculated columns. Familiarity with common filtering functions (CALCULATE, FILTER, etc.) and iteration functions (SUMX, AVERAGEX, etc.) 

Modeling – Create effective data models. Maintain relationship cardinality and cross- filtering between tables. Understand the use cases for Import, DirectQuery, Dual, and Live data storage modes. 

Publishing – Manage online deployment pipelines to test and publish Power BI reports. Manage user roles and implement row-level security to restrict data access. 

2. Power Query 

Preparation – Clean, transform, reshape, and aggregate data from different sources such as Excel, SQL Server, SharePoint, etc. Create dynamic, reusable queries using parameters. 

M Language – Knowledge of different data types and data structures like values, records, tables, lists, etc. Familiarity with built-in functions and the ability to write custom functions. Understand native query folding to optimize performance. 

3. SQL – Experience writing and optimizing queries. Strong understanding of relational databases