Sharing Is Caring:

Business Intelligence and Data Visualisation in Excel 365

Learn Power Pivot, Pivot Tables, Pivot charts, solver, what if analysis and more



Created by Wrikki Lahiri



What you’ll learn

  • Business Intelligence in Excel
  • Advanced Excel Applications
  • Advanced Data Visualisation in Excel
  • Creating Dashboards in Excel
  • Power Query in Excel
  • Power Pivot in Excel
  • Pivot Charts and Tables in Excel
  • What-if-analysis, solver and forecasting using Excel
  • Data Analysis using Excel


  • Basic Excel skills
  • Basic Mathematics
  • Basic understanding of data plots and charts
  • Eagerness to learn


The course – Business Intelligence and Data Visualisation in Excel 365- is designed to teach  excel applications for business intelligence, data visualisation and data analysis to prospective business intelligence analysts, business analysts and those who want to learn how to conduct business intelligence analysis and data analysis in Excel. The course covers all the key business intelligence, data visualisation and data analysis tools that Excel has to offer. And these tools are taught using practical, hands on demonstrations using sample data in Excel. Students will not only learn advanced Excel business intelligence tools but also learn how to analyse and study trends in data. The course will equip students with skills in business intelligence and will teach students how to study, understand and interpret data using Excel. The course will also equip students with advanced data visualisation and data analysis tools. The following topics are covered in the course:

Read Also -->   Bentley Staad Pro v8i

1. Power Query

2. Pivot tables and charts.

3. Power pivot

4. Excel Dashboards

5. Forecasting

6. What-if-analysis

7. Solver

8. Descriptive Statistics

9. Correlation Analysis

10. Regression Analysis

The course has a project at the end of the course. In this project students will deal with data on an apple refurbished product seller, provided by the instructor, and will do the following analysis:

1. Import data with Power Query and transfer the data. This step will involve assigning formatting data.

2. Students will generate pivot charts.

3. Students will create an Excel Dashboard using pivot charts.

4. Students will submit the dashboards.

Who this course is for:

  • People interested in learning Excel for Business Analysis
  • People interested in learning Excel for Business Intelligence
  • People interested in learning advanced Excel applications
  • People interested in learning data analysis and visualisation using Excel
  • People interested in learning power pivots, power queries, and pivot charts and tables in Excel
  • People interested in embarking on a business intelligence and analyst career

Show less

Course content

8 sections • 10 lectures • 1h 39m total lengthCollapse all sections

Importing Data using Power Query1 lecture • 13min

  • Power Query13:19

Power Pivots, Pivot Tables and Pivot Charts2 lectures • 44min

  • Pivot Tables and Pivot Charts22:27
  • Power Pivot21:17

Excel Dashboards1 lecture • 11min

  • Excel Dashboards10:38

Forecasting1 lecture • 5min

  • Forecasting in Excel04:49

What-if-analysis1 lecture • 6min

  • What-if-analysis05:53

Solving Equations in Excel1 lecture • 7min

  • Solver06:52

Data Analysis3 lectures • 14min

  • Descriptive Statistics04:07
  • Correlation Analysis03:13
  • Regression Analysis06:40

Project0 lectures • 0min

  • Create Dashboard Project2 questions

👇👇👇👇 Click Below to Enroll in Free Udemy Course 👇👇👇👇

Go to Course

👇👇 See Also 👇👇

Join Us Join Us Join Us
Sharing Is Caring:

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock