Business Intelligence with SQL Server Reporting Services [[electronic resource] /] / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [1st ed. 2015.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
Descrizione fisica | 1 online resource (413 p.) |
Disciplina |
005.75
005.75/85 |
Collana | The expert's voice in SQL server |
Soggetto topico |
Database management
Data structures (Computer science) Data mining Database Management Data Structures and Information Theory Data Mining and Knowledge Discovery |
ISBN | 1-4842-0532-4 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: SQL Server Reporting Services as a Business Intelligence Platform""; ""Business Intelligence Concepts""; ""Key Performance Indicators""; ""Scorecards""; ""Dashboards""; ""SSRS for Business Intelligence, Practically""; ""Getting the Data Right""; ""Prepare the Data""; ""Use Views and Stored Procedures""; ""Views""; ""Stored Procedures""; ""Some Ideas on Source Data Definition""; ""Real-World Data""
""Designing SQL Server Reports for Business Intelligence""""Presentation""; ""Design""; ""Layout""; ""Interface and Interactivity""; ""Multi-Purposing""; ""The Sample Database""; ""Preparing Your Environment""; ""Creating an SSDT Project""; ""Adding a Shared Datasource""; ""Add Shared Datasets""; ""Configuring Parameters""; ""Code and Stored Procedures""; ""Reusability""; ""The CarSales_Reports Database""; ""Book Audience""; ""How Best to Use This Book""; ""Conclusion""; ""Chapter 2: KPIs and Scorecards""; ""What Are Key Performance Indicators?""; ""KPI Value""; ""KPI Goal""; ""KPI Status"" ""KPI Status Thresholds""""Threshold Flags""; ""KPI Trends""; ""KPI Trend Thresholds and Flags""; ""A Simple KPI""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""A More Complex KPI Using Sparklines""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""Gauge-Based KPIs""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge-Based KPI""; ""How It Works""; ""Hints and Tips""; ""Text-Based KPIs""; ""A Simple Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Text-Based KPI"" ""How It Works""""A Complex Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Complex Text-Based KPI""; ""How It Works""; ""Conclusion""; ""Chapter 3: Gauges for Business Intelligence""; ""Gauge Elements""; ""Data for Gauges""; ""Gauge Development""; ""Classic Gauges""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Using Multiple Pointers in Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating the Gauge""; ""How It Works""; ""Varying the Pointer Types and Assembling Gauges"" ""The Source Data""""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Gauges with Multiple Elements""; ""The Source Data""; ""Creating the Gauge""; ""How It Works""; ""Hints and Tips""; ""Less Traditional Gauges""; ""Thermometers""; ""The Source Data""; ""How the Code Works""; ""Building the Thermometer""; ""How It Works""; ""Hints and Tips""; ""Sub-Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating Gauges with Sub-Gauges""; ""How It Works""; ""Hints and Tips""; ""Interesting Tricks with Gauges""; ""The Source Data""; ""How the Code Works"" ""Creating and Assembling the Gauges"" |
Record Nr. | UNINA-9910300638303321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data from External Sources / / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [1st ed. 2020.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 |
Descrizione fisica | 1 online resource (XXIV, 388 p. 237 illus.) |
Disciplina | 005.369 |
Soggetto topico |
Microsoft software
Microsoft .NET Framework Microsoft and .NET |
ISBN |
1-5231-5061-0
1-4842-6018-X |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. Using Power Query to Discover and Load Data into Excel -- 2. Discovering and Loading File-Based Data with Power Query -- 3. Loading Data from Databases and Data Warehouses -- 4. Loading Data from the Web and the Cloud -- 5. Generic Data Sources -- 6. Structuring Imported Data -- 7. Data Transformation -- 8. Restructuring Data -- 9. Complex Data Loads -- 10. Organizing and Managing Queries -- 11. Parameterizing Queries -- 12. The M Language -- 13. Appendix A: Sample Data. |
Record Nr. | UNINA-9910411929803321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI [[electronic resource] /] / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [2nd ed. 2016.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 |
Descrizione fisica | 1 online resource (XXXII, 599 p. 413 illus. in color.) |
Disciplina | 004 |
Soggetto topico |
Application software
Computer Applications |
ISBN | 1-4842-2400-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910151576103321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
High Impact Data Visualization with Power View, Power Map, and Power BI / / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [1st ed. 2014.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
Descrizione fisica | 1 online resource (536 p.) |
Disciplina | 005.3 |
Collana | Expert's Voice in Business Intelligence |
Soggetto topico |
Microsoft software
Microsoft .NET Framework Application software Microsoft and .NET Computer Applications |
ISBN | 1-4302-6617-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Contents at a Glance; Introduction; Chapter 1: Self-Service Business Intelligence; The Microsoft Self-Service Business Intelligence Solution; The Excel BI Toolkit; Power BI; The Excel BI Toolkit and Power BI; Power Query; PowerPivot; Power View; Power Map; Power BI; Preparing the Self-Service BI Environment; PowerPivot; Power View; Power Query; Power Map; Power BI; Adding a Power BI Site; The Windows Power BI App; Corporate BI or Self-Service BI ?; The Excel Data Model; How This Book Is Designed to Be Read; Discovering Data; Creating a Data Model; Taking Data and Preparing It for Output
Taking Existing Excel BI and Sharing ItDelivering Geodata; Delivering Excel BI to Mobile Devices; To Learn the Product Suite Following a Real-World Path; The Self-Service Business Intelligence Universe; Conclusion; Chapter 2: Power View and Tables; The Power View Experience; Adding a Power View Sheet to an Excel Workbook; The Power View Interface; The Power View Ribbon; The Field List; Using the Field List; Renaming or Deleting a Power View Report; Tables in Power View; Adding a Table; Deleting a Table; Changing the Table Size and Position; Changing Column Order; Removing Columns from a Table Types of DataData and Aggregations; Enhancing Tables; The Design Ribbon; Row Totals; Formatting Columns of Numbers; Default Formatting; Changing Column Widths; Font Sizes in Tables; Copying a Table; Sorting by Column; Table Granularity; Matrix Tables; Row Matrix; Column Matrix; Sorting Data in Matrix Tables; Drilling Through with Matrix Tables; Drilling Down; Drilling Up; Reapplying Matrix Visualization; Drilling Through with Column Hierarchies; Card Visualizations; Card Visualization Styles; Sorting Data in Card-View Tables; Switching Between Table Types; Key Performance Indicators (KPIs) ConclusionChapter 3: Filtering Data in Power View; Filters; Hiding and Displaying the Filters Area; View Filters; Adding Filters; The (All) Filter; Clearing Filters; Deleting Filters; Expanding and Collapsing Filters; Subsetting Large Filter Lists; Searching for Specific Elements in a Filter; Clearing a Filter Subset; Filtering with Wildcards; Clearing a Filter Element Search; Filtering Different Data Types; Numeric Data; Range Filter Mode; List Filter Mode; Quickly Excluding Outliers; Date and Time Data; Other Data Types; Multiple Filters; Advanced Filters; Applying an Advanced Filter Clearing an Advanced FilterAdvanced Wildcard Filters; Numeric Filters; Date and Time Filters; Complex Filters; Advanced Text Filter Options; Advanced Numeric Filter Options; Advanced Date Filter Options; Visualization-Level Filters; Filter Hierarchy; Filtering Tips; Don't Filter Too Soon; Drill-Down and Filters; Annotate, Annotate, Annotate; Conclusion; Chapter 4: Charts in Power View; A First Chart; Creating a First Chart; Deleting a Chart; Basic Chart Modification; Basic Chart Types; Column Charts; Line Charts; Pie Charts; Essential Chart Adjustments; Resizing Charts; Repositioning Charts Sorting Chart Elements |
Record Nr. | UNINA-9910300470803321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro data mashup for Power BI : powering up with power query and the m language to find, load, and transform data / / Adam Aspin |
Autore | Aspin Adam |
Pubbl/distr/stampa | [Place of publication not identified] : , : Apress, , [2022] |
Descrizione fisica | 1 online resource (497 pages) |
Disciplina | 658.501 |
Soggetto topico | Management information systems |
ISBN | 1-4842-8578-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. Discovering and Loading Data with Power BI Desktop 2. Discovering and Loading File-Based Data with Power BI Desktop 3. Loading Data From Databases and Data Warehouses 4. DirectQuery and Live Connect 5. Loading Data from the Web and Cloud 6. Loading Data from Other Data Sources 7. Power Query 8. Structuring Data 9. Shaping Data 10. Data Cleansing 11. Data Transformation 12. Complex Data Structures 13. Organizing, Managing, and Parameterizing Queries 14. The M Language 15. Appendix A: Sample Data. |
Record Nr. | UNINA-9910590069703321 |
Aspin Adam
![]() |
||
[Place of publication not identified] : , : Apress, , [2022] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro DAX and Data Modeling in Power BI : Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics / / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [1st ed. 2023.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2023 |
Descrizione fisica | 1 online resource (475 pages) |
Disciplina | 791.436553 |
Soggetto topico |
Dashboards (Management information systems)
Business intelligence - Computer programs Information visualization - Computer programs Visual analytics |
ISBN | 1-4842-8995-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. Using Power BI Desktop to Create a Data Model -- 2. Extending The Data Model -- 3. The Semantic Layer -- 4. Calculated Columns -- 5. Calculating Across Tables -- 6. DAX Logical Functions -- 7. Date and Time Calculations in Columns -- 8. Introduction to Measures -- 9. Filtering Measures -- 10. CALCULATE() Modifiers -- 11. The Filter() Function -- 12. Iterators -- 13. Creating and Applying a Date Dimension -- 14. Time Intelligence -- 15. DAX Variables -- 16. Table Functions -- 17. Extending the Data Model -- 18. Evaluation Context -- Appendix A: Sample Data. |
Record Nr. | UNINA-9910632473603321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2023 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro Power BI Dashboard Creation : Building Elegant and Interactive Dashboards with Visually Arresting Analytics / / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [1st ed. 2022.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2022 |
Descrizione fisica | 1 online resource (526 pages) |
Disciplina | 658.472 |
Soggetto topico |
Dashboards (Management information systems)
Business intelligence - Computer programs Information visualization - Computer programs Visual analytics |
ISBN | 1-4842-8227-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Chapter 1: Dashboard Basics -- Chapter 2. Table Visuals -- Chapter 3. Advanced Table Visual Techniques -- Chapter 4. Matrix Visuals -- Chapter 5. Card Visual Types -- Chapter 6. Charts in Power BI Desktop. Chapter 7: Advanced Chart Types. Chapter 8: Formatting Charts -- Chapter 9: Other Types of Visuals. - Chapter 10: Drilldown and Drillup. - Chapter 11: Third Party Visuals. - Chapter 12: Maps in Power BI Desktop -- Chapter 13: Filtering Data -- Chapter 14: Slicers and Cross-Filtering -- Chapter 15: Enhancing Dashboards -- Chapter 16: Multi-Page Dashboards -- Chapter 17: Bookmarks and Buttons. |
Record Nr. | UNINA-9910584484203321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2022 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro Power BI Desktop : Self-Service Analytics and Data Visualization for the Power User / / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [3rd ed. 2020.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 |
Descrizione fisica | 1 online resource (xxxiv, 898 pages) : illustrations |
Disciplina | 005.369 |
Soggetto topico |
Microsoft software
Microsoft .NET Framework Database management Microsoft and .NET Database Management |
ISBN | 1-4842-5763-4 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. Discovering and Loading Data with Power BI Desktop -- 2. Discovering and Loading File-Based Data with Power BI Desktop -- 3. Loading Data from Databases and Data Warehouses -- 4. DirectQuery and Connect Live -- 5. Loading Data from the Web and the Cloud -- 6. Loading Data from Other Data Sources -- 7. Structuring Imported Data -- 8. Data Transformation and Cleansing -- 9. Restructuring Data -- 10. Complex Data Loads -- 11. Organizing, Managing, and Parameterizing Queries -- 12. The M Language -- 13. Creating a Data Model -- 14. Table Visuals -- 15. Matrix and Card Visuals -- 16. Charts in Power BI Desktop -- 17. Formatting Charts in Power BI Desktop -- 18. Other Types of Visuals -- 19. Third-Party Visuals -- 20. Maps in Power BI Desktop -- 21. Filtering Data -- 22. Using Slicers -- 23. Enhancing Dashboards -- 24. Advanced Dashboarding Techniques -- 25. Appendix A: Sample Data. |
Altri titoli varianti | Pro Power business intelligence desktop |
Record Nr. | UNINA-9910409988203321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro Power BI Desktop / / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [2nd ed. 2018.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2018 |
Descrizione fisica | 1 online resource (XXXVI, 761 p. 647 illus., 563 illus. in color.) |
Disciplina | 005.74 |
Soggetto topico |
Database management
Database Management |
ISBN | 1-4842-3210-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. Introduction to Power BI Desktop -- 2. Discovering and Loading File-Based Data with Power BI Desktop -- 3. Loading Data from Databases and Data Warehouses -- 4. Direct Query and Connect Live -- 5. Loading Data from the Web and the Cloud -- 6. Dealing with Datasets -- 7. Data Transformation -- 8. Data Mashup -- 9. Structuring, Managing and Parameterizing Queries -- 10. Creating a Data Model -- 11. Extending the Data Model with Calculated Columns -- 12. Adding Measures to the Data Model -- 13. Analyzing Data over Time -- 14. Table Visuals -- 15. Matrix and Card Visuals -- 16. Charts in Power BI Desktop -- 17. Formatting Charts in Power BI Desktop -- 18. Other Types of Visuals -- 19. Maps in Power BI Desktop -- 20. Filtering Data -- 21. Using Slicers -- 22. Enhancing Dashboards -- 23. PowerBI.com -- 24. Appendix A: Sample Data. |
Altri titoli varianti | Pro Power business intelligence desktop |
Record Nr. | UNINA-9910300756703321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2018 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro Power BI Desktop [[electronic resource] /] / by Adam Aspin |
Autore | Aspin Adam |
Edizione | [1st ed. 2016.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 |
Descrizione fisica | 1 online resource (533 p.) |
Disciplina | 004 |
Collana | The expert's voice in business intelligence |
Soggetto topico |
Microsoft software
Microsoft .NET Framework Data mining Database management Microsoft and .NET Data Mining and Knowledge Discovery Database Management |
ISBN | 1-4842-1805-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Introduction -- 1. Introduction to Power BI Desktop -- 2. Discovering and Loading Data with Power BI Desktop -- 3. Transforming Datasets -- 4. Data Cleansing -- 5. Data Mashup -- 6. Creating a Data Model -- 7. Extending the Data Model with Calculated Columns -- 8. Adding Measures to the Data Model -- 9. Analyzing Data Over Time -- 10. Text-Based Visualizations -- 11. Charts in Power BI Desktop -- 12. Other Types of Visuals -- 13. Filtering Data -- 14. Using Slicers -- 15. Enhancing Dashboards -- 16. PowerBi.com. |
Record Nr. | UNINA-9910254750203321 |
Aspin Adam
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|