Ementorhub

What you'll learn

Create basic visualizations such as line graphs, bar graphs, and pie charts using Excel spreadsheets.

Explain the important role charts play in telling a data-driven story.

Construct advanced charts and visualizations such as Treemaps, Sparklines, Histogram, Scatter Plots, and Filled Map Charts.

Build and share interactive dashboards using Excel and Cognos Analytics.

Skills you'll gain

Data Visualization Software

Dashboard

Scatter Plots

IBM Cognos Analytics

Pivot Tables And Charts

Data Storytelling

Tree Maps

Histogram

Microsoft Excel

There are 4 modules in this course

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.

Creating Visualizations and Dashboards with Spreadsheets

Creating Visualizations and Dashboards with Cognos Analytics

Final Project