Data Warehousing for Business Intelligence

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You’ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience

• Learn structured data modeling basics and gain practical SQL coding experience
• Develop an in-depth understanding of data warehouse design
• Perform data manipulation tasks
• Build a basic data warehouse in a final capstone project
• Create dashboards for data analysis

• Prior hands-on experience with core concepts
• Comfort applying main tools or methods independently