糖心vlog官网观看

In this online Power Query Fundamentals course, we鈥檒l explore the world of data transformation and automation. You鈥檒l learn to extract data from multiple different sources, and transform it into layouts more suited to analysis. We will show you how to automate data connections and transformations, as well as how to extract and consolidate data from multiple files. Finally, we鈥檒l end by looking at how to deal with common errors.

Power Query is absolutely essential for any Excel focused analyst, and is a powerful asset to any Business Intelligence analyst. These skills will help you spend less time on data manipulation, and more time on your analysis projects. By the end of this course, you will be able to: 鈼� Identify the characteristics of good and bad data using the principles of data normalization 鈼� Extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot 鈼� Extract information from fields that combine two or more values 鈼� Transform datasets by grouping or combining data from different tables, or even multiple files from the same folder 鈼� Avoid, interpret, and fix errors and exceptions that you experience in Power Query 鈼� Load transformed data into Excel for use as automated data feeds

This course provides step-by-step instructions for how to set-up a business intelligence dashboard in Excel using the Power Pivot add-on. You鈥檒l learn the key functions and best practices for setting-up a dashboard. As you progress through the course, you鈥檒l apply everything you鈥檝e learned to a hands-on example using data we provide. By the end of this course, you鈥檒l walk away with everything you need to create your own dashboards in Excel鈥攕o you can analyze and present data, track KPIs, and make your data easily accessible.

Upon completing this course, you will be able to: 鈼� Create a Power Pivot table by drawing data from several different tables 鈼� Develop simple calculated metrics with consistent formatting to be re-used across our dashboard 鈼� Assemble multiple pivot tables, charts, and dimensions into a dashboard 鈼� Apply DAX formatting language to create measures and columns that draw data from other tables 鈼� Manipulate context to calculate more advanced metrics 鈼� Utilize DAX Advanced Time Intelligence to create powerful period comparisons and KPIs