Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Using Power BI with Excel

Using Power BI with Excel

48mIntermediate2022-02-23

Authors

John David Ariansen

John David Ariansen

Helping organizations understand and use data

Madecraft

Madecraft

Full-Service Learning Content Company

Course details

Are you ready to take your skills as a data analyst to the next level? Power BI is an easy-to-use analytics tool that can streamline how your organization works with data. In this course, instructor John David Ariansen shows you how to combine the power of a familiar tool, Excel, with all the potential of Power BI.

Discover how to conduct power pivots, import data, clean and shape data, and model data to present to stakeholders. Learn about performing calculations with Data Analysis Expressions (DAX) and visualizing your data with the various built-in charts and graphs in Power BI. Along the way, John gives you a short primer on how to get the most out of PivotTables and PivotCharts. By the end of this course, you’ll be equipped with new skills to take your data analysis to the next level.

Skills covered

Power BIBusiness AnalyticsBusiness IntelligenceSpreadsheetsData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

  • 01 - Transforming and refining your data

1. Excel vs. Power BI

  • 02 - Power BI desktop vs. Excel
  • 03 - Business intelligence (BI) with Excel
  • 04 - Excel business intelligence add-ons

2. Business Intelligence with Excel

  • 05 - Pros and cons of Excel
  • 06 - Cleaning data in Excel
  • 07 - Combining data in Excel
  • 08 - Creating calculations in Excel
  • 09 - Visualizing trends in Excel

3. Power BI Overview

  • 10 - What is Power BI
  • 11 - Connecting to multiple data sources
  • 12 - Data modeling
  • 13 - Introduction to DAX
  • 14 - Visualizing data

4. Business Intelligence with Power BI

  • 15 - Connecting to and cleaning data
  • 16 - Creating calculated columns in Power BI
  • 17 - Implicit vs. explicit measures
  • 18 - Building a data model
  • 19 - Data tables vs. lookup tables
  • 20 - Building line graphs
  • 21 - Building bar charts
  • 22 - Building geomaps
  • 23 - Creating a slicer
  • 24 - Creating a dashboard

Conclusion

  • 25 - Next steps

Related courses

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal