Viz Panda

If you are looking for script that allows you to get approximate p-value for your A/B testing, this is the place for you. Or if you are looking for reference to calculate p-value and z-value due to the limited available maths methods in SQL, the python script can be translated in SQL user define function. 

A lot of researches gave us the fancy definition about Data Science and Business Intelligence. I interviewed a few of my friends from my master program most of whom are working as a Data Scientist or Business Intelligence Engineer or Data Engineer in the tech industry. Since I am working in Amazon instead of the academic research environment, I will combine my experience and and my friends' interviews to discuss the responsibilities of a Data Scientist or a BI Engineer. 

Big Four Ice Cave is a beautiful hiking place of Mountain Baker northeast to Seattle. Despite the avalanche of the Big Four Snow Mountain on Dec 31st, 2014, the parking lot of the ice cave trail was full packed on at 3pm on Jan 1st, 2015. I never considered Instagram as the best real time weather until the New Year’s Day 2015. The location of Big Four Ice Cave was marked on Instagram map in a place more than 50 miles away from the real location, but as long as I tapped the location feature on Instagram, all the images shot in Big Four Ice Cave was organized at the bottom of the map. When I tapped the image, Instagram told me that how many hours or days ago the user posted on Instagram.

Responding to the huge success of Wechat Lucky Money in 2014, the e-commerce giant in China, Alibaba also launched the Lucky Money Giveaway on their official website, delivering 1 billion Yuan (equal to about 1.6 billion USD) to all Alipay users. You don’t have to participate in any silly 10-minutes survey or fill out any application forms to participate on Alibaba website.

It’s almost Christmas. We just graduated from school in December and now cheer with our family in a cozy house this week of Christmas, but at the same time, we feel so nervous and anxious about the new year of job hunting. I am not a recruiter, or a manager with many years of experience. I am one of the thousands of new graduate students with zero years of full time working experience. After three months of job hunting after my graduation from the University of Cincinnati, I landed my job at Amazon.com as a BI Engineer at the beginning of November. I would like to share my story of job hunting here with you.

For years I have been a big fan of Google and fascinated about the awesome features of Google Maps. The most recent version of Google Map on iOS looks very similar with the new Google Map on Lollipop, but not entirely. At the same time, I am confused about direction by two new features on the map. 

Recently a few friends asked me question about how to embed the Tableau dashboard on your weebly, your page, or your squarespace which provided HTML coding features.  Trust me, Tableau did not ask you for any coding skills when you want to put your awesome dashboard on your site. What you need to do is just "copy and paste". So let's get started.  Step 1: Upload your files on Tableau Public Upload it directly from your Tableau Desktop. Server --> Tableau Public --> Save to Web After you finished the step shown in the image above, a window will pop up.  Here it asked for your Tableau Public account. Your Tableau account is separated from your Tableau Public account , which means that you have to register a Tableau Public, sepearted from Tableau account to upload your files. Don't get stuck in this step when the window constantly reminds you of an error on your username and password.  After you upload your dashboard and rela...

According to Oracle website (Original link is here ), in order to get the Oracle Database Administrator Certified Associate Level, candidates have to pass one of the three exams: - Oracle Database 11g: SQL Fundamentals I (Exam #: 1Z0-051)  - Oracle Database 12c: SQL Fundamentals (Exam #: 1Z0-061) - Oracle Database SQL Expert (Exam #: 1Z0-047) And after you pass one of the three exams listed above, you have to pass Oracle Database 11g: Administration I (Exam #: 1Z0-052)  I chose  Oracle Database 11g: SQL Fundamentals I (Exam #: 1Z0-051)  as my goal during the first step of getting the certification. If you chose the training provided by Oracle, it would cost you a lot of money. So I am going to introduce some websites to save you $3000.  1. CBT Nuggets (  https://www.cbtnuggets.com/ )  This is the best site I found on Google after searching for half an hour. It asked you to put your credit card information when you open the 7-day free trail. Do...