Title Page Copyright and Credits Microsoft Power BI Quick Start Guide Packt Upsell Why subscribe? PacktPub.com Foreword Contributors About the authors About the reviewer Packt is searching for authors like you Preface Who this book is for What this book covers To get the most out of this book Download the example code files Download the color images Conventions used Get in touch Reviews Getting Started with Importing Data Options Getting started Importing data Excel as a source SQL Server as a source Web as a source DirectQuery Limitations Live Connection Limitations Which should I choose? Summary Data Transformation Strategies The Power Query Editor Transform basics Use First Row as Headers Remove Columns Change type Add Column From Examples Advanced data transformation options Conditional Columns Fill Down Unpivot Merging Queries Appending Queries Leveraging R Installation and configuration The R Script transform M formula language #shared Summary Building the Data Model Building relationships Editing relationships Creating a new relationship  Working with complex relationships Many-to-many relationships Cross-filtering direction Enabling filtering from the many side of a relationship Role-playing tables Importing the date table Usability enhancements Hiding tables and columns Renaming tables and columns Default summarization How to display one column but sort by another Data categorization Creating hierarchies Summary Leveraging DAX Building calculated columns String functions – Month, Year Format function – Month Year Age calculation SWITCH() – age breakdown Navigation functions – RELATED Calculated measures – the basics Calculated measure – basic aggregations Total Sales Total Cost Profit Profit Margin Optional parameters Filter context Calculate Percentage of total calculation Time intelligence Year to Date Sales YTD Sales (Fiscal Calendar) Prior Year Sales  Summary Visualizing Data Data visualization basics Visuals for filtering Interactive filtering The Slicer visual Visualizing tabular data The table visual The Matrix visual Visualizing categorical data Bar and Column charts Pie and Donut charts The Treemap visual The Scatter chart Visualizing trend data Line and Area charts Combo charts The Ribbon Chart The Waterfall Chart The Funnel Chart Visualizing KPI data The Gauge visual The KPI visual Visualizing geographical data The Map visual The Filled Map visual The Shape Map visual The ArcGIS Map visual Leveraging Power BI custom visuals Data visualization tips and tricks Edit interactions The Analytics pane The Top N filter Show value as Summary Digital Storytelling with Power BI Configuring drillthrough filters Storytelling with the Selection pane and bookmarks Bookmarks pane Selection pane Summary Using a Cloud Deployment with the Power BI Service Deploying to the Power BI service DATASETS WORKBOOKS Creating and interacting with dashboards Creating your first dashboard Asking your dashboard a question Subscribing to reports and dashboards Sharing your dashboards Workspaces Setting up row-level security Scheduling data refreshes Summary On-Premises Solutions with Power BI Report Server Deploying to Power BI Report Server Securing reports Scheduling data refreshes Summary Other Books You May Enjoy Leave a review - let other readers know what you think