Start learning with our library of video tutorials taught by experts. Get started

Power BI Features in Depth
Illustration by John Hersey

Power BI Features in Depth

with Gini Courter

Video: Welcome

Welcome to Power BI Features in Depth.
Expand all | Collapse all
  1. 4m 32s
    1. Welcome
      1m 4s
    2. What you should know before watching this course
      1m 56s
    3. Using the exercise files
      1m 32s
  2. 23m 50s
    1. Understanding BI
      6m 36s
    2. What you need for Excel self-service BI
      2m 30s
    3. Understanding Office 365 Power BI
      3m 9s
    4. Enabling Component Object Model (COM) add-ins for Power Pivot and Power View
      2m 37s
    5. Installing Power Map
      5m 20s
    6. Installing Power Query
      3m 38s
  3. 1h 10m
    1. Searching for online data with Power Query
      7m 21s
    2. Types of Power Query data sources
      4m 52s
    3. Shaping data in the Query Editor
      8m 55s
    4. Transforming Data
      14m 48s
    5. Appending queries
      3m 16s
    6. Duplicating a query
      3m 1s
    7. Merging queries
      9m 24s
    8. Connecting to an Excel data source
      2m 53s
    9. Connecting to a commercial data source
      6m 56s
    10. Troubleshooting queries
      8m 56s
  4. 31m 33s
    1. About Excel data models
      2m 57s
    2. Using Excel tables
      5m 25s
    3. Using Power Queries
      2m 41s
    4. Understanding relationships
      4m 33s
    5. Creating relationships between tables
      5m 42s
    6. Using database tables
      5m 30s
    7. Cleaning up the data model
      4m 45s
  5. 22m 50s
    1. Creating a PivotTable
      4m 34s
    2. Marking a data table
      4m 15s
    3. Adding slicers to the PivotTable
      5m 4s
    4. Adding a timeline to a PivotTable
      4m 33s
    5. Creating and formatting a PivotChart
      4m 24s
  6. 51m 36s
    1. Building the Contoso data model
      10m 28s
    2. Adding calculated columns
      5m 13s
    3. Understanding DAX functions in Power Pivot
      4m 24s
    4. Adding a related column
      4m 33s
    5. Building a hierarchy
      8m 45s
    6. Creating a measure
      6m 55s
    7. Creating a key performance indicator (KPI)
      11m 18s
  7. 47m 26s
    1. Understanding spatial data
      2m 42s
    2. Creating a tour
      6m 0s
    3. Using formatting tools
      3m 49s
    4. Using categories
      1m 52s
    5. Adding a scene to the tour
      5m 41s
    6. Adding detail with annotations and text boxes
      2m 30s
    7. Inserting a 2D chart
      4m 18s
    8. Visualizing data over time
      10m 47s
    9. Capturing a map screenshot
      3m 30s
    10. Saving a Power Map video
      6m 17s
  8. 25m 31s
    1. Understanding Power View
      5m 47s
    2. Creating and using a table visualization
      2m 54s
    3. Saving a Power View report
      43s
    4. Formatting a report
      4m 42s
    5. Refreshing Power View data
      24s
    6. Changing a table to a matrix visualization
      2m 29s
    7. Adding data to a visualization
      4m 18s
    8. Applying filters
      4m 14s
  9. 28m 56s
    1. Creating a column chart
      2m 21s
    2. Creating bar, line, and pie charts
      1m 58s
    3. Creating chart multiples to display data details
      5m 5s
    4. Creating a scatter chart
      7m 17s
    5. Creating a map visualization
      3m 28s
    6. Adding slicers to reports
      2m 35s
    7. Creating a card visualization
      1m 54s
    8. Using tiles for navigation
      4m 18s
  10. 40m 7s
    1. What you need for Power BI
      4m 59s
    2. Sharing and using Power Queries
      4m 59s
    3. Sharing a Power View report
      5m 14s
    4. Using the Power BI sites
      6m 2s
    5. Getting started with Power BI Q&A
      7m 19s
    6. Adding synonyms to a data model
      7m 16s
    7. Improving the data model for QA
      4m 18s
  11. 2m 59s
    1. Next steps
      2m 59s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Power BI Features in Depth
5h 49m Intermediate Jun 30, 2014

Viewers: in countries Watching now:

Learn how you can easily search, access, and analyze data inside and outside of your organization in just a few clicks with Power BI—the business intelligence features that lie inside Microsoft Office. Author Gini Courter walks you through two toolsets: the self-service BI tools that only require Excel, and Power BI, which relies on Office 365. Using the Power Query, Power Pivot, Power Map, and Power View tools in Excel 2013, you'll learn to connect to local and remote data sources, model that data, and present your findings in the form of tables, charts, maps, and reports. Then Gini switches to Power BI to enhance and share the queries and reports you just created. As you'll soon find in the course of these tutorials, Microsoft's BI tools allow you to use the software you already know and love to analyze and share complex business data.

Topics include:
  • 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
Subjects:
Business Data Analysis IT Business Intelligence
Software:
Excel SharePoint Office 365 Power BI for Office 365
Author:
Gini Courter

Welcome

Welcome to Power BI Features in Depth. In this course we'll use two different Excel 2013 Tool Set. The four self-service BI Tools that only require Excel and the Power BI tools that work with Office 365. First, I'll show you how to use Excel 2013 and the free add ins Power Pivot, Power Query, Power View, and Power Map to connect to data sources online and on your computer, build data models that are powerful, and summarize, analyze and present your data in tables, charts, maps, and reports.

Then we'll switch to power BI and see how you can share those queries and reports that you've already created using the new Office 365 Power BI tools. If you're comfortable with Excel features like tables, charts, and pivot tables and are ready to do more with your data, then I designed this course for you. Let's get started.

There are currently no FAQs about Power BI Features in Depth.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

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.


Mark all as unwatched Cancel

Congratulations

You have completed Power BI Features in Depth.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.