課程大綱： 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
加入高級會員獲得助教答疑
