PARAMETER ACTION + SHEET ACTION

Snowflake Cortex: AI-Powered Data at Your Fingertips

Snowflake Cortex provides access to industry-leading AI models, including large language models (LLMs) and vector search functionality. These serverless tools simplify everyday analytics and AI development, all within a single line of SQL or Python. Source: https://www.snowflake.com/en/blog/use-ai-snowflake-cortex/

Key benefits include:

• Instant Access to AI Models: Snowflake users can leverage specialized machine learning and LLM models without managing expensive infrastructure. • Enhanced Data Insights: With Cortex, users can analyze vast datasets using Snowflake’s powerful AI capabilities, unlocking strategic insights to improve decision-making. • Simplified AI App Development: By removing technical barriers, Cortex democratizes AI access, enabling users of all skill levels to build AI applications.

LLM-Based Models for Unstructured Data (in private preview):

• Answer Extraction: Extract key information from unstructured datasets. • Sentiment Detection: Identify the sentiment in textual data. • Text Summarization: Create concise summaries of lengthy documents for quicker insights. • Translation: Perform large-scale text translation efficiently.

ML-Based Models (available soon):

• Forecasting: Automatically forecast time series based on historical data, adjusting for seasonality and scaling. • Anomaly Detection: Detect outliers in time series data, useful for monitoring data pipelines. • Contribution Explorer: Identify key factors contributing to changes in metrics between two time intervals. • Classification: Categorize data into predefined classes to offer recommendations based on trends.

General Purpose Models for Broader Use Cases:

• Complete: Generate text completions using state-of-the-art open-source LLMs like Llama 2. • Text2SQL: Convert natural language queries into SQL, powered by Snowflake’s LLM, similar to the Snowflake Copilot feature. These serverless functions offer out-of-the-box capabilities that can be integrated into analytics workflows and app development in Snowflake. For example, with just a few lines of code, developers can embed these functions into chatbots using Streamlit. This allows Python-savvy users to build secure and powerful LLM applications quickly, often within hours.

Document AI

Document AI (currently in private preview) leverages large language models (LLMs) for seamless data extraction. By utilizing a pre-trained model and a user-friendly interface, customers can process various document types—such as PDFs, Word files, text files, and even screenshots—to quickly obtain answers to their queries. This capability can be scaled to build pipelines that automate data extraction, significantly reducing manual effort and saving time. Source: https://www.snowflake.com/en/blog/use-ai-snowflake-cortex/

Snowflake Copilot: Your AI-Powered SQL Assistant

Snowflake recently introduced Snowflake Copilot, an AI-driven solution that makes SQL query generation faster and more efficient. With Snowflake Copilot, users can ask data-related questions in plain English, and the AI will generate SQL queries to deliver the desired insights.

Key Features of Snowflake Copilot:

• Text-to-SQL: Users can interact with their data using natural language, eliminating the need for complex SQL coding. • Enhanced Accuracy: The AI continuously refines its understanding of user queries, providing more accurate SQL code suggestions. • Data Exploration: Ask open-ended questions about your data and receive detailed insights without writing complex queries.

The Future of Generative AI with Snowflake

Snowflake is pushing the boundaries of Generative AI with its continuous development of AI tools like Snowflake Cortex AI and Snowflake Copilot. These innovations pave the way for a future where natural language becomes the primary interface for data analysis, enabling businesses to extract more value from their data while maintaining robust governance.
By integrating AI capabilities directly into the data platform, Snowflake empowers users to streamline workflows, reduce processing times, and unlock new levels of productivity—all without needing deep AI expertise.

A Transformative Partnership for the Future

Generative AI, coupled with Snowflake’s powerful data platform, is a game-changer for businesses looking to innovate and scale. Whether it’s enhancing productivity, improving decision-making, or driving customer engagement, Snowflake’s AI solutions are built to transform how enterprises interact with their data.

As AI continues to evolve, so will Snowflake's offerings, bringing more capabilities, deeper insights, and greater efficiencies to businesses worldwide. Ready to experience the future of data analysis with Snowflake and AI? The journey has just begun!

Snowflake + Beinex Partnership

Beinex is a Snowflake Services Partner Premier Tier, and the partnership reaffirms Beinex’s commitment to delivering exceptional data solutions and positions the company at the forefront of industry advancements. Harnessing the true potential of the data, partnership drives innovation and success in the digital era.
Belonging to Snowflake Services Partner Premier Tier, Beinex leverages Snowflake’s advanced capabilities and seamlessly integrates them into its comprehensive data solutions. This enables Beinex to accelerate the pace of Digital Transformation for its clients, providing them with the tools necessary to extract maximum value from their data and thrive in an increasingly data-centric world.
Connect with us for a free demo: https://beinex.com/contact-us/

Benefits of Cloud Computing

Agility

The cloud offers seamless access to diverse technologies, enabling swift innovation and the realization of any imaginable concept. Resources ranging from infrastructure services like computing, storage, and databases to advanced features like machine learning, Internet of Things, data lakes, and analytics can be swiftly provisioned to meet specific needs.

Elasticity

Cloud computing eliminates the need to allocate excessive resources in advance to accommodate future peaks in business activity. Instead, you can precisely provision the required resources, with the flexibility to scale them up or down instantly based on evolving business demands.

Cost-effectiveness

The cloud enables the transition from fixed expenses associated with data centres and physical servers to variable expenses, where you only pay for IT services as you consume them. Additionally, the economies of scale inherent in cloud services contribute to significantly lower variable costs than in-house solutions.

Global Deployment in Minutes

You can leverage the cloud for rapid expansion to new geographic regions, enabling global deployment within minutes. For instance, AWS boasts a global infrastructure footprint, enabling the deployment of applications across multiple physical locations with just a few clicks. This proximity to end users reduces latency and enhances the overall user experience.

Worldwide Vendor Market Share

Sourced from: Cloud Market Share Q2 2023: AWS, Microsoft, Google Battle | CRN

AMAZON WEB SERVICES (AWS)

Amazon Web Services is the most extensive and widely adopted cloud platform worldwide, offering over 200 fully featured services across global data centres. AWS is used by millions of customers, including fast-growing startups, major enterprises, and prominent government agencies, to reduce costs, enhance agility, and accelerate innovation.

The USPs of AWS

Unparalleled Features and Services

AWS surpasses other cloud providers with a significantly larger array of services and features, ranging from infrastructure technologies like computing, storage, and databases to cutting-edge technologies like AI, machine learning, data lakes, analytics, and Internet of Things. This breadth of offerings facilitates a faster, easier, and more cost-effective transition of existing applications to the cloud and empowers the creation of any imaginable solution.

Extensive Network of Customers and Partners

AWS boasts the most extensive and dynamic community of tens of thousands of partners worldwide and millions of active customers. Clients from diverse industries and varying sizes, including the public sector, organizations, startups, and enterprises, run many use cases on AWS. The AWS Partner Network (APN) comprises thousands of systems integrators specializing in AWS services and thousands of independent software vendors (ISVs) adapting their technology to integrate with AWS seamlessly.

Top Security Standards

AWS is the safest and most flexible cloud computing environment available. The foundational infrastructure meets the security standards for global banks, military, and other high-sensitivity organizations. This commitment to security is fortified by an extensive set of over 300 security, compliance, governance services and features, and support for 143 security standards and certifications.

Faster Innovation

AWS allows for faster experimentation and innovation by leveraging the latest technologies. The continuous acceleration of innovation at AWS results in the introduction of groundbreaking technologies that can transform businesses.

Operational Proficiency

AWS's unparalleled experience, reliability, maturity, performance, and security offer a dependable foundation for critical applications. With over 17 years of delivering cloud services to millions of customers globally across diverse use cases, AWS possesses the most operational experience at a larger scale than any other cloud provider.

Popular Customers of AWS

Netflix:Netflix relies on AWS for most of its computing and storage requirements, including analytics, databases, recommendation engines, video transcoding and numerous functions utilizing over 100,000 server instances on the AWS platform.
BMW Group: BMW Group leverages AWS to acquire the agility and flexibility necessary for democratizing data usage and expediting innovation.
Philips: Philips is an early adopter of AWS that utilizes AWS services to manage the Philips HealthSuite Platform, ensuring scalability, cost-effectiveness, and regulatory-compliant solutions.
Salesforce: Salesforce shares a global strategic relationship with AWS, utilizing AWS compute, storage and AI solutions to create and deploy innovative business applications.
Pinterest: The exabyte data platform of Pinterest is hosted exclusively on AWS, managing log search and analytics that surpass 1.7TB. This implementation has led to a 30% reduction in operational costs.
Coca-Cola: After its migration to AWS, Coca-Cola has reduced operational costs by 40% and IT ticket volume by 80%.

Regions & Availability

AWS boasts the most expansive global cloud infrastructure. Gartner has acknowledged the AWS Region and Availability Zone framework as the endorsed strategy for operating enterprise applications demanding high availability.
The AWS Cloud covers 102 Availability Zones across 32 geographic regions worldwide, with disclosed intentions to introduce an additional 15 Availability Zones and 5 AWS Regions in Germany, Canada, Thailand, Malaysia and New Zealand.

MICROSOFT AZURE

The Azure cloud platform encompasses over 200 products and services crafted to empower you to bring innovative solutions to fruition, addressing current challenges while shaping the future. It offers the flexibility to build, run, and manage applications across various clouds, on-premises, and at the edge, utilizing the tools and frameworks as per your preferences.

The USPs of Microsoft Azure

Rely on Cloud Capabilities

Acquire security from the ground up, supported by experts, and embrace proactive compliance trusted by enterprises, governments, and startups.

Operate Hybrid Seamlessly

Whether on-premises, across multiple clouds, or at the edge, Azure will meet you wherever you are. Integrate and manage your environments effortlessly with services specifically designed for hybrid cloud scenarios.

Build in Line with Your Terms

With a dedication to open source and support for all frameworks and languages, build in the manner that suits you best and deploy your creations wherever you choose.

Get Equipped for the Future

Microsoft's continuous innovation supports your current development needs and aligns with your visions for future products.

Popular Customers of Microsoft Azure

New York City Department of Environmental Protection (DEP): DEP uses a Microsoft infrastructure specifically designed with modern security considerations. With the solution in the cloud, Microsoft manages disaster recovery, reducing the necessity for maintaining certain skill sets in-house. CCC Group: CCC Group utilizes Azure Data Lake and Data Warehouse to collect, store, and segment data. Panasonic Connect Co: Panasonic Connect Co maximizes the benefits of PaaS services such as Azure IoT Hub, Synapse Analytics, and Azure Kubernetes Services. Hamburg Commercial Bank: Hamburg Commercial Bank opted for Microsoft Azure Virtual Desktop to achieve improved performance, reliability, and enhanced interoperability with other Microsoft technologies previously invested in. Barnsley Hospital NHS Foundation Trust: Barnsley Hospital NHS Foundation Trust adopted a new, integrated platform using Power Platform and Microsoft Teams for video consultations. During the COVID-19 pandemic lockdowns, the Trust rapidly deployed Microsoft Teams to facilitate remote work and staff collaboration.

Regions & Availability:

Microsoft operates highly secure data centre facilities globally, forming a distributed infrastructure that sustains thousands of online services. This expansive, globally distributed infrastructure prioritizes sustainability, bringing applications closer to users, ensuring data residency, and providing customers with comprehensive compliance and resiliency options.
As of March 2023, Microsoft Azure boasts 160 active data centres spread across 60 regions worldwide. These Azure regions, defined by geographical areas, house one or more physical Azure data centres. Operating within a latency-defined perimeter, these data centres are strategically positioned to deliver optimal performance and security to users.
Azure leads with over 60 announced regions, surpassing all other cloud providers. It is accessible in 140 countries, showcasing a global presence that sets it apart in cloud computing.

GOOGLE CLOUD PLATFORM (GCP)

Google Cloud, also called Google Cloud Platform, offers computing resources dedicated to developing, deploying, and operating web applications. While its cloud infrastructure supports applications like Google Workplace, GCP primarily serves as a platform for constructing and managing custom applications. These applications can subsequently be published on the web, leveraging the extensive capabilities of its hyperscale data centre facilities.

The USPs of the Google Cloud Platform

Leveraging Data Effectively

Google’s comprehensive data foundation lets you integrate workloads and handle the complete data life cycle. This solution is engineered to operate data seamlessly across various environments, allowing you to utilize your data on any cloud, on-premises, and within popular SaaS applications. Designed with a focus on AI, it offers the latest tools for machine learning analysis, prompting, tuning, training, and deploying custom foundational models, all interconnected with your business data.

Revamping your Infrastructure with Modern Solutions

Google Cloud enables developers to build faster, safer, and cost-effectively utilizing the next generation of modern infrastructure tailored to specific workloads and industry requirements. Benefit from infrastructure optimized for AI, container-based applications, traditional enterprise workloads, and high-performance, distributed workloads, all while contributing to cost reduction and a reduced carbon footprint.

Fostering an Innovative Environment

GCP equips teams of all sizes to excel in their work regardless of the location and device. Google Workspace combines innovative tools favoured by the modern workforce for collaboration and creation, including Gmail, Google Drive, Google Chat, Google Calendar, Google Sheets, Google Docs, and Google Meet. With over 3 billion monthly active users, Workspace is the most popular productivity and collaboration software globally, offering new, user-friendly, generative AI features to enhance team productivity.

Incorporating Built-in Security Features

Benefit from built-in security features that mirror the same capabilities Google employs to safeguard more individuals and organizations online than any other provider. Google aids organizations in transforming their cybersecurity programs by providing frontline intelligence from Mandiant to comprehend the latest cyber threats.

Popular Customers of the Google Cloud Platform

Etsy: Utilizing the collaborative tools offered in Google Workspace, Etsy meets the evolving needs of sellers and buyers innovatively, fostering continued growth and enhancing the sustainability of its operations. X (formerly Twitter): Twitter's complete shifting of its ad analytics data platform to Google Cloud granted developers increased agility, allowing them to configure existing data pipelines more easily and build new features acceleratedly. Airbus Defence and Space: Airbus Defence and Space's Intelligence business line employs Google Cloud to construct a scalable online platform, enabling customers to access petabytes of satellite imagery in real-time.

Regions & Availability

Google Cloud provides global coverage through regions distributed worldwide, ensuring low cost, minimal latency, and optimal application availability for customers.

Follow the link to have a look into a tabular comparison of the solutions provided by the CSPs: AWS, Azure and GCP. https://cloud.google.com/docs/get-started/aws-azure-gcp-service-comparison

Understanding Homograph Phishing Attacks

Homograph phishing attacks rely on Internationalised Domain Names (IDNs), a feature designed to accommodate non-ASCII characters in domain names. While this capacity improves internet access for people of varied language backgrounds, it also allows for harmful exploitation. Cybercriminals can now register domain names that appear identical or almost equivalent to regular Latin characters but come from alternative Unicode character sets.

For example:

1. Legitimate Website: www.login.microsoft.com
2. Homograph Phishing URL: www.login.micrsoft.com

In this example, the 'o' in the homograph URL is not the standard Latin 'o,' but rather the Latin Small Letter Sideways 'ᴑ', which visually appears identical. To unsuspecting users, the homograph URL looks indistinguishable from the legitimate one and consequently fall prey to it.

The Dangers of Homograph Phishing Attacks

Homograph phishing attacks pose significant risks, primarily due to their ability to deceive users successfully by means of:

1. Credential Theft: Cybercriminals utilise homograph URLs to impersonate reputable websites and deceive users into entering their login credentials, collecting critical information.
2. Financial Fraud: Attackers may imitate banking websites, payment portals, or e-commerce platforms to steal credit card information or banking information from unsuspecting consumers, resulting in financial losses.
3. Malware Distribution: Homograph URLs can route users to fraudulent websites or start malware downloads, possibly infecting their devices and leading to data breaches.
4. Business Email Compromise (BEC): Homograph phishing URLs help in BEC attacks, in which attackers imitate high-ranking officials to trick employees into making fraudulent money transfers or disclosing sensitive information.

Protecting Against Homograph Phishing Attacks

While homograph phishing attacks can be challenging to detect, several preventive measures can help enhance cybersecurity like those of:

1. Domain Monitoring: Monitor domain registrations regularly for questionable or homograph URLs that mimic valid domains. Security professionals can also employ specialised tools to proactively identify potential risks.
2. Using Web Browsers with IDN Support: Modern web browsers include features for detecting and displaying problematic homograph URLs. Check that your browser is up to date and that IDN support is enabled.
3. URL Inspection: Hovering over links to show the actual domain before clicking on them encourages people to carefully analyse URLs. Homograph URLs may appear deceiving at first view, but they disclose their actual nature with closer inspection.
4. Deploying Security Software: To detect and block fraudulent URLs and emails, use powerful security solutions such as anti-phishing software, firewalls, and email filters.
5. Cybersecurity Awareness Training: Educate staff and users about the dangers of homograph phishing attempts and encourage them to be proactive in cybersecurity.

Defending against homograph phishing attacks necessitates a multi-pronged approach. Organisations and people must use domain monitoring services such as Amazon Route 53 and web browsers with IDN capability to identify fraudulent URLs. It is critical to educate clients about the risks through cybersecurity training.

Beinex+ AWS Offerings

AWS provides security services such as AWS Shield and AWS WAF to help protect against phishing attacks. Strengthen your defences by integrating robust security software from the AWS Marketplace and embracing Two-Factor Authentication (2FA). Safeguard against evolving threats like homograph phishing for a safer online experience.

Beinex is an AWS consulting partner, and we empower customers to host their BI solutions, provide security services and much more on the cloud. Our cloud migration experts bring in best-in-class stability and reliability by understanding your business strategy and working closely with you to deploy AWS infrastructure as a service.

• List the unused data sources: Data sources imported in a workbook but not used are highlighted by the new feature. The developer can remove these data sources from the data source list to make the workbook faster.
• List of unused fields or data columns: Just like the data sources, workbook optimizer also highlights the data columns not used across the workbook. Removing these at the data source level can help improve the overall performance of the workbook.
• List of sheets not used in the dashboard: It is a common practise that developers tend to create sheets not used in the final dashboard. This creates unnecessary clutter and makes the dashboard slower. The workbook optimiser feature gives a list of such sheets which the user can delete to optimise the performance of the workbook further.
• Highlights lengthy calculations: The feature provides a list of calculations which are too complex and in turn reduce the performance of the dashboard. Simplifying a few of these can improve performance to a great extent.

The user will see a screen like below as part of the workbook optimizer. Ask Data Phrase Builder: This feature is available on Tableau Server and Tableau Online Add field would look like as shown in the below screenshot: Customize View Data: This feature is available on Tableau Server, Desktop and Tableau Online This feature enables to reshape the tabular data behind your visualisation in the View data interface. One can create new columns, remove columns from the default view, change the order and sort the data using this feature. This reshaped data can also be exported as csv file to be shared with the team. Change the root table: This feature is available on Tableau Server, Desktop and Tableau Online Managing multiple data tables becomes easier and flexible with this new feature. One can swap any table to be the root table with a single click. This allows one to change the layout of the table quickly, reshape the data with a different root table and delete a specific table without deleting child nodes. For e.g., let us assume a user had to create a data source for an analysis using 3 tables namely ‘customers’, ‘orders’ and ‘returns’. The user creates the data model such that ‘customers’ is the root table followed by ‘orders’ and ‘returns’. But after performing some analysis the user realises that ‘orders’ should be the main root table. In such cases the user would have to re-create the data again from scratch but with the new ‘Swap with root table’ feature user can do the changes with a few clicks. Parameter Enhancements in Tableau Prep In version 2022.1 Tableau Prep is adding even more places where one can use parameters in the flow as well as user enhancements. Now, one can:

• Get a list of all the parameters in one place rather than finding them in the flow. One can delete these parameters directly from the parameter window rather than to find it in the flow first.
• Include parameter names in exported output files.
• Include parameters in SQL scripts that you run before or after writing the flow output to a database. Include parameters in worksheet names when writing the flow output to Microsoft Excel.

New Visualisation Toolbar: Available on Tableau Online and Server The new feature enhances the user dashboard navigation in Tableau Online and Tableau Server. Also, the new toolbar supports embedding for your external applications. However, the available functionality within the toolbar will vary based on the user’s access level. TabPy Model Evaluation Function: This feature is available on Tableau Server, Online and Desktop A new calculation type called MODEL_EXTENSION_X has been added to Tableau specifically to call deployed models from TabPy or other analytics extensions. It gives administrators a new configuration option to control TabPy deployments by disabling the execution of arbitrary Python code. Administrators can now maintain a single source of truth in the Analytics Extension server by leveraging a central version control, while end-users have an improved experience by easily accessing deployed functions on their TabPy server and understanding the model's requirements before adding it to the tool. Apart from the above Tableau 2022.1 has other exciting features the users can look forward to including:

• 1. Improvements in Esri Data Connector
• 2. Addition of new Accelerators
• 3. Added connectors to connect to more data sources

As with the earlier version, Tableau 2022.1 which has addressed a lot of the pain points experienced by its users. Certainly, it has a lot more to offer and enhancements to look forward to. Please download the new version and explore the new features. In case of any challenges while dealing with the new features or in case you need any help related to Tableau development, please reach out to the info@beinex.com. Would be more than happy to help you on the same!

Data preparation is purging imperfectly formed data, reorganising unclean data, and merging various data sets for analysis. Rows and columns in the data structure must be changed, and data types and values must be cleaned up. The amount of time it takes to find insights directly depends on how quickly and well you prepare your data. The entire process can be sped up by being aware of the extent of the data you're studying and observing the modifications you make to the data. With the help of Tableau Prep Builder, data can be combined, shaped, and cleaned more quickly and easily for analysis within Tableau. You can swiftly obtain high-quality data using the linear and visual approach when preparing your data. When ushering in data into a data prep tool, it is always better to know what you're working with and whether you're looking at the complete data set or just a subset. Before you begin cleaning, you might also need to undertake some data research. Five crucial steps are to be taken care of for prepping the data. Let's have a look:

1. Adjust the data sample size

2.Evaluate the data

You'll probably want to start by counting the number of distinct values in each field. A simple check at the column header at the top reveals how many states are represented in the data set. You'll also want to understand how various values connect to identify data outliers or problems. You can utilise highlighting in Tableau Prep to find correlations between different fields. The data grid view is condensed to only display the records with the selected value in the chosen field when you click on a value in the profile pane. Tableau Prep highlights the corresponding values in blue, and the values span areas.

3.Filter the data

Limit the fields you import into Tableau Prep to those you'll need for your analysis to maximise the overall effectiveness of your data preparation process. By filtering your data, you can verify that you're performing the proper analysis while saving time. For instance, if you need to look at sales data from the previous two years, you may use the range or relative date filters to limit the date field to that period. You might want to eliminate any incorrect or irrelevant data. A value in the data pane can be excluded with a single click. You can do this at any time during your flow.

4.Assess and tidy up the data

Tableau's data types will have an impact on your analysis. Therefore, it's critical to correctly identify each field before beginning. Even though Tableau allows you to update aliases, alter data types, split lots, and create calculations, it is far simpler to carry out these tasks beforehand, particularly when preparing the data set for someone else. Tableau Prep includes built-in capabilities to aggregate and replace recurring characters or pronunciation, saving you from having to edit each one individually so that you don't have to; these solutions use algorithms to make cleaning easier. Or, if you foresee a missing value, you may manually add it so that it will be included when the flow processes the complete data set. You can apply a computation if you know that a field must be cleaned or filtered, but it takes more than the user interface offers.

5.Understand the data results

Deciding about the final data set's appearance while you begin to prepare your data can be difficult. For Tableau to effectively analyse your data, you might need to merge numerous data sources or pivot your data from columns to rows. One technique to get beyond this obstacle is visualising the data pane in Tableau Desktop as to how it should appear. Do you have columns with the same value in several places? Should each product be in a single field with the sales transactions stated below, or should each product have its column with the sales transactions listed underneath? The latter is more likely, and a pivot is necessary for this situation. You will be joining the data if you need to combine two tables. By using a join, you can increase the number of fields in your data source that you can investigate. Although a join can be added at any point during the data preparation process, the sooner you use it, the sooner you will comprehend the data set and identify areas that require immediate attention. Like appending two data sets together, a union enables you to do so. For instance, you might have an Excel file where each sheet displays transactions from different years. You may maintain the same structure with extra rows by using a union rather than joining the tables. After your data has been organised, processed, and filtered, it's time to interpret what it is trying to tell you. Tableau Prep connects with your entire business intelligence platform like many other data preparation products. To allow others to begin their analysis, publish the extract to Tableau Server or Tableau Cloud. Bring it into Tableau Desktop to start posing and investigating more in-depth queries. The hardest part of the data analysis process is now complete. It's time to share the breakthroughs that resulted from your hard work.