Register Online - Add to Cart
Product ID: 406705EAU
 
Credit & Course Provided by:

BI Reporting: Excel Power Pivot and Power Query

OnDemand Webinar (87 minutes)

Learn why Power Query is the recommended experience for discovering, connecting to, and importing data.

In today's world, there is tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. Many companies have reduced their IT staff, so more and more, it is up to each person to deal with all of this data. This topic will show you how to take large amounts of data from many sources and process it into great reports. If you work with data, you're likely already familiar with common frustrations with Microsoft® Excel® like size limitations and manually entering data from multiple sources. Luckily there are two Microsoft® tools, Power Pivot and Power Query, that solve ALL of these issues, right inside Excel®. No Access® databases or IT department help needed. With imports of 1 million+ rows of data sets from virtually any source and the ability to save query definitions, you can completely overhaul your reporting and analysis workflow. Power Query and Power Pivot complement each other. Power Query is the recommended experience for discovering, connecting to, and importing data. Power Pivot is great for modeling the data you've imported.

Authors

Tom Fragale, DBA The PC Guy Consulting, INC

Agenda

Importing Data From Other Sources Into Excel® Using Power Query

• Importing Data From Text

• Importing Data From Access®

• Importing Data From Larger Data Bases

• Filtering and Sorting Using Power Query

Making Reports With Power Pivot

• Combining Data From Different Sheets With Relationships

• Adding Slicers, Timelines and Charts to the Power Pivot

• Making the Power Pivot Show by Date, Month, Quarter or Year

Using the Power Pivot Features to Create New Formulas

• Creating a Measure

• Creating a KPI From a Measure