Learning Path

Microsoft Certification Path

Excel and Power BI tools are core in Business Intelligence Analyst arsenal. For performing ETL, data modeling, data mining, data analysis visualization, and presenting insights to stakeholders.

2 Courses
11 Hours in Total
5 Case Studies
Lifetime access to course Content

Market Opportunity

The job market for business intelligence analysts is expected to grow by 21% from 2014 to 2024, according to the United States Bureau of Labor Statistics. They are required in many different fields, from healthcare to education to finance to law enforcement.

Career Opportunity

Over the next 10 years, approximately 232,000 new analytics jobs are slated to open up?

Certified Excel users increase their likelihood of promotions and lift earnings by 15% on average compared to non-certified users, while also showing an average productivity gain of 20%.

Power BI-certified developers earn upwards of $88,000 for entry-level positions and up to $134,000 for senior roles.

Rare skills

What You Will Learn

  • Building queries in Excel. Combining data from multiple files.
  • Modeling data in Excel’s Data Model
  • Transforming and cleaning data
  • Building relationships between data sets
  • Calculating DAX measures. Building Basic and Advanced DAX functions
  • Using Excel with Power BI
  • How to connect to data and transform data sources in Power BI
  • How to create a data model and build visualizations in Power BI
  • Learn all the topics covered in the Microsoft DA-100 PowerBI Exam
MS Excel Exam Guide: Analyzing and Visualizing Data
1
4 hours
Microsoft Certified: Data Analyst Associate with Power BI
2
7 hours

Other Learning Paths

The new powerful tool that will guide you on your educational journey and empower your career with Data Science.

Become an Artificial Intelligence (AI) Engineer

An AI engineer builds AI models using machine learning algorithms and deep learning neural networks to draw business insights, which can be used to make business decisions.

Learn More

Tensorflow 2.0 Skill Track

A TensorFlow specialist utilizes the vast knowledge of the TensorFlow library to create everything from neural networks to chat bots as a means to solve a myriad of problems in data science.

Learn More