This course covers some of the first steps in the development of data visualizations using spreadsheets and dashboards. Begin the process of telling a story with your data by creating the many types of charts that are available in spreadsheets like Excel. Explore the different tools of a spreadsheet, such as the important pivot function and the ability to create dashboards and learn how each one has its own unique property to transform your data. Continue to gain valuable experience by becoming familiar with the popular analytics tool - IBM Cognos Analytics - to create interactive dashboards.
Offered By
IBMAbout this Course
200,720 recent views
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Beginner Level
Basic familiarity with using spreadsheet software like Excel.
Approx. 9 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Vietnamese, Russian, English, Spanish
What you will learn
Create basic charts and pivot charts in Excel.
Explain the important role charts play in telling a data-driven story.
Construct advanced charts and visualizations.
Build dashboards using Excel and Cognos Analytics.
Skills you will gain
- Microsoft Excel
- Data Analysis
- Data Visualization (DataViz)
- IBM Cognos Analytics
- Dashboard
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Beginner Level
Basic familiarity with using spreadsheet software like Excel.
Approx. 9 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Vietnamese, Russian, English, Spanish
Offered by
IBM
IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.
Syllabus - What you will learn from this course
2 hours to complete
Visualizing Data Using Spreadsheets
In this module, you will be introduced to the basics of charts and the Excel functions that are used to create basic charts and pivot chart visualizations. By learning how to manipulate these features and creating visualizations, you will begin to understand the important role charts play in telling a data-driven story.
2 hours to complete
5 videos (Total 24 min), 2 readings, 2 quizzes
2 hours to complete
Creating Visualizations and Dashboards with Spreadsheets
In this module, you will learn about creating advanced charts and visualizations and learn about the basics of dashboarding and how to create a simple dashboard using a spreadsheet.
2 hours to complete
5 videos (Total 31 min), 2 readings, 4 quizzes
3 hours to complete
Creating Visualizations and Dashboards with Cognos Analytics
In this module, you will be introduced to another dashboarding solution called Cognos Analytics. After registering with Cognos Analytics, you will then explore the platform capabilities by creating visualizations, building a simple dashboard, and discovering its advanced features.
3 hours to complete
4 videos (Total 13 min), 1 reading, 2 quizzes
2 hours to complete
Final Project
Congratulations! You have now completed the modules for this course. In this module, you will complete the final assignment that will be graded by your peers. In the first part of the final assignment, you will use provided sample data to create some visualizations using Excel for the web. In the second part of the final assignment, you will create some visualizations and add them to a dashboard using Cognos Analytics.
2 hours to complete
2 readings
Reviews
- 5 stars76.80%
- 4 stars19%
- 3 stars2.31%
- 2 stars1.28%
- 1 star0.57%
TOP REVIEWS FROM DATA VISUALIZATION AND DASHBOARDS WITH EXCEL AND COGNOS
by ABAug 15, 2021
Thanks Coursera for providing this condition for all Enthusiasts Special thanks to IBM for providing this course in the best possible way
by SDJan 10, 2021
I got so many things to learn from this course. How the data can be visualized using IBM COGNOS just by simply loading .csv or excel file.
by VMMay 24, 2021
Great start to have a chance to see the world of visualization with step-by-step process and guidance to create our own dashboard. Thanks for the course.
by AAJan 30, 2022
Thanks, i will recommend this course for any person who wishes to dive into data analytics. this course is very good, i have a lot on data visualization with both excel and cognos.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Certificate?
More questions? Visit the Learner Help Center.
