In today's busy world, we are all presented with overwhelming amounts of data, and we are given the task of making sense of that data. It can be a very time-consuming task to pull all of this data together and somehow make sense of this large amount of data.

Microsoft has come up with 2 great tools, Power Query and Power BI, which can help you gather your data, and report on it in many ways. This course will show you how to gather and manipulate your data using Power Query, and then how to make the data visually appealing and dynamic with PowerBI. Power Query is really built into the desktop version of Power BI.

Topics covered:

• Downloading Powe rBI
• Tour of screen
• Importing data from Excel Normal data, Formatted data
• Text Access SQL
• Server web building and managing different visuals
• Adding and managing Slicers
• Add columns, Delete column, Merge columns, Split columns, Conditional column
• Date fields, Number fields, Text fields
• Quick measure: Filters Running, Total Year to Year Change