Calculated table joins are used to couple two or more tables of data. Common examples include CROSSJOIN, UNION, EXCEPT and INTERSECT. Common Use Cases for Calculated Table Joins in Power BI Blending or combining data across multiple tables. Creating advanced calculations like new vs. returning users or repeat purchase behavior. Querying tables to troubleshoot errors […]
Data + Intelligence
Show Last N Month Data using single Date Slicer & What if Parameter in Power BI
Have you ever had a scenario where you need to Display the last 6 month or 4 month or N months of data just by selecting a single date dimension in slicer, sounds difficult“? Let’s me show you step by step how to display last N months of data just by selecting single date dimension […]
Perficient Welcomes a New Data Solutions Alliance Manager!
Meet Our Newest Team Member Kyla Faust Our Partner Alliance team is growing, and we’re excited to introduce the newest member, Kyla Faust! With experience in sales and partnerships/alliances, Kyla is using her knowledge and skills to build relationships with her partners here at Perficient. This will result in powerful partnerships to ultimately work better […]
Filters and Types of Filtering in Power BI
Power BI filters are useful tools for organizing data, visualizing and comparing your data visualizations, and creating reports. They are utilized to sort data according to a chosen condition. Filter Types : Visual Level Filter Page Level Filter Report Level Filter Drill Through Filter On the right side of the dashboard, locate the Filter Pane. […]
Data Functions in TIBCO Spotfire
Data Functions in TIBCO Spotfire Data Functions in TIBCO Spotfire allow people to create scripts based on their custom logic for transforming data, adding features to a visualization, establishing connections to the database, and so on. It maps the input to the output, specifying what field/value to use and which variable to assign it to. […]
Relationship Functions in Power BI
Relationship functions in Power BI allow you to access fields within DAX measures or calculated columns through either physical or virtual relationships between tables. Common Use Cases for Relationship Functions in Power BI Defining calculated columns or measures using fields from related tables. Handling relationships between calendars and multiple date fields (transaction date, stock date, due […]
Implementation of a Data Governance Program in an Organization
Data is the biggest asset of every organization as it drives the business, so it is very important to implement data governance correctly to avoid making wrong decisions that will pull an organization down, with fines, with a lot of frustrations, and with wrong business decisions. Data Governance defines rules on how the data should […]
QA Test Management using Xray Tool
Xray is the leading Quality Assurance and Test Management Jira plugin, which helps companies in effective and efficient testing. It is the best test management tool that covers the entire testing life cycle: test planning, test specification, test organization, test execution and test reporting. Before diving deep into Xray, we will first see Test Management […]
July 1, 2023: End of Universal Analytics and Beginning of Google Analytics 4
Why Migrating to Google Analytics 4 (GA4) Should be a Priority “Often, when you think you’re at the end of something, you’re at the beginning of something else.” Fred Rogers There has already been a lot of buzz and panic around Google Analytics 4, but we’d like to offer you the highlights of what this […]
Automate the Office of Finance with Corporate Performance Management
Financial leaders have access to a vast amount of data to help make business decisions that grow their organization. Data is one of the most valuable and powerful tools in a leader’s arsenal. However, many leaders find that they cannot trust their data due to a variety of reasons, including: Multiple legacy systems, including multiple […]
ChatGPT is the most useful tool in the world
If you have not heard of ChatGPT yet, I highly recommend you check it out. And if you want me to tell you, how I about I just show you? Hey GPT, how would you explain yourself to a consulting agency in 4 sentences, focusing on how you could add value to technical and business […]
Star vs Snowflake Schema – Which To Use When & Where
Introduction People and organizations constantly produce a lot of data. Generally, we want to store generated data to access it later. Data storing should be efficient in all aspects, including speed, cost, reliability, security, etc. That’s why different approaches to data storage exist. One of the most popular approaches is a data warehouse. Data warehouses […]