Data Analysis and Dynamically generating charts.
- Data points(48) across dynamic rows of date period of units consumption - Calucations based on SheetA and SheetB and populating SheetC. - Dynmically generating Bar, Pie charts for Monthly Totals, %Total. - Scatter chart - with the axis and the Weekly color indicators being dynamically set. - Surface charts having 10 legends, dynamically populating the color and the axis ranges, gridlines - Depending on the total period the number of Surface Charts auto generated - Couple of line Plots for special day, and the average of 48 data points. - After the user input, and clicks the button the entire sequence of calcuations and Graph generations are done and shown in respective tabs.
Giới thiệu
Bachelors in Engineering - Computer Science o Expertise In: (Excel, SSIS, Power BI,MS Access, VBA, Data Entry, Webscraping. o eCommerce Data Mapping - eBay, bigCommerce, SalePresenter o Excel - Excel Macros programming, automation, VBA, formulas using data extraction from file and data sources, consolidation, populating graphs, pivot table, lookup,, Excel - Formulas,. Data import/export. o Outlook, Word - Word Template automation, Outlook mails automation. o Data analysis, data extraction from website, populating data on to websites. o MS Access - Designing forms for user input, building reports, Databased designing. Build full fledged software for small institutions on their customized needs. o Database - MS Access, Database Programming, SQL, MYSQL, importing exporting, extraction and modifying data. o Dedicated and would complete to the timelines committed. o Would provide additional support for minor issues/changes to have customer satisfaction and build a long time relationship.