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
Within the Power BI interface, there are three main tabs. We have the Reports tab, the Data tab, and the Model tab. The reports tab is the default, and it's where you see the canvas. This is the main place where visualizations are created and arranged, and it's where we've been working so far in this course, but the other tabs are very important and we will be spending plenty of time on those in this course as well.
All right. So next in line is the Data tab. Data View allows you to see all of the tables in your data sources, and they're all listed on the right-hand side. This is where we validate data, mine and transform data, create data we need if it doesn't already exist, and check data types. So I'm checking this data type right here, and it's a good thing we checked because this should be a number format, not text, which is very important in Power BI. This last tab is the Model tab, and this allows you to create and manage relationships between tables.
Relationships are a very important concept. They allow us to use the data from two or even more tables in the same visual. A relationship is where two or more tables are linked together because they each have a specific column of data in common. Think of store IDs. We have this store's table with a bunch of information about stores, and it has their store IDs listed in one of the columns. We have this other table, which is a list of all of the sales transactions that have happened at our company, and we make sure to record which store they happened at. So this table also has the store IDs. We can create a relationship between these tables using their matching information, the store IDs. And now we're able to perform analyses we would not previously have been able to perform, such as seeing a list of all of our stores by store description, and what each one of their total sales is.
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.