Data Analysis and Visualization Foundations

Get job-ready for a data analyst career in as little as 4 months. No prior experience needed.   Data skills are among the most in-demand skills in the job market. The U.S. Bureau of Labor Statistics projects employment of data scientists, a path this program also prepares you for, to grow 34% from 2024 to 2034, much faster than average, with a median annual wage of $112,590.¹ Every one of those careers starts with the same foundation: collecting, cleaning, analyzing, and communicating data. That's exactly what you'll learn here.   This IBM Professional Certificate teaches the skills employers look for in entry-level data analyst roles, including Data Analyst, Associate Data Analyst, and Business Analyst. You'll learn the tools professional analysts use every day: Excel, SQL, Python, Pandas, NumPy, Jupyter Notebooks, and IBM Cognos Analytics. You'll also have the option to learn how generative AI tools and techniques are used in data analysis, so you're ready for how the job is changing.   You won't just learn the tools, you'll use them. You'll work with real-world data sources and project scenarios, and you'll build a portfolio of hands-on projects that show hiring managers what you can do:   * Import, clean, and analyze a fleet vehicle inventory with Excel pivot tables * Turn car sales KPI data into an interactive dashboard with visualizations * Extract and graph financial data with the Pandas library in Python * Query census, crime, and school demographic data sets with SQL * Wrangle data, plot graphs, and build regression models to predict housing prices * Create a dynamic Python dashboard to monitor and improve US domestic flight reliability   You'll finish with a real-world capstone project designed to showcase your new skills, plus the soft skills that set analysts apart: working with stakeholders and telling a clear story with data.   What you'll walk away with:   * A Professional Certificate from IBM and an IBM Digital Badge to share on LinkedIn and your resume * A portfolio of projects and a capstone you can discuss in interviews * Access to career resources to support your job search * Up to 12 college credits and 6 ECTS credits, as this program is ACE® and FIBAA recommended²   It's also a strong foundation for what comes next. The skills you build here carry directly into data science, artificial intelligence, deep learning, and data engineering.   Join 500,000+ learners, backed by 98,000+ reviews of courses in this program.   ¹ U.S. Bureau of Labor Statistics, Occupational Outlook Handbook: Data Scientists. Median wage as of May 2024; projected growth for 2024 to 2034. This program is not a guarantee of employment or salary.   ² Credit recommendations are subject to acceptance by individual institutions.

Learn how to create data visualizations and dashboards using spreadsheets and analytics tools. This course covers some of the first steps for telling a compelling story with your data using various types of charts and graphs. You'll learn the basics of visualizing data with Excel and IBM Cognos Analytics without having to write any code. You'll start by creating simple charts in Excel such as line, pie and bar charts. You will then create more advanced visualizations with Treemaps, Scatter Charts, Histograms, Filled Map Charts, and Sparklines. Next you’ll also work with the Excel PivotChart feature as well as assemble several visualizations in an Excel dashboard. This course also teaches you how to use business intelligence (BI) tools like Cognos Analytics to create interactive dashboards. By the end of the course you will have an appreciation for the key role that data visualizations play in communicating your data analysis findings, and the ability to effectively create them. Throughout this course there will be numerous hands-on labs to help you develop practical experience for working with Excel and Cognos. There is also a final project in which you’ll create a set of data visualizations and an interactive dashboard to add to your portfolio, which you can share with peers, professional communities or prospective employers.

This course is the final step in the Data Analysis and Visualization Foundations Specialization. It contains a graded final examination that covers content from three courses: Introduction to Data Analytics, Excel Basics for Data Analysis, and Data Visualization and Dashboards with Excel and Cognos. From the Introduction to Data Analytics course, your understanding will be assessed on topics like the data ecosystem and the fundamentals of data analysis, covering tools for data gathering and data mining. Moving on to the Excel Basics for Data Analysis course, expect questions focusing on the use of Excel spreadsheets in data analytics, proficiency in data cleansing and wrangling, and skills in working with pivot tables. Finally, from the Data Visualization and Dashboards with Excel and Cognos course, you will demonstrate your knowledge of IBM Cognos basics and your ability to use Excel for effective data visualization.