Business Intelligence Workflow with Excel

[mitsumi]

Business Intelligence Workflow with Excel
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hour 44M | 176 MB
Genre: eLearning | Language: English

This course equips data analysts and Excel power users with the Business Intelligence knowledge and best practices required to import data into Excel from different data sources, clean the data, and transform this data into any desired format.

Data transformation from different sources if key when working in Excel. In this course, Business Intelligence Workflow with Excel, you will be equipped with Business Intelligence knowledge, tools, and best practices required to import data into Excel from different data sources, clean the data, and transform this data into any desired format. First, you will see how Power Query is an easy-to-use, yet powerful tool to import data from different sources. Next, you will learn how Power Query can cleanse and transform data without having to write any code. Then, you will also study What-if analysis which allows users to use several data sets in one or more formulas to explore various results. Finally, you will study Cube functions which help to pull data from Analysis Services into Excel. When you are finished with this course, you will have an understanding of the insertion and transformation process data goes through when imported into Excel.

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction