Week 1: Importing Data (import)
Within a company, data is often stored in many different places, from a database to an ERP system to an attachment in an email. Sometimes you may even want to get data from the web, like information on the stock market or trending topics on Twitter. In this week we will show you how to get data ‘live’ into your spreadsheet. Never copy-paste again.
Note: This week includes the use of a little VBA, and the Expector plugin.
Week 2: Power Up (analysis, visualization, design)
Now that we have some feeling for the data, we want to dive into analyzing deeper. This week, we explore the power of PivotTables in more depth, by adding our own columns to PivotTables, and adding visual beauty with PivotCharts and interactive slicers.
Week 3: PivotCharts (analysis, visualization)
In week 3, we will introduce spark lines and conditional formatting, to visualize the data immediately. Easy insights without the effort of making graphs.
Week 4: Decision Making (analysis)
The previous weeks concerned analyzing and visualizing existing data, but of course, we can use data to make decisions too. Week 4 talks about how to decide based on data. Predict a trend or figure out what happened when sales increase but demand would drop.
Week 5: Testing (analysis)
How to make sure your data is correct? We will use TU Delft plugin Expector to validate input and assumptions, so quality is guaranteed!
Week 6: Dashboard (Design)
Now we know different types of visualization, we can put it all together in a beautiful dashboard. We will create a dashboard based on real-time data of a specific domain.