Data | Business | Financial Analyst
Michael John
About Me
michael@trailblazeanalytics.com
Experienced analyst, data visualization specialist, and strategic problem solver.
I’m passionate about transforming raw data into clear and actionable insights that deliver real-world business value.
I am a resourceful, inquisitive, and driven problem-solver, specializing in using tools like Excel, MySQL, Power BI, and Python to help businesses unlock the power of their data.
Work Experience
FEB 2023 - Present
DATA ANALYST, NOORVIDA (Formerly known as workspacebooster), VIRGINIA, CHESAPAKE
Financial Data Analysis
- Utilized Excel and Power BI to analyze financial data.
- Track key performance indicators (KPIs).
- Generate actionable insights that supported business decisions.
Marketing Campaign Analysis
- Employed SQL to analyze the financial performance of marketing campaigns, leading to a 30% improvement in return on investment.
Sales Data Analysis
- Conducted in-depth sales data analysis using SQL, Excel, and Power BI to identify trends and opportunities.
- Developed actionable insights that informed marketing strategies.
- Implemented recommendations, resulting in a 50% increase in sales.
Website Optimization
- Managed website measurement, reporting, and optimization for workspaceboosters.com, enhancing user experience and engagement.
JAN 2024 - Present
Student Business Intelligence Path Maven Analytics
Data Analysis & Visualization
- Analyzed datasets to uncover patterns and trends using Excel, Python (Pandas), and R.
- Created compelling visualizations with Tableau, Power BI, and Excel to present data insights.
Technical Skills Development
- Executed SQL queries for data extraction and manipulation using MySQL.
- Applied programming skills in Python for advanced data analysis and machine learning.
Project Management
- Led and collaborated on capstone projects, simulating real-world data analytics tasks.
- Utilized MavenAnalytics for version control and project collaboration.
Data Collection & Cleaning
- Sourced data from APIs and databases, and performed data cleaning using Power Query in Excel and Power BI.
Business Intelligence
- Tracked and analyzed KPIs to support business decisions; created interactive dashboards with Tableau and Power BI.
Ethics & Compliance
- Studied data ethics and compliance standards, ensuring responsible data usage and adherence to regulations like GDPR.
Continuous Learning & Networking
- Attended workshops and webinars to stay updated on industry trends.
- Built a professional network through LinkedIn and industry events.
Soft Skills Development
- Enhanced communication skills by presenting data insights to non-technical stakeholders.
- Developed critical thinking through analytical exercises and case studies.
Feedback & Improvement
-
- Participated in peer review sessions to provide and receive constructive feedback.
- Regularly assessed personal progress and set goals for continuous improvement.
JAN 2020 - SEPT 2022
Web Designer, VIV DIGITAL MEDIA LLC
Web Design
- Designed and built corporate, business, e-commerce websites, and blogs using data analysis to inform design decisions and improve user experience.
Technical Data Integration
- Utilized HTML, CSS, and JavaScript to integrate and manage data-driven features on websites, ensuring seamless data flow and functionality.
Data Visualization
- Created graphics and visual assets using Adobe Photoshop and built websites using Divi Builder to effectively communicate data insights and enhance website aesthetics.
Email Marketing Analytics
- Developed and analyzed email marketing campaigns, sales funnels, and landing pages to track performance metrics and optimize conversion rates.
Comprehensive Data Services
- Provided clients with initial website setup services, including domain registration, hosting setup, business emails, and site security (SSL), ensuring all systems were optimized for data integrity and security.
Ongoing Data Maintenance
- Offered website troubleshooting and maintenance services, using data monitoring tools to identify and resolve issues, ensuring continuous performance and reliability.
Certifications
Excel Specialist
Power BI Specialist
MYSQL Data Analysis
Advanced Excel Dashboard Excel
Power Query, Power Pivot & DAX
Statistics for Data Analysis
Projects
Adventure Works Dashboard
Explore Adventure Works’ global performance
The Evolution of the Music Industry
Visualizing the impact of the iTunes launch in 2003 on digital music sales
Maven Toys Store
Harnessing Insights to Propel Growth and Optimize Inventory
Hotel Booking Optimization
Turning a $1million loss from cancellations into additional revenue
Skills
Analytical Skills
- Statistical Analysis
- Data Cleaning
- Data Visualization
- Predictive Modelling
- Hypothesis Testing
Software Proficiency
- Excel: Advanced functions, pivot tables, data analysis toolpak
- SQL: Database querying, data manipulation
- Tableau: Data visualization, dashboard creation
- Power BI: Data visualization, interactive reports
-
Communication
- Report Writing
- Presentation Skills
- Data Storytelling
- Stakeholder Management
- Collaboration
Products I’ve Worked With
Education
2010 - 2015
Bachelor of Technology (B.Tech) - Orthotist/Prosthetist
Federal University of Technology Owerri Nigeria
Graduated Top 5% with Second Class Honours, upper division (3.8 CGPA out of 5.0)
Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.