Introduction
Anybody can be a data analyst but what separates a good data analyst from a great one is what you can do and present.In this article i will be giving step by step guidelines from turning a raw data to an inteructive business dashboards and giving insights.We will generate our sales data from Mickaroo,use Python to turn the json file to csv,analyse with Sql and visualize with Power Bi.
1.Generatig the sales data.
You will go to your browser and search Mockaroo.com.Once open,hit the generate data button and give AI a comand to generate the data for you.You can select the number of rows that you want your data to have.Once its done,save the data as a json file.
a.Viewing the data
Once your data is generated and saved in your files in your machine,go to your Github acound and add that file to your repo.
Once you open that file,hit the daw button and you will see something like this:
2.Importing using Python.
The work is not yet done.Copy the link from your raw data in github because we shall need it.Use the import requests and the url will be your link you copied from raw data in github.While pasting the url,ensure it has the either the double or single quotes at the start and at the end of the url link.The status code must always be 200.
The next step will be seing the type of data that we have,either a list or dictonary.
We have created a data frame,viewed the first rows and saved the the data as csv.
You should be seing the sales data as an excel file in your files ready for analysing.
SQL analysis
Since we already have our data as csv,we will import it in any sql environment you use.I will be using D-beaver.First you create a schema called sales_data or any name of your choice,then creating the sales table.
1.creating the table
You create a schema called sales_data or any name of your choice,then creating the sales table.Every column name will be kept as texts.Why,to avoid data type errors during import and to handle missing values,weird formats or nulls with ease.
2.Importing the data
first,you go to your schema,refresh and search for your table name.Right click it and hit the import data button.Import the csv then press next,hit the brows button to select which file exactly that you want,then press next till you procede to the next part.After importing the data,hit the refresh button on the table name below your schema to ensure the data is set.You can now write a query to see your data
Top comments (0)