Search

Installation Guide to Jenkins

Jenkins is a Java-based open-source automation tool with plugins designed for ongoing integration. Jenkins is used to constantly develop and test software projects that help developers to incorporate project modifications and make it simpler for users to achieve a new build. The Jenkins allows developers to quickly locate and resolve flaws in a code base and to automatically test their structures. Jenkins can be changed and expanded readily on all operating platforms and various devices, whether OS X, Windows or Linux.  It immediately deploys code, produces test reports. During integration and continuous delivery, Jenkins can be configured according to the demands.System Requirements for Jenkins InstallationFollowing are the software and hardware requirements for installing Jenkins:Minimum hardware requirements:256 MB of RAM1 GB of drive space (although 10 GB is a recommended minimum if running Jenkins as a Docker container)Recommended hardware configuration for a small team:1 GB+ of RAM50 GB+ of drive spaceInstallation on WindowsYou must first install JDK. Jenkins promotes JDK8 only at this time. Jenkins can be installed when Java is running. The recent Jenkins package for Windows (presently version 2.191) can be downloaded from here. Click on the Jenkins exe file to unzip the file into a folder.To begin the installation click on "Next."To install Jenkins in another directory, click the "Change..." button. I'll hold the default choice in this instance and click on "Next."To begin the installation process, click on the "Install" button.The installation is being processed.When finished, you can finish the setup by clicking the "Finish" button.The URL http:/localhost:8080 will automatically be redirected to a Jenkins local page or the browser can be pasted.Copy and paste the password from the C:\Program Files (x85)\Jenkins\secrets\initialAdminPassword file for Jenkins unlocking. Click on the button "Continue."The suggested plugins or chosen plugins that you select can be installed. We will install the suggested plugins to maintain it easy.Wait for the complete installation of plugins.The next step is to build a Jenkins admin user. Click "Save and Continue." Please enter your information.To finish the Jenkins setup, click on "Save and Finish."To begin Jenkins, click on "Start using Jenkins."Below is the default page of Jenkins.Jenkins Installation on Linux/CentOS 7 systemMake sure that you are signed in as a user with sudo privileges before continuing this tutorial.The first step is to install Java, Jenkins being a Java application. To set up OpenJDK 8 package, execute the following command:$ sudo yum install java-1.8.0-openjdk-develJenkins does not currently support Java 10 (and Java 11). Make sure that Java 8 is the default Java version when multiple Java versions are installed on your computer.The next step is to allow the repository of Jenkins. To do so, use the following curl command to import the GPG key:$ curl --silent --location http://pkg.jenkins-ci.org/redhat-stable/jenkins.repo | sudo tee /etc/yum.repos.d/jenkins.repoAdd your system's repository with:$ sudo rpm --import https://jenkins-ci.org/redhat/jenkins-ci.org.keyUpon activation of the repository, install the recent stable Jenkins version by typing:$ sudo yum install jenkinsUpon completion of the installation, begin the Jenkins service with:$ sudo systemctl start jenkinsTo verify if it has been successful, check with below command:$ systemctl status jenkinsSomething like this you should see:Outputjenkins.service - LSB: Jenkins Automation ServerLoaded: loaded (/etc/rc.d/init.d/jenkins; bad; vendor preset: disabled)Active: active (running) since Thu 2018-09-20 14:58:21 UTC; 15s agoDocs: man:systemd-sysv-generator(8)Process: 2367 ExecStart=/etc/rc.d/init.d/jenkins start (code=exited, status=0/SUCCESS)CGroup: /system.slice/jenkins.serviceFinally, allow the Jenkins service to start on system boot $ sudo systemctl enable jenkinsOutputjenkins.service is not a native service, redirecting to /sbin/chkconfig.Executing /sbin/chkconfig jenkins onOpening Firewall portIf you install Jenkins on a remote CentOS firewall-protected server, port 8080 is necessary. To open   the required port, use the following instructions:$ sudo firewall-cmd --permanent --zone=public --add-port=8080/tcpsudo firewall-cmd --reloadSetting JenkinsOpen your browser and type in your domain or IP address followed by port 8080 in order to set your fresh Jenkins setup:http://your_ip_or_domain:8080Below screen will be displayed which prompts you to enter the admin password generated during setup:To print the password on your terminal, use the following instructions: $ sudo cat /var/lib/jenkins/secrets/initialAdminPasswordThe alphanumeric password should be 32 characters long, as shown below:Output 3226*****************************Copy your terminal password, paste it in the password field for the Administrator and click on Continue.On the next screen, you are asked if you would like to install or pick certain plugins. To begin the installation process instantly, just click on the Install suggested plug-ins box.When the installation is finished, the first administrative user is prompted for the setting. Fill in all the necessary data. and click the Save and Continue.On your next page, the URL for the Jenkins instance will be requested. An automatically produced URL will be added to the URL field.To finish the configuration, click the Save and Finish button to verify the setup.Finally,  click start using  Jenkins Button to start the process and the user we created in one of the past steps as admin user will log in Jenkins dashboard.You have effectively mounted Jenkins on your CentOS scheme when you have reached this point.Jenkins Installation on MacPrerequisiteA Mac machine with Mac OSX Yosemite or higher with admin accessInstallation of Java Development Kit on the machine.Access to Git, Svn, etc. remote repository.Download Jenkins installer.pkg file from Jenkins ' official website and get through the wizard setup.The jenkins setup wizard sets up a distinct Jenkins user on your system.We need to make some changes in the ‘Users & Groups’ section as well. Do follow below steps.Open ‘System Preferences -> Users & Groups’Click on the Lock icon located in the bottom left corner which reads, ‘Click the lock to make changes’. Enter your login password.Under the ‘Other Users’ section you may see the user without any name but with admin rights. This is our Jenkins user. Let's rename it.Right-click the empty user and select Advanced Options. This will show you all the details. Give the ‘Full name’ as Jenkins. Press OKClick on ‘Reset Password’. Enter a new password and make sure that you remember this.Now our Jenkins user is almost ready.This is just like another mac user with admin rights.Now restart your Mac machine and log in with Jenkins user with the password which you just reset.Click the lock to save the changes and restart the system to login with Jenkins user account.In localhost Jenkins resides at port 8080.Open your browser, go to localhost:8080 and make the original set-up, which consists of installing some plugins and creating account for safety purpose.Setting Jenkins as Launch agentJenkins operates by default as a daemon. A daemon is a non-interactive background that operates in the entire scheme and is not linked to a particular user.Much of CI runs simulators and other GUI apps, so another option is required. You can modify Jenkins as a launch agent to resolve this. On behalf of the user, a launch agent operates behind the scenes.You need to edit the settings folder and alter your place to begin rebooting automatically if you want to alter how the Jenkins process is started.Enter the below command to unload Jenkins as a Daemonsudolaunchctlunload/Library/LaunchDaemons/org.jenkins-ci.plistNext, migrate to the LaunchAgents folder the.plist file which defines how Jenkins will be running.sudo mv /Library/LaunchDaemons/org.jenkins-ci.plist /Library/LaunchAgents/Start the jenkins again and now it will run as launch agent.
Installation Guide to Jenkins
Ashish
Rated 4.5/5 based on 25 customer reviews
Ashish

Ashish Kumar

Senior Technology Specialist

Ashish is working as a Senior Technology Specialist in leading financial bank has more than 13 years of experience in developing enterprise applications

Posts by Ashish Kumar

Installation Guide to Jenkins

Jenkins is a Java-based open-source automation tool with plugins designed for ongoing integration. Jenkins is used to constantly develop and test software projects that help developers to incorporate project modifications and make it simpler for users to achieve a new build. The Jenkins allows developers to quickly locate and resolve flaws in a code base and to automatically test their structures. Jenkins can be changed and expanded readily on all operating platforms and various devices, whether OS X, Windows or Linux.  It immediately deploys code, produces test reports. During integration and continuous delivery, Jenkins can be configured according to the demands.System Requirements for Jenkins InstallationFollowing are the software and hardware requirements for installing Jenkins:Minimum hardware requirements:256 MB of RAM1 GB of drive space (although 10 GB is a recommended minimum if running Jenkins as a Docker container)Recommended hardware configuration for a small team:1 GB+ of RAM50 GB+ of drive spaceInstallation on WindowsYou must first install JDK. Jenkins promotes JDK8 only at this time. Jenkins can be installed when Java is running. The recent Jenkins package for Windows (presently version 2.191) can be downloaded from here. Click on the Jenkins exe file to unzip the file into a folder.To begin the installation click on "Next."To install Jenkins in another directory, click the "Change..." button. I'll hold the default choice in this instance and click on "Next."To begin the installation process, click on the "Install" button.The installation is being processed.When finished, you can finish the setup by clicking the "Finish" button.The URL http:/localhost:8080 will automatically be redirected to a Jenkins local page or the browser can be pasted.Copy and paste the password from the C:\Program Files (x85)\Jenkins\secrets\initialAdminPassword file for Jenkins unlocking. Click on the button "Continue."The suggested plugins or chosen plugins that you select can be installed. We will install the suggested plugins to maintain it easy.Wait for the complete installation of plugins.The next step is to build a Jenkins admin user. Click "Save and Continue." Please enter your information.To finish the Jenkins setup, click on "Save and Finish."To begin Jenkins, click on "Start using Jenkins."Below is the default page of Jenkins.Jenkins Installation on Linux/CentOS 7 systemMake sure that you are signed in as a user with sudo privileges before continuing this tutorial.The first step is to install Java, Jenkins being a Java application. To set up OpenJDK 8 package, execute the following command:$ sudo yum install java-1.8.0-openjdk-develJenkins does not currently support Java 10 (and Java 11). Make sure that Java 8 is the default Java version when multiple Java versions are installed on your computer.The next step is to allow the repository of Jenkins. To do so, use the following curl command to import the GPG key:$ curl --silent --location http://pkg.jenkins-ci.org/redhat-stable/jenkins.repo | sudo tee /etc/yum.repos.d/jenkins.repoAdd your system's repository with:$ sudo rpm --import https://jenkins-ci.org/redhat/jenkins-ci.org.keyUpon activation of the repository, install the recent stable Jenkins version by typing:$ sudo yum install jenkinsUpon completion of the installation, begin the Jenkins service with:$ sudo systemctl start jenkinsTo verify if it has been successful, check with below command:$ systemctl status jenkinsSomething like this you should see:Outputjenkins.service - LSB: Jenkins Automation ServerLoaded: loaded (/etc/rc.d/init.d/jenkins; bad; vendor preset: disabled)Active: active (running) since Thu 2018-09-20 14:58:21 UTC; 15s agoDocs: man:systemd-sysv-generator(8)Process: 2367 ExecStart=/etc/rc.d/init.d/jenkins start (code=exited, status=0/SUCCESS)CGroup: /system.slice/jenkins.serviceFinally, allow the Jenkins service to start on system boot $ sudo systemctl enable jenkinsOutputjenkins.service is not a native service, redirecting to /sbin/chkconfig.Executing /sbin/chkconfig jenkins onOpening Firewall portIf you install Jenkins on a remote CentOS firewall-protected server, port 8080 is necessary. To open   the required port, use the following instructions:$ sudo firewall-cmd --permanent --zone=public --add-port=8080/tcpsudo firewall-cmd --reloadSetting JenkinsOpen your browser and type in your domain or IP address followed by port 8080 in order to set your fresh Jenkins setup:http://your_ip_or_domain:8080Below screen will be displayed which prompts you to enter the admin password generated during setup:To print the password on your terminal, use the following instructions: $ sudo cat /var/lib/jenkins/secrets/initialAdminPasswordThe alphanumeric password should be 32 characters long, as shown below:Output 3226*****************************Copy your terminal password, paste it in the password field for the Administrator and click on Continue.On the next screen, you are asked if you would like to install or pick certain plugins. To begin the installation process instantly, just click on the Install suggested plug-ins box.When the installation is finished, the first administrative user is prompted for the setting. Fill in all the necessary data. and click the Save and Continue.On your next page, the URL for the Jenkins instance will be requested. An automatically produced URL will be added to the URL field.To finish the configuration, click the Save and Finish button to verify the setup.Finally,  click start using  Jenkins Button to start the process and the user we created in one of the past steps as admin user will log in Jenkins dashboard.You have effectively mounted Jenkins on your CentOS scheme when you have reached this point.Jenkins Installation on MacPrerequisiteA Mac machine with Mac OSX Yosemite or higher with admin accessInstallation of Java Development Kit on the machine.Access to Git, Svn, etc. remote repository.Download Jenkins installer.pkg file from Jenkins ' official website and get through the wizard setup.The jenkins setup wizard sets up a distinct Jenkins user on your system.We need to make some changes in the ‘Users & Groups’ section as well. Do follow below steps.Open ‘System Preferences -> Users & Groups’Click on the Lock icon located in the bottom left corner which reads, ‘Click the lock to make changes’. Enter your login password.Under the ‘Other Users’ section you may see the user without any name but with admin rights. This is our Jenkins user. Let's rename it.Right-click the empty user and select Advanced Options. This will show you all the details. Give the ‘Full name’ as Jenkins. Press OKClick on ‘Reset Password’. Enter a new password and make sure that you remember this.Now our Jenkins user is almost ready.This is just like another mac user with admin rights.Now restart your Mac machine and log in with Jenkins user with the password which you just reset.Click the lock to save the changes and restart the system to login with Jenkins user account.In localhost Jenkins resides at port 8080.Open your browser, go to localhost:8080 and make the original set-up, which consists of installing some plugins and creating account for safety purpose.Setting Jenkins as Launch agentJenkins operates by default as a daemon. A daemon is a non-interactive background that operates in the entire scheme and is not linked to a particular user.Much of CI runs simulators and other GUI apps, so another option is required. You can modify Jenkins as a launch agent to resolve this. On behalf of the user, a launch agent operates behind the scenes.You need to edit the settings folder and alter your place to begin rebooting automatically if you want to alter how the Jenkins process is started.Enter the below command to unload Jenkins as a Daemonsudolaunchctlunload/Library/LaunchDaemons/org.jenkins-ci.plistNext, migrate to the LaunchAgents folder the.plist file which defines how Jenkins will be running.sudo mv /Library/LaunchDaemons/org.jenkins-ci.plist /Library/LaunchAgents/Start the jenkins again and now it will run as launch agent.
Rated 4.5/5 based on 25 customer reviews
9051
Installation Guide to Jenkins

Jenkins is a Java-based open-source automation too... Read More

How to Install Docker on Windows, Mac, & Linux: A Step-By-Step Guide

Docker is intended to benefit developers and system managers and makes it a component of a number of toolchains for DevOps (developers + activities). This implies that designers can concentrate their attention on writing code without worrying about the scheme that it will eventually run on. It also gives them the opportunity to take advantage of one of the thousands of programs intended to operate as part of their implementation in a container at Docker. Docker offers flexibility for the operational team and decreases possibly a smaller overhead footprint and lower overhead the number of devices required.Let’s now deep dive into installation steps for docker on different platforms.Install Docker on Windows The community version of Docker for Microsoft Windows is Docker Desktop for Windows.Download from Docker Hub. System RequirementsThe software and hardware requirements need to operate Client Hyper-V on Windows 10 effectively are:Software Requirements:Windows-10 64-bit system requirements: Pro, Enterprise or EducationWindows characteristics of Hyper-V and Containers must be activatedHardware Requirements:The support for virtualization of hardware-level Client Hyper-V in BIOS settings must be allowed with the 64-bit processor with second-level address translation (SLAT). Minimum 4 GB RAMTo run Docker Desktop, Microsoft Hyper-V is needed. The Windows installer Docker Desktop allows Hyper-V and restarts your computer if needed. VirtualBox no longer operates when Hyper-V is activated. All VirtualBox VM images are however maintained.The DOCKer VMs (including the default one generated during the installation of the Toolbox) are no longer started. VirtualBox The Docker desktop can not use these VMs side-by-side. You can still handle remote VMs using the docker.What is included in Installation?The installation of Docker Desktop consists of the Docker Engine, Docker CLI, Docker Compose, Docker Machine, and Kitematic. Docker Desktop containers and images are shared among all user accounts on the machines where they are installed. All Windows accounts are building and running containers using the same VM. Nested virtualization situations, such as operating Docker Desktop with VMWare or Parallels, might operate. See Running Docker Desktop in nested situations for more data.Installation steps To run the installer, double-click Docker Desktop Installer.exe to install Docker Desktop on Windows. The installer can be accessed from Docker Hub if you have not previously downloaded (Docker Desktop Installer.exe). It typically downloads to your download directory or can be executed at the bottom of your internet browser from the latest download bar.Follow the installation wizard directions for licensing, authorizing the installer and proceeding with the installation. If advised, authorize your system password during the installation of the Docker Desktop Installer. The networking elements, connections to the applications of Docker and the management of Hyper-V VMs need to be privately accessible.Click Finish in the setup window and launch the application Docker Desktop.Start Docker DesktopAfter installation, Docker Desktop will not begin automatically. Search for Docker and select the search outcomes for Docker Desktop.If the whale icon remains stable in the status bar, Docker Desktop is up and running and can be accessed from any terminal window.You also get a pop-up message with the next steps, as well as a link to this documentation, after the Docker Desktop app is installed.When you're done initializing, click on the whale icon in the Notifications region and pick About Docker to check that your recent version is available.Install Docker on MacThe very first step is to download the Docker Toolbox for Mac. Get the downloadable link- Download from Docker HubSystem RequirementDocker Desktop for Mac starts only when all these requirements can be met:Mac hardware must be 2010 models or newer, including Extended Page Tables (EPT) and Unrestricted Mode, with Intel hardware to provide memory management unit (MMU) virtualization. This support can be checked to see if the following command is being run on your computer: sysctl kern.hv_supportmacOS Sierra 10.12 and newer versions of macOS are endorsed. The upgrade to the newest version of macOS is recommended.VirtualBox (incompatible with Docker Desktop on Mac) before version 4.3.30 must not be installed. It's alright if you have a newer VirtualBox version installed.Installation stepsDouble-click Docker.dmg and drag the whale Moby to the application folder to open the installer.In the Applications directory, double-click Docker.app to launch Docker. In the instance below, the applications folder is in the Grid view modeYou are led to allow Docker.app with your system password after starting it. Privileged access is required to install Docker app connections and networking elements.The whale in the top status bar shows that Docker runs from a terminal and is available.You will also get a success message, with the next steps and a link to this documentation, if you have just installed the app. To reject this pop-up, click on the whale in the status bar.To get Preferences and other options, click on the whale (whale menu).To check that you have the latest version, select About Docker.Notes:Getting started provides an overview of Docker Desktop for Mac, basic Docker command examples, how to get help or give feedback, and links to all topics in the Docker Desktop for Mac guide.Troubleshooting describes common problems, workarounds, how to run and submit diagnostics, and submit issues.Install Docker on LinuxLet’s use a Ubuntu example to begin installing Docker. If you don't already have it, you can use Oracle Virtual Box to install a virtual Linux example. A straightforward Ubuntu server mounted on the Oracle Virtual Box is shown in the following screenshot. There is an OS user called a demo defined with full root access to the scheme:Step 1 − We must first make sure you have the correct version of the Linux kernel running before installing Docker. Only version 3.8 or greater is intended for Docker on Linux kernel. We can do this with the instructions below.Uname: The system data for the Linux system is returned by this method. This method will return the kernel name, kernel release, kernel version information on the Linux system.uname -aa − Used for ensuring the return of the system data.Step 2 − You need to install packages from the internet onto the Linux system via the following command, the recent packages can be updated to the OS.apt-get Optionssudo− The sudo command is used to make sure the command runs with root access.update− Update option ensures that all packages on the Linux system are updated.sudo apt-get update Step 3- The next step is to install the certificates needed to later download required Docker packages for a job with the Docker site. The following command can be used.sudo apt-get install apt-transport-https ca-certificates Step 4− Adding fresh GPG key will be the next step. This key must guarantee that the required packages for Docker are all encrypted.This command is intended to download the key from hkp:/ha.pool.sks-keyservers.net:80 and add it to the adv keychain by means of the ID58118E89F3A912897C070ADBF76221572C52609D. Please note that to download the necessary Docker packages, this specific key is needed.Step 5 − Next, you need to add the appropriate site to docker.list of the apt package manager, depending on the version of Ubuntu which you hold, to allow it to detect and download the Docker packages from the Docker site.Precise 12.04 (LTS) ─ deb https://apt.dockerproject.org/repoubuntu-precise mainTrusty 14.04 (LTS) ─ deb https://apt.dockerproject.org/repo/ ubuntu-trusty mainWily 15.10 ─ deb https://apt.dockerproject.org/repo ubuntu-wily mainXenial 16.04 (LTS) - https://apt.dockerproject.org/repo ubuntu-xenial mainecho "deb https://apt.dockerproject.org/repo ubuntu-trusty main”     | sudo tee /etc/apt/sources.list.d/docker.listStep 6 –The next step is to update the packages on Ubuntu scheme with the apt-get update command.Step 7 ‐ if we want to make sure that the package manager points towards the correct repository then we can do this by issuing the apt-cache command.apt-cache policy docker-engineStep 8– Edit the update command apt-get to guarantee that all local system packages are up-to-date.Step 9- The Linux-image-extra-* kernel packages that allow the user to use the aufs storage driver are required for Ubuntu Trusty, Wily and Xenial. The newer variants of Docker use this engine.The following command can be used:sudo apt-get install linux-image-extra-$(uname -r)  linux-image-extra-virtualStep 10− Installing Docker is the final step and this can be done with the following command:sudo apt-get install –y docker-engineHere, apt-get utilizes the installation feature to download and install Docker from the Docker page. The Docker engine is the official package for Ubuntu based devices by the Docker Corporation.The docker running version can be checked by running below command:docker version
Rated 4.5/5 based on 10 customer reviews
5924
How to Install Docker on Windows, Mac, & Linux...

Docker is intended to benefit developers and syste... Read More

Tableau Vs QlikView

What is Tableau?Tableau stands as the most powerful and fastest-growing data visualization tool which is being used in the Business Intelligence Industry. Its basic funda is to simplify raw data into a format that can be easily understandable. Data analysis has become very quick with Tableau and the dashboards and worksheets are the forms of visualization that are being created.The best part is that Tableau is a market-leading BI tool as well as the most trending tool used to visualize and analyze the user's data in a very easily digestible format.It also enables the user to work on live data-set and spend quality time on data analysis rather than data wrangling.Usage of Tableau software are listed below:They are used to translate queries into visualization.Managing metadata is also feasible through Tableau.It can even import data of all sizes and ranges.In the case of the non-technical user as well as Tableau acts as a  lifesaver as it offers the facility to create ‘no-code’ data queries.What is QlikView?When we talk about the most flexible Business Intelligence platform for turning data into knowledge then Qlikview comes into the picture. There are more than  24,000 organizations worldwide have enabled their users to easily consolidate, search, and analyze visually all their data by using QlikView.List of the top companies using QlikViewCompanyWebsiteCountryRevenueCompany SizeRed Hat Incredhat.comUnited States>1000M>10000Centerstone of Tennessee,Inc.centerstone.orgUnited States50M-100M1000-5000Robert Walters Plcrobertwalters.comUnited Kingdom>1000M1000-5000Nigel Frank International Limitednigelfrank.comUnited Kingdom200M-1000M1000-5000Axtriaaxtria.comUnited States10M-50M500-1000The wide scope of this software lies in its simplicity of usage. The creation of dashboards for analytical purposes is done by its reporting tools.The era of modern analytics truly began with the launch of QlikView. It actually revolutionized the way organizations lets its user create data with the intuitive visual discovery that put business intelligence in the hands of more people than ever.Enterprise-scale analytics is also being performed with utmost ease and credibility.Usage of Qlikview software are listed below:Flexible Business Intelligence platform for converting data into knowledge.Consolidating, searching and visually analyzing data with simplicity.Even data discoveries in order to support decision making for end-users in the business.Key Difference between Tableau and QlikViewA quick view of the difference between Tableau and QlikViewFeaturesTableauQlikviewPerformanceProcesses data slower than QlikviewCombines large and complex data at a faster rateSpeedSlow in the data processingData processing and accessing is fasterCostCheaperBit costlyBig data supportGoodAverageMultidimensional CubesGoodLimitedVisualizationSimple and interactiveExcellentCustomizationSimpleComplex toolLet’s understand the differences brieflyEase of UseEverybody can analyze information with intuitive products for drag & drop. No programming, only insight. The user can easily create their own perception using various objects and it's easy to use because of a well designed GUI interface. Tableau offers a storytelling feature that can allow us to create a presentation using data points that are available. It does not provide a feature to search content across all the user's dataThe best quality of Qlikview is it's easy to use the feature and even exploring the hidden trends.QlikView offers an associative technology that enhances the capacity of the presentation. This feature helps companies understand hidden links between data points. In the case of searching any data, we just need to type the word in the search box resulting in instant and   It also shows in-depth connections and relationships across the data. At times it becomes difficult for users to design their own views due to properties that are menu-driven.Ease of LearningTableau has community and resources which are actively engaged. The drag & drop application even makes it very easy to learn for the end-users.QlikView also has actively engaged community and resources which ultimately helps the user learn this software in the best possible way.CostTableau: Here are Tableau’s new monthly prices: Tableau Desktop Personal, $35; Tableau Desktop Professional, $ 70; Tableau Server, $35; and  Tableau Online, $42. Under the old model, a license, with annual maintenance, costs $999 for Desktop Personal and $1,999 for Desktop Professional. The server starts at $10,000 for 10 people, and Online is $500 per user per year.Qlikview: The personal edition in Qlikview is absolutely free with a limitation of no feature for document sharing. Per named user license is $1,350 and $15,000 for a concurrent user. Per Server license cost around $35,000. Additionally we require to pay $21,000/server in case of PDF distribution service; $22,500 for SAP NetWeaver connector.Might even require upgradation of RAM if the concurrent users are larger in number.Data VisualizationTableau is one of the industry's leading instruments for data visualization. Today, companies are investing more in information segmentation, clustering, and stronger analysis. It offers a user-friendly interface that enables even non-technical users to generate tailored dashboards rapidly and easily to give significant perspectives in a wide range of company data.QlikView, on the contrary, offers normal report creation characteristics, visualization templates, configurable graphs, and customized opinions that assist provide an interactive report in real-time. All the visualizations and data sets are shown as a quick reference when QlikView is in use. Qlik's product provides an in-memory engine that can view patterns and produce associative analytics that alone can not be achieved with SQL. The In-Memory Engine is able to integrate with diverse information source variants and create a unified dashboard that shows analyses, KPIs and metrics of our concern.Connectivity with Other tools/ Language or DatabaseTableau integrates successfully with a wide range of data sources which includes the spreadsheets, CSV, SQL databases, Salesforce, Cloudera Hadoop, Firebird, Google Analytics, Google BigQuery, Hortonworks Hadoop, HP Vertica, MS SQL Server, MySQL, OData, Oracle, Pivotal Greenplum, PostgreSQL, Salesforce, Teradata, and Windows Azure Marketplace. It can also coordinate with sources of Big data as well.Qlikview also integrates with high range of data sources like Amazon Vectorwise, EC2, and Redshift, Cloudera Hadoop and Impala, CSV, DataStax, Epicor Scala, EMC Green Plum, Hortonworks Hadoop, HP Vertica, IBM DB2, IBM Netezza, Infor Lawson, Informatica Powercenter, MicroStrategy, MS SQL Server, My SQL, ODBC, ParAccel, Sage 500, Salesforce, SAP, SAP Hana, Teradata, and many more. In this case, API integration can be used to connect with R. It can also readily connect with Big data sources.DeploymentSince tableau does not have their own data warehouse hence they have to generate layers while connecting with data set. The deployment becomes easier here since it needs more structured data.QlikView has its own data warehouse with an additional feature of scripting which acts as a feature in the cap leading to the use of multilevel layers in its deployment. QlikView is readily deployable and configurable and starts producing excellent reports immediately after the installation. An additional feature involves enabling interactive queries and creation of reports—a technology which is not found in other products since this product does not use cubes; hence loads all the tables and charts found in the memory. Both 32 and 64 bit can be used for the development. Data modeling becomes easier because of associative technology.SpeedIn the case of Tableau the speed varies based on two parameters, first being the RAM and second being the source's database. Tableau makes it extremely effective to produce in a matter of minutes of interactive views and reports. Tableau can also speed up the entire process since it enables online and offline report sharing.  In Quikview the Speed is dependent on only the source's RAM.QlikView offers quick assessment, outcomes, and allows for much quicker decision-making in comparison to traditional techniques.Valuable Insight GenerationTableau has an excellent storytelling feature that helps the user to create effective presentations, using the available data sources.In Qlikview the Associative technology makes it more impressive and it also helps to read association between variables readily. This unique feature sometimes even benefits businesses to understand the hidden relation between the data points.MobilityTableau is readily available on all devices and can be accessed via the internet. We can even use it on our laptop, tablet or smartphones as well.QlikView is independent of any device thus we can easily access it from anywhere hence decision making becomes much prompt and quicker as compared to the traditional methods of data visualization.SecurityTableau provides excellent security features and it is highly handled by Tableau server. It is indeed a modern enterprise analytics platform that enables the users to avail the self-service analytics at scale with proper governance. Security is the first and foremost critical part of a data and content governance strategy. It's server actually provides comprehensive features along with deep integration to address all the aspects of enterprise security present. Tableau also renders the organizations in promoting trusted data sources for all users, so the right data is used to make the right decisions within seconds.PerformanceWhen compared with Qlikview, Tableau generates the output slower since it uses the cubing technique for data visualization. QlikView seamlessly combines all sizes of datasets hence are quicker when compared with Tableau.ScalabilityQlikView is a lot more scalable than Tableau. The  Qlik Sense applications can be easily scaled especially while dealing with big data. But we cannot deny the fact that both the vendors handle a huge amount of data successfully. In Fact, most of the organizations do not produce the amount of data that both these can handle individually.Big Data SupportTableau has good support for Big data as compared to Qlikview.CustomizationSimple drag and drop features are available in Tableau. Qlikview is Complex tools when compared with Tableau.ConclusionIn brief, the reply to the question:' Which is the best tool for data visualization? It's pretty subjective. Users find out the demands of their business or their projects, which is a matter of personal preference. In both Tableau and QlikView, all the points listed above in this blog illustrate the possible regions where consumers can assess and comprehend their possibilities and then decide in an informed fashion which ones to use.Want a career in Tableau and QlikView? Then taking up training in  Tableau and  QlikView would be an added advantage.
Rated 4.5/5 based on 43 customer reviews
11661
Tableau Vs QlikView

What is Tableau?Tableau stands as the most powerfu... Read More

The Architecture of Power BI

The main element of the drive to be agile, competitive, and efficient is business intelligence. As companies develop, the regular generation of information becomes very hard to handle. This, in turn, generates a road-block for data-driven businesses that want to use their data to drive company decision-making.In addition, the siloing impact and biased reporting structures across companies generate a scenario where decision-makers are compelled to make choices based on information that is partly accurate.This is why smart business systems are largely embraced. Establishing an analytical system to efficiently analyze data helps a company find helpful information, propose conclusion and promote improved decision-making. With its demonstrated technology track record, Microsoft has come to the fore with the implementation of its convincing analytics instrument,  Power BI. This report authoring tool enables businesses to readily visualize and analyze their business information to transform their activities. Here in this article, we will see various components included in Power Bi architecture. This guide will help you in  installing Power BI.Microsoft Power BI ArchitecturePower BI architecture consists of four steps. Let's look at them in detail:Sourcing DataTransforming InformationReport & PublishCreating a Dashboard1. Sourcing Data: Power BI can supply information from a wide range of internet facilities and file kinds. The information can be imported into Power BI or a live service link can be established to receive the information. If you import a Power BI file, it limits the compressed data sets to 1 GB. If the information set exceeds 1 GB, then the direct query may be used. For big information sets, there are two other choices.                     Power BI premium                      Azure analytics servicesList of Data Sources supported in Power BIFiles:Excel, XML, JSON, Text/CSV,Folder and SharePoint FolderDatabase:SQL Server Database, Access Database, SQL Server Analysis Services Database, SAP HANA Database, SAP Business Warehouse server, Amazon Redshift, Impala, Google BigQuery (Beta), Snowflake,Oracle Database, IBM DB2 Database, IBM Informix database (Beta), IBM Netezza (Beta), MySQL Database, PostgreSQL Database, Sybase Database, Teradata DatabaseAzure:Azure SQL Database,  Azure SQL Data Warehouse, Azure Analysis Services database (Beta), Azure Blob Storage, Azure Table Storage, Azure Cosmos DB (Beta), Azure Data Lake Store, Azure HDInsight (HDFS), Azure HDInsight Spark (Beta)Online Services:Power BI service, SharePoint Online List, Microsoft Exchange Online, Dynamics 365 (online), Dynamics 365 for Financials (Beta), Common Data Service (Beta), Microsoft Azure Consumption Insights (Beta), Visual Studio Team Services (Beta), Salesforce Objects, Salesforce Reports, Google Analytics, appFigures (Beta), comScore Digital Analytix (Beta), Dynamics 365 for Customer Insights (Beta), Facebook, GitHub (Beta), Kusto (Beta), MailChimp (Beta), Mixpanel (Beta), Planview Enterprise (Beta), Projectplace (Beta), QuickBooks Online Other:Vertica (Beta), Web, SharePoint List, OData Feed, Active Directory, Microsoft Exchange, Hadoop File (HDFS), Spark (Beta), R Script, ODBC, OLE DB, Blank Query2. Transforming information:After the information is imported into the Powerbi system, power bi offers a preview window for selecting columns or entities. There are many transformation choices available to perform the job if you need to edit the query.3. Report & Publish:We are prepared to produce reports after sourcing and editing the information. Reports are data visualization with filters and slicers in the form of graphs, charts and pie charts. A lot of custom visualization is also available. We can publish them to power bi facilities after generating reports. You can also publish them on the energy bi server assumption.4. Creating a Dashboard:We can create dashboards after publishing reports to Power BI services by pinning the individual elements or by pinning the page of the live report. The visual maintains the filter setting chosen when the report is saved when pinning the individual components. By choosing slicers and filters, pinning the Live Report page enables the dashboard user to communicate with the visual.Components in Power BIThere are four major components in Power BI which play an important role in delivering Power BI capabilities- 1. Power BI Desktop:Power BI Desktop is free software that allows you to connect, convert and visualize your information on your local desktop. You can connect to various distinct information sources with Power BI Desktop and combine them (often called modeling) into a data model that allows you to create graphics and collections of images that you can share with other individuals within your organization as records. Most users working on Business Intelligence projects use Power BI Desktop to generate reports and then use Power BI to share their reports with others.2. Power BI Gateway:The on-site Power BI gateway can be used to maintain your information fresh by linking to your on-site information sources without moving the information. It enables you to query big datasets and take advantage of current investments. By linking to your on-site information sources without the need to transfer the information, you can keep your information fresh with the on-site gateways. Request big datasets and take advantage of current investments. The gateways provide the flexibility you need to satisfy your organization's individual requirements and needs.3. Power BI Mobile Apps:You can remain linked to your information from anywhere using Power BI mobile applications. For Windows, iOS, and Android platform, Power BI applications are accessible.4. Power BI Service:This is a cloud service for publishing Power BI accounts and visualization of information. It allows designers and BI experts to generate and distribute extremely formatted, pixel-perfect reports alongside their interactive Power BI content, becoming the first cloud BI solution combining the energy of self-service BI with traditional Enterprise BI scenarios ' requirements and capacities.There are other components as well which we should understand to get benefits of advanced capabilities of Power BI.5. Power Query:Mashup data and instrument for conversion. You can connect to many distinct information sources with Power Query in Power BI, turn the information into the form you want, and be able to generate reports and ideas rapidly. Power Query functionality is given in the Power Query Editor when using Power BI Desktop. Power Query is made available in Power BI Desktop through Power Query Editor. To launch Power Query Editor, select Edit Queries from the Home tab of Power BI Desktop.6. Power Q&A:Natural Language Question and Reply Engine. Sometimes asking a question using natural language is the fastest way to get a response from your information. The Power BI Q&A function allows you to use your own phrases to explore your information.  Q&A is discussed in distinct papers in the Power BI mobile applications and Q&A with Power BI Embedded.7. Power Map: 3D Geospatial Data Visualization Tool.8. Power Pivot:Power Pivot is an element that models information in memory that allows highly compressed data storage and incredibly quick aggregation and calculation. It is also accessible as part of Excel and can be used within an Excel workbook to build a data model. Power Pivot can load information on its own, or Power Query can load information into it. It is highly comparable to the tabular model of SSAS (SQL Server Analysis Services), which is like a Power Pivot server-based variant.9. Power View:Power View is an interactive visualization instrument that offers a drag-and-drop interface for users to quickly and easily create information visualizations in their Excel workbooks (using the Power Pivot data model).10. SSRS Reporting services 2016:The integration between SQL Serb Reporting and the Power BI Services takes SSRS tiles to a Power BI dashboard with planned SQL Server Agent updates. This integration gives you the tile from SSRS reports. Integrating SSRS reports into the Power BI service will generate a connection to comprehensive SSRS reports from the Power BI dashboard.Clusters in Power BI Architecture The Power BI service is based on Azure, the cloud computing platform of Microsoft. Power BI is currently being deployed in many data centers around the world–there are many active deployments made available to customers in the regions served by those data centers, and an equal number of passive deployments serving as backups for each active deployment.Each deployment of Power BI comprises of two clusters–a cluster of Web Front End (WFE) and a cluster of Back End. The following picture shows these two clusters :1. WFE Cluster:The WFE cluster manages the original Power BI link and authentication process using AAD to authenticate customers and provide tokens for subsequent Power BI customer links. Power BI also utilizes the Azure Traffic Manager (ATM) to guide customer traffic to the closest datacenter, which is determined by the client's DNS record trying to link, authenticate and download static content and files. Using the Azure Content Delivery Network (CDN), Power BI effectively distributes the required static content and files to customers based on geographic location.2. Backend Cluster:How authenticated customers interact with the Power BI service is the Back-End cluster. The Back-End cluster manages visualization, user dashboards, datasets, reports, data storage, information links, information refresh, and other elements of Power BI service interaction. The Role Gateway functions as a gateway between customer demands and the service Power BI. Users are not directly interacting with positions other than the role of the Gateway. The Gateway Role will ultimately be managed by Azure API Management.How Power BI can be a game-changer for the enterprise?Power BI combines centralized DW / BI strategies with cloud data sources and self-service tools through its data catalog and data management gateway, as no other platform has yet been able to do. And as a SaaS solution, all its functionality is packaged so that it can be easily implemented and used by any organization.  In brief, Power BI can speed up the adoption curve and make sophisticated BI Analytics as prevalent as Excel itself.Power BI provides all BI system stakeholders with game-changing capabilities: 1. End-users:End-users wanted the capacity to access and evaluate information readily for a long time. The natural language query of Q&A and the smart visualization engine will do more to encourage each worker to use data as a basis for decision making.2. BI Analysts:Power Pivot provided power users with the capacity to create effective data models over big amounts of data, but the information required to "fit" into clean data models.  The data transformation and flexibility of Power Query further empowers analysts to rapidly create their own end-to-end alternatives.3. IT & Data Managers:BI self-service has always been a subject of push-pull. Everyone wants the instruments and data that consumers need to create excellent choices. However, good governance, safety, and auditing are often seen as a roadblock for power users to make progress.  The Power BI information catalog is interesting because it simultaneously encourages self-service and governance.Not every organization will move rapidly to embrace Power BI. For some, too much strategic shift will be represented too rapidly.  There may be truly regulatory or other reasons for others that prevent cloud-based systems from being considered. But setting up an accessible and robust BI platform was challenging and cost-prohibitive for many organisations.  Power BI can be the solution that ultimately makes sophisticated BI as simple and widely accepted as a search engine to use.
Rated 4.5/5 based on 47 customer reviews
6561
The Architecture of Power BI

The main element of the drive to be agile, competi... Read More

Tableau Installation and Configuration on Mac and Windows

Tableau is one of the most widely used data visualization tools across the industry.  It is primarily used for business intelligence. In today’s world where organizations have a large amount of data coming from different sources & platforms, it is very important to understand the trends which help businesses to drive strategy and take some important decisions. The data visualization tool plays a key role in that area. In the end-to-end analytics platform Tableau is the most powerful, secure, and flexible platform. Organizations use Tableau to create an impact on the visual views of the data. The basic purpose of this platform is to analyze varieties of structured data & convert it into highly interactive visualizations, dashboards & Stories which the end-user can easily understand and take impulsive decisions useful for the future. It empowers the end-users to get the analysis done quickly, and confidently combine, shape, clean and operationalize their data flow in a creative output which is visually effective.This article is going to cover step by step guide to install Tableau. Before going into details for installation, it is important to understand the various components of the Tableau software suite. There are six different components of Tableau:Tableau Server: It serves the purpose of a centralized repository for dashboards and data sources used in any organization. Tableau desktop publishes dashboard and data sources on the Tableau server. Tableau Server is a key component for control and compliance perspective as well. Industry-specific compliance requires to have an on-premises version of the server to have physical control of the content. This is important for auditing purposes. Tableau server also easily integrates with windows active directory which helps in enabling single sign-on for organizations as well.Tableau Desktop: This is the main component used by developers to create interactive dashboards and workbooks. It can connect to any data source and does the transformation required to meet the business needs of customers. We can add customized filters and also do some additional calculation while creating dashboards in Tableau desktop.Tableau Public: This helps users to publish their dashboards on Tableau public server hosted and owned by Tableau software. Any organization/individual can create their public profile on Tableau software and leverage that profile to publish local dashboards.Tableau Reader: This comes as a free offering from Tableau to view and interact with dashboards created by Tableau desktop.Tableau Online: This is a cloud-based offering from Tableau. Any organization who does not want to have a tableau server hosted on-premises, can go with Tableau online.Tableau Mobile: This is available as both android and iPhone apps. We can use this app to view dashboards if we have Tableau online subscriptions or user access to organizations Tableau server.Key FeaturesOther FeaturesOperating SystemLicenseTableau DesktopCreates dashboards and stories locallyTableau Personal: limited data sources, non-connectivity to Tableau Server.Tableau Professional: Full enterprise capabilities.Windows, MacPersonal: $999Professional: $1999Tableau PublicA massive, public, non-commercial Tableau ServerAll data published in public-FreeTableau OnlineCreating Dashboards and stories on the CloudLive connections-$500 per yearTableau ReaderView dashboards and Sheets locallyCannot modify workbooks or connect to the serverWindows, MacFreeTableau ServerConnect to Data sources and share DashboardsUsers can directly interact with Dashboards via a browserWindowsCore LicensingWe are going to cover installation for Tableau Server and Tableau desktop in detail here.Tableau server Installation on WindowsTableau server can run on a multi-node cluster as well on Virtual machines as well. Here we will be covering installation on a single-node machine.The minimum hardware requirement for Tableau server(Single node) :Processor speed: 8 core, 2.0 GHz or higher processor32 bit/64 bit architecture: 64-bitRAM: 32 GB memoryHard Disk: 50 GB disk space should be availableOperating system requirements :The operating system which supports Tableau server installation are as follows: Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows server 2019, CentOS 7, Ubuntu 16.04 LTS, Red Hat Enterprise Linux (RHEL) 7, Oracle Linux 7Installation Path: The Tableau server gets installed in the system drives where windows operating system files also exist. If by default, the system drive is the C drive, then the installation path will be as follows:C:\Program Files\Tableau\Tableau Server\packagesC:\ProgramData\Tableau\Tableau ServerSome organizations install tableau server on different location as well. We can provide the location different than the system drive by browsing install location which will automatically add  \Tableau Server to it and will install the files under it.Let’s now go to installation for version (2018.2) of Tableau Server.Step 1: Get the product key of the software using the user id and password that you must have received while purchasing Tableau. Then go to the Customer Portal and get the product key.Step 2: Get the Admin rights for the computer on which we are installing Tableau software. The developer should be a member of the administrator's group in local users and group management.Step 3: Get the installation files for Tableau server. We can download installation file by visiting Download Tableau Server-WindowsStep 4: Run the installation files with admin rights, the below screen will come up where you can change the installation drive, by default it will be installed in system drive:Step 5: Once we click next, the below page will appear where we can choose installation type, in this article we will be covering new Tableau server installation:Step 6: After we click on the install button, the installation process will be kicked off and once the installation is completed clicking next will start Tableau Service manager. It may take some time to start TSM.Step 7: Once TSM process gets launched by a setup process, the below screen will come up. We need to log in using the same admin credential which we have used for running installing set upStep 8: Once we login to TSM, it will ask for a product key to activate the tableau server:The product key is used to activate both server and setting license type which can be user-based or core-based. It requires an active internet connection but there is an alternative way to activate tableau offline as well. You can read Activate Tableau OfflineStep 9: The next step is configuring the basic settings on the Tableau server after activation and successful registration of product key. We can set how we want to authenticate users either local or active directory, setting under which account tableau server should run, setting default port and whether we want to include sample workbook or not.Step 10: Setting the authentication type is very critical in the entire set up. By default the authentication type is local. The other option is active directory authentication. If we select an active directory option, then we need to enter a domain name in the fully qualified name and in the NetBIOS section we can enter the domain’s nickname:Step 11: We can run Tableau server either under NT AUTHORITY\NetworkService or custom service account. We need to provide a domain name with the user name for the custom user account.Step 12: Setting default port for Tableau server: By default, it takes port number 80 if there is no other application running on the same port. If the port is not available, we need to find out which other application has claimed port number 80. Usually, IIS runs on the same port. IT infrastructure team can help us in getting a new port if 80 is not available:Step 13: Once we click on the initialize button in step 9, Tableau server will start saving all the configuration settings set in previous steps :Step 14: Once the initialization gets completed, the below screen will appear and clicking on the continue button will take you to the final step where you need to configure administrator user for running Tableau server:Step 15: Tableau server set up at last step launches a browser and opens a page where we need to set administrator user for Tableau server. The administrator does take care of all tasks like managing sites, users administration, groups and project management. Even for changing, any configuration setting can be done only by the administrator. In the case of active directory authentication, the administrator must belong to a user in the same directory. For local authentication, we need to provide a username and password. This account is very critical as it provides a single entry point to Tableau server in case of any issue in server.Step 16: Once we are done with the setting of administrator users, we can log in to the Tableau server using web interface. We can then start publishing the workbook to the server using Tableau desktop.Tableau server Installation on Linux/Ubuntu:With the growing demand for Tableau server running on Linux/Ubuntu, it is now supported on Linux as well. In a recent survey, it has been found that 25% new server installation happened on Linux server. Let us now cover the step by step process for installing Tableau Server on Linux :Download the Linux version of Tableau server as per the operating system. In this article we will cover tableau-server-2019-1-1_amd64.deb (1371 MB)Only the below version of Linux are supported Red Hat Enterprise Linux (RHEL) 7.3 and higher, CentOS 7.3 and higher, Oracle Linux 7.3 and higher, and Amazon Linux 2.Version.The latest versions of Ubuntu 16.04 and 18.04 LTS only. Non-LTS releases are not supported. The installation tasks will be run as root. We can run this by Sudo command or we can run commands directly as the root user.Log in with the user having Sudo access to the system and navigate to the location where you’ve copied the installation package. Now you will be using the package manager to install Tableau Server. We have different commands for RHEL and Ubuntu:On RHEL/CentOS we can have below commands sudo yum update sudo yum install tableau-server-.x86_64.rpm On ubuntu we can run below commands sudo apt-get update sudo apt-get -y install gdebi-core sudo gdebi -n tableau-server-_amd64.debNext step is initializing TSM. We need to navigate to script location:cd /opt/tableau/tableau_server/packages/scripts.If the system is connected to the internet, then we can run the command given below to start TSM: sudo ./initialize-tsm --accepteula and in case of a system connected to the internet through the proxy server, we can run the given below command:sudo ./initialize-tsm --accepteula --http_proxy=http://proxy.example.lan:80/ --https_proxy= http://1.2.3.4:443/In the above example, we can replace hostname proxy .example.lan and IP address 1.2.3.4 with our hostname and IP address.Once initialization is completed, we can close the terminal sessions: logoutNext step is activating and registering Tableau server. Navigate to web UI interface for TSM Web UI. In case of an authentication error, check if the user belongs to the tsmadmin group or not. It can be easily checked running following command in bash:grep tsmadmin /etc/group - this will list down all users belonging to the tsmadmin group. We can also add the user to a tsmadmin group by running the below command: sudo usermod -G tsmadmin -a . Once we added the user successfully we can run tsm login command.After successful login to TSM, you can activate the key :Once License activated, we can enter basic information and click on the register button as below :The next step is configuring basic settings like authentication, port etc.If we opt for active directory, then there are two options to connect either using simple bind or GSSAPI bind:Once initialization is completed, the below screen will come up to confirm it :Next step is creating administrator accounts for Tableau server. If we have used an active directory authentication, then we can run the below-given command to create the same :tabcmd initialuser --server 'localhost:80' --username ''.In case of local authentication we can create a custom user who will be working as admin using below command: tabcmd initialuser --server 'localhost:80' --username 'admin'We can then check firewall settings which is an optional step but it is best to practise for security. There are two ports on which Tableau server run. The first port is a gateway port(80) and the other one is tabadmincontoller port(8850). Please find below commands to open these ports :Starting firewalld by sudo systemctl start firewalldSetting default zone as public by running command sudo firewall -cmd --set-default-zone=publicAdding ports for the getaway port and tabadmin controller port by running commandsudo firwall -cmd --permanent --add-port=80/tcpsudo firwall -cmd --permanent --add-port=8850/tcpLast step would be reloading the firewall and verifying settingssudo firwall -cmd --reloadsudo firwall -cmd --list-allThe final step is validating Tableau server installation by installing the PostgreSQL driver which can help in viewing administrative views. First of all, you need to download the driver by navigating to Driver Download page. Once the driver is downloaded, you can install it by below command :CentOS and RHEL ,we can download the .rmp and run below command :sudo yum install tableau-postgresql-odbc-9.3.1.x86_64.rpmUbuntu need .deb file and below command :sudo dpkg -i tableau-postgresql-odbc-9.3.1.x86_64.debOnce the driver is installed, you can validate by visiting Administrative Views in tableau server.Tableau desktop Installation on WindowsThe first step is downloading installation files from Tableau Desktop DownloadRun the .exe file once the installation file is downloadedOnce you click the run button, the below screen will appear, you can read the license agreement and confirm the acceptance to proceed furtherOnce the installation is completed. In the next screen, you can choose the trial version or if you have the product key, you can activate the product as wellTableau desktop Installation on MacThe first step is to visit Product Downloads and Release Notes  and Tableau desktop should be selected from the list.Choose the version we would like to installIn the downloadable file section, we can select mac version of Tableau desktopFor Mac: Open the Disk image file (.DMG) and double-click the installer package (.PKG) to start the installation.With this installation, some data sources drivers get automatically installed for seamless integration with different data sources.Once the installation is completed, we can register the product or start using the trial versionTableau desktop Uninstallation on Windows/MacThe first step is deleting Tableau desktop from the applications folder.The second step is deleting My Tableau Repository from Documents folder. It might be possible that doing the above step may delete user-related files as well. So we may choose another alternative to rename the folder to something else.Then we can delete all files/folders beginning with “com.tableau” from Library folder under Preferences and Saved Application state respectively.To delete hidden folders from mac, we can follow the below steps:CMD-SHIFT-G or we can navigate to Go->Go to Folder.. From finder.It will open the dialogue box in which we can type ~/Library/PreferencesIf Tableau desktop being used by multiple users then we can repeat all steps except the first one for all users.For WindowsNavigate to Control Panels-Programs-Uninstall ProgramIn the program list select Tableau Desktop and on right-click select uninstallNavigate to installation path for Tableau desktop C:/Program Files/Tableau and delete the “Tableau” folder from there to uninstall it.
Rated 4.5/5 based on 4 customer reviews
5809
Tableau Installation and Configuration on Mac and ...

Tableau is one of the most widely used data visual... Read More

Guide To Install Power BI

The Power BI demand has raised significantly in recent times due to its amazing features and acceptance by the data visualization professionals/business intelligence teams. Due to this exponentially increasing trend, people are more interested in knowing how to install Power BI on a system. We will see installation steps further in this article, but before that let’s check out the recent trends on the rising popularity of Power BI: Power BI Dashboard Below is the screenshot of the Power BI dashboard. This is how the dashboard looks after converting data from different data sources with the help of Power BI, a data visualization and Business Intelligence tool. System Requirements for installing Power BI The prerequisite system requirements  for installing Power BI desktop version on your machine:The OS requirement for Power BI is as follows: Windows 7, Windows 8, Windows 8.1, Windows 2008 R2, Windows 10, Windows Server 2012, Windows Server 2012 R2, Window server 2016, Window server 2019The minimum IE version required is IE10The minimum .net version required is 4.6Hard Disk- At least 1 GB space is required to install the Power BI server and additional space is required to host Power BI database.RAM- Minimum: 1 GB and Recommendation: 4 GB or moreProcessor speed-Minimum x64 1.4GHz Recommended 2GHz or fasterProcessor - x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T supportAs we know that Power BI has two different variants so let us cover the installation of both variants separately. First, we will cover the scenario where the organization has already office 365 subscription  :1. The Power BI web client using Office 365- This version is used for connecting to Microsoft cloud. Let's go through step by step for using the same if we have already an office 365 subscription.In IE browser, navigate to Power BI Getting started link and click on “Sign in “ link which is available at the top right of the page :Next step is to log in with the organization’s office 365 account credentials:IIn case your office 365 access has not been activated for Power BI then you would see below screen:2. Downloading the desktop version of Power BI Navigate to the Power BI download page for downloading the desktop version of Power BI.Power BI DownloadClicking on download free  will take us to Microsoft store from where we can get a copy of Power BI desktop versionClicking on Get will ask for confirmation if we would sign in with Microsoft account to use the desktop version on all compatible devices. After confirmation downloading will start and once download gets completed, we can launch a window installer.Once Power BI is installed, we can log in with office 365 accountNow let us cover standalone Power BI desktop installation if we do not have pro Office 365 subscriptions. Please find below steps for the same : Let first navigate to download page  Power BI.  Then we can select the language in which you would like to  install Power BIWe can also directly navigate to download page by visiting the direct link  as well :Download files Power BI .We can select the appropriate file based on the OS type. There are two variants of the file available, one is 32 bit and the other is 64 bit. We can download the correct file. After running the downloaded installer(assume we have downloaded 64-bit version) we come across below screen where we can follow the instructions to install Power BI :After successful installation,  the welcome screen is launched which provides options to connect to data existing data models enrichment, creating new reports and publishing.Uninstall Power BI Desktop: On the start menu, go to control panels.In control panels section ,click Add/Remove ProgramThen select Microsoft Power BI Desktop in the program list and click uninstall option.Power BI on Mac:  There is no support available to run Power BI on Mac. But if we have Azure subscription then we can provision windows VM and install Power BI there. Once VM is configured, it is easy to remotely access VM from Mac machines.
Rated 4.5/5 based on 2 customer reviews
6633
Guide To Install Power BI

The Power BI demand has raised significantly in re... Read More