Build a Modern Data Warehouse from disparate sources with Apache Spark and Power BI
Oscar Garcia outlines that a data warehouse (DW) is a core component of business intelligence and a central data repository for different sources. This poses many challenges as the schema definition for those sources may be completely different from one another.
In this presentation, we discuss how to create a data warehouse model that can support data from multiple systems. Mr. Garcia shows how to build a dimensional model which can enable us to import the data with different shapes into a data warehouse. We then create processes to transform and load the data using Apache Spark. We finally use Power BI to visualize the data from our data warehouse and Spark.
- Learning Objectives:
* Challenges when using disparate data sources (different models)
* Define a common model to support the different model shapes (Star Schema)
* Apache Spark Overview
* Strategy for loading the different data-sets into the common model
* Data analysis and visualization with Power BI
Oscar Garcia is a Principal System Architect, Company Founder, Microsoft MVP and certified solutions engineer with many years of experience building solutions using .Net framework and multiple open source frameworks. Currently, he specializes in building cloud solutions using technologies like Azure, AWS data platforms. He enjoys sharing his technical experiences by maintaining a blog and delivering presentations. You can follow Oscar on Twitter via @ozkary or visiting his blog at ozkary.com.
- Date & Time:
Thursday - September 26,[masked]:30 pm: Networking
7:00 pm: Presentation
8:15 pm : Networking
8:30 pm: Conclusion
Nova Southeastern University - Davie Campus
Carl DeSantis Building
3301 College Avenue
Davie, Florida 33314
Room #: 2101 - 2102
. FROM I-95 (North or South)
or Florida's Turnpike (North or South)
. Take West on I-595 Exit
. Take South on University Drive Exit
. Take East (Left) on SW 30th Street (Traffic Light)
. Turn Right Ray Ferrero, Jr. Blvd
. The Carl DeSantis Building is on the left
* The Parking Garage is on the right
* Please do not park on the first floor. See parking meter for instructions.