         Excel to Power BI培訓

Introduction

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