Professional Certificate in Data Analysis
Harness Excel, SQL, and Power BI and Python to drive powerful analysis and insights. Build confidence and credibility to apply this versatile skill set to countless jobs.
Demand for Data Visualisation tools have increased 1,103% in five years. Across industries, data analysis skills command a salary premium.
Gain Vital Skills With Universal Relevance
Marketing managers who know SQL make 41% more than those who don’t, and GMs earn 29% more with data analysis skills. Hone crucial proficiency in Excel, SQL, and Power BI and make career moves across industries and roles.
Tap Into a Valuable Professional Network
Form real connections that can change the course of your career. Meet practitioners and peers who can help you succeed through our alumni network. Graduate with an industry-recognised certificate, and join an exclusive community.
Let Your Employer Foot the Bill
More than 45% of our part-time students receive tuition reimbursement from their companies — you could, too. We can send you an employer sponsorship package to show your manager the advantages of learning with AnalyticsCFD.
What you will learn
- Create charts and plots in Excel, and work withMicrosoft Power BI to build dashboards.
- Describe the data ecosystem and Compose queries to access data in databases using SQL and Python from Jupyter notebooks.
- Develop a working knowledge of Python language to analyze data using Python libraries like Pandas and Numpy.
- Perform data analysis tasks like data mining and data wrangling using Excel spreadsheets and Jupyter Notebooks. Visualize data using Python libraires like Matplotlib and Seaborn.
Program Overview
This five-course Professional Certificate from AnalyticsCFD prepares you with job-ready skills for an entry level data analyst role. Position yourself competitively and power your data analyst career for a job in a thriving market or leverage foundational data skills to explore problems in an increasingly data-driven professional world. The U.S. Bureau of Labor Statistics projects a growth rate of 20% in the data analytics industry until 2028.
You will learn the core principles of data analysis, participate in hands-on skills-based practice, and gain the knowledge to help companies make smarter business decisions. You will work with a variety of data sources, project scenarios, and data analysis tools, including Excel, SQL, Python, Jupyter Notebooks, and Power BI. These online learning tools will offer you practical experience with data manipulation and the application of analytical and data visualization techniques.
This Professional Certificate does not require any prior programming or statistical skills, and is suitable for learners with or without college degrees. A willingness to learn, basic computer literacy, comfort working with numbers, high school math, and a desire to enrich your profile with valuable skills is all you need to get started in this course.
With the AnalyticsCFD Data Analyst Professional Certificate you will develop the confidence and portfolio to begin a career as an associate or junior data analyst by learning the essential skills that help professionals in a wide range of job functions and industries explore business problems.
“I learned and did things over the last 10 weeks I never thought I’d be able to do on my own, nor would I opt to do on my own. It truly opened my world and confirmed my love for data analytics. The course pushed me to my ‘learning’ limits, but in the best way possible.”
Antoma Meba Adrienne, Technical Advisor in Decentralisation and local Governance chez GIZ Cameroun
Course Outline
Data Analytics Mindset
6 hours per week, for 1 weeks
Learn the fundamentals of Data Analytics and gain an understanding of the data ecosystem, the process and lifecycle of data analytics, career opportunities, and the different learning paths you can take to be a Data Analyst.
Analyzing Data with Excel
6 hours per week, for 3 weeks
Build the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course covers the basic workings and key features of Excel to help students analyze their data.
Data Visualization and Building Dashboards with Power BI
6 hours per week, for 2 weeks
Build the fundamental knowledge necessary to use Excel and IBM Cognos Analytics to create data visualizations and to create dashboards containing those visualizations to help tell a lucid story about data.
Python Basics for Data Analytics
6 hours per week, for 2 weeks
This Python course provides a beginner-friendly introduction to Python for Data Science. Practice through lab exercises, and you’ll be ready to create your first Python scripts on your own!
Analysing Data with Python
6 hours per week, for 2 weeks
In this course, you will learn how to analyze data in Python using multi-dimensional arrays in numpy, manipulate DataFrames in pandas, use SciPy library of mathematical routines, and perform machine learning using scikit-learn!
Data Analytics and Visualization Capstone Project
6 hours per week, for 2 weeks
Accelerate the knowledge you gain from previous courses in the AnalyticsCFD Data Analyst Professional Certificate program. Assume the role of an Associate Data Analyst and use various skills and techniques on real-world datasets to accomplish a task.
Expert instruction
05 skill-building courses
3 months
6 hours per week
1,000USD 1,500USD
For the full program experience
Bluebikes
Petrowski, a senior analyst at Precision Xtract, focused on the Bluebikes bikeshare program, comparing use by gender across points like trip duration and rides by station and identifying a low subscriber rate among women.
Cherokee Country Voter registration
Schieber, senior demand generation manager at PGI, compaired census and voter data to examine the correlation between voter registration and election day timeout.
2016 Election Spend
Lin, director of employee success at Lever, uses Excel and SQL to analyze campaign expenditure data from the 2016 election, yielding surprising discoveries about the spending habits of presidential candidates