And so there’s one way you can actually get data from the application as soon as it’s launched. So if I don’t want to filter through here, let’s say, I can actually filter through within these metrics here. One of the most effective ways to do this is by creating custom dashboards. It’s editing, it’s putting, it’s cleaning up some of that data as well for you here. This is the power of business intelligence for you. You can customize your visualizations and edit them and publish them again. We recommend you watch the videos in the recorded sequence, starting with video 01 and ending with video 20. Now, once, let’s say, this is created, you can actually edit a lot here. So this is a pretty large file. This is what’s available at least in the in the free version.

Let’s say, you can look at the general legends and axes, you can change it, you can change the way that the data color shows. My name is Ziad Paracha. Data preparation: Introduction to Power BI, Data Preparation: Cleansing, Modelling and Dashboards, Accounting learning resources from legacy organizations, how to access and transform data into model-ready formats, formulas to aggregate KPI values from data models, PC (not all functions noted in the course for Excel, Power Query, Power Pivot and Power BI may not be compatible with iOS devices), Microsoft Power Query for Excel (free download for Excel 2013, built-in for higher versions).

You throw it into a couple of dashboards and now you’re able to share it, basically, on any medium. These are all the different types of data that you can get.

So I didn’t talk about publishing, but maybe that’s one thing that I’ll touch on here as well is if, let’s say, you you’ve kind of decided that this is the visualization that I want to choose, you can…I mean, I had background colors and logos and things like that. So I would keep that in mind as well.

Whether it’s a C-level type of position or an executive, who just wants to kind of see how profitability is, for example, or just a high level understanding of what the company has been up to, you can have those but you can also go into in-depth and say, “Well, how is my so and so sales rep doing in this particular account or this particular region?” We can dive into that as well in our demo.

But within similar data at least, you can look at…I’m not sure if I click that. So let me do that right away. Increase your skills here. The Power BI Developer in a Day video-based course empowers you as an app developer with the technical knowledge required to embed Power BI content. Again, like I said, you could have quotas, for example, just ideas from a sales perspective at least of the things that you can do in different regions, and how they’re performing, and what they’re doing are indicated by these circles. We'll introduce you to the core concepts. So once that data is kind of loaded, visualizations will be connected or would be created through these kind of diagrams, whether it’s bar graphs, or pie charts, or other cool type of visualizations. So you can look at the opportunity by accounts, for instance, you can you can look at the revenue that’s there. You could do a whole bunch of different things, basically, anywhere.

Your account must have a Power BI Pro license, or you can still accept a Power BI Pro Trial license—an offer that can only be accepted once. So this is how my data looks at this time.

You can, for example, if I want to edit this one, I don’t like the way that this particular visualization looks. Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Consider creating a Power BI account for exclusive use in the labs. Learn how to harness the power of data science to enhance business intelligence and deliver precise, high-quality insights to your stakeholders. One of the exciting announcements during the Microsoft Business Application Summit 2020 Virtual Event was about the T-SQL Endpoint for the Common Data Service (CDS). So these are actually really cool as well, these little boxes.

But really, within the span of five minutes, you can actually get a whole bunch of data onto this and change it. So let’s put that like that, for instance. And if you want to follow along, you can by any means. What’s the opportunities that you get with data and how you can transform your organization for that? Microsoft Power BI is an excellent tool for building effective dashboards. So if I look at electronics, my target margin was 15, my actual margin is actually on 7%. For the sake of this, I’m going to show you the maximum amount of time it takes to, basically, put in all these spreadsheets. But you could change that to your own liking, as well. You can look at all sorts of different things. So this is, for example, my different phases in the pipeline, how these steps kind of go and where the most of the opportunity lies as far as value. You'll find classroom setup notes in slide one of the PowerPoint slide deck. So you could see whether it’s a pipeline or you can have…that’s my same one.

Storing sensitive information is never a recommended practice—it's done to simplify the lab.