Course Outline


Theoretical Science of Data Analysis

  • The principles of data analysis
  • Objectives of data analysis
  • Approaches for data analysis

Excel and Data Science

  • Data consistency
  • Data types used in Excel

Overview of Power BI

  • Processes and Power products used in Power BI

Preparing the Development Environment

  • Installing and configuring Excel
  • Installing and configuring Power BI

Business Data Analysis in Excel

  • Inserting and working with PivotCharts
  • Inserting and working with PowerPivots
  • Mail merging
  • Linking and duplicating sheets
  • Freezing panes
  • Splitting windows
  • Using conditional formatting
  • Creating a named range
  • Using Execel Web Query
  • Working with Power Excel functions

Power BI and Excel Integration

  • Importing data from Excel to Power BI with Power View
  • Incorporating Excel into the Power BI Portal

Cleaning Data in Power BI

  • Cleaning up cross tab data with unPivot
  • Cleaning up multiple cross tab data
  • Combining data from multiple tabs and sheets

Databases and Reports in Power BI

  • Using relationships to eliminate VLOOKUP
  • Creating calculated columns
  • Creating a custom date table
  • Working with reports and visuals
  • Filtering reports and viewing data
  • Publishing the report to Power BI Portal

DAX and Power BI

  • Adding calculated columns
  • Text grouping
  • Using Bin Analysis
  • Adding measures
  • Comparing past and current data

Summary and Conclusion


  • An understanding of the basics in Excel.


  • Data Analysts
  7 Hours


Related Courses

Power BI

  14 hours

Power BI for Business Analysts

  21 hours

Power BI for Developers

  28 hours

Creating Dashboards Using Microsoft Power BI

  14 hours

Power BI Dashboards

  14 hours

Power BI Dashboard Design

  7 hours

Data Analytics Process, Cloud Solutions, and Power BI Solutions

  35 hours

Analyzing Data with Power BI

  28 hours

Advanced Power BI

  21 hours

PL-300T00: Microsoft Power BI Data Analyst

  21 hours

Power BI DAX Fundamentals

  21 hours

Analysing Financial Data in Excel

  14 hours

Excel For Statistical Data Analysis

  14 hours

Microsoft Office Excel - poziom średnio zaawansowany

  14 hours

Working with spreadsheet in Microsoft Excel

  14 hours