بينيكس تفتتح مكتبها الرسمي في المملكة العربية السعودية

Will there a storm this week ? Is there a specific wind pattern ? Will you need your snow boots tomorrow? Should you bring an umbrella? Use the Weather forecast analysis using a web data connector to plan and analyze day to day activities and help in making impact full business decisions.

• 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!

For Beinex, being a custodian of data engineering and data analytics technologies, presence of AWS in UAE offers a plethora of opportunities for customers in terms of:

(a) Drawing customer centricity and confidence in data related services increasing productivity

(b) Building highly scalable and efficient data lakes/data warehouses/data marts to create ‘center of excellences in data’

(c) One-stop unified data access, security and governance using AWS data stack, thereby removing multiple overheads and solutions

(d) Building and deploying ML models and integrating with analytics services creating business far-sightedness

(e) Reducing time to market taken by "product based" data analytics solution to blazing fast AWS services boosting innovation

The new AWS Middle East (UAE) Region consists of three Availability Zones (AZs) and becomes AWS’s second region in the Middle East with the existing AWS Region in Bahrain, launched in 2019. The new AWS Region gives organizations even greater choice for running their applications and serving end users from data centers located in the UAE, using advanced AWS technologies to drive innovation.

AWS Regions are composed of Availability Zones that place infrastructure in separate and distinct geographic locations. Availability Zones are located far enough from each other to support customers’ business continuity but near enough to provide low latency for high availability applications that use multiple Availability Zones.

Each Availability Zone has independent power, cooling, and physical security and is connected through redundant, ultra-low latency networks. AWS customers focused on high availability can design their applications to run in multiple Availability Zones to achieve even greater fault tolerance. The launch of the AWS Middle East (UAE) Region will enable local customers with data residency requirements to store data securely in the UAE, while providing customers with even lower latency across the country.

Beinex has prescriptive and predictive data analytics product suites comprising of a mix of services (Redshift, S3, Glue, Athena, Kinesis, EMR etc.) customized along with BI viz platform apps like Tableau & Alteryx, all on the AWS platform. Beinex is also competent in data innovation using AI/ ML stack with Amazon Sagemaker.

The firm is a preferred partner of Aurex, a SaaS based GRC solution. The company has capabilities in data engineering technologies like data ingestion, data lakes, ETL & data transformation, data visualization and AI/ ML models leading to insights generation platforms.

The launch of AWS Middle East (UAE) Region will catalytically encourage the Public Sector to shift to Cloud in a big way. It will drastically alter the way business is conducted in that realm, providing an added boost to the entire region. Besides, the AWS range of services characterized by AI-ML capabilities will facilitate ease of living and convenience in all walks of life across the society.

[sc name="quote" quote="“As a practitioner, I believe that the major game changer in the latest version, Tableau 2023.1, is Accelerator Data Mapping. With Data Mapping you can jump-start your analytics even faster by reducing the time and effort required to set up an Accelerator’s ready-to-use dashboards. Now, when configuring an Accelerator, the Data Mapper allows users to pull outside data into the Accelerator and map fields from their data source into the fields the Accelerator expects. This will be made possible via the Data Mapping UI - a hybrid dialogue box that opens by default with any Data Mapping enabled Accelerator”" author="Sanchit Katiyar, Solution Architect at Beinex."][/sc]

Let’s catch up with Tableau’s brand-new capabilities:

1. Tableau for Slack Enhancements

The Tableau app for Slack has been improved to enhance collaboration on insights. These updates make it simpler to prioritize data in every conversation and decision. New features include the ability to share Tableau content with context using link previews, which helps teams quickly identify and act on pertinent information. Additionally, it's now easier to search for and share Tableau content in direct messages and channels. Finally, you can quickly access your recent and favourite items from the App homepage, making it faster to get to insights.

2. Identity Pools for Tableau Server

Identity Pools provide a way to go beyond the current restriction of having only one identity store on the Tableau Server. An Identity Pool consists of a "Source of Users" (previously known as the Identity Store) and an authentication mechanism. With this feature, you can add more pools where your source of users can belong to a local identity store and authenticate using OpenID Connect for modern authentication. This added flexibility will benefit organizations that have external users who need access to Tableau but cannot be added to their corporate Active Directory.

3. Dynamically Update Axis Titles

Parameters are useful for adding interactivity and flexibility to a visualization. They allow viewers to select how they want to view the data. However, previously, it was not possible to automatically update the axis title.
Dynamic axis titles enable the axis title to be determined by the value of a parameter or a single-value field. This feature allows authors to provide better context for their data visualizations to their audience.

4. Support Internal and External Users on Tableau Server

If you've found the single identity store limitation of Tableau Server to be limiting, you'll be pleased to know that Identity Pools offer a solution. In the past, there were only two types of identity stores, local and external, and changing the configuration required a complete reinstall of the Tableau Server.
Identity Pools allow you to overcome this limitation by creating additional pools that combine a "Source of Users" (previously known as the Identity Store) and an authentication mechanism. You can now have your source of users belonging to a local identity store and authenticate using OpenID Connect for modern authentication. This added flexibility allows you to support both internal and external users who are not part of the corporate Active Directory.

5. Personalize Data Access with User Attributes

The new USER ATTRIBUTE (string) function is now available for personalized data access. This function passes login attributes in a calculation, which can be used as a data source filter for row-level security, beyond just username and group, such as department or region. This allows for the customization of a user's data access in embedded scenarios.
With this new function, you can include additional information about users and send it to Tableau when the users sign in. Tableau will automatically use this information as a filter, only showing corresponding data to the user.
When the filter is applied in your workbook or dashboard, Tableau searches for the value of the attribute in the viewing user's authentication token. Using Connected Apps and SSO for embedding users, you can include the attribute as a claim in the JSON Web Token (JWT) used for user authentication.

How Tableau 2023.1 can be Beneficial to the Tableau Users

With the added new features, you can enjoy the advantages enlisted below:

1. Greater Flexibility and Security for Both Internal and External Users: Tableau Server now offers greater flexibility and security for both internal and external users with the ability to add local identity stores and authenticate using OpenID Connect.
2. Efficient Offline Environment Management: With an enhanced activation solution, managing offline environments is a breeze, thanks to the option to leverage login-based license management.
3. Reliable Tableau Mobile: Tableau Mobile is now even more secure, due to added security policies that prevent screen sharing and screenshots on Android devices, as well as the detection of jailbreak and malware.
4. Connect to Google BigQuery: Connecting to Google BigQuery is now more efficient than ever, be the new JDBC connector that uses BigQuery's Storage API.
5. Resource Monitoring Tool: The tool, which is a component of Tableau Advanced Management, now comes with enhanced features that make logging in easier and allow for more customization options:
6. Network Credentials Support: Users can now use their network credentials to log into the Resource Monitoring Tool instead of using a distinct username and password.
7. Customizable Run As users: With this new feature, you can set up Run As users for the Resource Monitoring Tool Server and Agent on Linux operating systems to comply with your security policies and apply best practices.
8. Tableau Data Management now offers enhanced features that enhance data reliability and flexibility for virtual connections:
9. Data Warnings: Data quality warnings are now available in both web authoring and Data Details to help improve data trust. Users can receive warnings about data quality at the column level.
10. Flexible Connectivity: With the latest update, users can choose to use either a live or extract connection for each table within a virtual connection. This allows them to refresh the data as needed to suit their needs.

Are you as excited as we are about these amazing new features? If so, be sure to get started with Tableau 2023.1 today!

About Beinex+ Tableau Partnership

As a quick, versatile, and easy-to-use self-service platform tailored to your organisational needs, Tableau streamlines the power of data. It enables users to make decisions more quickly and with greater confidence from anywhere, anytime.
As a premium partner, Beinex offers the best of Tableau services to grow your business. Our partnership with Tableau has unveiled several seamless possibilities for businesses. Tableau, with its user-friendliness, makes Data Analysis and Visualization an enjoyable, interesting and rewarding process.

Explore the power of Beinex + Tableau, now: https://www.beinex.com/tableau-partnership-and-consulting-services/

What is Time Series Analysis?

Time series analysis involves examining data that changes over time or where time is a variable in the outcomes. Time isn't just a data point; it's the primary axis on which the data is based.

The main difference with time series analysis is that data is collected at regular time intervals. This helps identify patterns in the data, forming trends, cycles, or seasonal variations. With a consistent time frame of historical data, time series forecasting becomes a valuable tool for predicting future data. Time's crucial role as a variable in data across industries makes time series analysis widely applicable. Explore a few examples outlined below.

6 Real-world Examples of Time Series Analysis in Various Industries

Example 1: Health Authority Enhances Patient Care

Problem: Inefficient resource use and rising costs of care and operations over time.

Solution: Utilizing data analytics, a prominent health authority conducted a comprehensive analysis of patient data. Examining historical data on patient stays, treatments, and conditions, they identified optimal times for administering medication, resulting in reduced average length of stay and cost savings for both patients and the system.
Insight: Time series analysis in healthcare extends beyond patient care to chronic disease research and epidemic-scale studies. Tracking chronic diseases over time and analyzing patient data using time series methods contribute to advancements in the field.

Example 2: Retail Giant Identifies Sales Opportunities

Problem: Slow data analysis affecting decision-making days before events.

Solution: A leading retail giant's front-office team integrated all data sources to gain a comprehensive view. Implementing time series analysis dashboards, they swiftly identified sales opportunities by forecasting against seasonal trends. Proactive measures were taken to increase ticket sales for upcoming events based on real-time insights.
Insight: Time series analysis aids retail giants in making data-driven decisions, predicting consumer trends, and strategizing marketing efforts, ensuring maximum impact.

Example 3: Manufacturing Company Improves Forecasting Accuracy

Problem: Inaccurate and time-consuming operations, manufacturing, and sales forecasting.
Solution: A manufacturing company revamped its forecasting process using time series analysis and modeling. By leveraging better data and faster analysis, they reduced analysis time from one day to one hour. Accurate forecasts in supply chain and manufacturing processes led to significant cost reductions in inventory, supply chain, labor, and capital equipment.
Insight: Time series analysis proves invaluable in optimizing forecasting models, enhancing accuracy, and streamlining operations in manufacturing.

Example 4: Marketing Analytics Scaling for Media Clients
Problem: Evolving marketing technologies making it challenging to quickly analyze information for media clients.
Solution: An analytics firm centralizes over 100 data sources using Tableau, allowing quick data retrieval and the creation of custom dashboards. Time series analysis aids in media forecasting, enabling the firm to develop insightful "what if" analyses. This empowers clients to make informed decisions about marketing investments.
Insight: Time series analysis combined with data centralization is crucial for scaling marketing analytics, providing clients with actionable insights.

Example 5: Streamlining IT Costs Through Self-Service Analytics
Problem: Business decisions based on static reports, consuming time and resources.
Solution: A retail group enables department staff with self-service analytics in Tableau, reducing IT costs by 20%. Time series analysis is applied for accurate forecasting of retail and IT trends, optimizing product orders and resource allocation.
Insight: Time series analysis aids in accurate forecasting for retail and IT trends, optimizing resource allocation, and reducing IT costs.

Example 6: Innovative Use of Data Analytics in Auditing Processes
Problem: Traditional audits were time-consuming and lacked value addition.
Solution: An organization in the energy sector used Tableau to analyze a year's worth of data, uncovering trends in financial processes. This data-driven approach revolutionized their auditing processes, providing deeper insights into the financial health of the organization.
Insight: Time series analysis proves instrumental in data-driven audits, providing a comprehensive view of historical data and uncovering trends for better decision-making.
These real-world examples showcase the versatility and impact of time series analysis across different industries, emphasizing its crucial role in data-driven decision-making and business optimization.