This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like.

    Based on numerous interviews, this book reveals exclusive new information about how Apple innovates, deals with its suppliers, and is handling the transition into the post Jobs era.

    His job no longer existed. "I think they just want to hire younger people," his boss at Newsweek told him. Fifty years old and with a wife and two young kids, Dan was, in a word, screwed. Then an idea hit. Dan had long reported on Silicon Valley and the tech explosion. Why not join it? HubSpot, a Boston start-up, was flush with $100 million in venture capital. They offered Dan a pile of stock options for the vague role of "marketing fellow." What could go wrong? HubSpotters were true believers: They were making the world a better place ... by selling email spam. The office vibe was frat house meets cult compound: The party began at four thirty on Friday and lasted well into the night; "shower pods" became hook-up dens; a push-up club met at noon in the lobby, while nearby, in the "content factory," Nerf gun fights raged. Groups went on "walking meetings," and Dan's absentee boss sent cryptic emails about employees who had "graduated" (read: been fired). In the middle of all this was Dan, exactly twice the age of the average HubSpot employee, and literally old enough to be the father of most of his co-workers, sitting at his desk on his bouncy-ball "chair."Mixed in with Lyons's uproarious tale of his rise and fall at Hubspot is a trenchant analysis of the start-up world, a de facto conspiracy between those who start companies and those who fund them, a world where bad ideas are rewarded with hefty investments, where companies blow money lavishing perks on their post-collegiate workforces, and where everybody is trying to hang on just long enough to reach an IPO and cash out. With a cast of characters that includes devilish angel investors, fad-chasing venture capitalists, entrepreneurs and "wantrapreneurs," bloggers and brogrammers, social climbers and sociopaths, Disrupted is a gripping and definitive account of life in the (second) tech bubble.

    He had mentored many tech leaders in his illustrious career as an investor, but few things had made him prouder, or been better for his fund's bottom line, than his early service to Mark Zuckerberg. Still a large shareholder in Facebook, he had every good reason to stay on the bright side. Until he simply couldn't. ZUCKED is McNamee's intimate reckoning with the catastrophic failure of the head of one of the world's most powerful companies to face up to the damage he is doing. It's a story that begins with a series of rude awakenings. First there is the author's dawning realization that the platform is being manipulated by some very bad actors. Then there is the even more unsettling realization that Zuckerberg and Sheryl Sandberg are unable or unwilling to share his concerns, polite as they may be to his face."

    As they helped grow Google from a young start-up to a global icon, they relearned everything they knew about management. How Google Works is the sum of those experiences distilled into a fun, easy-to-read primer on corporate culture, strategy, talent, decision-making, communication, innovation, and dealing with disruption.The authors explain how the confluence of three seismic changes - the internet, mobile, and cloud computing - has shifted the balance of power from companies to consumers. The companies that will thrive in this ever-changing landscape will be the ones that create superior products and attract a new breed of multifaceted employees whom the authors dub 'smart creatives'. The management maxims ('Consensus requires dissension', 'Exile knaves but fight for divas', 'Think 10X, not 10%') are illustrated with previously unreported anecdotes from Google's corporate history.'Back in 2010, Eric and I created an internal class for Google managers,' says Rosenberg. 'The class slides all read 'Google confidential' until an employee suggested we uphold the spirit of openness and share them with the world. This book codifies the recipe for our secret sauce: how Google innovates and how it empowers employees to succeed.'

    It shows how to integrate online and offline networking to supercharge both personal and professional connections.

    Regardless of your budget, you are almost certainly overspending on television, radio, and print ads, yet neglecting the number-one resource you have at your disposal: the Internet. Content marketing is no longer about keyword-stuffing and link-building; in fact, using those tactics today gets your page shuffled to the bottom of the heap. Quality content is the key to success, and you already have the ingredients in-house. This book shows you how to structure an effective content strategy using the same proven principles that have revolutionized marketing for all types of businesses, across industries.Author Marcus Sheridan's pool company struggled after the housing collapse; today, they're one of the largest pool installers in the U.S., turning away millions of dollars in business they simply cannot accommodate every year. How did he manage it? He answered questions. This book shows you how Marcus's strategy can work for your business, and how to use your keyboard to bring customers through the door.Boost your company's web presence with methods that work Build a level of trust that generates customer evangelism Leverage your in-house resources to produce winning content Utilize tactics that work, regardless of industry or sector When people have questions, they ask a search engine. If you have answers, the right content strategy will get them to the top of the search results and seen by millions of eyes every day. Drop the marketing-speak, stop "selling," and start answering. Be seen as an authority, not just another advertisement. They Ask You Answer describes a fresh approach to marketing and the beginning of big things for your business.

    In a restless and mobile nation he could have escaped from the past, assumed another identity. But in the close-knit community of South Kenton at the turn of the century, he could not escape. — From his earliest years, Dan seemed marked out by fate as one of its victims. In the eyes of the small respectable American town he was an outcast, a social misfit. His mother was dead; his father was only a blacksmith and , what was worse, a drunkard, and the two of them lived in a two-room shack behind the smithy. When Dan fell in love, it was with a woman twenty-two years older than him; when he got married, it was to a woman who hated him and wanted to make him suffer, and who succeeded - even after her death.This is the poignant story of a man who chose to do more than to look and pass'; a man who was good, honorable and high of heart, but whose end was lonely and tragic.

    How many likes? How many purchases? How many email subscribers?But as entrepreneurs, we have to remember that there are people behind all that data. People who are looking to us to be a leader, to give advice, and to care. They are looking for trustworthy tools and resources, and for someone to help them to achieve their goals. In this dog-eat-dog world, these are the people who are looking for someone who they can trust, and who they know have their best interests in mind.These are the people, if you connect with them in the right way, who will become Superfans.Followers may "like" an Instagram post. Customers may buy a product. But "Superfans" will be your biggest supporters. They will promote you and your products because they know you have made a difference in their lives. They will tell their friends. They will send you encouraging emails. They will connect with you and your other fans.Whether you're a shy YouTuber just starting out, or the leader of a Fortune 500 company, your superfans are out there waiting for you to connect with them. You just need to create that journey, to pave the yellow-brick road that will guide them surely and steadily to superfandom.You don't need to change the entire world to build a successful business; you just need to change someone's world.People don't become superfans the moment they find you. They become superfans because of the magical moments you create for them over time.This book will help you do just that.

    But what if everyone is wrong?In their acclaimed bestseller The Challenger Sale, Matthew Dixon and his colleagues at CEB busted longstanding myths about sales. Now they've turned to a new vital business subject - customer loyalty - with a book that turns conventional wisdom on its head.Companies devote untold time and resources trying to dazzle customers. Yet CEB's careful research proves that is wildly overrated: loyalty has a lot more to do with how well companies deliver on their basic promises than on how dazzling the service experience might be. Forget bells and whistles and just solve your customer's problems. The Effortless Experience lays out the four pillars of a low-effort customer experience, with robust data, in­sights and profiles. Here are tools and templates you can start applying right away to improve service, reduce costs, and ultimately generate the elusive loyalty that the 'dazzle factor' fails to deliver.The rewards are there for the taking, and the pathway to achieving them is now clearly marked.'A business detective story, in which cherished truths are systematically investigated-and frequently debunked' -Dan Heath, coauthor of Decisive, Switch, and Made to StickMatt Dixon is Executive Director of the Sales & Service Practice at CEB. He is a frequent contributor to the Harvard Business Review, and his previous book, The Challenger Sale, was a Wall Street Journal bestsellerNick Toman is Senior Director of Research for CEB's Sales & Services Practice and is a frequent contributor to the Harvard Business Review.Rick DeLisi is Senior Director of Advisory Services for CEB's Sales & Service Practice and a noted public speaker and facilitator.

    The notion may be outlandish, but it reflects executives’ drive to understand shoppers in the aisles with the same obsessive detail that they track us online. In fact, a hidden surveillance revolution is already taking place inside brick-and-mortar stores, where Americans still do most of their buying. Drawing on his interviews with retail executives, analysis of trade publications, and experiences at insider industry meetings, advertising and digital studies expert Joseph Turow pulls back the curtain on these trends, showing how a new hyper-competitive generation of merchants—including Macy’s, Target, and Walmart—is already using data mining, in-store tracking, and predictive analytics to change the way we buy, undermine our privacy, and define our reputations.  Eye-opening and timely, Turow’s book is essential reading to understand the future of shopping.

    We Are the Nerds is a riveting look deep inside this captivating, maddening enterprise–whose army of highly engaged (obsessed?) users have been credited with everything from solving cold case crimes to seeding alt-right fury and helping to land Donald Trump in the White House. We Are the Nerds is a gripping start-up business narrative: the story of how Reddit’s founders, Steve Huffman and Alexis Ohanian, rose up from their suburban childhoods to become millionaires and create an icon of the digital age–before seeing the site engulfed in controversies and nearly losing control of it for good. Based on Christine Lagorio’s exclusive access to founders Alexis Ohanian and Steve Huffman, We Are the Nerds is also a compelling exploration of the way we all communicate today–and how we got here. Reddit and its users have become a mirror of the Internet: it has dingy corners, shiny memes, malicious trolls, and a sometimes heart-melting ability to connect people across cultures, oceans, and ideological divides.

    It includes information on the latest third party applications, strategies and tactics for using Twitter's 140-character messages as a serious--and effective--way to boost your business, as well as how to turn Twitter into your personal newspaper, tracking breaking news and learning what matters to you and your friends.Co-written by Tim O'Reilly and Sarah Milstein, widely followed and highly respected twitterers, the practical information in The Twitter Book is presented in an innovative, visually rich format that's packed with clear explanations and examples of best practices that show Twitter in action, as demonstrated by the work of over 60 twitterers.This book will help you:Use Twitter to connect with colleagues, customers, family, and friends Stand out on Twitter Avoid common Twitter gaffes and pitfalls Build a critical professional communications channel with Twitter--and use the best third-party tools that help you manage it. If you want to know how to use Twitter like a pro, The Twitter Book will quickly get you up to speed.About the authors: Tim O Reilly (@timoreilly), founder and CEO of O Reilly Media, has hundreds of thousands of followers on Twitter. Sarah Milstein (@SarahM) frequently writes, speaks and teaches about Twitter; she was the 21st user of Twitter.

    Now, they build on their message with a bold, iconoclastic strategy for creating the ideal company culture—what they call "the calm company." Their approach directly attack the chaos, anxiety, and stress that plagues millions of workplaces and hampers billions of workers every day.Long hours, an excessive workload, and a lack of sleep have become a badge of honor for modern professionals. But it should be a mark of stupidity, the authors argue. Sadly, this isn’t just a problem for large organizations—individuals, contractors, and solopreneurs are burning themselves out the same way. The answer to better productivity isn’t more hours—it’s less waste and fewer things that induce distraction and persistent stress.It’s time to stop celebrating Crazy, and start celebrating Calm, Fried and Hansson assert.Fried and Hansson have the proof to back up their argument. "Calm" has been the cornerstone of their company’s culture since Basecamp began twenty years ago. Destined to become the management guide for the next generation, It Doesn't Have to Be Crazy at Work is a practical and inspiring distillation of their insights and experiences. It isn’t a book telling you what to do. It’s a book showing you what they’ve done—and how any manager or executive no matter the industry or size of the company, can do it too.

    This might seem uncontroversial, but it flies in the face of a tech sector long obsessed with rapid growth and sometimes on disruption as an end in itself. Now, though, we have reached an inflection point: Silicon Valley has moved fast and it has broken things. A new understanding has emerged that companies that create technology must accept greater responsibility for the future. And governments will need to regulate technology by moving faster and catching up with the pace of innovation that is impacting our communities and changing the world.In Tools and Weapons, Brad Smith takes us into the cockpit of one of the world's largest and most powerful tech companies as it finds itself in the middle of some of the thorniest emerging issues of our time. These are challenges that come with no preexisting playbook, including privacy, cybercrime and cyberwar, social media, the moral conundrums of AI, big tech's relationship to inequality and the challenges for democracy, far and near. While in no way a self-glorifying "Microsoft memoir," the book opens up the curtain remarkably wide onto some of the company's most crucial recent decision points, as it strives to protect the hopes technology offers against the very real threats it also presents. Every tool can be a weapon in the wrong person's hands, and companies are being challenged in entirely new ways to embrace the totality of their responsibilities. We have moved from a world in which Silicon Valley could take no prisoners to one in which tech companies and governments must work together to address the challenges and adapt to the changes technology has unleashed. There are huge ramifications to be thought through, and Brad Smith provides a marvelous and urgently necessary contribution to that effort.