Agile Data Mart Development Platform
|
|
|
LeapFrogBI greatly reduces the time & resources required to transform data from disparate systems into data marts capable of supporting
reliable cross functional analysis. Best practices are built into the platform
which provides a simple interface for designing extraction, transformation, and
load (ETL) components. By working at a high level organizations can achieve agile processes while maintaining unhindered
customization abilities to meet unique needs.
|
Why Build A Data Mart?
| |
MP4 format | Ogg format | WebM format | YouTube
|
Data marts provide organizations with information needed to make informed decisions related to a focused subject area. Often a single line of business’s data will be contained in a data mart. By combining multiple data marts while maintaining “conformed dimensions” (Ralph Kimball) a data warehouse is created. Business intelligence reporting tools consume data from a data mart or data warehouse.
|
5 Minute Product Tour
| |
MP4 format | Ogg format | WebM format | YouTube
|
LeapFrogBI creates SQL Server data marts by generating SQL Server Integration Services packages which, when executed, will build and maintain all required databases, schemas, tables, and views. Developers use LeapFrogBI to record metadata which defines a target data model (star schema). Repetitive tasks are eliminated and common tasks are streamlined enabling agile data warehouse development processes.
|
|
|
|
|
|
|
|
|
|
|
|
LeapFrogBI News
|
POC Quick and Easy
|
|
Posted: 2013-06-10
|
|
PSA has a vital role to play. Without it we are left without a persistent consolidation area making agile data warehousing quite difficult. However, there are situations when we just want to build a quick POC. In such cases you can now go straight from Stage to Transform without consolidating first.
|
|
Agile Deployment Process
|
|
Posted: 2013-05-08
|
|
Agile development equates to frequent improvement & deployment. Deploying a LeapFrogBI project is as simple as executing a single SSIS deployment package. The deployment package will create configurations, create execution jobs, and alter the deployed schema if required. When you are ready to load your data warehouse simply start a SQL Agent job!
|
|
Automated Load Status Notifications
|
|
Posted: 2013-04-25
|
|
Monitoring a data integration process can be a time consuming task. With the new automated notification system email notifications can be sent to alert administrators of load events. A flexible configuration definition and one click deployment makes setup a cinch.
|
|
Automated Precedence Solution
|
|
Posted: 2013-04-20
|
|
The precedence solution which controls the execution order of project components is now automated! Simply provide deployment configuration information via the new precedence page, build, and deploy. All required objects (table, store procedure, worker jobs, poll job, and reset job) will be created automatically.
|
|
Graphs Added to Component Details
|
|
Posted: 2013-04-06
|
|
User feedback on the new interactive graph feature has been extremely positive. By popular demand, interactive graphs are now also available in component details! Also, the component selection console has been added making it extremely easily to navigate between components without exiting the details context.
|
|
Interactive Graph Visualizations
|
|
Posted: 2013-02-21
|
|
ETL often get so complex it is difficult to grasps all of the steps & relationships. LeapFrogBI will now autogenetic interactive component graph feature. You can easily view your project data flow and dimensional model at the click a button. Never get lost in your ETL again!
|
|
Simplified Navigation
|
|
Posted: 2013-02-06
|
|
Navigating your LeapFrogBI projects and components has been further simplified. After logging into your account and clicking on the “Project” button, the main navigation menu will be focused on project shortcuts. Toggling between the application and marketing site is always just a click away.
|
|
Automated Change Management
|
|
Posted: 2013-01-28
|
|
Building a data mart in an agile manner often means that many incremental enhancements are deployed over time. These enhancements result in schema changes to the already deployed data mart. With this release LeapFrogBI automates the process of validating & updating all deployed objects. Agile data warehousing just got even easier!
|
|
|