Ben Brumm put together a super nice list of database key types along with easy to understand definitions. Bookmark the linked post below. It will come in handy! Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)
Run a search on “HIPAA compliant reporting” and Google will ask, “Did you mean HIPAA compliance reporting”? One obvious reason for this is the obvious importance of compliance and the immense amount of content available on the topic. But a less obvious reason is the glaring lack of HIPAA-compliant reporting solutions available to companies in […]
Need to execute a batch file? Visual Basic Script? EXE? You are in luck. Use the new s9502 (Execute Process) stage component to execute any process by generating an SSIS package which includes an “Execute Process Task”. Provide a path to the executable and input argument/s. LeapFrogBI will call the executable at the exact point […]
Your choice of data solution helps define your overall solution architecture as well as the specific needs that must be filled by data wrangling and visualization tools. Analytics has always been difficult, and as data sources expand and proliferate the challenge grows. Despite advancements in technology, including a broad range of available databases, data preparation […]
Business intelligence is a funny thing. The vast majority of companies engage in business intelligence in one form or another, yet if you ask 100 people what it is, 99 can’t tell you. As a provider of cloud business intelligence and BI consulting I figure LeapFrogBI has some responsibility to educate folks. So here […]
A Recipe for Transforming Data Into Insights that Improve Business Outcomes The failure rate for business intelligence projects is high. Exactly how high is up for debate, but high enough to cause discomfort. This stems from the fact that most companies treat BI like a project to be undertaken then forgotten. But much like sales […]
Simple as that. LeapFrogBI Data Warehouse Automation now supports SQL Server 2017. Existing clients can upgrade their projects without writing a single line of code using the “Set Target Project” option in the admin panel. As always, LeapFrogBI projects are both forward and backwards compatible. Enjoy!
Does race or gender impact sentencing lengths? To what extent? The United States Sentencing Commission (USSC) published a report which explores the correlation between demographic factors and federal sentence lengths. In this post, we review the findings in depth, look for bias in referencing articles, and draw our own conclusions. Data-driven decision making in action.
For years companies have been buying reporting software, such as Cognos or Business Objects, hoping to solve their reporting challenges with a single purchase. Today companies are buying newer tools like Power BI and Tableau with similar expectations. Despite the considerable power of these tools, most users are disappointed when they realize that software alone […]
Reporting tools have become pretty good, and companies buy them with the expectation that doing so will solve their reporting challenges. But is this really the case? Are they really up to the job? This is a conversation we have frequently with clients and we hope it may benefit you. You can learn more about […]
Design patterns greatly speed development. The DP3000 & DP3100 design patterns create a data flow which tracks the current version of records in PSA based on a selected key field. The result is a new field in PSA called isCurrent by default which identifies the current PSA record with a value equal to 1.At times […]
Many organizations have built data warehouses successfully, and some have failed. There’s no reason at all for you to learn the hard way. In this video I’m going to tell you what I believe are the top three reasons for data warehouse failure. Stick around. Reason number one for data warehouse failure; not implementing a […]