Excel 2016 Power BI - 10 Easy Steps for Beginners

Make sure you're confident what's coming up in Power View Step 1 - that way you've got a head start and are super prepared!

Insert your first Power View report from a single Excel table. Learn new terminology with the elements that make up a Power View report such as the "Canvas" and "Visualizations"...

By the end of this lecture you'll know how to resize table Visualizations within Containers and have a handle on the basics of Filtering. Sorting and AutoFit columns will, no doubt, be second nature to you but it's always good to be confident!

Take a peek at all that's coming your way and what you'll know about Power View by the end of this section - knowing your objectives goes a long way in your understanding and development

Table Visualizations are the default Power View display element. By the end of this video lecture you'll know how to "Switch Visualizations" and learn about the alternatives such as Matrix, Cards and Tile By...

By the end of this lecture you'll know how to use the Advanced Filter option, "drill-down" into a Bar Chart and add Slicers - your Power View report is beginning to take shape and your knowledge is expanding!

This lecture explores the limitations of Power View when working with Date fields and workarounds to combat display problems

Take a few minutes to checkout what's coming up next - it helps to prepare yourself and gives you an advantage for learning new concepts

In this lecture you will learn how to work with multiple tables. Using Power Pivot Data Model tools, you will learn how to establish relationships in the Diagram View window enabling sharing of data between tables to display in Power View reports

Prepare yourself for some awesome solution techniques with a sneak-peek at what's coming up in Step 4 of your Power View journey!

In this lecture you'll revisit Power View Filtering and take a deep dive into "Sliders" and "List" mode and how to fine tune to fit your requirements...

When your data set spans multiple years and Power View Filters need a boost, learn how relating an Excel Calendar table to the data model will enable slicing and dicing for end user convenience

Take a few minutes to discover just what you'll learn how to do - confidently - by the time you have completed this section. Half the fun is knowing what's coming up and the anticipation of knowing how to do it. Remember, fail to prepare - prepare to fail!

Power View Maps are the icing on the cake. In this section get to grips with "bubbles" and the new Drop-Zone areas. Maps are THE tools for displaying geographical data and to have the ability to utilise them interactively in reporting - is just GENIUS!

So, you can confidently add a Power View Map to inject some impressive interactivity to your report. Now the boss would like a breakdown by Category in Pie Charts - ON THE MAP! Is this too big an ask? No problem - and what's more - it can be achieved with ease!

Adding images to Power View reports adds that extra dimension especially when you have multi-value series such as Category or Region Managers. By the end of this lecture, you'll be confident adding images to reports and how to configure Power Pivot to categorise them correctly.

Put what you have learned to the test with this consolidation exercise - remember, practice makes perfect!

Take 5 minutes to recap all the key concepts you have covered in the first 5 Steps. By doing so, you will embed and consolidate all the new knowledge you have acquired and set you up for the what's to come. Feel proud and invincible and remember, you are NOW able to create Power View reports - a new skill you didn't have a couple of hours ago! Well done!

Take a refresher in creating multi-table pivots. Find out what's actually going on in the background and remind yourself of the power and additional tools you have at your finger tips!

Your first introduction to the wonderful world of Power Query. This heads-up will prepare you the new skill-set you about to acquire... and it's awesome!

By the end of this lecture, you'll know how to select the source data tables all contained within an Excel workbook

The Query Editor is the "Power-House" of Power Query. Learn how to Transform data including cleaning, preparing, arranging, deleting, splitting....By the end of this lecture, you will be confident with new key concepts and APPLYING STEPS of your own. Prepare to be AMAZED!

You have successfully Connected to the data source, APPLIED STEPS of your own to Transform the data. Now you wish to make some changes. Learn how to re-connect to the data source and Edit existing Queries

Get excited about what you are about to learn next by spending 5 minutes with this heads-up! Hint - you're never work the same again!

If automating file selection from a folder containing many different file types sounds a bit far fetched - then Power Query  could be the solution you have been looking.

So, you know how to automate file selection from a specified folder. Next, learn how to add new data and have Power Query do the "heavy-lifting" to display the results

Check your work with a run-through of the solutions to Practice Exercise 4

Watch this short video outlining what's next in your Power Query journey. Being clear on your objectives keeps you on track and reinforces your learning!

This video lecture demonstrates how to create multiple queries from different file types. Solve the age old problem of European and US date formatting - essential to completing the task

You are now working with multiple queries and date formatting is consistent throughout. In this video lecture you will learn how to Append queries, of differing source files, to create a single data table

In this video lecture I provide the solutions to Practice Exercise 5 - an opportunity for you to feel invincible and confirm how far you have come!