A refresher on SQL – The SQL Murder Mystery

A refresher on SQL – The SQL Murder Mystery

Image from The SQL Murder Mystery Website In my current role, I do not use SQL at all. I have always loved SQL. It is quite the language and I was very happy when @jessica_xls shared the link to The SQL Murder Mystery. I decided to relive my SQL days and what better...
How To Use Python To Publish Data From A CSV To Tableau Server

How To Use Python To Publish Data From A CSV To Tableau Server

Over the past year, I have learned a lot and I am extremely excited to share some of the cool things with you. As the world keeps evolving at a fast pace, it has led to automation. In my daily work, it is a key priority to automate some aspects of work to make life...
How Does a Bike-Share Navigate Speedy Success?

How Does a Bike-Share Navigate Speedy Success?

Difference between a Cyclistic member and a regular user – Across the previous 12 months in Chicago INTRODUCTION The Cyclistic bike share analysis is a project based on a fictional company in Chicago. As an analyst, the goal of this project is to maximize the...
2021 Week 1 | Power BI: Connecting To & Modeling Data

2021 Week 1 | Power BI: Connecting To & Modeling Data

For week 1, I did a data connection is done through online services, data.world instead of uploading the excel data file. This acts as a web connector. Below are the steps I followed to achieve loading in the data: 1. Get Data 2. Select online services 3. Select...