All businesses must make good decisions, or they won’t be in business for very long. Making good decisions requires sound data upon which to act, and to analyze for the insights that can be gained. Communicating that information to the decision-makers is ultra-important because they’re the ones who have to buy in and use the […]
Why Should You Consider Having a Data Analytics Portfolio
Why Should You Consider Having a Data Analytics Portfolio If you want to find a job in the field of data analytics or any job that requires technical skills in MS Excel, Tableau, SQL, PowerBI, Python R etc., then keep reading this article to understand why you need an Analytics Portfolio. What is an Analytics […]
Data Types and Their Impact on Choosing the Right Type of Data Visualization
Data Types and Their Impact on Choosing the Right Type of Data Visualization Choosing the right type of data visualization depends on several factors, of which one of the most important is the type of data to be plotted. Data types dictate which data visualization can or cannot to be used, and this becomes quite […]
Learn Foundational Data Analytics Skills with MS Excel
Learn Foundational Data Analytics Skills with MS Excel Millions of users around the world still use Microsoft Excel as a sophisticated spreadsheet, to perform various accounting functions and to contain lists of useful business items. However, Excel is also a great tool to use when you’re looking to learn basic Data Analytics skills, and for […]
Importance of Data Visualization: Text/Numbers vs. A Visual Chart/Graph
Importance of Data Visualization: Text/Numbers vs. A Visual Chart/Graph A picture is worth a thousand words! Human mind is conditioned to consume visual data quicker than numbers or text. Instead of writing a long article, why don’t we show you visually what we mean? Let’s use an example. Here is a slide that shows the […]
Two ways to join tables in SQL – using JOIN Clause vs Where Clause
Two ways to join tables in SQL – using JOIN Clause vs Where Clause Joins are an integral part of working with data, especially in SQL. When data is stored in tables, joins are used to connect the data points as necessary for retrieving full information. There are two different clauses that can be used […]
Power Up Your Resume With a High-Demand Skill: Tableau
Power Up Your Resume With a High-Demand Skill: Tableau If you’re wondering about the job market for people with Tableau skills, consider the fact that there are currently more than 19,000 job openings in the U.S. alone for people who work with Tableau. This has become an extremely popular tool for data visualization and it is […]
Top 6 Reasons Why You Should Learn SQL In 2022
Top 6 Reasons Why You Should Learn SQL In 2022 It might seem odd to you that something that’s been around since the mid-70’s is still going strong today in the field of computing and databases. Yet, that is exactly the case with SQL, which stands for Structured Query Language. Some people just pronounce it […]
5 Tricks to Elevate Your Data Visualizations (+1 Bonus)
5 Tricks to Elevate Your Data Visualizations (+1 Bonus) “Just as a picture is worth a thousand words, a data visualization is worth a million data points!” – Hira Fatima, CAP (Lead Instructor @ www.LearnDataAnalytics.ca) Understanding a million data points in one glance is nearly impossible, but if those data points are plotted in […]
Top 5 Must-Know Excel Formulas for Data Analysis
Excel has a countless number of formulas and functions that you can use and learn, but when working with data, consider focusing on these 5! 1) VLOOKUP() or better yet, XLOOKUP()! You will never find all the data in one place. That is the sad truth of working with data. Information is usually spread […]