Knowledge Visualization and Dashboards with Excel and Cognos

About this Course

This course covers a number of the first steps within the growth of information visualizations utilizing spreadsheets and dashboards. Start the method of telling a narrative together with your knowledge by creating the numerous kinds of charts which are obtainable in spreadsheets like Excel. Discover the totally different instruments of a spreadsheet, such because the necessary pivot operate and the power to create dashboards and learn the way every one has its personal distinctive property to rework your knowledge. Proceed to realize priceless expertise by turning into acquainted with the favored analytics instrument – IBM Cognos Analytics – to create interactive dashboards.

By finishing this course, you’ll have a fundamental understanding of utilizing spreadsheets as an information visualization instrument. You’ll acquire the power to successfully create knowledge visualizations, equivalent to charts or graphs, and can start to see how they play a key function in speaking your knowledge evaluation findings. All of this may be achieved by studying the fundamentals of information evaluation with Excel and IBM Cognos Analytics, with out having to write down any code. By the top of this course it is possible for you to to explain widespread dashboarding instruments utilized by an information analyst, design and create a dashboard in a cloud platform, and start to raise your confidence degree in creating intermediate degree knowledge visualizations. All through this course you’ll encounter quite a few hands-on labs and a closing venture. With every lab, acquire hands-on expertise with creating fundamental and superior charts, then proceed by the course and start creating dashboards with spreadsheets and IBM Cognos Analytics. You’ll then finish this course by making a set of information visualizations with IBM Cognos Analytics and creating an interactive dashboard that may be shared with friends, skilled communities or potential employers. This course doesn’t require any prior knowledge evaluation, or pc science expertise. All you have to get began is fundamental pc literacy, highschool degree math, entry to a contemporary internet browser equivalent to Chrome or Firefox, the power to create a Microsoft account to entry Excel for the Net, and a fundamental understanding of Excel spreadsheets.

This course is a part of a number of applications

This course will be utilized to a number of Specializations or Skilled Certificates applications. Finishing this course will rely in the direction of your studying in any of the next applications:

• IBM Knowledge Analytics with Excel and R Skilled Certificates
• IBM Knowledge Analyst Skilled Certificates

WHAT YOU WILL LEARN

• Create fundamental charts and pivot charts in Excel.

• Clarify the necessary function charts play in telling a data-driven story.

• Assemble superior charts and visualizations.

• Construct dashboards utilizing Excel and Cognos Analytics.

SKILLS YOU WILL GAIN

• Microsoft Excel
• Knowledge Evaluation
• Knowledge Visualization (DataViz)
• IBM Cognos Analytics
• Dashboard

Syllabus – What you’ll be taught from this course

Content material Ranking93%(4,171 scores)

WEEK

1

2 hours to finish

Visualizing Knowledge Utilizing Spreadsheets

On this module, you’ll be launched to the fundamentals of charts and the Excel features which are used to create fundamental charts and pivot chart visualizations. By studying manipulate these options and creating visualizations, you’ll start to know the necessary function charts play in telling a data-driven story.

WEEK

2

2 hours to finish

Creating Visualizations and Dashboards with Spreadsheets

On this module, you’ll find out about creating superior charts and visualizations and be taught in regards to the fundamentals of dashboarding and create a easy dashboard utilizing a spreadsheet.

WEEK

3

3 hours to finish

Creating Visualizations and Dashboards with Cognos Analytics

On this module, you’ll be launched to a different dashboarding resolution known as Cognos Analytics. After registering with Cognos Analytics, you’ll then discover the platform capabilities by creating visualizations, constructing a easy dashboard, and discovering its superior options.

WEEK

4

2 hours to finish

Closing Mission

Congratulations! You might have now accomplished the modules for this course. On this module, you’ll full the ultimate project that shall be graded by your friends. Within the first a part of the ultimate project, you’ll use supplied pattern knowledge to create some visualizations utilizing Excel for the net. Within the second a part of the ultimate project, you’ll create some visualizations and add them to a dashboard utilizing Cognos Analytics.