We know the product release notes from the vendors can be very detailed and overwhelming. So, we have outlined the major product updates you need to know about for Q3 2023, how these updates can impact you, how they can be applied, and other major news for key technologies within the data and analytics space. We also cover the latest in data privacy regulations — keeping you informed around data governance requirements.Snowflake ↵Databricks ↵dbt ↵BigQuery ↵Looker ↵Qlik ↵Tableau ↵Power BI ↵Sigma ↵State Data Privacy Regulations↵SnowflakeQ3 2023 Product Release UpdatesHere are a few highlights of new and updated features in Snowflake (either generally available or in preview) that we think are impactful to our customers. Budgets and Snowflake Alerts: Surprises on your Snowflake bills are a thing of the past. Budgets allow for account-level monitoring and credit usage notifications for groups of specific Snowflake objects. Credit usage notifications not only notify on exceeded budgets, but also when credit usage tracks to overspend — allowing for customers to react sooner and prevent overspending. Other types of alerts beyond budgets are available as well, both for notification and for performing actions. Table and Database Level Support for Tag-based Masking Policies: Leverage tag-based masking policies on databases and schemas in Snowflake when a data type of a column matches a data type of the policy set on a tag. This promotes data security and data governance because it allows for setting tag-based policies once compared to masking policies on every column in a database or schema. Dynamic Tables: In preview as of June 2023, Dynamic Tables are the building blocks of declarative data transformation pipelines. They significantly simplify data engineering in Snowflake and provide a reliable, cost-effective, and automated way to transform your data for consumption. Instead of defining data transformation steps as a series of tasks and having to monitor dependencies and scheduling, you can simply define the end state of the transformation using dynamic tables and leave the complex pipeline management to Snowflake. They could be especially useful as a datasource for applications that require near real-time data. Access Billing Usage Statements in Snowsight: Billing usage statements are available in Snowsight. In general, we want our customers to develop a habit of checking out the Snowflake Usage tab in Snowsight to monitor consumption, drill into specific organization, account, warehouse, and query levels to troubleshoot unexpected consumption patterns that appear on billing usage statements. If you need help with this, talk to us. Extensibility Updates for User-Defined Functions (UDFs) in Python: Extend Snowflake to perform operations that are not available from built-in system defined functions. Lots of feature enhancements happened around Snowpark Python, Python UDFs, Python UDTFs, and Python Stored Procedures this quarter to increase support for extensibility. If Snowflake can’t do it out of the box, you have increased options for how to extend support for customization. Network Rules: Snowflake now allows admins to create far more granular security controls with Network Rules. Previously, the only way to restrict access was through Network Policies, which are account-level objects that can allow or block IP addresses or CIDR blocks. Now, you can also specify cloud VPC endpoints. You can also specify if these are ingress or egress, which provides even more control over how Snowflake interacts with your VPC and users. Cross Platform Snowpipe Auto-Ingest Availability: Auto ingest is now available for event messages for AWS, GCP and Azure with Snowflake instances hosted in any of the supported platforms. This allows for multi-platform collaboration and integration of data sources. This update also includes the Amazon EventBridge general availability within Snowpipe Auto-Ingest. Streamlit Native Integration: Snowflake announced its acquisition of Streamlit in 2022, but up to this point apps had to be developed outside of Snowflake, tapping into the warehouse via a Snowpark connection. Now, Streamlit is a built-in option in the selection pane in Snowsight, and apps are saved within the Snowflake instance. With a few lines of Python, a developer can immediately spin up nice visualizations without the need to use a separate BI tool. See Q2 2023 Updates for SnowflakeQ2 2023 Product Release UpdatesAI Advancements in Snowflake with NVIDIA Partnership: Snowflake has introduced two promising AI features to their product roadmap: Snowflake Copilot and Document AI.Snowflake Copilot – a “comment to SQL” feature that will automatically generate a SQL statement based on user input (ie –show me daily revenue over the last 30 days) and Snowflake’s knowledge of user data.Document AI – Will allow users to ask questions about documents stored in Snowflake and automatically pull information from those documents. Could be ideal for document scraping and converting data from pdfs into something usable.These planned features, aimed to counter competitive advances from Databricks, Microsoft, and Google, are anticipated to enhance AI workloads run by customers on Snowflake.Streamlit Integration and Containerization: Certain third-party SaaS applications can be run within a container hosted in Snowflake, enhancing data security. This positions Snowflake ahead in the data management sector, particularly with increased industry focus on data privacy and security. For customers, this translates to a better integrated, secure environment for app development, thus potentially consolidating the Total Cost of Ownership (TCO).Managed Iceberg Tables: With this feature, Snowflake users can now manage Iceberg table data using Snowflake’s compute resources. This allows Write operations and offers similar performance to Snowflake tables, providing a superior option to other read-only external table formats.Dynamic Tables: These offer advantages over traditional materialized views, including support for SQL syntax, incremental loading, enhanced UI support for table metrics, and dependency visualization.Snowpipe Streaming API: This API aids in supporting workloads requiring lower latency, allowing data to be loaded into Snowflake from Apache Kafka or custom Java applications.Snowflake Alerts: This feature, already being utilized by customers, allows alerts to be set up based on trigger conditions and frequencies, enabling proactive responses to data changes.A notable example of how Snowflake Alerts are being utilized: One of our clients had to monitor changes to their product setups constantly, as unanticipated modifications could impact their sales tracking and comparison capabilities. We set up Snowflake Alerts that notified them via email of any data quality issues on a daily basis, enabling them to review the changes and make any necessary corrections swiftly. This level of proactive management helps maintain data integrity and supports their business continuity efforts.Q2 2023 Other NewsSnowflake Roadshow Events: Snowflake is set to host local roadshow events this fall, offering a great opportunity for customers to explore the latest features and network with industry peers. We’ll be attending those to our closest locales like Chicago – more info to come once we see the final dates and locations announced. See Q1 2023 Updates for SnowflakeQ1 2023 Product Release UpdatesSnowpipe Streaming is now an ingestion method for the Snowflake Connector, enabling low-latency streaming data pipelines to write data directly into Snowflake from business applications, IoT devices, or event sources such as Apache KafkA.Java and Scala stored procedures now have return values in a tabular format, adding to the capabilities and ease of use for stored procedure users.General availability of error log alerts for Snowpipe and SF Tasks.OBJECT_DEPENDENCIES view has been added to Account Usage, allowing users to see dependencies of Views that are built off shares.Python Worksheets in Snowsight. When you create a worksheet, you can specify whether it’s a SQL worksheet or a Python worksheet. You can use this instead of an IDE for python-specific Snowflake jobs. Every pipeline and worksheet is housed in a single app.Previously resource monitors were usable within the UI. Now, you can get email notifications for any kind of alert and alerts can be configured to trigger when any condition is met. Alerts can check this condition on a schedule, and execute an action (i.e., send an email notification) when the condition is met. This is a quality-of-life upgrade for developers and administrators to better monitor Snowflake when not using the platform.Q1 2023 Other NewsSnowflake Summit has been announced for June 2023 – we’ll be there! Let us know if you’re planning to come.Auto Refresh notifications for External tables will be a billed action from now on.DatabricksQ3 2023 Product Release UpdatesHere are some of the standout new and enhanced features in Databricks (either generally available or in preview), particularly those we have identified as being of significant value to our customers.Databricks Assistant – AI-based programming copilot (public preview): The Databricks Assistant works as an AI-based companion pair-programmer to make you more efficient as you create notebooks, queries, and files. It can help you rapidly answer questions by generating, optimizing, completing, explaining, and fixing code and queries. This is an important advancement for how your developers can securely use AI in their day-to-day jobs to be more efficient and create better work products.Unity Catalog Updates: Unity Catalog provides feature discovery and governance. Many important updates occurred to Unity Catalog over the quarter to continue to bolster Databrick’s enterprise feature demands from customers. For example, you can now apply tags to your securable objects in Unity Catalog. Tags help you organize securable objects and simplify search and discovery of your data assets. Tags are an important way for organizations to enforce data governance principles in a practical way within data platforms generally – Databricks supporting it in Unity Catalog is a great way to standardize tagging as best-practice.Delta Lake 3.0: Delta Lake 3.0 introduces significant enhancements. The standout feature is UniForm (short for Universal Format), which addresses limitations with Delta Lake in certain ecosystems. Previously, Delta Lake had some compatibility constraints, such as with BigQuery, which exclusively supported the Apache Iceberg data lakehouse format. Now, with Delta Lake 3.0, you can set a configuration option during table creation to incorporate Apache Iceberg or Apache Hudi metadata formats into your Delta Table. This enables compatibility with sources that exclusively support these formats, like BigQuery. UniForm ensures seamless integration with any ecosystem our clients employ, allowing Databricks and Delta Lake to adapt to diverse toolsets. Delta Lake 3.0 also now includes support for Apache Spark 3.5. See Q2 2023 Updates for DatabricksQ2 2023 Product Release UpdatesDelta Sharing & Marketplace: Databricks’ enhancement to Delta Sharing, launching the “Databricks Marketplace”, serves as a notable step in data monetization and sharing. Users can now share and/or monetize datasets, notebooks, and UDF(s) with consumers outside their organizations and across Workspaces. This innovation paves the way for businesses to monetize their data assets and streamline workflows across various teams and organizations. Customers looking to capitalize on their data assets or acquire new datasets for their projects will significantly benefit from this feature.UI Overhaul: The new UI overhaul from Databricks unifies platform offerings, enabling users to access the SQL warehouse, ML Models, and orchestration workflows from a single side pane. The update improves the user experience by reducing the fragmentation of resources, streamlining navigation and accessibility. Customers using Databricks for their Data Engineering and Machine Learning workflows will experience enhanced productivity and usability, saving time and simplifying tasks.Unity Catalog (US) Updates: Databricks has empowered users with the expansion of the Unity Catalog (UC), offering new capabilities such as ‘Volumes’, enhanced data lineage, and a UI space dedicated to Data Governance tools. These updates provide users greater control and visibility of their data assets within the UC’s three-tier namespace, making it easier to manage and monitor data. Customers can better manage their data assets, improve their data governance, and streamline their Machine Learning workflows, significantly enhancing efficiency and control. See Q1 2023 Updates for DatabricksQ1 2023 Product Release UpdatesAfter the release of UNITY CATALOG, DBX is now pivoting to quality-of-life and code features for users and developers as indicated by the recent release of their extension for VS code. The extension allows users to tap into VS Code’s advanced authoring capabilities while connecting to a DBX cluster to run your code remotely. The extension will better enable source control, modularized code, and unit testing. This means:Enhanced Developer Experience: The extension enables developers to use a familiar and powerful IDE like Visual Studio Code, which can improve the development experience and productivity.Remote Code Execution: Customers can now tap into cluster options and configurations remotely to increase performance and scalability of DBX cluster even further.Best Practices for Code Quality: By encouraging best practices like source control, modularized code, refactoring, and unit testing, the Databricks extension for Visual Studio Code promotes a culture of high-quality coding standards. This feature can help organizations build reliable and maintainable code, which can lead to better data management outcomes.UI improvements to their DBX JOB and native orchestration tooling to better track lineages in a matrix layout, and ‘continuous’ jobs that further enable streaming workloads.Q1 2023 Other NewsDatabricks was announced as a key partnership within SAP Datasphere.Databricks Data and AI Summit has been announced for June 2023. We’ll be there — Let us know if you’re planning to come!dbtQ3 2023 Product Release UpdatesHere, we’ve outlined some of the most crucial new and updated features within dbt (either generally available or in preview), emphasizing those we think are poised to make a meaningful difference for our clients.dbt Mesh: dbt Mesh provides domain-level ownership with data governance seamlessly integrated, establishing a distinctive advantage by allowing organizations to easily adopt a multi-project architecture in contrast to competing solutions. This functionality enables distributed teams to break down extensive models, fostering collaboration across different units or departments and ensuring agility and interoperability.dbt Explorer: The launch of dbt Explorer in public preview presents a comprehensive view of all dbt assets, setting itself apart by prioritizing data discoverability and trust. The feature enhances resource location across multiple dbt projects, ultimately boosting user trust and efficiency in their data-related tasks.dbt Semantic Layer: Tackling an industry-wide challenge, dbt introduces its Semantic Layer to maintain consistent definitions across various analysis tools. This innovation collaborates with major partners like Tableau and Google, emphasizing the goal of uniform metric and query definitions. The outcome? Users experience a consistent, reliable data analysis environment irrespective of the tool in use. Talk to us if you’d like help to enable this feature in your current environment or plan.dbt Cloud CLI: dbt’s unveiling of the Cloud CLI in public preview offers users the flexibility to utilize their preferred development tools without being restricted to the in-browser IDE, making dbt a formidable competitor in the market. This feature enhances adaptability and efficiency for developers, allowing them to harness the power of dbt Cloud through their favored interfaces.Dedicated CI Jobs: By introducing Dedicated CI Jobs, dbt empowers users to select continuous integration for their job types, ensuring production changes won’t disrupt existing pipelines. This strategic move not only upholds best practice configurations but also keeps costs in check, ultimately benefiting organizations that prioritize robust, cost-effective data pipelines.Support for Microsoft Fabric and Azure Synapse Adapters: dbt’s new support in private preview showcases its adaptability and commitment to integrating with evolving platforms like Microsoft Fabric. While this collaboration is in its early stages, its importance is evident, marking a significant step toward comprehensive data solutions. The integration offers promise to users, hinting at a seamless data handling experience across platforms in the future.Q3 2023 Other NewsFor further insights, consider checking out Tyler from Analytics8 and Yannick from Roche’s talk at the dbt Coalesce.Check out last year’s dbt Coalesce discussion on dimensional modeling’s relevance, it continues to resonate with many on their modern data stack journey.Stay tuned for our dbt Meetup in early 2024 at our new office in Chicago, IL. Interested in presenting? We’re eager to connect!Read all the product news from dbt from Coalesce 2023 here. See Q2 2023 Updates for dbtQ2 2023 Product Release Updatesdbt-core v1.5 marks a major milestone with its focus on multi-project deployments. The most significant enhancements relate to model governance, including access controls, model contracts, and model versioning. These advancements lay the foundation for upcoming releases, enabling stateful input from multiple dbt projects. This will facilitate stateful comparisons across projects, bringing more robustness to data operations and catering to the needs of large organizations maintaining multiple dbt projects.The recently released Discovery API is a game-changer for data understanding and pipeline optimization. By providing granular insights into the data generated by jobs and the deployment process, the Discovery API enables faster data discovery, better data quality, and eases pipeline optimization. This is particularly valuable for dbt Cloud customers dealing with complex refresh use cases, as it provides comprehensive insights into the reliability of dbt projects.Q2 2023 Other NewsAnalytics8 continues to host the dbt Chicago Meetup, a forum for data professionals to network and learn advanced dbt concepts through hands-on presentations. The next meetup is scheduled for Thursday, August 10th. Keep an eye on the #local-chicago channel in dbt Slack or LinkedIn for further updates.We are speaking at Coalesce! Make sure to register for a chance to gain valuable insights and connect with fellow dbt users.Analytics8 contributed to the dbt-core open-source project. Learn more See Q1 2023 Updates for dbtQ1 2023 Product Release UpdatesWebhooks is now available in dbt Cloud, users can use webhooks to automatically trigger workflows in external tools based on a dbt Cloud job status. This allows data to be pushed to apps for real-time notifications on information regarding jobs.dbt Labs has acquired Transform, the modern data stack’s semantic layer, with an ultimate vision to make uniformly defined metrics that are globally accessible from all the tools in one’s stack. Previously, metrics have been locked into vendor-specific semantic layers. Like dbt, Transform’s MetricFlow is an open-source framework that will accelerate this vision toward an open-source, comprehensive solution. The synergies from the acquisition will result in a more flexible experience for all data teams. General availability is still expected late 2023.Q1 2023 Other NewsAnalytics8 continues to host the dbt Chicago Meetup, which offers a chance to both network with local data professionals and learn advanced dbt concepts through hands-on presentations. Our next meetup takes place on May 25, 2023 (If you’re in Chicago, be sure to register for the in-person event). Let us know if you’re planning to come! Additionally, we are always looking for presenters, so contact us if you’re interested in speaking. Finally, check out the #local-chicago channel in dbt Slack or our LinkedIn for updates.BigQueryQ3 2023 Product Release UpdatesWe have highlighted several of the latest and improved features in BigQuery (either generally available or in preview), with a focus on those we deem to be particularly impactful for our customer base.Duet AI: Duet AI, available in Google Cloud, assists in completing, generating, and explaining SQL queries. This enhances the developer experience and potentially attracts a user base that values AI integrations in their tools.BigQuery DataFrames: The new Python API, BigQuery DataFrames, allows data analysis and machine learning with partial scikit-learn and pandas compatibility. This feature aims to cater to data scientists and advanced developers by offering an integrated environment within BigQuery.Multi-Region, Data Movement, and Federation Enhancements: BigQuery’s new features for data replication, transfer, and federation across different regions and platforms address the needs of businesses with expansive operations and data across multiple regions.Data Warehouse Migration Guide Updates: BigQuery has updated migration guides for several platforms including Teradata, Hive, Netezza, and Oracle. These guides assist organizations looking to transition their operations to BigQuery from other platforms.Billing Flexibility Update BigQuery’s ‘Physical Bytes Storage Billing’ offers a potential cost-saving solution for clients with large data volumes.SQL Enhancements Enhanced SQL capabilities, especially expanded functions for JSON manipulation, aim to provide more tools and functionalities for developers. See Q2 2023 Updates for BigQueryQ2 2023 Product Release UpdatesThe BigQuery partitioning and clustering recommender is now in preview, with the potential to revolutionize cost management. It uses a table’s workload data from the past 30 days to recommend cost-saving actions, which can be accessed directly via the BigQuery UI or the recommender API. This feature can significantly reduce the time and effort spent on manual optimization, directly impacting the monthly GCP bill of our customers.Primary and foreign key table constraints have been made generally available, enabling better query optimization and documentation. These non-enforced constraints can be managed through the BigQuery API and viewed in the BigQuery console. This update is set to make BigQuery more compatible with other database systems and provide customers with enhanced understanding and control over their data relationships.While we’re excited about the potential of Dataform, there are still some limitations to be aware of. A key enhancement is needed to allow for compatibility between the regions of Dataform instances and dataset regions. Misalignments of regions between dataset and Dataform can impede the efficiency of Dataform ELT architecture design. This improved clarification can help customers avoid unexpected issues and resource waste in the project planning stage.Q2 2023 Other NewsGoogle Next conference is scheduled for August 29-31 in San Francisco. We encourage customers interested in the latest in cloud technology and services to attend.For a more comprehensive view of updates and changes, customers can refer to the BigQuery Release Notes. Regular consultation of these notes can help customers stay up to date and make the most of their BigQuery experience. See Q1 2023 Updates for BigQueryQ1 2023 Product Release UpdatesA fully managed Dataplex capability that helps users understand how data is sourced and transformed within their organization. Dataplex data lineage automatically tracks data movement across BigQuery, BigLake, Cloud Data Fusion (Preview), and Cloud Composer (Preview), eliminating operational hassles around manual curation of lineage metadata. Dataplex allows engineers to focus on one platform and serves as a one-stop-shop for lineage and data glossary.For a project that uses GCP, this can be used for governance, data tracking, and troubleshooting, as well as with DLP for sensitivity tagging — eliminating the need to buy other tools that do this and integrating them, keeping everything encapsulated in GCP.Google is ending sales of flat and flex slots in July and moving customers into Enterprise edition. Contact us if you’re impacted by this change and looking for options moving forward.Q1 2023 Other NewsGoogle Next conference will be held in San Francisco this year August 29-31. Let us know if you’re planning to attend!LookerQ3 2023 Product Release UpdatesIn this section, we’re spotlighting a handful of new and updated functionalities in Looker (either generally available or in preview), pinpointing those we believe hold substantial value for our clientele.AND/OR Filters Available in Explores: Looker’s major overhaul this quarter introduced flexibility in querying with the new filter dropdown in Explores. Users can now seamlessly create ‘OR’ conditions without the need for custom filter expression logic. This enhancement not only streamlines the Explore experience but also reflects Looker’s commitment to addressing long-standing user feedback. The immediate impact? Customers can now leverage complex filter logic directly through UI controls, ensuring uninterrupted Looker content development, even for those niche use cases requiring AND/OR filters.Granular Admin Access: Looker has expanded permissions, enabling users to manage specific parts of the platform traditionally reserved for Admins. This strategic move not only aligns Looker with standard security practices but also makes it adept at handling enterprise-level user volumes. By decentralizing responsibilities, larger Looker instances can distribute tasks like user group assignments, preventing the bottleneck of few individuals addressing all requests. The long-term vision? Further refinement of these roles in upcoming quarters.Q3 2023 Other NewsGoogle’s “Next” conference took place this quarter, offering invaluable insights in regard to both Looker and other Google Data products. Missed it? Catch the recordings while they last at https://cloud.withgoogle.com/next. See Q2 2023 Updates for LookerQ2 2023 Product Release UpdatesThis quarter, Looker phased out legacy dashboards and YAML projects, in line with customers’ transition over the past few years. The change allows Looker to redirect its resources away from maintaining these legacy features, and instead, focus on advancing the product.The Looker to Power BI Connector has now reached general availability, marking the first non-Google BI connector to achieve this status. This development represents Looker’s progress toward expanding the use of its modeling language — LookML — in other tools. Users can now explore modeled data through Power BI, enhancing the potential utility of Looker’s offering. This advancement is particularly beneficial for customers who use both Looker and Power BI, enabling them to optimize the strengths of both platforms. Users with other BI tools should stay tuned for potential integration of Looker’s features in their preferred tools. See Q1 2023 Updates for LookerQ1 2023 Product Release UpdatesAn experimental feature that has not been made generally available was released in preparation for a future with cookieless embedding. Looker is aware that users are moving toward browsers that block third-party cookies. They have created a comprehensive guide on how to implement cookieless embedding on their docs page.There were many updates to the ‘New LookML Runtime’ this quarter that intend to fix some of the inconsistencies between the old and new runtimes. Developers should see more consistent behavior as they develop in more advanced areas of Looker like liquid filters, parameters, and derived tables. Additionally, these improvements allow more teams to make the switch to the new runtime and take advantage of its benefits, even if they were reluctant in the past due to unpredictable behavior.Q1 2023 Other NewsIn early Q2, Looker Studio and Google Sheets connectors will be available outside of Google Cloud hosted instances.Looker announced the release of Looker Modeler, a standalone metrics layer and single source of truth for BI that will be available in preview in Q2 2023. Metrics can be defined and stored within Looker Modeler, and can be consumed in tools such as Connected Sheets, Looker Studio, Looker Studio Pro, Microsoft Power BI, Tableau, and ThoughtSpot. Pricing and full feature release information is forthcoming.QlikQ3 2023 Product Release UpdatesBelow is a selection of the most significant new and enhanced features within Qlik (now either generally available or in preview) that stand out in terms of their potential benefits to our users.AI & Natural Language Improvements: Qlik has unveiled several updates to its natural language insights capabilities, positioning the company as a key player of data literacy tools in the competitive landscape. These enhancements, like the improved NL Insights object and the Insight Advisor Expression Generation, allow users to gain high-level insights automatically and in plain language, reducing barriers for self-service users and accelerating development. As a direct impact on customers, these features will not only enhance their overall user experience but also empower them to extract meaningful takeaways from their data more efficiently.Advanced Scripting Features: With the introduction of features like Window Functions and Tenant Attribute Function, Qlik is aligning its offerings more closely with the demands of advanced developers, many of whom come from a SQL background. This competitive edge allows for more efficient development processes and less code complexity. For Qlik’s users, these functionalities mean reduced complexity in data handling, more flexibility in application management across different spaces, and a smoother workflow for data processing tasks.Continued Improvements to Qlik Data Integration & Catalog: Qlik continues to be a key player in the realm of data integration, with updates such as the Business Glossary Improvements and Qlik Cloud Data Integration connectors. These updates, especially the direct inclusion of governed data KPIs and definitions into applications, bolster Qlik’s stance as a comprehensive data management solution provider. For customers, this translates to increased data awareness, a broader range of connectivity options, and overall improved data management workflows.Q3 2023 Other NewsChanges to Qlik Cloud’s Pricing Model: Qlik will now use a capacity model which will change how Qlik Cloud plans may be structured. For more information, please referencing the updated Qlik Cloud pricing plans: https://www.qlik.com/us/pricing See Q2 2023 Updates for QlikQ2 2023 Product Release UpdatesCo-development and Version Control: Qlik has updated its user collaboration process by allowing co-development and version control in applications. This enhancement enables multiple users to concurrently edit the data load editor in an application, regardless of ownership, thus significantly improving team collaboration. Changes are saved as version history, allowing users to revert to earlier versions if required. This advancement streamlines the application development process and reduces the workload for individual developers, thereby driving efficiency in app development and management.Business Glossary Connected with Master Measures: With a focus on improving data governance and organization capabilities, Qlik has integrated the in-app organizing mechanism (master dimensions and measures) with the platform-wide organizing mechanism (the business glossary). This step further simplifies data management, promoting better data literacy and trust in the data being presented. This improvement is particularly significant in the current climate of increased demand for robust data governance services.Additional Connectors: In its ongoing commitment to maintaining an open ecosystem, Qlik has introduced several new connectors, including Open AI and Google Analytics 4. The addition of these connectors not only expands the potential Qlik user base but also underscores Qlik’s dedication to integrating a wide range of data sources, making data integration more seamless for the users.Stylistic Updates: Qlik has also made the following stylistic updates in Q2:Legend Styling: New styling options are available for font family, size, and color for titles and labels.Hide or Show Measures in Bar Chart based on conditions: App developers can now hide or show a toggle switch in charts based on a calculation condition. This gives them more control and customization over their bar charts.Chart Animation: App developers can now turn on animations for bullet and line charts. Animations are a gradual transition between an old view to a new view after the data has been changed (upon the change of a selection for example).Styling for Buttons: Developers can change the font, labels, and layout of button objects.Personalized Straight Tables: The new straight table significantly boosts self service capabilities through chart exploration. Users can add, remove, and reorder columns and then download, subscribe or bookmark their new self-serviced layout.Q2 2023 Other NewsQlik’s acquisition of Talend has been officially confirmed. This strategic move is set to enhance Qlik’s capabilities in data integration and integrity, thereby providing customers with more comprehensive solutions for their data needs. See Q1 2023 Updates for QlikQ1 2023 Product Release UpdatesQlik Cloud released a new business glossary, allowing users to access a single repository of business terms and descriptions that can be categorized and linked to applications and datasets. This ensures that everyone in the organization has the same understanding of key business terms while increasing visibility and data governance capabilities in the Qlik Cloud Platform.Having a single source of truth to catalog business definitions is essential in improving data literacy and self-service analytics within an organization. Having it integrated into the user facing Qlik Cloud platform brings these insights close to the users and removes needing another tool in the modern data stack.Expansion of Qlik Data Integration/Automation functionalities:Update to Create More Advanced Scheduling Options: Users can now assign dependent tasks and more granular run intervals in QDI.New Data Connections View: A high-level overview of data connections so that users can easily view and edit data connections across the QDI platform.New Project Pipeline View: Users can now use widgets to get an overview of their pipeline and expand/hide additional info on individual widgets within QDI.Updated Automations Overview: A better overall view of existing automations and their run status.Updates to the UI in both QDI and Automations: Improves the user and administrative experience, which should expand adoption and provide faster time to value with data tools.Q1 2023 Other NewsQlik acquired TalendQlik awarded Analytics8 as their North American Data Integration Partner of the YearTableauQ3 2023 Product Release UpdatesHere, we’ve outlined some of the most crucial new and updated features within Tableau (either generally available or in preview), emphasizing those we think are poised to make a meaningful difference for our users.Change in Product Release Cadence: Tableau has transitioned from 4 to 3 annual updates, allowing for robust development and more thorough testing. This strategic shift aims to present users with more refined features, ensuring a smoother experience with fewer potential issues.Dynamic Axis Ranges: An enhancement that allows visualizations to utilize parameter values for setting axis ranges, this feature is an extension of the Dynamic Axis Titles, aiming to offer data consumers more control. The result is clearer, more tailored insights, enhancing user customization and precision in data visualization.Custom Data Labels: This feature enables Creators and Explorers to set custom labels for data assets, underlining their commitment to deeper data comprehension. Users will benefit from better categorization, streamlining analysis, and ensuring accurate interpretations.Q3 2023 Other NewsTableau Pulse: Debuted at Tableau Conference, Tableau Pulse is a suite of capabilities that bring trusted generative AI to the entire Tableau platform to simplify and democratize data analysis and insight consumption at scale. This highly anticipated product is scheduled to be released in December 2023. See Q2 2023 Updates for TableauQ2 2023 Product Release UpdatesGoogle Analytics 4 Support: The inclusion of Google Analytics GA4 Connector in Tableau Exchange empowers users to connect directly to event data in a GA4 property. This direct link is set to boost the competitive edge of organizations that utilize both Google Analytics and Tableau.Tableau Prep Enhancements: With the support for no-code, multi-row table calculations, Tableau Prep has been upgraded to become an even stronger contender against other ETL tools in the market. This makes it easier than ever for users to perform calculations during the data cleansing and preparation stage, streamlining report development.Lineage Updates: Enhancements to Tableau’s Lineage page, a metadata management tool, allow users to filter and sort fields of interest. This is a pivotal first step toward more valuable upgrades in the features included in Tableau’s Data Management add-on, providing better visibility into organizational metadata.Total Shares Metric: Tableau has introduced a “Total Shares” metric in the Usage tab, facilitating a clearer understanding of user engagement with visualizations (vizzes). This metric helps developers and analysts create more targeted content for their audience. See Q1 2023 Updates for TableauQ1 2023 Product Release UpdatesTableau released one major update this quarter (Tableau 2023.1) focusing on quality-of-life features for developers, as well as bringing previously released features into the Tableau Server environment. These include:Accelerator Data MappingThe new Data Mapping UI makes setting up accelerators much easier. Accelerators with the Data Mapping feature enabled will experience a smooth data source replacement. The accelerator will open showing a dialogue box with the expected fields and allows users to replace it with fields of the same type from the new data source.This feature makes analytics in Tableau even simpler and is useful for analysts looking to get quick wins for their organization or jumpstart their data exploration journey.Identity PoolsTableau Server’s single identity store is no longer a limitation in the 2023.1 release.Identity Pools are a means of provisioning and authentication to enable user access that compliments the initial pool managed by Tableau Server.Companies that need to manage internal and external users can now do so from a flexible and centralized identity management workflow.Content Migration Tool: Embedded Credential SupportFor companies that are migrating from Tableau Server to Cloud, they can migrate workbooks and data sources with embedded credentials.This feature saves countless hours of opening every workbook, adding the credentials back in, and then publishing to the Cloud.User Attribute FunctionsNew user functions allowing for row-level security data source filters aside from Username and Group (ex. Region, Department, etc.)This feature allows user’s data access to be customized in embedded applicationsThese updates help users see a faster time to value, expand their deployments, and increase dashboard flexibility.Smaller updates include:Tableau for Slack EnhancementsShare Tableau content with contextEnhancements to searching for view or workbooks shared within SlackNewly added Recent and Favorites sections in the App homepage supports a convenient and faster path to insightsSalesforce Data Cloud for TableauIncreases functionality for companies that use Salesforce dataQ1 2023 Other NewsReminder about Tableau Conference 2023 on May 9-11. Mark your calendar!Power BIQ3 2023 Product Release UpdatesHere are some of the standout new and enhanced features in Power BI (either generally available or in preview), particularly those we have identified as being of significant value to our customers.Report View Layout Switcher (August): Power BI introduced the dynamic capability to transition between Web view and Mobile view within Report View, available at the screen’s bottom left. This enhancement stems from Microsoft’s renewed focus on optimizing Power BI Mobile, catering to on-the-go data consumers. The outcome is dual fold: developers enjoy streamlined report creation for both formats, and end users benefit from tailored viewing experiences, bolstering overall satisfaction with the analytics product.XMLA Write Support for Datasets (August): Direct Lake datasets in Power BI now boast XMLA Write support, heralding a paradigm shift. Such integration facilitates multiple tools and methodologies to liaise with Power BI’s data, paving the way for expansive dataset management within Direct Lake. From deployments and customization to version control and more, developers now wield the flexibility to leverage an array of tools, optimizing dataset functions as per their comfort, provided the chosen method aligns with this feature.Q3 2023 Other NewsSmooth and Leader Lines on Line Charts (July): Aesthetics get a boost with the smoother line rendition on line charts and the addition of leader lines for distinct data label separation.Relationship Validation in Power BI Service (July): Users can now modify data model relationships within the Power BI Service.Dataset Access in Power BI Mobile (July): Mobile users can access Power BI datasets on the move, tapping into dataset metadata, scheduled refreshes, and push notifications.New Dataflow Data Connection and Discovery (August): OneLake Hub unveils a refined method to connect or locate datamarts within Fabric OneLake, introducing Dataflow Gen2.Emplify Metrics New Data Connector (September): “Get Data” tab in Power BI now features Emplify Metrics as a fresh data connector..NET 4.7.2 Framework Now Required (September): Power BI mandates users to transition to the .NET framework version 4.7.2 or above, discontinuing support for preceding versions.Mobile Canvas Interactivity (September): Enhancements in Mobile view allow users to engage with visuals, providing a sneak peek into object interactivity prior to publishing on the Power BI Service. See Q2 2023 Updates for Power BIQ2 2023 Product Release UpdatesMicrosoft Fabric and Power BI Connectivity: Microsoft Fabric is set to replace Azure Synapse as Microsoft’s all-in-one analytics solution, integrating data lakes, warehouses, real-time analytics, business intelligence, and data integration. This release bolsters Microsoft’s competitive position in the analytics market by simplifying the analytics process with an integrated platform. It’s expected to be most impactful initially for early adopters of Microsoft Fabric, but as it continues to develop, it can greatly simplify and enhance the analytics workflow for many organizations.Admin Monitoring: The addition of Admin Monitoring in Power BI Service tenant settings enhances visibility on how reports are being consumed across various workspaces. This new feature strengthens Power BI’s user-oriented approach by enabling more accountable monitoring of report usage, helping identify gaps in reporting, and optimizing reports based on user interaction, leading to more effective reporting and decision-making.Measure-Based Data Labels: This feature allows developers to apply measures to specific labels in visuals, overriding the default data, making data presentation more user-friendly. By enhancing adaptability and user-friendliness, Power BI distinguishes itself further from competitors. The update also enhances report readability and understanding, enabling tracking of unique KPIs in a more meaningful way.Q2 2023 Other NewsDynamic Format Strings in Measures: This feature enables users to dynamically alter measure outputs for a more user-friendly display.Paginated Reports – Filters Available: Paginated Reports now support the application of filters within the canvas.Azure Maps now Generally Available: Azure Maps officially moved out of Preview and became widely available, with plans for future Map visuals integration.Integration with SharePoint and OneDrive: Power BI reports can now be saved, stored, and shared within OneDrive and SharePoint file libraries.Drillthrough Functionality in Paginated Reports: This feature enables detailed data views from summarized data.Query Limits in Power BI Desktop: Power BI now supports setting query limits on reports to prevent overload scenarios.New Card Visual: This new visual supports the use of multiple measures and provides a range of formatting options.OneLake Data Hub for Fabric: This feature allows for the reuse of Microsoft Fabric items and building datasets and reports based on them.Power BI Developer Mode: This new mode provides a new project collaboration tool for users that keeps files organized for easy access and version control.On-Object Interaction Update: This update allows for permanent embedding of panes on the right side of the screen. See Q1 2023 Updates for Power BIQ1 2023 Product Release UpdatesUpdated Visualizations/Format Pane: Power BI put out an update in March that changed how the UI works for Power BI Desktop. Moving forward, the Visualizations pane is no longer on the right-hand side of the UI, users now have to select visuals at the top ribbon within the Home tab and Insert tab. The Format pane must now be enabled in the View tab. Enabling it will cause a button to appear on the right-most side of the UI. Clicking each button allows for switching between various panes that are enabled (ex: switching between Format pane, Data pane, Selection pane, and others). Users can view multiple at the same time by right-clicking and choosing Open in New Pane.On-Object Interaction: This is a new feature to coincide with the above update that allows for tweaking visuals at the individual level. Since the Format pane and Visualizations pane are removed from their original default position, the new way to make changes to visuals is to use On-Object Interaction. This feature is a Preview Feature that must be enabled in the Power BI settings. Now buttons will appear next to a selected visual in which will allow for tweaking the data of the visual and enabling the formatting of the visual. A visual in question must be selected to change the visual type and the dimensions/measures.Storytelling in PowerPoint: A new feature being rolled out in Power BI that allows for individual visuals of a report to be exported to PowerPoint to be used in presentations external to the Power BI instance. The visuals can be embedded live into a PowerPoint slide and can even produce an annotated text write up describing the data in detail. This is done by clicking the three dots above a visual, choosing Share, then selecting Open in PowerPoint.This allows for an additional method of data to be consumed by end users, especially users that don’t have the ability to connect to a Power BI instance. This is a nice export feature that keeps a live (or updated) connection to your reports. The feature is also visual-specific and can allow you to pull from various reports, allowing for a consolidated view of one’s most impactful visuals and data.Conditional Format String Values: This allows for conditional formatting features on string values instead of just numerical data.Custom Theme Validation: Built-in feature that validates whether your custom JSON themes are compatible to use in your reports.Textbox Text Indentation: Text within textboxes now give you the ability to indent, a feature missing in previous versions.Enhanced Row-Level Security Editor: Updated GUI dropdown approach to creating Row-Level Security groups for ease of use, rather than using DAX.New DAX Measures (LINEST and LINESTX): A new DAX function that provides linear regression using a Least Squares model. Used for statistical prediction analysis.Visual Container Improvements: New visual improvements for formatting purposes. This includes Subtitle, Divider Line, and Spacing/PaddingSigmaQ3 2023 Product Release UpdatesHere are a few highlights of new and updated features in Sigma (either generally available or in preview) that we think are impactful to our customers. Column Level Security: Sigma introduced column level security to control access to specific columns within datasets, ensuring the confidentiality of sensitive data. By granting access based on user teams or account attributes, Sigma enhances data security, even in embedded reports or when shared with external parties. This strategic implementation brings Sigma at par with leading BI tools, ensuring Admins have comprehensive control over data visibility. For BI analysts and managers, this means efficiency — instead of creating multiple similar datasets, one can be repurposed with specific column access. Stay informed on this feature here.Input Tables now supports Databricks: Sigma extended its Input Table feature — previously exclusive to Snowflake connections — to Databricks. Launched earlier this year, Input Tables allows users to generate tables by entering values directly into Sigma’s UI, interacting seamlessly with other data in a Sigma workbook. This expansion is pivotal; while Input Table capabilities are rare among BI tools, this Databricks integration caters to a broader organizational base, enabling features like scenario planning and forecasting. Dive deeper here.Q3 2023 Other NewsStay engaged with Sigma’s upcoming in-person events, the “Data Cloud World Tour”: Get all the details here. See Q2 2023 Updates for SigmaQ2 2023 Product Release UpdatesConnection to MySQL: This new data connector adds MySQL to Sigma’s repertoire of compatible data sources, reinforcing Sigma’s competitive standing in the BI market. By supporting connections to major relational database systems such as PostgreSQL and MySQL, Sigma is now more accessible to organizations that rely on these databases. For clients not yet utilizing a cloud-based platform, this enhancement opens the possibility of adopting Sigma as their BI tool of choice.Map – Geography release: This update replaces the Map – GeoJSON visualization with the more versatile Map – Geography, allowing Sigma to visualize any column formatted as geography WKT. This enhancement, coupled with the new “Geography()” function, brings Sigma’s mapping capabilities more in line with major BI platforms that have added WKT and GIS functions. For clients who have been facing challenges with GIS calculations on disparate software programs, this update facilitates GIS analysis within Sigma itself, improving ease and accessibility of GIS analysis.Q2 2023 Other NewsWurl and Sigma Webinar to be held on July 26, 2023: This upcoming webinar will delve into how Wurl is unlocking insights and monetizing data, the latest features and innovations within Sigma Computing, and the exciting possibilities brought about by input tables, application embedding, and the integration of data science and Snowpark with Streamlit. The webinar presents an excellent opportunity for Sigma users and prospective users to learn more about the potential Sigma offers for their organizations.State Data Privacy Regulations: See Q2 2023 Updates for State Data Privacy RegulationsQ2 2023 UpdatesAs personal data is used in more encompassing and inventive ways, it is important to be mindful of managing increased privacy risks. Failure to do so can negatively impact profitability, reputation, and leave businesses vulnerable to legal action.In Q2 2023 we conducted a deep dive on the data privacy principles in the following jurisdictions:JapanHong KongChinaThese updates are intended to raise awareness and encourage a proactive approach to data governance over a reactive one. Please follow the links for the most up-to-date information on each law and confirm with your legal counsel. Japan: The Act on the Protection of Personal Information (APPI) – last amended April 1, 2022 What is the Act on the Protection of Personal Information?In 2003, Japan enacted the Act on the Protection of Personal Information (“APPI”) which regulates privacy protection issues in Japan. The Personal Information Protection Commission (“PPC”) is a central agency which acts as a supervisory governmental organization on issues of privacy protection. After being amended twice in both 2017 and 2022, the Amended APPI came into force on April 1st 2022 and lists many guidelines including:Making sure that the data collected and its use is limited to what is necessary for its purpose (which must be specified by the time of collection) unless there is consent by data subjects or authority of law to use it otherwise.Ensuring data is obtained by fair and lawful means, with knowledge or consent of data subjects where appropriate.Maintaining data quality so that personal data is accurate, complete, and up to date. It is also necessary to have proper data retention policy so that personal data is deleted after its specified purpose is achieved.Implementing security safeguards to protect personal data against risks including but not limited to loss, cross-border transfers without consent, or unauthorized access. Businesses must also train staff in how to properly handle personal data and have procedures in place to notify the PPC in the event of a data breach. Creating a general policy of openness and transparency concerning developments, policies, and practices with respect to personal data and its purposes.How are Businesses Affected?If your business collects personal data of Japanese data subjects to provide them with your goods and/or services, and collects, retains, uses, transfers, or otherwise handles this data in a country other than Japan, you are subject to compliance with the APPI.What are the Enforcements and Penalties? Enforced by the PPC. Businesses must submit report, comply with on-site inspection, and take action to remedy violation. Responsible individuals may face imprisonment of up to one year and be subject to fines up to $720,000.Hong Kong: The Personal Data (Privacy) Ordinance (PDPO) – last amended October 8, 2021 What is the Personal Data (Privacy) Ordinance?One of Asia’s oldest data protection laws is the Personal Data (Privacy) Ordinance (“PDPO”) which was passed by Hong Kong in 1995 and took effect beginning December 1996. It underwent major amendments in 2012 and 2021. While the PDPO is rather high-level and general, we have focused on the Data Protection Principles which are clearly called out:Collection and use of data must be done lawfully and in a fair way, for a purpose that relates directly to a function of the data user (unless voluntary and explicit consent is obtained from the data subject). This purpose, as well as potential recipients of the data, must be disclosed to the data subjects. Steps must be taken to ensure data quality and proper retention of personal data. Data subjects must be provided with the ability to access and make corrections to their personal data. If data is no longer needed for its intended purpose, it must be erased barring circumstances where it is prohibited by law or not in the public interest to do so. Data users must take practicable steps to safeguard personal data from unauthorized or accidental access, processing, erasure, loss, or use. Policies and practices regarding types of personal data a business holds and how it is used must be transparent to the public. “Doxxing” (generally defined as publicly providing personally identifiable information about an individual or related person, usually via the internet, and often with malicious intent) is considered a criminal offense.How are Businesses Affected? If your business is collecting, retaining, using, transferring, or otherwise handling data in Hong Kong regardless of where the data was initially collected or processed, you are subject to compliance with the PDPO.What are the Enforcements and Penalties?Enforced by the Office of the Privacy Commissioner for Personal Data. Businesses must comply with investigation and take action directed by the Commissioner to remedy the violation. Responsible parties may face imprisonment of up to two years. Businesses are subject to fines up to $100,000, as well as civil action from data subjects.China: The Personal Information Protection Law (PIPL) – November 1, 2021 What is the Personal Information Protection Law?The Personal Information Protection Law (PIPL) is very similar to US laws and the European Union’s GDPR. Focusing on the differences, we have outlined the laws for key consideration:Any data processing activities (including sale/disclosure of personal information) that endanger national security or the public interest are considered illegal.Personal information processors must be transparent and able to fully explain automated decision-making based on data subjects’ personal information. Children under the age of fourteen are considered a specially protected class. For deceased data subjects, their close relatives have rights to consult, copy, correct, and delete relevant personal information of the deceased (unless otherwise arranged). In addition to participation in government inspections, regular compliance exercises and audits are required for personal information processors and the results of the exercises and audits must be maintained.How are Businesses Affected?If your business handles the data of Chinese citizens, you are subject to compliance with the PIPL.What are the Enforcements and Penalties? Enforced by responsible State authorities. Businesses must comply with investigation and take action directed by authorities to remedy the violation. Businesses found to be in violation of the PIPL are subject to confiscation of illegal gains and fines of up to $8 million or 5% annual revenue. Additionally, responsible parties may face criminal and civil penalties. There is no limit to civil penalties, so liabilities can be significant.Overall Takeaways It is imperative that businesses maintain thorough and up to date documentation on how personal data is collected and what its purpose is. Having poor data quality can not only affect the reliability of the insights your data is generating, but also put you at risk for noncompliance when it comes to certain laws. Implementing a data risk taxonomy is recommended to identify the specific vulnerabilities of your data and determine the necessary safeguards for its protection. Training employees to effectively handle personal data is a critical step in mitigating risk and remaining compliant. See Q1 2023 Updates for State Data Privacy RegulationsQ1 2023 UpdatesSince 2021, several US states have enacted new or updated data privacy regulations like GDPR in Europe. The impact of failing to comply is not limited to monetary loss and damage or one’s reputation, but also entails legal consequences. Below is a list of state data privacy regulations you should be aware of. These laws apply based on where the customers are located, rather than the state the business is based.These updates are intended to bring awareness and encourage planning ahead. Please follow the links for the most up-to-date information on each law and confirm with your legal counsel.California Privacy Rights Act (CPRA) – July 1, 2023What is the California Privacy Rights Act?Also known as, “CCPA 2.0” as it revises, expands, but does not replace California Consumer Privacy Act. CPRA is an amendment to CCPA and it makes California privacy law even more like the European Union’s GDPR.California voters voted the ballot measure Proposition 24 in November 2020. The new law didn’t take effect until January 2023. Full enforcement will begin July 1, 2023.How Are Businesses Affected?According to Termly, CPRA applies to “for-profit organizations that do business in the State of California and meet one or more of the following criteria: Had $25 million in annual gross revenues as of Jan. 1 of the preceding calendar year; Sell, buy, or share the personal information of 100,000 California households or consumers; Derive 50% or more of its revenues from sharing (a newly defined term) or selling personal information.What are the Enforcements and Penalties?New California Privacy Protection Agency takes over enforcement from the California Attorney General’s office. The CPRA’s enforcement authority begins July 1, 2023.Annual audits are now required for “high-risk processing.”Civil penalties of up to $2,500 per violation or $7,500 per each intentional violation.Colorado Privacy Act (CPA) – July 1, 2023What is the Colorado Privacy Rights Act?Protects the personal data of Colorado residents.Gives Colorado residents the right to opt-out of the sale of their personal data and the use of their data for certain types of profiling.Gives Colorado residents the right to correct or delete personal data.How are Businesses Affected?Applies to those that conduct business in Colorado or provide commercial products/services targeted to Colorado residents. The businesses must either: Control or process the personal data of at least 100K consumers per calendar year; derive revenue or receive a discount on the price of goods or services from the sale of personal information and process or control the personal data or 25K consumers or more.What are the Enforcements and Penalties?Enforced by the Colorado Attorney General’s office and district attorneys.No fine guidance under the CPA, but the penalties are under the more general Colorado Consumer Protection Act. Fines are up to $20,000 per violation.Connecticut Data Privacy Act (CTDPA) – July 1, 2023What is the Connecticut Data Privacy Act?Protects privacy rights of Connecticut residents, applies to sale of personal data and targeted advertising related to personal data.How are Businesses Affected?For businesses in Connecticut (note: based on where the business is located) OR provide products/services for Connecticut residents. The businesses must either: control or process the personal data of at least 100K consumers per calendar year; or control or process the personal data of at least 25K consumers and derive at least 25% of its gross revenue from the sale of personal data.What are the Enforcements and Penalties?The Connecticut Attorney General will enforce the CTDPA.Civil penalties up to $5,000 per violation.Maryland Personal Information Protection Act (PIPA) – October 1, 2018What is the Maryland Personal Information Protection Act?Protects Maryland residents’ personal identifying information.Businesses must Maryland consumers if there is a data security breach within 45 days.How are Businesses Affected?PIP applies to businesses that maintain personal information of an individual residing in Maryland.What are the Enforcements and Penalties?The Maryland Attorney General enforces PIPA.Civil penalties of up to $1,000 per violation.Possible criminal penalties up to $5,000 per violation.Also, the Maryland Attorney General can seek remedies that constrain violators.Utah Consumer Privacy Act (UCPA) – December 31, 2023What is the Utah Consumer Privacy Act?Protects privacy rights of Utah residents, applies to sale of personal data and targeted advertising related to personal data.How are Businesses Affected?Businesses must meet the following three criteria: conduct business in Utah or provide products/services targeted to Utah residents as consumers; AND business must have annual revenue of $25,000,000 or more ($25 million threshold) AND meet one of these two sub-criteria: control or process the personal data of 100K or more consumer per year; derive over 50% of the business’ gross revenue from the sale of personal data and controls or processes personal data of 25k or more consumers/What are the Enforcements and Penalties?Enforced by the Utah attorney general. The Division of Consumer Protection will administer consumer complaints.Damages and fines up to $7,500 per violation.Virginia Consumer Data Protection Act – March 2, 2021What is the Virginia Consumer Data Privacy Act?The Virginia Consumer Data Protection Act is similar to the European Union’s GDPR and California’s CCPA. It involves the collecting, storing, and selling of personal information. Consumers in Virginia now have the right to request that personal data be deleted.How are Businesses Affected?For businesses in Virginia (note: based on where the business is located) OR provide products/services targeted at Virginia residents. However, the word targeted is not clearly defined in the statute. The businesses must either: control or process the personal data of at least 100K consumers per calendar year or control or process the personal data of at least 25K consumers and derive at least 50% of its gross revenue from the sale of personal data.What are the Enforcements and Penalties?Enforced by the Virginia Attorney General beginning January 1, 2023.Damages up to $7,500 for each violation.Want to learn more? Talk to one of our experts.Thank you. Check your email for details on your request.These updates are current as of Q3 2023. Keep an eye out for quarterly updates on technologies within the data and analytics space.