DATADLE: A Daily Word Game for Data Engineers

-

Comments

Post a Comment

Popular posts from this blog

How to fetch data from SnowFlake using Excel VBA?

-
Image
The easiest way to fetch data from databases to Excel is using the Get Data option available under the Data Tab, Excel creates a query using the ODBC connection and fetches the data without the hassle of coding. But coding makes the process more flexible and is very dynamic. Here goes the details... 1) Download and install the snowflake ODBC driver either 32 or 64 bit depending on your MS Office Installation & OS from the SnowFlake portal, available under the Help menu. 2) Create a DSN with the correct connection properties. 3) Add the below reference if required in the visual basic editor and also change the DSN name in the VBA code. VBA Code...  '----------------------------------------------------------------------------------------------------------------------------------------- Sub VBA_SnowFlake_Connect() Dim sSQLQry As String Dim ReturnArray Dim Conn As ADODB.Connection Dim rs As ADODB.Recordset Dim DBPath As String, sconne...
Read more

How to clear Tableau Desktop Qualified Associate Exam (TDQA 10).

-
Preparation Time : Minimum 4 weeks for candidates with no prior Tableau experience. Tableau DQA is a 2 hours exam which consists of 36 questions, both theoretical and practical. All questions must be answered to complete the test(there is no negative marks) and 75 % score is needed to pass the test. Questions are either multiple-choice, multiple-answer, or True /False. TDQA10 . Total Time 2 hrs. Total Questions 36 Marks distribution 2,3&4 Total Points 100 Passing Points 75 Category Points Mod 1 - Data Connections 22 Mod 2 - Organizing and Simplifying Data 10 Mod 3 - Field and Chart Types 16 Mod 4 - Calculations 18 Mod 5 - Mapping 8 Mod 6 - Analytics 15 Mod 7 - Dashboards 11 Total 100 TDQA Preparation Materials Watch all the Tableau...
Read more

All you need to know about the Google Data Studio

-
Google data Studio(GDS) is based on SaaS(Software as a service, cloud-based) model and in my first look it is a neat and clean visualization tool primarily focused on Google data sources. So for businesses who are into google analytics or Google products can create great visualizations in minutes using DATA STUDIO. It is a free tool for now and is still in beta version. Other than google providers GDS can connect to CSV and databases like MySQL, PostgreSQL .For all other data sources, there are third-party community connectors available. URL: https://datastudio.google.com/u/0/navigation/reporting The look and feel are similar to other Google products like Google Sheets & Docs and all the reports created are saved in google drive. Here goes the list of features that I liked the most in GDS 😊. Easy to share the reports and works similar to file sharing in google drive(even edit permission is possible). Easy to copy the reports and any reports can be used as a template ...
Read more