responsibilities:
- understand business requirements in bi context and design data models to transform raw
data into meaningful insights
- create dashboards and interactive visual reports using power bi
- identify key performance indicators (kpis) with clear objectives and consistently monitor those
- analysing data and present data through reports that aid decision-making
- convert business requirements into technical specifications and decide timeline to accomplish
- create relationships between data and develop tabular and other multidimensional data
models
- chart creation and data documentation explaining algorithms, parameters, models, and
relations
- skilled in analyses service, building tabular & multidimensional models (olap, cubes) on top
of dw/ dm/db.
- expert in complex dax and mdx queries.
- design and guide bi related it architecture components in the existing or new bi landscape
to ensure compliance with regulations, policies and standards.
- providing blueprinting, gathering requirements, designing, and rolling out bi solutions to
users.
- design conceptual, logical, physical data model.
- design, develop, test, and deploy power bi scripts and perform detailed analytics
- perform dax queries and functions in power bi
- analyse current etl process, define and design new systems
- data warehouse development and work with ssas, ssis, and ssrs
- redefine and make technical/strategic changes to enhance existing business intelligence
systems
- create customize charts and custom calculations as per requirements
- design, develop and deploy business intelligence solutions as per needs
- sql querying for best results, use of filters and graphs for better understanding of data
- work with users and team members at all level for performance improvement and
suggestions