In today's busy world as an office worker, you might have to handle huge amounts of data from many different sources, and some how make sense of the data. It can be an overwhelming task. Microsoft recently introduced a new program called PowerBI , which will allow you to take all of your data from many different data sources and make great charts, reports, and dashboards from that data to get powerful results. This course will show you 25 Must-Know tips on using Microsoft PowerBI. Topics: Importing Excel Data Importing Text/CSV Data Importing Access Data Importing SQL Data Importing From a website Splitting Columns Merging Columns Calculating Age Calculating in PowerQuery Conditional Calculating in PowerQuery Joining Tables Visual w/1 table Visual w/multiple tables Drill Down Small Multiples Changing Calculation Type Filter / Slicer 2 Axis Chart Analytics Gauge Chart Publish the report Getting Additional Visuals Calculating Running Total Calculating Filtered Total Showing Year to Year difference