Advanced Analytics in Power BI with R and Python : Ingesting, Transforming, Visualizing / / by Ryan Wade
| Advanced Analytics in Power BI with R and Python : Ingesting, Transforming, Visualizing / / by Ryan Wade |
| Autore | Wade Ryan |
| Edizione | [1st ed. 2020.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 |
| Descrizione fisica | 1 online resource (XLVI, 391 p. 84 illus.) |
| Disciplina | 001.4226028566 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Quantitative research Big data Microsoft Data Analysis and Big Data Big Data |
| ISBN | 1-4842-5829-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Part I. Creating Custom Data Visualizations using R -- 1. The Grammar of Graphics -- 2. Creating R custom visuals in Power BI using ggplot2 -- Part II. Ingesting Data into the Power BI Data Model using R and Python -- 3. Reading CSV Files -- 4. Reading Excel Files -- 5. Reading SQL Server Data -- 6. Reading Data into the Power BI Data Model via an API -- Part III. Transforming Data using R and Python.-7. Advanced String Manipulation and Pattern Matching -- 8. Calculated Columns using R and Python -- Part IV. Machine Learning & AI in Power BI using R and Python -- 9. Applying Machine Learning and AI to your Power BI Data Models -- 10. Productionizing Data Science Models and Data Wrangling Scripts. . |
| Record Nr. | UNINA-9910427050203321 |
Wade Ryan
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced ASP.NET Core 3 Security : Understanding Hacks, Attacks, and Vulnerabilities to Secure Your Website / / by Scott Norberg
| Advanced ASP.NET Core 3 Security : Understanding Hacks, Attacks, and Vulnerabilities to Secure Your Website / / by Scott Norberg |
| Autore | Norberg Scott |
| Edizione | [1st ed. 2020.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 |
| Descrizione fisica | 1 online resource (XX, 405 p. 30 illus.) |
| Disciplina | 005.8 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Data protection Microsoft Data and Information Security |
| ISBN | 1-4842-6014-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Chapter 1: Introducing ASP.NET Core -- Chapter 2: General Security Concepts -- Chapter 3: Cryptography -- Chapter 4: Web Security Concepts -- Chapter 5: Understanding Common Attacks -- Chapter 6: Processing User Input -- Chapter 7: Authentication and Authorization -- Chapter 8: Data Access and Storage. - Chapter 9: Logging and Error Handling -- Chapter 10: Setup and Configuration -- Chapter 11: Secure Application Life Cycle Management. |
| Record Nr. | UNINA-9910427050303321 |
Norberg Scott
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced ASP.NET Core 8 Security : Move Beyond ASP.NET Documentation and Learn Real Security / / by Scott Norberg
| Advanced ASP.NET Core 8 Security : Move Beyond ASP.NET Documentation and Learn Real Security / / by Scott Norberg |
| Autore | Norberg Scott |
| Edizione | [2nd ed. 2024.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 |
| Descrizione fisica | 1 online resource (470 pages) |
| Disciplina | 005.268 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Data protection Microsoft Data and Information Security |
| ISBN | 979-88-6880-494-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Chapter 1: Intro to Security -- Chapter 2: Software Security Overview -- Chapter 3: Web Security -- Chapter 4: Thinking Like a Hacker -- Chapter 5: Introduction to ASP.NET Core Security -- Chapter 6: Cryptography -- Chapter 7: Processing User Input -- Chapter 8: Data Access and Storage -- Chapter 9: Authentication and Authorization -- Chapter 10: Advanced Web Security -- Chapter 11: Logging and Error Handling. Chapter 12: Setup and Configuration. - Chapter 13: Secure Software Development Life Cycle. (SSDLC). |
| Record Nr. | UNINA-9910896177903321 |
Norberg Scott
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced Excel Essentials / / by Jordan Goldmeier
| Advanced Excel Essentials / / by Jordan Goldmeier |
| Autore | Goldmeier Jordan |
| Edizione | [1st ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (203 p.) |
| Disciplina | 005.369 |
| Collana | The expert's voice in Excel |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Computers Application software Microsoft and .NET Information Systems and Communication Service Computer Applications |
| ISBN |
9781484207345
1484207343 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910300476503321 |
Goldmeier Jordan
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced Excel Formulas : Unleashing Brilliance with Excel Formulas / / by Alan Murray
| Advanced Excel Formulas : Unleashing Brilliance with Excel Formulas / / by Alan Murray |
| Autore | Murray Alan |
| Edizione | [1st ed. 2022.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2022 |
| Descrizione fisica | 1 online resource (834 pages) |
| Disciplina | 005.54 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Microsoft |
| ISBN |
9781484271254
1484271254 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Chapter 1: Excel Formulas: A Quick Primer -- Anatomy of an Excel Formula -- Breakdown of a Function -- Table of Formula Characters -- Order of Calculation -- Order of Range Operations -- Order of Mathematical Operations -- The Function Wizard -- Cell Referencing -- Absolute References -- Relative References Explained -- Making a Reference Absolute -- Mixed References -- Sheet References -- Workbook References -- Calculating Percentages -- Percentage of a Value -- Percentage of a Total -- Increase a Value by a Percentage -- Decrease a Value by a Percentage -- Calculate Percentage Change -- When Formulas Go Wrong -- Formula Errors -- Automatic Error Checking -- Excel Formula Is Not Calculating -- Formula Calculations Are Set to Manual -- Show Formulas Is Switched On -- Formula Is Stored As Text -- Cell Formatted As Text -- Summary -- Chapter 2: Logical Functions -- What Is TRUE and FALSE? -- The IF Function -- Example 1: Testing Numeric Values -- Example 2: Testing Text Values -- Example 3: Exact Text Match -- Example 4: Partial Text Match -- Example 5: Testing Date Values -- Example 6: Testing If a Cell Is Empty or Blank -- Example 7: Return a Symbol or Emoji -- Nested IF Functions -- IFS Function -- AND, OR, XOR, and NOT Functions -- AND Function -- OR Function -- XOR Function -- NOT Function -- The SWITCH Function -- Example 1: Match Against a List of Text Values -- Example 2: Evaluate to TRUE -- Example 3: Match a Formula Result to the List of Values -- Example 4: Pick Formula from a Drop-Down List -- Handling Errors -- IFERROR Function -- IFNA Function -- Logical Functions with Excel Features -- Format Values That Meet a Goal -- Conditional Formatting Rule with Multiple Conditions.
Data Validation Rule Based on Another Cell Value -- Conditional Formatting with Charts -- Dynamic Chart Data with SWITCH -- Summary -- Chapter 3: Defined Names -- Named Ranges -- Why Use Named Ranges? -- Define a Named Range with the Name Box -- Using Named Ranges in Formulas -- Rules for Defining Names -- Tips for Defining Names -- Named Ranges with Multiple Cells -- Named Range for a Drop-Down List -- Define a Dynamic Named Range -- Define Names with Create from Selection -- Scope of a Defined Name -- Define a Named Constant -- Finding Named Ranges -- Relative Named Ranges -- Named Formulas -- Managing Names -- Edit a Name -- Filtering Names -- Print a List of the Names -- Apply Names to Existing Formulas -- Summary -- Chapter 4: You Need to Start Using Tables -- Why Use Tables? -- Format a Range As a Table -- Creating a Table -- Changing or Removing Table Styles -- Naming the Table -- Working with Tables -- Table References in a Formula -- The Magic of @ -- Referencing Table Elements -- Make Table Column and Cell References Absolute -- Tables with Other Excel Features -- Dynamic Lists -- Dynamic Charts -- Summary -- Chapter 5: Manipulating Text -- Extract Characters from a Text String -- LEFT and RIGHT -- Extract Characters from the Middle of a String -- FIND and SEARCH for Irregular Strings -- Example 1: Extract Characters Before a Delimiter -- Example 2: Extract Characters After a Delimiter -- Example 3: Combining LEFT and RIGHT -- Example 4: Extract Text Between Two Characters -- Example 5: Extract Number from a Text String -- Change the Case of Text -- The LEN Function -- Convert Text to a VALUE -- The NUMBERVALUE Function -- Remove Unwanted Characters -- The TRIM Function -- The CLEAN Function -- SUBSTITUTE and REPLACE Functions -- The REPLACE Function -- The SUBSTITUTE Function -- Example 1: Simple SUBSTITUTE Example. Example 2: Count the Number of Words in a Cell -- Example 3: Use the Instance Number to Extract Text -- Example 4: Return Text After the Last Delimiter -- TEXTBEFORE and TEXTAFTER Functions -- Example 1: Text Before or After the First Delimiter -- Example 2: Specify an Instance Number -- Example 3: Extract Text Between Two Characters -- Example 4: Using Match End and If Not Found -- The TEXTSPLIT Function -- Example 1: Simple TEXTSPLIT -- Example 2: Using Multiple Column Delimiters -- Example 3: Splitting Across Rows (and Columns) -- Example 4: Handling Missing Data -- Combine Text into One Cell -- The CONCATENATE Function -- The Ampersand Character -- The CONCAT Function -- The TEXTJOIN Function -- TEXTJOIN and Delimiters -- TEXTJOIN and Empty Values -- TEXTJOIN and Arrays -- The TEXT Function -- Example 1: Currency Formats -- Example 2: Positive and Negative Value Formats -- Example 3: Date Formats -- Repeating a Character - REPT Function -- Text Functions with Other Excel Features -- Conditional Formatting Rules - Last Character Equals -- Data Validation Rules - Forcing Correct Case -- Dynamic Labels for Charts -- Summary -- Chapter 6: Working with Dates and Time -- Understanding Dates and Time -- Dates and the Calendar System in Excel -- Calculate the Difference Between Two Dates -- Time in Excel -- Calculate the Difference in Two Times -- The TODAY and NOW Functions -- Convert Text to Date -- The DATEVALUE Function -- The VALUE Function -- The DATE Function -- Extract Date from a Date-Time Stamp -- The INT Function -- The TRUNC Function -- Extract Time from a Date-Time Stamp -- The MOD Function -- The YEAR, MONTH, and DAY Functions -- The NETWORKDAYS Function -- Calculate the Working Days Difference Between Two Dates -- The NETWORKDAYS.INTL Function -- Example 1: Customized NETWORKDAYS.INTL Function -- Example 2: Conditional Holiday Ranges. Example 3: Number of Fridays Between Two Dates -- The YEARFRAC Function -- The DATEDIF Function -- The WORKDAY Function -- Calculate a Due Date from a Starting Date -- The WORKDAY.INTL Function -- Calculate First Working Day of a Month -- EDATE and EOMONTH -- Calculate Contract End Dates -- Last Day of a Month -- Number of Days in a Month -- Last Working Day of a Month -- First Working Day of Next Month -- Returning Week Numbers -- The WEEKNUM Function -- What Is ISOWEEKNUM? -- Return the Week Number for Any Given Date -- Week Number in a Month -- The WEEKDAY Function -- Rate of Pay Determined by Day of Week -- Calculating Financial Years and Quarters -- Fiscal Years -- Indian Financial Year -- Australian Financial Year -- UK Financial Year -- Fiscal Quarters -- Working with Time -- Convert Text to Time -- The TIMEVALUE Function -- The TIME Function -- Rounding Time -- MROUND, CEILING.MATH, and FLOOR.MATH -- Round Time to the Nearest Hour -- Round Time to the Nearest 15 Minutes -- Time Difference Past Midnight -- Sum Hours over 24 Hours -- Handling Negative Time -- Date and Time Functions with Other Excel Features -- Highlight Approaching Due Dates -- Highlight Dates Due Within the Next Month -- Data Validation Rules - Prevent Weekend Entries -- Summary -- Chapter 7: The Infamous VLOOKUP Function -- Introduction to VLOOKUP -- VLOOKUP for an Exact Match -- VLOOKUP for a Range Lookup -- Column Index Number Tricks -- Trick 1: The COLUMN Function -- Trick 2: The COLUMNS Function -- Trick 3: Using an Index Row -- Reasons Why VLOOKUP Is Not Working -- Lookup Column Must Be the First Column -- Data Type of the Values Must Match -- Exact Match Has Not Been Specified -- Ranges Must Be in Ascending Order -- Handling Fake Errors with VLOOKUP -- The HLOOKUP Function -- Get VLOOKUP to Look to the Left -- Partial Match Lookup -- Case-Sensitive VLOOKUP. Multiple Column VLOOKUP -- Return the Nth Match -- VLOOKUP with Other Excel Features -- Conditional Formatting and VLOOKUP -- Dynamic Chart Range -- Summary -- Chapter 8: The Awesome SUMIFS, COUNTIFS, and Friends -- The SUMIFS Function -- SUMIF or SUMIFS -- Using Text Criteria -- Working with Multiple Criteria -- Using Numeric Criteria -- Sum Values Between Two Dates -- OR Logic with SUMIFS -- Using Wildcards with SUMIFS -- The Versatile COUNTIFS Function -- Comparing Two Lists -- Generating Unique Rankings -- Creating Conditional Rankings -- Creating a Frequency Distribution -- The AVERAGEIFS Function -- TRIMMEAN Function -- Conditional MEDIAN and MODE Functions -- Calculating the Median -- Calculating the Mode -- MAXIFS and MINIFS Functions -- Using the Functions with Other Excel Features -- Identifying Duplicates with Conditional Formatting -- Identifying Unmatched Values Between Two Lists -- Highlight Values Larger Than the Median -- Preventing Duplicate Entries -- Summary -- Chapter 9: Next-Level Aggregation Functions -- SUMPRODUCT Function -- Classic SUMPRODUCT -- Sum Values That Meet Multiple Criteria -- Count Values That Meet Multiple Criteria -- Aggregating Multiple Columns -- Distinct Count Formula -- Weighted Average -- Sum Every Nth Cell -- Sum Values for a Specific Weekday -- Sum the Top Five Values Only -- AGGREGATE Function -- Ignoring Hidden Rows -- Ignoring Errors in a Range -- Adding Criteria to AGGREGATE -- Function Specified by a Cell Value -- Summary -- Chapter 10: Dynamic Array Formulas -- Getting to Know Dynamic Array Formulas -- Arrays vs. Dynamic Arrays -- Dynamic Arrays with Tables -- Dynamic Array Formula Example -- Welcome the # Operator -- The #SPILL! Error -- DA Formulas Cannot Be Used Within Tables -- UNIQUE Function -- Returning Distinct and Unique Values -- UNIQUE with Multiple Columns -- UNIQUE to Compare Columns. Distinct Labels for SUMIFS. |
| Record Nr. | UNINA-9910590054103321 |
Murray Alan
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2022 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced interactive interfaces with Access : Building Interactive Interfaces with VBA / / by Alessandro Grimaldi
| Advanced interactive interfaces with Access : Building Interactive Interfaces with VBA / / by Alessandro Grimaldi |
| Autore | Grimaldi Alessandro |
| Edizione | [1st ed. 2024.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 |
| Descrizione fisica | 1 online resource (287 pages) |
| Disciplina | 005.268 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Microsoft |
| ISBN | 979-88-6880-808-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction -- Chapter 1 - Writing code: good practices and tips -- Chapter 2 - VBA classes -- Chapter 3 - The presence vector technique -- Chapter 4 - Advanced interfaces: Drag and Drop -- Chapter 5 - Advanced interfaces: Scrollable timeline -- Conclusion. |
| Record Nr. | UNINA-9910890193003321 |
Grimaldi Alessandro
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Agile Machine Learning : Effective Machine Learning Inspired by the Agile Manifesto / / by Eric Carter, Matthew Hurst
| Agile Machine Learning : Effective Machine Learning Inspired by the Agile Manifesto / / by Eric Carter, Matthew Hurst |
| Autore | Carter Eric |
| Edizione | [1st ed. 2019.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 |
| Descrizione fisica | 1 online resource (257 pages) : illustrations |
| Disciplina | 004.165 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Software engineering Big data Microsoft and .NET Software Engineering Big Data |
| ISBN |
9781484251072
1484251075 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Chapter 1: Early Delivery -- Chapter 2: Changing Requirements -- Chapter 3: Continuous Delivery -- Chapter 4: Aligning with the Business -- Chapter 5: Motivated Individuals -- Chapter 6: Effective Communication -- Chapter 7: Monitoring -- Chapter 8: Sustainable Development -- Chapter 9: Technical Excellence -- Chapter 10 Simplicity -- Chapter 11: Self-organizing Teams -- Chapter 12: Tuning and Adjusting -- Chapter 13: Conclusion. |
| Record Nr. | UNINA-9910338230703321 |
Carter Eric
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Agile Office 365 : Successful Project Delivery Practices for an Evolving Platform / / by Haniel Croitoru
| Agile Office 365 : Successful Project Delivery Practices for an Evolving Platform / / by Haniel Croitoru |
| Autore | Croitoru Haniel |
| Edizione | [1st ed. 2018.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2018 |
| Descrizione fisica | 1 online resource (278 pages) |
| Disciplina | 650.02855369 |
| Soggetto topico |
Application software
Project management Microsoft software Microsoft .NET Framework Computer Applications Project Management Microsoft and .NET |
| ISBN |
9781484240816
1484240812 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Part I. Overview -- 1. Introduction to Office 365 -- 2. Agile Project Management -- 3. Office 365 Project Overview -- Part II. Project Conception -- 4. Business Outcomes -- 5. Governance -- 6. Legal Considerations -- 7. Building a Winning Team -- Part III. Execution -- 8. Designing the Solution -- 9. Developing & Testing Solutions -- Part IV. Deployment -- 10. Training -- 11. Release Planning -- 12. Transition to Operations -- Part V. Overarching Activities -- 13. Content Migration -- 14. Change Management & Adoption -- 15. Communication -- Part VI. Tools for Managing Office 365 Projects -- 16. Information Requirements -- 17. Office 365 as a PMIS. |
| Altri titoli varianti | Agile Office three hundred and sixty-five |
| Record Nr. | UNINA-9910300751603321 |
Croitoru Haniel
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2018 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Agile Project Management using Team Foundation Server 2015 [[electronic resource] /] / by Joachim Rossberg
| Agile Project Management using Team Foundation Server 2015 [[electronic resource] /] / by Joachim Rossberg |
| Autore | Rossberg Joachim |
| Edizione | [1st ed. 2016.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 |
| Descrizione fisica | 1 online resource (204 p.) |
| Disciplina | 004 |
| Collana | Expert's Voice in .NET |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Software engineering Microsoft and .NET Software Engineering/Programming and Operating Systems |
| ISBN | 1-4842-1870-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1: Introduction to Application Lifecycle Management.-2: Introduction to TFS -- 3: Introduction to Scrum and Agile Concepts -- 4: TFS Work Item Tracking and Process Templates -- 5: Customizing the Process Templates in TFS -- 6: Agile Practices in TFS -- 7: Agile Metrics in TFS -- 8: Agile Project Management in TFS. |
| Record Nr. | UNINA-9910254752203321 |
Rossberg Joachim
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Agile Project Management with Azure DevOps : Concepts, Templates, and Metrics / / by Joachim Rossberg
| Agile Project Management with Azure DevOps : Concepts, Templates, and Metrics / / by Joachim Rossberg |
| Autore | Rossberg Joachim |
| Edizione | [1st ed. 2019.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 |
| Descrizione fisica | 1 online resource (325 pages) |
| Disciplina | 005.1 |
| Soggetto topico |
Microsoft software
Microsoft .NET Framework Software engineering Project management Microsoft Software Engineering Project Management |
| ISBN |
9781484244838
1484244834 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Chapter 1: Introduction to Application Lifecycle Management -- Chapter 2: An Overview of Azure DevOps -- Chapter 3: Introduction to Scrum and Agile Concepts -- Chapter 4: Work Items and Process Templates -- Chapter 5: Customizing the Process Template in Azure DevOps -- Chapter 6: Agile Practices in Azure DevOps and TFS -- Chapter 7: Metrics in Agile Projects -- Chapter 8: Agile Project Management in Azure DevOps and TFS. |
| Record Nr. | UNINA-9910338009103321 |
Rossberg Joachim
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||