Job Title: Power BI with SQL

Relevant Experience: 4 years

Location: PAN India

CTC: Max :Open

Client: Tech Mahindra

Power BI Responsibilities



Recognize business requirements in the context of BI and create

data models to transform raw data into relevant insights.



Using Power BI, create dashboards and interactive visual reports.



Define key performance indicators (KPIs) with specific objectives and

track them regularly.



Analyze data and display it in reports to aid decision-making.



Convert business needs into technical specifications and establish a

timetable for job completion.



Create, test, and deploy Power BI scripts, as well as execute efficient

deep analysis.



Use Power BI to run DAX queries and functions.



Create charts and data documentation with explanations of

algorithms, parameters, models, and relationships.



Construct a data warehouse.

Use SQL queries to get the best results.

​



Make technological adjustments to current BI systems to improve

their performance.



For a better understanding of the data, use filters and visualizations.



Analyze current ETL procedures to define and create new systems.

Power BI Requirements & Skills



Background with BI tools and systems such as Power BI, Tableau,

and SAP



Prior experience in data-related tasks



Understanding of the Microsoft BI Stack



Mastery in data analytics



Should be proficient in software development.



Be familiar with MS SQL Server BI Stack tools and technologies,

such as SSRS and TSQL, Power Query, MDX, PowerBI, and DAX



Analytical thinking for converting data into relevant reports and

graphics.



Capable of enabling row-level data security



Knowledge of Power BI application security layer models



Ability to run DAX queries on Power BI desktop.



Proficient in doing advanced-level computations on the data set.



Excellent communication skills are required to communicate needs

with client and internal teams successfully.