Blog
20-table Join Spanning 20 Systems Proves the Data Rosetta Stone Theory
The Rosetta Stone, a 2,200-year-old slab of black granite, unlocked the secrets of ancient Egypt, bridging a 1,400-year gap in understanding their written language. Discovered in 1799, it bears the same decree inscribed in three scripts: Greek, Demotic, and Egyptian hieroglyphs. This trifecta became the key for scholars, led by Jean-François Champollion, to decode hieroglyphs,…
Read MoreYour Company has 10,000 Laptops. Make them all Data Warehouses.
It’s a bird, it’s a plane, it’s Superman. Wait, it’s a query tool, it’s a Toad, it’s Informatica, it’s Tableau, it’s MicroStrategy, it’s a Rosetta Stone, it’s a data warehouse. Oh my goodness, it’s Nexus. Your company has 10,000 laptops and PCs with a CPU and memory capable of processing data like a data warehouse.…
Read MoreThe Greatest Query Tool Does What Was Once Thought Impossible
Database vendors have enormous power because once you choose them, they own you. I love databases, but my first goal was to build the world’s greatest query tool and put the power into the hands of the users. I chose the name Nexus because it is the intersection where all databases meet. My second goal…
Read MoreOne Query Tool Company Wide is Now the Best Strategy
Every company stores data on dozens to hundreds of databases and purchases different query tools, costing millions annually. Getting users to give up their favorite query tool used to be impossible, but anyone who has tried Nexus Version 18.5 (available for a free trial) soon finds it the only query tool everyone loves using. While…
Read MoreBest Practices For Federated Queries
Introduction to Federated Queries Almost every developer or database user has joined two or more tables on a database using SQL. A federated query joins two or more tables or views on separate database platforms and runs as a single query. The layman’s term is a cross-system join, but experts refer to these as federated…
Read MorePostgres Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Postgres is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreGreenplum Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Greenplum is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreNetezza Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Netezza is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreVertica Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Vertica is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreYellowbrick Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Yellowbrick is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreIBM DB2 Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! IBM DB2 is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…
Read MoreOracle Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Oracle is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreTeradata Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Teradata is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreAmazon Redshift Analytics – Group By Grouping Sets, Rollup, and Cube
I can teach you analytics! Amazon Redshift is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…
Read MoreGoogle BigQuery Analytics – Group by Grouping Sets, Rollup, and Cube
I can teach you analytics! Google BigQuery is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…
Read MoreSQL Server Analytics – Group by Grouping Sets, Rollup, and Cube
I can teach you analytics! SQL Server is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly…
Read MoreDatabricks Analytics – GROUP BY GROUPING SETS, ROLLUP, and CUBE
I can teach you analytics! Databricks is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreSnowflake Analytics – GROUP BY GROUPING SETS, ROLLUP, and CUBE
I can teach you analytics! Snowflake is built for analytics, and this blog will brilliantly show you something amazing you have probably never seen before. You will witness the Group By Grouping Sets, Rollup, and Cube, three techniques you will add to your analytic arsenal. GROUP BY GROUPING SETS, ROLLUP, and CUBE are particularly useful…
Read MoreData Migration Best Practices
Introduction As a professional in the field, I have helped some of the largest financial institutions and insurance companies migrate multiple on-premises database systems to the cloud through software that has taken my team decades to build. The first lesson I learned is that if a company wants to move data from legacy or on-premises…
Read MoreYellowbrick Analytics – Moving Average
I can teach you analytics! Yellowbrick is built for analytics, and this blog will brilliantly show you the moving average. A moving average allows you to look for trends in your data. The most famous moving average is the Dow Jones Industrial 65-day moving average, but you can use a moving average to analyze trends…
Read More