要求
- An understanding of the basics in Excel.
Audience
- Data Analysts
课程概览
Microsoft Excel是世界上最受欢迎的业务分析，报告和策略软件。 Power BI是一种商业智能工具，用于在业务运营级别可视化数据。
这种由讲师指导的实时培训（现场或远程）针对希望学习Excel数据准备技术，然后在Power BI中将其可视化的数据分析人员。
在培训结束时，参与者将能够：
- 了解数据分析的原理，数据分析的目标以及数据分析的方法。
- 在Power BI使用DAX公式进行复杂的计算。
- 为特定的分析案例创建和使用可视化和图表。
- 使用Power View导入可从基于Excel的Power BI迁移到独立的Power BI 。
课程形式
- 互动式讲座和讨论。
- 很多练习和练习。
- 在现场实验室环境中动手实施。
课程自定义选项
- 要请求此课程的定制培训，请与我们联系以安排。
Machine Translated
课程大纲
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