Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

Image
SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT t1.id, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON t1.id >= t2.id GROUP BY t1.id, t1.value ORDER BY t1.id; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

Tableau 2 Top Books to Read

In this post, I have given two top data visualization in Tableau books. These books helpful for your self-study.  


Tableau 2 Top Books to Read

Top Tableau Course Contents


  • Introduction to Tableau 
  • Connecting to data 
  • Visual analytics 
  • How to design dashboard 
  • Mapping 
  • Calculations 
  • How to publish and Manage with Tableau 
  • Security with Tableau .....Read more.

Two Best books on Tableau to Learn and Visualize the Data.


#1. Learning Tableau

  • Learn how to create effective data visualizations with Tableau and unlock a smarter approach to business analytics. 
  • It might just transform your organization About This Book
  • Create stylish visualizations and dashboards that explain complexity with clarity.
  • Learn effective data storytelling to transform how your business uses ideas and makes decisions
  • Explore all the new features in Tableau 10 and start to redefine what business. analytics means to your organization.

#2. How to create Data Visualization in Tableau 

  • Tableau Your Data! is a comprehensive guide to the effective use of the Tableau Software toolset for data visualization.
  • It covers the core feature set for data analytics, illustrating best practices for creating and sharing effective visualizations that support timely business decision-making.
  • The author also covers little-known as well as more advanced features and techniques, illustrating them using detailed, real-world case studies that the author has developed as part of his consulting and training.

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers