Why Are My Power BI Locations Mapping My Data Incorrectly?
It can be a very confusing or frustrating experience whenever a technical tool doesn’t do what you want it to do, or even what it should be doing using common sense! I recently had some issues with the mapping visualization feature in Power BI and was able to solve the problem, so I want to […]
Maturing Analytics: User Adoption and Data Delivery
Welcome back to our journey in maturing analytics. In Part 1, we looked at our job to be done and why it wasn’t building dashboards. In Part 2, we dove into the details of how dashboards can be a mismatch to users’ needs. Now, we’ll tackle how you might be building the right thing, but […]
Introduction to Snowflake File Formats
File formats are database objects used by snowflake to ingest flat files. Consider file formats as your way of giving snowflake information about the file so it knows how to ingest those flat files in an optimal fashion. You specify the type of file along with a bunch of optional extra information such as (but […]
A Guide to Power BI Desktop for Tableau Developers
You may have the job title of data analyst, or you may work in HR or sales. Regardless, the versatility of modern data visualization tools allows everyone access to self-serve analytics. If you already have Tableau experience but are interested in Power BI, this is the guide for you! For steps on how to create […]
Tips from Assist: Tableau Map Layers Disappearing
Customer Question: “When I’m using filters on my map visualization, if the filter returns null values for any state, that state disappears from the map. How can I make a map that will show state outlines even when there’s no data?” There are, as with many things in Tableau, several ways to solve this problem, […]
Creating a Data Governance Framework That Drives User Adoption
In this six-part series, we’ve discussed the adoption history, planning a BI Rollout, decentralizing ownership of data workflows and operational definitions of key terms like data governance, data lineage and data provenance. We discussed change management and ideas for spreading data literacy throughout your company in every team and for every user persona. Then, we […]
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 […]
