Modern Analytics with Microsoft Excel and Power BI

What you'll learn:

Modern Analytics with Microsoft Excel and Power BI

Requirements:

• People who know how to use Microsoft Excel must do this job.

Description:

In the modern world, Excel and Power BI can be used to do modern analytics.

Take a look at how to make interactive and dynamic Dashboards with Modern Excel ( Power Query, PowerPivot, DAX and Power BI).

Microsoft Excel and Power BI have advanced analytical and BI tools that modern analysts can use to help their organizations have better data conversations.

In this class, you’ll learn about the business intelligence landscape, how technology can help, and what their roles are.

This course or Guided Project will help you learn how to use Excel and Power BI’s advanced and modern analytical tools.

How to connect and shape data with Power Query, how to make data models with PowerPivot and DAX, how to make dashboards with PivotTables and Slicers, and how to use Power Query to get data.

Microsoft Excel’s Data Model will also be used to make an interactive Dashboard with Power BI. You’ll also learn how to use the Data Model to make the Dashboard.

What you’ll learn from this project:

• When you use Power Query, how do you connect and change data?
• How to use DAX to model data and make complicated calculations.
• Learn how to use PivotTables and slicers to look at data
• How to show data and make an interactive dashboard with Pivot charts and slicers.
• Excel data models can be used with Microsoft Power BI, but how?

Who this course is for:

• Users of Microsoft Excel are looking for ways to make their reports and dashboards easier to make.
• Who want to use their Excel skills to learn about Power BI.

Course Details:

• 5 hours on-demand video
• 17 articles
• Full lifetime access
• Access on mobile and TV
• Assignments
• Certificate of completion