Data Analyst Power Bi

EXAUCEE BOKANYA

Atlanta, GA ***** +1-404-***-**** ********@*****.***

Summary

Data-driven Junior Data Analyst with experience in automating reporting workflows, transforming raw data into actionable insights, and building scalable data solutions. Proficient in Excel (Pivot Tables, VBA Macros), SQL, and Power BI. Strong ability to clean, structure, and analyze large datasets to drive business efficiency and decision-making. Automated a retail sales report that reduced manual reporting time, improving data accessibility and visualization. Excited to apply analytical skills in a dynamic, results-oriented environment.

SKILLS & TOOLS

•Data Analytics: Data Mining, ETL (Extract, Transform, Load), Descriptive & Predictive Analytics, Data Wrangling, Hypothesis Testing, Regression Modeling, Market Risk Analysis

•Data Visualization: Power BI, Tableau, Data Visualization, Excel Charts (Dynamic Dashboards)

•Programming & Tools: Advanced Excel (Pivot Tables, VBA Macros, Automation), R (Predictive Modeling, Data Wrangling), Python, SQL (Data Extraction, Query Optimization, Data Cleaning), Power Query, Workflow Optimization

•Business Intelligence: Business Intelligence Tools, SAP, Microsoft Office Suite

PROFESSIONAL EXPERIENCE

J.W Business Acquisition Junior Account Manager Apr 2022 - Feb 2023

•Engaged with 120+ potential customers daily, managing service plans, tracking interactions in Salesforce, and identifying business development opportunities to increase customer engagement.

•Analyzed sales metrics and telecom service trends, escalating orders as needed and collaborating with technicians to resolve service issues, leading to a 20% improvement in customer retention.

•Trained and mentored new personnel while managing a sales team, enhancing operational efficiency and maintaining high service standards.

Georgia State University Student Services Coordinator Feb 2021 - Sep 2021

•Managed and reconciled records for over 100 students, ensuring data accuracy and compliance by tracking and updating information in internal systems.

•Streamlined registration workflows, enhancing operational efficiency and reducing wait times by 80%.

•Provided detailed reports using Power BI to support decision-making and improve service delivery.

Rehoboth Food Restaurant Digital Marketing Specialist Sep 2019 - Jan 2021

• Conducted data-driven analysis of website traffic and campaign performance, increasing ROI by 25%.

• Analyzed customer demographics to guide marketing strategies, increasing social media engagement by 50%.

• Collaborated remotely with cross-functional teams to support data-driven decisions, contributing to a 15% growth in revenue.

EDUCATION

PROJECTS

The Impact of Lifestyle and Demographic Factors on Sleep Health and Efficiency

•Conducted data mining and statistical analysis using R to identify key lifestyle and demographic factors affecting sleep efficiency.

•Developed and optimized predictive models, including regression and classification techniques, to assess sleep patterns and provide actionable insights.

•Cleaned and preprocessed datasets in R, ensuring data integrity for statistical analysis.

•Created visual dashboards in Tableau to present insights effectively.

•Collaborated with team members to produce a comprehensive report and co-present findings to professors, showcasing data-driven recommendations for improving sleep health.

Retail Sales Performance Analysis (Excel VBA & Pivot Tables)

•Developed an automated sales reporting system in Excel using VBA and Pivot Tables, reducing manual reporting time by 80%.

•Cleaned and processed raw retail sales data, handling missing values, duplicates, and incorrect formats for accurate analysis.

•Developed a dynamic sales performance report, identifying key product trends and automating analysis to support business decision-making.

•Created an interactive Bar Chart to visualize sales trends, aiding in inventory and marketing decisions.

Mercer's Stetson-Hatcher School of Business

2023 - 2024

Master of Science, Business Analytics

J. Mack Robinson College of Business, Georgia State University

2019 - 2021

Bachelor of Business Administration, Management

Contact this candidate