Excel has gone far beyond being just a Spreadsheet. The Power Query (Get & Transform) and Power Pivot (Data Model) capabilities have made Excel a tool for modern Data Scientists. In this session, we will build a Data model getting data with Power Query from various sources including Excel Workbooks, Azure SQL Server and Web sites. After that, we will Transform data and load it into Power Pivot. In the end, we will end up with a full blown automated BI solution that no Data Scientist would frown upon. The session will be 95% DEMO!

Invitation

I would also like to invite you to my second session of the NT Conference called Power BI (The Circle Is Complete) . It should give you a glimpse into the future 🙂 See you there!