MIS Executive

Ranko Metals Private Limited

1 - 2 Years
1 Openings
1.3 - 2.0 Lac/Yr
Face-to-Face interview
Balanagar, Hyderabad - Kukatpally, Medchal

Key Skills

Microsoft Office Advanced Excel Word Back Office MIS Reporting VBA MIS Executive

Apply

Job Description

advance excel

 expert in creating and developing power bi reports and dashboards .

 expertise in power bi, power bi pro, power bi mobile, power bi report server.

 experience in developing reports by slicers, drill down, drill through reports and bookmarks by various dimensions.

 comfortable in working with filters/calculated columns/measures/relationships and transformations of edit query section.

 extensively used different categories of dax functions like time intelligence function, filter functions, date functions, logical functions, text functions, number and statistical functions for creating new information.

 created new calculated column and measure using dax expression.

 published/shared the reports by creating a content pack in /sharing the pbix file

 worked on on-premises gateway to refresh the data sources.

 experience in generating reports drill downs, drill through, sub-reports, navigation reports etc. using power bi.

 having experience in publishing reports to by configuring gateways.

 used transformations like derived column, conditional split, aggregates, sort, data conversion, merge join and union all.

 developed power bi reports using multiple sources like excel, csv, sql server, power bi service etc.

 having knowledge on row and role based security as a part of security in power bi.

 worked with custom visuals like tachometer, multiple axis chart, sunburst chart, advanced card etc.

 worked on dax functions like date & time functions, textual functions and time intelligence functions.

 created dax measures like totalytd, totalqtd, totalmtd, last year sales, last 30 days sales etc.

 hands on experience in ms sql server database queries, joins, stored procedures and views.