A recent survey conducted by CrowdFlower and summarized on Forbes found data scientists spend most of their time massaging rather than modeling or mining data for insights. It seems 79% of their time is spent either accessing or preparing data, leaving only 21% for everything else. Far from being a new problem, this same issue has […]
The ”data lake”, a catchy new buzzword in analytics circles, has many people wondering if they still need a data warehouse. You may have heard that you can run analysis directly against the data lake, and that’s true. This quickly leads to the question, why build a data warehouse when you can have a data […]
What is a dimensional model? What is a data warehouse? This video introduces dimensional modeling while setting the stage for the series of dimensional modeling training videos to follow.
Components are typically unique and apply only to a particular unit of work. The component’s source contains a unique set of outputs and the component exposes a transformed set of output. However, there are some cases where a component can be applied to numerous data flows with only minor differences. Consider a data warehousing effort […]
A resilient ETL process deals with data quality issues without causing a process failure while also meeting business requirements. One issue that should be anticipated is the early arriving fact (aka late arriving dimension) situation. As the name implies an early arriving fact is a record that is bound for a fact table which references […]
This quick tip video demonstrates how to create a new LeapFrogBI project. http://t.co/QG9icobhWw
When using several of the LeapFrogBI component types, configuration information is stored in Excel. This architecture is used in cases where it is not feasible to upload or input data into a web browser efficiently. Examples include; multi file stage, and rest API collection. Excel workbooks include the option to automatically “Calculate Workbook” when the […]
Users can now view a visual representation of functional constraints via the Precedence Graph option.
At times it is useful to retrace your navigation steps within a project. Now you can.
Trim both sides of a string in one step using the new Left Trim & Right Trim combined expression type.
Custom Connection Attributes This new feature adds a connection attributes dialog to connection string definitions enabling users to define custom attributes at design time. Faster Access to Generated Code Users can now view generated code, download a build (save or execute), view build status, and refresh generated code (build) directly from the component detail page. Can it get any easier?