Python: . Strong understanding of exploratory data analysis using libraries like NumPy, Pandas, Matplotlib, and Seaborn . Experience in data cleaning to ensure data accuracy and consistency . Knowledge of building machine learning models to provide insights and make predictions . Familiarity with data scraping using Selenium to extract data from websites
PowerBI: . Expertise in building powerful dashboards to monitor key performance indicators (KPIs) . Ability to add data from multiple sources to provide a comprehensive view of business performance . Experience in creating visualizations and reports to provide insights into business operations
Excel: . Experience in automated report generation using VBA macros . Proficiency in building interactive dashboards using PivotTables and Pivot Charts . Familiarity with Excel functions and formulas to help with data analysis . Expertise in applying conditional formatting and data validation to ensure data accuracy . Advanced knowledge of PivotTables to provide insights into complex data sets
SQL: . Proficient in writing SQL queries to extract and manipulate data from different databases . Skilled in writing stored procedures to save time and ensure consistency in data retrieval . Experience in working with multiple databases such as Teradata, Atlas, Greenplum, and Salesforce . Ability to conduct timely query checking and assessments of scripts and outputs to ensure data accuracy
Overall, you have experience in building reporting infrastructure from the ground up using Excel and SQL, and have successfully executed account targeting initiatives. You have a strong attention to detail and are able to conduct timely assessments of scripts and outputs to ensure data accuracy