Project #1
Client : First American | US Title Insurance
Technology/Tools : Power BI Desktop.
Duration : Nov 2021 to till date
Description
First American (India) is a Global Capability Center (GCC) of the First American Financial Corporation (US), a leading provider of title insurance, settlement services, and risk solutions for real estate transactions since 1889 First American also provides title plant management, home warranty, and banking, trust & wealth management services. With locations in Bangalore, Hyderabad and Salem, FAI delivers software development, back-office and knowledge-processing operations to support First American’s global operations in US, UK, Australia & Canada.
Responsibilities:
- Data gathering
- Gathering data from a structured database where actual transactions take place.
- Survey and feedback information collected from sales and marketing team
- Data Modelling.
- Data Cleaning in power query editor
- Complete responsibility on Database designing
- Maintained complete structured database (MYSQL)
- Applied Custom conditional formatting with help of Color by Rules in Power BI for Matrix & Table.
- Developed Power BI reports from multiple data source
- Created Bookmarks to move from one page to another page based on requirements like moving forward and backward navigations.
- Implemented DAX (Data Analysis Expressions) functions for Calculated columns and measures.
- Experience in developing Visualization reports and dashboards using Power BI.
- Involved in developing weekly reports.
- Published weekly reports to Business users.
- Designed power BI data visualization utilizing maps, scatter charts.
- End to end process to deliver the project
- Published Power BI Reports
- Worked on On-Premises Gateway to refresh the data source.
Project#2
Revenue Analysis dashboards
Client : First American
Technology/Tools: Power BI Desktop, MYSQL Database and Azure
Description:
Demonstrated an understanding of data analysis and visualization techniques to create an intuitive and effective revenue analysis dashboard, resulting in improved financial performance and data-driven decision-making.
Responsibilities:
- Created Bookmarks/Page Navigations as per the requirement.
- Creating workspace as per the business requirement and creating gateways and scheduling daily refresh.
- Providing access for workspace and app level to the admin and dev team to load the files in different instances.
- Implemented KPI’s in Power BI dashboards.
- Gained knowledge on Power Apps integration & Power Automate.
- Implemented DAX functions for Calculated columns and measures.
- Designed power BI data visualization utilizing, maps, scatterplots.
- End to end process to deliver the project.
- Optimize the performance of these reports in terms of time to refresh and size of the reports.
- Migrated on premises data to Azure Storage/Azure Lake Storage.