Basics to start

[Hash tag]

I have considered Excel, Business Intelligence as career. I want to learn basics but don't know where to start. Can anyone please guide what should be the route. Power Pivot, Power Query or BI. Shall be thankful to all of you

 

[sheetspread]

A good starting place is Power Pivot and Power Query:

https://www.youtube.com/watch?v=ms149Qi2PVA
https://www.youtube.com/watch?v=vZSOpmg4ehw

Matt Allington and Rob Collie have produced excellent videos and books also, be sure to search youtube, google, amazon, etc.

The mrexcel Power BI page has many problems/solutions on the subject, start by posting there when you get stuck and in time respond to other people's inquiries.

Power Pivot and Power Query are the main components of Power BI (in an Excel or MS Office context). Older and perhaps more enterprise-oriented applications like Cognos and SSAS are also popular.

 

[Hash tag]

Thanks. I am really obliged

 

[Hash tag]

Matt Allington and Rob Collie books on excel, power pivot, business intelligence, learn to write DAX are required. they are not freely available. anyone can help?

 

[Fluff]

Have a look at the MrExcel Store (button at the top of the page)

 

[sandy666]

As basic
Getting Started with Get & Transform
Microsoft Power Query for Excel
similar way for PowerPivot