Day 11 #20dayswithdata SQL Basics I wrote a SQL query to retrieve all the Columns from a Bikeshare dataset Table. #hertechtrailacademy #HTTDataChallenge #SQLBasic #SQLQuery #BigQuery @phaibooboo

Hi Everyone, I'm Baibiteim Amachree, a Data Analyst in Training 🤭. Today I will be starting the HerTechTrail 15 days Data Challenge. #HTTDataChallenge Day1: Sharing a photo of my Excel workspace. Looking forward to the rest of the challenges from #hertechtrailacademy

My name is Irene NWANKWO, and I am an aspiring data analyst. Currently, I am undergoing a scholarship from her tech trail academy learning data analytics. Day 1: This is a picture of my excel workspace #HTTDataChallenge #hertechtrailacademy

My name is Promise and I am currently taking Data analytics with #hertechtrailacademy it’s been an amazing journey so far. #HTTDataChallenge.

A 7 days data challenge. Day 1 Data analytics is all about the process of collecting and analyzing data for insights to make meaningful decisions. #hertechtrailacademy #HTTDataChallenge

Hello everyone! I am Waqilat Sulaiman Today, I'll be starting a 15-day data challenge. I am excited to enhance my data analysis skills and connect with fellow participants. Looking forward to this journey of growth and knowledge-sharing. #hertechtrailacademy #HTTDataChallenge

Day 2. The supermarket dataset may contain duplicates, while the bike-share dataset may contain missing values. #20dayswithdata #hertechtrailacademy #HTTDataChallenge #ExcelDataImport #DataCleaning

Day 2 Day 2 compromises of day 1 and day 2 since I missed day 1 I cleaned the data with power query #20dayswithdata #HertechtrailAcademy #HTTDataChallenge #ExcelDataImport #DataCleaning

Day 1. Access and download the daily challenges here: https://t.co/FyR2cFJTwv #20dayswithdata #hertechtrailacademy #HTTDataChallenge

Day 2 Challenge: Data Import and Cleaning Frame 1 is my imported Dataset before Cleaning Frame 2 is my dataset after Cleaning 😊 Thank you #hertechtrailacademy #HTTDataChallenge #ExcelDataImport #DataCleaning

#hertechtrailacademy #HTTDataChallenge #ExcelFormulas #DataAnalysis

Day 2  Data Import and Cleaning  20days with data challenge on @hertechtrail #20dayswithdata, #hertechtrailacademy and #HTTDataChallenge, #ExcelDataImport, #DataCleaning.

Day4-Conditional Formatting Challenge: Apply conditional formatting to highlight cells with high sales values. #20dayswithdata,#hertechtrailacademy, and #HTTDataChallenge, #ConditionalFormatting, #DataHiglighting.

Day 12 of my 15-Day #HTTDataChallenge Today, I dived into grouping and aggregation. My task was to write an SQL query to calculate the total sales and average order value by region. ✨Below is a snippet of my query and the results.👇 #SQLAggregation @hertechtrail @phaibooboo

Day 3 #HTTDataChallenge #hertechtrailacademy #ExcelFormulas #DataAnalysis We were asked to calculate the total sales and average order value, and share a screenshot of our formulas along with the Calculated values. I used the Sum and Average Formulas for this task. Thank you

Hi everyone! I am Oluwaseun Adebayo. I am a data enthusiast passionate about using data to solve real time problems. I joined the #HTTDataChallenge to build my skills in Excel, SQL, and analytics. #hertechtrailacademy #HTTDataChallenge

Day 4: String Operations #HTTDataChallenge #hertechtrailacademy This script demonstrates basic string manipulation techniques including slicing and concatenation. @hertechtrail @it_is_reel @phaibooboo @mychailblaise @som_nnamani @preciey_oma @AtiJoshua

Day 3-Basic Formulas. Challenge: Calculate the total sales and average order value using appropriate formulas. Image 1-Total sales Image 2-Average order Data set used Supermarket _sales #20dayswithdata, #hertechtrailacademy and #HTTDataChallenge, #ExcelFormulas #DataAnalysis

Before is tagged sheet 1, After is tagged Supermarket_sales_dataset. #hertechtrailacademy #HTTDataChallenge #ExcelDataImport #DataCleaning

Day 15 of #20dayswithdata Task: Write an SQL query to calculate total sales and average order value by region. #HTTDataChallenge