PinnedPublished inDataDrivenInvestorStructuring Data Teams From Raw Data to InsightsWhat data teams should we have and what are their functions?Nov 25, 2024Nov 25, 2024
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, 2024A response icon8Oct 13, 2024A response icon8
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, 2023A response icon6Nov 13, 2023A response icon6
Published inDataDrivenInvestorThinking Like a Philosopher as a Data ProfessionalHow philosophical thinking helped me excel in my data career5d ago5d ago
Published inDataDrivenInvestorHow to Compare Two Datasets to Validate AccuracyYou found some errors in the dataset of another team. How would you support your point?Mar 29Mar 29
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 17A response icon1Jan 17A response icon1
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
