From Excel to Dataiku

If you already use Excel, you will find that you can do perform the same operations and analytics in Dataiku, while also making the most of its big data capabilities! This guide leads you through some core concepts and capabilities of working in a spreadsheet, and how they’re accomplished in Dataiku.

Tip

Excel users new to Dataiku may also want to check out the quick start tutorial geared to users with an Excel background.

Tutorials

• Tutorial | Relative referencing in Dataiku formulas

How-tos

• How-to | Work with editable datasets
• How-to | Import an Excel workbook

References

• Reference | Data cleaning
• Reference | Using formulas
• Reference | Working with dates
• Reference | Removing duplicates
• Reference | Filtering rows
• Reference | Sampling rows
• Reference | Split a dataset
• Reference | Append datasets
• Reference | Joining datasets
• Reference | Aggregate and pivot
• Reference | Sorting values
• Reference | Top values