#20dayswithdatachallenge search results

This was achieved by joining three tables, sorting, filtering and Aggregation of the company's data #DataAnalytics #20dayswithdatachallenge #hertechtrailacademy @phaibooboo @ImaNjokko @vicSomadina @AtiJoshua @OMOTOSHOOLAMI15

and rating the highest order above 10,000. 😄 It's quite complex.. #Hertechtrailacademy #20dayswithdatachallenge #HTTDataChallenge #AdvancedSQLChallenge #DataAnalytics. @ImaNjokko

MOOD!!! ...after completing the #20dayswithdatachallenge 💃 Consistency can be difficult, but what i would never do is stop halfway. Every day, i remind myself about consistency with this daily mantra: "Failure is not having the courage to try. I do not fail cos i do not stop…

Day14 of the #20DaysWithDataChallenge I wrote a query to join two tables and retrieve 3 columns from each table. #SQLJoining #DataIntegration #httdatachallenge #hertechtrailacademy @hertechtrail @phaibooboo @AtiJoshua @ImaNjokko @fresh_gb @OMOTOSHOOLAMI15 @vicSomadina

Day 13: Sorting Data I retrieved all customer names and arranged them in alphabetical order. #SQLSorting #Datamanupulation #20dayswithdatachallenge #hertechtrailacademy

Day 12: Filtering Data Orders for customer with Id 1021, having total of 10 orders from 12th Oct 2015 to 9th February 2016. #SQLFiltering #Dataquerying #20dayswithdatachallenge #hertechtrailacademy

Day 11:SQL Basics Query retrieved all Columns from accounts table in the Parch and Posey paper company. #SQLQuery #20dayswithdatachallenge #hertechtrailacademy

For Payment method the Highest sales was made via Cash,followed by E wallet and lastly Credit card In the Sales per City chart, the highest was achieved in Navypyitaw city and the least was in Yangib city. #datavisualization #20dayswithdatachallenge #hertechtrailacademy

Day 10: Data Validation To avoid Invalid product entry, Data validation was done such that Entries will be greater than or equal to 1 and the corresponding Error message. #datavalidation #DataQuality #20dayswithdatachallenge #hertechtrailacademy

Day 8: Data Analysis Analysing the Total sales per month and income generated for each month, it shows that ; The most Sales were made in January, a dip occured in February and sales increased in the month of March. #SalesAnalysis #20dayswithdatachallenge #hertechtrailacademy

Couldn't follow up for some days but I'm Back Day 7: Advanced Formulas Index function retrieved the Product line if the 10th Order and the Gender Match function was used to find the First Member Purchase Occurrence #20Dayswithdatachallenge #hertechtrailacademy #DataExtraction

Day13 of #20DaysWithDataChallenge The challenge is to write a SQL query to retrieve customer names alphabetically. Using Parch and Posey Database. SELECT * FROM accounts ORDER BY name #SQLSorting #DataManipulation #httdatachallenge @hertechtrail @phaibooboo @ImaNjokko

Insight 3: Members of the supermarket purchased more goods than Non members. Insight 4: Most customers made payments using Cash. #20Dayswithdatachallenge #hertechtrailacademy #PivotTables #DataAggregation @hertechtrail @phaibooboo @ImaNjokko @AtiJoshua @vicSomadina

Day 5 Creating a bar chart depicting the sales distribution product wise #DataVisualization #ExcelCharts #20dayswithdatachallenge #hertechtrailacademy

Day4 of #20DaysWithDataChallenge I applied excel conditional formatting to highlight the products that has the hightest unit price, top 10 highest cogs and the product rating that equals 8.7 #ConditionalFormating #DataHighlighting #HTTDataChallenge @hertechtrail @phaibooboo

Day4: Conditional Formatting Inorder to find Customers with high Sales value I applied conditional formatting on the Total sales column for sales above Average and highlighted such cells with a Dark red color. #20dayswithdatachallenge #hertechtrailacademy #ConditionalFormatting

Day 3:Calculating Total sales and Average order value using Excel I calculated the Total sales and Average order value using the Sum formula of the Total column and Average formula respectively. #20dayswithdatachallenge #hertechtrailacademy #ExcelFormulars #DataAnalysis

DAY3 of #20DaysWithDataChallenge I did some calculations on the supermarket sales dataset using 'SUM' and 'AVERAGE' functions in excel. @hertechtrail @phaibooboo @ImaNjokko @vicSomadina @OMOTOSHOOLAMI15 @AtiJoshua @fresh_gb #HTTDataChallenge #ExcelFormulas #DataAnalysis

Day 2: Data import and cleaning I removed duplicates from the ID column and handled missing values by replacing blank cells with N/A using the find and replace function. #datafam I am open for corrections #20dayswithdatachallenge #hertechtrailacademy #HTTDatachallenge

DAY 3; This Dataset contains information of ordered/sold items. We calculated the average order sales and the total sales using Basic Excel formulas. Pictures below. #20dayswithdatachallenge at #hertechtrailacademy. #HTTdatachallenge.#Excelformulas.#DataAnalysis. @ImaNjokko

This was achieved by joining three tables, sorting, filtering and Aggregation of the company's data #DataAnalytics #20dayswithdatachallenge #hertechtrailacademy @phaibooboo @ImaNjokko @vicSomadina @AtiJoshua @OMOTOSHOOLAMI15

and rating the highest order above 10,000. 😄 It's quite complex.. #Hertechtrailacademy #20dayswithdatachallenge #HTTDataChallenge #AdvancedSQLChallenge #DataAnalytics. @ImaNjokko

Day 5 Creating a bar chart depicting the sales distribution product wise #DataVisualization #ExcelCharts #20dayswithdatachallenge #hertechtrailacademy

Day14 of the #20DaysWithDataChallenge I wrote a query to join two tables and retrieve 3 columns from each table. #SQLJoining #DataIntegration #httdatachallenge #hertechtrailacademy @hertechtrail @phaibooboo @AtiJoshua @ImaNjokko @fresh_gb @OMOTOSHOOLAMI15 @vicSomadina

For Payment method the Highest sales was made via Cash,followed by E wallet and lastly Credit card In the Sales per City chart, the highest was achieved in Navypyitaw city and the least was in Yangib city. #datavisualization #20dayswithdatachallenge #hertechtrailacademy

Day 3:Calculating Total sales and Average order value using Excel I calculated the Total sales and Average order value using the Sum formula of the Total column and Average formula respectively. #20dayswithdatachallenge #hertechtrailacademy #ExcelFormulars #DataAnalysis

Day 13: Sorting Data I retrieved all customer names and arranged them in alphabetical order. #SQLSorting #Datamanupulation #20dayswithdatachallenge #hertechtrailacademy

Day 11:SQL Basics Query retrieved all Columns from accounts table in the Parch and Posey paper company. #SQLQuery #20dayswithdatachallenge #hertechtrailacademy

Day 12: Filtering Data Orders for customer with Id 1021, having total of 10 orders from 12th Oct 2015 to 9th February 2016. #SQLFiltering #Dataquerying #20dayswithdatachallenge #hertechtrailacademy

The #20dayswithdatachallenge gets me excited by the day as I discover how much I can do as a data analyst 💯🥰 #20dayswithdata, #day3 #hertechtrailacademy #HTTADataChallenge #Excelformulas #DataAnalysis

#20dayswithdatachallenge. Day 1. I am Chinalurum Clementina, An Agricultural Economist, Educationist, Data Analyst and more🥰 It's been an awesome experience with HerTechTrail Academy Cohort 7 Data Analytics starter track 🥳🥳 #20dayswithdata #HertechtrailAcademy

DAY 1: Hi everyone, My name is Azubuike Esther, I'm excited to accept the #20dayswithdatachallenge with @hertechtrail it will be an amazing experience! #HertechtrailAcademy #HTTDatachallenge @phaibooboo @ImaNjokko @fresh_gb @vicSomadina @AtiJoshua @OMOTOSHOOLAMI15

DAY 3; This Dataset contains information of ordered/sold items. We calculated the average order sales and the total sales using Basic Excel formulas. Pictures below. #20dayswithdatachallenge at #hertechtrailacademy. #HTTdatachallenge.#Excelformulas.#DataAnalysis. @ImaNjokko

DAY3 of #20DaysWithDataChallenge I did some calculations on the supermarket sales dataset using 'SUM' and 'AVERAGE' functions in excel. @hertechtrail @phaibooboo @ImaNjokko @vicSomadina @OMOTOSHOOLAMI15 @AtiJoshua @fresh_gb #HTTDataChallenge #ExcelFormulas #DataAnalysis

Day 10: Data Validation To avoid Invalid product entry, Data validation was done such that Entries will be greater than or equal to 1 and the corresponding Error message. #datavalidation #DataQuality #20dayswithdatachallenge #hertechtrailacademy

Couldn't follow up for some days but I'm Back Day 7: Advanced Formulas Index function retrieved the Product line if the 10th Order and the Gender Match function was used to find the First Member Purchase Occurrence #20Dayswithdatachallenge #hertechtrailacademy #DataExtraction

Day 8: Data Analysis Analysing the Total sales per month and income generated for each month, it shows that ; The most Sales were made in January, a dip occured in February and sales increased in the month of March. #SalesAnalysis #20dayswithdatachallenge #hertechtrailacademy

Day 2: Data import and cleaning I removed duplicates from the ID column and handled missing values by replacing blank cells with N/A using the find and replace function. #datafam I am open for corrections #20dayswithdatachallenge #hertechtrailacademy #HTTDatachallenge

Day4: Conditional Formatting Inorder to find Customers with high Sales value I applied conditional formatting on the Total sales column for sales above Average and highlighted such cells with a Dark red color. #20dayswithdatachallenge #hertechtrailacademy #ConditionalFormatting

Day13 of #20DaysWithDataChallenge The challenge is to write a SQL query to retrieve customer names alphabetically. Using Parch and Posey Database. SELECT * FROM accounts ORDER BY name #SQLSorting #DataManipulation #httdatachallenge @hertechtrail @phaibooboo @ImaNjokko