Data Analyst
excis
Total years of experience :9 years, 1 Months
As an Data Analyst, Collect data from sales, marketing, and finance departments to use in establishing organizational structure.
Organize, extrapolate, and disseminate data across departments to be used for drawing conclusions about the success of current methods.
Present detailed reports about the meaning of gathered data to members of management and help them identify scenarios utilizing modifications in the data.
Built out the data and reporting infrastructure from the ground up using Power Bi, Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs
Identifying data sources
Collecting data
Sourcing missing data
Organizing data in to usable formats
Analyzing data to find answers to specific questions
Setting up data infrastructure
Developing, implementing and maintaining databases
Assessing quality of data and removing or cleaning data
Generating information and insights from data sets and identifying trends and patterns
Preparing reports for executive and project teams
Creating visualizations of data
Completed market analysis, resulting in a 21% increase in sales.
Used SPSS and MiniTab software to track and analyze data.
Conducted research using focus groups on 3 different products and increased sales by 11% due to the findings.
Spearheaded data flow improvement.
Developed Key Performance Indicators to monitor sales and decreased costs by 17%.
Skills,
Statistics and mathematics proficiency
Big data analytics
Analytical thinking skills
Computer skills
Predictive modeling techniques: decision trees and generalized linear models (GLM)
Analytical tools: SAS, IBM SPSS, Microsoft Excel, pivot tables, Tableau and Power Bi
Analytical coding languages: SQL, C++, and Java
Collect business intelligence data from sources which may include industry reports, public information, field reports or purchased findings. This may mean updating your knowledge about relevant technology trends or emerging markets in your industry in addition to gathering data related to the customers and the market.
Store the data in your company’s computer database, which may require regular updates. You may also need to establish operational procedures to utilize the database and provide technical support or software maintenance for any unique programs.
Analyze the data to identify any trends that could impact your business’ strategies.
Utilize the results of the analysis to support recommendations for action to improve or even grow the company.
Prepare analytical reports to summarize findings and share with the appropriate company stakeholders through established communication processes.
Math (statistics and probability) Logic and analysis Relational databases (MySQL) Problem-solving and troubleshooting Pattern and trend identification Data mining and data QA Database design and management SharePoint and advanced Microsoft Excel functions Tableau and Qlik Business intelligence (BI) Programming languages Risk management System administration Quantitative methods Data warehousing Regression analysis Data science research methods Experimental design & analysis Tech support