Project 1:
Role: Power BI Developer
Project Name: Smart Cursor – Bean Cursor system & HR System
Client Name: Precursor, Singapore
Environment: Power BI, Flat files, SQL Server
Project Description: Smart Cursors is an ERP system developed for Precursor for effective utilization of multiple domain services (each service called as Cursor) at a single centre. It provides different services like Admin, Audit, Bean, Board Room, Client, Documentation, HR, Knowledge and Workflow. Bean cursor is an accounting system. It maintains customers, vendors, and bank financial transactional information. It allows to change financial year end. It allows segmentation levels to do business and allow multicurrency transactions.
Responsibilities:
• Expert in identifying the requirements and also in finding the system requirements.
• Used Page Level and Report Level Filters to create Visuals.
• Used Quick Measure functionality to create Filters, Time Intelligence and Totals.
• Developing Visualization reports and Dashboards using Power BI
• knowledge in Power BI Service, Workspaces, Edit dashboards and implementing RowLevel Security
• To document the business process by identifying the requirements.
• Using Text Boxes, Creating Tables and changing Table visualization.
• Merge and Append Queries and Utilized aggregation to improve query performance.
• Multiple data to create Summary Queries in Power BI.
• Using Tiles and Power View Filters and connecting slicers to more than one table.
• Used Power Query and DAX Query functionality for derive calculated columns and Calculated Measures.