Posts

Showing posts from 2014

A Small Gift for New Graduates: 4 Suggestions for Job Hunting

Image
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.

Two main misleading features of Google Maps on iPhone

Image
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. 

How to embed the Tableau dashboard on Weebly?

Image
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 relat

Awesome online free sources for you to start learning SQL and prepare for the Oracle Certification Exam

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. Don't worry. I called the custom

Lessons I learned from SQL Interview

Image
So today I had a technical interview with a company in Seattle. It was my first technical interview after two months of job hunting in the west coast. I am writing this posts to remember what I made a mistake in SQL as people usually say we learn lessons from mistakes and failure.  First, About the rule that "GROUP BY function only allows you to SELECT two columns at a time".  Remark: This does NOT include the new column you generate by using COUNT!! Typical way you write a query with GROUP BY is like this: SELECT Column1, Column 2 FROM TableName GROUP BY Column1;  HOWEVER, if you want to COUNT something else besides Column 1 and Column 2, you can write: SELECT Column1, Column2, COUNT(Column3)  FROM TableName GROUP BY Column 1;  SQL will not generate the errors when you put the third elements "COUNT(Column3) before "FROM TableName GROUP BY Column1" because "COUNT(Column3)" is not considered as the third column in the "GROUP BY&quo

Tableau Annual Conference 2014

Image
Sep 8 to Sep 12, a huge data party took place in Convention Center in Seattle. It was an amazing week for any data enthusiasts from the data visualization industry. If you miss the conference, just search #data14 on Twitter or Instagram.  Monday Sep 8 Highlights of the Day: Lunch + Reception  I had a great lunch with Andy Kriebel , Bryan Brandon , and Alberto Cairo at the Cheesecake Factory just across the street of the Convention Center. It was my first meeting with the members from the Data Viz Team of Facebook !  Photo credits for Andy and Bryan. Andy shared his pictures on flickr. Check out here .  Reception began in the late afternoon with the warm welcoming music. The giant rectangle screen streamed the live Twitter and Instagram data.. (Yes, we are pretty nerdy :P)  At the reception, I had a great talk with the data viz professionals. I got to learn that Product Consultant at Tableau was not just a sales person but also a technician for the product. The Product