How to do a Circle Graph in PytIn Python visualizations are easy. If you are a data analyst, doing visualizations enhances your project and can really help tell a story…Jul 1, 2021Jul 1, 2021
How to Create a Table in MySQLWith SQL you may need to create a table within your database for your analysis. Using the SQL CREATE TABLE command makes it easy.Jun 25, 2021Jun 25, 2021
How to do a Git CommitAfter creating your repository in Github how do you get your changes and update on it? After all, Github is not really a blog site where…Jun 17, 2021Jun 17, 2021
What is a Database Management SystemA database management system (DBMS) makes retrieving, manipulating, and managing data much more easily with SQL instead of just running it…Jun 10, 2021Jun 10, 2021
What is Feature SelectionFeature selection is a term in machine learning for variables. When we test a model we want to know which variables affect it the most…Jun 3, 2021Jun 3, 2021
Macros in ExcelMicrosoft Excel is a great source for analyzing data especially utilizing a feature called Macros. If you do repetitive tasks in excel, a…May 27, 2021May 27, 2021
Correlation HeatmapsA correlation heatmap is graphical representation using color gradients to show a relationship between variables. The values are…May 13, 2021May 13, 2021
SQL JoinsJOIN clauses are what link two tables together and there are a few in SQL worth knowing. These clauses link the tables easily and…May 6, 2021May 6, 2021
Confusion MatrixA Confusion matrix is useful to test the performance of your classification model in machine learning. It will tell you the true positive…Apr 29, 2021Apr 29, 2021
Visualizations for a Business AnalystVisualizations are what tell a data set’s story. It is so important for a business analyst to be able to understand how to create and read…Apr 22, 2021Apr 22, 2021
Hypothesis TestingHypothesis testing is the use of statistics to determine the probability that a given hypothesis is true.Apr 15, 2021Apr 15, 2021
Why Use TableauTableau is a software that helps create great visualizations for a dataset. It is a very user friendly program that allows for quick…Apr 9, 2021Apr 9, 2021
How to do a VLOOKUPA VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column to return a value from a…Mar 25, 2021Mar 25, 2021
Waterfall Project ManagementIn software development things happen in stages. With each stage certain processes must be followed. This is where the waterfall…Mar 18, 2021Mar 18, 2021
CountIF in ExcelExcel COUNTIF function is used for counting cells within a specified range that meet a certain criterion, or condition.Mar 11, 2021Mar 11, 2021
Regression Analysis for Kings County Home SalesMy goodness! What felt like a never-ending project is finally complete. I must say I learned A LOT and have come to appreciate all the…Mar 4, 2021Mar 4, 2021
Importing CSV FileTo start, here is the code needed to import a CSV file into Python:Feb 25, 2021Feb 25, 2021
5 Excel Formulas Useful for Data AnalysisCONCATENATE: Concatenate allows you to combine the values of several cells into one. It’s one of the most powerful formulas for conducting…Feb 18, 2021Feb 18, 2021