MIS Executive

Ranko Metals Private Limited

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

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.