Cargando…
Learn Power BI : a Beginner's Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI.
This book will help you bring business intelligence capabilities using Power BI in order to make smarter decisions. You will learn data modeling, visualizations, and analytical capabilities from scratch using hands-on examples. By the end of this book, you will learn the extensive features of Power...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing, Limited,
2019.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Title Page; Copyright and Credits; About Packt; Contributors; Table of Contents; Preface; Section 1: The Basics; Chapter 1: Introduction to Business Intelligence and Power BI; Key concepts of business intelligence; Domain; Data; Internal and external data; Structured, unstructured, and semi-structured data; Model; Organizing; Transforming and cleansing; Defining and categorizing; Analysis; Visualization; The Power BI ecosystem; Core, Power BI-specific; Core, non-Power BI-specific; Non-core, Power BI-specific; Natively integrated Microsoft technologies; The extended Power BI ecosystem
- Power BI licensingPower BI Free; Power BI Pro; Power BI Premium; Power BI Embedded; Power BI Report Server; Power BI Desktop and Service; Power BI Desktop; Getting data; Creating a data model; Analyzing data; Creating and publishing reports; Power BI Service; Viewing and editing reports; Creating dashboards; Sharing and collaborating with others; Accessing and creating apps; Refreshing data; Summary; Questions; Further reading; Section 2: The Desktop; Chapter 2: Up and Running with Power BI Desktop; Technical requirements; Downloading and installing Power BI Desktop
- Power BI Desktop (the trusted Microsoft Store app)Power BI Desktop (MSI); Power BI Desktop (Report Server edition); Running Power BI Desktop; Touring the Desktop; Title Bar and Quick Access Toolbar; The Ribbon; The Formula Bar; Understanding DAX; Views Bar; Panes; Canvas; Page tabs; Footer; Generating data; Creating a calculated table; Creating calculated columns; Formatting columns; Creating visualizations; Creating your first visualization; Formatting your visualization; Adding analytics to your visualization; Creating and using a slicer; Creating more visualizations
- Editing visual interactionsSummary; Questions; Further reading; Chapter 3: Connecting and Shaping Data; Technical requirements; Getting data; Creating your first query; Getting additional data; Transforming data; Touring the Power Query Editor; The Title Bar and Quick Access Toolbar; The Ribbon; Formula Bar; The Queries Pane; The Query Settings Pane; Data Canvas; Footer; Transforming budget and forecast data; Cleaning up extraneous bottom rows; Filtering rows; Unpivoting data; Using Fill; Changing data types; Transforming people, tasks, and January data; Transforming the People query
- Transforming the Tasks queryTransforming the January query; Merging, copying, and appending queries; Merging queries; Expanding tables; Disabling the loading of queries; Copying queries; Changing sources; Appending queries; Verifying and loading data; Organizing queries; Checking column quality, distribution, and profiles; Loading the data; Summary; Questions; Further reading; Chapter 4: Creating Data Models and Calculations; Technical requirements; Creating a data model; Touring the Model view; Title Bar and Quick Access Toolbar; Ribbon; Views Bar; Panes; Canvas; Layout Tabs; Footer