book

Data Analysis with Microsoft Power BI

by Brian Larson

January 2020

Beginner to intermediate

544 pages

11h 42m

English

McGraw-Hill

Read now

Unlock full access

The Tool Chest Called Power BIThe BI ProcessPower BI Parts and PiecesThe Right Tool(s) for the JobConsuming Power BI ReportsPower BI as a Data Visualization ToolPower BI as a Modeling ToolPower BI as a Data Warehouse/Data MartWhere to Find What You NeedObtaining Power BI Desktop SoftwareSample Code and Supporting MaterialsInformation on Power BI New Features and EnhancementsHow to Succeed at Self-Service Analytics
What Is Business Intelligence?Defining KPIsIs Your Organization Ready for BI?DesireRealistic ExpectationsOngoing Care and FeedingWell-Defined KPIsActionable KPIsReliable Sources of DataImplementation: Best PracticesTake an Iterative Implementation ApproachUtilize a Data Warehouse/Data MartCleanse and Validate During Data GatheringCreate User-Friendly Data ModelsPublish LatencyProvide Training and SupportUse the Right Tool for the JobEstablish Standards and LimitsSuccessfully Using Power BI

The Power BI ArchitecturePower BI DesktopThe Power BI ServiceThe Power BI Report ServerThe Power BI Mobile AppPower BI Desktop OptimizationsPower BI UpdatesMicrosoft On-premises Data GatewayWhat Does the Data Have to Say?
Power BI DesktopObtaining What You NeedOpening the Report/Preparing the EnvironmentInteracting with a Power BI ReportWorking with a Single Report ItemInteracting with Multiple Report ItemsChanging the Data with Slicers and FiltersSlicersFiltersNavigating Power BI ReportsDrill Down and DrillthroughButtonsBookmarksAdditional Data InteractionsA Cloudy Forecast
PowerBI.comThe Organization of PowerBI.comConnecting to PowerBI.comThe Navigation PaneWorkspacesReportsDashboardsWorkbooksDatasetsDataflowsAdditional Areas and Items Within PowerBI.comAdditional Navigation Pane ItemsAdditional ButtonsHow It All Gets Made
Learn By DoingStarting PointBasic VisualizationsMaximum Miniatures ManufacturingOur First Report PageText-based VisualizationsGraphical VisualizationsInteractivitySlicersFiltersDrillthroughGeographic VisualizationsBing Map VisualizationsShape Map VisualizationsGIS Map VisualizationsOther Visual ElementsText Boxes, Images, and ShapesFancy Formatting
The Visualization Format TabReport PageAll ItemsChartsAdditional Chart Functional GroupsTable and MatrixCard and Multi-row CardPie Chart, Donut Chart, Treemap, and MapsFunnelGaugeKPISlicerButton, Shape, and ImageAdvanced Formatting Dialog BoxesConditional Formatting Advanced Controls Dialog BoxData Bars Advanced Controls Dialog BoxThe Visualization Analytics TabTypes of Analytics LinesControls for Editing Analytics LinesThemesNew Ways to Interact and Visualize
Controlling InteractivityControlling InteractionsSynchronizing SlicersCreating InteractivityCustom TooltipsBookmarksSelection PaneButtonsCustomizing VisualizationsCustom Visualizations from the MarketplaceCustom Visualizations from R and PythonCreating a Custom Shape MapMoving on to Modeling
Gathering DataGet DataPower BI Connection TypesTransforming Data During the Data ImportThe Power BI Query EditorA New Sample: World PopulationRepeating and Changing the Data ImportRefreshing Data in Power BI DesktopModifying QueriesThe Advanced Editor and the Power Query Formula LanguageData Source PermissionsRelationships and Intermediate TablesCreating an Intermediate Table from a Data SourceManually Creating Intermediate TablesParametersPutting Parameters to UseTransformers
Transformation ReferenceInformational-Only TransformationsTransformations on the Query Editor Home TabTransformations on the Query Editor Transform TabTransformations on the Query Editor Add Column TabModel Building
RelationshipsCreating RelationshipsUser-Friendly ModelsHiding Columns from the End UserColumn Names and DescriptionsFormatting and CategoriesOne Final RelationshipData CategoriesHierarchies, Groups, and BinsMeasuring Up
Calculated ColumnsCreating a Calculated ColumnThe Context for Calculated ColumnsMeasuresDefault SummarizationExplicit MeasuresMeasures and ContextDefining Context Within a MeasureTime AnalyticsRow-by-Row CalculationsThe FILTER() FunctionDAX VariablesDeclaring DAX Variables and Assigning a ValueUsing a DAX VariableUsing Return in a MeasureEverything DAX
DAX OperatorsComparison OperatorsArithmetic OperatorsText OperatorLogical OperatorsDAX FunctionsModifying ContextTable-Valued FunctionsAggregate FunctionsDAX Functions for Time AnalyticsParent/Child RelationshipsAdditional DAX FunctionsAdditional Modeling
Additional Power BI Data Model FeaturesSynonymsLinguistic SchemasDisplay FolderWhat-If ParametersRolesPerformance AnalyzerCapturing Performance InformationViewing the DAX QueryImport and ExportExcel Workbook ContentPower BI TemplatesSpreading the Word
The Power BI Service and Data RefreshThe On-premises Data GatewayThe On-premises Data Gateway ArchitectureInstalling the On-premises Data GatewayManaging the On-premises Data GatewayManaging the On-premises Data Gateway (personal mode)Setting a Dataset for Scheduled RefreshThe Power BI Service and SharingUsing ShareUsing Content PacksUsing AppsThe Power BI Service and Row-Level SecurityAssigning Users to a Custom Security RoleAnother Way to Share
Power BI Service and Power BI Report Server ComparisonVersionsPower BI Desktop OptimizationsInstalling Power BI Report ServerThe Power BI Report Server Installation ExecutableThe Report Server Configuration ManagerThe Report CatalogFoldersThe Web PortalSaving a Report to the Power BI Report ServerSecurityFolder and Report SecurityRow-Level SecurityBranding the Power BI Report ServerModifying the Site NameCreating a Brand PackagePowered Up and Ready to Go

Content preview from Data Analysis with Microsoft Power BI

This book is dedicated to my father-in-law, Len Martin. I had the great fortune to have in-laws who were also good friends. Len taught me many lessons on home improvement and was always ready to share his experience running a small business. A combat pilot in WWII, Air Force Reservist, and recreational pilot, he “slipped the surly bonds of earth” one last time on July 9, 2019.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Data Visualization with Microsoft Power BI

Alex Kolokolov, Maxim Zelensky

Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics

Dan Clark

Data Modeling with Microsoft Power BI

Markus Ehrenmueller-Jensen

Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition

Dan Clark

Publisher Resources

ISBN: 9781260458626