PowerBi Data Analyst
- Extensive experience in Data Analysis, PowerBI and Consumer Marketing analytics using SQL and Excel.
- 5.8 Yrs. of experience as a Data Analyst and PowerBI Developer into Banking and IT industries.
- Expert in writing SQL Queries to pull the data from different sources, creating data sets, Understanding of Views.
- Having knowledge of MDX Cube and Visual Studio.
- Performed in-depth analysis on the data pulled for an adhoc request and prepared graphs using MS Excel, MS PowerPoint, and PowerBI.
- Expert in creating Dashboards, implementing Power Query, RLS (Dynamic and Static), and DAX Query writing.
Skill-set Summary:
Languages
SQL (4 Yrs.)
SQL
Functions, Joins, Unions, Aggregation Functions, Sorting, Filters, Groupings, CTE Creation, Temp Tables Creation
Reporting Tools
PowerBI (3.8 Yrs.)
PowerBI
Data Integration, Dashboard Design, Row Level Security Implementation,
Publishing of Dash Boards, DAX, Power Query
Microsoft Tools
MS Office Suite, SSMS, SSAS(MDX),SSDT (Visual Studio)(Basics)
Excel
Lookup, Conditional Formatting, Pivot Tables, Macros, Validation, Dash Board
Creation
Operating Systems
Windows
Project Details:
Objective: Migration of Cognos and Excel Reports to PowerBI and creating dashboards as per client’s requirement.
Project Development Process:
- Requirement Gathering:
- Receiving a list of Cognos reports from the client indicating which reports must be migrated
- Analysing the reports and understanding the business requirements
Data Profiling:
-
- Interacting with the Cognos team to understand more about the business logic, report structure, and SQL logic of the reports.
Data Mining:
-
- SSMS and SSDT can be used to analyse MDX cubes.
- Create documents with dimensions, measures, and KPIs.
Data Analysis:
-
- Writing SQL queries in Legacy (Existing Source) and validating the results with Cognos reports, creating joins between tables to retrieve the data, using SQL Functions to optimise the query.
- Analysis of the gap between legacy and cloud query results so that the query can be replicated in the cloud.
- Find the most relevant tables in the cloud to be used in an SQL query.
- Analyse Cognos Reports and do gap analysis with Azure Cloud DB for available data.
- Organize, extrapolate, and disseminate data to be used for migrating the Cubes (Legacy) to the Cloud DB
Visualization:
-
- SQL Query Implementation in PowerBI
- Transformation of raw data into meaningful insights
- Replication of Cognos Reports into PowerBI.
UAT:
-
- Validation of PowerBI Reports results with Cognos Reports results
- Complete the process of UAT by sharing the PowerBI Dashboard Links to Testing Team
Roles & Responsibilities:
- Daily Interaction with the Client
- Updating the Agile Scrum Board on a Daily Basis
- Working on assigned tasks and making sure to complete the tasks within the sprint period
- Attending daily scrum calls with the client
- PowerBI DashBoard Creation, and making sure that reports are published to clients' workspace.
Project Name: Customer Segmentation Client: Banking and Finance
Objective:
- To group similar purchase customers
- To serve better for customer’s needs and wants
- Group / Cluster based on common characteristics, so Investment banks can market to each group effectively and appropriately
Roles and Responsibilities:
Data Gathering
- Collect Sales data (Rolling 12 months)
- Cross sales Product Information
- Behavioral information
- Locations specific
EDA / Data Pre-processing
- Bring out Insights / buying pattern of customers
- Clean data –Missing values, Outliers
- Feature Engineering / Selection
List the characteristics of each cluster
- This information will be shared with the sales/marketing team for smooth targeting of the right audience for campaigns.
Visualization:
PowerBi Data Analyst
Location : Hyderabad, India
Experience : 6 Year
Rate: $13 / Hourly
Availability : Immediate
Work From : Offsite
Category : Information Technology & Services
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume
