Register Online - Add to Cart

Credits

Only registered attendee will receive continuing education credit.
Product ID: 406705
 

BI Reporting: Excel Power Pivot and Power Query

Live Webinar
December 19, 2019
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart

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 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, PowerPivot and PowerQuery, that solve ALL of these issues, right inside Excel®. No Access databases or IT department help needed. With imports of 1-million-plus 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.

Learning Objectives

• You will be able to define different types of data that can be pulled into Excel.

• You will be able to identify how to link tables together on common fields.

• You will be able to review large amounts of data very quickly using the PowerPivot.

• You will be able to discuss how to use the PowerPivot features to create new formulas.

Registration

Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart