DECISION 617 - Information Management

Course Description

In the last few years, self-service business intelligence (BI) tools have expanded the power of Excel. Using BI tools, an end user can effectively glean insights from data independently of the services of an IT group, by writing their own queries, gathering data from multiple sources, creating visualizations, and generating reports and dashboards.

Information Management is designed for the student who anticipates the need to collect, process, and analyze large quantities of data and to effectively organize and present insights gained. The course focuses on PC-based tools and their growing capabilities in combining and working with large data sets from many sources. Information Management is organized around data extraction, transformation, and load (ETL) operations as well as small system building, visualization, and effective presentation.

Starting with the bedrock concept of structured data, we review data management and manipulation inside Excel, explore Excel's Pivot Table and Excel automation, and review critical relational database concepts. We progress to working with the new set of Excel tools that form Microsoft's "self-service BI suite": Power Pivot, Power View, Power Query, and Power Map. Finally, we compare and contrast data management and visualization in Excel with the capabilities of one of the most popular BI desktop tools today, Tableau Desktop.

Learning in this course is primarily hands-on, with the student completing practical tasks and projects that illustrate the features and functions of Excel and Tableau software. There are no prerequisites for this course beyond familiarity with Excel.