1-3 years of Experienced in MS Excel data cleaning and analysing using various features such as Pivot Tables & Pivot Charts, Look ups, Rank & Conditional Formatting
Good Knowledge on Power BI Data Modelling and Data Warehousing concepts like Star Schema, Snowflake Schema, Dimensions, Fact Tables, Relationships and Filter Directions
1-3 years of experience in Power Query and Power Pivot for Connecting, Importing, Shaping and Transforming data for Business Intelligence tools like Excel and Power BI
Designing Power BI reports and dashboards as per the requirement using Power BI inbuilt and custom visualizations like Bullet Charts, Histogram, San-key, eports, Creating Workspace, Publishing Reports, Designing Good Looking & Meaningful Dashboards, Publishing dashboards and Row Level Security Implementation
Working Knowledge in implementing report Slicers, Bookmarks, Hierarchy, Drill Down, Drill Through, Filters, Interactions and Custom Themes
Collaborate with business teams to design and implement projects. To understand business requirements in the BI context and design data models to convert raw data to meaningful insights
Analysis and development of complex DAX Queries, Reports and Dashboards KPIs with clear objectives and monitor them consistently.
Requirements:
1-3 years of experience in VBA programming knowledge, VB.NET, SQL Server & Power BI
Strong knowledge of Visual Basic, VBA, VB.NET, Integrate capability in Excel-based tools to both pull and push data from/to SQL Server
Must be able to analyse, write code, technical knowledge to prepare requirement documents conduct impact analysis and do testing.
Must have excellent programming knowledge of MS Excel VBA macros, excel functions, coding knowledge, Estimating, designing, and developing code solutions, testing, debugging, and documenting programs on complex projects
Both under graduates and post graduates can apply
Good communication (Demonstrate strong reading comprehension and writing skills)
Able to work independently, strong analytic skills