A ticker tape parade was a parade in a downtown urban area on Earth which involved people in buildings throwing down shredded paper or confetti out a window to make the event much more festive. This was often done to celebrate a homecoming, in some capacity.
In 2372, Q offered to return the USS Voyager back to Earth in exchange for Captain Kathryn Janeway to rule against Quinn's request for asylum on the ship. Q told Janeway to think about siding with him and told her that being the Captain who returned Voyager home, there would be a ticker tape parade down Sri Lanka Boulevard in celebration of her. Janeway ultimately turned down Q's offer and gave Quinn asylum aboard Voyager. In reaction, Q stated "So much for ticker tape parades." (VOY: "Death Wish")
In 2377, a hologram of Reginald Barclay modified by the Ferengi told Seven of Nine that there would be a ticker tape parade down Market Street in San Francisco when Voyager returned to Earth if their plan of opening a geodesic fold to return to the Alpha Quadrant was successful. Seven told the Barclay hologram that she would not be attending, but he convinced her that she should as she would be a hero to people who had lost their close ones to the Borg. (VOY: "Inside Man")