Join Gini von Courter for an in-depth discussion in this video What you should know before watching this course, part of Power BI Features in Depth.
There are some pre-requisites for this course. Almost all of the work that we do in Power BI will be based in some way in Microsoft Excel. So, there are things you need to know about Excel in order to be effective in this course. First, I'm assuming that you know how to enter, edit and format text and numbers in an Excel workbook, that you know how to use the format as table command and why you would do that. That you are very comfortable finding and replacing information. That you know how to sort and filter data within a table including multi-level sorts.
And conditional formatting. And that you're comfortable creating and formatting charts. Now, if all of these things feel fairly new to you, then I would like to recommend that you take a look at the Excel 2013 Essential Training course in the lynda.com training library. This is a great course that will take you through all of the things you're going to need to know in order to succeed. If you're relatively comfortable with many of these features, but you think I'd like a little bit more practice or I'd just like to brush my skills up a little more, I use Excel some but I'm not in it every single day.
Let me suggest a couple of different courses that would help you buff up your skills. First, Excel 2013: Managing and Analyzing Data, which will start with some of the basics, but will take you to a whole other level in terms of how you're thinking about data which is the foundation for everything we're going to do in Power BI. I also want to recommend the Excel 2013 Power Shortcuts course, because it will help you develop some more efficiencies in Excel, which then, of course, will carry over into your work with Power BI.
Here are the basic skills, whether some of these skill are new skills for you, or you're an old hand at everything that you can do with data in Excel 2013. I look forward to working with you on Power BI.
AuthorGini von Courter
- Understanding data analysis and business intelligence
- Installing Office BI add-ins
- Searching for online data with Power Query
- Shaping data in the Query Editor
- Connecting to data sources
- Modeling data with Power Pivot
- Enhancing PivotTables and PivotCharts with PowerPoint
- Visualizing geospatial data with Power Map
- Creating and formatting Power View reports
- Sharing your data using Power BI for Office 365
Skill Level Intermediate
1. Getting Started: Self-Service, Power BI, and BI Tools
2. Using Power Query to Get Data
3. Modeling Your Data with Power Pivot
4. Enhancing PivotTables and PivotCharts with Power Pivot
5. Expanding the Data Model in Power Pivot
6. Visualizing Geospatial Data with Power Map
7. Creating and Formatting Power View Reports
8. Creating Other Power View Visualizations
9. Sharing Your Data Using Power BI for Office 365
Next steps2m 59s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.