Business Intelligence and Data Visualisation in Excel 365
Business Intelligence and Data Visualisation in Excel 365, available at $34.99, has an average rating of 4.4, with 10 lectures, based on 173 reviews, and has 4103 subscribers.
You will learn about 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 This course is ideal for individuals who are People interested in learning Excel for Business Analysis or People interested in learning Excel for Business Intelligence or People interested in learning advanced Excel applications or People interested in learning data analysis and visualisation using Excel or People interested in learning power pivots, power queries, and pivot charts and tables in Excel or People interested in embarking on a business intelligence and analyst career It is particularly useful for People interested in learning Excel for Business Analysis or People interested in learning Excel for Business Intelligence or People interested in learning advanced Excel applications or People interested in learning data analysis and visualisation using Excel or People interested in learning power pivots, power queries, and pivot charts and tables in Excel or People interested in embarking on a business intelligence and analyst career.
Enroll now: Business Intelligence and Data Visualisation in Excel 365
Summary
Title: Business Intelligence and Data Visualisation in Excel 365
Price: $34.99
Average Rating: 4.4
Number of Lectures: 10
Number of Published Lectures: 10
Number of Curriculum Items: 11
Number of Published Curriculum Objects: 11
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- 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
Target Audiences
- 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
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:
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.
Course Curriculum
Chapter 1: Importing Data using Power Query
Lecture 1: Power Query
Chapter 2: Power Pivots, Pivot Tables and Pivot Charts
Lecture 1: Pivot Tables and Pivot Charts
Lecture 2: Power Pivot
Chapter 3: Excel Dashboards
Lecture 1: Excel Dashboards
Chapter 4: Forecasting
Lecture 1: Forecasting in Excel
Chapter 5: What-if-analysis
Lecture 1: What-if-analysis
Chapter 6: Solving Equations in Excel
Lecture 1: Solver
Chapter 7: Data Analysis
Lecture 1: Descriptive Statistics
Lecture 2: Correlation Analysis
Lecture 3: Regression Analysis
Chapter 8: Project/ Practise Activity
Instructors
-
Ricky Lahiri
Data Scientist, Digital Marketer and Doctoral Student.
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 2 votes
- 3 stars: 16 votes
- 4 stars: 70 votes
- 5 stars: 85 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Six Sigma Certified Course on Organizational Psychology
- First Time Manager
- HR Placement & Certification readiness tests
- Food Safety: HACCP Hazard Analysis Critical Control Point
- Business Intelligence and Data Visualisation in Excel 365
- How To Measure Impact?
- The Ultimate Restaurant Start-Up Academy!
- Tenant Screening for Landlords
- Welcome to Sales School
- ISO 22000 (FSMS) Implementation and Internal Auditor Course
- Survey Data Analytics using SPSS
- Disciplined Agile Scrum Master (DASM)-Practice Tests
- Sneaker Reselling – Learn GOAT Reselling – Work From Home
- Enterprise Sales Success: What You Actually Do
- Corporate Etiquettes and ethics
- Prevent burnout in your teams – Ultimate toolbox for leaders
- Mastering Collaboration and Leadership – Leading by Example!
- Directing the Actor: A USC course with Nina Foch
- Fiction Writing – Write, Polish and Publish Your First Novel
- Start a Classifieds Website From Scratch