Prashanth G
Data Analyst @Scotiabank
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Scotiabank
Gathering the requirements from the Business users and Participated in Requirement Meetings for - understanding the functionality & business rules- Understanding the business decisions and data source given in Oracle, MS Excel- Performed ETL operations like Detect data type, Rename, Pivot & Un-pivot, append queries, Custom Columns, Data Filtering, Date & Time etc, using Power Query Editor and then loaded to Power View- Involved in Data Modelling by identifying and establishing Cardinality is between multiple source tables before report development- Created and worked with Fiscal Calendar by using custom table as per the business requirements- Experienced in working with DAX Functions like Aggregation, Time Intelligence, Date and Time, Filter, Information & Logical Functions- Calculated Measures such as SUM, AVG, Cumulative, Current & Previous Record fetching etc, in DAX for analytical comparisons- Created Reports and Dashboard with various visualizations like Card, Stacked/Clustered Bar charts, Pie Chart, Map, Matrix, Line Chart, Gauge, Slicers etc- Implemented tooltips and book-marking options and parameters wherever required- Implemented RLS to relevant departments to access the report- Worked on On-Premises Gateway to refresh the data sources using Power BI Gateway. Participated in dashboard creation and publishing to end-user in Power BI Service. Utilized the Power Query in Power Bi to for performing data transformations, data cleaning as per business needs Used POWER BI filter like visual Level filters, page level filters, Report level filters.
EDUCATION
GITAM Deemed University
Bachelor of Engineering - BE, Electrical, Electronics and Communications Engineering
ABOUT PRASHANTH G
Over 5+ years of IT experience with expertise in analysis, design, development and…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.