 Welcome to Power BI. My name is Jordan McCarthy. I am the data analyst and storyteller at Tech Impact. Power BI is a very powerful data visualization and analytics engine that allows you to transform and reshape and manipulate your data into a wide variety of different forms and then display that data in immediately interactive dashboards that can allow you to tell very compelling stories about your organization's work. I've already set up here a dashboard for, could be any organization. This happens to be taken from an educational nonprofit that makes its fundraising data freely available online. Every visualization you create in Power BI is immediately interactive. So what do I mean by that? If we click on let's say, well first of all we can zoom in on this map and we can see here each dot represents the overall sum total of donations that came in from each state. And let's just say we want to drill down a little bit deeper into California's donations. If we click on this dot you'll see all of the other visualizations on this page adjust themselves to show me just the parts of the overall donation pool that came from California. So now my donation over year chart shows me in deep dark blue the proportion that came from California and even if I hover over it shows me the real numbers that underlie that visualization. And similarly this overall donation card has been updated to show me just the amount that came in from California and my donation by what type of donation it was graph also adjusts to show me in slightly deeper colors how California's like to donate. Could also take a look at New York. We can see interestingly when we do this that New Yorkers seem to have responded quite a bit to this promo code match. Not something we saw in California. So clearly this campaign whatever it was really worked in New York. You will notice that there's a little bit of jumpiness sometimes. The map will automatically try to show you all data that's part of the spread and since there were a few international donations in this data set it keeps on zooming out to show us the whole world. So you might have to zoom in and out a little bit but happily that's very easy in Power BI. And to get out of any particular zoom as we resumed it on the states you can just click anywhere in white space and that will return you to the overall total. Now note that I was just zooming in on states but I can do the same thing now for anything in this graph. So let's say I want to see in fact where did this promo code match thing work best. Okay I can click on promo code match and there we go. It looks like in fact it really only worked in a couple of places. A little bit in California not that much. Mostly New York I can do the same thing by year so let's say I want to look at our best year today 2014. What did that look like? Mostly our donations came in from credit card it looks like. And good representation across the country really it looks like in 2014 our donations were mirrored, our donation pattern more or less mirrored the donation pattern we saw over the entire data set. So I hope that gives you some idea of the power of dashboarding in Power BI.