Skip to main content
Collab365 Excel and Power BI Summit 2019
The Power Query Editor: Having your cake and eating it too!
  • Info
  • Agenda
  • Lobby
  • Settings

Getting your registration status....

Useful Resources

  • 👉 View all of the sessions in the Summit Bundle.
  • 👉 To watch the training, click ‘unlock’ on the video and enter the email address you used to purchase with.
  • 👉 Not receiving our emails? Check your junk and promo folders.
  • 👉 Need help? Contact us at [email protected]

The Power Query Editor: Having your cake and eating it too!

  • Details
  • Resources
You: a skilled, experienced analyst who is used to solving problems with Excel, but wants to explore what Power BI has to offer. This webinar: A conversation where we examine how to use the Power Query Editor to prepare data for use in both Power BI and Power Pivot (within Excel 2016). You have spent many years developing your expertise in Excel, and along comes Power BI and you wonder "do I have to quit using Excel and switch over to Power BI?" Absolutely not! You can continue to use Excel and take the dive into Power BI, a task made easier because there is one tool that both have in common: the Power Query Editor (PQE).  You can use the PQE to prepare data to use in Power Pivot within Excel 2016, where you can create pivot tables using multiple worksheets. You can then load the same data into Power BI, and create visual reports with it. Or publish it to the Power BI Service so others can use the data that you have prepped. If you want to follow along during the webinar you will need Excel 2016, the Power BI Desktop, and an account in the Power BI Service (you can use "My Workspace" if you only have a free account). Experience within Excel is assumed, but no experience with Power BI is required. Join us to find out why your mother was wrong when she said you can't have your cake and eat it too!

Speaker information:

Jessica Jolly

I am a Microsoft Certified Trainer with an M.C.S.E in Data Management and Analytics. My practice focuses on Power BI. Before starting my own business, ALT-Enter, LLC, I worked for Unilever, a global consumer products company, in a variety of managerial roles. Because my work history includes 27 years in a global organization, I bring to my practice a 'lived experience' of trying to communicate and share knowledge across large and complex organization. Teaching people how to create visuals is the tip of the iceberg. Talking to them about how to adopt business intelligence tools and adapt current information sharing practices is much more important. An example of my approach is that when I train I spend as much time talking about the 'workflow' and 'publication' concepts as I do explaining specific skills and techniques. My logic is that a participant can always look up the steps required to achieve a technical aim. Much harder is figuring out what data to use and what reports and dashboards to publish. I moved to Chicago to attend the University of Chicago. I graduated with a B.A. in American History about which I am still passionate. When I am not training, I volunteer at my local public library, knit (a refuge from all of the technology!), read about the Civil War, or walk my two terriers. I blog at www.altentertraining.com, tweet very occasionally at @JBJ2110. You can connect with me on Facebook at https://www.facebook.com/ALTEnter/ or on LinkedIn at https://www.linkedin.com/in/jessicabjolly/.

Session Resources
No resources available.
Name

The Power Query Editor: Having your cake and eating it too!

You: a skilled, experienced analyst who is used to solving problems with Excel, but wants to explore what Power BI has to offer. This webinar: A conversation where we examine how to use the Power Query Editor to prepare data for use in both Power BI and Power Pivot (within Excel 2016). You have spent many years developing your expertise in Excel, and along comes Power BI and you wonder "do I have to quit using Excel and switch over to Power BI?" Absolutely not! You can continue to use Excel and take the dive into Power BI, a task made easier because there is one tool that both have in common: the Power Query Editor (PQE).  You can use the PQE to prepare data to use in Power Pivot within Excel 2016, where you can create pivot tables using multiple worksheets. You can then load the same data into Power BI, and create visual reports with it. Or publish it to the Power BI Service so others can use the data that you have prepped. If you want to follow along during the webinar you will need Excel 2016, the Power BI Desktop, and an account in the Power BI Service (you can use "My Workspace" if you only have a free account). Experience within Excel is assumed, but no experience with Power BI is required. Join us to find out why your mother was wrong when she said you can't have your cake and eat it too!

Speaker information:

Jessica Jolly

I am a Microsoft Certified Trainer with an M.C.S.E in Data Management and Analytics. My practice focuses on Power BI. Before starting my own business, ALT-Enter, LLC, I worked for Unilever, a global consumer products company, in a variety of managerial roles. Because my work history includes 27 years in a global organization, I bring to my practice a 'lived experience' of trying to communicate and share knowledge across large and complex organization. Teaching people how to create visuals is the tip of the iceberg. Talking to them about how to adopt business intelligence tools and adapt current information sharing practices is much more important. An example of my approach is that when I train I spend as much time talking about the 'workflow' and 'publication' concepts as I do explaining specific skills and techniques. My logic is that a participant can always look up the steps required to achieve a technical aim. Much harder is figuring out what data to use and what reports and dashboards to publish. I moved to Chicago to attend the University of Chicago. I graduated with a B.A. in American History about which I am still passionate. When I am not training, I volunteer at my local public library, knit (a refuge from all of the technology!), read about the Civil War, or walk my two terriers. I blog at www.altentertraining.com, tweet very occasionally at @JBJ2110. You can connect with me on Facebook at https://www.facebook.com/ALTEnter/ or on LinkedIn at https://www.linkedin.com/in/jessicabjolly/.

Loading...

I have a Pass

Let us know the email you used to purchase the Pass and we'll email you an access code to watch the sessions.

Please enter the code sent to your email

Request new code

I want a Pass

If you would like to access all of the sessions, check out the latest offer.

Our offers are time limited so may be gone tomorrow!