PinnedPublished inDataDrivenInvestor7 MS Excel Tricks You Must Know as a Data AnalystHere are time-saving tricks I wish I had learned sooner in my data career.Oct 13, 20247Oct 13, 20247
PinnedPublished inDataDrivenInvestorWhere is “Science” in Data Science?A brief exploration to the nature of data science and how it relates to the scientific method and academic sciences.Jul 10, 2023Jul 10, 2023
PinnedPublished inDataDrivenInvestorData Modeling in Power BIWhy data modeling is a crucial step before analyzing and visualizing data in Power BI? Let’s find out via a Star Schema example.Nov 13, 20236Nov 13, 20236
Published inDataDrivenInvestorHow to Compare Two Datasets to Validate AccuracyYou found some errors in the dataset of another team. How would you support your point?4d ago4d ago
Published inDataDrivenInvestorExcel’s XLOOKUP: A More Efficient Alternative to VLOOKUP and INDEX MATCHLet’s demonstrate XLOOKUP capabilities that are missing from VLOOKUP and INDEX MATCH.Mar 3Mar 3
Published inDataDrivenInvestorBeginner’s Guide in Querying SQL Databases as a Data AnalystHere are 5 ways to query databases relevant to our data projects.Jan 17Jan 17
Published inDataDrivenInvestorStructuring Data Teams From Raw Data to InsightsWhat data teams should we have and what are their functions?Nov 25, 2024Nov 25, 2024
Published inDataDrivenInvestor4 Tips to Ensure Data Accuracy in Our Analytics Projects“Am I seeing/using the right data?” If you ask that question from time to time, then this article is for you.Nov 1, 2024Nov 1, 2024
Published inDataDrivenInvestorThe “End of History Illusion”A quick reflection of my past, an illusion of my futureSep 28, 2024Sep 28, 2024
Published inPython in Plain EnglishCreating a Racing Bar Chart Animation with Power Query and PythonLet’s animate the top 15 countries with the most freedom from 2000 to 2021 using Power Query and PythonJun 23, 2024Jun 23, 2024