New year, new you and new opportunities. If you were ever thinking about starting a career as a data analyst, either as a fresh first-time job seeker, career changer or if you want to upskill. There are loads of resources out there to help you meet your goals and all they’ll cost you is yourContinue reading “3 Excellent Freesources for Becoming a Data Analyst in 2024”
Author Archives: thescrappyanalyst
5 Reasons You Need to Focus on Data Curation (and How to Get Started)
It takes ZERO technical skills to accomplish. The employment outlook for data careers is booming. Whether you are looking to be a data scientist, data analyst, data architect or BI engineer, there are no shortage of openings at companies all over the world. Because of this boom many analysts are honing their technical skills toContinue reading “5 Reasons You Need to Focus on Data Curation (and How to Get Started)”
Data Modeling for Power BI
When you think of Microsoft’s Power BI you probably think about the attractive visualizations, but the tool’s biggest flex is it lets you create a mini data warehouse right in the desktop app. If you are working in a large company with a well-developed data strategy this may not be necessary, but if you workContinue reading “Data Modeling for Power BI”
Three Reasons to Learn SQL if You Want a Career in Analytics
According to the Bureau of Labor Statistics, employment of operations research analyst positions are expected to increase by 25% over the next 9 years, much higher than the average occupation (Bureau of Labor Statistics, 2020). Great news for you if you’re seeking a career in data analytics! This growth potential has sparked waves of online coursesContinue reading “Three Reasons to Learn SQL if You Want a Career in Analytics”
Normalization
Database Fundamentals If you’re learning about databases, it won’t be long before you hear the term normalization. It sounds a little scary and some texts used to explain the process can be heavy on jargon, but it is actually intuitive. Understanding this process is one of the cornerstones of understanding how relational databases work. ThereContinue reading “Normalization”