#Data analysis with excel description update
Worked closely with Program Manager and Executive Leadership to prepare and update documents, presentations, and other project related material as needed. Participate in developing best practices for product data and content analysis and reporting.Īssigned with task of post-migration cleansing of technical publication database reviewed and adjusted project timelines, data categories, developed and applied detailed business rules to determine naming convention and syntax, while working with project managers to determine universal assumptions and qualifications. Followed up with stakeholders and data owners to fill gaps in data. Extensive Excel work using pivot tables and complex formulas to manipulate large data structures. Conducted continuous improvement audits and document data gathering workflow processes. Produced metric decks for review by Project Managers and Executives. Daily use of complex Excel formulas and pivot tables to manipulate large datasets.Ĭonfidential, 700 Locust St., Dubuque, IA, 52001Ĭompiled weekly service delivery implementation metrics using Excel workbooks and proprietary databases. Synthesized data from several data sources to produce consolidated views of project Governance and reporting of Data Center Migration project data for PMO and VP level using Excel workbooks and proprietaryĭatabases. Prepared and facilitated weekly PMO meetings captured meeting decisions and content into Excel based tracking logs tracked budget and forecasts.Ĭreate and maintain pre- and post- migration checklists / steps. Helped remediate Vendor Statements of Work conducted follow-up with project team members to ensure open items are brought to resolution. Facilitated program and project meetings maintain Statement of Work and Resource Allocation Trackers. Perform SharePoint administration for team.Ĭreate reports and metrics, present them convincingly, facilitate required discussion, and drive superb execution of such reports. Adhere to and communicate Records Management procedures to customers. Conduct quality assurance activities regarding data migration and folder permissions. Prepare and facilitate weekly PMO meetings captured meeting decisions and content into Excel based tracking logs. Help remediate Vendor Statements of Work submit Statements of Work into Contracts database budget and forecast tracking and variance analysis work with Finance on accruals perform general back-office support for Project Managers. Facilitate program and project meetings maintain Statement of Work and Resource Allocation Trackers. 94080Įxtensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation. Collect user requirements and conduct project status meetings to insure project deliverables are met.Ĭonfidential, South San Francisco, CA. Responsible for validating good data and purging invalid/bad data. 18974Ĭurrently on assignment to develop a new Excel based compliance tracker tool perform data cleansing and build an Excel user interface to assistance in data collection and metrics. Strong end-user computing skills (Excel, SharePoint, Power Point, Word).Ĭonfidential, 100 Tournament Dr., Horsham, PA. Strong communication and customer service skills.
Extensive experience using data cleansing techniques, Excel pivot tables, formulas, and charts. Able to perform complex multiple tasks while insuring seamless support of the overall project timeline. Able to translate business needs into complex analysis designs and recommendations.
#Data analysis with excel description professional
Professional with 10+ years experience as a data analyst, providing support in the areas of project coordination, data analysis, and metrics reporting. If you need to adjust one, you can.Technically skilled Excel Data Analyst to provide data cleansing support and validation of data for use in presentations, metrics, and reporting of information. The values on the right are populated automatically in categories for Not a Value, Sum, and Average. Use the check boxes on the left side to select the fields that you want to analyze. You’ll then see the fields for your data and their summarized values. You’ll also see any recent questions that you’ve asked to quickly revisit them if you’d like.Īnswers to your questions or results from suggestions you pick display directly beneath.īelow the question area of the task pane is a link for Which Fields Interest You the Most? If you want to narrow down the data that you’re analyzing, you can do so by clicking this. This provides a drop-down list of recommended questions. Depending on the type of data that you’re using, you can type in things like, “How many shirts sales in January,” “What are shoes and pants total sales,” or “Total jackets excluding December.”Īlong with the ideas at the top, you can also see suggestions by clicking in the question box.
0 kommentar(er)
