My Favourite Power BI related Books in 2022

List not in ranking order, 

If you are the registered member of NLB (National Library Board Singapore), you are eligible to borrow these E-book freely via NLB Mobile App.   


1). Microsoft Power BI Data Analyst Certification Guide: A comprehensive guide to becoming a confident and certified Power BI professional

- Publication date: 24 Jun 2022

- Author: Orrin Edenfield, Edward Corcoran

- Contents:

  1. Overview of Power BI and the PL-300 Exam
  2. Connecting to Data Sources
  3. Profiling the Data
  4. Cleansing, Transforming, and Shaping Data
  5. Designing a Data Model
  6. Using Data Model Advanced Features
  7. Creating Measures Using DAX
  8. Optimizing Model Performance
  9. Creating Reports
  10. Creating Dashboards
  11. Enhancing Reports
  12. Exposing Insights from Data
  13. Performing Advanced Analytics
  14. Managing Workspaces
  15. Managing Datasets
  16. Practice Exams

2). DAX Cookbook: Over 120 recipes to enhance your business with analytics, reporting, and business intelligence

  • Publication date: Mar 2020
- Author: Greg Deckler

- Contents:

  1. Using DAX in Excel, Power BI, and SQL
  2. Writing good DAX
  3. Using variables
  4. Confronting context
  5. Grouping and summarizing
  6. Filtering and unfiltering
  7. Exploiting relationships
  8. Implementing iterators
  9. Using conditional logic

3). Power Query Cookbook: Use effective and powerful queries in Power BI Desktop and Dataflows to prepare and transform your data

- Publication date: 15 Oct 2021

- Author: Andrea Janicijevic

- Contents:
  1. Getting Started with Power Query
  2. Connecting to Fetch Data
  3. Data Exploration in Power Query
  4. Reshaping Your Data
  5. Combining Queries for Efficiency
  6. Optimizing Power Query Performance
  7. Leveraging the M Language
  8. Adding Value to Your Data
  9. Performance Tuning with Power BI Dataflows
  10. Implementing Query Diagnostics

- Author: Greg Deckler , Brett Powell

- Contents:

  1. Configuring Power BI Tools
  2. Accessing and Retrieving Data
  3. Building a Power BI Data Model
  4. Authoring Power BI Reports
  5. Working in the Service
  6. Getting Serious with Date Intelligence
  7. Parameterizing Power BI Solutions
  8. Implementing Dynamic User-Based Visibility in Power BI
  9. Applying Advanced Analytics and Custom Visuals
  10. Administering and Monitoring Power BI
  11. Enhancing and Optimizing Existing Power BI Solutions
  12. Deploying and Distributing Power BI Content
  13. Integrating Power BI with Other Applications

5). Mastering Microsoft Power BI : Expert techniques for effective data analytics and business intelligence


- Publication date: 30 Mar 2018

- Author: Brett Powell

- Contents:
  1. Planning Power BI Projects
  2. Connecting to Sources and Transforming Data with M
  3. Designing Import and DirectQuery Data Models
  4. Developing DAX Measures and Security Roles
  5. Creating and Formatting Power BI Reports
  6. Integrating Custom Visuals, Animation and Analytics into Power BI Reports
  7. Designing Power BI Dashboards and Multi-Dashboard Architectures
  8. Managing Application Workspaces and Power BI Content
  9. Managing the On-Premises Data Gateway and Data Refresh Configurations
  10. Deploying Power BI On-Premises with the Power BI Report Server
  11. Creating Power BI Apps and Content Distribution
  12. Administering Power BI for an Organization
  13. Scaling Up with Power BI Premium and SQL Server Analysis Services

6). Artificial Intelligence with Power BI

  •  April 2022
- Author: Mary-Jo Diepeveen

  1. Part 1: AI Fundamentals
  2. Free Chapter
  3. Chapter 1: Introducing AI in Power BI
  4. Chapter 2: Exploring Data in Power BI
  5. Chapter 3: Data Preparation
  6. Part 2: Out-of-the-Box AI Features
  7. Chapter 4: Forecasting Time-Series Data
  8. Chapter 5: Detecting Anomalies in Your Data Using Power BI
  9. Chapter 6: Using Natural Language to Explore Data with the Q&A Visual
  10. Chapter 7: Using Cognitive Services
  11. Chapter 8: Integrating Natural Language Understanding with Power BI
  12. Chapter 9: Integrating an Interactive Question and Answering App into Power BI
  13. Chapter 10: Getting Insights from Images with Computer Vision
  14. Part 3: Create Your Own Models
  15. Chapter 11: Using Automated Machine Learning with Azure and Power BI
  16. Chapter 12: Training a Model with Azure Machine Learning
  17. Chapter 13: Responsible AI


7). Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level


- Publication date: 20 Jan 2022

- Author: Michiel Rozema, Henk Vlootman

- Contents:

  1. DAX in Business Intelligence
  2. Model Design
  3. Using DAX
  4. Context and Filtering
  5. Security with DAX
  6. Dynamically Changing Visualizations
  7. Alternative Calendars
  8. Working with AutoExist
  9. Intercompany Business
  10. Exploring the Future: Forecasting and Future Values
  11. Inventory Analysis
  12. Personnel Planning

8). Extending Power BI with Python and R: Ingest, transform, enrich, and visualize data using the power of analytical languages


- Publication date: 26 Nov 2021

- Author: Luca Zavarella

- Contents:

  1. Where and How to Use R and Python Scripts in Power BI
  2. Configuring R with Power BI
  3. Configuring Python with Power BI
  4. Importing Unhandled Data Objects
  5. Using Regular Expressions in Power BI
  6. Anonymizing and Pseudonymizing Your Data in Power BI
  7. Logging Data From Power BI To External Sources
  8. Loading Large Datasets Beyond the Available RAM in Power BI
  9. Calling External APIs to Enrich Your Data
  10. Calculating Columns Using Complex Algorithms
  11. Adding Statistics Insights: Associations
  12. Adding Statistics Insights: Outliers and Missing Values
  13. Using Machine Learning Without Premium or Embedded Capacity
  14. Exploratory Data Analysis
  15. Advanced Visualizations
  16. Interactive R Custom Visuals


9). Expert Data Modeling with Power BI: Get the best out of Power BI by building optimized data models for reporting and business needs

- Publication date: 11 Jun 2021

- Author: Soheil Bakhshi

- Contents:

  1. Introduction to data modelling in Power BI
  2. Data Analysis eXpressions and Data Modeling
  3. Data Preparation in Power Query Editor
  4. Getting data from various sources
  5. Common data preparation steps
  6. Star Schema preparation in Power Query Editor
  7. Data preparation common best practices
  8. Data Modeling Components
  9. Star Shema and Data Modeling Common Best Practices
  10. Advanced Data Modeling Techniques
  11. Row Level Security
  12. Extra Options and Features Available for Data Modeling



- Publication date: 26 Aug 2022

- Author: Adam Aspin

- Covered Contents:

  1. Connect Power BI to a range of external data sources
  2. Prepare data from external sources for easy analysis in Power BI
  3. Cleanse data from duplicates, outliers, and other bad values
  4. Make live connections from which to refresh data quickly and easily
  5. Apply advanced techniques to interpolate missing data

Comments

Post a Comment

Popular posts from this blog

Power BI DAX Formula for Dynamic Ranking Calculations Based on User Selections and Filters

Image
  The Youtube Vidoe:  Power BI DAX: Dynamic Ranking Calculations Based on User Selections and Filters         DAX formulas from the Video: Total Opp count = DISTINCTCOUNTNOBLANK('Fact'[Opportunity ID]) Total P_Revenue = SUM('Fact'[ProductRevenue]) Total F_P_Revenue = SUM('Fact'[FactoredProductRevenue]) Selected KPIs = SELECTEDVALUE('Table_KPIs'[KPI Name]) Account value rank index =      SWITCH(         TRUE(),         [Selected KPIs]="Opportunity Numbers",RANKX(ALL('Account'[Account]),[Total Opp count],,,Dense),         [Selected KPIs]="Product Revenues",RANKX(ALL('Account'[Account]),[Total P_Revenue],,,Dense),         [Selected KPIs]="Factored Product Revenues",RANKX(ALL('Account'[Account]),[Total F_P_Revenue],,,Dense)     ) Account KPI values for sorting =      SWITCH(         TRUE(),         ...
Read more

Power BI DAX and Visualizations: Active employees across time (as x-axis) by Tenure group or age group

Image
Business Case raised by my youtube channel viewer on the 21st July 2023. In my employee tenure data, it has employee birthday, hire date and leaving date, and race, gender, etc. Do you have any idea how to create a dynamic measure of tenure and/or age, as well as a "tenure group" and "age group" that can change with the calendar date? I would like to show in a line chart the changing number of active employees across time (as x-axis). Furthermore, I would like to breakdown the number of employees by their age group or tenure group (using age group as a legend). The age or tenure group will be dynamically change according to the dates in the X-axis. Any suggestions are appreciated. My suggestions: Assumptions on what we have for the case:                         - an employee table with coloumns: table update(or registered) date,              ...
Read more

Excel VBA Tips: A Macro to Generate Line Chart Dynamically for Loan Schedule Trend Report

Image
The entire code shared in this video is designed to automate the process of creating a dynamic line chart based on loan data in the "Loan Report" sheet and display the chart on the "Charts" sheet. The chart shows trends in accumulated principal, accumulated interest, and loan remaining balance over time. The code is also flexible enough to handle both yearly and monthly loan schedule reports. The VBA codes as: Sub CreateLineChart()       '1. Variable Declarations     Dim srcSheet As Worksheet     Dim chtSheet As Worksheet     Dim lastRow As Long     Dim chartObj As Shape     Dim chartDataRange As Range     Dim xAxisRange As Range     Dim yAxisRange As Range     Dim colPrincipal As Variant     Dim colInterest As Variant     Dim colRemainingBalance, ColMonth As Variant     '2. set source and chart sheets     Set srcSheet = ThisWorkbook.Worksheets("Loa...
Read more