Harnessing Power BI Buttons for Interactive Insights
In the following example, users can switch between a line chart displaying Sales by Month and a bar chart for Sales by Region by clicking a button: This interactive feature was developed in Power BI. The same functionality can be accomplished in Tableau by combining techniques such as sheet-swapping, show/hide states, and parameter actions (along […]
Business Intelligence System Maintenance
An issue and an opportunity for nearly every existing business intelligence system is keeping it running well and minimizing costs. Cloud-based software makes it easy to spin up a data warehouse or a data lake, use data transformation tools, create data science studies and publish dashboard environments. Monitoring these systems is crucial for ensuring […]
Change Management for Improved Profits
Business intelligence software which includes databases, data transformation tools and software for searching and presenting interactive reports, as dashboards have been around for 25 years. In the last ten years, these tools have become easier to use and more able to deal with very large data sets. Cloud-based software has reduced the initial cost […]
What Is Data Governance?
Often, discussions about data governance begin and end with security. Preventing unauthorized access or the loss of proprietary data is crucial. Data governance also ensures that your data systems comply with regulatory requirements and protect privacy. You are undoubtedly aware of the horror stories regarding data breaches and extortion. Keeping proprietary data safe and secure […]
An Introduction to Snowflake’s Marketplace
This article intends to provide a brief overview of what all the talk about Snowflake Native Apps Marketplace is about, how organizations can utilize the space to monetize their offerings, and how consumers can benefit from these third-party off-the-shelf applications, ending with detailed instructions to help new users navigate to and around the Native Apps […]
Planning a Business Intelligence System
Selecting business intelligence software and planning a rollout is a significant undertaking. The real work should begin well before you start selecting software. You must comprehensively assess your entire organization’s information needs, wants and data workflows. Building a Strategic Vision Roadmap We call these planning sessions Strategic Vision Roadmaps (SVR). InterWorks has a well-developed, fixed-cost […]
Building a Data Culture Through Effective Planning, Governance and Measurement
Executives understand the value of high-quality, timely information. When asked why they invested in business intelligence software, they can cite examples that explain how their investments paid off. Most feel the paybacks achieved justify their investments, but they also believe that the adoption of the tools has not been as deep or wide as they […]
An Intern’s First Visual Storytelling Project in Tableau
This article reflects on my attempt at transforming a previously created Tableau dashboard. This transformation was greatly influenced by the insights gained from the excellent two-week Tableau data visualization training provided to me as a BI intern at InterWorks. Most humans are visual creatures. We consume knowledge better when it is presented in a visually […]
InterWorks Causes: Special Olympics Oklahoma
As I’ve touched on in prior posts, being involved with important causes in our local communities is one of the things that makes InterWorks a special place to work for. There are plenty of company-organized opportunities lined up throughout the year, giving each person a chance to participate as time allows. I am especially passionate […]
Power BI DAX Iterator Functions Guide
DAX Iterator functions are a subset family of aggregator functions used to iterate over a table of rows. First, they evaluate an expression for each row in a table. Then they apply some form of aggregation to the row-level results of the first expression calculated for each row. You can imagine iterator functions as adding […]