Scott Robinson

Welcome to the first book to explore the powerful tools within Power BI that can enhance and improve your analytical data exploration.You know Power BI’s reputation as a reporting, dashboarding, and data visualization tool but it might not occur to you that it has great value as a tool for data exploration. This book examines Power BI’s data analysis features and shows you, through real-world examples, how Power BI can be a go-to analysis tool for business users in all domains.You will discover that Microsoft’s Power BI offers all the number-crunching power of Excel plus versatile and impactful visualization tools that will greatly enhance your discovery process and make it easier to communicate results. You will see that its data analysis expression (DAX) language is far richer and more powerful than Excel’s limited (and outdated) MDX; and its data ingestion utility is vastly superior. You will learn how to unearth unexpected trends and hidden correlations that might be elusive in the numbers but will emerge in high relief using visualization, speeding up analysis and making your data analysis far more complete. You will build analysis pages which, after you have completed a particular analysis, can be preserved along with your datasets for later use, and even passed along to others in an organization as “what-if” tools.Hands-on exercises are provided that use downloadable data sources and “starter” configurations of Power BI files for building sample analyses. Downloadable Excel samples of those same exercises are provided for easy comparison.What You Will LearnUnderstand the exploratory methodologyBuild data sets and take a dive into DAXAdd visualization to your analysis processIncorporate R and PythonUse Power BI to extend your workWho ThisBook Is ForAny business user who currently performs exploratory data analysis using tools other than Power BI, users who are not currently doing exploratory analysis but understand their data and how it is used and wish to begin studying it, managers and executives who wish to expand their organization’s use of analytics and encourage new skills in their business workforce. Experience with Microsoft Excel is helpful but not essential.

In the beginning, there was Led Zeppelin – and Black Sabbath, and Deep Purple, the progenitors of British heavy metal, a musical form that wildly expanded the terrain of rock in the early Seventies. And as that decade progressed, it began to mutate, as Judas Priest fused heavy metal’s intensity and dark emotion with unbridled theatricality and the power of twin guitars. The New Wave of British Heavy Metal was underway. Five young men from Sheffield – some of them still in school – took that new sound and infused it with large doses of the glam they’d grown up on – T. Rex, Queen, Davie Bowie – and blazed a trail into the Eighties, leading NWOBHM into the new era of MTV. Taking the name Def Leppard, they brought unprecedented energy and innovation to every song, to every show, then partnering with legendary producer Mutt Lange to become heavy metal’s apostles to top 40 radio – delivering an astonishing string of hit singles and multi-platinum albums while setting new standards for arena rock. They’re still rocking the world today, a dozen albums in, touring the world and never resting on their laurels. Heavy metal, NWOBHM, hair metal have all come and gone – but Def Leppard remain