#15dayshttdatachallenge search results

📌 Day 2 – #15DaysHTTDataChallenge Today I worked on Data Cleaning in Excel using the Supermarket Sales dataset 🧹📊 ✔️ Removed duplicates ✔️ Handled missing values ✔️ Checked data types & formatting Clean data = reliable insights 🚀 #HerTechTrail #HTTDataChallenge #Data

✨ Starting Day 1 of the #15DaysHTTDataChallenge with @hertechtrail 🚀 This is my first post about my Data Analytics journey 📊 Over the next 15 days, I’ll be sharing progress on Excel, SQL & real datasets. Excited to grow & stay consistent! 💪 #DataAnalytics #HTTDataChallenge.

#15DaysHTTDataChallenge #Day15 Task:Write a complex SQL Query that involves multiple tables, filtering, sorting and Aggregation. Solve a practical problem or answer a practical question related to your organization's problem. Business insightsin the commentsection @hertechtrail

So, wrapping up the #15DaysHTTDataChallenge today. I must say it's been a wonderful experience. I had to stay up late many times just to understand a particular concept. It wasn't easy but it was worth it. Thanks to my amazing coaches @phaibooboo @it_is_reel, you are great tutors

#15DaysHTTDataChallenge #Day14 - Combining JOINs and Aggregate Task: Write an SQL Query to retrieve the total sales for each channel from which clients access the company. Highlight high value and low value channels. Details in the comment section @hertechtrail @phaibooboo

#15DaysHTTDataChallenge #Day13 - Subquerie The query calculates the average 'total_amt_usd' per order from the orders table and retrieves account_id from the orders table where the sum of orders for each account is greater than 3348.02. @hertechtrail @phaibooboo @it_is_reel

#15DaysHTTDataChallenge #Day12 - Grouping and Aggregation Task: Write an SQL Query and calculate Total Sales and Average Order Value by region. To calculate the total sales and Average Order Value, I joined the four given tables, and was able to determine the desired result.

#15DaysHTTDataChallenge #Day11- Joining tables Task: Write an SQL Query that combines two tables and retrieve six (6) Columns, 3 from each chosen table. From the Parch_and_Posey Database, I was able to write an SQL Query combining two tables: the accounts and the orders table

#15DaysHTTDataChallenge #Day10- Sorting Data Task: Write an SQL Query to retrieve Customer's names in alphabetically. Insights: I selected all columns from the accounts table and orders the name column in ascending order. @hertechtrail @phaibooboo @it_is_reel @som_nnamani

#15DaysHTTDataChallenge - #Day9 Excited to share that I'm continuing my data challenge journey, now diving deeper into SQL Building on my Excel skills, I'm expanding my data analysis capabilities by exploring SQL for more complex queries and data manipulation.@phaibooboo

#15DaysHTTDataChallenge #Day8 - Data Visualization I created a bar chart 📊 titled Product-wise Sales Distribution to displays the sales figures for different product categories in a supermarket. @hertechtrail @phaibooboo @it_is_reel @som_nnamani @AtiJoshua #hertechtrailacademy

#15DaysHTTDataChallenge #Day7- Data Validation I implemented data validation on the Dataset. This was necessary to prevent errors like entering negative values, non numeric values, or unrealistic numbers that could lead to inaccurate inventory or sales records. @hertechtrail

#15DaysHTTDataChallenge #Day6 Data Analysis Sights The month of January recorded the highest sales, but in February there was a great drop in sales. However, in March there was an increase but isn't upto the sales achieved in the month of January. @hertechtrail @phaibooboo

#15DaysHTTDataChallenge #Day5- Pivot Tables I created Pivot Tables from A Supermarket dataset, & Summarized all Sales across different categories like quantity, product, customer, date etc @hertechtrail @phaibooboo @it_is_reel @som_nnamani #hertechtrailacademy #HTTDataChallenge

#15DaysHTTDataChallenge #Day4- Conditional Formatting I applied conditional formatting to display sales values that are above average from the Total Sales column. #HertechTrailAcademy #HTTDataChallenge #ConditionalFormatting #DataHighlighting @phaibooboo @it_is_reel @AtiJoshua

#15DaysHTTDataChallenge #Day3-Basic Formulas I used the SUM ànd AVERAGE Functions to find the Total Sales and Average Order Value which falls under the quantity column. @hertechtrail @phaibooboo @it_is_reel @som_nnamani @mychailblaise @AtiJoshua #HTTDataChallenge #DataAnalysis

#15DaysHTTDataChallenge #Day10- Sorting Data Task: Write an SQL Query to retrieve Customer's names in alphabetically. Insights: I selected all columns from the accounts table and orders the name column in ascending order. @hertechtrail @phaibooboo @it_is_reel @som_nnamani

#15DaysHTTDataChallenge #Day5- Pivot Tables I created Pivot Tables from A Supermarket dataset, & Summarized all Sales across different categories like quantity, product, customer, date etc @hertechtrail @phaibooboo @it_is_reel @som_nnamani #hertechtrailacademy #HTTDataChallenge

#15DaysHTTDataChallenge #Day3-Basic Formulas I used the SUM ànd AVERAGE Functions to find the Total Sales and Average Order Value which falls under the quantity column. @hertechtrail @phaibooboo @it_is_reel @som_nnamani @mychailblaise @AtiJoshua #HTTDataChallenge #DataAnalysis

#15DaysHTTDataChallenge #Day8 - Data Visualization I created a bar chart 📊 titled Product-wise Sales Distribution to displays the sales figures for different product categories in a supermarket. @hertechtrail @phaibooboo @it_is_reel @som_nnamani @AtiJoshua #hertechtrailacademy

#15DaysHTTDataChallenge #Day13 - Subquerie The query calculates the average 'total_amt_usd' per order from the orders table and retrieves account_id from the orders table where the sum of orders for each account is greater than 3348.02. @hertechtrail @phaibooboo @it_is_reel

#15DaysHTTDataChallenge - #Day9 Excited to share that I'm continuing my data challenge journey, now diving deeper into SQL Building on my Excel skills, I'm expanding my data analysis capabilities by exploring SQL for more complex queries and data manipulation.@phaibooboo

#15DaysHTTDataChallenge #Day14 - Combining JOINs and Aggregate Task: Write an SQL Query to retrieve the total sales for each channel from which clients access the company. Highlight high value and low value channels. Details in the comment section @hertechtrail @phaibooboo

#15DaysHTTDataChallenge #Day6 Data Analysis Sights The month of January recorded the highest sales, but in February there was a great drop in sales. However, in March there was an increase but isn't upto the sales achieved in the month of January. @hertechtrail @phaibooboo

#15DaysHTTDataChallenge #Day7- Data Validation I implemented data validation on the Dataset. This was necessary to prevent errors like entering negative values, non numeric values, or unrealistic numbers that could lead to inaccurate inventory or sales records. @hertechtrail

#15DaysHTTDataChallenge #Day4- Conditional Formatting I applied conditional formatting to display sales values that are above average from the Total Sales column. #HertechTrailAcademy #HTTDataChallenge #ConditionalFormatting #DataHighlighting @phaibooboo @it_is_reel @AtiJoshua

#15DaysHTTDataChallenge #Day15 Task:Write a complex SQL Query that involves multiple tables, filtering, sorting and Aggregation. Solve a practical problem or answer a practical question related to your organization's problem. Business insightsin the commentsection @hertechtrail

✨ Starting Day 1 of the #15DaysHTTDataChallenge with @hertechtrail 🚀 This is my first post about my Data Analytics journey 📊 Over the next 15 days, I’ll be sharing progress on Excel, SQL & real datasets. Excited to grow & stay consistent! 💪 #DataAnalytics #HTTDataChallenge.

So, wrapping up the #15DaysHTTDataChallenge today. I must say it's been a wonderful experience. I had to stay up late many times just to understand a particular concept. It wasn't easy but it was worth it. Thanks to my amazing coaches @phaibooboo @it_is_reel, you are great tutors

#15DaysHTTDataChallenge #Day12 - Grouping and Aggregation Task: Write an SQL Query and calculate Total Sales and Average Order Value by region. To calculate the total sales and Average Order Value, I joined the four given tables, and was able to determine the desired result.

#15DaysHTTDataChallenge #Day11- Joining tables Task: Write an SQL Query that combines two tables and retrieve six (6) Columns, 3 from each chosen table. From the Parch_and_Posey Database, I was able to write an SQL Query combining two tables: the accounts and the orders table

Day 3 – #15DaysHTTDataChallenge Our focus today is on Basic Excel Formulas using the Supermarket Sales dataset. I practiced how to: 1. Calculate Total Sales using the =SUM() function. 2. Find the Average Order Value with the =AVERAGE() function. #hertechtrailacademy

📌 Day 2 – #15DaysHTTDataChallenge Today I worked on Data Cleaning in Excel using the Supermarket Sales dataset 🧹📊 ✔️ Removed duplicates ✔️ Handled missing values ✔️ Checked data types & formatting Clean data = reliable insights 🚀 #HerTechTrail #HTTDataChallenge #Data

DAY 5 #15DAYSHTTDataChallenge. - PIVOT TABLE INSIGHTS 1. Total Sales by Product Line - Insight: Identify your top-performing product lines. 2. Order Quantity by City 3. Order Quantity by Gender 4. Order Quantity by Unit and Branch #hertechtrailacademy