"a tale" is a story. He means that life is "a tale told by an idiot" in other words a story with no meaning or significance. The next sentence of the speech explains that we have a short time on the "stage of life" like actors,and then at the end of the play we disappear and nothing is left.