Using Subqueries to join 2 more tables which do not have distinct values in a column We want to find the number of Flight bookings by Country, number of Car bookings by Country and the number of Hotel bookings by Country all appearing in one table with same country on one row. We want to
This is a short guide to getting ranking or rating from Microsoft Sql Server customers. Ranking is taken by checking how many times a customer has visited a particular country divided by the total number of travels the customer has made within the database /*make a back up of the recommender rankings table*/ truncate
We can use Visual Basic codes to automate some reports in Excel. Below are some simple codes to do this. First this is a batch file to open our Excel report called “data report.xlsm”, assuming the report file is in the same folder as the batch file. You can schedule the time this batch file is
Sometimes, you need some charts to explore your data and many times when your analysis is done and you want to report, you would most likely want to convey your message using charts and graphs. This is a quick look at some charts which are available and their names: We use this raw data in
There are a couple Free Open Source Data Visualization Tools and Services which you can make use of for your work data exploration and visualization purposes. Below , I list a few ones in no order of importance. Caravel: It is a Python based data exploration and visualization software by Airbnb. It is powerful and
This is a just a bit of addition to a previous post, by formatting the Excel output further using the Python XlsxWriter package. The additions are : Colour formatting has been added to the Total Cost column The “Total Cost” has been given a money formatting The above uses row : column numeric values instead
Google has now made Data Studio accessible and you can use it to create pretty cool data visualizations. You can find out more about the free versions and the premium versions here. Google Data Studio In the meantime, you can view a simple dashboard I created for Amazon Product Sourcing here: Amazon product Sourcing Google Studio
This tutorial is just to illustrate how to save Python Pandas dataframe into one excel work SHEET . You can save it column-wise, that is side by side or row-wise, that is downwards, one dataframe after the other. In [110]: import sqlalchemy import pyodbc from pandas import DataFrame from bokeh.plotting import figure, output_file, show
The key advice for any Data Analysis project is to never start any analysis without first having a structured plan. You should set your goals and they should be S.M.A.R.T Below are the two charts to help with Analysis. This is part of Data Visualization and Communication with Tableau by Duke University on Coursera. Set your
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
No products in the cart.