Microsoft Power BI Cookbook 1st Edition by Brett Powell – Ebook PDF Instant Download/Delivery: 1788293789, 9781788293785
Full dowload Microsoft Power BI Cookbook 1st Edition after payment
Product details:
ISBN 10: 1788293789
ISBN 13: 9781788293785
Author: Brett Powell
Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI’s functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.
Microsoft Power BI Cookbook 1st Table of contents:
Technical Requirements
Installing and Configuring Power BI Desktop
Creating an On-Premises Data Gateway
Installing Analyze in Excel from the Power BI Service
Installing and Configuring Additional Tools
Conclusion
Accessing and Retrieving Data
Technical Requirements
Viewing and Analyzing M Functions
Managing Queries and Data Sources
Using DirectQuery
Importing Data
Applying Multiple Filters
Selecting and Renaming Columns
Transforming and Cleansing Data
Creating Custom Columns
Combining and Merging Queries
Selecting Column Data Types
Visualizing the M library
Profiling Source Data
Diagnosing Queries
Conclusion
Building a Power BI Data Model
Technical Requirements
Designing a Data Model
Implementing a Data Model
Creating Relationships
Configuring Model Metadata
Hiding Columns and Tables
Enriching a Model with DAX
Supporting Virtual Table Relationships
Creating Hierarchies and Groups
Designing Column Level Security
Leveraging Aggregation Tables
Conclusion
Authoring Power BI Reports
Technical Requirements
Building Rich and Intuitive Reports
Filtering at Different Scopes
Integrating Card visualizations
Using Slicers
Controlling Visual Interactions
Utilizing Graphical Visualizations
Creating Table and Matrix visuals
Enhancing Reports
Formatting Reports for Publication
Designing Mobile Layouts
Creating Paginated Reports
Conclusion
Working in the Service
Technical Requirements
Building a Dashboard
Preparing for Q&A
Adding Alerts and Subscriptions
Deploying Content from Excel and SSRS
Streaming Datasets
Authoring Dataflows
Conclusion
Getting Serious with Date Intelligence
Technical Requirements
Building a Date Dimension Table
Preparing the Date Dimension via the Query Editor
Authoring Date Intelligence Measures
Developing Advanced Date Intelligence Measures
Simplifying Date Intelligence with DAX and Calculated Tables
Leveraging Calculation Groups
Conclusion
Parameterizing Power BI Solutions
Technical requirements
Filtering reports dynamically
Leveraging query parameters
Working with templates
Converting static queries to dynamic functions
Capturing user selections with parameter tables
Forecasting with what-if analysis
Conclusion
Implementing Dynamic User-Based Visibility in Power BI
Technical Requirements
Capturing Current User Context
Defining RLS Roles and Filter Expressions
Designing Dynamic Security Models
Building Dynamic Security for DirectQuery
Displaying the Current Filter Context
Avoiding Manual User Clicks
Conclusion
Applying Advanced Analytics and Custom Visuals
Technical Requirements
Incorporating Advanced Analytics
Enriching Content with Custom Visuals and Quick Insights
Creating Geospatial Mapping with ArcGIS Maps
Democratizing Artificial Intelligence
Building Animation and Storytelling
Embedding Statistical Analyses
Grouping and Binning
Detecting and Analyzing Clusters
Forecasting and Anomaly Detection
Using R and Python Visuals
Conclusion
Administering and Monitoring Power BI
Technical requirements
Creating a centralized IT monitoring solution with Power BI
Constructing a monitoring, visualization, and analysis layer
Importing and visualizing dynamic management view (DMV) data
Increasing DBA productivity
Providing documentation
Analyzing SSAS tabular databases and gateways
Analyzing Extended Events
Visualizing log file data
Leveraging the Power BI PowerShell Module
Conclusion
Enhancing and Optimizing Existing Power BI Solutions
Technical Requirements
Enhancing Data Model Scalability and Usability
Improving DAX Measure Performance
Pushing Query Processing Back to Source Systems
Strengthening Data Import and Integration Processes
Isolating and Documenting DAX Expressions
Improving Data Load Speeds with Incremental Refresh
Conclusion
Deploying and Distributing Power BI Content
Technical Requirements
Preparing for Content Creation and Collaboration
Managing Content between Environments
Sharing Content with Colleagues
Configuring Workspaces
Configuring On-Premises Gateway Data Connections
Publishing Apps
Publishing Reports to the Public Internet
Enabling the Mobile Experience
Distributing Content with Teams
Conclusion
Integrating Power BI with Other Applications
Technical Requirements
Integrating SSRS and Excel
Migrating from Power Pivot for Excel Data to Power BI
Accessing and Analyzing Power BI Datasets in Excel
Building Power BI Reports into PowerPoint Presentations
Connecting to Azure Analysis Services
Integrating with Power Automate and Power Apps
Leveraging Dataverse and Dynamics 365
Connecting Dynamics 365 Finance and Operations and the Power Platform
People also search for Microsoft Power BI Cookbook 1st:
microsoft power bi books
microsoft power bi bookmarks
microsoft power apps cookbook
power bi microsoft list
microsoft power bi embedded
Reviews
There are no reviews yet.