All times are USA Eastern Time Zone.

Jackie Kiadii, MCT

How Power BI Solves Excel Data Headaches
10:00 am – 11:00 am
Level: Beginner – Intermediate

75% of a Data Analyst’s time is not spent on visualization. It’s spent organizing and cleaning data. If you’ve had to clean up your data in Excel, you know there’s a lot involved. Multiple functions (VLOOKUP, LEFT, RIGHT, MID), Text-to-columns, pasting values, and much more.
With the Power Query component of Power BI, you are able to automate your data cleanup without having to use code. You can collect data from multiple sources, transform it, and prepare it for visualizations.
In this session, you’ll learn how to replace time-consuming Excel functions with Power BI Power Query.

About Jackie:

Jackie Kiadii is Founder of Phoenix Computer Consultants, LLC, an IT firm that specializes in providing customized Microsoft Office training and consulting to solve business challenges. Since 2001, her firm has served thousands of business professionals in the United States, Africa and Asia, including employees of the following organizations: City of Atlanta, US Fish and Wildlife Service, Emory University, Sigvaris, Airbus Americas, and The Coca-Cola Company. Jackie is a Microsoft Certified Trainer.

Jennifer Lobo, MCT, MCAS

Harness the POWER of Power BI
11:00 am – 12:00 pm
Level: Beginner – Intermediate

From ETL – Extract Transform and Load to powerful visualizations, let’s explore what Power BI can do – In Excel and in Power BI Desktop. This seminar is full of tips and tricks for new and existing Power BI users.

• Extracting data from different data sources
• Transforming your data to help you analyze it – using Power Query
• Load your data into Power BI Desktop and Power BI Excel and create visuals to present your data

LeAndra Jordan, MBA, MCT
Power BI Collaboration
12:00 pm – 1:00 pm

Level: Beginner – Intermediate
Now that you’ve created dashboards and reports, let’s collaborate with coworkers to create meaningful reports and dashboards in a workspace. You can easily communicate within the Power Bi application and embed interactive reports in Microsoft Teams channels and chats. In this session, LeAndra looks at collaboration and integration within the Power Bi and Microsoft Teams integration.

About LeAndra:

LeAndra Jordan is the Owner at DreVon Business Solutions LLC. As a progressive Technology Consultant and Tech Speaker, she is part of an elite group of 21st-century global thinkers who continues to raise the bar of technology. LeAndra maintains a growing list of clients in both private and public sectors, supporting them with their end-user adoption rollouts and change management efforts. Today, LeAndra serves as a charter member for the Microsoft OneDrive Expert program (MODE), Microsoft Certified Trainer (MCT) program, and the host of the newly introduced YouTube-cast She’s Soul Techie(tm).