Transforming data monsters using Power Query

Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations.

With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data.

Transcript

1. Transforming data monsters using Power Query
2. About Me • My name is Ifeanyi Benny Iheagwara • Data and Business Intelligence Analyst at UrBizEdge • Technical Writer and Content creator • Open-source Contributor • Co-Community manager ◦ Microsoft Excel and Data Analysis Learning Community Lagos ◦ Power BI Learning Community Lagos ◦ Financial Modeling and Valuation Learning Community Lagos Benny Ifeanyi Iheagwara @Bennykillua
3. Power Query ETL Process Demo: Do-You-Even-Lift Demo: Dirty Data Samples Q & A Data Monster and Power Query Agenda
4. Dirty data Raw and unorganized Data Monster • Missing key elements • Extra characters • Poorly compiled and formatted • Poor data entries • Duplicates or mis-spelling • Data type error • Invalid data
5. • Data cleaning and transformation engine room. • Extract, transform, and load (ETL) Application. • Connect to various data source Power Query
6. • Excel and Power BI Power Query Desktop Power Query Online • Power BI dataflows, Microsoft Power Platform dataflows, Azure Data Factory wrangling dataflows
7. Why I Love Power Query 💚 User-friendly UI Ribbons, menus, buttons, and other interactive components Low code/No-code M Engine Creates the M code automatically Transformation Engine Various connectors and pre built transformation functions (over 350) Automation data cleaning process And much more!
9. Demo sessions Do You Even Lift.csv Badly Structured Sales Data 1 Link Link M Is for (Data) Monkey by Ken Puls & Miguel Escobar
10. Thank you!