From the course: Introduction to Business Analytics (2020)

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Data management tools

Data management tools

From the course: Introduction to Business Analytics (2020)

Start my 1-month free trial

Data management tools

- [Instructor] Whether you own a small mom and pop's business, or you run a large multinational corporation, your organization needs to manage data. In this video, I'm going to outline some common tools that can help you get this job done. The most commonly known data management tool is Excel. Microsoft Excel is a spreadsheet tool that features calculations, graphing tools, pivot tables, and a macro programming language called Visual Basic for Application. This tool is extremely versatile. You can use a data visualization tool like Tableau to not only visualize trends in your Excel spreadsheets, but Tableau can help you join and merge multiple Excel files together. I've used an Excel plus Tableau stack to build out a basic database and reporting system for my medium to small sized clients. As your organization continues to grow though, adding more departments, and thus producing more complex data, you'll probably need to…

Contents