Today's Python lesson π
Learned about lists, tuples and sets. Got confused when "type()" returned tuple instead of set, but now I understand why. Turns out, brackets matter!
What's one Python concept that confused you at first?
#Python#DataAnalytics
My OBank SQL projectπ»π
I used MySQL to analyse customer ages, account balances, transaction amounts, yearly activity, and the most-used transaction channel.
Debugging wasn't always easy, but every query teaches me something new.
What's your favourite SQL query?
#SQL#MySQL
SQL has entered my data analytics journey! π»
Foreign key errors, duplicate IDs, debugging. MySQL is testing me, but I'm learning!
SQL people, what's one mistake you made when starting out? ππ½
#SQL#MySQL
Built an Annual Production Report dashboard in Power BI! π
Created tables, KPIs, charts, and slicers to explore production, revenue, profit, and defects.
Learning, building, and improving one project at a time! π
#PowerBI#DataAnalytics
My first Power BI dashboard! π
I transformed and appended the data using Power Query, then customised the dashboard and visuals.
Still learning, but Iβm proud to see my progress. π
#PowerBI#DataAnalytics
Another step in my data analytics journey π
I built an interactive Excel Sales Dashboard with slicers for Region, Country, Item Type, Order Priority & Sales Rep.
Learning how to turn raw data into something interactive and useful! π
#DataAnalysis#Excel#DataAnalytics#Learning
Another Excel project done! π
I cleaned and transformed a sales dataset using Power Query, then used Pivot Tables & Pivot Charts to analyze and visualize the data.
Every project is helping me become more confident. π
#DataAnalysis#Excel#PowerQuery
π Another Excel project completed!
I worked with a University Staff dataset, using Power Query for cleaning & transformation, and XLOOKUP, SUMIF & SUMIFS for analysis.
Building my data analytics skills one project at a time. π
#DataAnalytics#Excel#PowerQuery
Another Excel project completed π
I analyzed exam scores using SUM, AVERAGE, MEDIAN, MODE, IF, COUNTIF and MAX/MIN to calculate totals, grades, pass/fail status and a 79.66% pass rate.
Still learning, still improving, one dataset at a timeπ»π
#Excel. #DataAnalytics.
Restarting my data analysis journey π
I practiced Excel using a student performance dataset, applying SUM, AVERAGE, MODE, MEDIAN, IF, IFS, COUNTIF & Standard Deviation to analyze scores, grades and pass/fail results.
One project at a time. π
#Excel#DataAnalysis