Building data marts in an agile manner often means that iterative enhancements will be deployed. Each deployment is aligned with a set of requirements which may require that the previously deployed data mart be altered to meet the new design & functionality. LeapFrogBI automates the tasks required to compare the deployed schema to the current […]
Monthly Archives: October 2014
A resilient data mart should include a consolidated view of all source system records collected. This is the role of the persistent stage area (PSA) component. PSA provides a dependable source for all downstream components designed to support agile development processes.
Are you ready to start collecting data? Stage components move data from a source system to controlled destination. In this course you will learn how to create a source system profile and incrementally extract source records using stage components.
Connection components define connection details for each project lifecycle. All other components reference connection components to define their source and destination. LeapFrogBI manages the creation of all required objects based on these definitions.
After collecting requirements and creating a target data model, it is time to create a source to target map known as an ETL Data Flow Diagram (DFD).Â This course bothÂ describes the role of a DFD and demonstrates the creation of a simple DFD.
Defining a desired data mart structure prior to beginning development is key to success. Data models are the blueprint of data mart development. This course demonstrates the creation of a simple data model while describing the role it serves.
New to LeapFrogBI? This is a great place to start. This course provides a high level development workflow overview. The concepts covered provide a foundation for all development tasks.
LeapFrogBI projects are containers for components which are the building blocks used to create and maintain data marts. Account administrators create projects and define project properties. After being granted project access, account users are able to develop or browse project components. This course steps through the project creation process.
Creating and configuring a LeapFrogBI account is simple. Each account is maintained by one or more administrators who can invite users to join the account. This short course covers account administration and user management.
We have all seen the job postings. “Immediate hire… ETL developer with 10 years’ experience.” Regardless of fast changing technologies there will be a need for data integration for the foreseeable future. Even the largest of big data repositories can’t automatically integrate data; not yet. Having all of your data in a repository that is […]