Crypto currency analyzer : Data visualization Project : Power BI

-

In this project i have created a Multiple Page Inter-connected Business Intelligence (BI) Dashboard using Power BI. I have analyzed the data to forecast the crypto currecy using forecast mode of PowerBI

Data link : https://docs.google.com/spreadsheets/d/1Lc380wCA1DkS2ejvbM8GtL2w_teZ80BM/edit?usp=sharing&ouid=109399052699278618880&rtpof=true&sd=true





1: Started by Using Slicer pane from Power BI, for sorting all the cryptop scripts, 

Below is the output 



2: Used Slicer pane to sort the data by Year ( Again we had the data in form of full dates, so we carried out "Data transformation" and thus sorted Years out of the date seperatly in new coloum. Then we implimented slicer on year column the below result was obtained.



3: Adding Cards  : Using cards pane we have added three different values. Here we have added cards with High, Low, Average.


                                                                    

4 : Adding line card  : Using line graph pane, we created a plot with respect to the forecast of future data of the crypto trend.



5. Sorting the High low by date , we have replicated the line chart from the line chart pane.


6. Sorting the Open Close by date ,we have replicated the line chart from the line chart pane.


                              




Making Dashbord from all of the above charts



Dashboard 2 - For Sync

                    


















Comments

Post a Comment

Popular posts from this blog

Docker

-
Image
  What is Docker ? Docker is a containerization platform that provides easy way to containerize your applications, which means, using Docker you can build container images, run the images to create containers and also push these containers to container registries such as Docker Hub, Quay.io and so on. In simple words, you can understand as  containerization is a concept or technology  and  Docker Implements Containerization . Docker Architecture ? The above picture, clearly indicates that Docker Deamon is brain of Docker. If Docker Deamon is killed, stops working for some reasons, Docker is brain dead :p (sarcasm intended). Docker LifeCycle We can use the above Image as reference to understand the lifecycle of Docker. There are three important things, docker build -> builds docker images from Dockerfile docker run -> runs container from docker images docker push -> push the container image to public/private regestries to share the docker images. Understandin...
Read more

Data Analytics for Healthcare Industry

-
Image
Data Analytics for Healthcare Industry: Transforming Patient Outcomes The healthcare industry generates vast amounts of data every day, including patient records, medical images, and clinical trials. This data holds immense potential to improve patient outcomes, but it can also be overwhelming to analyze without the right tools and expertise. That’s where data analytics comes in - it allows healthcare providers to turn raw data into meaningful insights and drive better decision-making. Here’s a closer look at how data analytics is transforming the healthcare industry: Improving Diagnosis and Treatment Data analytics can help providers to identify trends and patterns in patient data that might not be immediately obvious. For example, data analysis can reveal correlations between certain symptoms and diagnoses, or help doctors identify which treatments are most effective for specific patients. This can lead to more accurate diagnoses and personalized treatment plans, resulting in better ...
Read more

Employees Salary Prediction Using Linear Regression - KNIME ANALYTICS PLATFORM

-
Image
Here I will be using the KNIME to forecast the employee's salaries with respect to their year of experience by training and testing data in ML using Linear Regression. Step 1 : Reading the data set with KNINE - File Reader Node 1                                         Step 2: Adding the data filter node to remove the Null Values Setting up the pattern match to N/A Step 3: Adding Node 2.1 Partitioning for Data sorting to Train & Test for Machine learning Algo. Here we set 70% of total data to Train & 30% to Test Step 4:  Training data for linear regression Note: After training the data, we have concluded that our model shows ~95% Accuracy , as we have selected the Random samples from the training data to maintain the efficiency of the model. Step 5: Adding the Linear Regression Node run Trained & Test Data Step 6: Once we have trained and tested data, we have got the ...
Read more