- Collaborates with the business and with data analysts to understand requirements and business objectives for relevant reports & visualizations as well as underlying data model.
- Capable of identifying relevant data sources and attributes for use in model
Data Modeling:
- Designing and documenting efficient conceptual, logical, and physical data models to support business requirements.
- Understands how to deliver row and column-level security within the Power BI semantic model.
- Needs to be able to establish re-usable semantic data models within Power BI.
- Familiarity with running tabular Editor Best Practice Analyzer for adhering to modeling and DAX best practices.
- Creating relationships between tables and optimizing data structures.
Data Source Connectivity Setup:
- Connecting to various data sources (APIs, Big Query, ArcGIS map and feature layers, SQL databases, Excel files, etc.) including streaming datasets.
- Ensuring seamless data extraction and transformation.
- Collaborating with the members of Client Integrations team to ascertain available integration patterns.
DAX Formulas:
- Proficiency in writing DAX (Data Analysis Expressions) formulas.
- Calculated columns, measures, and custom calculations.
Report Creation:
- Designing and developing interactive and visually appealing reports and dashboards.
- Incorporating slicers, visuals, and drill-through functionality, including streaming and ArcGIS visuals.
- Needs to be cognizant of and adhere to accessibility standards (section 508).
- Capable of optimizing Power BI reports or making suggestions to underlying data model for performance, including the use of DAX Studio and built in Power BI performance tools.