Introduction to Power Query

Testing the SSIS package

Add and Configure the OLE DB Destination

Add and configure Lookup for DateKey Transformation

Add and configure lookup transformations

Add and configure the flat file source

Add a data flow task to package

Add and Configure OLE DB Connection manager

Remapping Column Data Types

Add and configure a Flat file connection manager

Constructor Property

Dynamic Nature of Objects

Constructor Functions

Factory Functions

Basics

Exercise - Prime Numbers

Stacked Column Chart (Part 2)

Stacked Column Chart (Part 3)

Use of Funnel Charts

Use of Line & Combo Charts

Use of Other Financial Functions

Merge Query and Un-Pivot in Power Query

Setting up Power Pivot

Transforming Data in Power Query

Tested: The Best Meal Delivery Services for Easy Planning

Former Aide Claims She Was Asked to Make a ‘Hit List’ For Trump