Competitor/Feature/Customer Feature analysis using Power Query and PowerPivot
In this video, I'd like to show how you can perform a Competitor/Feature/Customer Analysis using Power Query and PowerPivot. You may read the problem description and download my workbook from this link - http://www.ashishmathur.com/perform-a-competitor-feature-and-customer-analysis-with-the-powerpivot
Видео Competitor/Feature/Customer Feature analysis using Power Query and PowerPivot канала Ashish Mathur
Видео Competitor/Feature/Customer Feature analysis using Power Query and PowerPivot канала Ashish Mathur
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Append data from multiple worksheets with diff structures
Converting a tabular data layout to a matrix layout MS Query
Compute product wise YTD Revenue from a matrix like dataset
Remove duplicates from rows
Visualing data flows using PowerBI desktop
Dynamically tranpsoe data after ignoring blank cells
Transpose data columnwise
Unpivot a dataset
Create a Pivot Table from multiple individual ranges without using ancillary columns
Merge and Append data from two worksheets
Merge data from multiple cells into one cell
Power Query Extract unique entries
Customise Pivot Table Reports
Flip a string with conditions
Speed up the task of a VLOOKUP on a large database
Consolidate multiple rows of data and remove blank rows
Sales data modelling and interactive visualisations
Create a Pivot Table from multiple worksheets of a workbook
Facilitating many to many relationships
Show multiple text entries in one cell of a Pivot Table