Data Analyst

Home

People

Data Analyst

ID : 1822

Education level : Bachelor's degree

Work experience level : Associate- (1-2 year experience)

Work experience in total : Years

Job type : Online

Job time : Maandelijks

Last date of registration :

2023-01-05

Having 4.5 years of experience working with visualization tool Power BI, DAX, and SQL.
Experience gathering and translating end user requirements into effective & efficient Reports and Dashboards.
Experience including analysis, design, development of reports and dashboards for analytics.
Develop Power BI reports, Custom Visuals, Groups Creation and effective dashboards after gathering and translating end user requirements.
Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX.
Experience in creating different visualizations like Line, Bar, Histograms, Scatter Plot, Waterfall Chart, Bullet Graph, Heat maps, tree maps etc.
Experience in publishing reports to Power BI services and setting up the necessary connection details and scheduling.
Imported data from multiple data sources into Power BI from various data bases like SQL Server, Oracle & Excel etc.
Implemented Role Based Security as part of security in Power Bi.
Involved in create ETL packages to validate, extract, transform and load data to data warehouse and involved in data marts
Expertise in designing Report templates, bar charts, graphs and pie charts based on the data.
Developed various operational Drill-through and Drill-down reports using BI.
Good hands-on experience in creating SQL Server database objects like Tables, Constrains, Joins, Sub-Queries, CTE, Stored Procedures, User Defined Functions, Views, Indexes.
Skilled at assessing client needs, working in groups, Leading the team, suggesting ideas that enhance efficiency and performance, implementing technology solutions and training end users.

Data Analyst - Technologies, Bangalore - (24 months)

Description: Kemper is one of the top insurance companies in USA, which is providing Home, Business and Personal Insurance to the customers. Kemper Business users’ Policies and Customer details were closely monitored such as premium charged, premium paid and Claimed amount etc. to improve the business by giving satisfactory services to customers.
- Data gathering
  1. Gathering data from structured database where actual transactions takes place
  2. Survey and feedback information’s collected from sales and marketing team
  3. 3rd Party data source
- Data Modelling
- Complete responsibility on Database designing
- Maintained complete structured database (SQLSERVER)
  1. SQL tuning
- Developed Power BI reports from multiple data source
- Data cleaning in Power BI
- Reported EDA analysis in Power BI
- Implemented DAX (Data Analysis Expressions) functions for Calculated columns and measures
- Designed power BI data visualization utilizing, maps, scatter plots
- End to end process to deliver the project
- Published Power BI Reports
- Technology/Tools : Power BI Desktop. SQLSERVER Database

Power BI Developer - Technologies, Bangalore - (12 months)

Rogers Cable is the largest cable television provider in Canada offering cable television, high-speed Internet access, residential telephony services, and video retailing. A subdivision is Rogers Business Solutions division is a national provider of voice communications services, data networking, and broadband Internet connectivity to small, medium and large businesses. Rogers Wireless is Canada's largest voice and data communications services provider. Rogers Media is Canada's premier collection of category-leading media assets with businesses in radio & television broadcasting, televised shopping, publishing and sports entertainment.
- Develop Power BI reports & Effective dashboards after gathering and translating end user requirement.
- Experience in creating dashboards, presentation and graphs.
- Experience in creating calculated measures and columns with DAX in MS POWER BI DESKTOP.
- Experience in Custom visuals and Groups creation.
- Good Knowledge on advanced calculations using power BI desktop.
- Connect to different Data sources from Power BI.
- Experience in creating different visualizations like line, bar, histograms, scatter, water, Bullet, Heat maps, tree maps etc.
- Knowledge in creating Groups and content packs in the power BI services.
- Experience on installing Gateway and Created scheduling the reports using Data Gateway.
- Created Filters and apply conditional formatting based on user requirement.

Reporting Tools
- Power BI, SSIS, Gateway, DAX,Azure Data FactorY
Databases
- SQL Server, MySQL ,Azure SQL
OLAP Tools
- SQL Server Analysis Services (SSAS) Tabular Model
Operating Systems
- Windows XP/7/8/10.

Reporting Tools: Power BI, SSIS, Gateway, DAX,Azure Data FactorY | Databases: SQL Server, MySQL ,Azure SQL | OLAP Tools: SQL Server Analysis Services (SSAS) Tabular Model | Operating Systems: Windows XP/7/8/10.

Meer person

ID : 2042

Associate Software Engineer

Education level: Bachelor's degree

Work experience level: Intermediate- (2-4 year experience)

ID : 2041

System Engineer IT

Education level: Bachelor's degree

Work experience level: Experienced- (4-7 year experience)

ID : 2040

Associate Engineer

Education level: Bachelor's degree

Work experience level: Associate- (1-2 year experience)

ID : 2039

Intern

Education level: Bachelor's degree

Work experience level: Beginner- (internship- 1 year experience)

Data Analyst

Meer person

Mis geen enkele belangrijke kennisgeving houd jezelf update