Power BI has changed the BI landscape forever, enabling BI professionals and regular Excel users alike to work with big data and build insightful dashboards.
Learn to use this powerful business intelligence solution from the ground up. Navigate the intuitive user interface and explore the ecosystem of data modeling tools. Discover outside-the-box visualizations and broadcast your insights to colleagues in the Power BI Service. This Course gives you a solid foundation to begin your Power BI journey.
On completing this Course, learners will be able to:
- Identify the primary components of the Power BI interface: reports, data, and model views
- Import Excel data and build basic visuals
- Publish a desktop report to the Power BI Service
- Identify common challenges in Power BI data models, implement smart solutions, and avoid common mistakes
- Business professionals whose job requires them to design, build, or deliver business intelligence metrics
- Anyone preparing to take the Microsoft PL-900 exam
A desire to learn to use Power BI
While reports are anchored in one data model or one dataset, dashboards can contain visuals from any number of datasets. We can hand-select specific metrics from a variety of sources to compile a collection of insights that cater to the needs of a specific purpose. For instance, our director would like to see some of our client account information side-by-side with some of our Sales details. We don't usually have that information in the same data model, but we can definitely pull those metrics from different data models into one dashboard.
We will start by accessing the report where we can find the sales metrics. After we identify the metrics we want, we can simply pin them using this pin icon that appears when we hover over a report. We can pin this to an existing dashboard or we can create a new one. Our director wanted a new dashboard made for them, just for these metrics, so let's choose new dashboard. And let's give it a name and click pin. We'll get a popup in the upper right, and we could click to go to this dashboard right now, or we can navigate to it later by selecting my workspace and opening the dashboard from here. And there's our pin! So I can navigate to as many different data sources as we need and pin all the visuals that are relevant for this dashboard.
Chelsea Dohemann is a Senior Technical Trainer and Microsoft Certified Master with almost a decade of experience in technology training. She has taught an array of applications from Microsoft products including Office 365 web apps, Microsoft Office Suite, Power BI, VBA for Excel, and SharePoint to Adobe Acrobat Pro and Creative Cloud. Being a persistent learner herself, Chelsea is acutely in-tune with the challenges of learning. She presents her topics in plain language, with real-world examples, reducing complex concepts down to their simple parts.