Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot and Power BI, three power tools for transforming, analysing and presenting data.
Excel's ease and flexibility have long made it a tool of choice for doing data analysis, but it does have some inherent limitations: for one, truly "big" data simply does not fit in a spreadsheet and for another, the process of importing and cleaning data can be a repetitive, time-consuming and error-prone. Over the last few years, Microsoft have worked on transforming the end-to-end experience for analysts, and Excel has undergone a major upgrade with the inclusion of Power Query and Power Pivot.阅读更多.
此资源由附属合作伙伴提供。 如果您支付培训费用，我们可能会赚取佣金来支持该网站。
The techniques and tools covered in Excel Power Tools for Data Analysis are most similar to the requirements found in 商业分析师 data science job advertisements.
Excel Power Tools for Data Analysis is a part of 一 structured learning path.
3 Courses
4 Months
Excel Skills for Data Analytics and Visualization
