Ransom Eyoransomeyo.hashnode.dev·Sep 14, 2023Data Analytics: The visualization game where colors serve as a means of communication.""Hello, everyone! I really have passion for storytelling and greatly enjoy having people follow my progress over time. This is the main reason why I've chosen to make this my inaugural blog post here. Above this post's title, you'll find a screenshot...Discuss·2 likesDevops
olami bosipoolamibosipo1.hashnode.dev·Sep 13, 2023My First Project in data analytics - Sales dashboard using MS excelHi Hashnoders,I'd like to share my experience on my first project in data analytics here.The dashboard was created using Microsoft excel and the dataset (which is one of the historical sales of a supermarket company that was recorded in 3 different b...Discuss·2 likes·41 readsdataanalytics
Onasanya Victor Oluwatimileyintbright.hashnode.dev·Aug 8, 2023Calculated FieldsHello everyone. I’m back. Apologies for the break. So, over the past few days, I’ve reviewed the "show values as", calculated fields, and calculated items functions in pivot tables. I'll be focusing on Calculated Fields here. The Calculated Fields fu...Discussmsexcel
Onasanya Victor Oluwatimileyintbright.hashnode.dev·Jul 7, 2023Statistical FunctionsToday, I learned about statistical functions, and it was fascinating. I went through the following areas: COUNT AVERAGE/MEDIAN/MODE MIN/MAX PERCENTILE STANDARD DEVIATION VARIANCE RANK SMALL/LARGE RAND/RANDBETWEEN SUMPRODUCT COUNTIFS/SUMIFS/AVERAGEIFS...Discussdataanalytics
Onasanya Victor Oluwatimileyintbright.hashnode.dev·Jul 5, 2023Logical OperatorsI've been learning about Advanced Excel formulas and functions. Today, I covered Logical operators in the following areas: IF statement Nested IF statements IFAND and IFOR operators IFNOT function IS statements IF Statement I learned that th...Discusslogical operator
Rashidat Jimohrashidatjay.hashnode.dev·Mar 31, 2023Excel Data Validation: How to Ensure Consistent and Accurate Data Entry.In a standard Excel worksheet, users can input any data they like. Nothing is off-limits from whole numbers to decimals, lists, dates, texts, etc. They only need to double-click on the cell to input the data. However, allowing users to fill in any da...Discuss·1 like·117 readsexcel
Blessing Ewuolablesscanplay.hashnode.dev·Jul 1, 2022Maven Airlines' Passenger Satisfaction SurveyIt is common knowledge that boarding an airplane can be cumbersome. From booking tickets to checking in, handing over luggage, going through security inspection, finding the boarding gate, and other processes you go through to transport yourself from...Discuss·144 readsData Science
Tomisintomihashdata.hashnode.dev·Jun 19, 2022Covid-19 Data AnalysisThis week was a proper HUSTLE, and I remember telling our Teams Supervisor at Side Hustle why it was and that I am sure some people in my team have given up on Data Analytics. THE TASK The task is to Work on any Health/Disease Insight Analysis. We ar...Discuss·1 like·63 readsPowerBI