Business Intelligence using Microsoft Excel

In this training, you will learn Learn how to evaluate business processes using Excel worksheet formulas..

15

 5h 06m | 35 Videos | 59340 Views |   Beginner

Business Intelligence Using Excel:

Business intelligence (BI) is essentially the collection of tools and processes that are used to gather data and turn it into meaningful information that people can use to make better decisions. Using Excel, you can create powerful reports, scorecards, and dashboards. You can bring data into Excel, sort, and organize data, and use it to create reports and scorecards. You can also use powerful analytic capabilities in Excel to visualize and explore data.

This training will help you learn about:

• Sorting Algorithm in Excel
• Filter and Criteries
• Conditonal Formatting
• Data Charts in Excel
• Hands on with Pivot Tables
• Data Tables in Excel
• What-If Analysis:
• Solver
• Analysis ToolPak financial, statistical and engineering data analysis
• Power BI
• QlinkView BI
• Advance BI topics
• Demo projects

Target Customers:

• Students
• Working Professionals
• Data Analysts
• Business Analysts

Pre-Requisites:

• Basic computer knowledge
• Familiarity with the Microsoft Office work environment

Back to top ▴