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
180,664 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. 10 hours to complete
English
Subtitles: French, Portuguese (European), Vietnamese, Russian, English, Spanish
Skills you will gain
Microsoft ExcelData AnalysisData Visualization (DataViz)IBM Cognos AnalyticsDashboard
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. 10 hours to complete
English
Subtitles: 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. This week, 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
TOP REVIEWS FROM DATA VISUALIZATION AND DASHBOARDS WITH EXCEL AND COGNOS
by AOApr 9, 2021
As an aspiring data analyst, this course gave me more information about what I am currently doing and after finishing this course I have learned a lot and gave me more interest to learn more.
by MPNov 6, 2020
I think I accomplished the most with this course. It was very cleanly accelerated but left enough open to explore more capabilities. I really love Cognos.
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 THFeb 15, 2021
I enjoyed the course but really struggled to create a pdf of my final assignment on Cognos Analytics at the end, which left me feeling hugely frustrated.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Certificate?
Will I earn university credit for completing the Course?
More questions? Visit the Learner Help Center.
