Passion for your work is a little bit of discovery, followed by a lot of development, and then a lifetime of deepening. — Grit the Power of Passion and Perseverance Angela Duckworth

Passion Project ​

I started this blog because I wanted to show people how easy it is to use business analysis software to visualize data and generate insights. I love doing this and cannot help, but want to teach others how amazing and useful these tools are. But this blog is more than that. This blog is a passion project that provides me (and others on occasion) with…


Understanding and interpreting data is the final stage of a long journey. Data starts in its raw format is then compiled, cleaned and translated into information, knowledge and finally wisdom.

One of the most common challenges companies face when investing in improving their data process is bridging the gap between data infrastructure and analytics. The answer to this problem is to hire a data engineer.

A data engineer is an engineering role within a data science team or any data related project that requires creating and managing technological infrastructure of a data platform.

Processing data systematically requires a dedicated ecosystem…


“A data scientist is someone who is better at statistics than any software engineer and better at software engineering than any statistician.”
— Josh Wills of Cloudera

90% of the data we have today was generated in just the past two years. For businesses and organizations that can learn and benefit from that data, the explosive growth seems like a dream come true. However, that data is meaningless without ways to capture and analyze it. A fact that is driving the strong demand for data science professionals.

Data science can cover virtually any quantitative work. Two data scientists at different…


You’ve heard the job title “data analyst” floating around lately and it sounds like an intriguing career. The idea of working with data and technology has piqued your curiosity, but what does a data analyst do all day?

Data analysts spend their workdays digging into big data and making it useable for the company they work for. This includes tasks like analyzing data systems, automating information retrieval and preparing reports that show managers how this data could be applied to their business model.

A day in the life of a data analyst

Generally speaking, a data analyst will retrieve and gather data, organize it and use it to reach…


Why is everybody obsessed with data, big data, structured data, and analytics? Is every profession really going to depend on data or is it just a trend/fashion of our decade that will vanish in the future?

On the contrary, if you ask me, I think data and analytics are really just getting started in the business world. Everything tends to be connected. Every company is trying to be data driven, to be a company that uses its data to optimize decision making and improve their competitive advantage.

Professional business analysts can play a critical role in a company’s productivity, efficiency…


“Data is the new currency, it’s the language of the business. We need to be able to speak that.” — Piyanka Jain

Are you a budding analyst?

If you can describe yourself as the powerful combination of data hacker, analyst, communicator, and advisor you probably are. Analyst need to be able to see both the big picture trends and the detailed numerical data.

MIT grad Kay Aull put it like this “There’s data everywhere. Have you ever said “Hmm, I wonder… and then lost hours of your life trying to kludge together an analysis?” …


Are you exploring a business analyst role and wondering if you have the required business analysis skills and experience?

There is a wide range of essential skills you’ll need as a business analyst, from communication skills to technical skills, I am here to show you the core skills every business analyst needs.

Communication

Business analysts spend a significant amount of time interacting with clients, users, management, and developers. Therefore, being an effective communicator is key. You will be expected to facilitate work meetings, ask the right questions, and actively listen to your colleagues to take in new information and build relationships…


If you have Excel 365, it’s time to leave VLOOKUP behind!

Microsoft released a function called XLOOKUP. This function should replace the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data.

Excel users now have a new function that is more user-friendly, more flexible and avoids some frustrating and time consuming VLOOKUP mistakes.

VLOOKUP function in Excel

This is how it looks:

=VLOOKUP(lookup_value, table_array, column_index, [match_mode])

  • lookup_value: this is what you want to look up, here it’s your 1st list of IDs.
  • table_array: this is where you want to look for it, here it’s the 2nd list…


I am lucky enough to have just started my colleges senior seminar class: Seminar on Life Management.

Another name for this class could be: Adulting 101

This class covers a variety of post college necessary knowledge such as: accepting/negotiation your first job offer, taxes and IRS forms, health insurance, saving/investing/401K, budgeting and common expenses, debt/credit cards/credit score, and creating work-life balance/good habits.

That is a lot of material to cover in just 5 weeks, but I am very grateful that I have the opportunity to learn these things and ask questions before I encounter these in real life, a lot of college grads do not get this chance.

Here…


Imagine being able to use big data to design a model that will ease traffic and make transport in major cities easy and convenient. This and many more can be done and one of the skills needed by a data scientist is SQL.

With massive data currently available, businesses and industries are compiling Terabytes of information every day. The big data phenomenon requires a proper skill set to be able to make meaning out of it, a great way to do that is SQL.

What is SQL?

SQL (Structured Query Language) is a popular database language that is used to create, maintain and…

Sarah Robinson

Data-driven business analyst focused on gathering vital business intelligence to meet company needs and passionate about showing how easy analytics can be

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store