Udemy

Business Data Analysis with Microsoft Excel and Power BI

Enroll Now
  • 21,149 Students
  • Updated 11/2020
4.4
(2,383 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
12 Hour(s) 34 Minute(s)
Language
English
Taught by
Michael Olafusi
Rating
4.4
(2,383 Ratings)

Course Overview

Business Data Analysis with Microsoft Excel and Power BI

An in-depth training on Excel and Power BI for busy professionals who use Excel a lot at work.

**** Important Notice *********************************

We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!

*************************************************************

Microsoft Excel is the world's most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization's progress. And, hopefully, it will lead to a much greater career role and opportunity for you.

Power BI is Microsoft's business intelligence and dashboarding tool that enables organizations to have a wholesome understanding of what is happening at all operational levels of the company. With it you can create reports with drill down features, access-level restrictions, auto-refresh, alerts/triggers and interactivity.

This training is going to focus on making you highly proficient in the use of Excel and Power BI for business data analysis, dashboard creation and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work.

Course Content

  • 10 section(s)
  • 64 lecture(s)
  • Section 1 Introduction
  • Section 2 Data Manipulation in Excel and setting the foundation.
  • Section 3 Charts
  • Section 4 Creative Excel Use and Tips
  • Section 5 Business Data Analysis
  • Section 6 Live Session on Advanced Filtering, Custom List, Data Validation, Charts...
  • Section 7 Power BI
  • Section 8 Excel VBA
  • Section 9 Difference Between Data Analysis, Business Analysis, BI and Big Data
  • Section 10 Demonstration of Pivot Table vs Power Pivot vs Power BI

What You’ll Learn

  • Constantly being updated with new content and covering more areas of business data analysis.
  • Be more productive and creative in their use of Microsoft Excel and Power BI for business and reporting
  • Become proficient in using PivotTables for analyzing a large data
  • Become proficient in the use of VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboarts/reports.
  • Learn how to use Sorting in more advanced ways: multi-level sorting, sorting left to right.
  • Learn how to create professional and great looking charts in Excel and understand when to use a particular chart type.
  • Learn creative uses of Excel and a lot of keyboard shortcuts that saves analysis time
  • Be introduced to Excel VBA, shown how to create a macro by clicking a particular button twice.
  • Make a sample Excel VBA userform that gets data from user and input into a table in Excel
  • Learn Power BI and other new interesting business data analysis tools by Microsoft


Reviews

  • W
    Wan Adibah
    5.0

    very details and clear explanation

  • K
    K Arunramachandran
    1.0

    Worst Explanation

  • G
    Gagan Kumar A N
    4.5

    good

  • M
    Mansi Agrawal
    5.0

    amazing

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed