From the course: Introduction to Business Analytics
Unlock this course with a free trial
Join today to access over 24,200 courses taught by industry experts.
Data management tools
From the course: Introduction to Business Analytics
Data management tools
- Whether you own a small mom-and-pops 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 Applications. This tool is extremely versatile. You can use a data visualization tool like Tableau to not only visualize the trends in your Excel spreadsheet. Tableau can also 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 a small to medium-size organization. As your organization continues to grow, adding more departments and thus producing more complex data, you'll need to invest in a relational…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.