Ta spletna stran hrani piškotke, da bi vam zagotovili boljšo uporabniško izkušnjo in popolno funkcionalnost te strani.

Analitične piškotke uporabljamo s storitvijo Google Analytics, samo z vašo privolitvijo. Sprejemam Zavrnitev Več informacij
Pojdi na vsebino
Arhiv predavanj

Automated BI solution With Excel in 60 minutes

  • NTK 2018
  • Stopnja 300
  • Datum četrtek
    24. maj 2018     10:15

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, 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.

Gašper Kamenšek

Excel Olympics

Gašper Kamenšek is an Excel MVP and a self-proclaimed BI enthusiast. In his work as Excel Trainer, he combines two great passions of his, love for teaching and love for Excel. His determination to spread knowledge in Excel also made him start an Excel blog in May of 2014. It’s called Excel Unplugged and can be found at http://excelunplugged.com.